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

SQL_MODE=ORACLE assignment doesn't recognize autocommit=0

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Fixed
    • 6.4.14, 22.08.11, 23.02.8, 23.08.4
    • 24.08.0
    • qc_sqlite
    • None
    • MXS-SPRINT-210

    Description

      The assignment to autocommit isn't detected by the parser but this ends up having very little effect in MaxScale 23.08 as the autocommit state is still correctly detected by the transaction state fixing code that reads it from the OK packet. Older versions may incorrectly track the transaction state if SQL_MODE=ORACLE is used with autocommit:=0.

      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.