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

Report fields used in WITH clause

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.2
    • Fix Version/s: 2.2.0
    • Component/s: QueryClassifier
    • Labels:
      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

            Assignee:
            johan.wikman Johan Wikman
            Reporter:
            johan.wikman Johan Wikman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration