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

Session state tracking does not track variable changes via aliases

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.5, 10.6, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
    • 11.1.1
    • Variables

    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

              serg Sergei Golubchik
              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.