dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Support `LATERAL` derived tables

Open knutwannheden opened this issue 3 years ago • 2 comments

MySQL 8.0.14 added support for lateral derived tables (see https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-14.html#mysqld-8-0-14-sql-syntax). This is a very useful feature which would be nice to have support for in Dolt.

This may be more work, but since there is now support for JSON_TABLE() which is implicitly laterally joined, maybe it is not too far out of reach.

knutwannheden avatar Aug 17 '22 19:08 knutwannheden

Maybe one step closer now with #4340.

knutwannheden avatar Sep 21 '22 01:09 knutwannheden

Yet one step closer with #4534 :-)

knutwannheden avatar Oct 26 '22 02:10 knutwannheden

We're tracking progress on this with https://github.com/dolthub/dolt/issues/6194, going to close this as a duplicate.

nicktobey avatar Aug 07 '23 20:08 nicktobey