[MDEV-15478] Explicit column name error in CTE of UNION - Jira

XML

Word

Printable

WITH cte (col1) AS

  SELECT 1

  UNION

  SELECT 2

SELECT col1 FROM cte;

ERROR 1054 (42S22): Unknown column 'col1' in 'field list'

Query succeeds.

It works without UNION:

WITH cte (col1) AS

  SELECT 1

SELECT col1 FROM cte;

+------+

| col1 |

+------+

|    1 |

+------+

relates to

MDEV-24597 Explicit column name error in CTE of UNION

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