regression-test/data/nereids_syntax_p0/window_function.out

-- This file is automatically generated. You should know what you did if you want to edit this
-- !empty_over --
1
1
1
1
1
1
1
1
1
1
1
1
1
1

-- !with_star --
1	\N	3.0	1
1	1	1.0	1
1	1	2.0	1
1	2	\N	1
1	2	1.0	3
1	2	2.0	3
1	3	\N	2
1	3	1.0	5
2	\N	3.0	1
2	1	1.0	1
2	1	2.0	1
2	2	1.0	3
2	2	2.0	3
2	3	1.0	5

-- !multi_window_1 --
1	1
1	10
1	11
1	12
1	13
1	14
1	2
1	3
1	4
1	5
1	6
1	7
1	8
1	9

-- !multi_window_2 --
20	12	1
20	12	1
20	12	1
20	12	1
20	12	1
20	12	1
20	12	1
20	12	2
20	12	3
20	12	3
20	12	3
20	12	3
20	12	5
20	12	5

-- !dense_rank --
1
1
1
1
1
1
1
2
2
2
2
2
3
3

-- !ntile --
1
1
1
1
1
2
2
2
2
3
3
4
4
5

-- !rank --
1
1
1
1
1
1
1
2
3
3
3
3
5
5

-- !row_number --
1
1
1
1
2
2
2
2
3
3
4
4
5
6

-- !sum --
1
2
3
3
3
3
3
3
6
6
6
6
9
9

-- !avg --
1.0
1.0
1.5
1.5
1.5
1.5
1.5
1.5
1.5
1.5
1.5
1.5
1.5
1.5

-- !count --
1
2
2
2
2
2
2
2
4
4
4
4
6
6

-- !max --
1
1
2
2
2
2
2
2
2
2
2
2
2
2

-- !min --
1
1
1
1
1
1
1
1
1
1
1
1
1
1

-- !agg_1 --
2	\N	1	1
2	1	2	1
2	2	3	1
2	3	2	1
3	\N	2	3
3	1	4	3
3	2	4	3
3	3	2	3

-- !agg_2 --
1	\N	2	2
1	1	4	2
1	2	6	2
1	3	4	2
2	\N	3	5
2	1	6	5
2	2	6	5
2	3	3	5

-- !agg_3 --
1
1
1
2
2
3
3
4
4
5
6
7
8

-- !subquery_1 --
1	\N	3.0	1	8
1	1	1.0	1	3
1	1	2.0	3	6
1	2	\N	1	1
1	2	1.0	2	4
1	2	2.0	4	7
1	3	\N	1	2
1	3	1.0	2	5
2	\N	3.0	2	6
2	1	1.0	2	1
2	1	2.0	4	4
2	2	1.0	3	2
2	2	2.0	5	5
2	3	1.0	3	3

-- !subquery_2 --
10	4	6
10	4	6
12	5	7
12	5	7
2	1	1
2	1	1
5	2	3
5	2	3
5	2	3
5	2	3
7	3	4
7	3	4
7	3	4
7	3	4

-- !range --
1	8
1	8
1	8
1	8
1	8
1	8
1	8
1	8
2	20
2	20
2	20
2	20
2	20
2	20

-- !cte --
1	8
1	8
1	8
1	8
1	8
1	8
1	8
1	8
2	20
2	20
2	20
2	20
2	20
2	20

-- !window_use_agg --
20

-- !winExpr_not_agg_expr --
2	5
3	5
3	5
4	5
4	5
6	5
6	5
6	5

-- !on_notgroupbycolumn --
1.0
2.0
3.0
3.0
3.0
6.0
6.0
6.0

-- !orderby --
1	2	2
1	4	2
1	4	2
1	6	2
2	3	5
2	3	5
2	6	5
2	6	5

-- !winExpr_with_others --
0.4
0.4
0.5
0.8
0.8
1.0
1.0
1.5

-- !winExpr_with_others2 --
0.4
0.4
0.5
0.8
0.8
1.0
1.0
1.5

-- !sql --
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N
\N

-- !multi_winf1 --
1	c

-- !multi_winf2 --
1	35

-- !first_value_false --
1
1
1
1
1
1
1
1
2
2
2
2
2
2

-- !last_value_false --
1
1
1
1
1
1
1
1
1
1
1
1
1
1