adordly opened a new issue, #36994: URL: https://github.com/apache/shardingsphere/issues/36994
## Question Today, I used the following SQL to query the minimum transaction date in the table. The SQL statement is as follows: `select MIN(trade_data) from table_a`。 The data type of trade_date in MySQL is date, and I use LocalDate to encapsulate the returned data type in MyBatis, but the system reports the following error: `org.mybatis.spring.MyBatisSystemException:nested exception is org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'MIN(trade_date)' from result set. Cause: org.apache.shardingsphere.infra.exception.ShardingSphereException: Unsupported date type: class java.time.LocalDate for value 2025-05-01 org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) com.sun.proxy.$Proxy242.selectOne(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)` **I would like to ask if there will be any issues or if it is not supported when converting from the database date type to the LocalDate type in Java within sharding?** -- 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]
