| 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: | |
| Category: | MySQL Server: DML | Severity: | S4 (Feature request) |
| Version: | OS: | Any | |
| Assigned to: | CPU Architecture: | Any | |
[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.
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.