Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-333

use_sql_variables_in=master doesn't work

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.0
    • 1.3.0
    • readwritesplit
    • None

    Description

      Setting the use_sql_variables_in=master parameter in the readwritesplit should make it so that all read queries which access a variable should be routed to the master. The queries are not routed to the master but are routed to a slave.

      Steps to reproduce:
      add use_sql_variables_in=master to a service which uses readwritesplit and execute the following queries.

      set @myvar = @@hostname;
      select @myvar; -- This should not return NULL

      The following does work which shows that the select part of the query is the cause.

      set @myvar = @@hostname;
      begin;
      select @myvar; -- @@hostname is returned

      Attachments

        Activity

          People

            markus makela markus makela
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.