[MCOL-3477] Outer queries return "Circular joins are not supported" error Created: 2019-09-04  Updated: 2019-11-26  Resolved: 2019-11-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.4.0
Fix Version/s: 1.4.1

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2019-06

 Description   

Build tested: 1.4.0-1

[dlee@master centos7]$ cat gitversionInfo.txt
server commit:
67452bc
engine commit:
4d2a159

Autopilot test case: features.outerJoin

This test works in 1.2.4-1

The following queries returned "Internal error: IDB-1003: Circular joins are not supported."

select * from t1
join t2 on t1.c=t2.c
join t3 on t2.c=t3.c
join t4 on t1.c=t4.c
order by 4;
#
select * from t1
join t2 on t1.c=t2.c
join t3 on t2.c=t3.c
left join t4 on t1.c=t4.c
order by 4;
#
select * from t1
join t2 on t1.c=t2.c
left join t3 on t2.c=t3.c
join t4 on t1.c=t4.c
order by 4;
#
select * from t1
join t2 on t1.c=t2.c
right join t3 on t2.c=t3.c
join t4 on t1.c=t4.c
order by 4;
#
select * from t1
left join t2 on t1.c=t2.c
join t3 on t2.c=t3.c
join t4 on t1.c=t4.c
order by 4;
#
select * from t1
left join t2 on t1.c=t2.c
join t3 on t2.c=t3.c
left join t4 on t1.c=t4.c
order by 4;
#
select * from t1
left join t2 on t1.c=t2.c
right join t3 on t2.c=t3.c
join t4 on t1.c=t4.c
order by 4;
#
select * from t1
right join t2 on t1.c=t2.c
join t3 on t2.c=t3.c
join t4 on t1.c=t4.c
order by 4;
#
select * from t1
right join t2 on t1.c=t2.c
left join t3 on t2.c=t3.c
join t4 on t1.c=t4.c
order by 4;
#
select * from t1
right join t2 on t1.c=t2.c
right join t3 on t2.c=t3.c
join t4 on t1.c=t4.c
order by 4;



 Comments   
Comment by Daniel Lee (Inactive) [ 2019-11-26 ]

Build verified: 1.4.1-1
engine commit:
57724e5

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