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.
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.
I left the fixVersion as containing 5.2, but really that is Gail's call.
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.