svn commit: r742181 - /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/order/TestOrderColumn.java

[fancy]

Author: fancy
Date: Sun Feb  8 22:01:47 2009
New Revision: 742181

URL: http://svn.apache.org/viewvc?rev=742181&view=rev
Log:
OPENJPA-802 JPQ2 fix TestOrderColumn, enforce ordered results

Modified:
    
openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/order/TestOrderColumn.java

Modified: 
openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/order/TestOrderColumn.java
URL: 
http://svn.apache.org/viewvc/openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/order/TestOrderColumn.java?rev=742181&r1=742180&r2=742181&view=diff
==============================================================================
--- 
openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/order/TestOrderColumn.java
 (original)
+++ 
openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/jdbc/order/TestOrderColumn.java
 Sun Feb  8 22:01:47 2009
@@ -858,7 +858,9 @@
             String entity, String indexedCol, int base, Object[] objs, String
             idField, Object idValue) {
         String queryString = "SELECT INDEX(b), b FROM " + entity + " a JOIN 
a." +
-            indexedCol + " b WHERE a." + idField + " = :idVal";
+            indexedCol + " b WHERE a." + idField + " = :idVal " +
+            " ORDER BY a." + idField;
+        em.clear();
         Query qry = em.createQuery(queryString);
         qry.setParameter("idVal", idValue);
         List rlist = qry.getResultList();