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

Doubled quotes inside quoted strings do not collapse correctly when canonicalizing query strings

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 6.4.13, 22.08.11, 23.02.8, 23.08.4
    • 24.02.0
    • Core
    • None

    Description

      For a query like this:

      SELECT '''''''''';
      

      The canonical version currently is:

      SELECT ?????;
      

      The correctly "collapsed" canonical would be:

      SELECT ?;
      

      This is because there's only one SQL value in the string. The practical effects of this are fairly minimal and the effects of this usually are mainly in less efficient use of the qc_cache. For the QLA filter, it might be a more of a nuisance as the same logical query might end up with a different canonical query string.

      Attachments

        Activity

          People

            markus makela markus makela
            markus makela markus makela
            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.