<p dir="auto"><strong>Bug Report</strong><br>
Which version of ShardingSphere did you use?<br>
5.0.0</p>
<p dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?<br>
ShardingSphere-JDBC</p>
<p dir="auto">Expected behavior<br>
[insert into t_pipeline_info (PIPELINE_ID, PROJECT_ID, PIPELINE_NAME, PIPELINE_DESC) values (?, ?, ?, ?) on duplicate key update t_pipeline_info.PIPELINE_DESC = ?]<br>
can be converted into<br>
[insert into t_pipeline_info_0 (PIPELINE_ID, PROJECT_ID, PIPELINE_NAME, PIPELINE_DESC) values (?, ?, ?, ?) on duplicate key update t_pipeline_info_0.PIPELINE_DESC = ?]</p>
<p dir="auto">Actual behavior<br>
converted to [insert into <strong>t_pipeline_info_0</strong> (PIPELINE_ID, PROJECT_ID, PIPELINE_NAME, PIPELINE_DESC) values (?, ?, ?, ?) on duplicate key update <strong>t_pipeline_info</strong>.PIPELINE_DESC = ?]</p>
<p dir="auto"><strong>The error message is as follows:</strong><br>
2022-04-29 11:45:55.634|biz-6f32770874f04555a58353f335304281||SQLLogger.java|74|INFO||||||[XNIO-1 task-1] Logic SQL: insert into t_pipeline_info (PIPELINE_ID, PROJECT_ID, PIPELINE_NAME, PIPELINE_DESC) values (?, ?, ?, ?) on duplicate key update t_pipeline_info.PIPELINE_DESC = ?<br>
2022-04-29 11:45:55.634|biz-6f32770874f04555a58353f335304281||SQLLogger.java|74|INFO||||||[XNIO-1 task-1] SQLStatement: MySQLInsertStatement(setAssignment=Optional.empty, onDuplicateKeyColumns=Optional[org.apache.shardingsphere.sql.parser.sql.common.segment.dml.column.OnDuplicateKeyColumnsSegment@4e2038b4])<br>
2022-04-29 11:45:55.634|biz-6f32770874f04555a58353f335304281||SQLLogger.java|74|INFO||||||[XNIO-1 task-1] Actual SQL: ds_0 ::: insert into t_pipeline_info_0 (PIPELINE_ID, PROJECT_ID, PIPELINE_NAME, PIPELINE_DESC) values (?, ?, ?, ?) on duplicate key update t_pipeline_info.PIPELINE_DESC = ? ::: [p-17bd8ac017dsfsd1f, devops0, bnmvvv123dsfdf, 232323yui, 232323yui]<br>
2022-04-29 11:45:55.669|biz-6f32770874f04555a58353f335304281||RuntimeExceptionMapper.kt|47|ERROR||||||[XNIO-1 task-1] Failed with runtime exception org.jooq.exception.DataAccessException: SQL [insert into t_pipeline_info (PIPELINE_ID, PROJECT_ID, PIPELINE_NAME, PIPELINE_DESC) values (?, ?, ?, ?) on duplicate key update t_pipeline_info.PIPELINE_DESC = ?]; Unknown column 't_pipeline_info.PIPELINE_DESC' in 'field list'<br>
at org.jooq_3.14.7.MYSQL.debug(Unknown Source)<br>
at org.jooq.impl.Tools.translate(Tools.java:2880)</p>
<p dir="auto">Add API for configuring whether ShardingSphere cache the metadata of the same sharding tables at startup.</p>
<h3 dir="auto">Question</h3>
<p dir="auto">Many users will pay more attention on performance at startup, and the metadata of the sharding-tables are mostly the same. So add a cache can reduce startup time.</p>
<p dir="auto">Therefore we will add API to make user decide to cache metatata or not.</p>