MySQL Bugs: #114790: MySQL Workbench falsely reports the INTERSECT clause as a syntax error

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

Hello Robert,

Thank you for the bug report.
Verified as described.

Regards,
Ashwini Patil