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

SET SESSION statement combined with SET STATEMENT has no effect if it's executed for the same variable

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: N/A
    • Fix Version/s: N/A
    • Component/s: Documentation
    • Labels:
      None
    • Sprint:
      10.1.11

      Description

      MariaDB [test]> select @@sort_buffer_size;
      +--------------------+
      | @@sort_buffer_size |
      +--------------------+
      |            2097152 |
      +--------------------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> set statement sort_buffer_size = 100000 for set session sort_buffer_size = 200000;
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [test]> select @@sort_buffer_size;
      +--------------------+
      | @@sort_buffer_size |
      +--------------------+
      |            2097152 |
      +--------------------+
      1 row in set (0.00 sec)

      If it's not expected to work, there should be an error or a warning.

      Percona has a more generic flavor of the problem, where it doesn't work for any combination of variables (https://bugs.launchpad.net/percona-server/+bug/1341438), while in our case it happens when the same variable appears in SET STATEMENT and SET SESSION.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
              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.