<p dir="auto">Bug Report<br>
Which version of ShardingSphere did you use?<br>
4.1.1</p>
<p dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?<br>
ShardingSphere-proxy</p>
<p dir="auto">Expected behavior<br>
connection<br>
my yaml<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/67138442/85101000-fe6f3a80-b233-11ea-8c24-9b2b92896d49.png"><img src="https://user-images.githubusercontent.com/67138442/85101000-fe6f3a80-b233-11ea-8c24-9b2b92896d49.png" alt="image" style="max-width: 100%;"></a></p>
<h2 dir="auto">Bug Report</h2>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">Faced an issue upgrading from 3.1.0 to 4.0.1</p>
<h3 dir="auto">Which project did you use? Sharding-JDBC or Sharding-Proxy?</h3>
<p dir="auto">sharding-jdbc-core<br>
<a href="https://mvnrepository.com/artifact/org.apache.shardingsphere/sharding-jdbc-core/4.0.1" rel="nofollow">https://mvnrepository.com/artifact/org.apache.shardingsphere/sharding-jdbc-core/4.0.1</a></p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">Insert query needs to run as usual</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">Getting <code class="notranslate">java.sql.SQLException: No value specified for parameter 1</code></p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<p dir="auto">Please notice in the below log fragment, the <code class="notranslate">insertValueContexts</code> is empty. Also, in the logic and actual sql, all the columns mentioned in <code class="notranslate">columnNames</code> in SQLContext are not present. This is what is causing the error as per my understanding.</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="Logic SQL: insert into sample_table (client, create_date, source, key_string, ticket_id) values (?, ?, ?, ?, ?)

SQLStatement: InsertSQLStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@3b8923ff, tablesContext=TablesContext(tables=[Table(name= sample_table, alias=Optional.absent())], schema=Optional.absent())), columnNames=[id, client, ticket_id, source, key_string, source_id, create_date, update_date], insertValueContexts=[])

Actual SQL: shard-1 ::: insert into sample_table (client, create_date, source, key_string, ticket_id) values (?, ?, ?, ?, ?)"><pre class="notranslate"><code class="notranslate">Logic SQL: insert into sample_table (client, create_date, source, key_string, ticket_id) values (?, ?, ?, ?, ?)

SQLStatement: InsertSQLStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@3b8923ff, tablesContext=TablesContext(tables=[Table(name= sample_table, alias=Optional.absent())], schema=Optional.absent())), columnNames=[id, client, ticket_id, source, key_string, source_id, create_date, update_date], insertValueContexts=[])

Actual SQL: shard-1 ::: insert into sample_table (client, create_date, source, key_string, ticket_id) values (?, ?, ?, ?, ?)
</code></pre></div>
<h3 dir="auto">Proposed fix</h3>
<p dir="auto">The above error gets fixed if I rename column <code class="notranslate">source</code> to something else. I tried <code class="notranslate">option_source</code> and it worked.<br>
Can <code class="notranslate">source</code> column name be supported please</p>