Bug #97416 EXPLAIN ANALYZE shows syntax error in SQL editor

Submitted: 29 Oct 2019 13:08 Modified: 14 Jan 2020 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:Windows
Assigned to: CPU Architecture:x86

[29 Oct 2019 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 2019 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 2019 13:17] MySQL Verification Team
Hello Georgi Sotirov,

Thank you for the report and feedback.

regards,
Umesh
[30 Oct 2019 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.
[14 Jan 2020 7:30] Georgi Sotirov
Verified fixed in Workbench 8.0.19 released yesterday.
[11 Jul 2021 20:42] Runfeng Li
Using mysql workbench 8.0.25 on mac, the same syntax error happens again.
[12 Jul 2021 4:23] Runfeng Li
Never mind! We just noticed that we were using 5.7. After changing to 8.0, the command is working now.
[12 Feb 2025 7:41] Shoaib Muhammad
I am getting the error in MySQL Workbench 8.0.32. EXPLAIN ANALYZE is not working
[21 Jul 2025 6:41] Murugan G
Mac Workbench 8.0.42 community - explain analyze throws syntax error

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.