Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-4280

qc_sqlite does not properly handle a LIMIT clause

    XMLWordPrintable

    Details

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

        Attachments

          Activity

            People

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            johan.wikman Johan Wikman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.