Devart Forums

Posted: **Sun 05 May 2019 15:58**

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/

Posted: **Mon 06 May 2019 07:05**

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

Posted: **Mon 02 Sep 2019 08:13**

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.

Devart Forums

Syntax support for EXCEPT and INTERSECT ?

Syntax support for EXCEPT and INTERSECT ?

Re: Syntax support for EXCEPT and INTERSECT ?

Re: Syntax support for EXCEPT and INTERSECT ?