[CAY-2871] QualifierTranslator breaks on a relationship with a compound FK

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 4.2, 4.2.1
• Fix Version/s: 4.2.2, 5.0-M2
• Assignee: Nikita Timofeev
• Reporter: Nikita Timofeev
• Created: 03/Sep/24 13:51
• Updated: 31/Oct/24 14:03
• Resolved: 31/Oct/24 14:03

Description

Expression like this:

Expression exp = CompoundFkTestEntity.TO_COMPOUND_PK.eq(objectId1)
                .or(CompoundFkTestEntity.TO_COMPOUND_PK.eq(objectId2)

Completely breaks QualifierTranslator and produces incorrect SQL like this:
( ( t0.F_KEY1 = 'PK1' ) AND ( t0.F_KEY2 = 'PK2' ) ) OR ( 'PK4' 'PK3' )

Note that the first equality translates completely fine, it's the second (and further) that breaks everything.