cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Lewis (JIRA)" <j...@apache.org>
Subject [jira] Created: (CAY-1247) Query SQL syntax with join and OR on Oracle8 (and maybe OpenBase)
Date Mon, 29 Jun 2009 15:12:47 GMT
Query SQL syntax with join and OR on Oracle8 (and maybe OpenBase)
-----------------------------------------------------------------

                 Key: CAY-1247
                 URL: https://issues.apache.org/jira/browse/CAY-1247
             Project: Cayenne
          Issue Type: Bug
          Components: Cayenne Core Library
    Affects Versions: 3.0M6
         Environment: Oracle 8
            Reporter: Bryan Lewis
            Priority: Minor


See the thread at http://news.gmane.org/gmane.comp.java.cayenne.user/11127.
The Oracle8 adapter produces legacy syntax for joins.  We found that queries that involve
both a join and an orExp produce SQL with insufficient parentheses.  It appears that Oracle
applies the OR to the join clause and fetches the entire table.  Cayenne2 supplied an extra
pair of parentheses to avoid this.  I've fixed the code for our purposes (will append in a
moment).

Perhaps this will be an issue on OpenBase too, since they use the same legacy join code. 
Or maybe Openbase will handle the ungrouped AND's and OR's more intelligently.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message