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

EXPLAIN does not work with masking filter

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5, 6.2.4
    • Fix Version/s: 22.08.0
    • Component/s: masking
    • Labels:
      None
    • Sprint:
      MXS-SPRINT-160

      Description

      It seems EXPLAIN is not handled by masking filter at all and we get:

      ERROR 1141 : The statement could not be fully parsed and will hence bee rejected (masking filter)
      

      even for simple

      explain select * from T;
      

      where T is not involved in any masking rules. Same probably applies to ANALYZE and is not documented in our KB as a limitation:

      https://mariadb.com/kb/en/mariadb-maxscale-6-masking/#limitations

        Attachments

          Activity

            People

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.