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

sql_log_bin should be SESSION_ONLY

        Details

          Gliffy Diagrams

            Attachments

              Issue Links

              is part of

              Task - A task that needs to be done. MDEV-7344 5.5.41 merge

              • Blocker - Blocks development and/or testing work, production could not run.
              • Closed
              links to

              Web Link Bug #67433 - Using SET GLOBAL SQL_LOG_BIN should not be allowed

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment - 
                5.5.41/5.6.22 version:

    The global scope for the sql_log_bin system variable has been
    deprecated, and this variable can now be set with session scope
    only. The statement SET GLOBAL SQL_LOG_BIN now produces an
    error. It remains possible to read the global value of
    sql_log_bin, but you should act now to remove any dependencies
    on reading this value from your applications, as the ability to
    do so will be removed in a future MySQL release.
                Show
                elenst Elena Stepanova added a comment - 5.5.41/5.6.22 version: The global scope for the sql_log_bin system variable has been deprecated, and this variable can now be set with session scope only. The statement SET GLOBAL SQL_LOG_BIN now produces an error. It remains possible to read the global value of sql_log_bin, but you should act now to remove any dependencies on reading this value from your applications, as the ability to do so will be removed in a future MySQL release.
                Hide
                Permalink
                danblack Daniel Black added a comment -

                updated documentation. This should be done as part of the commit process.

                Show
                danblack Daniel Black added a comment - updated documentation. This should be done as part of the commit process.

                  People

                  • Assignee:
                    serg Sergei Golubchik
                    Reporter:
                    nirbhay_c Nirbhay Choubey
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: