sosadfly-gh opened a new issue, #70809:
URL: https://github.com/apache/doris/issues/70809

   ### Version
   
   `doris version doris-4.0.8-rc02-bc8ea1bac6d (Cloud Mode)`
   
   ### What's Wrong?
   
   Doris rejects `SET time_zone = 'SYSTEM'` in an established session. MySQL 
clients that execute this statement during session initialization can therefore 
report a connection failure. [Tabularis issue 
#1640](https://github.com/TabularisDB/tabularis/issues/1640)
   
   ### What You Expected?
   
   For MySQL compatibility, Doris should accept `SYSTEM` as a session 
`time_zone` value. MySQL uses `SYSTEM` to select the server's system time zone. 
TiDB provides a distributed precedent: it accepts the same value and resolves 
it to the system time zone recorded when the cluster was first bootstrapped. 
[MySQL time zone 
documentation](https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html) 
ยท [TiDB time zone 
documentation](https://docs.pingcap.com/tidb/stable/configure-time-zone/)
   
   Doris could follow a similar approach by defining which time zone `SYSTEM` 
resolves to in a multi-node deployment, documenting that rule, and using the 
resolved time zone consistently across all nodes executing a query.
   
   ### How to Reproduce?
   
   1. Connect to Apache Doris 4.0.8 using a MySQL client.
   2. Run the following statement in the established session.
   
      ```sql
      SET time_zone = 'SYSTEM';
      ```
   
   3. Observe the error.
   
      ```text
      Unknown or incorrect time zone: 'SYSTEM'
      ```
   


-- 
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]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to