Bug #78930 Support for LATERAL (SQL:1999)
Submitted: 22 Oct 2015 19:50 Modified: 8 Feb 2018 14:43
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S4 (Feature request)
Version:5.7, 8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: SQL:1999, STANDARDS
Triage: Needs Triage: D5 (Feature request)

[22 Oct 2015 19:50] Daniël van Eeden
Description:
Please add support for LATERAL derived tables.

https://oracle-base.com/articles/12c/lateral-inline-views-cross-apply-and-outer-apply-join...
https://docs.oracle.com/database/121/SQLRF/statements_10002.htm#SQLRF01702

This is to increase compatibility with other databases

How to repeat:
See description.
[22 Oct 2015 19:51] Daniël van Eeden
Also improves SQL Server compatibility:
https://msdn.microsoft.com/en-us/library/hh544587%28v=sql.105%29.aspx
[22 Oct 2015 19:53] Daniël van Eeden
It is about this feature:
Feature T491, "LATERAL derived table"

My previous comment about SQL Server was wrong. This is not supported in SQL Server.
[8 Dec 2017 14:04] Daniël van Eeden
Added 8.0
[8 Feb 2018 14:43] Umesh Shastry
Hello Daniël,

Thank you for the feature request!

Thanks,
Umesh