wangyu3619 commented on issue #21683:
URL: 
https://github.com/apache/shardingsphere/issues/21683#issuecomment-1286737462

   i debug the code ,find that the ShardingSphereDataSource data source does 
not contain all my sharding tables infomation.
   
![image](https://user-images.githubusercontent.com/19728206/197167907-31a17373-8caa-4ec8-b322-4c68e321e32d.png)
   **this is my configs:**
   
   
`spring.shardingsphere.datasource.master.type=com.zaxxer.hikari.HikariDataSource
   
spring.shardingsphere.datasource.master.driver-class-name=org.mariadb.jdbc.Driver
   
spring.shardingsphere.datasource.master.jdbc-url=jdbc:mysql://127.0.0.1:3306/test-new-oms?useSSL=false&useServerPrepStmts=false&rewriteBatchedStatements=true&zeroDateTimeBehavior=convertToNull&characterEncoding=UTF-8
   spring.shardingsphere.datasource.master.username=root
   spring.shardingsphere.datasource.master.password=root
   
spring.shardingsphere.datasource.master.binding-tables=node_stat_info,stat_center_info
   
   
spring.shardingsphere.rules.sharding.tables.node_stat_info.actual-data-nodes=master.node_stat_info_$->{2022..2030}$->{['01','02','03','04','05','06','07','08','09','10','11','12']}$->{['01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31']}
   
spring.shardingsphere.rules.sharding.tables.center_stat_info.actual-data-nodes=master.stat_center_info_$->{2022..2030}$->{['01','02','03','04','05','06','07','08','09','10','11','12']}$->{['01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31']}
   
   
spring.shardingsphere.rules.sharding.tables.node_stat_info.table-strategy.standard.sharding-column=sampling_time
   
spring.shardingsphere.rules.sharding.tables.node_stat_info.table-strategy.standard.sharding-algorithm-name=sharding-by-day
   
spring.shardingsphere.rules.sharding.tables.center_stat_info.table-strategy.standard.sharding-column=sampling_time
   
spring.shardingsphere.rules.sharding.tables.center_stat_info.table-strategy.standard.sharding-algorithm-name=sharding-by-day
   
   
spring.shardingsphere.rules.sharding.sharding-algorithms.sharding-by-day.type=CLASS_BASED
   
spring.shardingsphere.rules.sharding.sharding-algorithms.sharding-by-day.props.strategy=standard
   
spring.shardingsphere.rules.sharding.sharding-algorithms.sharding-by-day.props.algorithmClassName=com.config.ShardingByDayTime`
   
   i configed two rules ,but i can find only one shardingTable`s infomations in 
the ShardingSphereSchema.
   
   I crete a table every day.
   
![image](https://user-images.githubusercontent.com/19728206/197170238-df4fe0c1-9b74-48aa-a037-b708733a2a90.png)
   
   
   


-- 
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]

Reply via email to