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

PREPARE ... FROM @var is not parsed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.9
    • Fix Version/s: 2.2.10
    • Component/s: qc_sqlite
    • Labels:
      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

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