regression-test/data/query_p0/subquery/subquery_unnesting.out

-- This file is automatically generated. You should know what you did if you want to edit this
-- !select1 --
1	\N
1	2
1	3
2	4
2	5
3	3
3	4

-- !select2 --
1	2
1	3
2	4
3	3
3	4

-- !select3 --
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select4 --
1	\N
1	2
1	3
2	4
2	5
3	3
3	4

-- !select5 --
1	\N
1	2
1	3
2	4
2	5
3	3
3	4

-- !select6 --
2	4
3	4

-- !select7 --
1	\N
1	2
1	3
2	4
2	5
3	3
3	4

-- !select8 --
2	4
2	5
3	3
3	4

-- !select9 --
1	\N
1	2
1	3
2	4
2	5
3	3
3	4

-- !select10 --
2	4
2	5
3	3
3	4

-- !select11 --
\N	\N
\N	1
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select12 --
\N	\N
\N	1
1	\N
1	2
1	3
2	5
3	3
20	2
22	3
24	4

-- !select13 --
\N	\N
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select14 --
\N	\N
1	\N
1	2
1	3
2	4
2	5
3	4
20	2
22	3
24	4

-- !select15 --
1	\N
1	2
1	3
2	4
2	5
3	3
3	4

-- !select16 --
1	\N
1	2
1	3
20	2
22	3
24	4

-- !select17 --
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select18 --
\N	2
1	2
1	3
2	4
3	3
3	4
20	2
22	3
24	4

-- !select19 --
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
22	3
24	4

-- !select20 --
1	3
2	4
2	5
3	3
3	4
22	3
24	4

-- !select21 --
1	\N
1	2
1	3
2	4
2	5
3	3
3	4

-- !select22 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select23 --
\N	\N
\N	1
1	\N
1	2
1	3
2	4
2	5
3	3
3	4

-- !select24 --
\N	\N
\N	1
1	\N
2	5

-- !select25 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2

-- !select26 --
\N	\N
1	\N

-- !select27 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select28 --

-- !select29 --
\N	2
1	2
1	3
2	4
3	3
3	4
20	2
22	3
24	4

-- !select30 --
1	3
2	4
2	5
3	3
3	4
22	3
24	4

-- !select31 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select32 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
22	3
24	4

-- !select33 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select34 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
22	3
24	4

-- !select35 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	2
1	3
1	3
1	3
2	4
2	4
2	5
3	3
3	3
3	3
3	4
3	4
20	2
22	3
24	4

-- !select36 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
22	3
24	4

-- !select37 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	2
1	3
2	4
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select38 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
22	3
24	4

-- !select39 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	2
1	3
1	3
1	3
2	4
2	5
3	3
3	3
3	3
3	4
3	4
20	2
22	3
24	4

-- !select40 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
22	3
24	4

-- !select41 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	2
1	3
1	3
1	3
2	4
2	4
2	5
3	3
3	3
3	3
3	4
3	4
20	2
22	3
24	4

-- !select42 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
20	2
22	3
24	4
24	4

-- !select43 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
3	4
20	2
20	2
22	3
24	4
24	4

-- !select44 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
22	3
22	3
22	3
24	4
24	4

-- !select45 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	4
2	5
3	3
3	4
20	2
22	3
22	3
22	3
24	4
24	4

-- !select46 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
22	3
24	4

-- !select47 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select48 --
\N	\N
\N	1
\N	2
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
20	2
22	3
22	3
22	3
24	4
24	4

-- !select49 --
\N	\N
\N	1
\N	2
\N	2
1	\N
1	2
1	2
1	3
1	3
1	3
2	4
2	4
2	5
3	3
3	3
3	3
3	4
3	4
20	2
20	2
22	3
22	3
22	3
24	4
24	4

-- !select50 --
\N	\N
\N	1
\N	2
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
20	2
22	3
22	3
22	3
24	4
24	4

-- !select51 --
\N	\N
\N	1
\N	2
\N	2
1	\N
1	2
1	2
1	3
1	3
1	3
2	4
2	4
2	5
3	3
3	3
3	3
3	4
3	4
20	2
20	2
22	3
22	3
22	3
24	4
24	4

-- !select52 --
\N	\N
\N	1
\N	2
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
20	2
22	3
22	3
22	3
24	4
24	4

-- !select53 --
\N	\N
\N	1
\N	2
\N	2
1	\N
1	2
1	2
1	3
1	3
1	3
2	4
2	4
2	5
3	3
3	3
3	3
3	4
3	4
20	2
20	2
22	3
22	3
22	3
24	4
24	4

-- !select54 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
22	3
24	4

-- !select55 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select56 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
22	3
24	4

-- !select57 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select58 --
\N	\N
\N	1
\N	2
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	\N
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	2
1	3
1	3
1	3
1	3
1	3
1	3
1	3
1	3
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	4
2	5
2	5
2	5
2	5
2	5
2	5
2	5
2	5
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	4
3	4
3	4
3	4
3	4
3	4
3	4
3	4
20	2
22	3
24	4

-- !select59 --
\N	\N
\N	1
\N	2
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select60 --
\N	1
\N	2
1	2
1	3
2	4
3	3
3	4
20	2
22	3
24	4

-- !select61 --

-- !select62 --

-- !select63 --
1	\N
1	2
1	3
2	4
2	5
3	3
3	4
20	2
22	3
24	4

-- !select64 --
0
0
0
0
0
0
0
0
0
0
0
0
2