[CAY-2389] DbEntity qualifier with DbPath expression translates into wrong SQL

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.1.1, 4.0.B2, 4.1.M1
• Fix Version/s: 3.1.3, 4.0.RC1, 4.1.M2
• Assignee: Nikita Timofeev
• Reporter: Nikita Timofeev
• Created: 13/Dec/17 14:09
• Updated: 24/Jul/18 08:56
• Resolved: 18/Dec/17 14:26

Description

When qualifier with DbPath expression attached to DbEntity (e.g. programmatically set ExpressionFactory.matchDbExpression() qualifier) used in JOIN clause, it generates wrong SQL.

For example: JOIN GROUP t2 ON (t1.GROUPID = t2.GROUPID AND t0.DELETED = 0)
Note t0 alias used with DELETED field, t2 should be used instead.

Everything works fine if ObjPath used in qualifier.