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

Maxscale masking filter returns parsing error on SELECT with very long WHERE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 6.4.1
    • Fix Version/s: 6.4.3, 22.08.2
    • Component/s: Filter
    • Labels:
      None

      Description

      SELECT that has WHERE with ~1173 elements fails if masking filter is configured:
      Error : (conn=65) The statement could not be fully parsed and will hence be rejected (masking filter)
      ...
      reducing WHERE makes the error gone. It seems no documented limitations, which this SQL violates.

        Attachments

          Activity

            People

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            YK Yakov Kushnirsky
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.