Return-Path: Delivered-To: apmail-cayenne-commits-archive@www.apache.org Received: (qmail 91915 invoked from network); 24 Jan 2010 12:48:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 24 Jan 2010 12:48:41 -0000 Received: (qmail 15678 invoked by uid 500); 24 Jan 2010 12:48:41 -0000 Delivered-To: apmail-cayenne-commits-archive@cayenne.apache.org Received: (qmail 15648 invoked by uid 500); 24 Jan 2010 12:48:40 -0000 Mailing-List: contact commits-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cayenne.apache.org Delivered-To: mailing list commits@cayenne.apache.org Received: (qmail 15639 invoked by uid 99); 24 Jan 2010 12:48:40 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 24 Jan 2010 12:48:40 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 24 Jan 2010 12:48:38 +0000 Received: from brutus.apache.org (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id E875B234C4AC for ; Sun, 24 Jan 2010 04:48:17 -0800 (PST) Message-ID: <1315442352.10351264337297950.JavaMail.jira@brutus.apache.org> Date: Sun, 24 Jan 2010 12:48:17 +0000 (UTC) From: "Andrey Razumovsky (JIRA)" To: commits@cayenne.apache.org Subject: [jira] Closed: (CAY-1371) EJBQL query doesn't preserve grouping by brackets In-Reply-To: <1436551259.395061264082574600.JavaMail.jira@brutus.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/CAY-1371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrey Razumovsky closed CAY-1371. ---------------------------------- Resolution: Fixed Fix Version/s: 3.0RC2 Assignee: Andrey Razumovsky > EJBQL query doesn't preserve grouping by brackets > ------------------------------------------------- > > Key: CAY-1371 > URL: https://issues.apache.org/jira/browse/CAY-1371 > Project: Cayenne > Issue Type: Bug > Components: Core Library > Affects Versions: 3.0RC2 > Reporter: Andreas Hartmann > Assignee: Andrey Razumovsky > Fix For: 3.0RC2 > > Attachments: 1371.txt, CAY-1371.patch > > > EJBQL statement: > SELECT object(t) FROM User t WHERE (t.language.code = 'fr') AND ((upper(t.email) LIKE '%ANDREAS.HARTMANN@GMAIL.COM%') OR (upper(t.email) LIKE '%NOBBY@MACBAY.DE%')) > Resulting query: > SELECT COUNT(*) AS sc0 FROM public.user t0 INNER JOIN public.language t1 ON (t0.language = t1.code) WHERE t1.code = ? AND {fn UCASE( t0.email)} LIKE ? OR {fn UCASE( t0.email)} LIKE ? > In the resulting query, the brackets surrounding the OR clause are lost. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.