MariaDB: INTERSECT and EXCEPT keywords

[ibennetch]

MariaDB 10.3 will introduce the INTERSECT and EXCEPT keywords.

./lint-query --query "(SELECT a,b FROM t1) INTERSECT (SELECT c,d FROM t2)"
#1: Unexpected token. (near "INTERSECT" at position 21)
#2: Unexpected token. (near "(" at position 31)
#3: This type of clause was previously parsed. (near "SELECT" at position 32)
#4: Unexpected token. (near ")" at position 50)

and

./lint-query --query "(SELECT a,b FROM t1) EXCEPT (SELECT c,d FROM t2)"
#1: Unexpected token. (near "EXCEPT" at position 21)
#2: Unexpected token. (near "(" at position 28)
#3: This type of clause was previously parsed. (near "SELECT" at position 29)
#4: Unexpected token. (near ")" at position 47)

As far as I've been able to tell, MySQL has no plans to implement either of these at this time.