kevinLuan opened a new issue #3321: nested exception is 
org.postgresql.util.PSQLException: 未设定参数值 5 的内容。
URL: https://github.com/apache/incubator-shardingsphere/issues/3321
 
 
   ## Bug Report
   Postgresql database + ShardingSphere using the following SQL times wrong:  
nested exception is org.postgresql.util.PSQLException: 未设定参数值 5 的内容。
   
   The sample:
   INSERT INTO xxx(c1,c2,c3,c4,c5)VALUES (#{c1},#{c2},#{c3},#{c4},lower(#{c5}))
    ON conflict(id) DO 
   UPDATE SET c1=#{c1},appdes=#{c2},c4=lower(#{c5})
   
   Through the debug code, is a postgresql parse SQL syntax tree, unable to 
properly resolve the insert at the back of the parameters, lead to the JDBC 
insert data, tip missing parameters

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

Reply via email to