Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.4.6
-
None
-
Linux Ubuntu 18.04 (n.a.)
Description
MariaDB Documentation states: Scope: Session for sql_log_off
https://mariadb.com/kb/en/library/server-system-variables/#sql_log_off
MySQL 8.0 Docu (and before) states differently.
Own tests show as well that MariaDB Docu is wrong:
SQL> SHOW GLOBAL VARIABLES LIKE 'sql_log_off';
|
+---------------+-------+
|
| Variable_name | Value |
|
+---------------+-------+
|
| sql_log_off | OFF |
|
+---------------+-------+
|
|
SQL> SHOW SESSION VARIABLES LIKE 'sql_log_off';
|
+---------------+-------+
|
| Variable_name | Value |
|
+---------------+-------+
|
| sql_log_off | OFF |
|
+---------------+-------+
|
|
SQL> set session sql_log_off=on;
|
Query OK, 0 rows affected (0.000 sec)
|
|
SQL> SHOW SESSION VARIABLES LIKE 'sql_log_off';
|
+---------------+-------+
|
| Variable_name | Value |
|
+---------------+-------+
|
| sql_log_off | ON |
|
+---------------+-------+
|
|
SQL> SHOW GLOBAL VARIABLES LIKE 'sql_log_off';
|
+---------------+-------+
|
| Variable_name | Value |
|
+---------------+-------+
|
| sql_log_off | OFF |
|
+---------------+-------+
|