-
Bug
-
Resolution: Done
-
Critical
-
fuse-7.9-GA
-
False
-
False
-
%
-
+
-
Automated
-
Undefined
-
After update SQL parser, this query doesn't work
INSERT INTO todo(id, completed, task) VALUES (:#id, :#completed, :#task) ON CONFLICT (id) DO UPDATE SET completed=:#completed, task=:#task
Parser error:
net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "CONFLICT" <S_IDENTIFIER> at line 1, column 77. Was expecting: "DUPLICATE" . Unable to fetch and process metadata
The query was working before ( on Fuse Online 7.8 or upstream version 1.12.0-20210427)
When I update the query to
INSERT INTO todo(id, completed, task) VALUES (:#id, :#completed, :#task) ON DUPLICATE KEY UPDATE completed=:#completed, task=:#task
the query is valid but the integration doesn't work.
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "DUPLICATE"
It looks that the first (old) query is working with PostgreSql and the second (new) query is working with MySql.
Is there any unique solution for that query which is not DB vendor-specific? (which can be used with the new SQL parser and PostgreSql demoData sampledb)
- links to
