strongduanmu commented on issue #11794: URL: https://github.com/apache/shardingsphere/issues/11794#issuecomment-918940633
When I tested, I found another problem, that is, calcite has problems with time processing. ```sql mysql> insert into t_single(single_id, content, date) values(1, '11', '2021-09-14'); Query OK, 1 row affected (0.03 sec) ``` I executed the following SQL and inserted a record with the date `2021-09-14` into the t_single table, but when I query it through calcite, it returns `2021-09-13`. ```sql mysql> select * from t_single s inner join t_order_test t ON s.single_id = t.test_id; +---------+------------+-----------+----------+---------+ | content | date | single_id | content0 | test_id | +---------+------------+-----------+----------+---------+ | 11 | 2021-09-13 | 1 | 11 | 1 | +---------+------------+-----------+----------+---------+ ``` -- 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]
