[MDEV-32283] CTE renaming columns too early in union subquery elements - Jira

XML

Word

Printable

with cte (c1,c2) as (select a, b from t1 union select a, b from t1 order by a ) select * from cte;

provokes an error

ERROR 1054 (42S22): Unknown column 'a' in 'order clause'

Where both of these do not

select a, b from t1 union select a, b from t1 order by a;

with cte (c1,c2) as (select * from (select a, b from t1 union select a, b from t1 order by b) tt ) select * from cte;

is blocked by

MDEV-26831 New name resolution

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