You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/08/09 02:18:09 UTC
[GitHub] [shardingsphere] wsg96321 opened a new issue, #20004: sharding proxy time_zone can not change
wsg96321 opened a new issue, #20004:
URL: https://github.com/apache/shardingsphere/issues/20004
version: sharding proxy v5.1.0
for example : `1659070419` is the timestamp of `2022-07-29 12:53:39` for time_zone "UTC+8"
but when I set time_zone in my sharding proxy, it seems does't effect. It keeps the `time_zone` for `SYSTEM`, and I can't not change it in one connect session (it doesn't have matter when I login the remote mysql to `set time_zone`, so it troubleshoot remote mysql problems)
in the same instance but not the same database, It works for sharding proxy by `set time_zone` when I doesn't have use INLINE expressions for my sharding table, like belows:
--
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] wsg96321 closed issue #20004: sharding proxy time_zone can not change
Posted by GitBox <gi...@apache.org>.
wsg96321 closed issue #20004: sharding proxy time_zone can not change
URL: https://github.com/apache/shardingsphere/issues/20004
--
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] wsg96321 commented on issue #20004: sharding proxy time_zone can not change
Posted by GitBox <gi...@apache.org>.
wsg96321 commented on issue #20004:
URL: https://github.com/apache/shardingsphere/issues/20004#issuecomment-1208982675
it is the same behavior when I use set global time_zone , and besides , when it is only just one database in a sharding proxy instance , it seems work right.
( also I have try this in v5.1.1 version , it is the same as v5.1.0 )
--
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] TeslaCN commented on issue #20004: sharding proxy time_zone can not change
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #20004:
URL: https://github.com/apache/shardingsphere/issues/20004#issuecomment-1208973447
SET statement is not properly handled in previous versions. Please consider setting global timezone.
--
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] TeslaCN commented on issue #20004: sharding proxy time_zone can not change
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #20004:
URL: https://github.com/apache/shardingsphere/issues/20004#issuecomment-1208988337
We did some changes to SET statement in https://github.com/apache/shardingsphere/issues/18738, which would be available in next release.
--
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] wsg96321 commented on issue #20004: sharding proxy time_zone can not change
Posted by GitBox <gi...@apache.org>.
wsg96321 commented on issue #20004:
URL: https://github.com/apache/shardingsphere/issues/20004#issuecomment-1209117912
OK , thanks a lot , then we will have a try in next release .
--
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