http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int16_null/stddev_int16_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int16_null/stddev_int16_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int16_null/stddev_int16_null.1.adm index 74efe52..4f788be 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int16_null/stddev_int16_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int16_null/stddev_int16_null.1.adm @@ -1 +1 @@ -{ "stddev": 0.0 } +{ "stddev": 0.0, "stddev_pop": 0.0 }
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int32/stddev_int32.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int32/stddev_int32.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int32/stddev_int32.1.adm index d3827e7..653259d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int32/stddev_int32.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int32/stddev_int32.1.adm @@ -1 +1 @@ -1.0 +{ "stddev": [ 1.0 ], "stddev_pop": [ 0.816496580927726 ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int32_null/stddev_int32_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int32_null/stddev_int32_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int32_null/stddev_int32_null.1.adm index 74efe52..4f788be 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int32_null/stddev_int32_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int32_null/stddev_int32_null.1.adm @@ -1 +1 @@ -{ "stddev": 0.0 } +{ "stddev": 0.0, "stddev_pop": 0.0 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int64/stddev_int64.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int64/stddev_int64.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int64/stddev_int64.1.adm index d3827e7..653259d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int64/stddev_int64.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int64/stddev_int64.1.adm @@ -1 +1 @@ -1.0 +{ "stddev": [ 1.0 ], "stddev_pop": [ 0.816496580927726 ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int64_null/stddev_int64_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int64_null/stddev_int64_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int64_null/stddev_int64_null.1.adm index 74efe52..4f788be 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int64_null/stddev_int64_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int64_null/stddev_int64_null.1.adm @@ -1 +1 @@ -{ "stddev": 0.0 } +{ "stddev": 0.0, "stddev_pop": 0.0 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int8/stddev_int8.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int8/stddev_int8.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int8/stddev_int8.1.adm index d3827e7..653259d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int8/stddev_int8.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int8/stddev_int8.1.adm @@ -1 +1 @@ -1.0 +{ "stddev": [ 1.0 ], "stddev_pop": [ 0.816496580927726 ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int8_null/stddev_int8_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int8_null/stddev_int8_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int8_null/stddev_int8_null.1.adm index 43cef5a..20dd54a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int8_null/stddev_int8_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_int8_null/stddev_int8_null.1.adm @@ -1 +1 @@ -{ "stddev": 26.0 } +{ "stddev": 26.0, "stddev_pop": 21.228911104120876 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_pop_mixed/stddev_pop_mixed.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_pop_mixed/stddev_pop_mixed.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_pop_mixed/stddev_pop_mixed.1.adm new file mode 100644 index 0000000..e3b97f5 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/stddev_pop_mixed/stddev_pop_mixed.1.adm @@ -0,0 +1 @@ +[ ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null/agg_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null/agg_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null/agg_null.1.adm index 979beb0..78a89a3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null/agg_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null/agg_null.1.adm @@ -1 +1 @@ -{ "count1": 1, "average1": null, "sum1": null, "min1": null, "max1": null, "stddev1": null, "count2": 2, "average2": null, "sum2": null, "min2": null, "max2": null, "stddev2": null } +{ "count1": 1, "average1": null, "sum1": null, "min1": null, "max1": null, "stddev1": null, "stddev_pop1": null, "count2": 2, "average2": null, "sum2": null, "min2": null, "max2": null, "stddev2": null, "stddev_pop2": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec/agg_null_rec.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec/agg_null_rec.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec/agg_null_rec.1.adm index 7f18cac..054e601 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec/agg_null_rec.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec/agg_null_rec.1.adm @@ -1 +1 @@ -{ "count": 3, "average": null, "stddev": null, "sum": null, "min": null, "max": null } \ No newline at end of file +{ "count": 3, "average": null, "stddev": null, "stddev_pop": null, "sum": null, "min": null, "max": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec_1/agg_null_rec.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec_1/agg_null_rec.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec_1/agg_null_rec.1.adm index 683f829..4be73ca 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec_1/agg_null_rec.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec_1/agg_null_rec.1.adm @@ -1 +1 @@ -{ "count": 3, "average": 5.32, "sum": 15.96, "stddev": 1.0, "min": null, "max": null } +{ "count": 3, "average": 5.32, "sum": 15.96, "stddev": 1.0, "stddev_pop": 0.816496580927726, "min": null, "max": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number/agg_number.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number/agg_number.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number/agg_number.1.adm index 7ac56d4..d6c4363 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number/agg_number.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number/agg_number.1.adm @@ -1 +1 @@ -{ "count1": 4, "average1": 2.3461845695961844E16, "stddev1": 4.6923691391923688E16, "count2": 4, "average2": 2.3461845695961844E16, "stddev2": 4.6923691391923688E16, "sum1": 9.3847382783847376E16, "min1": 1.0, "max1": 9.3847382783847376E16, "sum2": 9.3847382783847376E16, "min2": 1.0, "max2": 9.3847382783847376E16 } +{ "count1": 4, "average1": 2.3461845695961844E16, "stddev1": 4.6923691391923688E16, "stddev_pop1": 4.0637108784747104E16, "count2": 4, "average2": 2.3461845695961844E16, "stddev2": 4.6923691391923688E16, "stddev_pop2": 4.0637108784747104E16, "sum1": 9.3847382783847376E16, "min1": 1.0, "max1": 9.3847382783847376E16, "sum2": 9.3847382783847376E16, "min2": 1.0, "max2": 9.3847382783847376E16 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number_rec/agg_number_rec.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number_rec/agg_number_rec.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number_rec/agg_number_rec.1.adm index 2e68a7b..633b714 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number_rec/agg_number_rec.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number_rec/agg_number_rec.1.adm @@ -1 +1 @@ -{ "count": 3, "average": 1.2824609161579424E16, "stddev": 2.2212874655068836E16, "sum": 3.8473827484738272E16, "min": 2.0, "max": 3.847382748473824E16 } +{ "count": 3, "average": 1.2824609161579424E16, "stddev": 2.2212874655068836E16, "stddev_pop": 1.8136736208439848E16, "sum": 3.8473827484738272E16, "min": 2.0, "max": 3.847382748473824E16 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev/scalar_stddev.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev/scalar_stddev.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev/scalar_stddev.1.adm index 325ebd5..16c838c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev/scalar_stddev.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev/scalar_stddev.1.adm @@ -1,6 +1 @@ -1.0 -1.0 -1.0 -1.0 -1.0 -1.0 +{ "stddev": [ 1.0, 1.0, 1.0, 1.0, 1.0, 1.0 ], "stddev_pop": [ 0.816496580927726, 0.816496580927726, 0.816496580927726, 0.816496580927726, 0.816496580927726, 0.816496580927726 ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev_empty/scalar_stddev_empty.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev_empty/scalar_stddev_empty.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev_empty/scalar_stddev_empty.1.adm index 19765bd..eb24dcb 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev_empty/scalar_stddev_empty.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev_empty/scalar_stddev_empty.1.adm @@ -1 +1 @@ -null +{ "stddev": [ null ], "stddev_pop": [ null ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev_null/scalar_stddev_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev_null/scalar_stddev_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev_null/scalar_stddev_null.1.adm index aef8b7f..a8cdc43 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev_null/scalar_stddev_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_stddev_null/scalar_stddev_null.1.adm @@ -1,6 +1 @@ -null -null -null -null -null -null +{ "stddev": [ null, null, null, null, null, null ], "stddev_pop": [ null, null, null, null, null, null ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_double/serial_stddev_double.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_double/serial_stddev_double.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_double/serial_stddev_double.1.adm index d2bef52..4e89687 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_double/serial_stddev_double.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_double/serial_stddev_double.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": 0.8944271909999159 } +{ "gid": 1, "stddev": 0.8944271909999159, "stddev_pop": 0.8 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_double_null/serial_stddev_double_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_double_null/serial_stddev_double_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_double_null/serial_stddev_double_null.1.adm index c65635a..0405f84 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_double_null/serial_stddev_double_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_double_null/serial_stddev_double_null.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": null } +{ "gid": 1, "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_float/serial_stddev_float.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_float/serial_stddev_float.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_float/serial_stddev_float.1.adm index d2bef52..4e89687 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_float/serial_stddev_float.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_float/serial_stddev_float.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": 0.8944271909999159 } +{ "gid": 1, "stddev": 0.8944271909999159, "stddev_pop": 0.8 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_float_null/serial_stddev_float_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_float_null/serial_stddev_float_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_float_null/serial_stddev_float_null.1.adm index c65635a..0405f84 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_float_null/serial_stddev_float_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_float_null/serial_stddev_float_null.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": null } +{ "gid": 1, "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int16/serial_stddev_int16.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int16/serial_stddev_int16.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int16/serial_stddev_int16.1.adm index d2bef52..4e89687 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int16/serial_stddev_int16.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int16/serial_stddev_int16.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": 0.8944271909999159 } +{ "gid": 1, "stddev": 0.8944271909999159, "stddev_pop": 0.8 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.1.adm index c65635a..0405f84 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": null } +{ "gid": 1, "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int32/serial_stddev_int32.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int32/serial_stddev_int32.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int32/serial_stddev_int32.1.adm index d2bef52..4e89687 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int32/serial_stddev_int32.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int32/serial_stddev_int32.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": 0.8944271909999159 } +{ "gid": 1, "stddev": 0.8944271909999159, "stddev_pop": 0.8 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int32_null/serial_stddev_int32_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int32_null/serial_stddev_int32_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int32_null/serial_stddev_int32_null.1.adm index c65635a..0405f84 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int32_null/serial_stddev_int32_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int32_null/serial_stddev_int32_null.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": null } +{ "gid": 1, "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int64/serial_stddev_int64.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int64/serial_stddev_int64.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int64/serial_stddev_int64.1.adm index d2bef52..4e89687 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int64/serial_stddev_int64.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int64/serial_stddev_int64.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": 0.8944271909999159 } +{ "gid": 1, "stddev": 0.8944271909999159, "stddev_pop": 0.8 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int64_null/serial_stddev_int64_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int64_null/serial_stddev_int64_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int64_null/serial_stddev_int64_null.1.adm index c65635a..0405f84 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int64_null/serial_stddev_int64_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int64_null/serial_stddev_int64_null.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": null } +{ "gid": 1, "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int8/serial_stddev_int8.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int8/serial_stddev_int8.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int8/serial_stddev_int8.1.adm index d2bef52..4e89687 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int8/serial_stddev_int8.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int8/serial_stddev_int8.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": 0.8944271909999159 } +{ "gid": 1, "stddev": 0.8944271909999159, "stddev_pop": 0.8 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int8_null/serial_stddev_int8_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int8_null/serial_stddev_int8_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int8_null/serial_stddev_int8_null.1.adm index c65635a..0405f84 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int8_null/serial_stddev_int8_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_int8_null/serial_stddev_int8_null.1.adm @@ -1 +1 @@ -{ "gid": 1, "stddev": null } +{ "gid": 1, "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.adm new file mode 100644 index 0000000..8ca0475 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.adm @@ -0,0 +1 @@ +{ "gid": 1, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_distinct/stddev_distinct.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_distinct/stddev_distinct.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_distinct/stddev_distinct.1.adm new file mode 100644 index 0000000..17f7b05 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_distinct/stddev_distinct.1.adm @@ -0,0 +1 @@ +{ "t1": 10, "t2": null, "t3": null, "t4": null, "t5": 8, "t6": null, "t7": null, "t8": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_double/stddev_double.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_double/stddev_double.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_double/stddev_double.1.adm index d3827e7..653259d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_double/stddev_double.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_double/stddev_double.1.adm @@ -1 +1 @@ -1.0 +{ "stddev": [ 1.0 ], "stddev_pop": [ 0.816496580927726 ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_double_null/stddev_double_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_double_null/stddev_double_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_double_null/stddev_double_null.1.adm index f41cf92..07f36d3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_double_null/stddev_double_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_double_null/stddev_double_null.1.adm @@ -1 +1 @@ -{ "stddev": null } +{ "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_empty_01/stddev_empty_01.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_empty_01/stddev_empty_01.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_empty_01/stddev_empty_01.1.adm index 19765bd..eb24dcb 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_empty_01/stddev_empty_01.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_empty_01/stddev_empty_01.1.adm @@ -1 +1 @@ -null +{ "stddev": [ null ], "stddev_pop": [ null ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_empty_02/stddev_empty_02.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_empty_02/stddev_empty_02.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_empty_02/stddev_empty_02.1.adm index 19765bd..eb24dcb 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_empty_02/stddev_empty_02.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_empty_02/stddev_empty_02.1.adm @@ -1 +1 @@ -null +{ "stddev": [ null ], "stddev_pop": [ null ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_float/stddev_float.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_float/stddev_float.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_float/stddev_float.1.adm index d3827e7..653259d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_float/stddev_float.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_float/stddev_float.1.adm @@ -1 +1 @@ -1.0 +{ "stddev": [ 1.0 ], "stddev_pop": [ 0.816496580927726 ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_float_null/stddev_float_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_float_null/stddev_float_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_float_null/stddev_float_null.1.adm index f41cf92..07f36d3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_float_null/stddev_float_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_float_null/stddev_float_null.1.adm @@ -1 +1 @@ -{ "stddev": null } +{ "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int16/stddev_int16.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int16/stddev_int16.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int16/stddev_int16.1.adm index d3827e7..653259d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int16/stddev_int16.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int16/stddev_int16.1.adm @@ -1 +1 @@ -1.0 +{ "stddev": [ 1.0 ], "stddev_pop": [ 0.816496580927726 ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int16_null/stddev_int16_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int16_null/stddev_int16_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int16_null/stddev_int16_null.1.adm index f41cf92..07f36d3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int16_null/stddev_int16_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int16_null/stddev_int16_null.1.adm @@ -1 +1 @@ -{ "stddev": null } +{ "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int32/stddev_int32.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int32/stddev_int32.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int32/stddev_int32.1.adm index d3827e7..653259d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int32/stddev_int32.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int32/stddev_int32.1.adm @@ -1 +1 @@ -1.0 +{ "stddev": [ 1.0 ], "stddev_pop": [ 0.816496580927726 ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int32_null/stddev_int32_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int32_null/stddev_int32_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int32_null/stddev_int32_null.1.adm index f41cf92..07f36d3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int32_null/stddev_int32_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int32_null/stddev_int32_null.1.adm @@ -1 +1 @@ -{ "stddev": null } +{ "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int64/stddev_int64.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int64/stddev_int64.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int64/stddev_int64.1.adm index d3827e7..653259d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int64/stddev_int64.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int64/stddev_int64.1.adm @@ -1 +1 @@ -1.0 +{ "stddev": [ 1.0 ], "stddev_pop": [ 0.816496580927726 ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int64_null/stddev_int64_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int64_null/stddev_int64_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int64_null/stddev_int64_null.1.adm index f41cf92..07f36d3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int64_null/stddev_int64_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int64_null/stddev_int64_null.1.adm @@ -1 +1 @@ -{ "stddev": null } +{ "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int8/stddev_int8.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int8/stddev_int8.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int8/stddev_int8.1.adm index d3827e7..653259d 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int8/stddev_int8.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int8/stddev_int8.1.adm @@ -1 +1 @@ -1.0 +{ "stddev": [ 1.0 ], "stddev_pop": [ 0.816496580927726 ] } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int8_null/stddev_int8_null.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int8_null/stddev_int8_null.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int8_null/stddev_int8_null.1.adm index f41cf92..07f36d3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int8_null/stddev_int8_null.1.adm +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_int8_null/stddev_int8_null.1.adm @@ -1 +1 @@ -{ "stddev": null } +{ "stddev": null, "stddev_pop": null } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_pop_mixed/stddev_pop_mixed.1.adm ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_pop_mixed/stddev_pop_mixed.1.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_pop_mixed/stddev_pop_mixed.1.adm new file mode 100644 index 0000000..e3b97f5 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/stddev_pop_mixed/stddev_pop_mixed.1.adm @@ -0,0 +1 @@ +[ ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null/agg_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null/agg_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null/agg_null.3.ast index 7405394..0e8f3ea 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null/agg_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null/agg_null.3.ast @@ -55,6 +55,15 @@ RecordConstructor [ ] ) ( + LiteralExpr [STRING] [sql-stddev_pop1] + : + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + LiteralExpr [NULL] + ] + ] + ) + ( LiteralExpr [STRING] [sql-count2] : FunctionCall asterix.sql-count@1[ @@ -114,4 +123,14 @@ RecordConstructor [ ] ] ) + ( + LiteralExpr [STRING] [sql-stddev_pop2] + : + FunctionCall asterix.sql-stddev_pop@1[ + UnorderedListConstructor [ + LiteralExpr [NULL] + LiteralExpr [NULL] + ] + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.ast index 167b753..96cbb48 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.ast @@ -115,4 +115,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [sql-stddev_pop] + : + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$t ] + Field=valplus + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Test] + ] + AS Variable [ Name=$t ] + ] + ) + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.ast index 97c3cfa..c411817 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.ast @@ -147,4 +147,30 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [sql-stddev_pop] + : + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$i ] + Field=valplus + ] + ] + FROM [ ( + SELECT ELEMENT [ + Variable [ Name=$t ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Test] + ] + AS Variable [ Name=$t ] + ] + ) + AS Variable [ Name=$i ] + ] + ) + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number/agg_number.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number/agg_number.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number/agg_number.3.ast index bfa0267..cbaebaa 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number/agg_number.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number/agg_number.3.ast @@ -97,6 +97,22 @@ RecordConstructor [ ] ) ( + LiteralExpr [STRING] [sql-stddev_pop1] + : + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall null.float@1[ + LiteralExpr [STRING] [2.0] + ] + FunctionCall null.double@1[ + LiteralExpr [STRING] [3.0] + ] + LiteralExpr [LONG] [93847382783847382] + LiteralExpr [LONG] [1] + ] + ] + ) + ( LiteralExpr [STRING] [sql-count2] : FunctionCall asterix.sql-count@1[ @@ -192,4 +208,20 @@ RecordConstructor [ ] ] ) + ( + LiteralExpr [STRING] [sql-stddev_pop2] + : + FunctionCall asterix.sql-stddev_pop@1[ + UnorderedListConstructor [ + FunctionCall null.float@1[ + LiteralExpr [STRING] [2.0] + ] + FunctionCall null.double@1[ + LiteralExpr [STRING] [3.0] + ] + LiteralExpr [LONG] [93847382783847382] + LiteralExpr [LONG] [1] + ] + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.ast index 167b753..96cbb48 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.ast @@ -115,4 +115,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [sql-stddev_pop] + : + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$t ] + Field=valplus + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Test] + ] + AS Variable [ Name=$t ] + ] + ) + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.3.ast index a206740..c9a7865 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.3.ast @@ -1,105 +1,222 @@ DataverseUse test Query: -Let Variable [ Name=$i8 ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.int8@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int8@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int8@1[ - LiteralExpr [STRING] [3] - ] - ] - ] -Let Variable [ Name=$i16 ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.int16@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int16@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int16@1[ - LiteralExpr [STRING] [3] - ] - ] - ] -Let Variable [ Name=$i32 ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.int32@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int32@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int32@1[ - LiteralExpr [STRING] [3] - ] - ] - ] -Let Variable [ Name=$i64 ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.int64@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int64@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int64@1[ - LiteralExpr [STRING] [3] - ] - ] - ] -Let Variable [ Name=$f ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.float@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.float@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.float@1[ - LiteralExpr [STRING] [3] - ] - ] - ] -Let Variable [ Name=$d ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.double@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.double@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.double@1[ - LiteralExpr [STRING] [3] - ] - ] - ] -SELECT ELEMENT [ -Variable [ Name=$i ] -] -FROM [ OrderedListConstructor [ - Variable [ Name=$i8 ] - Variable [ Name=$i16 ] - Variable [ Name=$i32 ] - Variable [ Name=$i64 ] - Variable [ Name=$f ] - Variable [ Name=$d ] - ] - AS Variable [ Name=$i ] +RecordConstructor [ + ( + LiteralExpr [STRING] [stddev] + : + ( + Let Variable [ Name=$i8 ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.int8@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i16 ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i32 ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.int32@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i64 ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.int64@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$f ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$d ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.double@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.double@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.double@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + SELECT ELEMENT [ + Variable [ Name=$i ] + ] + FROM [ OrderedListConstructor [ + Variable [ Name=$i8 ] + Variable [ Name=$i16 ] + Variable [ Name=$i32 ] + Variable [ Name=$i64 ] + Variable [ Name=$f ] + Variable [ Name=$d ] + ] + AS Variable [ Name=$i ] + ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + Let Variable [ Name=$i8 ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.int8@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i16 ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i32 ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.int32@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i64 ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.int64@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$f ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$d ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.double@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.double@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.double@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + SELECT ELEMENT [ + Variable [ Name=$i ] + ] + FROM [ OrderedListConstructor [ + Variable [ Name=$i8 ] + Variable [ Name=$i16 ] + Variable [ Name=$i32 ] + Variable [ Name=$i64 ] + Variable [ Name=$f ] + Variable [ Name=$d ] + ] + AS Variable [ Name=$i ] + ] + ) + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.3.ast index 6954f95..3fd8fec 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.3.ast @@ -1,7 +1,27 @@ Query: -SELECT ELEMENT [ -FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - ] -] +RecordConstructor [ + ( + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + ] + ] + ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + ] + ] + ] + ) + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.3.ast index 61692e0..5615328 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.3.ast @@ -1,111 +1,234 @@ DataverseUse test Query: -Let Variable [ Name=$i8 ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.int8@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int8@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int8@1[ - LiteralExpr [STRING] [3] - ] - LiteralExpr [NULL] - ] - ] -Let Variable [ Name=$i16 ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.int16@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int16@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int16@1[ - LiteralExpr [STRING] [3] - ] - LiteralExpr [NULL] - ] - ] -Let Variable [ Name=$i32 ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.int32@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int32@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int32@1[ - LiteralExpr [STRING] [3] - ] - LiteralExpr [NULL] - ] - ] -Let Variable [ Name=$i64 ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.int64@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int64@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int64@1[ - LiteralExpr [STRING] [3] - ] - LiteralExpr [NULL] - ] - ] -Let Variable [ Name=$f ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.float@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.float@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.float@1[ - LiteralExpr [STRING] [3] - ] - LiteralExpr [NULL] - ] - ] -Let Variable [ Name=$d ] - := - FunctionCall asterix.sql-stddev@1[ - OrderedListConstructor [ - FunctionCall test.double@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.double@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.double@1[ - LiteralExpr [STRING] [3] - ] - LiteralExpr [NULL] - ] - ] -SELECT ELEMENT [ -Variable [ Name=$i ] -] -FROM [ OrderedListConstructor [ - Variable [ Name=$i8 ] - Variable [ Name=$i16 ] - Variable [ Name=$i32 ] - Variable [ Name=$i64 ] - Variable [ Name=$f ] - Variable [ Name=$d ] - ] - AS Variable [ Name=$i ] +RecordConstructor [ + ( + LiteralExpr [STRING] [stddev] + : + ( + Let Variable [ Name=$i8 ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.int8@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i16 ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i32 ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.int32@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i64 ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.int64@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$f ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$d ] + := + FunctionCall asterix.sql-stddev@1[ + OrderedListConstructor [ + FunctionCall test.double@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.double@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.double@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + SELECT ELEMENT [ + Variable [ Name=$i ] + ] + FROM [ OrderedListConstructor [ + Variable [ Name=$i8 ] + Variable [ Name=$i16 ] + Variable [ Name=$i32 ] + Variable [ Name=$i64 ] + Variable [ Name=$f ] + Variable [ Name=$d ] + ] + AS Variable [ Name=$i ] + ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + Let Variable [ Name=$i8 ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.int8@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i16 ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i32 ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.int32@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i64 ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.int64@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$f ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$d ] + := + FunctionCall asterix.sql-stddev_pop@1[ + OrderedListConstructor [ + FunctionCall test.double@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.double@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.double@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + SELECT ELEMENT [ + Variable [ Name=$i ] + ] + FROM [ OrderedListConstructor [ + Variable [ Name=$i8 ] + Variable [ Name=$i16 ] + Variable [ Name=$i32 ] + Variable [ Name=$i64 ] + Variable [ Name=$f ] + Variable [ Name=$d ] + ] + AS Variable [ Name=$i ] + ] + ) + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_double/serial_stddev_double.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_double/serial_stddev_double.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_double/serial_stddev_double.3.ast index 3bd59ff..d9e097b 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_double/serial_stddev_double.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_double/serial_stddev_double.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_double_null/serial_stddev_double_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_double_null/serial_stddev_double_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_double_null/serial_stddev_double_null.3.ast index 8dae584..923fc41 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_double_null/serial_stddev_double_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_double_null/serial_stddev_double_null.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_empty/serial_stddev_empty.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_empty/serial_stddev_empty.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_empty/serial_stddev_empty.3.ast index 3bd59ff..d9e097b 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_empty/serial_stddev_empty.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_empty/serial_stddev_empty.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_float/serial_stddev_float.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_float/serial_stddev_float.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_float/serial_stddev_float.3.ast index 3bd59ff..d9e097b 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_float/serial_stddev_float.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_float/serial_stddev_float.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_float_null/serial_stddev_float_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_float_null/serial_stddev_float_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_float_null/serial_stddev_float_null.3.ast index 8dae584..923fc41 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_float_null/serial_stddev_float_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_float_null/serial_stddev_float_null.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int16/serial_stddev_int16.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int16/serial_stddev_int16.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int16/serial_stddev_int16.3.ast index 3bd59ff..d9e097b 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int16/serial_stddev_int16.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int16/serial_stddev_int16.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int16_null/serial_stddev_int16_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int16_null/serial_stddev_int16_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int16_null/serial_stddev_int16_null.3.ast index 8dae584..923fc41 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int16_null/serial_stddev_int16_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int16_null/serial_stddev_int16_null.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.ast index 3bd59ff..d9e097b 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.ast index 8dae584..923fc41 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.ast index 3bd59ff..d9e097b 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.ast index 8dae584..923fc41 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.ast index 3bd59ff..d9e097b 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.ast index 8dae584..923fc41 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.ast @@ -20,6 +20,23 @@ FunctionCall asterix.sql-stddev@1[ ) ] stddev +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +stddev_pop ] FROM [ FunctionCall asterix.dataset@1[ LiteralExpr [STRING] [test.Test] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.1.ast new file mode 100644 index 0000000..a61c9df --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : double + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.2.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.3.ast new file mode 100644 index 0000000..2e6d6ae --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_int64_null.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=valplus + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +stddev_pop +] +FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Test] + ] + AS Variable [ Name=$t ] +] +Groupby + Variable [ Name=$gid ] + := + FieldAccessor [ + Variable [ Name=$t ] + Field=gid + ] + GROUP AS Variable [ Name=$g ] + ( + valplus:=FunctionCall asterix.field-access-by-name@2[ + Variable [ Name=$t ] + LiteralExpr [STRING] [valplus] +] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.3.ast index c0e7dac..a156d16 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.3.ast @@ -1,19 +1,51 @@ Query: -SELECT ELEMENT [ -FunctionCall asterix.sql-stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - Variable [ Name=$x ] - ] - FROM [ OrderedListConstructor [ - LiteralExpr [DOUBLE] [1.0] - LiteralExpr [DOUBLE] [2.0] - FunctionCall null.double@1[ - LiteralExpr [STRING] [3.0] - ] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + LiteralExpr [DOUBLE] [1.0] + LiteralExpr [DOUBLE] [2.0] + FunctionCall null.double@1[ + LiteralExpr [STRING] [3.0] + ] + ] + AS Variable [ Name=$x ] + ] + ) ] - AS Variable [ Name=$x ] - ] + ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + LiteralExpr [DOUBLE] [1.0] + LiteralExpr [DOUBLE] [2.0] + FunctionCall null.double@1[ + LiteralExpr [STRING] [3.0] + ] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) ) -] ]
