qudonghui opened a new issue, #20680:
URL: https://github.com/apache/shardingsphere/issues/20680
## Bug Report
### Which version of ShardingSphere did you use?
5.1.0
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
### Actual behavior
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule
configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
```
sharding-sphere:
datasource:
names: oms-base,oms-2022-1,oms-2022-2,oms-2022-3,oms-2022-4
oms-base:
type: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbc-url:
jdbc:mysql://localhost:13306/db_oms1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
username: root
password: root
oms-2022-1:
type: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbc-url:
jdbc:mysql://localhost:13306/db_oms_2022_1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
username: root
password: root
oms-2022-2:
type: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbc-url:
jdbc:mysql://localhost:13306/db_oms_2022_2?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
username: root
password: root
oms-2022-3:
type: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbc-url:
jdbc:mysql://localhost:13306/db_oms_2022_3?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
username: root
password: root
oms-2022-4:
type: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbc-url:
jdbc:mysql://localhost:13306/db_oms_2022_4?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
username: root
password: root
rules:
sharding:
binding-tables:
- oms_order_basic_info,oms_order_logistics_info
broadcast-tables: auth_sys_data_permission,mds_customer_warehouse
default-database-strategy:
standard:
sharding-column: data_route
sharding-algorithm-name: database-inline
sharding-algorithms:
database-inline:
type: CLASS_BASED
props:
strategy: STANDARD
algorithmClassName:
com.mengfan.shardingdemo.config.DbStandardAlgorithm
tables:
oms_order_basic_info:
actual-data-nodes: oms-$->{2022}-$->{1..4}.oms_order_basic_info
oms_order_logistics_info:
actual-data-nodes:
oms-$->{2022}-$->{1..4}.oms_order_logistics_info
oms_order_sync_stringcode:
actual-data-nodes:
oms-$->{2022}-$->{1..4}.oms_order_sync_stringcode
props:
sql-show: true
```
## When I insert the broadcast table auth_ sys_ data_ Permission, not
broadcast to oms-base Datasource
--
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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
