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

SET STATEMENT allows variables that cannot be set per query basis

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
    • 10.5, 10.6, 10.11
    • Variables

    Description

      SET STATEMENT allows variables that should not be allowed to set per query basis.
      Example:
      default_master_connection, last_insert_id, log_slow_filter, log_slow_rate_limit, log_slow_verbosity, long_query_time, min_examined_row_limit, rand_seed1, rand_seed2, slow_query_log

      See limitation

      Attachments

        Issue Links

          Activity

            rucha174 Rucha Deodhar added a comment - Patch: https://github.com/MariaDB/server/commit/ebb5acf947b2699ce9596677c3a4a3f429644556

            sanja A review for this patch would be appreciated as this patch may resolve MDEV-22768 which affects tests significantly. Thank you

            Roel Roel Van de Paar added a comment - sanja A review for this patch would be appreciated as this patch may resolve MDEV-22768 which affects tests significantly. Thank you
            rucha174 Rucha Deodhar added a comment -

            Reassigning to myself to check why those variables can't be set and if any other system variable should go to the disallowed list.

            rucha174 Rucha Deodhar added a comment - Reassigning to myself to check why those variables can't be set and if any other system variable should go to the disallowed list.
            rucha174 Rucha Deodhar added a comment -

            Roel Hi ! I have found the list of variables that should be disallowed. But some are confusing. I am waiting for what sanja thinks. (Should have reassigned it)

            rucha174 Rucha Deodhar added a comment - Roel Hi ! I have found the list of variables that should be disallowed. But some are confusing. I am waiting for what sanja thinks. ( Should have reassigned it )

            People

              sanja Oleksandr Byelkin
              rucha174 Rucha Deodhar
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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