Bug #94012 MySQL Workbench 8.0.14 doesn't support LATERAL keyword
Submitted: 23 Jan 2019 8:11 Modified: 18 May 2019 10:31
Reporter: Georgi Sotirov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.14 OS:Windows (Windows 10 Pro)
Assigned to: CPU Architecture:x86

[23 Jan 2019 8:11] Georgi Sotirov 
Description:
With the release of MySQL Community Server 8.0.14 a new keyword LATERAL is supported to allow for lateral derived tables. Unfortunately, the keyword is not properly colored as a keyword and there is a syntax error after it (see attached screenshot) although the query is OK and executes successfully on the server.

How to repeat:
1. Open SQL Editor.
2. Write a query with LATERAL keyword.

Suggested fix:
LATERAL keyword should be properly colored as a keyword and there shouldn't be a syntax error after it.
[23 Jan 2019 8:14] Georgi Sotirov 
A screen shot of SQL Editor in Workbench 8.0.14 with LATERAL keyword not colored properly and a syntax error after it

Attachment: wb-8.0.14-lateral.png (image/png, text), 7.60 KiB.
[23 Jan 2019 10:11] MySQL Verification Team 
Hello Georgi,

Thank you for the report and feedback!

regards,
Umesh
[28 Feb 2019 20:00] Christine Cole 
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.16 release, and here's the changelog entry:

The LATERAL keyword now conforms with the SQL editor convention to
highlight and indent the words considered keywords by MySQL.

Thank you for the bug report.
[18 May 2019 10:31] Georgi Sotirov 
Verified fixed. Thanks.