[MXS-4280] qc_sqlite does not properly handle a LIMIT clause Created: 2022-09-07  Updated: 2022-09-14  Resolved: 2022-09-14

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 2.4, 2.5, 6, 22.08
Fix Version/s: 6.4.3, 22.08.2

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

Sprint: MXS-SPRINT-166

 Description   

Internally sqlite3 handles a LIMIT clause as if IN were used.
That is not properly taken into account, which in 22.08 leads to a statement like

DELETE FROM test.mxs1585 LIMIT 100

causing the warning

warning: (4) [qc_sqlite] The function 'in' is not found in the canonical statement 'DELETE FROM test.mxs1585 LIMIT ?' created from the statement 'DELETE FROM test.mxs1585 LIMIT 100'.

to be logged.

In 22.08 there are no other implications. In earlier version, if the firewall filter is used and configured to reject functions, then this will cause the statement to be rejected.


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