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

Implement EXCEPT ALL and INTERSECT ALL operations

    XMLWordPrintable

    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

          Activity

            People

            Assignee:
            igor Igor Babaev
            Reporter:
            igor Igor Babaev
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: