dolthub/dolt
Dolt differs from MySQL on allowing query global only system variable with session scope
Chiusa
#6722 aperta il 26 set 2023
bugcorrectnessgood first issuegood reprosql
Metriche repository
- Star
- (15.227 stelle)
- Metriche merge PR
- (Metriche PR in attesa)
Descrizione
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