[EMPIREDB-418] Oracle DBMS Handler fix for Boolean type CHAR and MERGE into

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Component/s: Core
• Assignee: Unassigned
• Reporter: Rainer Döbele
• Created: 23/Mar/24 12:27
• Updated: 16/Jun/24 08:01
• Resolved: 16/Jun/24 08:01

Description

If the Oracle DBMS Handler is configured to use Boolean type CHAR then when also using prepared statement, Statement parameters have to be replaced by yes and no char.

Second the method addUpdateWithJoins that produces a MERGE INTO statement does not separate multi key contraints correctly.