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
            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 added a comment - - edited

            ALL is not standard option

            sanja Oleksandr Byelkin added a comment - - edited ALL is not standard option

            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.