Bug #118243 EXCEPT and INTERSECT not in autocomplete word list
Submitted: 21 May 17:55 Modified: 22 May 16:33
Reporter: Earl Kirkland Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.42 OS:Windows (Windows 11)
Assigned to: CPU Architecture:Any (Intel i9)
Tags: autocomplete, except, intersect, workbench

[21 May 17:55] Earl Kirkland 
Description:
In workbench, if you are coding a compound query, only the UNION set operator is in the list of keywords.  The EXCEPT and INTERSECT are implemented, but those keywords are not in the dropdown code completion list.

Note that the EXCEPT and INTERSECT set operators work in the Workbench even though there is a red 'X' on the line of the set operator.

I am a college teacher and this is definitely confusing my students.

How to repeat:
Write a compound query.  Format your code so that the set operator (EXCEPT or INTERSECT) is on its own line.  You will see the red 'X' in the margin.  If you execute the query, it will run normally.

If I could upload an image, I would.

Suggested fix:
Add the two set operators to your list of other operators and keywords.
[22 May 11:52] MySQL Verification Team 
Hello Earl Kirkland,

Thank you for the report and feedback.
IMHO this is duplicate of Bug #114790, please see Bug #114790.

Regards,
Ashwini Patil
[22 May 16:33] Earl Kirkland 
Supposedly, this is a duplicate of #114790.  How ever that bug only state a problem with the INTERSECT operator and doesn't mention the EXCEPT operator.  It does say that all operators added in the 8.0.31 version.  

Please don't forget the EXCEPT operator as well.