[CAY-1371] EJBQL query doesn't preserve grouping by brackets

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0RC2
• Fix Version/s: 3.0RC2
• Component/s: Core Library
• Assignee: Andrey Razumovsky
• Reporter: Andreas Hartmann
• Created: 21/Jan/10 14:02
• Updated: 24/Jan/10 12:47
• Resolved: 24/Jan/10 12:47

Description

EJBQL statement:

SELECT object(t) FROM User t WHERE (t.language.code = 'fr') AND ((upper(t.email) LIKE '[e-mail]%') OR (upper(t.email) LIKE '[e-mail]%'))

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.