Status: Open (View Workflow)
The SQL standard defines the LATERAL keyword, which can be found on
LATERAL combined with joins are very useful, because you can reference columns in the left hand side from the right hand side. A good use case is the following. Let's say you have Posts and Comments and you want the first three comments for each post.
SELECT * FROM Posts CROSS JOIN LATERAL (SELECT * FROM Comments WHERE Comments.PostID = Posts.ID LIMIT 3)
That works in PostgreSQL. SQL Server instead has APPLY which is similar.
If this will be supported, Entity Framework will work much better with MariaDB. EF expects that the database has support for these kind of queries, so some queries make the EF provider throw an exception when used with MySQL/MariaDB.
Both Oracle and PostgreSQL has recently implemented support. MariaDB should too
- is part of
MDEV-19078 Support lateral derived tables