You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Bryan Lewis (JIRA)" <ji...@apache.org> on 2009/11/25 20:17:39 UTC

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

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

Bryan Lewis updated CAY-1247:
-----------------------------

    Priority: Major  (was: Minor)

I boosted the Priority from Minor to Major, hope you don't mind.  This is the only remaining bug that prevents us from using the standard cayenne jar on Oracle8.  If you don't get to it, that's okay... I can fix it locally if we're the last Oracle8 users in the world.

> 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
>
> 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.