[ASTERIXDB-2459][FUN] Add sttdev_pop() aggregate function - user model changes: yes - storage format changes: no - interface changes: no
Details: 1. Add stddev_pop aggregation function and test cases 2. Add stddev and stddev_pop distinct functions 3. Fix some stddev test case comments 4. Add documentation for stddev_pop Change-Id: I1732d8d70eba26e12a6e68d0e0c621491ed6b3ae Reviewed-on: https://asterix-gerrit.ics.uci.edu/2997 Tested-by: Jenkins <[email protected]> Contrib: Jenkins <[email protected]> Integration-Tests: Jenkins <[email protected]> Reviewed-by: Dmitry Lychagin <[email protected]> Project: http://git-wip-us.apache.org/repos/asf/asterixdb/repo Commit: http://git-wip-us.apache.org/repos/asf/asterixdb/commit/11d5b281 Tree: http://git-wip-us.apache.org/repos/asf/asterixdb/tree/11d5b281 Diff: http://git-wip-us.apache.org/repos/asf/asterixdb/diff/11d5b281 Branch: refs/heads/master Commit: 11d5b2812ff304af77f548979a08ee5998e45d48 Parents: c4dbb61 Author: James Fang <[email protected]> Authored: Mon Oct 22 15:13:24 2018 -0700 Committer: Dmitry Lychagin <[email protected]> Committed: Tue Oct 23 09:33:12 2018 -0700 ---------------------------------------------------------------------- .../aggregate-sql/agg_null/agg_null.3.query.aql | 2 +- .../agg_null_rec/agg_null_rec.3.query.aql | 2 +- .../agg_null_rec_1/agg_null_rec_1.3.query.aql | 3 +- .../agg_number/agg_number.3.query.aql | 3 +- .../agg_number_rec/agg_number_rec.3.query.aql | 2 +- .../aggregate/agg_null/agg_null.3.query.aql | 2 +- .../agg_null_rec/agg_null_rec.3.query.aql | 2 +- .../agg_null_rec_1/agg_null_rec_1.3.query.aql | 3 +- .../aggregate/agg_number/agg_number.3.query.aql | 3 +- .../agg_number_rec/agg_number_rec.3.query.aql | 2 +- .../agg_null/agg_null.3.query.sqlpp | 2 +- .../agg_null_rec/agg_null_rec.3.query.sqlpp | 3 + .../agg_null_rec_1/agg_null_rec_1.3.query.sqlpp | 6 + .../agg_number/agg_number.3.query.sqlpp | 2 +- .../agg_number_rec/agg_number_rec.3.query.sqlpp | 3 + .../scalar_stddev/scalar_stddev.1.ddl.sqlpp | 2 +- .../scalar_stddev/scalar_stddev.3.query.sqlpp | 17 +- .../scalar_stddev_empty.1.ddl.sqlpp | 2 +- .../scalar_stddev_empty.3.query.sqlpp | 5 +- .../scalar_stddev_null.1.ddl.sqlpp | 2 +- .../scalar_stddev_null.3.query.sqlpp | 17 +- .../serial_stddev_double.3.query.sqlpp | 2 +- .../serial_stddev_double_null.3.query.sqlpp | 2 +- .../serial_stddev_empty.3.query.sqlpp | 2 +- .../serial_stddev_float.3.query.sqlpp | 2 +- .../serial_stddev_float_null.3.query.sqlpp | 2 +- .../serial_stddev_int16.3.query.sqlpp | 2 +- .../serial_stddev_int16_null.3.query.sqlpp | 2 +- .../serial_stddev_int32.3.query.sqlpp | 2 +- .../serial_stddev_int32_null.3.query.sqlpp | 2 +- .../serial_stddev_int64.3.query.sqlpp | 2 +- .../serial_stddev_int64_null.3.query.sqlpp | 2 +- .../serial_stddev_int8.3.query.sqlpp | 2 +- .../serial_stddev_int8_null.3.query.sqlpp | 2 +- .../serial_stddev_pop_mixed.1.ddl.sqlpp | 33 ++ .../serial_stddev_pop_mixed.2.update.sqlpp | 29 ++ .../serial_stddev_pop_mixed.3.query.sqlpp | 30 ++ .../stddev_distinct.1.query.sqlpp | 28 ++ .../stddev_double/stddev_double.3.query.sqlpp | 7 +- .../stddev_double_null.3.query.sqlpp | 3 + .../stddev_empty_01/stddev_empty_01.1.ddl.sqlpp | 2 +- .../stddev_empty_01.3.query.sqlpp | 10 +- .../stddev_empty_02/stddev_empty_02.1.ddl.sqlpp | 2 +- .../stddev_empty_02.3.query.sqlpp | 9 +- .../stddev_float/stddev_float.3.query.sqlpp | 7 +- .../stddev_float_nu.3.query.sqlpp | 3 + .../stddev_int16/stddev_int16.3.query.sqlpp | 7 +- .../stddev_int16_null.3.query.sqlpp | 3 + .../stddev_int32/stddev_int32.3.query.sqlpp | 7 +- .../stddev_int32_null.3.query.sqlpp | 3 + .../stddev_int64/stddev_int64.3.query.sqlpp | 7 +- .../stddev_int64_null.3.query.sqlpp | 3 + .../stddev_int8/stddev_int8.3.query.sqlpp | 7 +- .../stddev_int8_null.3.query.sqlpp | 3 + .../stddev_mixed/stddev_mixed.3.query.sqlpp | 2 +- .../stddev_pop_mixed.3.query.sqlpp | 28 ++ .../aggregate/agg_null/agg_null.3.query.sqlpp | 2 +- .../agg_null_rec/agg_null_rec.3.query.sqlpp | 3 + .../agg_null_rec_1/agg_null_rec_1.3.query.sqlpp | 6 + .../agg_number/agg_number.3.query.sqlpp | 2 +- .../agg_number_rec/agg_number_rec.3.query.sqlpp | 3 + .../scalar_stddev/scalar_stddev.1.ddl.sqlpp | 2 +- .../scalar_stddev/scalar_stddev.3.query.sqlpp | 17 +- .../scalar_stddev_empty.1.ddl.sqlpp | 2 +- .../scalar_stddev_empty.3.query.sqlpp | 5 +- .../scalar_stddev_null.1.ddl.sqlpp | 2 +- .../scalar_stddev_null.3.query.sqlpp | 17 +- .../serial_stddev_double.3.query.sqlpp | 3 +- .../serial_stddev_double_null.3.query.sqlpp | 3 +- .../serial_stddev_empty.3.query.sqlpp | 3 +- .../serial_stddev_float.3.query.sqlpp | 3 +- .../serial_stddev_float_null.3.query.sqlpp | 3 +- .../serial_stddev_int16.3.query.sqlpp | 3 +- .../serial_stddev_int16_null.3.query.sqlpp | 3 +- .../serial_stddev_int32.3.query.sqlpp | 3 +- .../serial_stddev_int32_null.3.query.sqlpp | 3 +- .../serial_stddev_int64.3.query.sqlpp | 3 +- .../serial_stddev_int64_null.3.query.sqlpp | 3 +- .../serial_stddev_int8.3.query.sqlpp | 3 +- .../serial_stddev_int8_null.3.query.sqlpp | 3 +- .../serial_stddev_pop_mixed.1.ddl.sqlpp | 33 ++ .../serial_stddev_pop_mixed.2.update.sqlpp | 29 ++ .../serial_stddev_pop_mixed.3.query.sqlpp | 30 ++ .../stddev_distinct.1.query.sqlpp | 28 ++ .../stddev_double/stddev_double.3.query.sqlpp | 7 +- .../stddev_double_null.3.query.sqlpp | 4 +- .../stddev_empty_01/stddev_empty_01.1.ddl.sqlpp | 2 +- .../stddev_empty_01.3.query.sqlpp | 11 +- .../stddev_empty_02/stddev_empty_02.1.ddl.sqlpp | 2 +- .../stddev_empty_02.3.query.sqlpp | 10 +- .../stddev_float/stddev_float.3.query.sqlpp | 7 +- .../stddev_float_null.3.query.sqlpp | 3 + .../stddev_int16/stddev_int16.3.query.sqlpp | 7 +- .../stddev_int16_null.3.query.sqlpp | 3 + .../stddev_int32/stddev_int32.3.query.sqlpp | 7 +- .../stddev_int32_null.3.query.sqlpp | 3 + .../stddev_int64/stddev_int64.3.query.sqlpp | 7 +- .../stddev_int64_null.3.query.sqlpp | 3 + .../stddev_int8/stddev_int8.3.query.sqlpp | 7 +- .../stddev_int8_null.3.query.sqlpp | 3 + .../stddev_pop_mixed.3.query.sqlpp | 28 ++ .../aggregate-sql/agg_null/agg_null.1.adm | 2 +- .../agg_null_rec/agg_null_rec.1.adm | 2 +- .../agg_null_rec_1/agg_null_rec.1.adm | 2 +- .../aggregate-sql/agg_number/agg_number.1.adm | 2 +- .../agg_number_rec/agg_number_rec.1.adm | 2 +- .../scalar_stddev/scalar_stddev.1.adm | 7 +- .../scalar_stddev_empty.1.adm | 2 +- .../scalar_stddev_null/scalar_stddev_null.1.adm | 7 +- .../serial_stddev_double.1.adm | 2 +- .../serial_stddev_double_null.1.adm | 2 +- .../serial_stddev_float.1.adm | 2 +- .../serial_stddev_float_null.1.adm | 2 +- .../serial_stddev_int16.1.adm | 2 +- .../serial_stddev_int16_null.1.adm | 2 +- .../serial_stddev_int32.1.adm | 2 +- .../serial_stddev_int32_null.1.adm | 2 +- .../serial_stddev_int64.1.adm | 2 +- .../serial_stddev_int64_null.1.adm | 2 +- .../serial_stddev_int8/serial_stddev_int8.1.adm | 2 +- .../serial_stddev_int8_null.1.adm | 2 +- .../serial_stddev_pop_mixed.1.adm | 1 + .../stddev_distinct/stddev_distinct.1.adm | 1 + .../stddev_double/stddev_double.1.adm | 2 +- .../stddev_double_null/stddev_double_null.1.adm | 2 +- .../stddev_empty_01/stddev_empty_01.1.adm | 2 +- .../stddev_empty_02/stddev_empty_02.1.adm | 2 +- .../stddev_float/stddev_float.1.adm | 2 +- .../stddev_float_null/stddev_float_null.1.adm | 2 +- .../stddev_int16/stddev_int16.1.adm | 2 +- .../stddev_int16_null/stddev_int16_null.1.adm | 2 +- .../stddev_int32/stddev_int32.1.adm | 2 +- .../stddev_int32_null/stddev_int32_null.1.adm | 2 +- .../stddev_int64/stddev_int64.1.adm | 2 +- .../stddev_int64_null/stddev_int64_null.1.adm | 2 +- .../aggregate-sql/stddev_int8/stddev_int8.1.adm | 2 +- .../stddev_int8_null/stddev_int8_null.1.adm | 2 +- .../stddev_pop_mixed/stddev_pop_mixed.1.adm | 1 + .../results/aggregate/agg_null/agg_null.1.adm | 2 +- .../aggregate/agg_null_rec/agg_null_rec.1.adm | 2 +- .../aggregate/agg_null_rec_1/agg_null_rec.1.adm | 2 +- .../aggregate/agg_number/agg_number.1.adm | 2 +- .../agg_number_rec/agg_number_rec.1.adm | 2 +- .../aggregate/scalar_stddev/scalar_stddev.1.adm | 7 +- .../scalar_stddev_empty.1.adm | 2 +- .../scalar_stddev_null/scalar_stddev_null.1.adm | 7 +- .../serial_stddev_double.1.adm | 2 +- .../serial_stddev_double_null.1.adm | 2 +- .../serial_stddev_float.1.adm | 2 +- .../serial_stddev_float_null.1.adm | 2 +- .../serial_stddev_int16.1.adm | 2 +- .../serial_stddev_int16_null.1.adm | 2 +- .../serial_stddev_int32.1.adm | 2 +- .../serial_stddev_int32_null.1.adm | 2 +- .../serial_stddev_int64.1.adm | 2 +- .../serial_stddev_int64_null.1.adm | 2 +- .../serial_stddev_int8/serial_stddev_int8.1.adm | 2 +- .../serial_stddev_int8_null.1.adm | 2 +- .../serial_stddev_pop_mixed.1.adm | 1 + .../stddev_distinct/stddev_distinct.1.adm | 1 + .../aggregate/stddev_double/stddev_double.1.adm | 2 +- .../stddev_double_null/stddev_double_null.1.adm | 2 +- .../stddev_empty_01/stddev_empty_01.1.adm | 2 +- .../stddev_empty_02/stddev_empty_02.1.adm | 2 +- .../aggregate/stddev_float/stddev_float.1.adm | 2 +- .../stddev_float_null/stddev_float_null.1.adm | 2 +- .../aggregate/stddev_int16/stddev_int16.1.adm | 2 +- .../stddev_int16_null/stddev_int16_null.1.adm | 2 +- .../aggregate/stddev_int32/stddev_int32.1.adm | 2 +- .../stddev_int32_null/stddev_int32_null.1.adm | 2 +- .../aggregate/stddev_int64/stddev_int64.1.adm | 2 +- .../stddev_int64_null/stddev_int64_null.1.adm | 2 +- .../aggregate/stddev_int8/stddev_int8.1.adm | 2 +- .../stddev_int8_null/stddev_int8_null.1.adm | 2 +- .../stddev_pop_mixed/stddev_pop_mixed.1.adm | 1 + .../aggregate-sql/agg_null/agg_null.3.ast | 19 ++ .../agg_null_rec/agg_null_rec.3.ast | 19 ++ .../agg_null_rec_1/agg_null_rec_1.3.ast | 26 ++ .../aggregate-sql/agg_number/agg_number.3.ast | 32 ++ .../agg_number_rec/agg_number_rec.3.ast | 19 ++ .../scalar_stddev/scalar_stddev.3.ast | 321 ++++++++++++------ .../scalar_stddev_empty.3.ast | 30 +- .../scalar_stddev_null/scalar_stddev_null.3.ast | 339 +++++++++++++------ .../serial_stddev_double.3.ast | 17 + .../serial_stddev_double_null.3.ast | 17 + .../serial_stddev_empty.3.ast | 17 + .../serial_stddev_float.3.ast | 17 + .../serial_stddev_float_null.3.ast | 17 + .../serial_stddev_int16.3.ast | 17 + .../serial_stddev_int16_null.3.ast | 17 + .../serial_stddev_int32.3.ast | 17 + .../serial_stddev_int32_null.3.ast | 17 + .../serial_stddev_int64.3.ast | 17 + .../serial_stddev_int64_null.3.ast | 17 + .../serial_stddev_int8/serial_stddev_int8.3.ast | 17 + .../serial_stddev_int8_null.3.ast | 17 + .../serial_stddev_pop_int64_null.1.ast | 9 + .../serial_stddev_pop_int64_null.2.ast | 1 + .../serial_stddev_pop_int64_null.3.ast | 40 +++ .../stddev_double/stddev_double.3.ast | 60 +++- .../stddev_double_null/stddev_double_null.3.ast | 19 ++ .../stddev_empty_01/stddev_empty_01.3.ast | 70 +++- .../stddev_empty_02/stddev_empty_02.3.ast | 57 +++- .../stddev_float/stddev_float.3.ast | 72 +++- .../stddev_float_null/stddev_float_nu.3.ast | 19 ++ .../stddev_int16/stddev_int16.3.ast | 72 +++- .../stddev_int16_null/stddev_int16_null.3.ast | 19 ++ .../stddev_int32/stddev_int32.3.ast | 72 +++- .../stddev_int32_null/stddev_int32_null.3.ast | 19 ++ .../stddev_int64/stddev_int64.3.ast | 72 +++- .../stddev_int64_null/stddev_int64_null.3.ast | 19 ++ .../aggregate-sql/stddev_int8/stddev_int8.3.ast | 72 +++- .../stddev_int8_null/stddev_int8_null.3.ast | 19 ++ .../stddev_pop_mixed/stddev_pop_mixed.3.ast | 22 ++ .../aggregate/agg_null/agg_null.3.ast | 19 ++ .../aggregate/agg_null_rec/agg_null_rec.3.ast | 19 ++ .../agg_null_rec_1/agg_null_rec_1.3.ast | 26 ++ .../aggregate/agg_number/agg_number.3.ast | 32 ++ .../agg_number_rec/agg_number_rec.3.ast | 19 ++ .../aggregate/scalar_stddev/scalar_stddev.3.ast | 321 ++++++++++++------ .../scalar_stddev_empty.3.ast | 30 +- .../scalar_stddev_null/scalar_stddev_null.3.ast | 339 +++++++++++++------ .../serial_stddev_double.3.ast | 14 + .../serial_stddev_double_null.3.ast | 14 + .../serial_stddev_empty.3.ast | 14 + .../serial_stddev_float.3.ast | 14 + .../serial_stddev_float_null.3.ast | 14 + .../serial_stddev_int16.3.ast | 14 + .../serial_stddev_int16_null.3.ast | 14 + .../serial_stddev_int32.3.ast | 14 + .../serial_stddev_int32_null.3.ast | 14 + .../serial_stddev_int64.3.ast | 14 + .../serial_stddev_int64_null.3.ast | 14 + .../serial_stddev_int8/serial_stddev_int8.3.ast | 14 + .../serial_stddev_int8_null.3.ast | 14 + .../serial_stddev_pop_mixed.1.ast | 9 + .../serial_stddev_pop_mixed.2.ast | 1 + .../serial_stddev_pop_mixed.3.ast | 40 +++ .../aggregate/stddev_double/stddev_double.3.ast | 60 +++- .../stddev_double_null/stddev_double_null.3.ast | 19 ++ .../stddev_empty_01/stddev_empty_01.3.ast | 70 +++- .../stddev_empty_02/stddev_empty_02.3.ast | 57 +++- .../aggregate/stddev_float/stddev_float.3.ast | 72 +++- .../stddev_float_null/stddev_float_nu.3.ast | 19 ++ .../aggregate/stddev_int16/stddev_int16.3.ast | 72 +++- .../stddev_int16_null/stddev_int16_null.3.ast | 19 ++ .../aggregate/stddev_int32/stddev_int32.3.ast | 54 ++- .../stddev_int32_null/stddev_int32_null.3.ast | 19 ++ .../aggregate/stddev_int64/stddev_int64.3.ast | 72 +++- .../stddev_int64_null/stddev_int64_null.3.ast | 19 ++ .../aggregate/stddev_int8/stddev_int8.3.ast | 72 +++- .../stddev_int8_null/stddev_int8_null.3.ast | 19 ++ .../stddev_pop_mixed/stddev_pop_mixed.3.ast | 22 ++ .../resources/runtimets/testsuite_sqlpp.xml | 34 ++ .../runtimets/testsuite_sqlpp_parser.xml | 178 +++++++++- .../main/markdown/builtins/9_aggregate_sql.md | 51 +++ .../asterix/om/functions/BuiltinFunctions.java | 166 +++++++++ .../ScalarSqlStddevPopAggregateDescriptor.java | 49 +++ .../ScalarStddevPopAggregateDescriptor.java | 49 +++ ...ngleVariableStatisticsAggregateFunction.java | 4 +- ...zableGlobalSqlStddevAggregateDescriptor.java | 2 +- ...lizableGlobalSqlStddevAggregateFunction.java | 19 +- ...leGlobalSqlStddevPopAggregateDescriptor.java | 63 ++++ ...alizableGlobalStddevAggregateDescriptor.java | 2 +- ...rializableGlobalStddevAggregateFunction.java | 19 +- ...zableGlobalStddevPopAggregateDescriptor.java | 63 ++++ ...ntermediateSqlStddevAggregateDescriptor.java | 2 +- ...eIntermediateSqlStddevAggregateFunction.java | 11 +- ...rmediateSqlStddevPopAggregateDescriptor.java | 63 ++++ ...leIntermediateStddevAggregateDescriptor.java | 2 +- ...ableIntermediateStddevAggregateFunction.java | 11 +- ...ntermediateStddevPopAggregateDescriptor.java | 63 ++++ ...izableLocalSqlStddevAggregateDescriptor.java | 2 +- ...alizableLocalSqlStddevAggregateFunction.java | 11 +- ...bleLocalSqlStddevPopAggregateDescriptor.java | 63 ++++ ...ializableLocalStddevAggregateDescriptor.java | 2 +- ...erializableLocalStddevAggregateFunction.java | 11 +- ...izableLocalStddevPopAggregateDescriptor.java | 63 ++++ ...erializableSqlStddevAggregateDescriptor.java | 2 +- .../SerializableSqlStddevAggregateFunction.java | 19 +- ...alizableSqlStddevPopAggregateDescriptor.java | 61 ++++ .../SerializableStddevAggregateDescriptor.java | 2 +- .../SerializableStddevAggregateFunction.java | 19 +- ...erializableStddevPopAggregateDescriptor.java | 62 ++++ ...actSingleVarStatisticsAggregateFunction.java | 4 +- .../std/GlobalSqlStddevAggregateDescriptor.java | 2 +- .../std/GlobalSqlStddevAggregateFunction.java | 19 +- .../GlobalSqlStddevPopAggregateDescriptor.java | 62 ++++ .../std/GlobalStddevAggregateDescriptor.java | 2 +- .../std/GlobalStddevAggregateFunction.java | 19 +- .../std/GlobalStddevPopAggregateDescriptor.java | 62 ++++ ...ntermediateSqlStddevAggregateDescriptor.java | 2 +- .../IntermediateSqlStddevAggregateFunction.java | 11 +- ...rmediateSqlStddevPopAggregateDescriptor.java | 61 ++++ .../IntermediateStddevAggregateDescriptor.java | 2 +- .../IntermediateStddevAggregateFunction.java | 11 +- ...ntermediateStddevPopAggregateDescriptor.java | 62 ++++ .../std/LocalSqlStddevAggregateDescriptor.java | 2 +- .../std/LocalSqlStddevAggregateFunction.java | 11 +- .../LocalSqlStddevPopAggregateDescriptor.java | 60 ++++ .../std/LocalStddevAggregateDescriptor.java | 2 +- .../std/LocalStddevAggregateFunction.java | 11 +- .../std/LocalStddevPopAggregateDescriptor.java | 60 ++++ .../std/SqlStddevAggregateDescriptor.java | 2 +- .../std/SqlStddevAggregateFunction.java | 19 +- .../std/SqlStddevPopAggregateDescriptor.java | 61 ++++ .../std/StddevAggregateDescriptor.java | 2 +- .../aggregates/std/StddevAggregateFunction.java | 19 +- .../std/StddevPopAggregateDescriptor.java | 61 ++++ .../runtime/functions/FunctionCollection.java | 36 ++ 310 files changed, 5178 insertions(+), 956 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null/agg_null.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null/agg_null.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null/agg_null.3.query.aql index db3e6c1..51d6069 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null/agg_null.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null/agg_null.3.query.aql @@ -24,4 +24,4 @@ let $l1 := [null] let $l2 := {{null, null}} -return { "sql-count1": sql-count($l1), "average1": sql-avg($l1), "sql-sum1": sql-sum($l1), "sql-min1": sql-min($l1), "sql-max1": sql-max($l1), "sql-stddev1": sql-stddev($l1), "sql-count2": sql-count($l2), "average2": sql-avg($l2), "sql-sum2": sql-sum($l2), "sql-min2": sql-min($l2), "sql-max2": sql-max($l2), "sql-stddev2": sql-stddev($l2)} +return { "sql-count1": sql-count($l1), "average1": sql-avg($l1), "sql-sum1": sql-sum($l1), "sql-min1": sql-min($l1), "sql-max1": sql-max($l1), "sql-stddev1": sql-stddev($l1), "sql-stddev_pop1": sql-stddev_pop($l1), "sql-count2": sql-count($l2), "average2": sql-avg($l2), "sql-sum2": sql-sum($l2), "sql-min2": sql-min($l2), "sql-max2": sql-max($l2), "sql-stddev2": sql-stddev($l2), "sql-stddev_pop2": sql-stddev_pop($l2) } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null_rec/agg_null_rec.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null_rec/agg_null_rec.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null_rec/agg_null_rec.3.query.aql index 0e9081a..6fcde5c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null_rec/agg_null_rec.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null_rec/agg_null_rec.3.query.aql @@ -25,4 +25,4 @@ use dataverse test; let $l := for $t in dataset Test return $t.valplus -return { "sql-count": sql-count($l), "average": sql-avg($l), "sql-stddev": sql-stddev($l), "sql-sum": sql-sum($l), "sql-min": sql-min($l), "sql-max": sql-max($l) } +return { "sql-count": sql-count($l), "average": sql-avg($l), "sql-stddev": sql-stddev($l), "sql-stddev_pop": sql-stddev_pop($l), "sql-sum": sql-sum($l), "sql-min": sql-min($l), "sql-max": sql-max($l) } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.aql index 121264d..fbdaa58 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.aql @@ -27,4 +27,5 @@ use dataverse test; let $l := for $t in dataset Test return $t return { "sql-count": sql-count($l), "average": sql-avg(for $i in $l return $i.val), "sql-sum": sql-sum(for $i in $l return $i.val), "sql-stddev": sql-stddev(for $i in $l return $i.valplus), -"sql-min": sql-min(for $i in $l return $i.valplus), "sql-max": sql-max(for $i in $l return $i.valplus) } +"sql-stddev_pop": sql-stddev_pop(for $i in $l return $i.valplus), "sql-min": sql-min(for $i in $l return $i.valplus), +"sql-max": sql-max(for $i in $l return $i.valplus) } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_number/agg_number.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_number/agg_number.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_number/agg_number.3.query.aql index ea1db8a..eeab6ad 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_number/agg_number.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_number/agg_number.3.query.aql @@ -30,5 +30,6 @@ let $a3 := sql-sum($l2) let $a4 := sql-min($l2) let $a5 := sql-max($l2) let $a6 := sql-stddev($l2) -return { "sql-count1": sql-count($l1), "average1": sql-avg($l1), "sql-stddev1": sql-stddev($l1), "sql-sum1": sql-sum($l1), "sql-min1": sql-min($l1), "sql-max1": sql-max($l1), "sql-count2": $a1, "average2": $a2, "sql-stddev2": $a6, "sql-sum2": $a3, "sql-min2": $a4, "sql-max2": $a5 } +let $a7 := sql-stddev_pop($l2) +return { "sql-count1": sql-count($l1), "average1": sql-avg($l1), "sql-stddev1": sql-stddev($l1), "sql-stddev_pop1": sql-stddev_pop($l1), "sql-sum1": sql-sum($l1), "sql-min1": sql-min($l1), "sql-max1": sql-max($l1), "sql-count2": $a1, "average2": $a2, "sql-stddev2": $a6, "sql-stddev_pop2": $a7, "sql-sum2": $a3, "sql-min2": $a4, "sql-max2": $a5 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_number_rec/agg_number_rec.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_number_rec/agg_number_rec.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_number_rec/agg_number_rec.3.query.aql index 522b50e..cd93b51 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_number_rec/agg_number_rec.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate-sql/agg_number_rec/agg_number_rec.3.query.aql @@ -25,4 +25,4 @@ use dataverse test; let $l := for $t in dataset Test return $t.valplus -return { "sql-count": sql-count($l), "average": sql-avg($l), "sql-stddev": sql-stddev($l), "sql-sum": sql-sum($l), "sql-min": sql-min($l), "sql-max": sql-max($l) } +return { "sql-count": sql-count($l), "average": sql-avg($l), "sql-stddev": sql-stddev($l), "sql-stddev_pop": sql-stddev_pop($l), "sql-sum": sql-sum($l), "sql-min": sql-min($l), "sql-max": sql-max($l) } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null/agg_null.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null/agg_null.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null/agg_null.3.query.aql index 5f39d47..92fc08f 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null/agg_null.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null/agg_null.3.query.aql @@ -24,4 +24,4 @@ let $l1 := [null] let $l2 := {{null, null}} -return { "count1": count($l1), "average1": avg($l1), "sum1": sum($l1), "min1": min($l1), "max1": max($l1),"stddev1": stddev($l1), "count2": count($l2), "average2": avg($l2), "sum2": sum($l2), "min2": min($l2), "max2": max($l2), "stddev2": stddev($l2) } +return { "count1": count($l1), "average1": avg($l1), "sum1": sum($l1), "min1": min($l1), "max1": max($l1),"stddev1": stddev($l1), "stddev_pop1": stddev_pop($l1), "count2": count($l2), "average2": avg($l2), "sum2": sum($l2), "min2": min($l2), "max2": max($l2), "stddev2": stddev($l2), "stddev_pop2": stddev_pop($l2) } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null_rec/agg_null_rec.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null_rec/agg_null_rec.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null_rec/agg_null_rec.3.query.aql index 5b14f2d..238fb4e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null_rec/agg_null_rec.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null_rec/agg_null_rec.3.query.aql @@ -25,4 +25,4 @@ use dataverse test; let $l := for $t in dataset Test return $t.valplus -return { "count": count($l), "average": avg($l), "stddev": stddev($l), "sum": sum($l), "min": min($l), "max": max($l) } +return { "count": count($l), "average": avg($l), "stddev": stddev($l), "stddev_pop": stddev_pop($l), "sum": sum($l), "min": min($l), "max": max($l) } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null_rec_1/agg_null_rec_1.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null_rec_1/agg_null_rec_1.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null_rec_1/agg_null_rec_1.3.query.aql index 5b8a017..1e2dcd2 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null_rec_1/agg_null_rec_1.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_null_rec_1/agg_null_rec_1.3.query.aql @@ -27,4 +27,5 @@ use dataverse test; let $l := for $t in dataset Test return $t return { "count": count($l), "average": avg(for $i in $l return $i.val), "sum": sum(for $i in $l return $i.val), "stddev": stddev(for $i in $l return $i.val), -"min": min(for $i in $l return $i.valplus), "max": max(for $i in $l return $i.valplus) } +"stddev_pop": stddev_pop(for $i in $l return $i.val), "min": min(for $i in $l return $i.valplus), +"max": max(for $i in $l return $i.valplus) } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_number/agg_number.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_number/agg_number.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_number/agg_number.3.query.aql index 3ece422..98e996e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_number/agg_number.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_number/agg_number.3.query.aql @@ -30,5 +30,6 @@ let $a3 := sum($l2) let $a4 := min($l2) let $a5 := max($l2) let $a6 := stddev($l2) -return { "count1": count($l1), "average1": avg($l1), "stddev1": stddev($l1), "sum1": sum($l1), "min1": min($l1), "max1": max($l1), "count2": $a1, "average2": $a2, "stddev2": $a6, "sum2": $a3, "min2": $a4, "max2": $a5 } +let $a7 := stddev_pop($l2) +return { "count1": count($l1), "average1": avg($l1), "stddev1": stddev($l1), "stddev_pop1": stddev_pop($l1), "sum1": sum($l1), "min1": min($l1), "max1": max($l1), "count2": $a1, "average2": $a2, "stddev2": $a6, "stddev_pop2": $a7, "sum2": $a3, "min2": $a4, "max2": $a5 } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_number_rec/agg_number_rec.3.query.aql ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_number_rec/agg_number_rec.3.query.aql b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_number_rec/agg_number_rec.3.query.aql index 220ff31..8dbb4d3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_number_rec/agg_number_rec.3.query.aql +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries/aggregate/agg_number_rec/agg_number_rec.3.query.aql @@ -25,4 +25,4 @@ use dataverse test; let $l := for $t in dataset Test return $t.valplus -return { "count": count($l), "average": avg($l), "stddev": stddev($l), "sum": sum($l), "min": min($l), "max": max($l) } +return { "count": count($l), "average": avg($l), "stddev": stddev($l), "stddev_pop": stddev_pop($l), "sum": sum($l), "min": min($l), "max": max($l) } http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null/agg_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null/agg_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null/agg_null.3.query.sqlpp index 9fd31d1..547b555 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null/agg_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null/agg_null.3.query.sqlpp @@ -22,4 +22,4 @@ * Date : Feb 7th 2014 */ -{'sql-count1':array_count([null]),'average1':array_avg([null]),'sql-sum1':array_sum([null]),'sql-min1':array_min([null]),'sql-max1':array_max([null]),'sql-stddev1':array_stddev([null]),'sql-count2':array_count({{null,null}}),'average2':array_avg({{null,null}}),'sql-sum2':array_sum({{null,null}}),'sql-min2':array_min({{null,null}}),'sql-max2':array_max({{null,null}}),'sql-stddev2':array_stddev({{null,null}})}; +{'sql-count1':array_count([null]),'average1':array_avg([null]),'sql-sum1':array_sum([null]),'sql-min1':array_min([null]),'sql-max1':array_max([null]),'sql-stddev1':array_stddev([null]),'sql-stddev_pop1':array_stddev_pop([null]),'sql-count2':array_count({{null,null}}),'average2':array_avg({{null,null}}),'sql-sum2':array_sum({{null,null}}),'sql-min2':array_min({{null,null}}),'sql-max2':array_max({{null,null}}),'sql-stddev2':array_stddev({{null,null}}),'sql-stddev_pop2':array_stddev_pop({{null,null}})}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.query.sqlpp index b5bdd81..1831367 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.query.sqlpp @@ -43,4 +43,7 @@ use test; )),'sql-stddev':test.array_stddev(( select element t.valplus from Test as t +)),'sql-stddev_pop':test.array_stddev_pop(( + select element t.valplus + from Test as t ))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.sqlpp index 13c8be1..9a56d93 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.query.sqlpp @@ -58,4 +58,10 @@ use test; select element t from Test as t ) as i +)),'sql-stddev_pop':test.array_stddev_pop(( + select element i.valplus + from ( + select element t + from Test as t + ) as i ))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_number/agg_number.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_number/agg_number.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_number/agg_number.3.query.sqlpp index 4776925..f76f7d6 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_number/agg_number.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_number/agg_number.3.query.sqlpp @@ -22,4 +22,4 @@ * Date : Feb 7th 2014 */ -{'sql-count1':array_count([float('2.0'),double('3.0'),93847382783847382,1]),'average1':array_avg([float('2.0'),double('3.0'),93847382783847382,1]),'sql-sum1':array_sum([float('2.0'),double('3.0'),93847382783847382,1]),'sql-min1':array_min([float('2.0'),double('3.0'),93847382783847382,1]),'sql-max1':array_max([float('2.0'),double('3.0'),93847382783847382,1]),'sql-stddev1':array_stddev([float('2.0'),double('3.0'),93847382783847382,1]),'sql-count2':array_count({{float('2.0'),double('3.0'),93847382783847382,1}}),'average2':array_avg({{float('2.0'),double('3.0'),93847382783847382,1}}),'sql-sum2':array_sum({{float('2.0'),double('3.0'),93847382783847382,1}}),'sql-min2':array_min({{float('2.0'),double('3.0'),93847382783847382,1}}),'sql-max2':array_max({{float('2.0'),double('3.0'),93847382783847382,1}}),'sql-stddev2':array_stddev({{float('2.0'),double('3.0'),93847382783847382,1}})}; +{'sql-count1':array_count([float('2.0'),double('3.0'),93847382783847382,1]),'average1':array_avg([float('2.0'),double('3.0'),93847382783847382,1]),'sql-sum1':array_sum([float('2.0'),double('3.0'),93847382783847382,1]),'sql-min1':array_min([float('2.0'),double('3.0'),93847382783847382,1]),'sql-max1':array_max([float('2.0'),double('3.0'),93847382783847382,1]),'sql-stddev1':array_stddev([float('2.0'),double('3.0'),93847382783847382,1]),'sql-stddev_pop1':array_stddev_pop([float('2.0'),double('3.0'),93847382783847382,1]),'sql-count2':array_count({{float('2.0'),double('3.0'),93847382783847382,1}}),'average2':array_avg({{float('2.0'),double('3.0'),93847382783847382,1}}),'sql-sum2':array_sum({{float('2.0'),double('3.0'),93847382783847382,1}}),'sql-min2':array_min({{float('2.0'),double('3.0'),93847382783847382,1}}),'sql-max2':array_max({{float('2.0'),double('3.0'),93847382783847382,1}}),'sql-stddev2':array_stddev({{float('2.0'),double('3.0'),93847382783847382,1}}),'sql-stddev_pop2':array_std dev_pop({{float('2.0'),double('3.0'),93847382783847382,1}})}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.query.sqlpp index faec87a..790e567 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.query.sqlpp @@ -43,4 +43,7 @@ use test; )),'sql-stddev':test.array_stddev(( select element t.valplus from Test as t +)),'sql-stddev_pop':test.array_stddev_pop(( + select element t.valplus + from Test as t ))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.1.ddl.sqlpp index fbd4e19..7049419 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.1.ddl.sqlpp @@ -17,7 +17,7 @@ * under the License. */ /* - * Description : Tests the scalar version of array_avg without nulls. + * Description : Tests the scalar version of stddev and stddev_pop without nulls. * Success : Yes */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.3.query.sqlpp index 8a4ed23..061da60 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev/scalar_stddev.3.query.sqlpp @@ -17,19 +17,26 @@ * under the License. */ /* - * Description : Tests the scalar version of array_stddev without nulls. + * Description : Tests the scalar version of stddev and stddev_pop without nulls. * Success : Yes */ use test; - -with i8 as test.array_stddev([test.tinyint('1'),test.tinyint('2'),test.tinyint('3')]), +{'stddev': (with i8 as test.array_stddev([test.tinyint('1'),test.tinyint('2'),test.tinyint('3')]), i16 as test.array_stddev([test.smallint('1'),test.smallint('2'),test.smallint('3')]), i32 as test.array_stddev([test.integer('1'),test.integer('2'),test.integer('3')]), i64 as test.array_stddev([test.bigint('1'),test.bigint('2'),test.bigint('3')]), f as test.array_stddev([test.float('1'),test.float('2'),test.float('3')]), d as test.array_stddev([test.double('1'),test.double('2'),test.double('3')]) select element i -from [i8,i16,i32,i64,f,d] as i -; +from [i8,i16,i32,i64,f,d] as i), +'stddev_pop': (with i8 as test.array_stddev_pop([test.tinyint('1'),test.tinyint('2'),test.tinyint('3')]), + i16 as test.array_stddev_pop([test.smallint('1'),test.smallint('2'),test.smallint('3')]), + i32 as test.array_stddev_pop([test.integer('1'),test.integer('2'),test.integer('3')]), + i64 as test.array_stddev_pop([test.bigint('1'),test.bigint('2'),test.bigint('3')]), + f as test.array_stddev_pop([test.float('1'),test.float('2'),test.float('3')]), + d as test.array_stddev_pop([test.double('1'),test.double('2'),test.double('3')]) +select element i +from [i8,i16,i32,i64,f,d] as i) +}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.1.ddl.sqlpp index 430406c..63c85db 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.1.ddl.sqlpp @@ -17,7 +17,7 @@ * under the License. */ /* - * Description : Tests the scalar version of array_avg with an empty list. + * Description : Tests the scalar version of stddev and stddev_pop with an empty list. * Success : Yes */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.3.query.sqlpp index 2b01753..f29f59a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_empty/scalar_stddev_empty.3.query.sqlpp @@ -17,8 +17,9 @@ * under the License. */ /* - * Description : Tests the scalar version of array_stddev with an empty list. + * Description : Tests the scalar version of stddev and stddev_pop with an empty list. * Success : Yes */ -select element array_stddev([]); +{'stddev': (select element array_stddev([])), +'stddev_pop': (select element array_stddev_pop([]))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.1.ddl.sqlpp index 87b10c9..487d166 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.1.ddl.sqlpp @@ -17,7 +17,7 @@ * under the License. */ /* - * Description : Tests the scalar version of array_avg with nulls. + * Description : Tests the scalar version of stddev and stddev_pop with nulls. * Success : Yes */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.3.query.sqlpp index e49076d..8a2db99 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/scalar_stddev_null/scalar_stddev_null.3.query.sqlpp @@ -17,19 +17,26 @@ * under the License. */ /* - * Description : Tests the scalar version of array_stddev with nulls. + * Description : Tests the scalar version of stddev and stddev_pop with nulls. * Success : Yes */ use test; - -with i8 as test.array_stddev([test.tinyint('1'),test.tinyint('2'),test.tinyint('3'),null]), +{'stddev': (with i8 as test.array_stddev([test.tinyint('1'),test.tinyint('2'),test.tinyint('3'),null]), i16 as test.array_stddev([test.smallint('1'),test.smallint('2'),test.smallint('3'),null]), i32 as test.array_stddev([test.integer('1'),test.integer('2'),test.integer('3'),null]), i64 as test.array_stddev([test.bigint('1'),test.bigint('2'),test.bigint('3'),null]), f as test.array_stddev([test.float('1'),test.float('2'),test.float('3'),null]), d as test.array_stddev([test.double('1'),test.double('2'),test.double('3'),null]) select element i -from [i8,i16,i32,i64,f,d] as i -; +from [i8,i16,i32,i64,f,d] as i), +'stddev_pop': (with i8 as test.array_stddev_pop([test.tinyint('1'),test.tinyint('2'),test.tinyint('3'),null]), + i16 as test.array_stddev_pop([test.smallint('1'),test.smallint('2'),test.smallint('3'),null]), + i32 as test.array_stddev_pop([test.integer('1'),test.integer('2'),test.integer('3'),null]), + i64 as test.array_stddev_pop([test.bigint('1'),test.bigint('2'),test.bigint('3'),null]), + f as test.array_stddev_pop([test.float('1'),test.float('2'),test.float('3'),null]), + d as test.array_stddev_pop([test.double('1'),test.double('2'),test.double('3'),null]) +select element i +from [i8,i16,i32,i64,f,d] as i) +}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_double/serial_stddev_double.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_double/serial_stddev_double.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_double/serial_stddev_double.3.query.sqlpp index 1219f2e..d20e7c9 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_double/serial_stddev_double.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_double/serial_stddev_double.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.val) as stddev +select gid, stddev(t.val) as stddev, stddev_pop(t.val) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_double_null/serial_stddev_double_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_double_null/serial_stddev_double_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_double_null/serial_stddev_double_null.3.query.sqlpp index 2125b05..eb4bc56 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_double_null/serial_stddev_double_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_double_null/serial_stddev_double_null.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.valplus) as stddev +select gid, stddev(t.valplus) as stddev, stddev_pop(t.valplus) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_empty/serial_stddev_empty.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_empty/serial_stddev_empty.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_empty/serial_stddev_empty.3.query.sqlpp index 1219f2e..d20e7c9 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_empty/serial_stddev_empty.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_empty/serial_stddev_empty.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.val) as stddev +select gid, stddev(t.val) as stddev, stddev_pop(t.val) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_float/serial_stddev_float.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_float/serial_stddev_float.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_float/serial_stddev_float.3.query.sqlpp index 1219f2e..d20e7c9 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_float/serial_stddev_float.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_float/serial_stddev_float.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.val) as stddev +select gid, stddev(t.val) as stddev, stddev_pop(t.val) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_float_null/serial_stddev_float_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_float_null/serial_stddev_float_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_float_null/serial_stddev_float_null.3.query.sqlpp index 2125b05..eb4bc56 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_float_null/serial_stddev_float_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_float_null/serial_stddev_float_null.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.valplus) as stddev +select gid, stddev(t.valplus) as stddev, stddev_pop(t.valplus) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int16/serial_stddev_int16.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int16/serial_stddev_int16.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int16/serial_stddev_int16.3.query.sqlpp index 1219f2e..d20e7c9 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int16/serial_stddev_int16.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int16/serial_stddev_int16.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.val) as stddev +select gid, stddev(t.val) as stddev, stddev_pop(t.val) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int16_null/serial_stddev_int16_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int16_null/serial_stddev_int16_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int16_null/serial_stddev_int16_null.3.query.sqlpp index 2125b05..eb4bc56 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int16_null/serial_stddev_int16_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int16_null/serial_stddev_int16_null.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.valplus) as stddev +select gid, stddev(t.valplus) as stddev, stddev_pop(t.valplus) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.query.sqlpp index 1219f2e..d20e7c9 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.val) as stddev +select gid, stddev(t.val) as stddev, stddev_pop(t.val) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.query.sqlpp index 2125b05..eb4bc56 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.valplus) as stddev +select gid, stddev(t.valplus) as stddev, stddev_pop(t.valplus) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.query.sqlpp index 1219f2e..d20e7c9 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.val) as stddev +select gid, stddev(t.val) as stddev, stddev_pop(t.val) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.query.sqlpp index 2125b05..eb4bc56 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.valplus) as stddev +select gid, stddev(t.valplus) as stddev, stddev_pop(t.valplus) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.query.sqlpp index 1219f2e..d20e7c9 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.val) as stddev +select gid, stddev(t.val) as stddev, stddev_pop(t.val) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.query.sqlpp index 2125b05..eb4bc56 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.query.sqlpp @@ -19,7 +19,7 @@ use test; -select gid, stddev(t.valplus) as stddev +select gid, stddev(t.valplus) as stddev, stddev_pop(t.valplus) as stddev_pop from Test as t /* +hash */ group by t.gid as gid; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.ddl.sqlpp new file mode 100644 index 0000000..da0bd7b --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.ddl.sqlpp @@ -0,0 +1,33 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +drop dataverse test if exists; +create dataverse test; + +use test; + + +create type test.TestType as +{ + id : bigint, + gid : bigint, + val : double +}; + +create dataset Test(TestType) primary key id; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.2.update.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.2.update.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.2.update.sqlpp new file mode 100644 index 0000000..8c0b731 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.2.update.sqlpp @@ -0,0 +1,29 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + +use test; + +insert into Test +select element {'id':0,'gid':1,'val':double(4.32),'valplus':float('2.0')}; +insert into Test +select element {'id':1,'gid':1,'val':double(5.32)}; +insert into Test +select element {'id':2,'gid':1,'val':double(6.32),'valplus':'hello world'}; +insert into Test +select element {'id':3,'gid':1,'val':double(4.32),'valplus':double('3.0')}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.3.query.sqlpp new file mode 100644 index 0000000..207b139 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/serial_stddev_pop_mixed/serial_stddev_pop_mixed.3.query.sqlpp @@ -0,0 +1,30 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + /* + * Description : Run serial-stddev over an ordered list with mixed types + * Expected Res : Failure + * Date : March 5th 2018 + */ + +use test; + +select gid, array_stddev_pop((select value g.valplus from g)) as stddev_pop +from Test as t +/* +hash */ +group by t.gid as gid group as g(valplus as valplus); http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_distinct/stddev_distinct.1.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_distinct/stddev_distinct.1.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_distinct/stddev_distinct.1.query.sqlpp new file mode 100644 index 0000000..37606a1 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_distinct/stddev_distinct.1.query.sqlpp @@ -0,0 +1,28 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, + * software distributed under the License is distributed on an + * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + * KIND, either express or implied. See the License for the + * specific language governing permissions and limitations + * under the License. + */ + { + 't1': to_bigint(array_stddev(distinct [10,20,30,10,20,30,10])), + 't2': to_bigint(array_stddev(distinct [null,missing,null,missing])), + 't3': to_bigint(array_stddev(distinct [40,null,missing,50,40,null,missing,50,40])), + 't4': to_bigint(array_stddev(distinct [])), + 't5': to_bigint(array_stddev_pop(distinct [10,20,30,10,20,30,10])), + 't6': to_bigint(array_stddev_pop(distinct [null,missing,null,missing])), + 't7': to_bigint(array_stddev_pop(distinct [40,null,missing,50,40,null,missing,50,40])), + 't8': to_bigint(array_stddev_pop(distinct [])) + }; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_double/stddev_double.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_double/stddev_double.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_double/stddev_double.3.query.sqlpp index 4a539ed..ff20386 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_double/stddev_double.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_double/stddev_double.3.query.sqlpp @@ -17,7 +17,10 @@ * under the License. */ -select element array_stddev(( +{'stddev': (select element array_stddev(( select element x from [1.0,2.0,double('3.0')] as x -)); +))), 'stddev_pop': (select element array_stddev_pop(( + select element x + from [1.0,2.0,double('3.0')] as x +)))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.3.query.sqlpp index c06f58d..3899ca2 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.3.query.sqlpp @@ -23,4 +23,7 @@ use test; {'stddev':test.array_stddev(( select element x.doubleField from Numeric as x +)), 'stddev_pop':test.array_stddev_pop(( + select element x.doubleField + from Numeric as x ))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.1.ddl.sqlpp index a6590c5..e2d346b 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.1.ddl.sqlpp @@ -17,7 +17,7 @@ * under the License. */ /* - * Description : Tests that array_avg aggregation correctly returns null for an empty stream, + * Description : Tests that array_stddev aggregation correctly returns null for an empty stream, * without an aggregate combiner. * Success : Yes */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.query.sqlpp index 8331de0..988b1e6 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.query.sqlpp @@ -17,7 +17,7 @@ * under the License. */ /* - * Description : Tests that array_stddev aggregation correctly returns null for an empty stream, + * Description : Tests that stddev and stddev_pop aggregation correctly returns null for an empty stream, * without an aggregate combiner. * Success : Yes */ @@ -25,8 +25,12 @@ use test; -select element test.array_stddev(( +{'stddev': (select element test.array_stddev(( select element x from [1,2,3] as x where (x > 10) -)); +))), 'stddev_pop': (select element test.array_stddev_pop(( + select element x + from [1,2,3] as x + where (x > 10) +)))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.1.ddl.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.1.ddl.sqlpp index b9cd662..444cfb2 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.1.ddl.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.1.ddl.sqlpp @@ -17,7 +17,7 @@ * under the License. */ /* - * Description : Tests that array_avg aggregation correctly returns null for an empty stream, + * Description : Tests that array_stddev aggregation correctly returns null for an empty stream, * with an aggregate combiner. * Success : Yes */ http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.query.sqlpp index bfbe1b1..3ad8d1b 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.query.sqlpp @@ -17,7 +17,7 @@ * under the License. */ /* - * Description : Tests that array_stddev aggregation correctly returns null for an empty stream, + * Description : Tests that stddev and stddev_pop aggregation correctly returns null for an empty stream, * with an aggregate combiner. * Success : Yes */ @@ -25,7 +25,10 @@ use test; -select element test.array_stddev(( +{'stddev': (select element test.array_stddev(( select element x.val from Test as x -)); +))), 'stddev_pop': (select element test.array_stddev_pop(( + select element x.val + from Test as x +)))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_float/stddev_float.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_float/stddev_float.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_float/stddev_float.3.query.sqlpp index cb51c3d..a4baabb 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_float/stddev_float.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_float/stddev_float.3.query.sqlpp @@ -20,7 +20,10 @@ use test; -select element test.array_stddev(( +{'stddev': (select element test.array_stddev(( select element x from [test.float('1'),test.float('2'),test.float('3')] as x -)); +))), 'stddev_pop': (select element test.array_stddev_pop(( + select element x + from [test.float('1'),test.float('2'),test.float('3')] as x +)))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.query.sqlpp index c85ce12..8a1abff 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.query.sqlpp @@ -23,4 +23,7 @@ use test; {'stddev':test.array_stddev(( select element x.floatField from Numeric as x +)), 'stddev_pop':test.array_stddev_pop(( + select element x.floatField + from Numeric as x ))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.query.sqlpp index c5360e9..2ad24ab 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.query.sqlpp @@ -20,7 +20,10 @@ use test; -select element test.array_stddev(( +{'stddev': (select element test.array_stddev(( select element x from [test.smallint('1'),test.smallint('2'),test.smallint('3')] as x -)); +))), 'stddev_pop': (select element test.array_stddev_pop(( + select element x + from [test.smallint('1'),test.smallint('2'),test.smallint('3')] as x +)))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.query.sqlpp index f89e1ec..2da44d4 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.query.sqlpp @@ -23,4 +23,7 @@ use test; {'stddev':test.array_stddev(( select element x.int16Field from Numeric as x +)), 'stddev_pop':test.array_stddev_pop(( + select element x.int16Field + from Numeric as x ))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.query.sqlpp index afbe777..b8a59c3 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.query.sqlpp @@ -20,7 +20,10 @@ use test; -select element test.array_stddev(( +{'stddev': (select element test.array_stddev(( select element x from [test.integer('1'),test.integer('2'),test.integer('3')] as x -)); +))), 'stddev_pop': (select element test.array_stddev_pop(( + select element x + from [test.integer('1'),test.integer('2'),test.integer('3')] as x +)))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.query.sqlpp index a76ea4a..4d0ff58 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.query.sqlpp @@ -23,4 +23,7 @@ use test; {'stddev':test.array_stddev(( select element x.int32Field from Numeric as x +)), 'stddev_pop':test.array_stddev_pop(( + select element x.int32Field + from Numeric as x ))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.query.sqlpp index 17e2285..cf0fa59 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.query.sqlpp @@ -20,7 +20,10 @@ use test; -select element test.array_stddev(( +{'stddev': (select element test.array_stddev(( select element x from [test.bigint('1'),test.bigint('2'),test.bigint('3')] as x -)); +))), 'stddev_pop': (select element test.array_stddev_pop(( + select element x + from [test.bigint('1'),test.bigint('2'),test.bigint('3')] as x +)))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.query.sqlpp index 5ed6db6..7aa502c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.query.sqlpp @@ -23,4 +23,7 @@ use test; {'stddev':test.array_stddev(( select element x.int64Field from Numeric as x +)), 'stddev_pop':test.array_stddev_pop(( + select element x.int64Field + from Numeric as x ))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.query.sqlpp index 6efdcaf..016b368 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.query.sqlpp @@ -20,7 +20,10 @@ use test; -select element test.array_stddev(( +{'stddev': (select element test.array_stddev(( select element x from [test.tinyint('1'),test.tinyint('2'),test.tinyint('3')] as x -)); +))), 'stddev_pop': (select element test.array_stddev_pop(( + select element x + from [test.tinyint('1'),test.tinyint('2'),test.tinyint('3')] as x +)))}; http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.query.sqlpp ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.query.sqlpp index 1001843..f7e4dbe 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.query.sqlpp +++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.query.sqlpp @@ -23,4 +23,7 @@ use test; {'stddev':test.array_stddev(( select element x.int8Field from Numeric as x +)), 'stddev_pop':test.array_stddev_pop(( + select element x.int8Field + from Numeric as x ))};
