<h2 dir="auto">Bug Report</h2>
<p dir="auto"><strong>For English only</strong>, other languages will not accept.</p>
<p dir="auto">Before report a bug, make sure you have:</p>
<ul dir="auto">
<li>Searched open and closed <a href="https://github.com/apache/incubator-shardingsphere/issues">GitHub issues</a>.</li>
<li>Read documentation: <a href="https://shardingsphere.apache.org/document/current/en/overview" rel="nofollow">ShardingSphere Doc</a>.</li>
</ul>
<p dir="auto">Please pay attention on issues you submitted, because we maybe need more details.<br>
If no response <strong>more than 7 days</strong> and we cannot reproduce it on current information, we will <strong>close it</strong>.</p>
<p dir="auto">Please answer these questions before submitting your issue. Thanks!</p>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">4.0.0-RC2</p>
<h3 dir="auto">Which project did you use? Sharding-JDBC or Sharding-Proxy?</h3>
<p dir="auto">Sharding-JDBC</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">Successfully read from tables with columns of clob types ( with <a class="user-mention notranslate" data-hovercard-type="organization" data-hovercard-url="/orgs/lob/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/lob">@lob</a> annotation).</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">Got the following error:<br>
org.springframework.dao.InvalidDataAccessApiUsageException: java.lang.String cannot be cast to java.sql.Clob; nested exception is java.lang.IllegalArgumentException: java.lang.String cannot be cast to java.sql.Clob</p>
<p dir="auto">The same code works for original DataSource from springboot.</p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>
<h2 dir="auto">Bug Report</h2>
<p dir="auto"><strong>For English only</strong>, other languages will not accept.</p>
<p dir="auto">Before report a bug, make sure you have:</p>
<ul dir="auto">
<li>Searched open and closed <a href="https://github.com/apache/shardingsphere/issues">GitHub issues</a>.</li>
<li>Read documentation: <a href="https://shardingsphere.apache.org/document/current/en/overview" rel="nofollow">ShardingSphere Doc</a>.</li>
</ul>
<p dir="auto">Please pay attention on issues you submitted, because we maybe need more details.<br>
If no response anymore and we cannot reproduce it on current information, we will <strong>close it</strong>.</p>
<p dir="auto">Please answer these questions before submitting your issue. Thanks!</p>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">5.0.0-RC1(From <a href="https://dist.apache.org/repos/dist/dev/shardingsphere/5.0.0-RC1/" rel="nofollow">https://dist.apache.org/repos/dist/dev/shardingsphere/5.0.0-RC1/</a> , not master branch)</p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-Proxy</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">When I click on the library table in the SQLyog GUI to operate normally, the Proxy terminal should not have an error level log.<br>
The following is my operation log in SQLyog.<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/20187731/138399015-d2b0d938-73cb-4a66-9265-b36ca477964f.png"><img src="https://user-images.githubusercontent.com/20187731/138399015-d2b0d938-73cb-4a66-9265-b36ca477964f.png" alt="image" style="max-width: 100%;"></a></p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/20187731/138397807-41836d4e-8439-4131-ad54-6ec2ed855c26.png"><img src="https://user-images.githubusercontent.com/20187731/138397807-41836d4e-8439-4131-ad54-6ec2ed855c26.png" alt="image" style="max-width: 100%;"></a></p>
<div class="highlight highlight-source-shell notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="/*[22-Oct 13:20:02][17 ms]*/ SHOW VARIABLES LIKE 'AUTOCOMMIT'; 
/*[22-Oct 13:20:02][2 ms]*/ SHOW DATABASES; 
/*[22-Oct 13:20:04][1 ms]*/ USE `sharding_db`; 
/*[22-Oct 13:20:05][2 ms]*/ SHOW FULL TABLES FROM `sharding_db` WHERE table_type = 'BASE TABLE'; 
/*[22-Oct 13:20:06][30 ms]*/ DESCRIBE `sharding_db`.`tb_result3_sharding_sphere`; 
/*[22-Oct 13:20:06][19 ms]*/ SHOW INDEX FROM `sharding_db`.`tb_result3_sharding_sphere`; 
/*[22-Oct 13:21:21][39789 ms]*/ SELECT * FROM `sharding_db`.`tb_result3_sharding_sphere` LIMIT 0, 1000; 
/*[22-Oct 13:21:21][12 ms]*/ SHOW CREATE TABLE `sharding_db`.`tb_result3_sharding_sphere`; 
/*[22-Oct 13:21:21][27 ms]*/ SHOW FULL FIELDS FROM `sharding_db`.`tb_result3_sharding_sphere`; 
/*[22-Oct 13:21:21][11 ms]*/ SHOW KEYS FROM `sharding_db`.`tb_result3_sharding_sphere`; "><pre class="notranslate">/<span class="pl-k">*</span>[22-Oct 13:20:02][17 ms]<span class="pl-k">*</span>/ SHOW VARIABLES LIKE <span class="pl-s"><span class="pl-pds">'</span>AUTOCOMMIT<span class="pl-pds">'</span></span><span class="pl-k">;</span> 
/<span class="pl-k">*</span>[22-Oct 13:20:02][2 ms]<span class="pl-k">*</span>/ SHOW DATABASES<span class="pl-k">;</span> 
/<span class="pl-k">*</span>[22-Oct 13:20:04][1 ms]<span class="pl-k">*</span>/ USE <span class="pl-s"><span class="pl-pds">`</span>sharding_db<span class="pl-pds">`</span></span><span class="pl-k">;</span> 
/<span class="pl-k">*</span>[22-Oct 13:20:05][2 ms]<span class="pl-k">*</span>/ SHOW FULL TABLES FROM <span class="pl-s"><span class="pl-pds">`</span>sharding_db<span class="pl-pds">`</span></span> WHERE table_type = <span class="pl-s"><span class="pl-pds">'</span>BASE TABLE<span class="pl-pds">'</span></span><span class="pl-k">;</span> 
/<span class="pl-k">*</span>[22-Oct 13:20:06][30 ms]<span class="pl-k">*</span>/ DESCRIBE <span class="pl-s"><span class="pl-pds">`</span>sharding_db<span class="pl-pds">`</span></span>.<span class="pl-s"><span class="pl-pds">`</span>tb_result3_sharding_sphere<span class="pl-pds">`</span></span><span class="pl-k">;</span> 
/<span class="pl-k">*</span>[22-Oct 13:20:06][19 ms]<span class="pl-k">*</span>/ SHOW INDEX FROM <span class="pl-s"><span class="pl-pds">`</span>sharding_db<span class="pl-pds">`</span></span>.<span class="pl-s"><span class="pl-pds">`</span>tb_result3_sharding_sphere<span class="pl-pds">`</span></span><span class="pl-k">;</span> 
/<span class="pl-k">*</span>[22-Oct 13:21:21][39789 ms]<span class="pl-k">*</span>/ SELECT <span class="pl-k">*</span> FROM <span class="pl-s"><span class="pl-pds">`</span>sharding_db<span class="pl-pds">`</span></span>.<span class="pl-s"><span class="pl-pds">`</span>tb_result3_sharding_sphere<span class="pl-pds">`</span></span> LIMIT 0, 1000<span class="pl-k">;</span> 
/<span class="pl-k">*</span>[22-Oct 13:21:21][12 ms]<span class="pl-k">*</span>/ SHOW CREATE TABLE <span class="pl-s"><span class="pl-pds">`</span>sharding_db<span class="pl-pds">`</span></span>.<span class="pl-s"><span class="pl-pds">`</span>tb_result3_sharding_sphere<span class="pl-pds">`</span></span><span class="pl-k">;</span> 
/<span class="pl-k">*</span>[22-Oct 13:21:21][27 ms]<span class="pl-k">*</span>/ SHOW FULL FIELDS FROM <span class="pl-s"><span class="pl-pds">`</span>sharding_db<span class="pl-pds">`</span></span>.<span class="pl-s"><span class="pl-pds">`</span>tb_result3_sharding_sphere<span class="pl-pds">`</span></span><span class="pl-k">;</span> 
/<span class="pl-k">*</span>[22-Oct 13:21:21][11 ms]<span class="pl-k">*</span>/ SHOW KEYS FROM <span class="pl-s"><span class="pl-pds">`</span>sharding_db<span class="pl-pds">`</span></span>.<span class="pl-s"><span class="pl-pds">`</span>tb_result3_sharding_sphere<span class="pl-pds">`</span></span><span class="pl-k">;</span> </pre></div>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">Of course, everything is normal in SQLyog, and the select statement is executed normally. I have not seen any abnormalities in SQLyog, but I found error level logs on the terminal of ShardingSphere-Proxy, which puzzled me.</p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/20187731/138397665-4eeca3b9-0be3-424c-902d-364a4c86c8ab.png"><img src="https://user-images.githubusercontent.com/20187731/138397665-4eeca3b9-0be3-424c-902d-364a4c86c8ab.png" alt="image" style="max-width: 100%;"></a></p>
<div class="highlight highlight-source-shell notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="[INFO ] 2021-10-22 13:18:32.839 [main] o.a.s.p.frontend.ShardingSphereProxy - ShardingSphere-Proxy start success
[ERROR] 2021-10-22 13:19:47.669 [Connection-5-ThreadExecutor] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.lang.UnsupportedOperationException: unsupported table : `EVENTS`
        at org.apache.shardingsphere.proxy.backend.text.admin.mysql.MySQLInformationSchemaExecutorFactory.newInstance(MySQLInformationSchemaExecutorFactory.java:52)
        at org.apache.shardingsphere.proxy.backend.text.admin.mysql.MySQLAdminExecutorFactory.newInstance(MySQLAdminExecutorFactory.java:95)
        at org.apache.shardingsphere.proxy.backend.text.admin.DatabaseAdminBackendHandlerFactory.newInstance(DatabaseAdminBackendHandlerFactory.java:78)
        at org.apache.shardingsphere.proxy.backend.text.TextProtocolBackendHandlerFactory.newInstance(TextProtocolBackendHandlerFactory.java:86)
        at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.&lt;init&gt;(MySQLComQueryPacketExecutor.java:52)
        at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecutorFactory.newInstance(MySQLCommandExecutorFactory.java:73)
        at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandExecutor(MySQLCommandExecuteEngine.java:60)
        at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:97)
        at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:72)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
[ERROR] 2021-10-22 13:20:03.759 [Connection-10-ThreadExecutor] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.lang.UnsupportedOperationException: unsupported table : `EVENTS`
        at org.apache.shardingsphere.proxy.backend.text.admin.mysql.MySQLInformationSchemaExecutorFactory.newInstance(MySQLInformationSchemaExecutorFactory.java:52)
        at org.apache.shardingsphere.proxy.backend.text.admin.mysql.MySQLAdminExecutorFactory.newInstance(MySQLAdminExecutorFactory.java:95)
        at org.apache.shardingsphere.proxy.backend.text.admin.DatabaseAdminBackendHandlerFactory.newInstance(DatabaseAdminBackendHandlerFactory.java:78)
        at org.apache.shardingsphere.proxy.backend.text.TextProtocolBackendHandlerFactory.newInstance(TextProtocolBackendHandlerFactory.java:86)
        at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.&lt;init&gt;(MySQLComQueryPacketExecutor.java:52)
        at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecutorFactory.newInstance(MySQLCommandExecutorFactory.java:73)
        at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandExecutor(MySQLCommandExecuteEngine.java:60)
        at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:97)
        at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:72)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
[INFO ] 2021-10-22 13:20:38.681 [Connection-8-ThreadExecutor] o.a.s.p.b.t.a.m.e.i.AbstractSelectInformationExecutor$DefaultSelectInformationExecutor - Actual SQL: ds_0 ::: select `ENGINE`, `SUPPORT` from information_schema.Engines"><pre class="notranslate">[INFO ] 2021-10-22 13:18:32.839 [main] o.a.s.p.frontend.ShardingSphereProxy - ShardingSphere-Proxy start success
[ERROR] 2021-10-22 13:19:47.669 [Connection-5-ThreadExecutor] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.lang.UnsupportedOperationException: unsupported table <span class="pl-c1">:</span> <span class="pl-s"><span class="pl-pds">`</span>EVENTS<span class="pl-pds">`</span></span>
        at org.apache.shardingsphere.proxy.backend.text.admin.mysql.MySQLInformationSchemaExecutorFactory.newInstance(MySQLInformationSchemaExecutorFactory.java:52)
        at org.apache.shardingsphere.proxy.backend.text.admin.mysql.MySQLAdminExecutorFactory.newInstance(MySQLAdminExecutorFactory.java:95)
        at org.apache.shardingsphere.proxy.backend.text.admin.DatabaseAdminBackendHandlerFactory.newInstance(DatabaseAdminBackendHandlerFactory.java:78)
        at org.apache.shardingsphere.proxy.backend.text.TextProtocolBackendHandlerFactory.newInstance(TextProtocolBackendHandlerFactory.java:86)
        at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.<span class="pl-k">&lt;</span>init<span class="pl-s"><span class="pl-pds">&gt;(</span>MySQLComQueryPacketExecutor.java:52<span class="pl-pds">)</span></span>
        at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecutorFactory.newInstance(MySQLCommandExecutorFactory.java:73)
        at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandExecutor(MySQLCommandExecuteEngine.java:60)
        at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:97)
        at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:72)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor<span class="pl-smi">$Worker</span>.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
[ERROR] 2021-10-22 13:20:03.759 [Connection-10-ThreadExecutor] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.lang.UnsupportedOperationException: unsupported table <span class="pl-c1">:</span> <span class="pl-s"><span class="pl-pds">`</span>EVENTS<span class="pl-pds">`</span></span>
        at org.apache.shardingsphere.proxy.backend.text.admin.mysql.MySQLInformationSchemaExecutorFactory.newInstance(MySQLInformationSchemaExecutorFactory.java:52)
        at org.apache.shardingsphere.proxy.backend.text.admin.mysql.MySQLAdminExecutorFactory.newInstance(MySQLAdminExecutorFactory.java:95)
        at org.apache.shardingsphere.proxy.backend.text.admin.DatabaseAdminBackendHandlerFactory.newInstance(DatabaseAdminBackendHandlerFactory.java:78)
        at org.apache.shardingsphere.proxy.backend.text.TextProtocolBackendHandlerFactory.newInstance(TextProtocolBackendHandlerFactory.java:86)
        at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.<span class="pl-k">&lt;</span>init<span class="pl-s"><span class="pl-pds">&gt;(</span>MySQLComQueryPacketExecutor.java:52<span class="pl-pds">)</span></span>
        at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecutorFactory.newInstance(MySQLCommandExecutorFactory.java:73)
        at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandExecutor(MySQLCommandExecuteEngine.java:60)
        at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:97)
        at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:72)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor<span class="pl-smi">$Worker</span>.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
[INFO ] 2021-10-22 13:20:38.681 [Connection-8-ThreadExecutor] o.a.s.p.b.t.a.m.e.i.AbstractSelectInformationExecutor<span class="pl-smi">$DefaultSelectInformationExecutor</span> - Actual SQL: ds_0 ::: <span class="pl-k">select</span> <span class="pl-smi">`ENGINE`,</span> <span class="pl-s"><span class="pl-pds">`</span>SUPPORT<span class="pl-pds">`</span></span> from information_schema.Engines</pre></div>
<h3 dir="auto">Reason analyze (If you can)</h3>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>
<p dir="auto">The following is my configuration in Proxy.<br>
server.yaml</p>
<div class="highlight highlight-source-yaml notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="mode:
  type: Cluster
  repository:
    type: ZooKeeper
    props:
      namespace: governance_ds
      server-lists: localhost:2181
      retryIntervalMilliseconds: 500
      timeToLiveSeconds: 60
      maxRetries: 3
      operationTimeoutMilliseconds: 500
  overwrite: true
rules:
  - !AUTHORITY
    users:
      - root@%:root
      - sharding233@:sharding233
    provider:
      type: ALL_PRIVILEGES_PERMITTED
  - !TRANSACTION
    defaultType: XA
    providerType: Atomikos
props:
  max-connections-size-per-query: 1
  kernel-executor-size: 16
  proxy-frontend-flush-threshold: 128
  proxy-opentracing-enabled: false
  proxy-hint-enabled: false
  sql-show: false
  check-table-metadata-enabled: false
  lock-wait-timeout-milliseconds: 50000
  show-process-list-enabled: false
  proxy-backend-query-fetch-size: -1
  check-duplicate-table-enabled: false
  sql-comment-parse-enabled: false
  proxy-frontend-executor-size: 0
  proxy-backend-executor-suitable: OLAP"><pre class="notranslate"><span class="pl-ent">mode</span>:
  <span class="pl-ent">type</span>: <span class="pl-s">Cluster</span>
  <span class="pl-ent">repository</span>:
    <span class="pl-ent">type</span>: <span class="pl-s">ZooKeeper</span>
    <span class="pl-ent">props</span>:
      <span class="pl-ent">namespace</span>: <span class="pl-s">governance_ds</span>
      <span class="pl-ent">server-lists</span>: <span class="pl-s">localhost:2181</span>
      <span class="pl-ent">retryIntervalMilliseconds</span>: <span class="pl-c1">500</span>
      <span class="pl-ent">timeToLiveSeconds</span>: <span class="pl-c1">60</span>
      <span class="pl-ent">maxRetries</span>: <span class="pl-c1">3</span>
      <span class="pl-ent">operationTimeoutMilliseconds</span>: <span class="pl-c1">500</span>
  <span class="pl-ent">overwrite</span>: <span class="pl-c1">true</span>
<span class="pl-ent">rules</span>:
  - <span class="pl-k">!AUTHORITY</span>
    <span class="pl-ent">users</span>:
      - <span class="pl-s">root@%:root</span>
      - <span class="pl-s">sharding233@:sharding233</span>
    <span class="pl-ent">provider</span>:
      <span class="pl-ent">type</span>: <span class="pl-s">ALL_PRIVILEGES_PERMITTED</span>
  - <span class="pl-k">!TRANSACTION</span>
    <span class="pl-ent">defaultType</span>: <span class="pl-s">XA</span>
    <span class="pl-ent">providerType</span>: <span class="pl-s">Atomikos</span>
<span class="pl-ent">props</span>:
  <span class="pl-ent">max-connections-size-per-query</span>: <span class="pl-c1">1</span>
  <span class="pl-ent">kernel-executor-size</span>: <span class="pl-c1">16</span>
  <span class="pl-ent">proxy-frontend-flush-threshold</span>: <span class="pl-c1">128</span>
  <span class="pl-ent">proxy-opentracing-enabled</span>: <span class="pl-c1">false</span>
  <span class="pl-ent">proxy-hint-enabled</span>: <span class="pl-c1">false</span>
  <span class="pl-ent">sql-show</span>: <span class="pl-c1">false</span>
  <span class="pl-ent">check-table-metadata-enabled</span>: <span class="pl-c1">false</span>
  <span class="pl-ent">lock-wait-timeout-milliseconds</span>: <span class="pl-c1">50000</span>
  <span class="pl-ent">show-process-list-enabled</span>: <span class="pl-c1">false</span>
  <span class="pl-ent">proxy-backend-query-fetch-size</span>: <span class="pl-c1">-1</span>
  <span class="pl-ent">check-duplicate-table-enabled</span>: <span class="pl-c1">false</span>
  <span class="pl-ent">sql-comment-parse-enabled</span>: <span class="pl-c1">false</span>
  <span class="pl-ent">proxy-frontend-executor-size</span>: <span class="pl-c1">0</span>
  <span class="pl-ent">proxy-backend-executor-suitable</span>: <span class="pl-s">OLAP</span></pre></div>
<p dir="auto">config-sharding.yaml</p>
<div class="highlight highlight-source-yaml notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="schemaName: sharding_db
dataSources:
  ds_0:
    url: jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2b8&amp;useSSL=false
    username: root
    password: 123456
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
    minPoolSize: 1
rules:
- !SHARDING
  tables:
    tb_result3_sharding_sphere:
      actualDataNodes: ds_0.tb_result3_sharding_sphere_$-&gt;{1..366}
      tableStrategy:
        standard:
          shardingColumn: datadate
          shardingAlgorithmName: tb-result3-class-based
      keyGenerateStrategy:
        column: tb_result3_id
        keyGeneratorName: snowflake
  bindingTables:
    - tb_result3_sharding_sphere
  defaultDatabaseStrategy:
    none:
  defaultTableStrategy:
    none:
  shardingAlgorithms:
    tb-result3-class-based:
      type: CLASS_BASED
      props:
        strategy: STANDARD
        algorithmClassName: com.sg8000.spi.TbResult3ShardingAlgorithm
  keyGenerators:
    snowflake:
      type: SNOWFLAKE
      props:
        worker-id: 1"><pre class="notranslate"><span class="pl-ent">schemaName</span>: <span class="pl-s">sharding_db</span>
<span class="pl-ent">dataSources</span>:
  <span class="pl-ent">ds_0</span>:
    <span class="pl-ent">url</span>: <span class="pl-s">jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2b8&amp;useSSL=false</span>
    <span class="pl-ent">username</span>: <span class="pl-s">root</span>
    <span class="pl-ent">password</span>: <span class="pl-c1">123456</span>
    <span class="pl-ent">connectionTimeoutMilliseconds</span>: <span class="pl-c1">30000</span>
    <span class="pl-ent">idleTimeoutMilliseconds</span>: <span class="pl-c1">60000</span>
    <span class="pl-ent">maxLifetimeMilliseconds</span>: <span class="pl-c1">1800000</span>
    <span class="pl-ent">maxPoolSize</span>: <span class="pl-c1">50</span>
    <span class="pl-ent">minPoolSize</span>: <span class="pl-c1">1</span>
<span class="pl-ent">rules</span>:
- <span class="pl-k">!SHARDING</span>
  <span class="pl-ent">tables</span>:
    <span class="pl-ent">tb_result3_sharding_sphere</span>:
      <span class="pl-ent">actualDataNodes</span>: <span class="pl-s">ds_0.tb_result3_sharding_sphere_$-&gt;{1..366}</span>
      <span class="pl-ent">tableStrategy</span>:
        <span class="pl-ent">standard</span>:
          <span class="pl-ent">shardingColumn</span>: <span class="pl-s">datadate</span>
          <span class="pl-ent">shardingAlgorithmName</span>: <span class="pl-s">tb-result3-class-based</span>
      <span class="pl-ent">keyGenerateStrategy</span>:
        <span class="pl-ent">column</span>: <span class="pl-s">tb_result3_id</span>
        <span class="pl-ent">keyGeneratorName</span>: <span class="pl-s">snowflake</span>
  <span class="pl-ent">bindingTables</span>:
    - <span class="pl-s">tb_result3_sharding_sphere</span>
  <span class="pl-ent">defaultDatabaseStrategy</span>:
    <span class="pl-ent">none</span>:
  <span class="pl-ent">defaultTableStrategy</span>:
    <span class="pl-ent">none</span>:
  <span class="pl-ent">shardingAlgorithms</span>:
    <span class="pl-ent">tb-result3-class-based</span>:
      <span class="pl-ent">type</span>: <span class="pl-s">CLASS_BASED</span>
      <span class="pl-ent">props</span>:
        <span class="pl-ent">strategy</span>: <span class="pl-s">STANDARD</span>
        <span class="pl-ent">algorithmClassName</span>: <span class="pl-s">com.sg8000.spi.TbResult3ShardingAlgorithm</span>
  <span class="pl-ent">keyGenerators</span>:
    <span class="pl-ent">snowflake</span>:
      <span class="pl-ent">type</span>: <span class="pl-s">SNOWFLAKE</span>
      <span class="pl-ent">props</span>:
        <span class="pl-ent">worker-id</span>: <span class="pl-c1">1</span></pre></div>