[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2647) Problems with OR parenthesis in HQL

[Nicolas De Cubber (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28026 ] 

Nicolas De Cubber commented on HHH-2647:
----------------------------------------

I was still looking at that problem, and finally, i found it was not a problem.
If you look at the SQL condition Precedence, you will see that the 'AND' is always executed before the 'OR', so the query
((1 AND 2) OR (3 AND 4) OR (5 AND 6))
 is equivalent to the query
(1 AND 2 OR 3 AND 4 OR 5 AND 6)

It is like in Mathematics where the multiplication has priority over the addition.

So, this bug (which is not a bug) can be close because it was a misunderstood of the sql language.

see SQL condition Precedence here : http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10759/conditions001.htm#i1034741

> Problems with OR parenthesis in HQL
> -----------------------------------
>
>                 Key: HHH-2647
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2647
>             Project: Hibernate3
>          Issue Type: Bug
>          Components: query-hql
>    Affects Versions: 3.2.1
>         Environment: Hibernate 3.2.1, postgresql 8.2, jboss 5 embedded beta 2
>            Reporter: Dennis Fleurbaaij
>   Original Estimate: 15 minutes
>  Remaining Estimate: 15 minutes
>
> Given the following (part) of a query in HQL (where 1 to 6 are comparisons of different types (=, <=, is null), but irrelevant for the problem posted here ):
> AND ( ( 1 AND 2 ) OR ( 3 AND 4 )  OR ( 5 AND 6 ) )
> will be balanced to:
> and ( ( 1 ) and 2 or 3 and ( 4 ) or 5 and 6 )

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira