Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11953

support of brackets (parentheses) in UNION/EXCEPT/INTERSECT operations

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.4.0
    • Parser
    • None
    • 10.1.32, 10.3.6-1, 10.4.0-1

    Description

      Add suport of brackets which mean priority of operation in the parser:

      ((SELECT a from t1) union (SELECT b from t2)) intersect (select c from t3)

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22595 INSERT .. VALUES allows undocumented optional ORDER BY and LIMIT clauses but ignores them

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35193 Results of queries depending on user variables are written into and hit the query cache

          • Major - Major loss of function.
          • Open
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-6341 INSERT ... SELECT UNION with parenthesis

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10028 Syntax error on ((SELECT ...) UNION (SELECT ...))

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-10140 Add support for EXCEPT

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-10141 Add support for INTERSECT (and common parts for EXCEPT)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14347 CREATE PROCEDURE returns no error when using an unknown variable

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15870 Using aggregate and window function in unexpected places can crash the server

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16357 LIMIT and ORDER BY clause is ignored on a query with UNION when using brackets

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20606 Union with parentheses and IN()

          • Major - Major loss of function.
          • Closed

          Activity

            People

              sanja Oleksandr Byelkin
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.