[MDEV-20005] sql_log_off Docu seems wrong Created: 2019-07-09  Updated: 2019-08-22  Resolved: 2019-08-22

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Server, Variables
Affects Version/s: 10.4.6
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Oli Sennhauser Assignee: Jacob Moorman (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

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   |
 
+---------------+-------+


Generated at Thu Feb 08 08:56:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.