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

qc_sqlite does not properly handle a LIMIT clause

    XMLWordPrintable

Details

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

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            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.