[jira] Closed: (CAY-1247) Query SQL syntax with join and OR on Oracle8 (and maybe OpenBase)

["Andrus Adamchik (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CAY-1247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik closed CAY-1247.
--------------------------------

    Resolution: Fixed

> 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
>            Assignee: Andrus Adamchik
>             Fix For: 3.0 beta 2, 3.1
>
>
> 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.