104 lines
5.0 KiB
SQL
104 lines
5.0 KiB
SQL
#before test set stack limit to small value
|
|
select * from (select c1 from t1) v1 join (
|
|
select 1 as b union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
union all select 2 as b union all select 2 as b
|
|
) v2 on v1.c1 = v2.b;
|