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

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2647?page=c... ] 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/conditi... -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira