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

Docs: `old` variable is session and dynamic

    XMLWordPrintable

Details

    Description

      Documentation https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/system-variables/server-system-variables/#old says that old variable is global and non-dynamic; in fact, it's can be set on a session level at runtime (at least in 5.5 and above, I didn't check earlier versions):

      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      		 
      Your MariaDB connection id is 1
      		 
      Server version: 5.5.40-MariaDB-debug Source distribution
      		 
       
      		 
      Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
      		 
       
      		 
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      		 
       
      		 
      MariaDB [test]> set old = 1;
      		 
      Query OK, 0 rows affected (0.00 sec)

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.