You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "Ikki-Dai (via GitHub)" <gi...@apache.org> on 2023/02/28 06:50:43 UTC
[GitHub] [shardingsphere] Ikki-Dai opened a new issue, #24374: error time_zone while use Instant type to query
Ikki-Dai opened a new issue, #24374:
URL: https://github.com/apache/shardingsphere/issues/24374
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
5.1.2 ~ 5.3.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
while use Instant type, it have different value type from mysql sql log
when trans value like '2023-02-10T00:00:00Z' use Instant Type
- use jdbc **without** shardingsphere, print log in mybatis is '2023-02-10 00:00:00.0 (Timestamp)' and actual value '2023-02-10 00:00:00' in mysql (mysql.general_log)
### Actual behavior
- use jdbc **with** shardingsphere, pring log in mybatis and shardingsphere is '2023-02-10 00:00:00.0 (Timestamp' and actual value '2023-02-09 16:00:00' in mysql(mysql.general_log)
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] FlyingZC commented on issue #24374: error time_zone while use Instant type to query
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC commented on issue #24374:
URL: https://github.com/apache/shardingsphere/issues/24374#issuecomment-1459093175
<img width="1354" alt="image" src="https://user-images.githubusercontent.com/19788130/223589766-c486bb50-4a2d-407c-ac09-9aad26dcef1a.png">
I tried it, and found that the time displayed in the Mybatis log seems to be wrong, and the code has not yet entered the ShardingSphere.
--
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
Re: [I] error time_zone while use Instant type to query [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #24374: error time_zone while use Instant type to query
URL: https://github.com/apache/shardingsphere/issues/24374
--
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
[GitHub] [shardingsphere] FlyingZC commented on issue #24374: error time_zone while use Instant type to query
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC commented on issue #24374:
URL: https://github.com/apache/shardingsphere/issues/24374#issuecomment-1451545078
[OK]
--
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
[GitHub] [shardingsphere] Ikki-Dai commented on issue #24374: error time_zone while use Instant type to query
Posted by "Ikki-Dai (via GitHub)" <gi...@apache.org>.
Ikki-Dai commented on issue #24374:
URL: https://github.com/apache/shardingsphere/issues/24374#issuecomment-1450281306
@FlyingZC
pls refer https://github.com/Ikki-Dai/shardsphere24374.git for demo
--
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
[GitHub] [shardingsphere] FlyingZC commented on issue #24374: error time_zone while use Instant type to query
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC commented on issue #24374:
URL: https://github.com/apache/shardingsphere/issues/24374#issuecomment-1449168181
Shardingsphere will not modify the date time, can you provide a reproducible demo.
--
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
[GitHub] [shardingsphere] Ikki-Dai commented on issue #24374: error time_zone while use Instant type to query
Posted by "Ikki-Dai (via GitHub)" <gi...@apache.org>.
Ikki-Dai commented on issue #24374:
URL: https://github.com/apache/shardingsphere/issues/24374#issuecomment-1452805536
`Date` type have same issue
--
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
[GitHub] [shardingsphere] Ikki-Dai commented on issue #24374: error time_zone while use Instant type to query
Posted by "Ikki-Dai (via GitHub)" <gi...@apache.org>.
Ikki-Dai commented on issue #24374:
URL: https://github.com/apache/shardingsphere/issues/24374#issuecomment-1459592926
have u checked `mysql.general_log`, it have different actual value and result set while use shardingsphere and not
--
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