Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.4, 2.5, 6, 22.08
-
Component/s: qc_sqlite
-
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.