Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.4, 2.5, 6, 22.08
-
None
-
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.