[GitHub] [shardingsphere] qingchengshi commented on issue #22829: Table by month, cross month query error

[GitBox]

qingchengshi commented on issue #22829:
URL: 
https://github.com/apache/shardingsphere/issues/22829#issuecomment-1347622102

   <dependency&gt;
       <groupId&gt;org.apache.shardingsphere</groupId&gt;
       
<artifactId&gt;shardingsphere-jdbc-core-spring-boot-starter</artifactId&gt;
       <version&gt;5.0.0</version&gt;
   </dependency&gt;
   spring.shardingsphere.enabled=true spring.shardingsphere.datasource.names = 
m1  spring.shardingsphere.props.sql-show=true 
spring.shardingsphere.datasource.m1.type= com.zaxxer.hikari.HikariDataSource 
spring.shardingsphere.datasource.m1.jdbc-url= 
jdbc:mysql://127.0.0.1:3306/sy_attendance_gy_1?characterEncoding=UTF-8&amp;rewriteBatchedStatements=true&amp;autoReconnect=true&amp;useSSL=false&amp;serverTimezone=Asia/Shanghai
 spring.shardingsphere.datasource.m1.username = root 
spring.shardingsphere.datasource.m1.password = 123456 
spring.shardingsphere.datasource.m1.driver-class-name= com.mysql.cj.jdbc.Driver 
 
spring.shardingsphere.rules.sharding.tables.attendance_three_well.actual-data-nodes
 = m1.attendance_three_well_202$-&gt;{201..212} 
spring.shardingsphere.rules.sharding.tables.attendance_three_well.table-strategy.standard.sharding-column
 = day_date 
spring.shardingsphere.rules.sharding.tables.attendance_three_well.table-strategy.standard.sharding-algorithm-name
 = table-inline spring.s
 hardingsphere.rules.sharding.tables.attendance_three_well.key-generator.column 
= id 
spring.shardingsphere.rules.sharding.tables.attendance_three_well.key-generator.type
 = SNOWFLAKE 
spring.shardingsphere.rules.sharding.sharding-algorithms.table-inline.type = 
CLASS_BASED 
spring.shardingsphere.rules.sharding.sharding-algorithms.table-inline.props.strategy
 = standard 
spring.shardingsphere.rules.sharding.sharding-algorithms.table-inline.props.algorithmClassName
 = com.ms.attendance.threepairs.controller.CommonStandardShardingAlgorithm 
   
   
   
   Message ID: ***@***.***&gt;


-- 
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-unsubscr...@shardingsphere.apache.org

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