Bug #97416 EXPLAIN ANALYZE shows syntax error in SQL editor
Submitted: 29 Oct 13:08 Modified: 30 Oct 14:47
Reporter: Georgi Sotirov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.18 OS:Microsoft Windows
Assigned to: CPU Architecture:x86

[29 Oct 13:08] Georgi Sotirov
Description:
A statement prefixed with EXPLAIN ANALYZE shows syntax error in Workbench's SQL editor although the statement is executed without a problem.

How to repeat:
1. Paste the following statement into SQL editor:

EXPLAIN ANALYZE
SELECT * FROM emp;

2. EXPLAIN keyword is highlighted with red curved underline and moving the mouse over it shows: "EXPLAIN" is not valid at this position for this server version, expecting: HELP, DESC, USE, RESTART

Suggested fix:
No syntax error on EXPLAIN ANALYZE.
[29 Oct 13:09] Georgi Sotirov
Screenshot with the error on EXPLAIN ANALYZE

Attachment: wb_explain_analyze_err.png (image/png, text), 6.95 KiB.

[29 Oct 13:17] Umesh Shastry
Hello Georgi Sotirov,

Thank you for the report and feedback.

regards,
Umesh
[30 Oct 14:47] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.19 release, and here's the changelog entry:

The SQL editor applied syntax-error highlighting to the EXPLAIN keyword in
a valid statement prefixed with EXPLAIN ANALYZE, but the statement
executed as expected.

Thank you for the bug report.