[MDEV-11050] Reuse temporary tables created for materialized CTE tables Created: 2016-10-13  Updated: 2023-12-05

Status: Stalled
Project: MariaDB Server
Component/s: Optimizer - CTE
Fix Version/s: None

Type: Task Priority: Major
Reporter: Igor Babaev Assignee: Igor Babaev
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-19656 MariaDB behaviour with many JOINs Open

 Description   

Currently a separate temporary table is created for every reference of the same materialized CTE table.
The goal of this task is to use one temporary table for all references of the same CTE table.
Generated at Thu Feb 08 07:46:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.