[#MDEV-32119] CTE table is created with wrong column name if column name

[MDEV-32119] CTE table is created with wrong column name if column name > 64 symbols Created: 2023-09-07 Updated: 2023-11-28
Status:	Open
Project:	MariaDB Server
Component/s:	Optimizer - CTE
Affects Version/s:	10.4, 10.5, 10.6, 10.10, 10.11, 11.0, 11.1, 11.2, 11.3
Fix Version/s:	10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3

Type:

Bug

Priority:

Major

Reporter:

Lena Startseva

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

None

Issue Links:

Relates
relates to	MDEV-27871	View is created with wrong column nam...	Stalled
relates to	MDEV-31004	Create cte-protocol	Stalled

Description

If column name less or equal 64 symbols is everything Ok:

with cte as (

select 1111

) select * from cte;

But if column name more than 64 symbols the column name changes to "Name_exp_1":

with cte as (

select 11111111111111111111111111111111111111111111111111111111111111111

) select * from cte;

Name_exp_1

11111111111111111111111111111111111111111111111111111111111111111

Generated at Thu Feb 08 10:28:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.