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]
