Mailing-List: contact commits-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cayenne.apache.org
Message-ID: <1995200123.1246288367187.JavaMail.jira@brutus>
Date: Mon, 29 Jun 2009 08:12:47 -0700 (PDT)
From: "Bryan Lewis (JIRA)" <jira@apache.org>
To: commits@cayenne.apache.org
Subject: [jira] Created: (CAY-1247) Query SQL syntax with join and OR on
 Oracle8 (and maybe OpenBase)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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.