Syntax support for EXCEPT and INTERSECT ?

[rithban]

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
    EXCEPT 
    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.
https://mariadb.com/kb/en/library/except/
https://mariadb.com/kb/en/library/intersect/

[alexa]

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

[alexa]

We would like to let you know that we have released dbForge Studio for MySQL, v8.2 where the issue you reported is fixed https://www.devart.com/dbforge/mysql/st ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.