JSqlParser
JSqlParser copied to clipboard
Insert ON CONFLICT parsed failed when composite primary multi columns
Ref: #1630
Failed when composite primary keys (id_1+id_2) --> "ON CONFLICT (id_1, id_2)"
INSERT into test_data (id_1, id_2, my_string_1, my_string_2)
VALUES ('id_1_A', 'id_2_A', 'my_string_1-new', 'my_string_2-new')
ON CONFLICT (id_1, id_2) DO UPDATE
SET my_string_1 = 'my_string_1-update', my_string_2 = 'my_string_2-update';
Screenshot:

DB tools validation successfully:
(1) Left is schema, right is sample data:

(2) Executed successfully:

(3) Update sample data:

Thats right. This is not yet supported. JsqlParser only supports on conflict without an id list.
Duplicate #955
Please can someone have a look at the PostgreSQL Documentation and explain to me, where exactly it allows multiple columns?!