[MDEV-18844] Implement EXCEPT ALL and INTERSECT ALL operations - Jira

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Fix Version/s: 10.5.0
Component/s: Optimizer
Labels:
- gsoc19

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

MDEV-25158 Segfault on INTERSECT ALL with UNION in Oracle mode

Stalled

relates to

MDEV-21716 Document EXCEPT ALL and INTERSECT ALL operations

Closed

MDEV-24242 Query returns wrong result while using big_tables=1;

Closed

Activity

Transition	Time In Source Status	Execution Times

Igor Babaev (Inactive) made transition - 2019-06-23 18:00

Open

In Progress

108d 11h 57m

Igor Babaev (Inactive) made transition - 2019-06-30 03:13

In Progress

Stalled

6d 9h 12m

Igor Babaev (Inactive) made transition - 2019-09-10 18:35

Stalled

Closed

72d 15h 21m

People

Assignee:: Igor Babaev (Inactive)

Reporter:: Igor Babaev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2019-03-07 06:03

Updated:: 2025-04-30 22:07

Resolved:: 2019-09-10 18:35

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.