Is this a bug or am I missing something obvious?
Code: Select all
SELECT a.* FROM table2 n JOIN table1 a ON a.uuid = n.uuid
WHERE n.m_id = @n
EXCEPT
SELECT a.* FROM table2 o JOIN table1 a ON a.uuid = o.uuid
WHERE o.m_id = @o;
But this works
These keywords were added two years ago with MariaDB 10.3, so I'm a bit surprised.
https://mariadb.com/kb/en/library/except/
https://mariadb.com/kb/en/library/intersect/