Bug #1309 EXCEPT statement

• Submitted: 16 Sep 2003 15:51
• Modified: 26 Nov 2005 12:59
• Reporter: Mauro Moura
• Status: Verified
• Category: Server: DML
• Severity: S4 (Feature request)
• OS: Any
• Triage: Triaged: D5 (Feature request)

[16 Sep 2003 15: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 12: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 16:38] Susanne Ebrecht

Bug #33200 is a duplicate of this bug here.