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

SELECT ignores @@default_master_connection

    XMLWordPrintable

Details

    • Unexpected results

    Description

      It always points to the pre-multi-source unnamed connection.

      # Setup
      		 
      CHANGE MASTER 'name' TO master_host='127.0.0.1', master_user='root';
      		 
       
      		 
      SET @@GLOBAL.replicate_do_db= 'unnamed';
      		 
      SET @@SESSION.default_master_connection= 'name';
      		 
      SET @@GLOBAL.replicate_do_db= 'named';
      		 
       
      		 
      SELECT @@GLOBAL.name.replicate_do_db; #=> ⭕ named
      		 
      SELECT @@GLOBAL.replicate_do_db; #=> ❌ unnamed
      		 
       
      		 
      # Cleanup
      		 
      RESET SLAVE ALL;
      		 
      SET @@SESSION.default_master_connection= '';
      		 
      SET @@GLOBAL.replicate_do_db= DEFAULT;

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-39875 Add a way to access the global default value of per-connection replication configurations

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40297 SET changes @@default_master_connection if the explicit connection name is blank

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              ParadoxV5 Jimmy Hú
              ParadoxV5 Jimmy Hú
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 0.75h
                  0.75h

                  Git Integration

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