[MXS-2210] Query with brackets classify as unknown Created: 2018-12-05  Updated: 2019-06-18  Resolved: 2019-06-18

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 2.2.12
Fix Version/s: 2.4.0

Type: Bug Priority: Major
Reporter: dapeng huang Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MXS-2065 Query could not be tokenized due to r... Closed

 Description   

example:
1. (select 1)
2. (SELECT *,'buy' FROM order_coin WHERE buy_uid =803 and `coin_from` = 'cc' AND `coin_to` = 'usdt') UNION ALL (SELECT * ,'sale' FROM order_coin WHERE sale_uid = 803 and `coin_from` = 'cc' AND `coin_to` = 'usdt') ORDER BY created desc limit 0,30；

 Comments   
Comment by Johan Wikman [ 2019-06-18 ]

Fixed by https://jira.mariadb.org/browse/MXS-2553

The first sample will be fully parsed, the latter partially parsed, but still correctly classified as a read.

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