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

Add support for EXCEPT

Details

    Description

      Add support for EXCEPT clause

      The EXCEPT clause has this general form:

      select_statement EXCEPT select_statement

      select_statement is any SELECT statement without an ORDER BY, LIMIT, or FOR UPDATE clause.

      The EXCEPT operator computes the set of rows that are in the result of the left SELECT statement but not in the result of the right one.

      The result of EXCEPT does not contain any duplicate rows unless the ALL option is specified. With ALL, a row that has m duplicates in the left table and n duplicates in the right table will appear max(m-n,0) times in the result set.

      Attachments

        Issue Links

          relates to

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-10137 Providing compatibility to other databases

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-11953 support of brackets (parentheses) in UNION/EXCEPT/INTERSECT operations

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13231 Server crashes in _ma_unique_hash upon EXCEPT or INTERSECT with ORDER BY MATCH

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13230 Information about EXCEPT ALL is inconsistent between KB, JIRA, code and tests

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            Epic Link MDEV-10137 [ 56868 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility
            alvinr Alvin Richards (Inactive) made changes -
            Epic Link MDEV-10137 [ 56868 ] MDEV-10872 [ 58182 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.2 [ 14601 ]
            alvinr Alvin Richards (Inactive) made changes -
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility Compatibility NRE-307517
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin added a comment -

            All common code and preparations will be done under MDEV-10141

            sanja Oleksandr Byelkin added a comment - All common code and preparations will be done under MDEV-10141
            sanja Oleksandr Byelkin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            alvinr Alvin Richards (Inactive) made changes -
            NRE Projects NRE-307517
            alvinr Alvin Richards (Inactive) made changes -
            Labels Compatibility NRE-307517 Compatibility
            sanja Oleksandr Byelkin made changes -
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Michael Widenius [ monty ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Michael Widenius [ monty ] Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Component/s Optimizer [ 10200 ]
            Fix Version/s 10.3.0 [ 22127 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            alvinr Alvin Richards (Inactive) made changes -
            NRE Approved Yes [ 10304 ]
            bar Alexander Barkov made changes -
            Component/s Parser [ 10201 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility 10.3-beta Compatibility
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            sanja Oleksandr Byelkin made changes -
            Description Add support for EXCEPT clause

            The EXCEPT clause has this general form:

            select_statement EXCEPT [ ALL ] select_statement

            select_statement is any SELECT statement without an ORDER BY, LIMIT, or FOR UPDATE clause.

            The EXCEPT operator computes the set of rows that are in the result of the left SELECT statement but not in the result of the right one.

            The result of EXCEPT does not contain any duplicate rows unless the ALL option is specified. With ALL, a row that has m duplicates in the left table and n duplicates in the right table will appear max(m-n,0) times in the result set.
            		Add support for EXCEPT clause

            The EXCEPT clause has this general form:

            select_statement EXCEPT select_statement

            select_statement is any SELECT statement without an ORDER BY, LIMIT, or FOR UPDATE clause.

            The EXCEPT operator computes the set of rows that are in the result of the left SELECT statement but not in the result of the right one.

            The result of EXCEPT does not contain any duplicate rows unless the ALL option is specified. With ALL, a row that has m duplicates in the left table and n duplicates in the right table will appear max(m-n,0) times in the result set.
            sanja Oleksandr Byelkin added a comment - - edited

            ALL is not standard option

            sanja Oleksandr Byelkin added a comment - - edited ALL is not standard option
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 75810 ] MariaDB v4 [ 132885 ]

            People

              sanja Oleksandr Byelkin
              monty Michael Widenius
              Votes:
              2 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.