[MDEV-32119] CTE table is created with wrong column name if column name > 64 symbols - Jira

XML

Word

Printable

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

relates to

MDEV-27871 View is created with wrong column name if column name > 64 symbols

MDEV-31004 Create cte-protocol

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.