Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
This is already available in MariaDB as "EXCEPT"
returns the Result of the query 1 that is not found in the result of query 2
MariaDB [world]> select * From City where id between 456 and 457 except select * from City where id=456; |
+-----+------------+-------------+----------+------------+
|
| ID | Name | CountryCode | District | Population |
|
+-----+------------+-------------+----------+------------+
|
| 457 | Birmingham | GBR | England | 1013000 | |
+-----+------------+-------------+----------+------------+
|
Oracle Doc: https://www.techonthenet.com/oracle/minus.php
Attachments
Activity
Yes, a synonym, as Oracle's MINUS is the equivalent of EXCEPT [DISTINCT]
the patch in attachment is mapping MINUS to EXCEPT, please review it. thanks!
Faisal Is the task to support the MINUS keyword as a synonym to EXCEPT in this context?
Or does Oracle's MINUS work somehow differently from MariaDB EXCEPT?