====
---- QUERY: primitive_many_fragments
-- Description : Query with a large number of shuffle joins
-- Target test case : Run a query with a large number of fragments
--  stressing query startup, connection creation and query teardown
select /* +straight_join */ count(*),a.c_nationkey, max(b.c_comment) from   customer A join /* +shuffle */  customer B on A.c_custkey = B.c_custkey join /* +shuffle */   customer C on c.c_custkey = B.c_custkey join /* +shuffle */   customer D on d.c_custkey = B.c_custkey join /* +shuffle */   customer E on e.c_custkey = B.c_custkey join /* +shuffle */   customer F on f.c_custkey = B.c_custkey join /* +shuffle */   customer G on g.c_custkey = B.c_custkey join /* +shuffle */   customer H on h.c_custkey = B.c_custkey join /* +shuffle */   customer I on i.c_custkey = B.c_custkey join /* +shuffle */   customer J on j.c_custkey = B.c_custkey join /* +shuffle */   customer K on k.c_custkey = B.c_custkey join /* +shuffle */   customer L on l.c_custkey = B.c_custkey join /* +shuffle */   customer M on m.c_custkey = B.c_custkey join /* +shuffle */   customer N on n.c_custkey = B.c_custkey join /* +shuffle */   customer O on o.c_custkey = B.c_custkey join /* +shuffle */   customer P on p.c_custkey = B.c_custkey join /* +shuffle */   customer R on R.c_custkey = B.c_custkey join /* +shuffle */   customer S on S.c_custkey = B.c_custkey join /* +shuffle */   customer T on T.c_custkey = B.c_custkey join /* +shuffle */   customer U on U.c_custkey = B.c_custkey join /* +shuffle */   customer V on V.c_custkey = B.c_custkey join /* +shuffle */   customer W on W.c_custkey = B.c_custkey join /* +shuffle */   customer X on X.c_custkey = B.c_custkey join /* +shuffle */   customer Y on Y.c_custkey = B.c_custkey join /* +shuffle */   customer Z on Z.c_custkey = B.c_custkey join /* +shuffle */   customer z1  on Z1.c_custkey = B.c_custkey join /* +shuffle */   customer z2  on Z2.c_custkey = B.c_custkey join /* +shuffle */   customer z3  on Z3.c_custkey = B.c_custkey join /* +shuffle */   customer z4  on Z4.c_custkey = B.c_custkey join /* +shuffle */   customer z5  on Z5.c_custkey = B.c_custkey join /* +shuffle */   customer z6  on Z6.c_custkey = B.c_custkey join /* +shuffle */   customer z7  on Z7.c_custkey = B.c_custkey join /* +shuffle */   customer z8  on Z8.c_custkey = B.c_custkey join /* +shuffle */   customer z9  on Z9.c_custkey = B.c_custkey join /* +shuffle */   customer z10  on Z10.c_custkey = B.c_custkey join /* +shuffle */   customer z11  on Z11.c_custkey = B.c_custkey join /* +shuffle */   customer z12  on Z12.c_custkey = B.c_custkey join /* +shuffle */   customer z13  on Z13.c_custkey = B.c_custkey join /* +shuffle */   customer z14  on Z14.c_custkey = B.c_custkey join /* +shuffle */   customer z15  on Z15.c_custkey = B.c_custkey join /* +shuffle */   customer z16  on Z16.c_custkey = B.c_custkey join /* +shuffle */   customer z17  on Z17.c_custkey = B.c_custkey join /* +shuffle */   customer z18  on Z18.c_custkey = B.c_custkey join /* +shuffle */   customer z19  on Z19.c_custkey = B.c_custkey join /* +shuffle */   customer z20  on Z20.c_custkey = B.c_custkey join /* +shuffle */   customer z21  on Z21.c_custkey = B.c_custkey join /* +shuffle */   customer z22  on Z22.c_custkey = B.c_custkey join /* +shuffle */   customer z23  on Z23.c_custkey = B.c_custkey join /* +shuffle */   customer z24  on Z24.c_custkey = B.c_custkey join /* +shuffle */   customer z25  on Z25.c_custkey = B.c_custkey join /* +shuffle */   customer z26  on Z26.c_custkey = B.c_custkey join /* +shuffle */   customer z27  on Z27.c_custkey = B.c_custkey join /* +shuffle */   customer z28  on Z28.c_custkey = B.c_custkey join /* +shuffle */   customer z29  on Z29.c_custkey = B.c_custkey join /* +shuffle */   customer z30  on Z30.c_custkey = B.c_custkey join /* +shuffle */   customer z31  on Z31.c_custkey = B.c_custkey join /* +shuffle */   customer z32  on Z32.c_custkey = B.c_custkey join /* +shuffle */   customer z33  on Z33.c_custkey = B.c_custkey join /* +shuffle */   customer z34  on Z34.c_custkey = B.c_custkey join /* +shuffle */   customer z35  on Z35.c_custkey = B.c_custkey join /* +shuffle */   customer z36  on Z36.c_custkey = B.c_custkey join /* +shuffle */   customer z37  on Z37.c_custkey = B.c_custkey join /* +shuffle */   customer z38  on Z38.c_custkey = B.c_custkey join /* +shuffle */   customer z39  on Z39.c_custkey = B.c_custkey join /* +shuffle */   customer z40  on Z40.c_custkey = B.c_custkey join /* +shuffle */   customer z41  on Z41.c_custkey = B.c_custkey join /* +shuffle */   customer z42  on Z42.c_custkey = B.c_custkey join /* +shuffle */   customer z43  on Z43.c_custkey = B.c_custkey join /* +shuffle */   customer z44  on z44.c_custkey = B.c_custkey join /* +shuffle */   customer z45  on z45.c_custkey = B.c_custkey join /* +shuffle */   customer z46  on z46.c_custkey = B.c_custkey join /* +shuffle */   customer z47  on z47.c_custkey = B.c_custkey join /* +shuffle */   customer z48  on z48.c_custkey = B.c_custkey join /* +shuffle */   customer z49  on z49.c_custkey = B.c_custkey join /* +shuffle */   customer z50  on z50.c_custkey = B.c_custkey join /* +shuffle */   customer z51  on z51.c_custkey = B.c_custkey join /* +shuffle */   customer z52  on z52.c_custkey = B.c_custkey join /* +shuffle */   customer z53  on z53.c_custkey = B.c_custkey join /* +shuffle */   customer z54  on z54.c_custkey = B.c_custkey join /* +shuffle */   customer z55  on z55.c_custkey = B.c_custkey join /* +shuffle */   customer z56  on z56.c_custkey = B.c_custkey join /* +shuffle */   customer z57  on z57.c_custkey = B.c_custkey join /* +shuffle */   customer z58  on z58.c_custkey = B.c_custkey join /* +shuffle */   customer z59  on z59.c_custkey = B.c_custkey join /* +shuffle */   customer z60  on z60.c_custkey = B.c_custkey join /* +shuffle */   customer z61  on z61.c_custkey = B.c_custkey join /* +shuffle */   customer z62  on z62.c_custkey = B.c_custkey join /* +shuffle */   customer z63  on z63.c_custkey = B.c_custkey join /* +shuffle */   customer z64  on z64.c_custkey = B.c_custkey join /* +shuffle */   customer z65  on z65.c_custkey = B.c_custkey join /* +shuffle */   customer z66  on z66.c_custkey = B.c_custkey join /* +shuffle */   customer z67  on z67.c_custkey = B.c_custkey join /* +shuffle */   customer z68  on z68.c_custkey = B.c_custkey join /* +shuffle */   customer z69  on z69.c_custkey = B.c_custkey join /* +shuffle */   customer z70  on z70.c_custkey = B.c_custkey join /* +shuffle */   customer z71  on z71.c_custkey = B.c_custkey join /* +shuffle */   customer z72  on z72.c_custkey = B.c_custkey join /* +shuffle */   customer z73  on z73.c_custkey = B.c_custkey join /* +shuffle */   customer z74  on z74.c_custkey = B.c_custkey join /* +shuffle */   customer z75  on z75.c_custkey = B.c_custkey join /* +shuffle */   customer z76  on z76.c_custkey = B.c_custkey join /* +shuffle */   customer z77  on z77.c_custkey = B.c_custkey join /* +shuffle */   customer z78  on z78.c_custkey = B.c_custkey join /* +shuffle */   customer z79  on z79.c_custkey = B.c_custkey join /* +shuffle */   customer z80  on z80.c_custkey = B.c_custkey join /* +shuffle */   customer z81  on z81.c_custkey = B.c_custkey join /* +shuffle */   customer z82  on z82.c_custkey = B.c_custkey join /* +shuffle */   customer z83  on z83.c_custkey = B.c_custkey join /* +shuffle */   customer z84  on z84.c_custkey = B.c_custkey join /* +shuffle */   customer z85  on z85.c_custkey = B.c_custkey join /* +shuffle */   customer z86  on z86.c_custkey = B.c_custkey join /* +shuffle */   customer z87  on z87.c_custkey = B.c_custkey join /* +shuffle */   customer z88  on z88.c_custkey = B.c_custkey join /* +shuffle */   customer z89  on z89.c_custkey = B.c_custkey join /* +shuffle */   customer z90  on z90.c_custkey = B.c_custkey join /* +shuffle */   customer z91  on z91.c_custkey = B.c_custkey join /* +shuffle */   customer z92  on z92.c_custkey = B.c_custkey join /* +shuffle */   customer z93  on z93.c_custkey = B.c_custkey join /* +shuffle */   customer z94  on z94.c_custkey = B.c_custkey join /* +shuffle */   customer z95  on z95.c_custkey = B.c_custkey join /* +shuffle */   customer z96  on z96.c_custkey = B.c_custkey join /* +shuffle */   customer z97  on z97.c_custkey = B.c_custkey join /* +shuffle */   customer z98  on z98.c_custkey = B.c_custkey join /* +shuffle */   customer z99  on z99.c_custkey = B.c_custkey join /* +shuffle */   customer z100  on z100.c_custkey = B.c_custkey and b.c_custkey < 10000 group by a.c_nationkey;
---- RESULTS
---- TYPES
====