Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
6.1.1
-
None
-
2021-17
Description
A Variant from MCOL-1205 , it works not, if in the from clause is a view.
To reproduce:
drop table if exists t1,t2; |
create table t1 (i int) engine=columnstore; |
create table t2 (i int) engine=columnstore; |
drop view if exists v1; |
CREATE VIEW v1 AS select t1.* from t1 left join t2 on t1.i = t2.i;
|
|
select * from t1
|
join t2 on t1.i = t2.i
|
join v1 on t2.i = v1.i
|
and t1.i = v1.i;
|
# trigger circular join error
|
|
|
select * from t1 join t2 on t1.i = t2.i join v1 on t2.i = v1.i ;
|
works normal
|