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

SET tx_isolation cancels out strict_multi_stmt and strict_sp_calls

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 21.06.17, 22.08.14, 23.02.11, 23.08.7, 24.02.3, 24.08.0
    • 25.10.0
    • readwritesplit
    • None

    Description

      If readwritesplit is configured with strict_multi_stmt or strict_sp_calls and a SET tx_isolation='repeatable-read' is executed, the effects of strict_multi_stmt and strict_sp_calls are canceled out. The following test case should return the same server_id value as long as the session is alive but it may return a server_id from a replica.

      delimiter $$ ;
      SELECT @@server_id AS 'before multistmt' $$
      DO 1; DO 2; $$
      SELECT @@server_id AS 'after multistmt' $$
      SET tx_isolation='read-committed' $$
      SELECT @@server_id AS 'after tx_isolation' $$
      

      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.