Actual Behavior

Expected Behavior

Steps to Reproduce the Problem

merge INTO M_KC21 USING
(SELECT AAA, BBB FROM I_KC21 WHERE I_KC21.aaa = 'li_kun'
) TEMP ON (TEMP.AAA = M_KC21.AAA)
WHEN MATCHED THEN
UPDATE SET M_KC21.BBB = 6 ### WHERE enterprise_id IN (0, 1)
WHEN NOT MATCHED THEN
INSERT VALUES
(TEMP.AAA,TEMP.BBB
)

Do not support WHERE clauses in a MERGE UPDATE

Specifications

• Version:
• Platform:
• Subsystem: