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

Session state tracking does not track variable changes via aliases

    XMLWordPrintable

    Details

      Description

      If variable X is set to be tracked, and it has an alias X_ALIAS, and its value changes, tracking does not occur. I'm not sure whether it should (MySQL documentation at least doesn't say one way or another), but it would be logical for the purpose of having a consistent session state.

      --enable_session_track_info
       
      --echo #
      --echo # Only max_delayed_threads is set for tracking,
      --echo # the value changed via a synonym -- no tracking
      --echo #
       
      SET session_track_system_variables='max_delayed_threads';
       
      SELECT @@max_delayed_threads;
      SET max_insert_delayed_threads= 0;
       
      --echo #
      --echo # Both max_delayed_threads and the synonym are set for tracking,
      --echo # the value changed via a synonym - only the synonym tracked
      --echo #
       
      SET session_track_system_variables='max_insert_delayed_threads,max_delayed_threads';
       
      SELECT @@max_delayed_threads;
      SET max_insert_delayed_threads= DEFAULT;
      

      10.10 87e8463e

      #
      # Only max_delayed_threads is set for tracking,
      # the value changed via a synonym -- no tracking
      #
      SET session_track_system_variables='max_delayed_threads';
      SELECT @@max_delayed_threads;
      @@max_delayed_threads
      20
      SET max_insert_delayed_threads= 0;
      

      #
      # Both max_delayed_threads and the synonym are set for tracking,
      # the value changed via a synonym - only the synonym tracked
      #
      SET session_track_system_variables='max_insert_delayed_threads,max_delayed_threads';
      SELECT @@max_delayed_threads;
      @@max_delayed_threads
      0
      SET max_insert_delayed_threads= DEFAULT;
      -- Tracker : SESSION_TRACK_SYSTEM_VARIABLES
      -- max_insert_delayed_threads
      -- 20
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.