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

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5, 10.4.12, 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.2.38, 10.3.29, 10.4.19, 10.5.10
Component/s: Optimizer - CTE
Labels:
- CTE
- union

Description

The bug described in ~~MDEV-15478~~ is not fully resolved. When the CTE is used again with UNION in the main statement, it gives error #1054 - Unknown column 'col1' in 'field list'

WITH cte (col1) AS

  SELECT 1

  UNION

  SELECT 2

SELECT col1 FROM cte

-- union statement added to example in MDEV-15478

UNION

SELECT col1 FROM cte

This can currently be worked around with:

WITH cte (col1) AS

  SELECT 1 AS col1 -- alias required

  UNION

  SELECT 2

SELECT col1 FROM cte

UNION

SELECT col1 FROM cte

Attachments

Issue Links

relates to

MDEV-15478 Explicit column name error in CTE of UNION

Closed

Activity

People

Assignee:: Igor Babaev

Reporter:: Tarrin Wills

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2021-01-15 06:47

Updated:: 2021-03-11 18:02

Resolved:: 2021-03-11 18:02

Git Integration

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