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

Query could not be tokenized due to round bracket.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • 2.2.14
    • N/A
    • dbfwfilter, qc_sqlite
    • None
    • 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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MXS-2210 Query with brackets classify as unknown

          • Major - Major loss of function.
          • Closed

          Activity

            People

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