MySQL Bugs: #97416: EXPLAIN ANALYZE shows syntax error in SQL editor

Bug #97416	EXPLAIN ANALYZE shows syntax error in SQL editor
Submitted:	29 Oct 2019 13:08	Modified:	14 Jan 7:30
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

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.

Screenshot with the error on EXPLAIN ANALYZE

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

Hello Georgi Sotirov,

Thank you for the report and feedback.

regards,
Umesh

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.

Verified fixed in Workbench 8.0.19 released yesterday.