[I] When using IntervalShardingAlgorithm to split tables by month, there is a problem in creating split tables across years [shardingsphere]

[via GitHub]

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

   ### version：
   ShardingSphere Proxy 5.4.0
   
   ### config-sharding.yaml
   rules:
   - !SHARDING
     tables:
       t_order:
         actualDataNodes: ds.t_order_${202311..202401}
         tableStrategy:
           standard:
             shardingColumn: create_time
             shardingAlgorithmName: sharding_by_time
   
     shardingAlgorithms:
       sharding_by_time:
         type: INTERVAL
         props:
           datetime-pattern: "yyyy-MM-dd HH:mm:ss" 
           datetime-lower: "2023-01-01 00:00:00"
           datetime-upper: "2099-12-31 23:59:59"
           sharding-suffix-pattern: "yyyyMM"
           datetime-interval-amount: 1
           datetime-interval-unit: "MONTHS" 
   
   ### Expected behavior
   Create the following sub-tables when executing sql
   ```sql
   CREATE TABLE `t_order` (  `id` int NOT NULL,  `name` varchar(45) DEFAULT 
NULL,create_time datetime,  PRIMARY KEY (`id`))
   ```
   t_order_202311
   t_order_202312
   t_order_202401
   
   ### Actual behavior
   t_order_202311
   t_order_202312
   t_order_202313
   ....
   t_order_202399
   t_order_202400
   t_order_202401
   
   
![image](https://github.com/apache/shardingsphere/assets/5884703/6c8e5291-c751-4e3d-bd0b-548810f1e84c)
   
   
   


-- 
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.apache.org

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