You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by dl...@apache.org on 2018/10/23 16:33:36 UTC
[4/6] asterixdb git commit: [ASTERIXDB-2459][FUN] Add sttdev_pop()
aggregate function
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 ]
+ ]
+ )
+ ]
+ ]
+ )
)
-]
]