[MCOL-4892] "unknown column" in nested subselects with alias columns - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Not a Bug
Affects Version/s: 5.6.2
Fix Version/s: 6.4.1
Component/s: ?
Labels:
- digicert
- mcs_cs_amdocs

Description

To reproduce

create table t1 (c1 int, c2 int) engine=columnstore;

select calias,c2 from (select c1  ,c2 from (select c1,c2 Calias from t1)A2) A1;

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

Client would like this query to complete

Attachments

Activity

People

Assignee:: Denis Khalikov

Reporter:: Richard Stracke

Votes:: 1 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2021-10-08 05:03

Updated:: 2022-06-22 19:20

Resolved:: 2022-05-04 17:59

Git Integration

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