Syntax support for EXCEPT and INTERSECT ?

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
rithban
Posts: 1
Joined: Sun 05 May 2019 15:32

Syntax support for EXCEPT and INTERSECT ?

Post by rithban » 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,

Image

Image

But this works

Image

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
Devart Team
Posts: 2856
Joined: Fri 24 Jun 2011 14:17

Re: Syntax support for EXCEPT and INTERSECT ?

Post by alexa » 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.

alexa
Devart Team
Posts: 2856
Joined: Fri 24 Jun 2011 14:17

Re: Syntax support for EXCEPT and INTERSECT ?

Post by alexa » 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.

Post Reply