Bug #114790 MySQL Workbench falsely reports the INTERSECT clause as a syntax error
Submitted: 25 Apr 2024 16:07 Modified: 29 Apr 2024 12:46
Reporter: Robert Light Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.36, 8.0.40, 8.0.42 OS:Any
Assigned to: CPU Architecture:Any

[25 Apr 2024 16:07] Robert Light 
Description:
This version of MySQL workbench falsely reports an INTERSECT between two select statements as a syntax error with a red X. The command will still run and return the expected result but the syntax parser does not recognize this as valid.

How to repeat:
Any intersect between two selects should demonstrate the issue.

Suggested fix:
The syntax parser should correctly recognize the SQL clauses added in MySQL 8.0.31.
[29 Apr 2024 12:46] MySQL Verification Team 
Hello Robert,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil
[13 Jan 7:28] MySQL Verification Team 
Bug #117185	marked as duplicate of this one
[22 May 11:53] MySQL Verification Team 
Bug #118243 marked as duplicate of this one