Bug #110499 SQL editor underlining EXCEPT but execution of the query doesn't fail
Submitted: 25 Mar 2023 7:56 Modified: 26 Mar 2023 7:45
Reporter: Pietro Bembo Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.32 OS:Windows (Microsoft Windows 11 Home)
Assigned to: CPU Architecture:x86
Tags: WBBugReporter

[25 Mar 2023 7:56] Pietro Bembo 
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\user\AppData\Roaming\MySQL\Workbench\log\wb.log]

Execution doesn't fail, but EXCEPT is underlined("EXCEPT" is not valid at this position, expecting EOF, ';') and the editor thinks there is an error, showing a red cross.

How to repeat:
Using EXCEPT clause with two compatible tables. 
In any database:

CREATE TABLE a(
     Attr1 int);

CREATE TABLE b(
    Attr1 int);

INSERT INTO a VALUES
(2),
(8),
(9);

INSERT INTO b VALUES
(2),
(8);

SELECT * FROM a EXCEPT SELECT * FROM b;
[26 Mar 2023 7:45] MySQL Verification Team 
Hello Pietro Bembo,

Thank you for the report and feedback.

regards,
Umesh