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

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.

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.

Hello Georgi,

Thank you for the report and feedback!

regards,
Umesh

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.

Verified fixed. Thanks.

Page generated in 0.054 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.