Open jennifersp opened 11 months ago
This is partially fixed in Dolt 1.32.0...
We no longer add the SESSION
prefix, and now match the exact form that was requested in the query:
SELECT @@system_time_zone;
+--------------------+
| @@system_time_zone |
+--------------------+
| PST |
+--------------------+
However, you can still incorrectly query a global variable using SESSION
syntax:
SELECT @@SESSION.system_time_zone;
+----------------------------+
| @@SESSION.system_time_zone |
+----------------------------+
| PST |
+----------------------------+
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: