You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-commits@db.apache.org by cl...@apache.org on 2007/09/19 19:51:43 UTC
svn commit: r577401 -
/db/jdo/trunk/tck2/src/java/org/apache/jdo/tck/query/api/ChangeQuery.java
Author: clr
Date: Wed Sep 19 10:51:41 2007
New Revision: 577401
URL: http://svn.apache.org/viewvc?rev=577401&view=rev
Log:
JDO-529 Add DISTINCT to query in ChangeQuery
Modified:
db/jdo/trunk/tck2/src/java/org/apache/jdo/tck/query/api/ChangeQuery.java
Modified: db/jdo/trunk/tck2/src/java/org/apache/jdo/tck/query/api/ChangeQuery.java
URL: http://svn.apache.org/viewvc/db/jdo/trunk/tck2/src/java/org/apache/jdo/tck/query/api/ChangeQuery.java?rev=577401&r1=577400&r2=577401&view=diff
==============================================================================
--- db/jdo/trunk/tck2/src/java/org/apache/jdo/tck/query/api/ChangeQuery.java (original)
+++ db/jdo/trunk/tck2/src/java/org/apache/jdo/tck/query/api/ChangeQuery.java Wed Sep 19 10:51:41 2007
@@ -62,7 +62,7 @@
Query query = getPM().newNamedQuery(Person.class, "changeQuery");
// change query
- query.setResult("firstname, lastname");
+ query.setResult("DISTINCT firstname, lastname");
query.setResultClass(FullName.class);
query.setClass(FullTimeEmployee.class);
String filter = "salary > 1000 & projects.contains(p) & " +
@@ -73,14 +73,15 @@
query.declareImports(imports);
query.declareVariables("Project p");
query.declareParameters("BigDecimal limit");
- query.setOrdering("personid ASCENDING");
+ query.setOrdering("firstname, lastname ASCENDING");
query.setRange(0, 5);
String singleStringQuery =
- "SELECT firstname, lastname INTO FullName FROM FullTimeEmployee " +
+ "SELECT DISTINCT firstname, lastname " +
+ "INTO FullName FROM FullTimeEmployee " +
"WHERE salary > 1000 & projects.contains(p) & " +
"p.budget > limit " +
"VARIABLES Project p PARAMETERS BigDecimal limit " +
- "ORDER BY personid ASCENDING RANGE 0, 5";
+ "ORDER BY firstname, lastname ASCENDING RANGE 0, 5";
// query parameters
Object[] parameters = {new BigDecimal("2000")};