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

Implement EXCEPT ALL and INTERSECT ALL operations

Details

    Description

      SQL Standard allows to use EXCEPT ALL and INTERSECT ALL as set operations.
      Currently MariaDB Server does not support them.

      The goal of this task is to support EXCEPT ALL and INTERSECT ALL
      1. at syntax level - allow to use operators EXCEPT ALL and INTERSECT ALL in query expression body
      2. at execution level - implement these operations employing temporary tables
      (the implementation could use the idea similar to that used for the existing implementation of the INTERSECT operation).

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25158 Segfault on INTERSECT ALL with UNION in Oracle mode

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21716 Document EXCEPT ALL and INTERSECT ALL operations

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24242 Query returns wrong result while using big_tables=1;

          • Major - Major loss of function.
          • Closed

          Activity

            People

              igor Igor Babaev (Inactive)
              igor Igor Babaev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.