Join for joined table over mapping doesn't generate join sql

Description

The test case attached.
We have faced with the problem on more complex selects, but the test case contains the simplest one.

So select like:

produces the following SQL:

For main entity it generates a proper join* subs3_* but for joined testentity1_ the join was not generated but appropriate records into select are added:

As a result it fails with:

The subs are mapped over @OneToMany annotation.

Environment

None

Activity

Show:
Christian Beikov
February 1, 2017, 10:29 AM

Can you try 5.2.6? I have fixed something similar for and I think your issue should be resolved now.

Chris Cranford
February 3, 2017, 1:02 AM
Edited

Just tested against master and 5.2.6, the proper SQL is generated:

Assignee

Unassigned

Reporter

Nikita Metzger

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure