Bug #98266 Workbench editor shows syntax error on TABLE statement

• Submitted: 17 Jan 2020 9:59
• Modified: 1 Apr 2020 15:56
• Reporter: Georgi Sotirov
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 8.0.19
• OS: Windows
• CPU Architecture: x86

[17 Jan 2020 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 2020 10:00] Georgi Sotirov

Syntax error on table statement

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

[17 Jan 2020 10:11] MySQL Verification Team

Hello Georgi Sotirov,

Thank you for the report!

Thanks,
Umesh

[1 Apr 2020 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.