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

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.4.1
    • 6.4.3, 22.08.2
    • Filter
    • 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

        1. sql_where.sql
          49 kB
          Yakov Kushnirsky

        Activity

          People

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