/******************************************************************************* | |
* Copyright (c) 1998, 2013 Oracle and/or its affiliates. All rights reserved. | |
* This program and the accompanying materials are made available under the | |
* terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0 | |
* which accompanies this distribution. | |
* The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html | |
* and the Eclipse Distribution License is available at | |
* http://www.eclipse.org/org/documents/edl-v10.php. | |
* | |
* Contributors: | |
* tware - test for https://bugs.eclipse.org/bugs/show_bug.cgi?id=260986 | |
******************************************************************************/ | |
package org.eclipse.persistence.testing.tests.queries; | |
import java.util.Iterator; | |
import java.util.List; | |
import org.eclipse.persistence.queries.ReadAllQuery; | |
import org.eclipse.persistence.testing.framework.AutoVerifyTestCase; | |
import org.eclipse.persistence.testing.framework.TestErrorException; | |
import org.eclipse.persistence.testing.models.employee.domain.Employee; | |
// test for bug 260986 | |
@SuppressWarnings("deprecation") | |
public class PartialAttributeDistinctOrderByTest extends AutoVerifyTestCase{ | |
protected Exception exception = null; | |
protected List results = null; | |
public void test(){ | |
try{ | |
ReadAllQuery query = new ReadAllQuery(Employee.class); | |
query.dontMaintainCache(); | |
query.useDistinct(); | |
query.addPartialAttribute("firstName"); | |
query.addPartialAttribute("address"); | |
query.addOrdering(query.getExpressionBuilder().get("firstName")); | |
results = (List)getSession().executeQuery(query); | |
} catch (Exception exception){ | |
this.exception = exception; | |
} | |
} | |
public void verify(){ | |
if (exception != null){ | |
throw new TestErrorException("Partial Attribute query with joining failed with exception. " + exception.toString()); | |
} | |
if (results.size() != 12){ | |
throw new TestErrorException("Incorrect number of Employees returned."); | |
} | |
Iterator i = results.iterator(); | |
String previousValue = "AAAAA"; | |
while (i.hasNext()){ | |
Employee e = (Employee)i.next(); | |
if (e.getFirstName().compareTo(previousValue) < 0){ | |
throw new TestErrorException("Order is incorrect between: " + e.getFirstName() + " and: " + previousValue + "."); | |
} | |
previousValue = e.getFirstName(); | |
} | |
} | |
} |