linghengqian opened a new issue, #17948: URL: https://github.com/apache/shardingsphere/issues/17948
## Feature Request **For English only**, other languages will not accept. Please pay attention on issues you submitted, because we maybe need more details. If no response anymore and we cannot make decision by current information, we will **close it**. Please answer these questions before submitting your issue. Thanks! ### Is your feature request related to a problem? Yes, related to https://github.com/apache/shardingsphere/issues/17752 and https://github.com/apache/shardingsphere/issues/16738 . ### Describe the feature you would like. - Due to the introduction of the above two issues and corresponding PR, `org.apache.shardingsphere.sharding.algorithm.sharding.datetime.IntervalShardingAlgorithm` has completed support for the following JSR-310 and time related classes, These classes are no longer a problem for Mybatis' built-in TypeHandlers recognition. Refer to https://mybatis.org/mybatis-3/zh/configuration.html#typeHandlers . - java.util.Date - java.sql.Timestamp - java.time.Instant - java.time.LocalDateTime - java.time.OffsetDateTime - java.time.ZonedDateTime - java.time.LocalTime - java.time.OffsetTime - java.time.LocalDate - java.time.chrono.JapaneseDate - However, border situations remain. The following JSR-310 classes are not yet supported in 'org.apache.shardingsphere.sharding.algorithm.sharding.datetime.IntervalShardingAlgorithm . Also affected by https://github.com/apache/shardingsphere/pull/17919#issuecomment-1136026115 , support for `java.time.chrono.JapaneseDate` is subject to support that has not yet been validated in `org.apache.shardingsphere.sharding.algorithm.sharding.datetime.IntervalShardingAlgorithmTest`, which is where it needs to be handled . - `java.time.Year` (JDBC Type is INTEGER in Mybatis) - `java.time.Month` (JDBC Type is INTEGER in Mybatis) - `java.time.YearMonth` (JDBC Type is VARCHAR or LONGVARCHAR in Mybatis) - From the purpose of IntervalShardingAlgorithm, supporting the above class is expected behavior. -- 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]
