Bug #98266 Workbench editor shows syntax error on TABLE statement
Submitted: 17 Jan 9:59 Modified: 1 Apr 15:56
Reporter: Georgi Sotirov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.19 OS:Microsoft Windows
Assigned to: CPU Architecture:x86

[17 Jan 9:59] Georgi Sotirov
Description:
Workbench SQL Editor shows syntax error on any query using the new TABLE statement (see https://dev.mysql.com/doc/refman/8.0/en/table.html) like the simple one below:

CREATE TABLE t1 (n INT, s VARCHAR(10));
TABLE t1;

The SQL editor shows the following syntax error (see also attached screenshot) on TABLE:

"TABLE" is not valid at this position, expecting EOF, BEGIN, CACHE, CHECKSUM, COMMIT, DEALLOCATE, ...

but the query is valid and executed by the server.

How to repeat:
1. Enter the following in SQL Editor:

CREATE TABLE t1 (n INT, s VARCHAR(10));
TABLE t1;

2. Note the error on TABLE statement.

Suggested fix:
There should not be syntax error on TABLE statement.
[17 Jan 10:00] Georgi Sotirov
Syntax error on table statement

Attachment: wb_table_error.png (image/png, text), 12.94 KiB.

[17 Jan 10:11] Umesh Shastry
Hello Georgi Sotirov,

Thank you for the report!

Thanks,
Umesh
[1 Apr 15:56] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.21 release, and here's the proposed changelog entry from the documentation team:

Valid TABLE and VALUES statements were identified as having syntax errors
in the SQL editor.

Thank you for the bug report.