[GitHub] [shardingsphere] RaigorJiang opened a new issue, #27290: Single table loading may be incorrect when single tables with the same name exist in different storage units

["RaigorJiang (via GitHub)" <gi...@apache.org>]

RaigorJiang opened a new issue, #27290:
URL: https://github.com/apache/shardingsphere/issues/27290

   ## Bug Report
   ### Which version of ShardingSphere did you use?
   5.4.0
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Actual behavior
   #### actual tables
   ```sql
   mysql> show tables from demo_ds_0;
   +---------------------+
   | Tables_in_demo_ds_0 |
   +---------------------+
   | t_encrypt           |
   | t_single            |
   +---------------------+
   2 rows in set (0.00 sec)
   
   mysql> show tables from demo_ds_1;
   +---------------------+
   | Tables_in_demo_ds_1 |
   +---------------------+
   | t_order             |
   | t_single            |
   +---------------------+
   2 rows in set (0.00 sec)
   ```
   
   #### config-sharding.yaml
   ```yaml
   dataSources:
     ds_0:
       url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true
       username: root
       password: 123456
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 5
       minPoolSize: 1
     ds_1:
       url: jdbc:mysql://127.0.0.1:3306/demo_ds_1?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true
       username: root
       password: 123456
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 5
       minPoolSize: 1
   
   rules:
   - !SINGLE
     tables:
       - ds_1.*
   ```
   
   #### loaded single tables
   ```sql
   mysql> show tables;
   +-----------------------+
   | Tables_in_sharding_db |
   +-----------------------+
   | t_order               |
   +-----------------------+
   1 row in set (0.10 sec)
   ```
   `t_single` is lost.
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhaojinchao95 closed issue #27290: Single table loading may be incorrect when single tables with the same name exist in different storage units

["zhaojinchao95 (via GitHub)" <gi...@apache.org>]

zhaojinchao95 closed issue #27290: Single table loading may be incorrect when single tables with the same name exist in different storage units
URL: https://github.com/apache/shardingsphere/issues/27290


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org