dolthub/dolt
在 GitHub 查看Dolt differs from MySQL on allowing query global only system variable with session scope
Open
#6,722 建立於 2023年9月26日
bugcorrectnessgood first issuegood reprosql
倉庫指標
- Star
- (15,227 star)
- PR 合併指標
- (平均合併 2天 21小時) (30 天內合併 58 個 PR)
描述
Dolt display incorrect header for querying global only variable without specifying the scope. It also should error on querying global only variable with SESSION scope.
Dolt:
mysql> SELECT @@system_time_zone;
+----------------------------+
| @@SESSION.system_time_zone |
+----------------------------+
| PDT |
+----------------------------+
1 row in set (0.00 sec)
mysql> SELECT @@SESSION.system_time_zone;
+----------------------------+
| @@SESSION.system_time_zone |
+----------------------------+
| PDT |
+----------------------------+
1 row in set (0.00 sec)
MySQL:
mysql> SELECT @@system_time_zone;
+--------------------+
| @@system_time_zone |
+--------------------+
| PDT |
+--------------------+
1 row in set (0.00 sec)
mysql> SELECT @@SESSION.system_time_zone;
ERROR 1238 (HY000): Variable 'system_time_zone' is a GLOBAL variable