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

Docs: `old` variable is session and dynamic

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Trivial
        • Resolution: Fixed
        • Affects Version/s: N/A
        • Fix Version/s: N/A
        • Component/s: Documentation
        • Labels:

          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)

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                greenman Ian Gilfillan added a comment -

                Documentation updated, the behaviour changed in 5.5

                Show
                greenman Ian Gilfillan added a comment - Documentation updated, the behaviour changed in 5.5

                  People

                  • Assignee:
                    greenman Ian Gilfillan
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: