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

SET STATEMENT variables are not ignored when statements are classified

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 22.08
    • 22.08.4
    • qc_sqlite
    • None
    • MXS-SPRINT-172

    Description

      Currently the statement

      SET STATEMENT max_statement_time = 60 FOR SELECT 1

      is classified like QUERY_TYPE_READ|QUERY_TYPE_GSYSVAR_WRITE, which will cause it to be sent to all servers. However, as the variable changes caused by SET STATEMENT are effective only for the duration of the specified statement, they should simply be ignored and the whole statement classified as QUERY_TYPE_READ.

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            johan.wikman Johan Wikman
            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.