Bug #98263 Workbench editor shows syntax error on VALUES statement

• Submitted: 17 Jan 2020 8:56
• Modified: 1 Apr 2020 15:55
• 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 8:56] Georgi Sotirov

Description:
Workbench SQL Editors shows syntax error on any query using the new VALUES statement (see https://dev.mysql.com/doc/refman/8.0/en/values.html) like the simple one below:

VALUES ROW(1), ROW(2), ROW(3);

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

"VALUES" 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 query VALUES ROW(1), ROW(2), ROW(3); in Workbench SQL editor.
2. Observe the reported syntax error on VALUES.

Suggested fix:
There should not be syntax error on VALUES statement.

[17 Jan 2020 8:56] Georgi Sotirov

Syntax error on values statement

Attachment: wb_values_error.png (image/png, text), 12.06 KiB.

[17 Jan 2020 9:09] MySQL Verification Team

Hello Georgi Sotirov,

Thank you for the report!

Thanks,
Umesh

[1 Apr 2020 15:55] 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.