Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
Description
SQL> SELECT first_name, last_name FROM user
-> MINUS
-> SELECT first_name, last_name FROM customer
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT first_name, last_name FROM customer' at line 3
SQL> SELECT first_name, last_name FROM user
-> EXCEPT
-> SELECT first_name, last_name FROM customer
-> ;
OK
Official Oracle documentation does not even mention the EXCEPT clause. So it is quite probable that many of those statements exist in real world...
https://en.wikipedia.org/wiki/Set_operations_(SQL)#EXCEPT_operator
https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries004.htm