[GitHub] [shardingsphere] linghengqian commented on issue #22451: The group by statement with division sign cannot be executed for the datatime type field of the logical table in H2Database

["linghengqian (via GitHub)" <gi...@apache.org>]

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: notifications-unsubscribe@shardingsphere.apache.org

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