[MXS-1248] Report fields used in WITH clause Created: 2017-04-24  Updated: 2017-06-30  Resolved: 2017-06-29

Status: Closed
Project: MariaDB MaxScale
Component/s: QueryClassifier
Affects Version/s: 2.1.2
Fix Version/s: 2.2.0

Type: Task Priority: Major
Reporter: Johan Wikman Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: None

Epic Link: Parser extensions
Sprint: 2017-37

 Description   

Given a statement like
code
WITH t AS (SELECT a FROM t1 WHERE b >= 'c')
SELECT * FROM t2,t WHERE t2.c=t.a;
code
the current query classifier will not report fields used in the WITH clause, e.g. b.

Consequently, the database firewall filter will not block a statement using a forbidden field in the SELECT of the WITH clause.
Generated at Thu Feb 08 04:05:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.