Re: [I] No value specified for parameter exception when sql is 'INSERT INTO tableName *** ON CONFLICT *** DO UPDATE set ** WHERE ***' [shardingsphere]

["omkar-shitole (via GitHub)" <gi...@apache.org>]

omkar-shitole commented on issue #32280:
URL: https://github.com/apache/shardingsphere/issues/32280#issuecomment-2550955685

   Hello, 
   I investigated this particular bug report.
   
   It is a bug. I successfully reproduced it. Also, I would like to let you know that this particular query -
   *  The query executes successfully with `INSERT INTO` & `VALUES` when no `WHERE` statement is provided.
   *  The query fails when extra parameter markers/placeholders are provided beyond those assigned to `VALUES`.
   *  The `WHERE`  statement works well with the INSERT INTO` & `SELECT statements. 
   
   I reviewed the ANTLR rules related to this issue, and they seem to be correctly implemented.
   
   Any suggestions regarding the scope of the investigation and fix would be greatly appreciated.
   
   Also, I would request you to assign this issue to me.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org