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

PREPARE ... FROM @var is not parsed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.2.9
    • 2.2.10
    • qc_sqlite
    • None

    Description

      The following text protocol prepared statement cannot be parsed.

      SET @sql='SELECT 1';
      PREPARE a FROM @sql;
      

      This causes uses of the prepared statement to fail.

      An adequate solution would be to classify these as either unknown types or writes, both of which would cause the query to be routed to the master.

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.