Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20005

sql_log_off Docu seems wrong

    XMLWordPrintable

Details

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

      Attachments

        Activity

          People

            jacob.moorman Jacob Moorman (Inactive)
            oli Oli Sennhauser
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.