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

[GitBox <gi...@apache.org>]

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

   <dependency>
               <groupId>org.apache.shardingsphere</groupId>
               <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
               <version>5.0.0</version>
           </dependency>
   
   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&rewriteBatchedStatements=true&autoReconnect=true&useSSL=false&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$->{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.shardingsphere.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
   


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