JPQL to PostgresSQL not translated correctly
Activity

Former user March 18, 2016 at 1:46 AM
I agree the different parentheses is confusing, but I also agree that the generated SQL is equivalence due to AND having precedence.over OR.
Steve Ebersole October 28, 2015 at 3:24 AM
As part of verifying that this issue affects 5.0, please just set the "Affects version". Leave the "verify-affects-5.0" label and leave the issue in "Awaiting Response" status; these are critical for us to be able to track these verifications and triage them. Thanks.
Steve Ebersole October 27, 2015 at 7:16 PM
This bug report does not indicate that the reported issue affects version 5.x. Versions prior to 5.x are no longer maintained. It would be a great help to the Hibernate team and community for someone to verify that the reported issue still affects version 5.x. If so, please add the 5.x version that you verified with to the list of affected-versions and attach the (preferably SSCCE) test case you used to do the verification to the report; from there the issues will be looked at during our triage meetings.
For details, see http://in.relation.to/2015/10/27/great-jira-cleanup-2015/

Christian Beikov August 27, 2014 at 6:49 PM
The generated SQL query seems correct. I guess the parenthesis are confusing you, but if you think about the precedence of the AND predicate, the generated where predicate is semantically equivalent to the one of the HQL.

Hugh January 22, 2014 at 12:27 PM
This might help too
Details
Details
Assignee

Reporter

The OR part of a complex JPQL query is not translated correctly.
Please see forum topic https://forum.hibernate.org/viewtopic.php?f=1&t=1030515