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

Report fields used in WITH clause

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.1.2
    • 2.2.0
    • QueryClassifier
    • None

    Description

      Given a statement like
      code
      WITH t AS (SELECT a FROM t1 WHERE b >= 'c')
      SELECT * FROM t2,t WHERE t2.c=t.a;
      code
      the current query classifier will not report fields used in the WITH clause, e.g. b.

      Consequently, the database firewall filter will not block a statement using a forbidden field in the SELECT of the WITH clause.

      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.