Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
- Posts: 1
- Joined: Sun 05 May 2019 15:32
The syntax parser doesn't seem to recognize EXCEPT, INTERSECT, but understands UNION and UNION ALL.
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
SELECT a.* FROM table2 o JOIN table1 a ON a.uuid = o.uuid
WHERE o.m_id = @o;
These are not recognized,
But this works
These keywords were added two years ago with MariaDB 10.3, so I'm a bit surprised.
- Devart Team
- Posts: 2856
- Joined: Fri 24 Jun 2011 14:17
We will fix this issue in one of the next product builds and will notify you once it's available for downloading.