linghengqian commented on issue #22451: URL: https://github.com/apache/shardingsphere/issues/22451#issuecomment-1696993331
- I finished verifying in https://github.com/linghengqian/group-by-shardingsphere-test/commit/033ef1b778a5684f7d7c5df42ca95cd1786173e6 and no longer reported an error using `unix_timestamp` and `group by` on the logical table, and this issue has been fixed in ShardingSphere JDBC 5.4.0. ```sql select `id_string`,`create_time` from t_order where `create_time` between '2022-11-24 00:00:00.000' and '2022-11-25 00:00:00.000' group by (unix_timestamp(`create_time`) / 3600) order by `create_time` limit 30 ``` -- 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]
