<p dir="auto">As i use the sharding-sphere in my old project . There is some sql segement like<br>
insert into a (a,b) value(?,?) on duplicate key update a= ? , b = ? + b by use the PreparedStatement<br>
then the sharding-sphere will ignore the last two question symbol , then will cause the parameter 3 not found exception .<br>
As i go through the source code in version 3.0.1-SNAPSHOT and found there is not any logic to handle the placeholder in 'on duplicate key update' , so just support sql like insert into a (a,b) value(?,?) on duplicate key update a= VALUES(a) , b = VALUES(b) .<br>
Does this feature will support sooner , or any consideration for the sql at the beginning.<br>
As i have modified the code to support it .</p>
<h2 dir="auto">Bug Report</h2>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">Both 5.0.0-alpha and 5.0.0-beta have this problem.</p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-JDBC</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">Successful execution of sql.</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">Unsuccessful execution of sql</p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<p dir="auto">N/A</p>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<p dir="auto">Use Oracle 11g,MybatisPlus.<br>
Run the TestdemoApplicationTests will get java.sql.SQLException: getValidColumnIndex.<br>
If you don't use sharding, you will get the correct result.</p>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>
<p dir="auto"><a href="https://github.com/xueshiji/testdemo.git">https://github.com/xueshiji/testdemo.git</a></p>