This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 727853017c [regression-test](Nereids) add agg function, tvf,
generator, window function test cases (#16824)
727853017c is described below
commit 727853017cb9fb3ec72669e7e39d360d0ac81c39
Author: mch_ucchi <[email protected]>
AuthorDate: Tue Feb 28 17:51:39 2023 +0800
[regression-test](Nereids) add agg function, tvf, generator, window
function test cases (#16824)
add agg_function, tvf, generator, window_function test for nereids and add
more feature to gen.py
---
.../data/nereids_function_p0/agg_function/agg.out | 6079 ++++++++++++++++++++
.../data/nereids_function_p0/gen_function/gen.out | 595 ++
.../data/nereids_function_p0/tvf/tvf.out | 13 +
.../window_function/window_fn.out | 3974 +++++++++++++
.../nereids_function_p0/agg_function/agg.groovy | 2761 +++++++++
.../nereids_function_p0/gen_function/gen.groovy | 52 +
.../suites/nereids_function_p0/load.groovy | 4 +-
.../nereids_function_p0/scalar_function/M.groovy | 16 +-
.../nereids_function_p0/scalar_function/W.groovy | 44 +-
.../suites/nereids_function_p0/script/define.py | 95 +-
.../suites/nereids_function_p0/script/gen.py | 208 +-
.../{agg_function.groovy => tvf/tvf.groovy} | 8 +-
.../window_function/window_fn.groovy | 660 +++
13 files changed, 14440 insertions(+), 69 deletions(-)
diff --git a/regression-test/data/nereids_function_p0/agg_function/agg.out
b/regression-test/data/nereids_function_p0/agg_function/agg.out
new file mode 100644
index 0000000000..28e636d483
--- /dev/null
+++ b/regression-test/data/nereids_function_p0/agg_function/agg.out
@@ -0,0 +1,6079 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql_avg_TinyInt_gb --
+\N
+4.0
+10.0
+
+-- !sql_avg_TinyInt --
+6.5
+
+-- !sql_avg_TinyInt_agg_phase_1 --
+0 \N
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_TinyInt_agg_phase_2 --
+12 6.5
+
+-- !sql_avg_TinyInt_agg_phase_3 --
+0 \N
+7 4.0
+5 10.0
+
+-- !sql_avg_TinyInt_agg_phase_4 --
+12 6.5
+
+-- !sql_avg_TinyInt_gb_notnull --
+4.0
+10.0
+
+-- !sql_avg_TinyInt_notnull --
+6.5
+
+-- !sql_avg_TinyInt_agg_phase_1_notnull --
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_TinyInt_agg_phase_2_notnull --
+12 6.5
+
+-- !sql_avg_TinyInt_agg_phase_3_notnull --
+0 \N
+7 4.0
+5 10.0
+
+-- !sql_avg_TinyInt_agg_phase_4_notnull --
+12 6.5
+
+-- !sql_avg_SmallInt_gb --
+\N
+4.0
+10.0
+
+-- !sql_avg_SmallInt --
+6.5
+
+-- !sql_avg_SmallInt_agg_phase_1 --
+0 \N
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_SmallInt_agg_phase_2 --
+12 6.5
+
+-- !sql_avg_SmallInt_agg_phase_3 --
+0 \N
+7 4.0
+5 10.0
+
+-- !sql_avg_SmallInt_agg_phase_4 --
+12 6.5
+
+-- !sql_avg_SmallInt_gb_notnull --
+4.0
+10.0
+
+-- !sql_avg_SmallInt_notnull --
+6.5
+
+-- !sql_avg_SmallInt_agg_phase_1_notnull --
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_SmallInt_agg_phase_2_notnull --
+12 6.5
+
+-- !sql_avg_SmallInt_agg_phase_3_notnull --
+0 \N
+7 4.0
+5 10.0
+
+-- !sql_avg_SmallInt_agg_phase_4_notnull --
+12 6.5
+
+-- !sql_avg_Integer_gb --
+\N
+4.0
+10.0
+
+-- !sql_avg_Integer --
+6.5
+
+-- !sql_avg_Integer_agg_phase_1 --
+0 \N
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_Integer_agg_phase_2 --
+12 6.5
+
+-- !sql_avg_Integer_agg_phase_3 --
+0 \N
+7 4.0
+5 10.0
+
+-- !sql_avg_Integer_agg_phase_4 --
+12 6.5
+
+-- !sql_avg_Integer_gb_notnull --
+4.0
+10.0
+
+-- !sql_avg_Integer_notnull --
+6.5
+
+-- !sql_avg_Integer_agg_phase_1_notnull --
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_Integer_agg_phase_2_notnull --
+12 6.5
+
+-- !sql_avg_Integer_agg_phase_3_notnull --
+0 \N
+7 4.0
+5 10.0
+
+-- !sql_avg_Integer_agg_phase_4_notnull --
+12 6.5
+
+-- !sql_avg_BigInt_gb --
+\N
+4.0
+10.0
+
+-- !sql_avg_BigInt --
+6.5
+
+-- !sql_avg_BigInt_agg_phase_1 --
+0 \N
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_BigInt_agg_phase_2 --
+12 6.5
+
+-- !sql_avg_BigInt_agg_phase_3 --
+0 \N
+7 4.0
+5 10.0
+
+-- !sql_avg_BigInt_agg_phase_4 --
+12 6.5
+
+-- !sql_avg_BigInt_gb_notnull --
+4.0
+10.0
+
+-- !sql_avg_BigInt_notnull --
+6.5
+
+-- !sql_avg_BigInt_agg_phase_1_notnull --
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_BigInt_agg_phase_2_notnull --
+12 6.5
+
+-- !sql_avg_BigInt_agg_phase_3_notnull --
+0 \N
+7 4.0
+5 10.0
+
+-- !sql_avg_BigInt_agg_phase_4_notnull --
+12 6.5
+
+-- !sql_avg_Double_gb --
+\N
+0.4
+1.0
+
+-- !sql_avg_Double --
+0.65
+
+-- !sql_avg_Double_agg_phase_1 --
+0 \N
+1 0.1
+1 0.2
+1 0.3
+1 0.4
+1 0.5
+1 0.6
+1 0.7
+1 0.8
+1 0.9
+1 1.0
+1 1.1
+1 1.2
+
+-- !sql_avg_Double_agg_phase_2 --
+12 0.65
+
+-- !sql_avg_Double_agg_phase_3 --
+0 \N
+7 0.39999999999999997
+5 1.0
+
+-- !sql_avg_Double_agg_phase_4 --
+12 0.65
+
+-- !sql_avg_Double_gb_notnull --
+0.39999999999999997
+1.0
+
+-- !sql_avg_Double_notnull --
+0.6499999999999999
+
+-- !sql_avg_Double_agg_phase_1_notnull --
+1 0.1
+1 0.2
+1 0.3
+1 0.4
+1 0.5
+1 0.6
+1 0.7
+1 0.8
+1 0.9
+1 1.0
+1 1.1
+1 1.2
+
+-- !sql_avg_Double_agg_phase_2_notnull --
+12 0.65
+
+-- !sql_avg_Double_agg_phase_3_notnull --
+0 \N
+7 0.4000000000000001
+5 1.0
+
+-- !sql_avg_Double_agg_phase_4_notnull --
+12 0.65
+
+-- !sql_avg_DecimalV2_gb --
+\N
+0.400000000
+1.000000000
+
+-- !sql_avg_DecimalV2 --
+0.650000000
+
+-- !sql_avg_DecimalV2_agg_phase_1 --
+0 \N
+1 0.100000000
+1 0.200000000
+1 0.300000000
+1 0.400000000
+1 0.500000000
+1 0.600000000
+1 0.700000000
+1 0.800000000
+1 0.900000000
+1 1.000000000
+1 1.100000000
+1 1.200000000
+
+-- !sql_avg_DecimalV2_agg_phase_2 --
+12 0.650000000
+
+-- !sql_avg_DecimalV2_agg_phase_3 --
+0 \N
+7 0.400000000
+5 1.000000000
+
+-- !sql_avg_DecimalV2_agg_phase_4 --
+12 0.650000000
+
+-- !sql_avg_DecimalV2_gb_notnull --
+0.400000000
+1.000000000
+
+-- !sql_avg_DecimalV2_notnull --
+0.650000000
+
+-- !sql_avg_DecimalV2_agg_phase_1_notnull --
+1 0.100000000
+1 0.200000000
+1 0.300000000
+1 0.400000000
+1 0.500000000
+1 0.600000000
+1 0.700000000
+1 0.800000000
+1 0.900000000
+1 1.000000000
+1 1.100000000
+1 1.200000000
+
+-- !sql_avg_DecimalV2_agg_phase_2_notnull --
+12 0.650000000
+
+-- !sql_avg_DecimalV2_agg_phase_3_notnull --
+0 \N
+7 0.400000000
+5 1.000000000
+
+-- !sql_avg_DecimalV2_agg_phase_4_notnull --
+12 0.650000000
+
+-- !sql_avg_weighted_TinyInt_Double_gb --
+\N
+5.0
+10.2
+
+-- !sql_avg_weighted_TinyInt_Double --
+8.333333333333332
+
+-- !sql_avg_weighted_TinyInt_Double_agg_phase_1 --
+0 \N
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_weighted_TinyInt_Double_agg_phase_2 --
+12 8.333333333333332
+
+-- !sql_avg_weighted_TinyInt_Double_agg_phase_3 --
+0 \N
+7 4.999999999999999
+5 10.2
+
+-- !sql_avg_weighted_TinyInt_Double_agg_phase_4 --
+12 8.333333333333332
+
+-- !sql_avg_weighted_TinyInt_Double_gb_notnull --
+5.0
+10.2
+
+-- !sql_avg_weighted_TinyInt_Double_notnull --
+8.333333333333332
+
+-- !sql_avg_weighted_TinyInt_Double_agg_phase_1_notnull --
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_weighted_TinyInt_Double_agg_phase_2_notnull --
+12 8.333333333333334
+
+-- !sql_avg_weighted_TinyInt_Double_agg_phase_3_notnull --
+0 \N
+7 5.0
+5 10.2
+
+-- !sql_avg_weighted_TinyInt_Double_agg_phase_4_notnull --
+12 8.333333333333332
+
+-- !sql_avg_weighted_SmallInt_Double_gb --
+\N
+4.999999999999999
+10.2
+
+-- !sql_avg_weighted_SmallInt_Double --
+8.333333333333334
+
+-- !sql_avg_weighted_SmallInt_Double_agg_phase_1 --
+0 \N
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_weighted_SmallInt_Double_agg_phase_2 --
+12 8.333333333333332
+
+-- !sql_avg_weighted_SmallInt_Double_agg_phase_3 --
+0 \N
+7 4.999999999999999
+5 10.2
+
+-- !sql_avg_weighted_SmallInt_Double_agg_phase_4 --
+12 8.333333333333334
+
+-- !sql_avg_weighted_SmallInt_Double_gb_notnull --
+4.999999999999999
+10.2
+
+-- !sql_avg_weighted_SmallInt_Double_notnull --
+8.333333333333334
+
+-- !sql_avg_weighted_SmallInt_Double_agg_phase_1_notnull --
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_weighted_SmallInt_Double_agg_phase_2_notnull --
+12 8.333333333333334
+
+-- !sql_avg_weighted_SmallInt_Double_agg_phase_3_notnull --
+0 \N
+7 5.0
+5 10.2
+
+-- !sql_avg_weighted_SmallInt_Double_agg_phase_4_notnull --
+12 8.333333333333332
+
+-- !sql_avg_weighted_Integer_Double_gb --
+\N
+4.999999999999999
+10.2
+
+-- !sql_avg_weighted_Integer_Double --
+8.333333333333334
+
+-- !sql_avg_weighted_Integer_Double_agg_phase_1 --
+0 \N
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_weighted_Integer_Double_agg_phase_2 --
+12 8.333333333333332
+
+-- !sql_avg_weighted_Integer_Double_agg_phase_3 --
+0 \N
+7 4.999999999999999
+5 10.2
+
+-- !sql_avg_weighted_Integer_Double_agg_phase_4 --
+12 8.333333333333332
+
+-- !sql_avg_weighted_Integer_Double_gb_notnull --
+4.999999999999999
+10.2
+
+-- !sql_avg_weighted_Integer_Double_notnull --
+8.333333333333334
+
+-- !sql_avg_weighted_Integer_Double_agg_phase_1_notnull --
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_weighted_Integer_Double_agg_phase_2_notnull --
+12 8.333333333333334
+
+-- !sql_avg_weighted_Integer_Double_agg_phase_3_notnull --
+0 \N
+7 5.0
+5 10.2
+
+-- !sql_avg_weighted_Integer_Double_agg_phase_4_notnull --
+12 8.333333333333334
+
+-- !sql_avg_weighted_BigInt_Double_gb --
+\N
+4.999999999999999
+10.2
+
+-- !sql_avg_weighted_BigInt_Double --
+8.333333333333334
+
+-- !sql_avg_weighted_BigInt_Double_agg_phase_1 --
+0 \N
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_weighted_BigInt_Double_agg_phase_2 --
+12 8.333333333333334
+
+-- !sql_avg_weighted_BigInt_Double_agg_phase_3 --
+0 \N
+7 4.999999999999999
+5 10.2
+
+-- !sql_avg_weighted_BigInt_Double_agg_phase_4 --
+12 8.333333333333332
+
+-- !sql_avg_weighted_BigInt_Double_gb_notnull --
+4.999999999999999
+10.2
+
+-- !sql_avg_weighted_BigInt_Double_notnull --
+8.333333333333334
+
+-- !sql_avg_weighted_BigInt_Double_agg_phase_1_notnull --
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_avg_weighted_BigInt_Double_agg_phase_2_notnull --
+12 8.333333333333334
+
+-- !sql_avg_weighted_BigInt_Double_agg_phase_3_notnull --
+0 \N
+7 4.999999999999999
+5 10.2
+
+-- !sql_avg_weighted_BigInt_Double_agg_phase_4_notnull --
+12 8.333333333333332
+
+-- !sql_avg_weighted_Float_Double_gb --
+\N
+0.5000000045235667
+1.0200000143051147
+
+-- !sql_avg_weighted_Float_Double --
+0.8333333441271232
+
+-- !sql_avg_weighted_Float_Double_agg_phase_1 --
+0 \N
+1 0.10000000149011612
+1 0.20000000298023224
+1 0.30000001192092896
+1 0.4000000059604645
+1 0.5
+1 0.6000000238418579
+1 0.699999988079071
+1 0.800000011920929
+1 0.8999999761581421
+1 1.0
+1 1.100000023841858
+1 1.2000000476837158
+
+-- !sql_avg_weighted_Float_Double_agg_phase_2 --
+12 0.8333333441271231
+
+-- !sql_avg_weighted_Float_Double_agg_phase_3 --
+0 \N
+7 0.5000000045235667
+5 1.0200000143051147
+
+-- !sql_avg_weighted_Float_Double_agg_phase_4 --
+12 0.8333333441271231
+
+-- !sql_avg_weighted_Float_Double_gb_notnull --
+0.5000000045235667
+1.0200000143051144
+
+-- !sql_avg_weighted_Float_Double_notnull --
+0.8333333441271232
+
+-- !sql_avg_weighted_Float_Double_agg_phase_1_notnull --
+1 0.10000000149011612
+1 0.20000000298023224
+1 0.30000001192092896
+1 0.4000000059604645
+1 0.5
+1 0.6000000238418579
+1 0.699999988079071
+1 0.800000011920929
+1 0.8999999761581421
+1 1.0
+1 1.100000023841858
+1 1.2000000476837158
+
+-- !sql_avg_weighted_Float_Double_agg_phase_2_notnull --
+12 0.8333333441271231
+
+-- !sql_avg_weighted_Float_Double_agg_phase_3_notnull --
+0 \N
+7 0.5000000045235666
+5 1.0200000143051149
+
+-- !sql_avg_weighted_Float_Double_agg_phase_4_notnull --
+12 0.833333344127123
+
+-- !sql_avg_weighted_Double_Double_gb --
+\N
+0.5000000000000001
+1.02
+
+-- !sql_avg_weighted_Double_Double --
+0.8333333333333335
+
+-- !sql_avg_weighted_Double_Double_agg_phase_1 --
+0 \N
+1 0.10000000000000002
+1 0.20000000000000004
+1 0.3
+1 0.4000000000000001
+1 0.5
+1 0.6
+1 0.7
+1 0.8000000000000002
+1 0.9
+1 1.0
+1 1.1
+1 1.2
+
+-- !sql_avg_weighted_Double_Double_agg_phase_2 --
+12 0.8333333333333334
+
+-- !sql_avg_weighted_Double_Double_agg_phase_3 --
+0 \N
+7 0.49999999999999983
+5 1.02
+
+-- !sql_avg_weighted_Double_Double_agg_phase_4 --
+12 0.8333333333333334
+
+-- !sql_avg_weighted_Double_Double_gb_notnull --
+0.49999999999999994
+1.02
+
+-- !sql_avg_weighted_Double_Double_notnull --
+0.8333333333333334
+
+-- !sql_avg_weighted_Double_Double_agg_phase_1_notnull --
+1 0.10000000000000002
+1 0.20000000000000004
+1 0.3
+1 0.4000000000000001
+1 0.5
+1 0.6
+1 0.7
+1 0.8000000000000002
+1 0.9
+1 1.0
+1 1.1
+1 1.2
+
+-- !sql_avg_weighted_Double_Double_agg_phase_2_notnull --
+12 0.8333333333333334
+
+-- !sql_avg_weighted_Double_Double_agg_phase_3_notnull --
+0 \N
+7 0.5000000000000001
+5 1.02
+
+-- !sql_avg_weighted_Double_Double_agg_phase_4_notnull --
+12 0.8333333333333333
+
+-- !sql_avg_weighted_DecimalV2_Double_gb --
+\N
+0.49999999999999994
+1.02
+
+-- !sql_avg_weighted_DecimalV2_Double --
+0.8333333333333334
+
+-- !sql_avg_weighted_DecimalV2_Double_agg_phase_1 --
+0 \N
+1 0.10000000000000002
+1 0.20000000000000004
+1 0.3
+1 0.4000000000000001
+1 0.5
+1 0.6
+1 0.7
+1 0.8000000000000002
+1 0.9
+1 1.0
+1 1.1
+1 1.2
+
+-- !sql_avg_weighted_DecimalV2_Double_agg_phase_2 --
+12 0.8333333333333334
+
+-- !sql_avg_weighted_DecimalV2_Double_agg_phase_3 --
+0 \N
+7 0.5000000000000001
+5 1.0199999999999998
+
+-- !sql_avg_weighted_DecimalV2_Double_agg_phase_4 --
+12 0.8333333333333333
+
+-- !sql_avg_weighted_DecimalV2_Double_gb_notnull --
+0.5
+1.02
+
+-- !sql_avg_weighted_DecimalV2_Double_notnull --
+0.8333333333333334
+
+-- !sql_avg_weighted_DecimalV2_Double_agg_phase_1_notnull --
+1 0.10000000000000002
+1 0.20000000000000004
+1 0.3
+1 0.4000000000000001
+1 0.5
+1 0.6
+1 0.7
+1 0.8000000000000002
+1 0.9
+1 1.0
+1 1.1
+1 1.2
+
+-- !sql_avg_weighted_DecimalV2_Double_agg_phase_2_notnull --
+12 0.8333333333333333
+
+-- !sql_avg_weighted_DecimalV2_Double_agg_phase_3_notnull --
+0 \N
+7 0.49999999999999994
+5 1.02
+
+-- !sql_avg_weighted_DecimalV2_Double_agg_phase_4_notnull --
+12 0.8333333333333333
+
+-- !sql_bitmap_intersect_Bitmap_gb --
+\N
+\N
+\N
+
+-- !sql_bitmap_intersect_Bitmap --
+\N
+
+-- !sql_bitmap_intersect_Bitmap_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_bitmap_intersect_Bitmap_agg_phase_2 --
+12 \N
+
+-- !sql_bitmap_intersect_Bitmap_agg_phase_3 --
+0 \N
+7 \N
+5 \N
+
+-- !sql_bitmap_intersect_Bitmap_agg_phase_4 --
+12 \N
+
+-- !sql_bitmap_intersect_Bitmap_gb_notnull --
+\N
+\N
+
+-- !sql_bitmap_intersect_Bitmap_notnull --
+\N
+
+-- !sql_bitmap_intersect_Bitmap_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_bitmap_intersect_Bitmap_agg_phase_2_notnull --
+12 \N
+
+-- !sql_bitmap_intersect_Bitmap_agg_phase_3_notnull --
+0 \N
+7 \N
+5 \N
+
+-- !sql_bitmap_intersect_Bitmap_agg_phase_4_notnull --
+12 \N
+
+-- !sql_bitmap_union_Bitmap_gb --
+\N
+\N
+\N
+
+-- !sql_bitmap_union_Bitmap --
+\N
+
+-- !sql_bitmap_union_Bitmap_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_bitmap_union_Bitmap_agg_phase_2 --
+12 \N
+
+-- !sql_bitmap_union_Bitmap_agg_phase_3 --
+0 \N
+7 \N
+5 \N
+
+-- !sql_bitmap_union_Bitmap_agg_phase_4 --
+12 \N
+
+-- !sql_bitmap_union_Bitmap_gb_notnull --
+\N
+\N
+
+-- !sql_bitmap_union_Bitmap_notnull --
+\N
+
+-- !sql_bitmap_union_Bitmap_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_bitmap_union_Bitmap_agg_phase_2_notnull --
+12 \N
+
+-- !sql_bitmap_union_Bitmap_agg_phase_3_notnull --
+0 \N
+7 \N
+5 \N
+
+-- !sql_bitmap_union_Bitmap_agg_phase_4_notnull --
+12 \N
+
+-- !sql_bitmap_union_count_Bitmap_gb --
+0
+7
+5
+
+-- !sql_bitmap_union_count_Bitmap --
+12
+
+-- !sql_bitmap_union_count_Bitmap_agg_phase_1 --
+0 0
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_bitmap_union_count_Bitmap_agg_phase_2 --
+12 12
+
+-- !sql_bitmap_union_count_Bitmap_agg_phase_3 --
+0 0
+7 7
+5 5
+
+-- !sql_bitmap_union_count_Bitmap_agg_phase_4 --
+12 12
+
+-- !sql_bitmap_union_count_Bitmap_gb_notnull --
+7
+5
+
+-- !sql_bitmap_union_count_Bitmap_notnull --
+12
+
+-- !sql_bitmap_union_count_Bitmap_agg_phase_1_notnull --
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_bitmap_union_count_Bitmap_agg_phase_2_notnull --
+12 12
+
+-- !sql_bitmap_union_count_Bitmap_agg_phase_3_notnull --
+0 0
+7 7
+5 5
+
+-- !sql_bitmap_union_count_Bitmap_agg_phase_4_notnull --
+12 12
+
+-- !sql_bitmap_union_int_SmallInt_gb --
+0
+7
+5
+
+-- !sql_bitmap_union_int_SmallInt --
+12
+
+-- !sql_bitmap_union_int_SmallInt_agg_phase_1 --
+0 0
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_bitmap_union_int_SmallInt_agg_phase_2 --
+12 12
+
+-- !sql_bitmap_union_int_SmallInt_agg_phase_3 --
+0 0
+7 7
+5 5
+
+-- !sql_bitmap_union_int_SmallInt_agg_phase_4 --
+12 12
+
+-- !sql_bitmap_union_int_SmallInt_gb_notnull --
+7
+5
+
+-- !sql_bitmap_union_int_SmallInt_notnull --
+12
+
+-- !sql_bitmap_union_int_SmallInt_agg_phase_1_notnull --
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_bitmap_union_int_SmallInt_agg_phase_2_notnull --
+12 12
+
+-- !sql_bitmap_union_int_SmallInt_agg_phase_3_notnull --
+0 0
+7 7
+5 5
+
+-- !sql_bitmap_union_int_SmallInt_agg_phase_4_notnull --
+12 12
+
+-- !sql_bitmap_union_int_TinyInt_gb --
+0
+7
+5
+
+-- !sql_bitmap_union_int_TinyInt --
+12
+
+-- !sql_bitmap_union_int_TinyInt_agg_phase_1 --
+0 0
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_bitmap_union_int_TinyInt_agg_phase_2 --
+12 12
+
+-- !sql_bitmap_union_int_TinyInt_agg_phase_3 --
+0 0
+7 7
+5 5
+
+-- !sql_bitmap_union_int_TinyInt_agg_phase_4 --
+12 12
+
+-- !sql_bitmap_union_int_TinyInt_gb_notnull --
+7
+5
+
+-- !sql_bitmap_union_int_TinyInt_notnull --
+12
+
+-- !sql_bitmap_union_int_TinyInt_agg_phase_1_notnull --
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_bitmap_union_int_TinyInt_agg_phase_2_notnull --
+12 12
+
+-- !sql_bitmap_union_int_TinyInt_agg_phase_3_notnull --
+0 0
+7 7
+5 5
+
+-- !sql_bitmap_union_int_TinyInt_agg_phase_4_notnull --
+12 12
+
+-- !sql_bitmap_union_int_Integer_gb --
+0
+7
+5
+
+-- !sql_bitmap_union_int_Integer --
+12
+
+-- !sql_bitmap_union_int_Integer_agg_phase_1 --
+0 0
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_bitmap_union_int_Integer_agg_phase_2 --
+12 12
+
+-- !sql_bitmap_union_int_Integer_agg_phase_3 --
+0 0
+7 7
+5 5
+
+-- !sql_bitmap_union_int_Integer_agg_phase_4 --
+12 12
+
+-- !sql_bitmap_union_int_Integer_gb_notnull --
+7
+5
+
+-- !sql_bitmap_union_int_Integer_notnull --
+12
+
+-- !sql_bitmap_union_int_Integer_agg_phase_1_notnull --
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_bitmap_union_int_Integer_agg_phase_2_notnull --
+12 12
+
+-- !sql_bitmap_union_int_Integer_agg_phase_3_notnull --
+0 0
+7 7
+5 5
+
+-- !sql_bitmap_union_int_Integer_agg_phase_4_notnull --
+12 12
+
+-- !sql_count_gb --
+1
+7
+5
+
+-- !sql_count --
+13
+
+-- !sql_count_agg_phase_1 --
+0 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_count_agg_phase_2 --
+12 13
+
+-- !sql_count_agg_phase_3 --
+0 1
+7 7
+5 5
+
+-- !sql_count_agg_phase_4 --
+12 13
+
+-- !sql_count_gb_notnull --
+7
+5
+
+-- !sql_count_notnull --
+12
+
+-- !sql_count_agg_phase_1_notnull --
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_count_agg_phase_2_notnull --
+12 12
+
+-- !sql_count_agg_phase_3_notnull --
+0 1
+7 7
+5 5
+
+-- !sql_count_agg_phase_4_notnull --
+12 13
+
+-- !sql_count_AnyData_gb --
+0
+7
+5
+
+-- !sql_count_AnyData --
+12
+
+-- !sql_count_AnyData_agg_phase_1 --
+0 0
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_count_AnyData_agg_phase_2 --
+12 12
+
+-- !sql_count_AnyData_agg_phase_3 --
+0 0
+7 7
+5 5
+
+-- !sql_count_AnyData_agg_phase_4 --
+12 12
+
+-- !sql_count_AnyData_gb_notnull --
+7
+5
+
+-- !sql_count_AnyData_notnull --
+12
+
+-- !sql_count_AnyData_agg_phase_1_notnull --
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_count_AnyData_agg_phase_2_notnull --
+12 12
+
+-- !sql_count_AnyData_agg_phase_3_notnull --
+0 0
+7 7
+5 5
+
+-- !sql_count_AnyData_agg_phase_4_notnull --
+12 12
+
+-- !sql_group_bit_and_TinyInt_gb --
+\N
+0
+8
+
+-- !sql_group_bit_and_TinyInt --
+0
+
+-- !sql_group_bit_and_TinyInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_and_TinyInt_agg_phase_2 --
+12 0
+
+-- !sql_group_bit_and_TinyInt_agg_phase_3 --
+0 \N
+7 0
+5 8
+
+-- !sql_group_bit_and_TinyInt_agg_phase_4 --
+12 0
+
+-- !sql_group_bit_and_TinyInt_gb_notnull --
+0
+8
+
+-- !sql_group_bit_and_TinyInt_notnull --
+0
+
+-- !sql_group_bit_and_TinyInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_and_TinyInt_agg_phase_2_notnull --
+12 0
+
+-- !sql_group_bit_and_TinyInt_agg_phase_3_notnull --
+0 \N
+7 0
+5 8
+
+-- !sql_group_bit_and_TinyInt_agg_phase_4_notnull --
+12 0
+
+-- !sql_group_bit_and_SmallInt_gb --
+\N
+0
+8
+
+-- !sql_group_bit_and_SmallInt --
+0
+
+-- !sql_group_bit_and_SmallInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_and_SmallInt_agg_phase_2 --
+12 0
+
+-- !sql_group_bit_and_SmallInt_agg_phase_3 --
+0 \N
+7 0
+5 8
+
+-- !sql_group_bit_and_SmallInt_agg_phase_4 --
+12 0
+
+-- !sql_group_bit_and_SmallInt_gb_notnull --
+0
+8
+
+-- !sql_group_bit_and_SmallInt_notnull --
+0
+
+-- !sql_group_bit_and_SmallInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_and_SmallInt_agg_phase_2_notnull --
+12 0
+
+-- !sql_group_bit_and_SmallInt_agg_phase_3_notnull --
+0 \N
+7 0
+5 8
+
+-- !sql_group_bit_and_SmallInt_agg_phase_4_notnull --
+12 0
+
+-- !sql_group_bit_and_Integer_gb --
+\N
+0
+8
+
+-- !sql_group_bit_and_Integer --
+0
+
+-- !sql_group_bit_and_Integer_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_and_Integer_agg_phase_2 --
+12 0
+
+-- !sql_group_bit_and_Integer_agg_phase_3 --
+0 \N
+7 0
+5 8
+
+-- !sql_group_bit_and_Integer_agg_phase_4 --
+12 0
+
+-- !sql_group_bit_and_Integer_gb_notnull --
+0
+8
+
+-- !sql_group_bit_and_Integer_notnull --
+0
+
+-- !sql_group_bit_and_Integer_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_and_Integer_agg_phase_2_notnull --
+12 0
+
+-- !sql_group_bit_and_Integer_agg_phase_3_notnull --
+0 \N
+7 0
+5 8
+
+-- !sql_group_bit_and_Integer_agg_phase_4_notnull --
+12 0
+
+-- !sql_group_bit_and_BigInt_gb --
+\N
+0
+8
+
+-- !sql_group_bit_and_BigInt --
+0
+
+-- !sql_group_bit_and_BigInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_and_BigInt_agg_phase_2 --
+12 0
+
+-- !sql_group_bit_and_BigInt_agg_phase_3 --
+0 \N
+7 0
+5 8
+
+-- !sql_group_bit_and_BigInt_agg_phase_4 --
+12 0
+
+-- !sql_group_bit_and_BigInt_gb_notnull --
+0
+8
+
+-- !sql_group_bit_and_BigInt_notnull --
+0
+
+-- !sql_group_bit_and_BigInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_and_BigInt_agg_phase_2_notnull --
+12 0
+
+-- !sql_group_bit_and_BigInt_agg_phase_3_notnull --
+0 \N
+7 0
+5 8
+
+-- !sql_group_bit_and_BigInt_agg_phase_4_notnull --
+12 0
+
+-- !sql_group_bit_and_LargeInt_gb --
+\N
+0
+8
+
+-- !sql_group_bit_and_LargeInt --
+0
+
+-- !sql_group_bit_and_LargeInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_and_LargeInt_agg_phase_2 --
+12 0
+
+-- !sql_group_bit_and_LargeInt_agg_phase_3 --
+0 \N
+7 0
+5 8
+
+-- !sql_group_bit_and_LargeInt_agg_phase_4 --
+12 0
+
+-- !sql_group_bit_and_LargeInt_gb_notnull --
+0
+8
+
+-- !sql_group_bit_and_LargeInt_notnull --
+0
+
+-- !sql_group_bit_and_LargeInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_and_LargeInt_agg_phase_2_notnull --
+12 0
+
+-- !sql_group_bit_and_LargeInt_agg_phase_3_notnull --
+0 \N
+7 0
+5 8
+
+-- !sql_group_bit_and_LargeInt_agg_phase_4_notnull --
+12 0
+
+-- !sql_group_bit_or_TinyInt_gb --
+\N
+7
+15
+
+-- !sql_group_bit_or_TinyInt --
+15
+
+-- !sql_group_bit_or_TinyInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_or_TinyInt_agg_phase_2 --
+12 15
+
+-- !sql_group_bit_or_TinyInt_agg_phase_3 --
+0 \N
+7 7
+5 15
+
+-- !sql_group_bit_or_TinyInt_agg_phase_4 --
+12 15
+
+-- !sql_group_bit_or_TinyInt_gb_notnull --
+7
+15
+
+-- !sql_group_bit_or_TinyInt_notnull --
+15
+
+-- !sql_group_bit_or_TinyInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_or_TinyInt_agg_phase_2_notnull --
+12 15
+
+-- !sql_group_bit_or_TinyInt_agg_phase_3_notnull --
+0 \N
+7 7
+5 15
+
+-- !sql_group_bit_or_TinyInt_agg_phase_4_notnull --
+12 15
+
+-- !sql_group_bit_or_SmallInt_gb --
+\N
+7
+15
+
+-- !sql_group_bit_or_SmallInt --
+15
+
+-- !sql_group_bit_or_SmallInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_or_SmallInt_agg_phase_2 --
+12 15
+
+-- !sql_group_bit_or_SmallInt_agg_phase_3 --
+0 \N
+7 7
+5 15
+
+-- !sql_group_bit_or_SmallInt_agg_phase_4 --
+12 15
+
+-- !sql_group_bit_or_SmallInt_gb_notnull --
+7
+15
+
+-- !sql_group_bit_or_SmallInt_notnull --
+15
+
+-- !sql_group_bit_or_SmallInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_or_SmallInt_agg_phase_2_notnull --
+12 15
+
+-- !sql_group_bit_or_SmallInt_agg_phase_3_notnull --
+0 \N
+7 7
+5 15
+
+-- !sql_group_bit_or_SmallInt_agg_phase_4_notnull --
+12 15
+
+-- !sql_group_bit_or_Integer_gb --
+\N
+7
+15
+
+-- !sql_group_bit_or_Integer --
+15
+
+-- !sql_group_bit_or_Integer_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_or_Integer_agg_phase_2 --
+12 15
+
+-- !sql_group_bit_or_Integer_agg_phase_3 --
+0 \N
+7 7
+5 15
+
+-- !sql_group_bit_or_Integer_agg_phase_4 --
+12 15
+
+-- !sql_group_bit_or_Integer_gb_notnull --
+7
+15
+
+-- !sql_group_bit_or_Integer_notnull --
+15
+
+-- !sql_group_bit_or_Integer_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_or_Integer_agg_phase_2_notnull --
+12 15
+
+-- !sql_group_bit_or_Integer_agg_phase_3_notnull --
+0 \N
+7 7
+5 15
+
+-- !sql_group_bit_or_Integer_agg_phase_4_notnull --
+12 15
+
+-- !sql_group_bit_or_BigInt_gb --
+\N
+7
+15
+
+-- !sql_group_bit_or_BigInt --
+15
+
+-- !sql_group_bit_or_BigInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_or_BigInt_agg_phase_2 --
+12 15
+
+-- !sql_group_bit_or_BigInt_agg_phase_3 --
+0 \N
+7 7
+5 15
+
+-- !sql_group_bit_or_BigInt_agg_phase_4 --
+12 15
+
+-- !sql_group_bit_or_BigInt_gb_notnull --
+7
+15
+
+-- !sql_group_bit_or_BigInt_notnull --
+15
+
+-- !sql_group_bit_or_BigInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_or_BigInt_agg_phase_2_notnull --
+12 15
+
+-- !sql_group_bit_or_BigInt_agg_phase_3_notnull --
+0 \N
+7 7
+5 15
+
+-- !sql_group_bit_or_BigInt_agg_phase_4_notnull --
+12 15
+
+-- !sql_group_bit_or_LargeInt_gb --
+\N
+7
+15
+
+-- !sql_group_bit_or_LargeInt --
+15
+
+-- !sql_group_bit_or_LargeInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_or_LargeInt_agg_phase_2 --
+12 15
+
+-- !sql_group_bit_or_LargeInt_agg_phase_3 --
+0 \N
+7 7
+5 15
+
+-- !sql_group_bit_or_LargeInt_agg_phase_4 --
+12 15
+
+-- !sql_group_bit_or_LargeInt_gb_notnull --
+7
+15
+
+-- !sql_group_bit_or_LargeInt_notnull --
+15
+
+-- !sql_group_bit_or_LargeInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_or_LargeInt_agg_phase_2_notnull --
+12 15
+
+-- !sql_group_bit_or_LargeInt_agg_phase_3_notnull --
+0 \N
+7 7
+5 15
+
+-- !sql_group_bit_or_LargeInt_agg_phase_4_notnull --
+12 15
+
+-- !sql_group_bit_xor_TinyInt_gb --
+\N
+0
+12
+
+-- !sql_group_bit_xor_TinyInt --
+12
+
+-- !sql_group_bit_xor_TinyInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_xor_TinyInt_agg_phase_2 --
+12 12
+
+-- !sql_group_bit_xor_TinyInt_agg_phase_3 --
+0 \N
+7 0
+5 12
+
+-- !sql_group_bit_xor_TinyInt_agg_phase_4 --
+12 12
+
+-- !sql_group_bit_xor_TinyInt_gb_notnull --
+0
+12
+
+-- !sql_group_bit_xor_TinyInt_notnull --
+12
+
+-- !sql_group_bit_xor_TinyInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_xor_TinyInt_agg_phase_2_notnull --
+12 12
+
+-- !sql_group_bit_xor_TinyInt_agg_phase_3_notnull --
+0 \N
+7 0
+5 12
+
+-- !sql_group_bit_xor_TinyInt_agg_phase_4_notnull --
+12 12
+
+-- !sql_group_bit_xor_SmallInt_gb --
+\N
+0
+12
+
+-- !sql_group_bit_xor_SmallInt --
+12
+
+-- !sql_group_bit_xor_SmallInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_xor_SmallInt_agg_phase_2 --
+12 12
+
+-- !sql_group_bit_xor_SmallInt_agg_phase_3 --
+0 \N
+7 0
+5 12
+
+-- !sql_group_bit_xor_SmallInt_agg_phase_4 --
+12 12
+
+-- !sql_group_bit_xor_SmallInt_gb_notnull --
+0
+12
+
+-- !sql_group_bit_xor_SmallInt_notnull --
+12
+
+-- !sql_group_bit_xor_SmallInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_xor_SmallInt_agg_phase_2_notnull --
+12 12
+
+-- !sql_group_bit_xor_SmallInt_agg_phase_3_notnull --
+0 \N
+7 0
+5 12
+
+-- !sql_group_bit_xor_SmallInt_agg_phase_4_notnull --
+12 12
+
+-- !sql_group_bit_xor_Integer_gb --
+\N
+0
+12
+
+-- !sql_group_bit_xor_Integer --
+12
+
+-- !sql_group_bit_xor_Integer_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_xor_Integer_agg_phase_2 --
+12 12
+
+-- !sql_group_bit_xor_Integer_agg_phase_3 --
+0 \N
+7 0
+5 12
+
+-- !sql_group_bit_xor_Integer_agg_phase_4 --
+12 12
+
+-- !sql_group_bit_xor_Integer_gb_notnull --
+0
+12
+
+-- !sql_group_bit_xor_Integer_notnull --
+12
+
+-- !sql_group_bit_xor_Integer_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_xor_Integer_agg_phase_2_notnull --
+12 12
+
+-- !sql_group_bit_xor_Integer_agg_phase_3_notnull --
+0 \N
+7 0
+5 12
+
+-- !sql_group_bit_xor_Integer_agg_phase_4_notnull --
+12 12
+
+-- !sql_group_bit_xor_BigInt_gb --
+\N
+0
+12
+
+-- !sql_group_bit_xor_BigInt --
+12
+
+-- !sql_group_bit_xor_BigInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_xor_BigInt_agg_phase_2 --
+12 12
+
+-- !sql_group_bit_xor_BigInt_agg_phase_3 --
+0 \N
+7 0
+5 12
+
+-- !sql_group_bit_xor_BigInt_agg_phase_4 --
+12 12
+
+-- !sql_group_bit_xor_BigInt_gb_notnull --
+0
+12
+
+-- !sql_group_bit_xor_BigInt_notnull --
+12
+
+-- !sql_group_bit_xor_BigInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_xor_BigInt_agg_phase_2_notnull --
+12 12
+
+-- !sql_group_bit_xor_BigInt_agg_phase_3_notnull --
+0 \N
+7 0
+5 12
+
+-- !sql_group_bit_xor_BigInt_agg_phase_4_notnull --
+12 12
+
+-- !sql_group_bit_xor_LargeInt_gb --
+\N
+0
+12
+
+-- !sql_group_bit_xor_LargeInt --
+12
+
+-- !sql_group_bit_xor_LargeInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_xor_LargeInt_agg_phase_2 --
+12 12
+
+-- !sql_group_bit_xor_LargeInt_agg_phase_3 --
+0 \N
+7 0
+5 12
+
+-- !sql_group_bit_xor_LargeInt_agg_phase_4 --
+12 12
+
+-- !sql_group_bit_xor_LargeInt_gb_notnull --
+0
+12
+
+-- !sql_group_bit_xor_LargeInt_notnull --
+12
+
+-- !sql_group_bit_xor_LargeInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_bit_xor_LargeInt_agg_phase_2_notnull --
+12 12
+
+-- !sql_group_bit_xor_LargeInt_agg_phase_3_notnull --
+0 \N
+7 0
+5 12
+
+-- !sql_group_bit_xor_LargeInt_agg_phase_4_notnull --
+12 12
+
+-- !sql_group_bitmap_xor_Bitmap_gb --
+\N
+\N
+\N
+
+-- !sql_group_bitmap_xor_Bitmap --
+\N
+
+-- !sql_group_bitmap_xor_Bitmap_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_group_bitmap_xor_Bitmap_agg_phase_2 --
+12 \N
+
+-- !sql_group_bitmap_xor_Bitmap_agg_phase_3 --
+0 \N
+7 \N
+5 \N
+
+-- !sql_group_bitmap_xor_Bitmap_agg_phase_4 --
+12 \N
+
+-- !sql_group_bitmap_xor_Bitmap_gb_notnull --
+\N
+\N
+
+-- !sql_group_bitmap_xor_Bitmap_notnull --
+\N
+
+-- !sql_group_bitmap_xor_Bitmap_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_group_bitmap_xor_Bitmap_agg_phase_2_notnull --
+12 \N
+
+-- !sql_group_bitmap_xor_Bitmap_agg_phase_3_notnull --
+0 \N
+7 \N
+5 \N
+
+-- !sql_group_bitmap_xor_Bitmap_agg_phase_4_notnull --
+12 \N
+
+-- !sql_group_concat_Varchar_gb --
+\N
+1, 2, 3, 4, 5, 6, 7
+8, 9, 10, 11, 12
+
+-- !sql_group_concat_Varchar_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_concat_Varchar_gb_notnull --
+1, 2, 3, 4, 5, 6, 7
+8, 9, 10, 11, 12
+
+-- !sql_group_concat_Varchar_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_concat_Varchar_AnyData_gb --
+\N
+1, 2, 3, 4, 5, 6, 7
+8, 9, 10, 11, 12
+
+-- !sql_group_concat_Varchar_AnyData_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_concat_Varchar_AnyData_gb_notnull --
+1, 2, 3, 4, 5, 6, 7
+8, 9, 10, 11, 12
+
+-- !sql_group_concat_Varchar_AnyData_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_concat_Varchar_Varchar_AnyData_gb --
+\N
+1_x_2_x_3_x_4_x_5_x_6_x_7
+8_x_9_x_10_x_11_x_12
+
+-- !sql_group_concat_Varchar_Varchar_AnyData_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_group_concat_Varchar_Varchar_AnyData_gb_notnull --
+1_x_2_x_3_x_4_x_5_x_6_x_7
+8_x_9_x_10_x_11_x_12
+
+-- !sql_group_concat_Varchar_Varchar_AnyData_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_max_by_AnyData_AnyData_gb --
+\N
+7
+12
+
+-- !sql_max_by_AnyData_AnyData --
+12
+
+-- !sql_max_by_AnyData_AnyData_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_max_by_AnyData_AnyData_agg_phase_2 --
+12 12
+
+-- !sql_max_by_AnyData_AnyData_agg_phase_3 --
+0 \N
+7 7
+5 12
+
+-- !sql_max_by_AnyData_AnyData_agg_phase_4 --
+12 12
+
+-- !sql_max_by_AnyData_AnyData_gb_notnull --
+7
+12
+
+-- !sql_max_by_AnyData_AnyData_notnull --
+12
+
+-- !sql_max_by_AnyData_AnyData_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_max_by_AnyData_AnyData_agg_phase_2_notnull --
+12 12
+
+-- !sql_max_by_AnyData_AnyData_agg_phase_3_notnull --
+0 \N
+7 7
+5 12
+
+-- !sql_max_by_AnyData_AnyData_agg_phase_4_notnull --
+12 12
+
+-- !sql_min_by_AnyData_AnyData_gb --
+\N
+1
+8
+
+-- !sql_min_by_AnyData_AnyData --
+1
+
+-- !sql_min_by_AnyData_AnyData_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_min_by_AnyData_AnyData_agg_phase_2 --
+12 1
+
+-- !sql_min_by_AnyData_AnyData_agg_phase_3 --
+0 \N
+7 1
+5 8
+
+-- !sql_min_by_AnyData_AnyData_agg_phase_4 --
+12 1
+
+-- !sql_min_by_AnyData_AnyData_gb_notnull --
+1
+8
+
+-- !sql_min_by_AnyData_AnyData_notnull --
+1
+
+-- !sql_min_by_AnyData_AnyData_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_min_by_AnyData_AnyData_agg_phase_2_notnull --
+12 1
+
+-- !sql_min_by_AnyData_AnyData_agg_phase_3_notnull --
+0 \N
+7 1
+5 8
+
+-- !sql_min_by_AnyData_AnyData_agg_phase_4_notnull --
+12 1
+
+-- !sql_ndv_AnyData_gb --
+0
+7
+5
+
+-- !sql_ndv_AnyData --
+12
+
+-- !sql_ndv_AnyData_agg_phase_1 --
+0 0
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_ndv_AnyData_agg_phase_2 --
+12 12
+
+-- !sql_ndv_AnyData_agg_phase_3 --
+0 0
+7 7
+5 5
+
+-- !sql_ndv_AnyData_agg_phase_4 --
+12 12
+
+-- !sql_ndv_AnyData_gb_notnull --
+7
+5
+
+-- !sql_ndv_AnyData_notnull --
+12
+
+-- !sql_ndv_AnyData_agg_phase_1_notnull --
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_ndv_AnyData_agg_phase_2_notnull --
+12 12
+
+-- !sql_ndv_AnyData_agg_phase_3_notnull --
+0 0
+7 7
+5 5
+
+-- !sql_ndv_AnyData_agg_phase_4_notnull --
+12 12
+
+-- !sql_orthogonal_bitmap_union_count_Bitmap_gb --
+0
+7
+5
+
+-- !sql_orthogonal_bitmap_union_count_Bitmap --
+12
+
+-- !sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_1 --
+0 0
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_3 --
+0 0
+7 0
+5 0
+
+-- !sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_4 --
+12 0
+
+-- !sql_orthogonal_bitmap_union_count_Bitmap_gb_notnull --
+7
+5
+
+-- !sql_orthogonal_bitmap_union_count_Bitmap_notnull --
+12
+
+-- !sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_1_notnull --
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+1 1
+
+-- !sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_3_notnull --
+0 0
+7 0
+5 0
+
+-- !sql_orthogonal_bitmap_union_count_Bitmap_agg_phase_4_notnull --
+12 0
+
+-- !sql_percentile_BigInt_Double_gb --
+\N
+4.6
+10.399999999999999
+
+-- !sql_percentile_BigInt_Double --
+7.6
+
+-- !sql_percentile_BigInt_Double_agg_phase_1 --
+0 \N
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_percentile_BigInt_Double_agg_phase_2 --
+12 7.6
+
+-- !sql_percentile_BigInt_Double_agg_phase_3 --
+0 \N
+7 4.6
+5 10.399999999999999
+
+-- !sql_percentile_BigInt_Double_agg_phase_4 --
+12 7.6
+
+-- !sql_percentile_BigInt_Double_gb_notnull --
+4.6
+10.399999999999999
+
+-- !sql_percentile_BigInt_Double_notnull --
+7.6
+
+-- !sql_percentile_BigInt_Double_agg_phase_1_notnull --
+1 1.0
+1 2.0
+1 3.0
+1 4.0
+1 5.0
+1 6.0
+1 7.0
+1 8.0
+1 9.0
+1 10.0
+1 11.0
+1 12.0
+
+-- !sql_percentile_BigInt_Double_agg_phase_2_notnull --
+12 7.6
+
+-- !sql_percentile_BigInt_Double_agg_phase_3_notnull --
+0 \N
+7 4.6
+5 10.399999999999999
+
+-- !sql_percentile_BigInt_Double_agg_phase_4_notnull --
+12 7.6
+
+-- !sql_percentile_approx_Double_Double_gb --
+\N
+0.4700000286102295
+1.0499999523162842
+
+-- !sql_percentile_approx_Double_Double --
+0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_agg_phase_1 --
+0 \N
+1 0.10000000149011612
+1 0.20000000298023224
+1 0.30000001192092896
+1 0.4000000059604645
+1 0.5
+1 0.6000000238418579
+1 0.699999988079071
+1 0.800000011920929
+1 0.8999999761581421
+1 1.0
+1 1.100000023841858
+1 1.2000000476837158
+
+-- !sql_percentile_approx_Double_Double_agg_phase_2 --
+12 0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_agg_phase_3 --
+0 \N
+7 0.4700000286102295
+5 1.0499999523162842
+
+-- !sql_percentile_approx_Double_Double_agg_phase_4 --
+12 0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_gb_notnull --
+0.4700000286102295
+1.0499999523162842
+
+-- !sql_percentile_approx_Double_Double_notnull --
+0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_agg_phase_1_notnull --
+1 0.10000000149011612
+1 0.20000000298023224
+1 0.30000001192092896
+1 0.4000000059604645
+1 0.5
+1 0.6000000238418579
+1 0.699999988079071
+1 0.800000011920929
+1 0.8999999761581421
+1 1.0
+1 1.100000023841858
+1 1.2000000476837158
+
+-- !sql_percentile_approx_Double_Double_agg_phase_2_notnull --
+12 0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_agg_phase_3_notnull --
+0 \N
+7 0.4700000286102295
+5 1.0499999523162842
+
+-- !sql_percentile_approx_Double_Double_agg_phase_4_notnull --
+12 0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_Double_gb --
+\N
+0.4700000286102295
+1.0499999523162842
+
+-- !sql_percentile_approx_Double_Double_Double --
+0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_Double_agg_phase_1 --
+0 \N
+1 0.10000000149011612
+1 0.20000000298023224
+1 0.30000001192092896
+1 0.4000000059604645
+1 0.5
+1 0.6000000238418579
+1 0.699999988079071
+1 0.800000011920929
+1 0.8999999761581421
+1 1.0
+1 1.100000023841858
+1 1.2000000476837158
+
+-- !sql_percentile_approx_Double_Double_Double_agg_phase_2 --
+12 0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_Double_agg_phase_3 --
+0 \N
+7 0.4700000286102295
+5 1.0499999523162842
+
+-- !sql_percentile_approx_Double_Double_Double_agg_phase_4 --
+12 0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_Double_gb_notnull --
+0.4700000286102295
+1.0499999523162842
+
+-- !sql_percentile_approx_Double_Double_Double_notnull --
+0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_Double_agg_phase_1_notnull --
+1 0.10000000149011612
+1 0.20000000298023224
+1 0.30000001192092896
+1 0.4000000059604645
+1 0.5
+1 0.6000000238418579
+1 0.699999988079071
+1 0.800000011920929
+1 0.8999999761581421
+1 1.0
+1 1.100000023841858
+1 1.2000000476837158
+
+-- !sql_percentile_approx_Double_Double_Double_agg_phase_2_notnull --
+12 0.7700000405311584
+
+-- !sql_percentile_approx_Double_Double_Double_agg_phase_3_notnull --
+0 \N
+7 0.4700000286102295
+5 1.0499999523162842
+
+-- !sql_percentile_approx_Double_Double_Double_agg_phase_4_notnull --
+12 0.7700000405311584
+
+-- !sql_sequence_count_String_DateV2_Boolean_gb --
+0
+1
+0
+
+-- !sql_sequence_count_String_DateV2_Boolean --
+1
+
+-- !sql_sequence_count_String_DateV2_Boolean_agg_phase_1 --
+0 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+
+-- !sql_sequence_count_String_DateV2_Boolean_agg_phase_2 --
+12 1
+
+-- !sql_sequence_count_String_DateV2_Boolean_agg_phase_3 --
+0 0
+7 1
+5 0
+
+-- !sql_sequence_count_String_DateV2_Boolean_agg_phase_4 --
+12 1
+
+-- !sql_sequence_count_String_DateV2_Boolean_gb_notnull --
+1
+0
+
+-- !sql_sequence_count_String_DateV2_Boolean_notnull --
+1
+
+-- !sql_sequence_count_String_DateV2_Boolean_agg_phase_1_notnull --
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+
+-- !sql_sequence_count_String_DateV2_Boolean_agg_phase_2_notnull --
+12 1
+
+-- !sql_sequence_count_String_DateV2_Boolean_agg_phase_3_notnull --
+0 0
+7 1
+5 0
+
+-- !sql_sequence_count_String_DateV2_Boolean_agg_phase_4_notnull --
+12 1
+
+-- !sql_sequence_count_String_DateTime_Boolean_gb --
+0
+1
+0
+
+-- !sql_sequence_count_String_DateTime_Boolean --
+1
+
+-- !sql_sequence_count_String_DateTime_Boolean_agg_phase_1 --
+0 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+
+-- !sql_sequence_count_String_DateTime_Boolean_agg_phase_2 --
+12 1
+
+-- !sql_sequence_count_String_DateTime_Boolean_agg_phase_3 --
+0 0
+7 1
+5 0
+
+-- !sql_sequence_count_String_DateTime_Boolean_agg_phase_4 --
+12 1
+
+-- !sql_sequence_count_String_DateTime_Boolean_gb_notnull --
+1
+0
+
+-- !sql_sequence_count_String_DateTime_Boolean_notnull --
+1
+
+-- !sql_sequence_count_String_DateTime_Boolean_agg_phase_1_notnull --
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+
+-- !sql_sequence_count_String_DateTime_Boolean_agg_phase_2_notnull --
+12 1
+
+-- !sql_sequence_count_String_DateTime_Boolean_agg_phase_3_notnull --
+0 0
+7 1
+5 0
+
+-- !sql_sequence_count_String_DateTime_Boolean_agg_phase_4_notnull --
+12 1
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_gb --
+0
+1
+0
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean --
+1
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_1 --
+0 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_2 --
+12 1
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_3 --
+0 0
+7 1
+5 0
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_4 --
+12 1
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_gb_notnull --
+1
+0
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_notnull --
+1
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_1_notnull --
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_2_notnull --
+12 1
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_3_notnull --
+0 0
+7 1
+5 0
+
+-- !sql_sequence_count_String_DateTimeV2_Boolean_agg_phase_4_notnull --
+12 1
+
+-- !sql_sequence_match_String_DateV2_Boolean_gb --
+false
+true
+false
+
+-- !sql_sequence_match_String_DateV2_Boolean --
+true
+
+-- !sql_sequence_match_String_DateV2_Boolean_agg_phase_1 --
+0 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+
+-- !sql_sequence_match_String_DateV2_Boolean_agg_phase_2 --
+12 true
+
+-- !sql_sequence_match_String_DateV2_Boolean_agg_phase_3 --
+0 false
+7 true
+5 false
+
+-- !sql_sequence_match_String_DateV2_Boolean_agg_phase_4 --
+12 true
+
+-- !sql_sequence_match_String_DateV2_Boolean_gb_notnull --
+true
+false
+
+-- !sql_sequence_match_String_DateV2_Boolean_notnull --
+true
+
+-- !sql_sequence_match_String_DateV2_Boolean_agg_phase_1_notnull --
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+
+-- !sql_sequence_match_String_DateV2_Boolean_agg_phase_2_notnull --
+12 true
+
+-- !sql_sequence_match_String_DateV2_Boolean_agg_phase_3_notnull --
+0 false
+7 true
+5 false
+
+-- !sql_sequence_match_String_DateV2_Boolean_agg_phase_4_notnull --
+12 true
+
+-- !sql_sequence_match_String_DateTime_Boolean_gb --
+false
+true
+false
+
+-- !sql_sequence_match_String_DateTime_Boolean --
+true
+
+-- !sql_sequence_match_String_DateTime_Boolean_agg_phase_1 --
+0 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+
+-- !sql_sequence_match_String_DateTime_Boolean_agg_phase_2 --
+12 true
+
+-- !sql_sequence_match_String_DateTime_Boolean_agg_phase_3 --
+0 false
+7 true
+5 false
+
+-- !sql_sequence_match_String_DateTime_Boolean_agg_phase_4 --
+12 true
+
+-- !sql_sequence_match_String_DateTime_Boolean_gb_notnull --
+true
+false
+
+-- !sql_sequence_match_String_DateTime_Boolean_notnull --
+true
+
+-- !sql_sequence_match_String_DateTime_Boolean_agg_phase_1_notnull --
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+
+-- !sql_sequence_match_String_DateTime_Boolean_agg_phase_2_notnull --
+12 true
+
+-- !sql_sequence_match_String_DateTime_Boolean_agg_phase_3_notnull --
+0 false
+7 true
+5 false
+
+-- !sql_sequence_match_String_DateTime_Boolean_agg_phase_4_notnull --
+12 true
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_gb --
+false
+true
+false
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean --
+true
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_1 --
+0 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_2 --
+12 true
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_3 --
+0 false
+7 true
+5 false
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_4 --
+12 true
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_gb_notnull --
+true
+false
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_notnull --
+true
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_1_notnull --
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+1 false
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_2_notnull --
+12 true
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_3_notnull --
+0 false
+7 true
+5 false
+
+-- !sql_sequence_match_String_DateTimeV2_Boolean_agg_phase_4_notnull --
+12 true
+
+-- !sql_stddev_TinyInt_gb --
+\N
+2.0
+1.4142135623730951
+
+-- !sql_stddev_TinyInt --
+3.452052529534663
+
+-- !sql_stddev_TinyInt_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_TinyInt_agg_phase_2 --
+12 3.452052529534663
+
+-- !sql_stddev_TinyInt_agg_phase_3 --
+0 \N
+7 1.9999999999999998
+5 1.4142135623730951
+
+-- !sql_stddev_TinyInt_agg_phase_4 --
+12 3.452052529534663
+
+-- !sql_stddev_TinyInt_gb_notnull --
+2.0
+1.4142135623730951
+
+-- !sql_stddev_TinyInt_notnull --
+3.452052529534663
+
+-- !sql_stddev_TinyInt_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_TinyInt_agg_phase_2_notnull --
+12 3.452052529534663
+
+-- !sql_stddev_TinyInt_agg_phase_3_notnull --
+0 \N
+7 1.9999999999999998
+5 1.414213562373095
+
+-- !sql_stddev_TinyInt_agg_phase_4_notnull --
+12 3.452052529534663
+
+-- !sql_stddev_SmallInt_gb --
+\N
+2.0
+1.4142135623730951
+
+-- !sql_stddev_SmallInt --
+3.452052529534663
+
+-- !sql_stddev_SmallInt_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_SmallInt_agg_phase_2 --
+12 3.452052529534663
+
+-- !sql_stddev_SmallInt_agg_phase_3 --
+0 \N
+7 2.0
+5 1.4142135623730951
+
+-- !sql_stddev_SmallInt_agg_phase_4 --
+12 3.452052529534663
+
+-- !sql_stddev_SmallInt_gb_notnull --
+2.0
+1.4142135623730951
+
+-- !sql_stddev_SmallInt_notnull --
+3.452052529534663
+
+-- !sql_stddev_SmallInt_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_SmallInt_agg_phase_2_notnull --
+12 3.452052529534663
+
+-- !sql_stddev_SmallInt_agg_phase_3_notnull --
+0 \N
+7 2.0
+5 1.4142135623730951
+
+-- !sql_stddev_SmallInt_agg_phase_4_notnull --
+12 3.452052529534663
+
+-- !sql_stddev_Integer_gb --
+\N
+2.0
+1.4142135623730954
+
+-- !sql_stddev_Integer --
+3.452052529534663
+
+-- !sql_stddev_Integer_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_Integer_agg_phase_2 --
+12 3.452052529534663
+
+-- !sql_stddev_Integer_agg_phase_3 --
+0 \N
+7 2.0
+5 1.4142135623730951
+
+-- !sql_stddev_Integer_agg_phase_4 --
+12 3.452052529534663
+
+-- !sql_stddev_Integer_gb_notnull --
+1.9999999999999998
+1.4142135623730951
+
+-- !sql_stddev_Integer_notnull --
+3.452052529534663
+
+-- !sql_stddev_Integer_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_Integer_agg_phase_2_notnull --
+12 3.452052529534663
+
+-- !sql_stddev_Integer_agg_phase_3_notnull --
+0 \N
+7 1.9999999999999998
+5 1.414213562373095
+
+-- !sql_stddev_Integer_agg_phase_4_notnull --
+12 3.452052529534663
+
+-- !sql_stddev_BigInt_gb --
+\N
+2.0
+1.414213562373095
+
+-- !sql_stddev_BigInt --
+3.452052529534663
+
+-- !sql_stddev_BigInt_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_BigInt_agg_phase_2 --
+12 3.452052529534663
+
+-- !sql_stddev_BigInt_agg_phase_3 --
+0 \N
+7 2.0
+5 1.4142135623730951
+
+-- !sql_stddev_BigInt_agg_phase_4 --
+12 3.452052529534663
+
+-- !sql_stddev_BigInt_gb_notnull --
+2.0
+1.4142135623730951
+
+-- !sql_stddev_BigInt_notnull --
+3.452052529534664
+
+-- !sql_stddev_BigInt_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_BigInt_agg_phase_2_notnull --
+12 3.452052529534663
+
+-- !sql_stddev_BigInt_agg_phase_3_notnull --
+0 \N
+7 2.0
+5 1.4142135623730951
+
+-- !sql_stddev_BigInt_agg_phase_4_notnull --
+12 3.452052529534663
+
+-- !sql_stddev_Float_gb --
+\N
+0.1999999992549422
+0.1414213730960499
+
+-- !sql_stddev_Float --
+0.34520525854707257
+
+-- !sql_stddev_Float_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_Float_agg_phase_2 --
+12 0.3452052585470726
+
+-- !sql_stddev_Float_agg_phase_3 --
+0 \N
+7 0.1999999992549422
+5 0.1414213730960499
+
+-- !sql_stddev_Float_agg_phase_4 --
+12 0.3452052585470726
+
+-- !sql_stddev_Float_gb_notnull --
+0.1999999992549422
+0.1414213730960499
+
+-- !sql_stddev_Float_notnull --
+0.3452052585470726
+
+-- !sql_stddev_Float_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_Float_agg_phase_2_notnull --
+12 0.34520525854707257
+
+-- !sql_stddev_Float_agg_phase_3_notnull --
+0 \N
+7 0.1999999992549422
+5 0.1414213730960499
+
+-- !sql_stddev_Float_agg_phase_4_notnull --
+12 0.34520525854707257
+
+-- !sql_stddev_Double_gb --
+\N
+0.19999999999999998
+0.1414213562373095
+
+-- !sql_stddev_Double --
+0.3452052529534663
+
+-- !sql_stddev_Double_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_Double_agg_phase_2 --
+12 0.3452052529534663
+
+-- !sql_stddev_Double_agg_phase_3 --
+0 \N
+7 0.19999999999999998
+5 0.1414213562373095
+
+-- !sql_stddev_Double_agg_phase_4 --
+12 0.3452052529534663
+
+-- !sql_stddev_Double_gb_notnull --
+0.19999999999999996
+0.1414213562373095
+
+-- !sql_stddev_Double_notnull --
+0.3452052529534663
+
+-- !sql_stddev_Double_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_stddev_Double_agg_phase_2_notnull --
+12 0.3452052529534663
+
+-- !sql_stddev_Double_agg_phase_3_notnull --
+0 \N
+7 0.19999999999999996
+5 0.1414213562373095
+
+-- !sql_stddev_Double_agg_phase_4_notnull --
+12 0.3452052529534663
+
+-- !sql_stddev_DecimalV2_gb --
+\N
+0.200000000
+0.141421356
+
+-- !sql_stddev_DecimalV2_agg_phase_1 --
+0 \N
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+
+-- !sql_stddev_DecimalV2_agg_phase_2 --
+12 0.345205253
+
+-- !sql_stddev_DecimalV2_agg_phase_3 --
+0 \N
+7 0.200000000
+5 0.141421356
+
+-- !sql_stddev_DecimalV2_agg_phase_4 --
+12 0.345205253
+
+-- !sql_stddev_DecimalV2_gb_notnull --
+0.200000000
+0.141421356
+
+-- !sql_stddev_DecimalV2_agg_phase_1_notnull --
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+
+-- !sql_stddev_DecimalV2_agg_phase_2_notnull --
+12 0.345205253
+
+-- !sql_stddev_DecimalV2_agg_phase_3_notnull --
+0 \N
+7 0.200000000
+5 0.141421356
+
+-- !sql_stddev_DecimalV2_agg_phase_4_notnull --
+12 0.345205253
+
+-- !sql_stddev_samp_TinyInt_gb --
+\N
+2.160246899469287
+1.5811388300841898
+
+-- !sql_stddev_samp_TinyInt --
+3.605551275463989
+
+-- !sql_stddev_samp_TinyInt_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_TinyInt_agg_phase_2 --
+12 3.605551275463989
+
+-- !sql_stddev_samp_TinyInt_agg_phase_3 --
+0 \N
+7 2.160246899469287
+5 1.58113883008419
+
+-- !sql_stddev_samp_TinyInt_agg_phase_4 --
+12 3.605551275463989
+
+-- !sql_stddev_samp_TinyInt_gb_notnull --
+2.160246899469287
+1.5811388300841898
+
+-- !sql_stddev_samp_TinyInt_notnull --
+3.6055512754639896
+
+-- !sql_stddev_samp_TinyInt_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_TinyInt_agg_phase_2_notnull --
+12 3.605551275463989
+
+-- !sql_stddev_samp_TinyInt_agg_phase_3_notnull --
+0 \N
+7 2.160246899469287
+5 1.5811388300841898
+
+-- !sql_stddev_samp_TinyInt_agg_phase_4_notnull --
+12 3.605551275463989
+
+-- !sql_stddev_samp_SmallInt_gb --
+\N
+2.160246899469287
+1.5811388300841898
+
+-- !sql_stddev_samp_SmallInt --
+3.605551275463989
+
+-- !sql_stddev_samp_SmallInt_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_SmallInt_agg_phase_2 --
+12 3.605551275463989
+
+-- !sql_stddev_samp_SmallInt_agg_phase_3 --
+0 \N
+7 2.160246899469287
+5 1.5811388300841898
+
+-- !sql_stddev_samp_SmallInt_agg_phase_4 --
+12 3.605551275463989
+
+-- !sql_stddev_samp_SmallInt_gb_notnull --
+2.160246899469287
+1.5811388300841898
+
+-- !sql_stddev_samp_SmallInt_notnull --
+3.605551275463989
+
+-- !sql_stddev_samp_SmallInt_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_SmallInt_agg_phase_2_notnull --
+12 3.605551275463989
+
+-- !sql_stddev_samp_SmallInt_agg_phase_3_notnull --
+0 \N
+7 2.160246899469287
+5 1.5811388300841898
+
+-- !sql_stddev_samp_SmallInt_agg_phase_4_notnull --
+12 3.605551275463989
+
+-- !sql_stddev_samp_Integer_gb --
+\N
+2.160246899469287
+1.58113883008419
+
+-- !sql_stddev_samp_Integer --
+3.605551275463989
+
+-- !sql_stddev_samp_Integer_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_Integer_agg_phase_2 --
+12 3.605551275463989
+
+-- !sql_stddev_samp_Integer_agg_phase_3 --
+0 \N
+7 2.1602468994692865
+5 1.5811388300841898
+
+-- !sql_stddev_samp_Integer_agg_phase_4 --
+12 3.605551275463989
+
+-- !sql_stddev_samp_Integer_gb_notnull --
+2.160246899469287
+1.5811388300841898
+
+-- !sql_stddev_samp_Integer_notnull --
+3.605551275463989
+
+-- !sql_stddev_samp_Integer_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_Integer_agg_phase_2_notnull --
+12 3.605551275463989
+
+-- !sql_stddev_samp_Integer_agg_phase_3_notnull --
+0 \N
+7 2.1602468994692865
+5 1.5811388300841893
+
+-- !sql_stddev_samp_Integer_agg_phase_4_notnull --
+12 3.605551275463989
+
+-- !sql_stddev_samp_BigInt_gb --
+\N
+2.160246899469287
+1.58113883008419
+
+-- !sql_stddev_samp_BigInt --
+3.605551275463989
+
+-- !sql_stddev_samp_BigInt_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_BigInt_agg_phase_2 --
+12 3.605551275463989
+
+-- !sql_stddev_samp_BigInt_agg_phase_3 --
+0 \N
+7 2.160246899469287
+5 1.5811388300841898
+
+-- !sql_stddev_samp_BigInt_agg_phase_4 --
+12 3.605551275463989
+
+-- !sql_stddev_samp_BigInt_gb_notnull --
+2.160246899469287
+1.5811388300841898
+
+-- !sql_stddev_samp_BigInt_notnull --
+3.6055512754639896
+
+-- !sql_stddev_samp_BigInt_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_BigInt_agg_phase_2_notnull --
+12 3.605551275463989
+
+-- !sql_stddev_samp_BigInt_agg_phase_3_notnull --
+0 \N
+7 2.160246899469287
+5 1.5811388300841898
+
+-- !sql_stddev_samp_BigInt_agg_phase_4_notnull --
+12 3.605551275463989
+
+-- !sql_stddev_samp_Float_gb --
+\N
+0.2160246891421743
+0.15811390185706375
+
+-- !sql_stddev_samp_Float --
+0.3605551333887302
+
+-- !sql_stddev_samp_Float_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_Float_agg_phase_2 --
+12 0.36055513338873013
+
+-- !sql_stddev_samp_Float_agg_phase_3 --
+0 \N
+7 0.2160246891421743
+5 0.15811390185706375
+
+-- !sql_stddev_samp_Float_agg_phase_4 --
+12 0.36055513338873013
+
+-- !sql_stddev_samp_Float_gb_notnull --
+0.2160246891421743
+0.15811390185706375
+
+-- !sql_stddev_samp_Float_notnull --
+0.3605551333887302
+
+-- !sql_stddev_samp_Float_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_Float_agg_phase_2_notnull --
+12 0.36055513338873013
+
+-- !sql_stddev_samp_Float_agg_phase_3_notnull --
+0 \N
+7 0.2160246891421743
+5 0.15811390185706375
+
+-- !sql_stddev_samp_Float_agg_phase_4_notnull --
+12 0.3605551333887302
+
+-- !sql_stddev_samp_Double_gb --
+\N
+0.21602468994692867
+0.15811388300841897
+
+-- !sql_stddev_samp_Double --
+0.36055512754639896
+
+-- !sql_stddev_samp_Double_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_Double_agg_phase_2 --
+12 0.36055512754639896
+
+-- !sql_stddev_samp_Double_agg_phase_3 --
+0 \N
+7 0.21602468994692864
+5 0.15811388300841897
+
+-- !sql_stddev_samp_Double_agg_phase_4 --
+12 0.36055512754639896
+
+-- !sql_stddev_samp_Double_gb_notnull --
+0.21602468994692864
+0.15811388300841897
+
+-- !sql_stddev_samp_Double_notnull --
+0.36055512754639896
+
+-- !sql_stddev_samp_Double_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_Double_agg_phase_2_notnull --
+12 0.36055512754639896
+
+-- !sql_stddev_samp_Double_agg_phase_3_notnull --
+0 \N
+7 0.21602468994692867
+5 0.15811388300841894
+
+-- !sql_stddev_samp_Double_agg_phase_4_notnull --
+12 0.36055512754639896
+
+-- !sql_stddev_samp_DecimalV2_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_DecimalV2_agg_phase_2 --
+12 0.360555127
+
+-- !sql_stddev_samp_DecimalV2_agg_phase_3 --
+0 \N
+7 0.216024690
+5 0.158113883
+
+-- !sql_stddev_samp_DecimalV2_agg_phase_4 --
+12 0.360555127
+
+-- !sql_stddev_samp_DecimalV2_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_stddev_samp_DecimalV2_agg_phase_2_notnull --
+12 0.360555127
+
+-- !sql_stddev_samp_DecimalV2_agg_phase_3_notnull --
+0 \N
+7 0.216024690
+5 0.158113883
+
+-- !sql_stddev_samp_DecimalV2_agg_phase_4_notnull --
+12 0.360555127
+
+-- !sql_sum_TinyInt_gb --
+\N
+28
+50
+
+-- !sql_sum_TinyInt --
+78
+
+-- !sql_sum_TinyInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_sum_TinyInt_agg_phase_2 --
+12 78
+
+-- !sql_sum_TinyInt_agg_phase_3 --
+0 \N
+7 28
+5 50
+
+-- !sql_sum_TinyInt_agg_phase_4 --
+12 78
+
+-- !sql_sum_TinyInt_gb_notnull --
+28
+50
+
+-- !sql_sum_TinyInt_notnull --
+78
+
+-- !sql_sum_TinyInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_sum_TinyInt_agg_phase_2_notnull --
+12 78
+
+-- !sql_sum_TinyInt_agg_phase_3_notnull --
+0 \N
+7 28
+5 50
+
+-- !sql_sum_TinyInt_agg_phase_4_notnull --
+12 78
+
+-- !sql_sum_SmallInt_gb --
+\N
+28
+50
+
+-- !sql_sum_SmallInt --
+78
+
+-- !sql_sum_SmallInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_sum_SmallInt_agg_phase_2 --
+12 78
+
+-- !sql_sum_SmallInt_agg_phase_3 --
+0 \N
+7 28
+5 50
+
+-- !sql_sum_SmallInt_agg_phase_4 --
+12 78
+
+-- !sql_sum_SmallInt_gb_notnull --
+28
+50
+
+-- !sql_sum_SmallInt_notnull --
+78
+
+-- !sql_sum_SmallInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_sum_SmallInt_agg_phase_2_notnull --
+12 78
+
+-- !sql_sum_SmallInt_agg_phase_3_notnull --
+0 \N
+7 28
+5 50
+
+-- !sql_sum_SmallInt_agg_phase_4_notnull --
+12 78
+
+-- !sql_sum_Integer_gb --
+\N
+28
+50
+
+-- !sql_sum_Integer --
+78
+
+-- !sql_sum_Integer_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_sum_Integer_agg_phase_2 --
+12 78
+
+-- !sql_sum_Integer_agg_phase_3 --
+0 \N
+7 28
+5 50
+
+-- !sql_sum_Integer_agg_phase_4 --
+12 78
+
+-- !sql_sum_Integer_gb_notnull --
+28
+50
+
+-- !sql_sum_Integer_notnull --
+78
+
+-- !sql_sum_Integer_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_sum_Integer_agg_phase_2_notnull --
+12 78
+
+-- !sql_sum_Integer_agg_phase_3_notnull --
+0 \N
+7 28
+5 50
+
+-- !sql_sum_Integer_agg_phase_4_notnull --
+12 78
+
+-- !sql_sum_BigInt_gb --
+\N
+28
+50
+
+-- !sql_sum_BigInt --
+78
+
+-- !sql_sum_BigInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_sum_BigInt_agg_phase_2 --
+12 78
+
+-- !sql_sum_BigInt_agg_phase_3 --
+0 \N
+7 28
+5 50
+
+-- !sql_sum_BigInt_agg_phase_4 --
+12 78
+
+-- !sql_sum_BigInt_gb_notnull --
+28
+50
+
+-- !sql_sum_BigInt_notnull --
+78
+
+-- !sql_sum_BigInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_sum_BigInt_agg_phase_2_notnull --
+12 78
+
+-- !sql_sum_BigInt_agg_phase_3_notnull --
+0 \N
+7 28
+5 50
+
+-- !sql_sum_BigInt_agg_phase_4_notnull --
+12 78
+
+-- !sql_sum_Double_gb --
+\N
+2.8000000000000003
+5.0
+
+-- !sql_sum_Double --
+7.800000000000001
+
+-- !sql_sum_Double_agg_phase_1 --
+0 \N
+1 0.1
+1 0.2
+1 0.3
+1 0.4
+1 0.5
+1 0.6
+1 0.7
+1 0.8
+1 0.9
+1 1.0
+1 1.1
+1 1.2
+
+-- !sql_sum_Double_agg_phase_2 --
+12 7.8
+
+-- !sql_sum_Double_agg_phase_3 --
+0 \N
+7 2.8
+5 5.0
+
+-- !sql_sum_Double_agg_phase_4 --
+12 7.800000000000001
+
+-- !sql_sum_Double_gb_notnull --
+2.8000000000000003
+5.0
+
+-- !sql_sum_Double_notnull --
+7.800000000000001
+
+-- !sql_sum_Double_agg_phase_1_notnull --
+1 0.1
+1 0.2
+1 0.3
+1 0.4
+1 0.5
+1 0.6
+1 0.7
+1 0.8
+1 0.9
+1 1.0
+1 1.1
+1 1.2
+
+-- !sql_sum_Double_agg_phase_2_notnull --
+12 7.8
+
+-- !sql_sum_Double_agg_phase_3_notnull --
+0 \N
+7 2.8000000000000007
+5 5.0
+
+-- !sql_sum_Double_agg_phase_4_notnull --
+12 7.800000000000001
+
+-- !sql_sum_DecimalV2_gb --
+\N
+2.800000000
+5.000000000
+
+-- !sql_sum_DecimalV2 --
+7.800000000
+
+-- !sql_sum_DecimalV2_agg_phase_1 --
+0 \N
+1 0.100000000
+1 0.200000000
+1 0.300000000
+1 0.400000000
+1 0.500000000
+1 0.600000000
+1 0.700000000
+1 0.800000000
+1 0.900000000
+1 1.000000000
+1 1.100000000
+1 1.200000000
+
+-- !sql_sum_DecimalV2_agg_phase_2 --
+12 7.800000000
+
+-- !sql_sum_DecimalV2_agg_phase_3 --
+0 \N
+7 2.800000000
+5 5.000000000
+
+-- !sql_sum_DecimalV2_agg_phase_4 --
+12 7.800000000
+
+-- !sql_sum_DecimalV2_gb_notnull --
+2.800000000
+5.000000000
+
+-- !sql_sum_DecimalV2_notnull --
+7.800000000
+
+-- !sql_sum_DecimalV2_agg_phase_1_notnull --
+1 0.100000000
+1 0.200000000
+1 0.300000000
+1 0.400000000
+1 0.500000000
+1 0.600000000
+1 0.700000000
+1 0.800000000
+1 0.900000000
+1 1.000000000
+1 1.100000000
+1 1.200000000
+
+-- !sql_sum_DecimalV2_agg_phase_2_notnull --
+12 7.800000000
+
+-- !sql_sum_DecimalV2_agg_phase_3_notnull --
+0 \N
+7 2.800000000
+5 5.000000000
+
+-- !sql_sum_DecimalV2_agg_phase_4_notnull --
+12 7.800000000
+
+-- !sql_sum_LargeInt_gb --
+\N
+28
+50
+
+-- !sql_sum_LargeInt --
+78
+
+-- !sql_sum_LargeInt_agg_phase_1 --
+0 \N
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_sum_LargeInt_agg_phase_2 --
+12 78
+
+-- !sql_sum_LargeInt_agg_phase_3 --
+0 \N
+7 28
+5 50
+
+-- !sql_sum_LargeInt_agg_phase_4 --
+12 78
+
+-- !sql_sum_LargeInt_gb_notnull --
+28
+50
+
+-- !sql_sum_LargeInt_notnull --
+78
+
+-- !sql_sum_LargeInt_agg_phase_1_notnull --
+1 1
+1 2
+1 3
+1 4
+1 5
+1 6
+1 7
+1 8
+1 9
+1 10
+1 11
+1 12
+
+-- !sql_sum_LargeInt_agg_phase_2_notnull --
+12 78
+
+-- !sql_sum_LargeInt_agg_phase_3_notnull --
+0 \N
+7 28
+5 50
+
+-- !sql_sum_LargeInt_agg_phase_4_notnull --
+12 78
+
+-- !sql_topn_Varchar_Integer_gb --
+{"null":1}
+{"varchar11":3,"varchar13":2,"varchar12":2}
+{"varchar13":2,"varchar12":2,"varchar11":1}
+
+-- !sql_topn_Varchar_Integer --
+{"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_Varchar_Integer_agg_phase_1 --
+0 {"null":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+
+-- !sql_topn_Varchar_Integer_agg_phase_2 --
+12 {"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_Varchar_Integer_agg_phase_3 --
+0 {"null":1}
+7 {"varchar11":3,"varchar13":2,"varchar12":2}
+5 {"varchar13":2,"varchar12":2,"varchar11":1}
+
+-- !sql_topn_Varchar_Integer_agg_phase_4 --
+12 {"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_Varchar_Integer_gb_notnull --
+{"varchar11":3,"varchar13":2,"varchar12":2}
+{"varchar13":2,"varchar12":2,"varchar11":1}
+
+-- !sql_topn_Varchar_Integer_notnull --
+{"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_Varchar_Integer_agg_phase_1_notnull --
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+
+-- !sql_topn_Varchar_Integer_agg_phase_2_notnull --
+12 {"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_Varchar_Integer_agg_phase_3_notnull --
+0 {"null":1}
+7 {"varchar11":3,"varchar13":2,"varchar12":2}
+5 {"varchar13":2,"varchar12":2,"varchar11":1}
+
+-- !sql_topn_Varchar_Integer_agg_phase_4_notnull --
+12 {"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_String_Integer_gb --
+{"null":1}
+{"string1":3,"string3":2,"string2":2}
+{"string3":2,"string2":2,"string1":1}
+
+-- !sql_topn_String_Integer --
+{"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_String_Integer_agg_phase_1 --
+0 {"null":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+
+-- !sql_topn_String_Integer_agg_phase_2 --
+12 {"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_String_Integer_agg_phase_3 --
+0 {"null":1}
+7 {"string1":3,"string3":2,"string2":2}
+5 {"string3":2,"string2":2,"string1":1}
+
+-- !sql_topn_String_Integer_agg_phase_4 --
+12 {"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_String_Integer_gb_notnull --
+{"string1":3,"string3":2,"string2":2}
+{"string3":2,"string2":2,"string1":1}
+
+-- !sql_topn_String_Integer_notnull --
+{"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_String_Integer_agg_phase_1_notnull --
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+
+-- !sql_topn_String_Integer_agg_phase_2_notnull --
+12 {"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_String_Integer_agg_phase_3_notnull --
+0 {"null":1}
+7 {"string1":3,"string3":2,"string2":2}
+5 {"string3":2,"string2":2,"string1":1}
+
+-- !sql_topn_String_Integer_agg_phase_4_notnull --
+12 {"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_Varchar_Integer_Integer_gb --
+{"null":1}
+{"varchar11":3,"varchar13":2,"varchar12":2}
+{"varchar13":2,"varchar12":2,"varchar11":1}
+
+-- !sql_topn_Varchar_Integer_Integer --
+{"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_Varchar_Integer_Integer_agg_phase_1 --
+0 {"null":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+
+-- !sql_topn_Varchar_Integer_Integer_agg_phase_2 --
+12 {"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_Varchar_Integer_Integer_agg_phase_3 --
+0 {"null":1}
+7 {"varchar11":3,"varchar13":2,"varchar12":2}
+5 {"varchar13":2,"varchar12":2,"varchar11":1}
+
+-- !sql_topn_Varchar_Integer_Integer_agg_phase_4 --
+12 {"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_Varchar_Integer_Integer_gb_notnull --
+{"varchar11":3,"varchar13":2,"varchar12":2}
+{"varchar13":2,"varchar12":2,"varchar11":1}
+
+-- !sql_topn_Varchar_Integer_Integer_notnull --
+{"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_Varchar_Integer_Integer_agg_phase_1_notnull --
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+1 {"varchar11":1}
+1 {"varchar12":1}
+1 {"varchar13":1}
+
+-- !sql_topn_Varchar_Integer_Integer_agg_phase_2_notnull --
+12 {"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_Varchar_Integer_Integer_agg_phase_3_notnull --
+0 {"null":1}
+7 {"varchar11":3,"varchar13":2,"varchar12":2}
+5 {"varchar13":2,"varchar12":2,"varchar11":1}
+
+-- !sql_topn_Varchar_Integer_Integer_agg_phase_4_notnull --
+12 {"varchar13":4,"varchar12":4,"varchar11":4}
+
+-- !sql_topn_String_Integer_Integer_gb --
+{"null":1}
+{"string1":3,"string3":2,"string2":2}
+{"string3":2,"string2":2,"string1":1}
+
+-- !sql_topn_String_Integer_Integer --
+{"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_String_Integer_Integer_agg_phase_1 --
+0 {"null":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+
+-- !sql_topn_String_Integer_Integer_agg_phase_2 --
+12 {"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_String_Integer_Integer_agg_phase_3 --
+0 {"null":1}
+7 {"string1":3,"string3":2,"string2":2}
+5 {"string3":2,"string2":2,"string1":1}
+
+-- !sql_topn_String_Integer_Integer_agg_phase_4 --
+12 {"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_String_Integer_Integer_gb_notnull --
+{"string1":3,"string3":2,"string2":2}
+{"string3":2,"string2":2,"string1":1}
+
+-- !sql_topn_String_Integer_Integer_notnull --
+{"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_String_Integer_Integer_agg_phase_1_notnull --
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+1 {"string1":1}
+1 {"string2":1}
+1 {"string3":1}
+
+-- !sql_topn_String_Integer_Integer_agg_phase_2_notnull --
+12 {"string3":4,"string2":4,"string1":4}
+
+-- !sql_topn_String_Integer_Integer_agg_phase_3_notnull --
+0 {"null":1}
+7 {"string1":3,"string3":2,"string2":2}
+5 {"string3":2,"string2":2,"string1":1}
+
+-- !sql_topn_String_Integer_Integer_agg_phase_4_notnull --
+12 {"string3":4,"string2":4,"string1":4}
+
+-- !sql_variance_TinyInt_gb --
+\N
+4.0
+2.0
+
+-- !sql_variance_TinyInt --
+11.916666666666666
+
+-- !sql_variance_TinyInt_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_TinyInt_agg_phase_2 --
+12 11.916666666666666
+
+-- !sql_variance_TinyInt_agg_phase_3 --
+0 \N
+7 4.0
+5 2.0
+
+-- !sql_variance_TinyInt_agg_phase_4 --
+12 11.916666666666666
+
+-- !sql_variance_TinyInt_gb_notnull --
+4.0
+2.0
+
+-- !sql_variance_TinyInt_notnull --
+11.916666666666666
+
+-- !sql_variance_TinyInt_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_TinyInt_agg_phase_2_notnull --
+12 11.916666666666666
+
+-- !sql_variance_TinyInt_agg_phase_3_notnull --
+0 \N
+7 3.9999999999999996
+5 2.0
+
+-- !sql_variance_TinyInt_agg_phase_4_notnull --
+12 11.916666666666666
+
+-- !sql_variance_SmallInt_gb --
+\N
+4.0
+2.0
+
+-- !sql_variance_SmallInt --
+11.916666666666666
+
+-- !sql_variance_SmallInt_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_SmallInt_agg_phase_2 --
+12 11.916666666666666
+
+-- !sql_variance_SmallInt_agg_phase_3 --
+0 \N
+7 4.0
+5 2.0
+
+-- !sql_variance_SmallInt_agg_phase_4 --
+12 11.916666666666666
+
+-- !sql_variance_SmallInt_gb_notnull --
+4.0
+2.0
+
+-- !sql_variance_SmallInt_notnull --
+11.916666666666666
+
+-- !sql_variance_SmallInt_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_SmallInt_agg_phase_2_notnull --
+12 11.916666666666666
+
+-- !sql_variance_SmallInt_agg_phase_3_notnull --
+0 \N
+7 4.0
+5 2.0
+
+-- !sql_variance_SmallInt_agg_phase_4_notnull --
+12 11.916666666666666
+
+-- !sql_variance_Integer_gb --
+\N
+3.999999999999999
+2.0
+
+-- !sql_variance_Integer --
+11.91666666666667
+
+-- !sql_variance_Integer_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_Integer_agg_phase_2 --
+12 11.916666666666666
+
+-- !sql_variance_Integer_agg_phase_3 --
+0 \N
+7 4.000000000000001
+5 2.0
+
+-- !sql_variance_Integer_agg_phase_4 --
+12 11.916666666666666
+
+-- !sql_variance_Integer_gb_notnull --
+4.0
+2.0
+
+-- !sql_variance_Integer_notnull --
+11.916666666666666
+
+-- !sql_variance_Integer_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_Integer_agg_phase_2_notnull --
+12 11.916666666666666
+
+-- !sql_variance_Integer_agg_phase_3_notnull --
+0 \N
+7 4.0
+5 2.0
+
+-- !sql_variance_Integer_agg_phase_4_notnull --
+12 11.916666666666666
+
+-- !sql_variance_BigInt_gb --
+\N
+3.9999999999999996
+2.0
+
+-- !sql_variance_BigInt --
+11.916666666666666
+
+-- !sql_variance_BigInt_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_BigInt_agg_phase_2 --
+12 11.916666666666666
+
+-- !sql_variance_BigInt_agg_phase_3 --
+0 \N
+7 3.9999999999999996
+5 2.0
+
+-- !sql_variance_BigInt_agg_phase_4 --
+12 11.916666666666666
+
+-- !sql_variance_BigInt_gb_notnull --
+3.9999999999999996
+2.0
+
+-- !sql_variance_BigInt_notnull --
+11.91666666666667
+
+-- !sql_variance_BigInt_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_BigInt_agg_phase_2_notnull --
+12 11.916666666666666
+
+-- !sql_variance_BigInt_agg_phase_3_notnull --
+0 \N
+7 3.9999999999999996
+5 1.9999999999999993
+
+-- !sql_variance_BigInt_agg_phase_4_notnull --
+12 11.916666666666666
+
+-- !sql_variance_Float_gb --
+\N
+0.03999999970197688
+0.02000000476837215
+
+-- !sql_variance_Float --
+0.11916667052855127
+
+-- !sql_variance_Float_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_Float_agg_phase_2 --
+12 0.11916667052855125
+
+-- !sql_variance_Float_agg_phase_3 --
+0 \N
+7 0.03999999970197688
+5 0.020000004768372152
+
+-- !sql_variance_Float_agg_phase_4 --
+12 0.11916667052855125
+
+-- !sql_variance_Float_gb_notnull --
+0.03999999970197688
+0.020000004768372152
+
+-- !sql_variance_Float_notnull --
+0.11916667052855127
+
+-- !sql_variance_Float_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_Float_agg_phase_2_notnull --
+12 0.11916667052855123
+
+-- !sql_variance_Float_agg_phase_3_notnull --
+0 \N
+7 0.03999999970197688
+5 0.020000004768372152
+
+-- !sql_variance_Float_agg_phase_4_notnull --
+12 0.11916667052855125
+
+-- !sql_variance_Double_gb --
+\N
+0.039999999999999994
+0.01999999999999999
+
+-- !sql_variance_Double --
+0.11916666666666668
+
+-- !sql_variance_Double_agg_phase_1 --
+0 \N
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_Double_agg_phase_2 --
+12 0.11916666666666668
+
+-- !sql_variance_Double_agg_phase_3 --
+0 \N
+7 0.039999999999999994
+5 0.02
+
+-- !sql_variance_Double_agg_phase_4 --
+12 0.11916666666666664
+
+-- !sql_variance_Double_gb_notnull --
+0.039999999999999994
+0.019999999999999997
+
+-- !sql_variance_Double_notnull --
+0.1191666666666667
+
+-- !sql_variance_Double_agg_phase_1_notnull --
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+1 0.0
+
+-- !sql_variance_Double_agg_phase_2_notnull --
+12 0.11916666666666668
+
+-- !sql_variance_Double_agg_phase_3_notnull --
+0 \N
+7 0.03999999999999999
+5 0.019999999999999997
+
+-- !sql_variance_Double_agg_phase_4_notnull --
+12 0.11916666666666666
+
+-- !sql_variance_DecimalV2_gb --
+\N
+0.040000000
+0.020000000
+
+-- !sql_variance_DecimalV2 --
+0.119166667
+
+-- !sql_variance_DecimalV2_agg_phase_1 --
+0 \N
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+
+-- !sql_variance_DecimalV2_agg_phase_2 --
+12 0.119166667
+
+-- !sql_variance_DecimalV2_agg_phase_3 --
+0 \N
+7 0.040000000
+5 0.020000000
+
+-- !sql_variance_DecimalV2_agg_phase_4 --
+12 0.119166667
+
+-- !sql_variance_DecimalV2_gb_notnull --
+0.040000000
+0.020000000
+
+-- !sql_variance_DecimalV2_notnull --
+0.119166667
+
+-- !sql_variance_DecimalV2_agg_phase_1_notnull --
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+1 0E-9
+
+-- !sql_variance_DecimalV2_agg_phase_2_notnull --
+12 0.119166667
+
+-- !sql_variance_DecimalV2_agg_phase_3_notnull --
+0 \N
+7 0.040000000
+5 0.020000000
+
+-- !sql_variance_DecimalV2_agg_phase_4_notnull --
+12 0.119166667
+
+-- !sql_variance_samp_TinyInt_gb --
+\N
+4.666666666666667
+2.5
+
+-- !sql_variance_samp_TinyInt --
+13.0
+
+-- !sql_variance_samp_TinyInt_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_TinyInt_agg_phase_2 --
+12 13.0
+
+-- !sql_variance_samp_TinyInt_agg_phase_3 --
+0 \N
+7 4.666666666666667
+5 2.5
+
+-- !sql_variance_samp_TinyInt_agg_phase_4 --
+12 13.0
+
+-- !sql_variance_samp_TinyInt_gb_notnull --
+4.666666666666665
+2.5
+
+-- !sql_variance_samp_TinyInt_notnull --
+13.0
+
+-- !sql_variance_samp_TinyInt_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_TinyInt_agg_phase_2_notnull --
+12 13.0
+
+-- !sql_variance_samp_TinyInt_agg_phase_3_notnull --
+0 \N
+7 4.666666666666666
+5 2.5
+
+-- !sql_variance_samp_TinyInt_agg_phase_4_notnull --
+12 13.0
+
+-- !sql_variance_samp_SmallInt_gb --
+\N
+4.666666666666667
+2.5
+
+-- !sql_variance_samp_SmallInt --
+13.0
+
+-- !sql_variance_samp_SmallInt_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_SmallInt_agg_phase_2 --
+12 13.0
+
+-- !sql_variance_samp_SmallInt_agg_phase_3 --
+0 \N
+7 4.666666666666667
+5 2.5
+
+-- !sql_variance_samp_SmallInt_agg_phase_4 --
+12 13.0
+
+-- !sql_variance_samp_SmallInt_gb_notnull --
+4.666666666666667
+2.5000000000000004
+
+-- !sql_variance_samp_SmallInt_notnull --
+13.0
+
+-- !sql_variance_samp_SmallInt_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_SmallInt_agg_phase_2_notnull --
+12 13.0
+
+-- !sql_variance_samp_SmallInt_agg_phase_3_notnull --
+0 \N
+7 4.666666666666667
+5 2.5
+
+-- !sql_variance_samp_SmallInt_agg_phase_4_notnull --
+12 13.0
+
+-- !sql_variance_samp_Integer_gb --
+\N
+4.666666666666667
+2.5000000000000004
+
+-- !sql_variance_samp_Integer --
+13.0
+
+-- !sql_variance_samp_Integer_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_Integer_agg_phase_2 --
+12 13.0
+
+-- !sql_variance_samp_Integer_agg_phase_3 --
+0 \N
+7 4.666666666666668
+5 2.5
+
+-- !sql_variance_samp_Integer_agg_phase_4 --
+12 13.0
+
+-- !sql_variance_samp_Integer_gb_notnull --
+4.666666666666667
+2.5
+
+-- !sql_variance_samp_Integer_notnull --
+13.0
+
+-- !sql_variance_samp_Integer_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_Integer_agg_phase_2_notnull --
+12 13.0
+
+-- !sql_variance_samp_Integer_agg_phase_3_notnull --
+0 \N
+7 4.666666666666667
+5 2.5
+
+-- !sql_variance_samp_Integer_agg_phase_4_notnull --
+12 13.0
+
+-- !sql_variance_samp_BigInt_gb --
+\N
+4.666666666666667
+2.5
+
+-- !sql_variance_samp_BigInt --
+13.0
+
+-- !sql_variance_samp_BigInt_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_BigInt_agg_phase_2 --
+12 13.0
+
+-- !sql_variance_samp_BigInt_agg_phase_3 --
+0 \N
+7 4.666666666666667
+5 2.5
+
+-- !sql_variance_samp_BigInt_agg_phase_4 --
+12 13.0
+
+-- !sql_variance_samp_BigInt_gb_notnull --
+4.666666666666667
+2.499999999999999
+
+-- !sql_variance_samp_BigInt_notnull --
+13.000000000000002
+
+-- !sql_variance_samp_BigInt_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_BigInt_agg_phase_2_notnull --
+12 13.0
+
+-- !sql_variance_samp_BigInt_agg_phase_3_notnull --
+0 \N
+7 4.666666666666667
+5 2.5
+
+-- !sql_variance_samp_BigInt_agg_phase_4_notnull --
+12 13.0
+
+-- !sql_variance_samp_Float_gb --
+\N
+0.04666666631897303
+0.02500000596046519
+
+-- !sql_variance_samp_Float --
+0.130000004212965
+
+-- !sql_variance_samp_Float_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_Float_agg_phase_2 --
+12 0.130000004212965
+
+-- !sql_variance_samp_Float_agg_phase_3 --
+0 \N
+7 0.04666666631897303
+5 0.02500000596046519
+
+-- !sql_variance_samp_Float_agg_phase_4 --
+12 0.130000004212965
+
+-- !sql_variance_samp_Float_gb_notnull --
+0.04666666631897303
+0.025000005960465182
+
+-- !sql_variance_samp_Float_notnull --
+0.130000004212965
+
+-- !sql_variance_samp_Float_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_Float_agg_phase_2_notnull --
+12 0.13000000421296498
+
+-- !sql_variance_samp_Float_agg_phase_3_notnull --
+0 \N
+7 0.04666666631897303
+5 0.02500000596046519
+
+-- !sql_variance_samp_Float_agg_phase_4_notnull --
+12 0.130000004212965
+
+-- !sql_variance_samp_Double_gb --
+\N
+0.04666666666666666
+0.024999999999999994
+
+-- !sql_variance_samp_Double --
+0.13
+
+-- !sql_variance_samp_Double_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_Double_agg_phase_2 --
+12 0.13
+
+-- !sql_variance_samp_Double_agg_phase_3 --
+0 \N
+7 0.04666666666666666
+5 0.025
+
+-- !sql_variance_samp_Double_agg_phase_4 --
+12 0.13
+
+-- !sql_variance_samp_Double_gb_notnull --
+0.046666666666666655
+0.025
+
+-- !sql_variance_samp_Double_notnull --
+0.13
+
+-- !sql_variance_samp_Double_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_Double_agg_phase_2_notnull --
+12 0.13
+
+-- !sql_variance_samp_Double_agg_phase_3_notnull --
+0 \N
+7 0.04666666666666666
+5 0.024999999999999994
+
+-- !sql_variance_samp_Double_agg_phase_4_notnull --
+12 0.13
+
+-- !sql_variance_samp_DecimalV2_agg_phase_1 --
+0 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_DecimalV2_agg_phase_2 --
+12 0.130000000
+
+-- !sql_variance_samp_DecimalV2_agg_phase_3 --
+0 \N
+7 0.046666667
+5 0.025000000
+
+-- !sql_variance_samp_DecimalV2_agg_phase_4 --
+12 0.130000000
+
+-- !sql_variance_samp_DecimalV2_agg_phase_1_notnull --
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+1 \N
+
+-- !sql_variance_samp_DecimalV2_agg_phase_2_notnull --
+12 0.130000000
+
+-- !sql_variance_samp_DecimalV2_agg_phase_3_notnull --
+0 \N
+7 0.046666667
+5 0.025000000
+
+-- !sql_variance_samp_DecimalV2_agg_phase_4_notnull --
+12 0.130000000
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_gb --
+0
+1
+0
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean --
+1
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_agg_phase_1 --
+0 0
+1 1
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_agg_phase_2 --
+12 1
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_agg_phase_3 --
+0 0
+7 1
+5 0
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_agg_phase_4 --
+12 1
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_gb_notnull --
+1
+0
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_notnull --
+1
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_agg_phase_1_notnull --
+1 1
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_agg_phase_2_notnull --
+12 1
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_agg_phase_3_notnull --
+0 0
+7 1
+5 0
+
+-- !sql_window_funnel_BigInt_String_DateTime_Boolean_agg_phase_4_notnull --
+12 1
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_gb --
+0
+1
+0
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean --
+1
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_agg_phase_1 --
+0 0
+1 1
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_agg_phase_2 --
+12 1
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_agg_phase_3 --
+0 0
+7 1
+5 0
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_agg_phase_4 --
+12 1
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_gb_notnull --
+1
+0
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_notnull --
+1
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_agg_phase_1_notnull --
+1 1
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+1 0
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_agg_phase_2_notnull --
+12 1
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_agg_phase_3_notnull --
+0 0
+7 1
+5 0
+
+-- !sql_window_funnel_BigInt_String_DateTimeV2_Boolean_agg_phase_4_notnull --
+12 1
+
diff --git a/regression-test/data/nereids_function_p0/gen_function/gen.out
b/regression-test/data/nereids_function_p0/gen_function/gen.out
new file mode 100644
index 0000000000..ce8d8f8de1
--- /dev/null
+++ b/regression-test/data/nereids_function_p0/gen_function/gen.out
@@ -0,0 +1,595 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql_explode_bitmap_Bitmap --
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !sql_explode_bitmap_Bitmap_notnull --
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !sql_explode_bitmap_outer_Bitmap --
+\N \N
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !sql_explode_bitmap_outer_Bitmap_notnull --
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !sql_explode_numbers_Integer --
+0 0
+1 0
+1 1
+2 0
+2 1
+2 2
+3 0
+3 1
+3 2
+3 3
+4 0
+4 1
+4 2
+4 3
+4 4
+5 0
+5 1
+5 2
+5 3
+5 4
+5 5
+6 0
+6 1
+6 2
+6 3
+6 4
+6 5
+6 6
+7 0
+7 1
+7 2
+7 3
+7 4
+7 5
+7 6
+7 7
+8 0
+8 1
+8 2
+8 3
+8 4
+8 5
+8 6
+8 7
+8 8
+9 0
+9 1
+9 2
+9 3
+9 4
+9 5
+9 6
+9 7
+9 8
+9 9
+10 0
+10 1
+10 2
+10 3
+10 4
+10 5
+10 6
+10 7
+10 8
+10 9
+10 10
+11 0
+11 1
+11 2
+11 3
+11 4
+11 5
+11 6
+11 7
+11 8
+11 9
+11 10
+11 11
+
+-- !sql_explode_numbers_Integer_notnull --
+0 0
+1 0
+1 1
+2 0
+2 1
+2 2
+3 0
+3 1
+3 2
+3 3
+4 0
+4 1
+4 2
+4 3
+4 4
+5 0
+5 1
+5 2
+5 3
+5 4
+5 5
+6 0
+6 1
+6 2
+6 3
+6 4
+6 5
+6 6
+7 0
+7 1
+7 2
+7 3
+7 4
+7 5
+7 6
+7 7
+8 0
+8 1
+8 2
+8 3
+8 4
+8 5
+8 6
+8 7
+8 8
+9 0
+9 1
+9 2
+9 3
+9 4
+9 5
+9 6
+9 7
+9 8
+9 9
+10 0
+10 1
+10 2
+10 3
+10 4
+10 5
+10 6
+10 7
+10 8
+10 9
+10 10
+11 0
+11 1
+11 2
+11 3
+11 4
+11 5
+11 6
+11 7
+11 8
+11 9
+11 10
+11 11
+
+-- !sql_explode_numbers_outer_Integer --
+\N \N
+0 0
+1 0
+1 1
+2 0
+2 1
+2 2
+3 0
+3 1
+3 2
+3 3
+4 0
+4 1
+4 2
+4 3
+4 4
+5 0
+5 1
+5 2
+5 3
+5 4
+5 5
+6 0
+6 1
+6 2
+6 3
+6 4
+6 5
+6 6
+7 0
+7 1
+7 2
+7 3
+7 4
+7 5
+7 6
+7 7
+8 0
+8 1
+8 2
+8 3
+8 4
+8 5
+8 6
+8 7
+8 8
+9 0
+9 1
+9 2
+9 3
+9 4
+9 5
+9 6
+9 7
+9 8
+9 9
+10 0
+10 1
+10 2
+10 3
+10 4
+10 5
+10 6
+10 7
+10 8
+10 9
+10 10
+11 0
+11 1
+11 2
+11 3
+11 4
+11 5
+11 6
+11 7
+11 8
+11 9
+11 10
+11 11
+
+-- !sql_explode_numbers_outer_Integer_notnull --
+0 0
+1 0
+1 1
+2 0
+2 1
+2 2
+3 0
+3 1
+3 2
+3 3
+4 0
+4 1
+4 2
+4 3
+4 4
+5 0
+5 1
+5 2
+5 3
+5 4
+5 5
+6 0
+6 1
+6 2
+6 3
+6 4
+6 5
+6 6
+7 0
+7 1
+7 2
+7 3
+7 4
+7 5
+7 6
+7 7
+8 0
+8 1
+8 2
+8 3
+8 4
+8 5
+8 6
+8 7
+8 8
+9 0
+9 1
+9 2
+9 3
+9 4
+9 5
+9 6
+9 7
+9 8
+9 9
+10 0
+10 1
+10 2
+10 3
+10 4
+10 5
+10 6
+10 7
+10 8
+10 9
+10 10
+11 0
+11 1
+11 2
+11 3
+11 4
+11 5
+11 6
+11 7
+11 8
+11 9
+11 10
+11 11
+
+-- !sql_explode_split_Varchar_Varchar --
+\N b
+\N c
+\N d
+\N a
+0 b
+0 c
+0 d
+0 a
+1 b
+1 c
+1 d
+1 a
+2 b
+2 c
+2 d
+2 a
+3 b
+3 c
+3 d
+3 a
+4 b
+4 c
+4 d
+4 a
+5 b
+5 c
+5 d
+5 a
+6 b
+6 c
+6 d
+6 a
+7 b
+7 c
+7 d
+7 a
+8 b
+8 c
+8 d
+8 a
+9 b
+9 c
+9 d
+9 a
+10 b
+10 c
+10 d
+10 a
+11 b
+11 c
+11 d
+11 a
+
+-- !sql_explode_split_Varchar_Varchar_notnull --
+\N b
+\N c
+\N d
+\N a
+0 b
+0 c
+0 d
+0 a
+1 b
+1 c
+1 d
+1 a
+2 b
+2 c
+2 d
+2 a
+3 b
+3 c
+3 d
+3 a
+4 b
+4 c
+4 d
+4 a
+5 b
+5 c
+5 d
+5 a
+6 b
+6 c
+6 d
+6 a
+7 b
+7 c
+7 d
+7 a
+8 b
+8 c
+8 d
+8 a
+9 b
+9 c
+9 d
+9 a
+10 b
+10 c
+10 d
+10 a
+11 b
+11 c
+11 d
+11 a
+
+-- !sql_explode_split_outer_Varchar_Varchar --
+\N b
+\N c
+\N d
+\N a
+0 b
+0 c
+0 d
+0 a
+1 b
+1 c
+1 d
+1 a
+2 b
+2 c
+2 d
+2 a
+3 b
+3 c
+3 d
+3 a
+4 b
+4 c
+4 d
+4 a
+5 b
+5 c
+5 d
+5 a
+6 b
+6 c
+6 d
+6 a
+7 b
+7 c
+7 d
+7 a
+8 b
+8 c
+8 d
+8 a
+9 b
+9 c
+9 d
+9 a
+10 b
+10 c
+10 d
+10 a
+11 b
+11 c
+11 d
+11 a
+
+-- !sql_explode_split_outer_Varchar_Varchar_notnull --
+\N b
+\N c
+\N d
+\N a
+0 b
+0 c
+0 d
+0 a
+1 b
+1 c
+1 d
+1 a
+2 b
+2 c
+2 d
+2 a
+3 b
+3 c
+3 d
+3 a
+4 b
+4 c
+4 d
+4 a
+5 b
+5 c
+5 d
+5 a
+6 b
+6 c
+6 d
+6 a
+7 b
+7 c
+7 d
+7 a
+8 b
+8 c
+8 d
+8 a
+9 b
+9 c
+9 d
+9 a
+10 b
+10 c
+10 d
+10 a
+11 b
+11 c
+11 d
+11 a
+
diff --git a/regression-test/data/nereids_function_p0/tvf/tvf.out
b/regression-test/data/nereids_function_p0/tvf/tvf.out
new file mode 100644
index 0000000000..00a44e23bb
--- /dev/null
+++ b/regression-test/data/nereids_function_p0/tvf/tvf.out
@@ -0,0 +1,13 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql_number --
+0
+1
+2
+3
+4
+5
+6
+7
+8
+9
+
diff --git
a/regression-test/data/nereids_function_p0/window_function/window_fn.out
b/regression-test/data/nereids_function_p0/window_function/window_fn.out
new file mode 100644
index 0000000000..0237012f31
--- /dev/null
+++ b/regression-test/data/nereids_function_p0/window_function/window_fn.out
@@ -0,0 +1,3974 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql_count_ob --
+\N 0
+1 1
+2 2
+3 3
+4 4
+5 5
+6 6
+7 7
+8 8
+9 9
+10 10
+11 11
+12 12
+
+-- !sql_count_pb --
+null 0
+string1 4
+string1 4
+string1 4
+string1 4
+string2 4
+string2 4
+string2 4
+string2 4
+string3 4
+string3 4
+string3 4
+string3 4
+
+-- !sql_count_pb_ob --
+null \N 0
+string1 1 1
+string1 4 2
+string1 7 3
+string1 10 4
+string2 2 1
+string2 5 2
+string2 8 3
+string2 11 4
+string3 3 1
+string3 6 2
+string3 9 3
+string3 12 4
+
+-- !sql_count_ob_notnull --
+1 1
+2 2
+3 3
+4 4
+5 5
+6 6
+7 7
+8 8
+9 9
+10 10
+11 11
+12 12
+
+-- !sql_count_pb_notnull --
+string1 4
+string1 4
+string1 4
+string1 4
+string2 4
+string2 4
+string2 4
+string2 4
+string3 4
+string3 4
+string3 4
+string3 4
+
+-- !sql_count_pb_ob_notnull --
+string1 1 1
+string1 4 2
+string1 7 3
+string1 10 4
+string2 2 1
+string2 5 2
+string2 8 3
+string2 11 4
+string3 3 1
+string3 6 2
+string3 9 3
+string3 12 4
+
+-- !sql_count_f_1 --
+null \N 0
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_notnull_1 --
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_2 --
+null \N 0
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 3
+string2 11 3
+string3 12 3
+
+-- !sql_count_f_notnull_2 --
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 3
+string2 11 3
+string3 12 3
+
+-- !sql_count_f_3 --
+null \N 0
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 1
+string2 5 1
+string3 6 1
+string1 7 1
+string2 8 1
+string3 9 1
+string1 10 1
+string2 11 1
+string3 12 1
+
+-- !sql_count_f_notnull_3 --
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 1
+string2 5 1
+string3 6 1
+string1 7 1
+string2 8 1
+string3 9 1
+string1 10 1
+string2 11 1
+string3 12 1
+
+-- !sql_count_f_4 --
+null \N 0
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_notnull_4 --
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_5 --
+null \N 0
+string1 1 3
+string2 2 3
+string3 3 3
+string1 4 4
+string2 5 4
+string3 6 4
+string1 7 4
+string2 8 4
+string3 9 4
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_notnull_5 --
+string1 1 3
+string2 2 3
+string3 3 3
+string1 4 4
+string2 5 4
+string3 6 4
+string1 7 4
+string2 8 4
+string3 9 4
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_6 --
+null \N 0
+string1 1 4
+string2 2 4
+string3 3 4
+string1 4 4
+string2 5 4
+string3 6 4
+string1 7 4
+string2 8 4
+string3 9 4
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_notnull_6 --
+string1 1 4
+string2 2 4
+string3 3 4
+string1 4 4
+string2 5 4
+string3 6 4
+string1 7 4
+string2 8 4
+string3 9 4
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_7 --
+null \N 0
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 3
+string2 11 3
+string3 12 3
+
+-- !sql_count_f_notnull_7 --
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 3
+string2 11 3
+string3 12 3
+
+-- !sql_count_f_8 --
+null \N 0
+string1 1 3
+string2 2 3
+string3 3 3
+string1 4 4
+string2 5 4
+string3 6 4
+string1 7 4
+string2 8 4
+string3 9 4
+string1 10 3
+string2 11 3
+string3 12 3
+
+-- !sql_count_f_notnull_8 --
+string1 1 3
+string2 2 3
+string3 3 3
+string1 4 4
+string2 5 4
+string3 6 4
+string1 7 4
+string2 8 4
+string3 9 4
+string1 10 3
+string2 11 3
+string3 12 3
+
+-- !sql_count_f_9 --
+null \N 0
+string1 1 4
+string2 2 4
+string3 3 4
+string1 4 4
+string2 5 4
+string3 6 4
+string1 7 4
+string2 8 4
+string3 9 4
+string1 10 3
+string2 11 3
+string3 12 3
+
+-- !sql_count_f_notnull_9 --
+string1 1 4
+string2 2 4
+string3 3 4
+string1 4 4
+string2 5 4
+string3 6 4
+string1 7 4
+string2 8 4
+string3 9 4
+string1 10 3
+string2 11 3
+string3 12 3
+
+-- !sql_count_f_10 --
+null \N 0
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 1
+string2 5 1
+string3 6 1
+string1 7 1
+string2 8 1
+string3 9 1
+string1 10 1
+string2 11 1
+string3 12 1
+
+-- !sql_count_f_notnull_10 --
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 1
+string2 5 1
+string3 6 1
+string1 7 1
+string2 8 1
+string3 9 1
+string1 10 1
+string2 11 1
+string3 12 1
+
+-- !sql_count_f_11 --
+null \N 0
+string1 1 3
+string2 2 3
+string3 3 3
+string1 4 3
+string2 5 3
+string3 6 3
+string1 7 2
+string2 8 2
+string3 9 2
+string1 10 1
+string2 11 1
+string3 12 1
+
+-- !sql_count_f_notnull_11 --
+string1 1 3
+string2 2 3
+string3 3 3
+string1 4 3
+string2 5 3
+string3 6 3
+string1 7 2
+string2 8 2
+string3 9 2
+string1 10 1
+string2 11 1
+string3 12 1
+
+-- !sql_count_f_12 --
+null \N 0
+string1 1 4
+string2 2 4
+string3 3 4
+string1 4 3
+string2 5 3
+string3 6 3
+string1 7 2
+string2 8 2
+string3 9 2
+string1 10 1
+string2 11 1
+string3 12 1
+
+-- !sql_count_f_notnull_12 --
+string1 1 4
+string2 2 4
+string3 3 4
+string1 4 3
+string2 5 3
+string3 6 3
+string1 7 2
+string2 8 2
+string3 9 2
+string1 10 1
+string2 11 1
+string3 12 1
+
+-- !sql_count_f_13 --
+null \N 0
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_notnull_13 --
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_14 --
+null \N 0
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_notnull_14 --
+string1 1 1
+string2 2 1
+string3 3 1
+string1 4 2
+string2 5 2
+string3 6 2
+string1 7 3
+string2 8 3
+string3 9 3
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_15 --
+null \N 0
+string1 1 4
+string2 2 4
+string3 3 4
+string1 4 4
+string2 5 4
+string3 6 4
+string1 7 4
+string2 8 4
+string3 9 4
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_notnull_15 --
+string1 1 4
+string2 2 4
+string3 3 4
+string1 4 4
+string2 5 4
+string3 6 4
+string1 7 4
+string2 8 4
+string3 9 4
+string1 10 4
+string2 11 4
+string3 12 4
+
+-- !sql_count_f_16 --
+null \N 0
+string1 1 4
+string2 2 4
+string3 3 4
+string1 4 3
+string2 5 3
+string3 6 3
+string1 7 2
+string2 8 2
+string3 9 2
+string1 10 1
+string2 11 1
+string3 12 1
+
+-- !sql_count_f_notnull_16 --
+string1 1 4
+string2 2 4
+string3 3 4
+string1 4 3
+string2 5 3
+string3 6 3
+string1 7 2
+string2 8 2
+string3 9 2
+string1 10 1
+string2 11 1
+string3 12 1
+
+-- !sql_avg_ob --
+\N \N
+1 1.0
+2 1.5
+3 2.0
+4 2.5
+5 3.0
+6 3.5
+7 4.0
+8 4.5
+9 5.0
+10 5.5
+11 6.0
+12 6.5
+
+-- !sql_avg_pb --
+null \N
+string1 5.5
+string1 5.5
+string1 5.5
+string1 5.5
+string2 6.5
+string2 6.5
+string2 6.5
+string2 6.5
+string3 7.5
+string3 7.5
+string3 7.5
+string3 7.5
+
+-- !sql_avg_pb_ob --
+null \N \N
+string1 1 1.0
+string1 4 2.5
+string1 7 4.0
+string1 10 5.5
+string2 2 2.0
+string2 5 3.5
+string2 8 5.0
+string2 11 6.5
+string3 3 3.0
+string3 6 4.5
+string3 9 6.0
+string3 12 7.5
+
+-- !sql_avg_ob_notnull --
+1 1.0
+2 1.5
+3 2.0
+4 2.5
+5 3.0
+6 3.5
+7 4.0
+8 4.5
+9 5.0
+10 5.5
+11 6.0
+12 6.5
+
+-- !sql_avg_pb_notnull --
+string1 5.5
+string1 5.5
+string1 5.5
+string1 5.5
+string2 6.5
+string2 6.5
+string2 6.5
+string2 6.5
+string3 7.5
+string3 7.5
+string3 7.5
+string3 7.5
+
+-- !sql_avg_pb_ob_notnull --
+string1 1 1.0
+string1 4 2.5
+string1 7 4.0
+string1 10 5.5
+string2 2 2.0
+string2 5 3.5
+string2 8 5.0
+string2 11 6.5
+string3 3 3.0
+string3 6 4.5
+string3 9 6.0
+string3 12 7.5
+
+-- !sql_avg_f_1 --
+null \N \N
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_notnull_1 --
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_2 --
+null \N \N
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 7.0
+string2 11 8.0
+string3 12 9.0
+
+-- !sql_avg_f_notnull_2 --
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 7.0
+string2 11 8.0
+string3 12 9.0
+
+-- !sql_avg_f_3 --
+null \N \N
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 4.0
+string2 5 5.0
+string3 6 6.0
+string1 7 7.0
+string2 8 8.0
+string3 9 9.0
+string1 10 10.0
+string2 11 11.0
+string3 12 12.0
+
+-- !sql_avg_f_notnull_3 --
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 4.0
+string2 5 5.0
+string3 6 6.0
+string1 7 7.0
+string2 8 8.0
+string3 9 9.0
+string1 10 10.0
+string2 11 11.0
+string3 12 12.0
+
+-- !sql_avg_f_4 --
+null \N \N
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_notnull_4 --
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_5 --
+null \N \N
+string1 1 4.0
+string2 2 5.0
+string3 3 6.0
+string1 4 5.5
+string2 5 6.5
+string3 6 7.5
+string1 7 5.5
+string2 8 6.5
+string3 9 7.5
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_notnull_5 --
+string1 1 4.0
+string2 2 5.0
+string3 3 6.0
+string1 4 5.5
+string2 5 6.5
+string3 6 7.5
+string1 7 5.5
+string2 8 6.5
+string3 9 7.5
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_6 --
+null \N \N
+string1 1 5.5
+string2 2 6.5
+string3 3 7.5
+string1 4 5.5
+string2 5 6.5
+string3 6 7.5
+string1 7 5.5
+string2 8 6.5
+string3 9 7.5
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_notnull_6 --
+string1 1 5.5
+string2 2 6.5
+string3 3 7.5
+string1 4 5.5
+string2 5 6.5
+string3 6 7.5
+string1 7 5.5
+string2 8 6.5
+string3 9 7.5
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_7 --
+null \N \N
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 7.0
+string2 11 8.0
+string3 12 9.0
+
+-- !sql_avg_f_notnull_7 --
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 7.0
+string2 11 8.0
+string3 12 9.0
+
+-- !sql_avg_f_8 --
+null \N \N
+string1 1 4.0
+string2 2 5.0
+string3 3 6.0
+string1 4 5.5
+string2 5 6.5
+string3 6 7.5
+string1 7 5.5
+string2 8 6.5
+string3 9 7.5
+string1 10 7.0
+string2 11 8.0
+string3 12 9.0
+
+-- !sql_avg_f_notnull_8 --
+string1 1 4.0
+string2 2 5.0
+string3 3 6.0
+string1 4 5.5
+string2 5 6.5
+string3 6 7.5
+string1 7 5.5
+string2 8 6.5
+string3 9 7.5
+string1 10 7.0
+string2 11 8.0
+string3 12 9.0
+
+-- !sql_avg_f_9 --
+null \N \N
+string1 1 5.5
+string2 2 6.5
+string3 3 7.5
+string1 4 5.5
+string2 5 6.5
+string3 6 7.5
+string1 7 5.5
+string2 8 6.5
+string3 9 7.5
+string1 10 7.0
+string2 11 8.0
+string3 12 9.0
+
+-- !sql_avg_f_notnull_9 --
+string1 1 5.5
+string2 2 6.5
+string3 3 7.5
+string1 4 5.5
+string2 5 6.5
+string3 6 7.5
+string1 7 5.5
+string2 8 6.5
+string3 9 7.5
+string1 10 7.0
+string2 11 8.0
+string3 12 9.0
+
+-- !sql_avg_f_10 --
+null \N \N
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 4.0
+string2 5 5.0
+string3 6 6.0
+string1 7 7.0
+string2 8 8.0
+string3 9 9.0
+string1 10 10.0
+string2 11 11.0
+string3 12 12.0
+
+-- !sql_avg_f_notnull_10 --
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 4.0
+string2 5 5.0
+string3 6 6.0
+string1 7 7.0
+string2 8 8.0
+string3 9 9.0
+string1 10 10.0
+string2 11 11.0
+string3 12 12.0
+
+-- !sql_avg_f_11 --
+null \N \N
+string1 1 4.0
+string2 2 5.0
+string3 3 6.0
+string1 4 7.0
+string2 5 8.0
+string3 6 9.0
+string1 7 8.5
+string2 8 9.5
+string3 9 10.5
+string1 10 10.0
+string2 11 11.0
+string3 12 12.0
+
+-- !sql_avg_f_notnull_11 --
+string1 1 4.0
+string2 2 5.0
+string3 3 6.0
+string1 4 7.0
+string2 5 8.0
+string3 6 9.0
+string1 7 8.5
+string2 8 9.5
+string3 9 10.5
+string1 10 10.0
+string2 11 11.0
+string3 12 12.0
+
+-- !sql_avg_f_12 --
+null \N \N
+string1 1 5.5
+string2 2 6.5
+string3 3 7.5
+string1 4 7.0
+string2 5 8.0
+string3 6 9.0
+string1 7 8.5
+string2 8 9.5
+string3 9 10.5
+string1 10 10.0
+string2 11 11.0
+string3 12 12.0
+
+-- !sql_avg_f_notnull_12 --
+string1 1 5.5
+string2 2 6.5
+string3 3 7.5
+string1 4 7.0
+string2 5 8.0
+string3 6 9.0
+string1 7 8.5
+string2 8 9.5
+string3 9 10.5
+string1 10 10.0
+string2 11 11.0
+string3 12 12.0
+
+-- !sql_avg_f_13 --
+null \N \N
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_notnull_13 --
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_14 --
+null \N \N
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_notnull_14 --
+string1 1 1.0
+string2 2 2.0
+string3 3 3.0
+string1 4 2.5
+string2 5 3.5
+string3 6 4.5
+string1 7 4.0
+string2 8 5.0
+string3 9 6.0
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_15 --
+null \N \N
+string1 1 5.5
+string2 2 6.5
+string3 3 7.5
+string1 4 5.5
+string2 5 6.5
+string3 6 7.5
+string1 7 5.5
+string2 8 6.5
+string3 9 7.5
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_notnull_15 --
+string1 1 5.5
+string2 2 6.5
+string3 3 7.5
+string1 4 5.5
+string2 5 6.5
+string3 6 7.5
+string1 7 5.5
+string2 8 6.5
+string3 9 7.5
+string1 10 5.5
+string2 11 6.5
+string3 12 7.5
+
+-- !sql_avg_f_16 --
+null \N \N
+string1 1 5.5
+string2 2 6.5
+string3 3 7.5
+string1 4 7.0
+string2 5 8.0
+string3 6 9.0
+string1 7 8.5
+string2 8 9.5
+string3 9 10.5
+string1 10 10.0
+string2 11 11.0
+string3 12 12.0
+
+-- !sql_avg_f_notnull_16 --
+string1 1 5.5
+string2 2 6.5
+string3 3 7.5
+string1 4 7.0
+string2 5 8.0
+string3 6 9.0
+string1 7 8.5
+string2 8 9.5
+string3 9 10.5
+string1 10 10.0
+string2 11 11.0
+string3 12 12.0
+
+-- !sql_min_ob --
+\N \N
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+12 1
+
+-- !sql_min_pb --
+null \N
+string1 1
+string1 1
+string1 1
+string1 1
+string2 2
+string2 2
+string2 2
+string2 2
+string3 3
+string3 3
+string3 3
+string3 3
+
+-- !sql_min_pb_ob --
+null \N \N
+string1 1 1
+string1 4 1
+string1 7 1
+string1 10 1
+string2 2 2
+string2 5 2
+string2 8 2
+string2 11 2
+string3 3 3
+string3 6 3
+string3 9 3
+string3 12 3
+
+-- !sql_min_ob_notnull --
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+12 1
+
+-- !sql_min_pb_notnull --
+string1 1
+string1 1
+string1 1
+string1 1
+string2 2
+string2 2
+string2 2
+string2 2
+string3 3
+string3 3
+string3 3
+string3 3
+
+-- !sql_min_pb_ob_notnull --
+string1 1 1
+string1 4 1
+string1 7 1
+string1 10 1
+string2 2 2
+string2 5 2
+string2 8 2
+string2 11 2
+string3 3 3
+string3 6 3
+string3 9 3
+string3 12 3
+
+-- !sql_min_f_1 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_min_f_notnull_1 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_min_f_2 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_min_f_notnull_2 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_min_f_3 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_min_f_notnull_3 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_min_f_4 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_min_f_notnull_4 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_min_f_5 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_min_f_notnull_5 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_min_f_6 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_min_f_notnull_6 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_min_f_7 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_min_f_notnull_7 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_min_f_8 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_min_f_notnull_8 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_min_f_9 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_min_f_notnull_9 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_min_f_10 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_min_f_notnull_10 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_min_f_11 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_min_f_notnull_11 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_min_f_12 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_min_f_notnull_12 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_ob --
+\N \N
+1 1
+2 2
+3 3
+4 4
+5 5
+6 6
+7 7
+8 8
+9 9
+10 10
+11 11
+12 12
+
+-- !sql_max_pb --
+null \N
+string1 10
+string1 10
+string1 10
+string1 10
+string2 11
+string2 11
+string2 11
+string2 11
+string3 12
+string3 12
+string3 12
+string3 12
+
+-- !sql_max_pb_ob --
+null \N \N
+string1 1 1
+string1 4 4
+string1 7 7
+string1 10 10
+string2 2 2
+string2 5 5
+string2 8 8
+string2 11 11
+string3 3 3
+string3 6 6
+string3 9 9
+string3 12 12
+
+-- !sql_max_ob_notnull --
+1 1
+2 2
+3 3
+4 4
+5 5
+6 6
+7 7
+8 8
+9 9
+10 10
+11 11
+12 12
+
+-- !sql_max_pb_notnull --
+string1 10
+string1 10
+string1 10
+string1 10
+string2 11
+string2 11
+string2 11
+string2 11
+string3 12
+string3 12
+string3 12
+string3 12
+
+-- !sql_max_pb_ob_notnull --
+string1 1 1
+string1 4 4
+string1 7 7
+string1 10 10
+string2 2 2
+string2 5 5
+string2 8 8
+string2 11 11
+string3 3 3
+string3 6 6
+string3 9 9
+string3 12 12
+
+-- !sql_max_f_1 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_1 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_2 --
+null \N \N
+string1 1 7
+string2 2 8
+string3 3 9
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_2 --
+string1 1 7
+string2 2 8
+string3 3 9
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_3 --
+null \N \N
+string1 1 10
+string2 2 11
+string3 3 12
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_3 --
+string1 1 10
+string2 2 11
+string3 3 12
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_4 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_4 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_5 --
+null \N \N
+string1 1 7
+string2 2 8
+string3 3 9
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_5 --
+string1 1 7
+string2 2 8
+string3 3 9
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_6 --
+null \N \N
+string1 1 10
+string2 2 11
+string3 3 12
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_6 --
+string1 1 10
+string2 2 11
+string3 3 12
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_7 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_7 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_8 --
+null \N \N
+string1 1 7
+string2 2 8
+string3 3 9
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_8 --
+string1 1 7
+string2 2 8
+string3 3 9
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_9 --
+null \N \N
+string1 1 10
+string2 2 11
+string3 3 12
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_9 --
+string1 1 10
+string2 2 11
+string3 3 12
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_10 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_10 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_11 --
+null \N \N
+string1 1 10
+string2 2 11
+string3 3 12
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_11 --
+string1 1 10
+string2 2 11
+string3 3 12
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_12 --
+null \N \N
+string1 1 10
+string2 2 11
+string3 3 12
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_max_f_notnull_12 --
+string1 1 10
+string2 2 11
+string3 3 12
+string1 4 10
+string2 5 11
+string3 6 12
+string1 7 10
+string2 8 11
+string3 9 12
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_sum_ob --
+\N \N
+1 1
+2 3
+3 6
+4 10
+5 15
+6 21
+7 28
+8 36
+9 45
+10 55
+11 66
+12 78
+
+-- !sql_sum_pb --
+null \N
+string1 22
+string1 22
+string1 22
+string1 22
+string2 26
+string2 26
+string2 26
+string2 26
+string3 30
+string3 30
+string3 30
+string3 30
+
+-- !sql_sum_pb_ob --
+null \N \N
+string1 1 1
+string1 4 5
+string1 7 12
+string1 10 22
+string2 2 2
+string2 5 7
+string2 8 15
+string2 11 26
+string3 3 3
+string3 6 9
+string3 9 18
+string3 12 30
+
+-- !sql_sum_ob_notnull --
+1 1
+2 3
+3 6
+4 10
+5 15
+6 21
+7 28
+8 36
+9 45
+10 55
+11 66
+12 78
+
+-- !sql_sum_pb_notnull --
+string1 22
+string1 22
+string1 22
+string1 22
+string2 26
+string2 26
+string2 26
+string2 26
+string3 30
+string3 30
+string3 30
+string3 30
+
+-- !sql_sum_pb_ob_notnull --
+string1 1 1
+string1 4 5
+string1 7 12
+string1 10 22
+string2 2 2
+string2 5 7
+string2 8 15
+string2 11 26
+string3 3 3
+string3 6 9
+string3 9 18
+string3 12 30
+
+-- !sql_sum_f_1 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_notnull_1 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_2 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 21
+string2 11 24
+string3 12 27
+
+-- !sql_sum_f_notnull_2 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 21
+string2 11 24
+string3 12 27
+
+-- !sql_sum_f_3 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_sum_f_notnull_3 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_sum_f_4 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_notnull_4 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_5 --
+null \N \N
+string1 1 12
+string2 2 15
+string3 3 18
+string1 4 22
+string2 5 26
+string3 6 30
+string1 7 22
+string2 8 26
+string3 9 30
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_notnull_5 --
+string1 1 12
+string2 2 15
+string3 3 18
+string1 4 22
+string2 5 26
+string3 6 30
+string1 7 22
+string2 8 26
+string3 9 30
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_6 --
+null \N \N
+string1 1 22
+string2 2 26
+string3 3 30
+string1 4 22
+string2 5 26
+string3 6 30
+string1 7 22
+string2 8 26
+string3 9 30
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_notnull_6 --
+string1 1 22
+string2 2 26
+string3 3 30
+string1 4 22
+string2 5 26
+string3 6 30
+string1 7 22
+string2 8 26
+string3 9 30
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_7 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 21
+string2 11 24
+string3 12 27
+
+-- !sql_sum_f_notnull_7 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 21
+string2 11 24
+string3 12 27
+
+-- !sql_sum_f_8 --
+null \N \N
+string1 1 12
+string2 2 15
+string3 3 18
+string1 4 22
+string2 5 26
+string3 6 30
+string1 7 22
+string2 8 26
+string3 9 30
+string1 10 21
+string2 11 24
+string3 12 27
+
+-- !sql_sum_f_notnull_8 --
+string1 1 12
+string2 2 15
+string3 3 18
+string1 4 22
+string2 5 26
+string3 6 30
+string1 7 22
+string2 8 26
+string3 9 30
+string1 10 21
+string2 11 24
+string3 12 27
+
+-- !sql_sum_f_9 --
+null \N \N
+string1 1 22
+string2 2 26
+string3 3 30
+string1 4 22
+string2 5 26
+string3 6 30
+string1 7 22
+string2 8 26
+string3 9 30
+string1 10 21
+string2 11 24
+string3 12 27
+
+-- !sql_sum_f_notnull_9 --
+string1 1 22
+string2 2 26
+string3 3 30
+string1 4 22
+string2 5 26
+string3 6 30
+string1 7 22
+string2 8 26
+string3 9 30
+string1 10 21
+string2 11 24
+string3 12 27
+
+-- !sql_sum_f_10 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_sum_f_notnull_10 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_sum_f_11 --
+null \N \N
+string1 1 12
+string2 2 15
+string3 3 18
+string1 4 21
+string2 5 24
+string3 6 27
+string1 7 17
+string2 8 19
+string3 9 21
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_sum_f_notnull_11 --
+string1 1 12
+string2 2 15
+string3 3 18
+string1 4 21
+string2 5 24
+string3 6 27
+string1 7 17
+string2 8 19
+string3 9 21
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_sum_f_12 --
+null \N \N
+string1 1 22
+string2 2 26
+string3 3 30
+string1 4 21
+string2 5 24
+string3 6 27
+string1 7 17
+string2 8 19
+string3 9 21
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_sum_f_notnull_12 --
+string1 1 22
+string2 2 26
+string3 3 30
+string1 4 21
+string2 5 24
+string3 6 27
+string1 7 17
+string2 8 19
+string3 9 21
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_sum_f_13 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_notnull_13 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_14 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_notnull_14 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 5
+string2 5 7
+string3 6 9
+string1 7 12
+string2 8 15
+string3 9 18
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_15 --
+null \N \N
+string1 1 22
+string2 2 26
+string3 3 30
+string1 4 22
+string2 5 26
+string3 6 30
+string1 7 22
+string2 8 26
+string3 9 30
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_notnull_15 --
+string1 1 22
+string2 2 26
+string3 3 30
+string1 4 22
+string2 5 26
+string3 6 30
+string1 7 22
+string2 8 26
+string3 9 30
+string1 10 22
+string2 11 26
+string3 12 30
+
+-- !sql_sum_f_16 --
+null \N \N
+string1 1 22
+string2 2 26
+string3 3 30
+string1 4 21
+string2 5 24
+string3 6 27
+string1 7 17
+string2 8 19
+string3 9 21
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_sum_f_notnull_16 --
+string1 1 22
+string2 2 26
+string3 3 30
+string1 4 21
+string2 5 24
+string3 6 27
+string1 7 17
+string2 8 19
+string3 9 21
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_dense_rank_ob --
+\N 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+12 13
+
+-- !sql_dense_rank_pb --
+null 1
+string1 1
+string1 1
+string1 1
+string1 1
+string2 1
+string2 1
+string2 1
+string2 1
+string3 1
+string3 1
+string3 1
+string3 1
+
+-- !sql_dense_rank_pb_ob --
+null \N 1
+string1 1 1
+string1 4 2
+string1 7 3
+string1 10 4
+string2 2 1
+string2 5 2
+string2 8 3
+string2 11 4
+string3 3 1
+string3 6 2
+string3 9 3
+string3 12 4
+
+-- !sql_dense_rank_ob_notnull --
+1 1
+2 2
+3 3
+4 4
+5 5
+6 6
+7 7
+8 8
+9 9
+10 10
+11 11
+12 12
+
+-- !sql_dense_rank_pb_notnull --
+string1 1
+string1 1
+string1 1
+string1 1
+string2 1
+string2 1
+string2 1
+string2 1
+string3 1
+string3 1
+string3 1
+string3 1
+
+-- !sql_dense_rank_pb_ob_notnull --
+string1 1 1
+string1 4 2
+string1 7 3
+string1 10 4
+string2 2 1
+string2 5 2
+string2 8 3
+string2 11 4
+string3 3 1
+string3 6 2
+string3 9 3
+string3 12 4
+
+-- !sql_first_value_ob --
+\N \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+12 \N
+
+-- !sql_first_value_pb_ob --
+null \N \N
+string1 1 1
+string1 4 1
+string1 7 1
+string1 10 1
+string2 2 2
+string2 5 2
+string2 8 2
+string2 11 2
+string3 3 3
+string3 6 3
+string3 9 3
+string3 12 3
+
+-- !sql_first_value_ob_notnull --
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+12 1
+
+-- !sql_first_value_pb_ob_notnull --
+string1 1 1
+string1 4 1
+string1 7 1
+string1 10 1
+string2 2 2
+string2 5 2
+string2 8 2
+string2 11 2
+string3 3 3
+string3 6 3
+string3 9 3
+string3 12 3
+
+-- !sql_first_value_f_1 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_notnull_1 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_2 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_first_value_f_notnull_2 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_first_value_f_3 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_first_value_f_notnull_3 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_first_value_f_4 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_notnull_4 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_5 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_notnull_5 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_6 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_notnull_6 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_7 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_first_value_f_notnull_7 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_first_value_f_8 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_first_value_f_notnull_8 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_first_value_f_9 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_first_value_f_notnull_9 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 4
+string2 11 5
+string3 12 6
+
+-- !sql_first_value_f_10 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_first_value_f_notnull_10 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_first_value_f_11 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_first_value_f_notnull_11 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_first_value_f_12 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_first_value_f_notnull_12 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_first_value_f_13 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_notnull_13 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_14 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_notnull_14 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_15 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_first_value_f_notnull_15 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 1
+string2 5 2
+string3 6 3
+string1 7 1
+string2 8 2
+string3 9 3
+string1 10 1
+string2 11 2
+string3 12 3
+
+-- !sql_lag_ob --
+\N 1
+1 1
+2 \N
+3 1
+4 2
+5 3
+6 4
+7 5
+8 6
+9 7
+10 8
+11 9
+12 10
+
+-- !sql_lag_pb_ob --
+null \N 1
+string1 1 1
+string1 4 1
+string1 7 1
+string1 10 4
+string2 2 1
+string2 5 1
+string2 8 2
+string2 11 5
+string3 3 1
+string3 6 1
+string3 9 3
+string3 12 6
+
+-- !sql_lag_ob_notnull --
+1 1
+2 1
+3 1
+4 2
+5 3
+6 4
+7 5
+8 6
+9 7
+10 8
+11 9
+12 10
+
+-- !sql_lag_pb_ob_notnull --
+string1 1 1
+string1 4 1
+string1 7 1
+string1 10 4
+string2 2 1
+string2 5 1
+string2 8 2
+string2 11 5
+string3 3 1
+string3 6 1
+string3 9 3
+string3 12 6
+
+-- !sql_last_value_ob --
+\N \N
+1 1
+2 2
+3 3
+4 4
+5 5
+6 6
+7 7
+8 8
+9 9
+10 10
+11 11
+12 12
+
+-- !sql_last_value_pb_ob --
+null \N \N
+string1 1 1
+string1 4 4
+string1 7 7
+string1 10 10
+string2 2 2
+string2 5 5
+string2 8 8
+string2 11 11
+string3 3 3
+string3 6 6
+string3 9 9
+string3 12 12
+
+-- !sql_last_value_ob_notnull --
+1 1
+2 2
+3 3
+4 4
+5 5
+6 6
+7 7
+8 8
+9 9
+10 10
+11 11
+12 12
+
+-- !sql_last_value_pb_ob_notnull --
+string1 1 1
+string1 4 4
+string1 7 7
+string1 10 10
+string2 2 2
+string2 5 5
+string2 8 8
+string2 11 11
+string3 3 3
+string3 6 6
+string3 9 9
+string3 12 12
+
+-- !sql_last_value_f_1 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_last_value_f_notnull_1 --
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
+string3 12 12
+
+-- !sql_last_value_f_2 --
+null \N \N
+string1 1 1
+string2 2 2
+string3 3 3
+string1 4 4
+string2 5 5
+string3 6 6
+string1 7 7
+string2 8 8
+string3 9 9
+string1 10 10
+string2 11 11
... 4723 lines suppressed ...
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
