Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
None
Description
I just found out that MINUS and INTERSECT queries work when you do this:
MariaDB [MY_DB]> select pers_id, pers_first_name from PERSONS minus select pers_id, pers_first_name from PERSONS1;
|
+---------+-----------------+
|
| pers_id | pers_first_name |
|
+---------+-----------------+
|
| 3 | Edward |
|
+---------+-----------------+
|
1 row in set (0.000 sec)
|
There should be no reason to require sql_mode=oracle for this kind of query because the syntax does not conflict with anything that mariadb's standard SQL engine does.