Bug #78930 Support for LATERAL (SQL:1999)
Submitted: 22 Oct 2015 19:50 Modified: 30 Jul 2019 15:14
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed 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

[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] MySQL Verification Team 
Hello Daniël,

Thank you for the feature request!

Thanks,
Umesh
[30 Jul 2019 15:14] Guilhem Bichot 
Posted by developer:
 
Feature implemented in 8.0:
https://mysqlserverteam.com/support-for-lateral-derived-tables-added-to-mysql-8-0-14/
[6 Jan 2021 21:20] Tanveer Ahmed 
Description:
Please add support for LATERAL derived tables.

https://isqlplus.com/sql-server/auto-growth-and-sizing-of-transaction-log/
https://isqlplus.com/mongodb/sharding-06-working-with-sharded-cluster/
https://isqlplus.com/oracle/asm/asm-disk-groups/

This is to increase compatibility with other databases