[MXS-2065] Query could not be tokenized due to round bracket. Created: 2018-09-21  Updated: 2020-07-03  Resolved: 2020-07-03

Status: Closed
Project: MariaDB MaxScale
Component/s: dbfwfilter, qc_sqlite
Affects Version/s: 2.2.14
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Chanmesa Yos Assignee: Johan Wikman
Resolution: Done Votes: 0
Labels: None
Environment:

OS: CentOS 7
Maxscale: 2.2.14
MariaDB Server: 10.2.15


Issue Links:
Relates
relates to MXS-2210 Query with brackets classify as unknown Closed

 Description   

dbfwfilter doesn't support query with round bracket

Example: a query below could be run successfully on MariaDB server but when it's run on Maxscale with dbfwfilter enabled, it doesn't work with log message "Query could not be tokenized and will hence be rejected. Please ensure that the SQL syntax is correct."

Query:
(select Name from test2)
UNION
(select Name from test1)

Hope this could be fixed soon. Thanks



 Comments   
Comment by markus makela [ 2020-07-03 ]

Looks like this was fixed by MXS-2210.

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