Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.4.0
-
None
-
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;