Bug #1309 EXCEPT statement

Submitted: 16 Sep 2003 13:51 Modified: 21 Oct 2022 12:35
Reporter: Mauro Moura Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DML Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[16 Sep 2003 13:51] Mauro Moura 
Description:
The EXCEPT statement would very useful, since it plays an important role in relational algebra, corresponding to DIFERENCE which is one of the five elementar operations.

    Thanks,
        Mauro

How to repeat:
It's not a bug, so you can't repeat it.
[26 Nov 2005 11:59] Valeriy Kravchuk 
Thank you for a feature request. 

SQL 2003 Standard prescribes to support UNION, EXCEPT and INTERSECT relational operators in SELECT statements. I belive that one day MySQL will support them all, not only UNION [ALL].
[3 Jan 2008 15:38] Susanne Ebrecht 
Bug #33200 is a duplicate of this bug here.
[21 Oct 2022 12:35] Jon Stephens 
Fixed in MySQL 8.0.31 by WL#349.

Closed.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.