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

Query could not be tokenized due to round bracket.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 2.2.14
    • Fix Version/s: N/A
    • Component/s: dbfwfilter, qc_sqlite
    • Labels:
      None
    • Environment:
      OS: CentOS 7
      Maxscale: 2.2.14
      MariaDB Server: 10.2.15

      Description

      dbfwfilter doesn't support query with round bracket

      Example: a query below could be run successfully on MariaDB server but when it's run on Maxscale with dbfwfilter enabled, it doesn't work with log message "Query could not be tokenized and will hence be rejected. Please ensure that the SQL syntax is correct."

      Query:
      (select Name from test2)
      UNION
      (select Name from test1)

      Hope this could be fixed soon. Thanks

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              johan.wikman Johan Wikman
              Reporter:
              chanmesa Chanmesa Yos
              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.