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

UPDATE with user variable modification is treated as a session command

    XMLWordPrintable

Details

    Description

      If a write query modifies a user variable in it, the query is treated as a session command instead of being properly classified as a write. This either corrupted the replicas if GTID strict mode wasn't used or broke replication if it was in use.

      The problem can be reproduced with the following query:

      UPDATE test.t1 SET id = (@var := @var + 1);
      

      Attachments

        Activity

          People

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