Entity joins are not polymorphic

Description

When doing an entity join on an entity type that involves multiple tables, currently the joins for the subclasses are missing in the SQL leading to a syntax error when e.g. using a sub- or super-type property with joined inheritance strategy.

Take the following model

and the following query

The column for the property price is rendered in the ON clause into SQL, but the table join for the super type table item is missing.

Environment

None

Activity

Show:
Steve Ebersole
February 8, 2017, 3:16 PM

is this something you want backported to 5.x? I will set the new fields we discussed, just wanted to bring this one to your attention specifically.

Steve Ebersole
February 8, 2017, 3:17 PM

I left the fixVersion as containing 5.2, but really that is Gail's call.

Chris Cranford
February 9, 2017, 5:58 PM

We really should consider this as part of 5.2.8 as it addresses a bug with the traversal API that was introduced for Envers in HHH-10762.

Assignee

Christian Beikov

Reporter

Christian Beikov

Fix versions

Labels

None

backPortable

Backport?

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure