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

Query with brackets classify as unknown

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.2.12
    • 2.4.0
    • qc_sqlite
    • None

    Description

      example:
      1. (select 1)
      2. (SELECT *,'buy' FROM order_coin WHERE buy_uid =803 and `coin_from` = 'cc' AND `coin_to` = 'usdt') UNION ALL (SELECT * ,'sale' FROM order_coin WHERE sale_uid = 803 and `coin_from` = 'cc' AND `coin_to` = 'usdt') ORDER BY created desc limit 0,30；

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MXS-2065 Query could not be tokenized due to round bracket.

          • Major - Major loss of function.
          • Closed

          Activity

            People

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