[jira] Closed: (CAY-1371) EJBQL query doesn't preserve grouping by brackets

["Andrey Razumovsky (JIRA)" <ji...@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.