phdbutbachelor opened a new issue, #22916: URL: https://github.com/apache/shardingsphere/issues/22916
### Which version of ShardingSphere did you use? 5.1.1~5.2.1 ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-JDBC ### Expected behavior my project worked ok with mysql-connector-java 8.0.22, when I upgraded mysql-connector-java to 8.0.23+, shardingsphere can produced correct sql but did not return data. shardingsphere printed log: `2022-12-16 18:13:09.408 [INFO] @http-nio-80-exec-6: Logic SQL: select infolog0_.id as id1_2_, infolog0_.actorId as actorid2_2_, infolog0_.endTime as endtime3_2_, infolog0_.ip as ip4_2_, infolog0_.level as level5_2_, infolog0_.method as method6_2_, infolog0_.realmType as realmtyp7_2_, infolog0_.request as request8_2_, infolog0_.response as response9_2_, infolog0_.stack as stack10_2_, infolog0_.startTime as startti11_2_, infolog0_.transactionId as transac12_2_, infolog0_.responseCode as respons13_2_ from set_info_logs infolog0_ where infolog0_.startTime>=? order by infolog0_.startTime DESC limit ? 2022-12-16 18:13:09.408 [INFO] @http-nio-80-exec-6: SQLStatement: MySQLSelectStatement(table=Optional.empty, limit=Optional[org.apache.shardingsphere.sql.parser.sql.common.segment.dml.pagination.limit.LimitSegment@3bc80369], lock=Optional.empty, window=Optional.empty) 2022-12-16 18:13:09.408 [INFO] @http-nio-80-exec-6: Actual SQL: main ::: select infolog0_.id as id1_2_, infolog0_.actorId as actorid2_2_, infolog0_.endTime as endtime3_2_, infolog0_.ip as ip4_2_, infolog0_.level as level5_2_, infolog0_.method as method6_2_, infolog0_.realmType as realmtyp7_2_, infolog0_.request as request8_2_, infolog0_.response as response9_2_, infolog0_.stack as stack10_2_, infolog0_.startTime as startti11_2_, infolog0_.transactionId as transac12_2_, infolog0_.responseCode as respons13_2_ from set_info_logs_202212 infolog0_ where infolog0_.startTime>=? order by infolog0_.startTime DESC limit ? ::: [1970-01-01 00:00:00.0, 10]` ### Actual behavior the sql can acctually run in database client, but shardingsphere returns not data -- 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]
