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
| Field | Original Value | New Value |
|---|---|---|
| Labels | Cinoa |
| Labels | Cinoa | Compatibility |
| Labels | Compatibility | Compatibility need_feedback |
| Labels | Compatibility need_feedback | Compatibility |
| Attachment | 10.6-minus.path [ 55504 ] |
| Fix Version/s | 10.6 [ 24028 ] |
| Assignee | Michael Widenius [ monty ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2021-05-20 09:28:55.0 | 2021-05-20 09:28:55.941 |
| Component/s | Server [ 13907 ] | |
| Fix Version/s | 10.6.1 [ 24437 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 98147 ] | MariaDB v4 [ 156464 ] |