[MCOL-4892] "unknown column" in nested subselects with alias columns Created: 2021-10-08  Updated: 2023-11-17  Resolved: 2022-05-04

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 5.6.2
Fix Version/s: 6.4.1

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: Denis Khalikov
Resolution: Not a Bug Votes: 1
Labels: None


 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

 Comments   
Comment by alexey vorovich (Inactive) [ 2022-05-04 ]

denis0x0D thnks for detailed checking

toddstoffel see above. What should we do ? close this ?

Generated at Thu Feb 08 02:53:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.