postgres sql parsing "conflict " error #1551

Activity

1. mrtang123 commented on Jun 2, 2022

   

   mrtang123

   on Jun 2, 2022

   Author

   More actions

   sql: insert into (xxx) values (xxx) on conflict(xxx) do update xxx ...
   jsqlparser version is 4.3
2. manticore-projects

   added a commit that references this issue on Jun 3, 2022

   Support Postgres INSERT ... ON CONFLICT

   ...

   This issue will close once commit 92c8937 is merged into the 'master' branch.

   92c8937
3. wumpz

   closed this as completedin #1552on Jul 19, 2022
4. wumpz

   added a commit that references this issue on Jul 19, 2022

   PostgreSQL INSERT ... ON CONFLICT Issue #1551 (#1552)

   ...

   5ae09ad
5. ashishkrgupta commented on Feb 13, 2023

   

   ashishkrgupta

   on Feb 13, 2023

   More actions

   This fix is not working if we have 2 columns in on conflict clause.
   Ex:
   insert into table ( col1, col2, updationtime, username, lastname ) values ( ?, ?, ?, ?, ? ) ON CONFLICT ( col1, col2 ) DO UPDATE SET username=EXCLUDED.username RETURNING id

   It throws below error:
   `could not parse query 'insert into userinfo ( col1, col2, updationtime, username, lastname ) values ( ?, ?, ?, ?, ? ) ON CONFLICT ( col1, col2 ) DO UPDATE SET username=EXCLUDED.username RETURNING id'
   net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," ","
   at line 1, column 116.

   Was expecting:

   ")"
   
   at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:263)
   at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:81)
   at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:47)
   at com.securonix.soar.database.cache.JDBCCache.getTableSet(JDBCCache.java:155)
   at com.securonix.soar.database.cache.JDBCCache.main(JDBCCache.java:198)
   

   Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," ","
   at line 1, column 116.

   Was expecting:

   ")"
   
   at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
   at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:205)
   at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:258)
   ... 4 common frames omitted
   

   Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," ","
   at line 1, column 116.

   Was expecting:

   ")"
   
   at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:33398)
   at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:33231)
   at net.sf.jsqlparser.parser.CCJSqlParser.InsertConflictTarget(CCJSqlParser.java:3017)
   at net.sf.jsqlparser.parser.CCJSqlParser.Insert(CCJSqlParser.java:2967)
   at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:252)
   at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:157)
   at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:253)
   at net.sf.jsqlparser.parser.CCJSqlParserUtil$1.call(CCJSqlParserUtil.java:250)
   at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
   at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
   at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
   at java.base/java.lang.Thread.run(Thread.java:829)
   

   []
   `

   👍React with 👍2Reacted by CrazyZfp and ahweis