[MXS-4548] The statement canonicalizer cannot handle comments within statements Created: 2023-03-07  Updated: 2023-03-29  Resolved: 2023-03-29

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: 6.4, 22.08, 23.02
Fix Version/s: 2.5.25, 6.4.7, 22.08.6, 23.02.2

Type: Bug Priority: Major
Reporter: Johan Wikman Assignee: Niclas Antti
Resolution: Fixed Votes: 0
Labels: None


 Description   

The canonicalized version of a statement like

START/**/TRANSACTION READ WRITE

is

START

and not

START TRANSACTION READ WRITE

as it should be.

The effect of this is that if the query classifier cache is used (which it is by default), there may be false positives if statements contain comments. And the effect of that will be the incorrect classification.


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