[MXS-4600] Do not unnecessarily inject the '=' function into classification data. Created: 2023-04-27  Updated: 2023-04-28  Resolved: 2023-04-28

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 22.08, 23.02
Fix Version/s: 22.08.6, 23.02.2

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


 Description   

A statement like INSERT INTO t SET f = 42 will be reported to be using the function =, but so will INSERT INTO t (f) VALUES (42). In the latter case it is clearly nonsensical and in the former case quite dubious as = in that context is assignment and not comparison. From the point of view of the firewall filter (no longer supported in 23.02) and the masking filter the use of = for comparison is meaningful, but not for assignment.

In the latter case, since = is not present in the statement, it means that extra scratch memory will have to be allocated in the classification data. In DEBUG mode it will cause a warning to be logged.


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