Issues

Select view

List view

Detail view

Select search mode

Basic

JQL

Hibernate criteria with multiple joins does not handle the order of query parameters (join on) correcly
HHH-9891
Resolved issue: HHH-9891
Validity audit strategy: end revision timestamp is not stored in tables for joined subclasses
HHH-9062
Resolved issue: HHH-9062
Correct ObjectNameNormalizer for mssql-style quoting
HHH-9057
Resolved issue: HHH-9057
OneToOneTest.testPkOneToOneSelectStatementDoesNotGenerateExtraJoin fails on oracle and postresql databases
HHH-9056
Resolved issue: HHH-9056
org.hibernate.test.annotations.quote.QuoteTest violates unique key constraint on some DBs
HHH-9054
Resolved issue: HHH-9054
Discriminator / WrongClassException
HHH-9053
Resolved issue: HHH-9053
Unsupported SQL generated when constructors are used with predicates as arguments
HHH-9052
Resolved issue: HHH-9052
Globally quoted identifiers and id class not working properly with quoted join columns error Unable to find logical column name from physical name JobPositon+id in table JOB+Position
HHH-9035
org.hibernate.test.hql.ASTParserLoadingTest fails with postgresplus92
HHH-9034
Resolved issue: HHH-9034
Nullability.checkNullability fails for allowed embedded null object
HHH-9020
Resolved issue: HHH-9020
HHH-8814 breaks pooled sequences
HHH-9017
Resolved issue: HHH-9017
PluralAttributePath.getModel() must not return null
HHH-9016
@OrderColumn not updated in second level cache
HHH-9014
Resolved issue: HHH-9014

13 of 13

Hibernate criteria with multiple joins does not handle the order of query parameters (join on) correcly

Duplicate

Description

Here is a simple example:

Here is the generated SQL:

And query parameters are:

Parameters "B" and "C" switched they order, which is incorrect.

If I change the order of joins in the criteria everything works fine:

The generated query is:

And query parameters are:

Similar issues were reproduced with left outer joins.

Linked issues

duplicates

HHH-5645

Criteria.createAlias with specified criterion results in wrong parameters passed into SQL statement

Details

Assignee

Former user(Deactivated)

Reporter

Kryvda

Labels

Affects versions

4.2.10

5.0.6

Priority

Major

Created July 3, 2015 at 10:31 AM

Updated January 19, 2018 at 5:46 AM

Resolved January 19, 2018 at 5:46 AM

Configure

Activity

Show:

Kryvda January 12, 2018 at 8:16 PM

This bug is a duplicate of HHH-5645

Kryvda December 21, 2015 at 11:38 PM

The bug still exists in 5.0.6.

Steve Ebersole October 28, 2015 at 3:25 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:14 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/

Kryvda July 3, 2015 at 10:53 AM

Here are Hibernate entities: