Implement SQL standard Common Table Expression (CTE) support (MDEV-8308)

[MDEV-8789] Implement non-recursive common table expressions Created: 2015-09-10  Updated: 2017-09-22  Resolved: 2016-09-12

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: None
Fix Version/s: 10.2.0

Type: Technical task Priority: Major
Reporter: Igor Babaev Assignee: Igor Babaev
Resolution: Fixed Votes: 3
Labels: Compatibility, contribution

Issue Links:
Relates
relates to MDEV-5535 cannot reopen temporary table Closed

 Description   

Support for WITH:
This allows you to refer to a sub query as a table.

Example:
with t as (select a from t1 where b >= 'c')
select * from t2,t where t2.c=t.a

 Comments   
Comment by Sergei Petrunia [ 2015-12-08 ]

while working on this, it was discovered that MDEV-3944 can be trivially fixed.
Decided to make a separate patch for MDEV-3944 and submit it for testing.

Comment by Igor Babaev [ 2016-04-02 ]

The contribution was merged with 10.2 and pushed into the 10.2 tree.

Generated at Thu Feb 08 07:29:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.