Missing from clause in query from BinaryLogicOperatorNode row value constructor translation

Description

The row value constructor translation that happens in BinaryLogicOperatorNode may introduce referenced tables in the SqlFragment nodes. As these nodes are then substituted for their original DotNodes, the referenced table information is lost. As a result, the table join may be falsely omitted.

The reproducer is as follows:

While this specific regression was only introduced in 5.4.10 with HHH-12895, I have all reason to believe that the same issue exists on a Joined Inheritance hierarchy, for which table join omission was implemented with HHH-19883 in 5.4.5.

Environment

None

Assignee

Jan-Willem Gmelig Meyling

Reporter

Jan-Willem Gmelig Meyling

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

backportDecision

None

Worked in

5.4.4

Affects versions

Priority

Major
Configure