<p dir="auto">I'm trying to upgrade from legacy version 2.0.3 -&gt; <code class="notranslate">Sharding-JDBC 4.0.0-RC1</code>, here I have many compatibility issue, such as:</p>
<ul dir="auto">
<li>FORCE INDEX will cause BAD SQL.</li>
<li>LIMIT NOT WORKING with sum etc.</li>
</ul>
<p dir="auto">so I am wondering how much SQL test case is included in this project?</p>
<p dir="auto">version: sharding proxy 5.0.0</p>
<p dir="auto">yml:</p>
<p dir="auto">schemaName: sharding_db</p>
<p dir="auto">dataSourceCommon:<br>
username: root<br>
password: 123456<br>
connectionTimeoutMilliseconds: 30000<br>
idleTimeoutMilliseconds: 60000<br>
maxLifetimeMilliseconds: 1800000<br>
maxPoolSize: 50<br>
minPoolSize: 1<br>
maintenanceIntervalMilliseconds: 30000</p>
<p dir="auto">dataSources:<br>
ds1:<br>
url: jdbc:mysql://192.168.255.115/testdb1?serverTimezone=UTC&amp;useSSL=false&amp;characterEncoding=utf8<br>
ds1_slave:<br>
url: jdbc:mysql://192.168.255.116/testdb1?serverTimezone=UTC&amp;useSSL=false&amp;characterEncoding=utf8<br>
ds2:<br>
url: jdbc:mysql://192.168.255.115/testdb2?serverTimezone=UTC&amp;useSSL=false&amp;characterEncoding=utf8<br>
ds2_slave:<br>
url: jdbc:mysql://192.168.255.116/testdb2?serverTimezone=UTC&amp;useSSL=false&amp;characterEncoding=utf8</p>
<p dir="auto">rules:</p>
<ul dir="auto">
<li>
<p dir="auto">!SHARDING<br>
tables:<br>
t_order:<br>
actualDataNodes: ms_ds${1..2}.t_order${1..2}<br>
databaseStrategy:<br>
standard:<br>
shardingColumn: uid<br>
shardingAlgorithmName: database_inline<br>
tableStrategy:<br>
standard:<br>
shardingColumn: id<br>
shardingAlgorithmName: t_order_inline<br>
keyGenerateStrategy:<br>
column: id<br>
keyGeneratorName: snowflake<br>
bindingTables:</p>
<ul dir="auto">
<li>t_order<br>
broadcastTables:</li>
<li>t_user</li>
<li>t_org<br>
defaultDatabaseStrategy:<br>
none:<br>
defaultTableStrategy:<br>
none:</li>
</ul>
<p dir="auto">shardingAlgorithms:<br>
database_inline:<br>
type: INLINE<br>
props:<br>
algorithm-expression: ms_ds${uid % 2+1}<br>
t_order_inline:<br>
type: INLINE<br>
props:<br>
algorithm-expression: t_order${order_id % 2+1}</p>
<p dir="auto">keyGenerators:<br>
snowflake:<br>
type: SNOWFLAKE<br>
props:<br>
worker-id: 123</p>
</li>
<li>
<p dir="auto">!REPLICA_QUERY<br>
dataSources:<br>
ms_ds1:<br>
primaryDataSourceName: ds1<br>
replicaDataSourceNames:<br>
- ds1_slave<br>
loadBalancerName: ROUND_ROBIN<br>
ms_ds2:<br>
primaryDataSourceName: ds2<br>
replicaDataSourceNames:<br>
- ds2_slave<br>
loadBalancerName: ROUND_ROBIN</p>
</li>
</ul>
<p dir="auto">##############################################<br>
*** when I try to connect the proxy db it misreport:<br>
10002 _ 2Unknown exception [Can not route tables for '[ENGINES]', please make sure the tables are in same schema.]</p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/64132316/106251017-6ae0fc00-624f-11eb-8acc-32972478eae0.png"><img src="https://user-images.githubusercontent.com/64132316/106251017-6ae0fc00-624f-11eb-8acc-32972478eae0.png" alt="image" style="max-width: 100%;"></a></p>