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

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22768 Assertion `! is_set() || m_can_overwrite_status' failed in Diagnostics_area::set_error_status

          • Major - Major loss of function.
          • Stalled
          relates to

          Task - A task that needs to be done. MDEV-5231 Per query variables from Percona Server [patch]

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14760 Replication does not take into account SET STATEMENT

          • Critical - Crashes, loss of data, severe memory leak.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22768 Assertion `! is_set() || m_can_overwrite_status' failed in Diagnostics_area::set_error_status

          • Major - Major loss of function.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            rucha174 Rucha Deodhar created issue -
            rucha174 Rucha Deodhar made changes -
            Field Original Value New Value
            rucha174 Rucha Deodhar made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            rucha174 Rucha Deodhar made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            rucha174 Rucha Deodhar added a comment -

            Patch: https://github.com/MariaDB/server/commit/ebb5acf947b2699ce9596677c3a4a3f429644556

            rucha174 Rucha Deodhar added a comment - Patch: https://github.com/MariaDB/server/commit/ebb5acf947b2699ce9596677c3a4a3f429644556
            rucha174 Rucha Deodhar made changes -
            Assignee Rucha Deodhar [ rucha174 ] Oleksandr Byelkin [ sanja ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            rucha174 Rucha Deodhar made changes -
            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             		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|http://mariadb.com/kb/en/set-statement/#limitations]
            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

            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
            Roel Roel Van de Paar made changes -
            Labels affects-tests
            Roel Roel Van de Paar made changes -
            julien.fritsch Julien Fritsch made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Priority Critical [ 2 ] Major [ 3 ]
            rucha174 Rucha Deodhar made changes -
            Assignee Oleksandr Byelkin [ sanja ] Rucha Deodhar [ rucha174 ]
            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 made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            rucha174 Rucha Deodhar made changes -
            Elkin Andrei Elkin made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.2 [ 14601 ]
            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 )
            rucha174 Rucha Deodhar made changes -
            Assignee Rucha Deodhar [ rucha174 ] Oleksandr Byelkin [ sanja ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.3 [ 22126 ]
            alice Alice Sherepa made changes -
            Affects Version/s 10.6 [ 24028 ]
            Affects Version/s 10.7 [ 24805 ]
            Affects Version/s 10.8 [ 26121 ]
            Affects Version/s 10.9 [ 26905 ]
            Affects Version/s 10.10 [ 27530 ]
            Affects Version/s 10.11 [ 27614 ]
            Affects Version/s 11.0 [ 28320 ]
            alice Alice Sherepa made changes -
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.10 [ 27530 ]
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 11.0 [ 28320 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.9 [ 26905 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.10 [ 27530 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 11.0 [ 28320 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.4 [ 22408 ]
            rucha174 Rucha Deodhar made changes -

            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.