Attached is a patch which fixes a bug in parenthesized grouping of 
terms in the WHERE clause of CALL SQL SELECT.

Regards,

Glenn

----------------------------------------------------------------------
Glenn Nielsen             [EMAIL PROTECTED] | /* Spelin donut madder    |
MOREnet System Programming               |  * if iz ina coment.      |
Missouri Research and Education Network  |  */                       |
----------------------------------------------------------------------
Index: src/main/org/exolab/castor/jdo/engine/OQLQueryImpl.java
===================================================================
RCS file: /cvs/castor/castor/src/main/org/exolab/castor/jdo/engine/OQLQueryImpl.java,v
retrieving revision 1.67
diff -u -r1.67 OQLQueryImpl.java
--- src/main/org/exolab/castor/jdo/engine/OQLQueryImpl.java     11 Dec 2001 09:38:49 
-0000      1.67
+++ src/main/org/exolab/castor/jdo/engine/OQLQueryImpl.java     9 Feb 2002 22:14:48 
+-0000
@@ -332,7 +332,7 @@
         sql = new StringBuffer();
         paramCnt = 0;
         _paramInfo = new Hashtable();
-        if ( leftParen < 0 && rightParen < 0 ) {
+        if ( oql.startsWith("CALL SQL") || (leftParen < 0 && rightParen < 0) ) {
             sql.append( oql.substring( 5, as ) );
         } else {
             if ( ( leftParen < 0 && rightParen >= 0 )

Reply via email to