databend icon indicating copy to clipboard operation
databend copied to clipboard

bug: lateral will generate same column index

Open Dousir9 opened this issue 2 years ago • 0 comments

Summary

SQL:

drop table if exists t;
drop table if exists t1;
create table t(a int);
create table t1(a int);
insert into t values(1),(2),(3);
insert into t1 values(1),(2),(3);
select * from t, lateral(select * from t1 where t1.a = t.a) t2;

Dousir9 avatar Jan 26 '24 09:01 Dousir9