[MXS-1935] PREPARE ... FROM @var is not parsed Created: 2018-06-20  Updated: 2018-06-21  Resolved: 2018-06-21

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 2.2.9
Fix Version/s: 2.2.10

Type: Bug Priority: Major
Reporter: markus makela Assignee: Johan Wikman
Resolution: Fixed Votes: 0
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.



 Comments   
Comment by Johan Wikman [ 2018-06-21 ]

Currently it is classified as QC_QUERY_INVALID, which should cause it to be routed to master.

Generated at Thu Feb 08 04:10:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.