svn commit: r921550 - /openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/query/TestJDBCEscapeDate.java

[jr...@apache.org]

Author: jrbauer
Date: Wed Mar 10 20:22:57 2010
New Revision: 921550

URL: http://svn.apache.org/viewvc?rev=921550&view=rev
Log:
OPENJPA-1560 Committing JDBC escape sequence tests contributed by Dianne Richards.

Modified:
    openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/query/TestJDBCEscapeDate.java

Modified: openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/query/TestJDBCEscapeDate.java
URL: http://svn.apache.org/viewvc/openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/query/TestJDBCEscapeDate.java?rev=921550&r1=921549&r2=921550&view=diff
==============================================================================
--- openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/query/TestJDBCEscapeDate.java (original)
+++ openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/query/TestJDBCEscapeDate.java Wed Mar 10 20:22:57 2010
@@ -73,7 +73,19 @@ public class TestJDBCEscapeDate extends 
             List results = q.getResultList();
             Assert.assertEquals(1, results.size());
         }
+        
+        // Test support in HAVING clause.
+        String[] havingJpql = {
+            "select a from Employee a group by a.hireTime having a.hireTime >= {t '00:00:00'}",
+            "select a from Employee a group by a.hireDate having a.hireDate >= {d '2009-08-25'}",
+            "select a from Employee a group by a.hireTimestamp having a.hireTimestamp >= {d '2009-08-25'}"
+        };
 
+        for (int j = 0; j < havingJpql.length; j++) {
+            Query q = em.createQuery(havingJpql[j]);
+            List results = q.getResultList();
+            Assert.assertEquals(1, results.size());
+        }
         em.getTransaction().begin();
         String update = "update Employee a set a.hireTimestamp = {ts '2009-08-25 00:00:00.123456'} where a.empId = 1";
         Query q = em.createQuery(update);