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:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 0.25d
                0.25d

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.