From: Jeremy B. <jb...@us...> - 2003-01-07 23:45:17
|
User: jboynes Date: 03/01/07 15:45:17 Modified: src/main/org/jboss/test/cmp2/commerce Tag: Branch_3_2 QueryTest.java Log: Fix for bug 638488: OR with IS NOT EMPTY For platforms that support sub-queries, always use them For platforms that don't (MySQL), use DISTINCT with OUTER JOIN Quirks still remain for the latter case, but that's why SQL needs sub-queries Revision Changes Path No revision No revision 1.2.2.1 +7 -0 jbosstest/src/main/org/jboss/test/cmp2/commerce/QueryTest.java Index: QueryTest.java =================================================================== RCS file: /cvsroot/jboss/jbosstest/src/main/org/jboss/test/cmp2/commerce/QueryTest.java,v retrieving revision 1.2 retrieving revision 1.2.2.1 diff -u -r1.2 -r1.2.2.1 --- QueryTest.java 4 Jul 2002 17:25:28 -0000 1.2 +++ QueryTest.java 7 Jan 2003 23:45:17 -0000 1.2.2.1 @@ -74,5 +74,12 @@ "FROM OrderX o " + "WHERE o.creditCard <> ?1", new Object[] { new Card() }); + + oh.getStuff( + "SELECT OBJECT(o) " + + "FROM OrderX o " + + "WHERE o.ordernumber = ?1 OR o.lineItems IS NOT EMPTY", + new Object[] { new Long(1) }); + } } |