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_null/stddev_double_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.3.ast index e01f5cc..02ccab8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.3.ast @@ -20,4 +20,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=doubleField + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) ]
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.ast index f85f450..51a67dc 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.ast @@ -1,24 +1,60 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.sql-stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - Variable [ Name=$x ] - ] - FROM [ OrderedListConstructor [ - LiteralExpr [LONG] [1] - LiteralExpr [LONG] [2] - LiteralExpr [LONG] [3] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + LiteralExpr [LONG] [1] + LiteralExpr [LONG] [2] + LiteralExpr [LONG] [3] + ] + AS Variable [ Name=$x ] + ] + Where + OperatorExpr [ + Variable [ Name=$x ] + > + LiteralExpr [LONG] [10] + ] + ) ] - AS Variable [ Name=$x ] - ] - Where - OperatorExpr [ - Variable [ Name=$x ] - > - LiteralExpr [LONG] [10] ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + LiteralExpr [LONG] [1] + LiteralExpr [LONG] [2] + LiteralExpr [LONG] [3] + ] + AS Variable [ Name=$x ] + ] + Where + OperatorExpr [ + Variable [ Name=$x ] + > + LiteralExpr [LONG] [10] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.ast index 1e74018..1fcdc77 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.ast @@ -1,19 +1,50 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.sql-stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - FieldAccessor [ - Variable [ Name=$x ] - Field=val - ] - ] - FROM [ FunctionCall asterix.dataset@1[ - LiteralExpr [STRING] [test.Test] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=val + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Test] + ] + AS Variable [ Name=$x ] + ] + ) ] - AS Variable [ Name=$x ] - ] + ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=val + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Test] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float/stddev_float.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float/stddev_float.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float/stddev_float.3.ast index 139a799..3b9af93 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float/stddev_float.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float/stddev_float.3.ast @@ -1,24 +1,60 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.sql-stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - Variable [ Name=$x ] - ] - FROM [ OrderedListConstructor [ - FunctionCall test.float@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.float@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.float@1[ - LiteralExpr [STRING] [3] - ] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + ] + 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 [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.ast index 2fd1ef4..af4b678 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.ast @@ -20,4 +20,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=floatField + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.ast index e1d4be2..a3ae382 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.ast @@ -1,24 +1,60 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.sql-stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - Variable [ Name=$x ] - ] - FROM [ OrderedListConstructor [ - FunctionCall test.int16@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int16@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int16@1[ - LiteralExpr [STRING] [3] - ] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + ] + 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 [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.ast index ee1fdc7..abfdf357 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.ast @@ -20,4 +20,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=int16Field + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.ast index d40a004..475d383 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.ast @@ -1,24 +1,60 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.sql-stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - Variable [ Name=$x ] - ] - FROM [ OrderedListConstructor [ - FunctionCall test.int32@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int32@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int32@1[ - LiteralExpr [STRING] [3] - ] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + FunctionCall test.int32@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [3] + ] + ] + 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 [ + FunctionCall test.int32@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [3] + ] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.ast index 55da89c..ae92087 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.ast @@ -20,4 +20,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=int32Field + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.ast index 0583b7f..aafffb8 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.ast @@ -1,24 +1,60 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.sql-stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - Variable [ Name=$x ] - ] - FROM [ OrderedListConstructor [ - FunctionCall test.int64@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int64@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int64@1[ - LiteralExpr [STRING] [3] - ] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + FunctionCall test.int64@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [3] + ] + ] + 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 [ + FunctionCall test.int64@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [3] + ] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.ast index e8787dd..8726277 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.ast @@ -20,4 +20,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=int64Field + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.ast index 2ec6818..21b3171 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.ast @@ -1,24 +1,60 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.sql-stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - Variable [ Name=$x ] - ] - FROM [ OrderedListConstructor [ - FunctionCall test.int8@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int8@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int8@1[ - LiteralExpr [STRING] [3] - ] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + FunctionCall test.int8@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [3] + ] + ] + 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 [ + FunctionCall test.int8@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [3] + ] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.ast index a7c371c..f2c9bef 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.ast @@ -20,4 +20,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=int8Field + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_pop_mixed/stddev_pop_mixed.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_pop_mixed/stddev_pop_mixed.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_pop_mixed/stddev_pop_mixed.3.ast new file mode 100644 index 0000000..7c39453 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_pop_mixed/stddev_pop_mixed.3.ast @@ -0,0 +1,22 @@ +Query: +SELECT ELEMENT [ +FunctionCall asterix.sql-stddev_pop@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + FunctionCall null.float@1[ + LiteralExpr [STRING] [2.0] + ] + LiteralExpr [STRING] [hello world] + LiteralExpr [LONG] [93847382783847382] + FunctionCall null.date@1[ + LiteralExpr [STRING] [2013-01-01] + ] + ] + AS Variable [ Name=$x ] + ] + ) +] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null/agg_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null/agg_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null/agg_null.3.ast index 42aab0a..53b7249 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null/agg_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null/agg_null.3.ast @@ -55,6 +55,15 @@ RecordConstructor [ ] ) ( + LiteralExpr [STRING] [stddev_pop1] + : + FunctionCall asterix.stddev_pop@1[ + OrderedListConstructor [ + LiteralExpr [NULL] + ] + ] + ) + ( LiteralExpr [STRING] [count2] : FunctionCall asterix.count@1[ @@ -114,4 +123,14 @@ RecordConstructor [ ] ] ) + ( + LiteralExpr [STRING] [stddev_pop2] + : + FunctionCall asterix.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/agg_null_rec/agg_null_rec.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null_rec/agg_null_rec.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null_rec/agg_null_rec.3.ast index ea96a9a..d92c399 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null_rec/agg_null_rec.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null_rec/agg_null_rec.3.ast @@ -115,4 +115,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.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/agg_null_rec_1/agg_null_rec_1.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null_rec_1/agg_null_rec_1.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null_rec_1/agg_null_rec_1.3.ast index 5668cdb..5d11b6e 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null_rec_1/agg_null_rec_1.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_null_rec_1/agg_null_rec_1.3.ast @@ -147,5 +147,31 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$i ] + Field=val + ] + ] + 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/agg_number/agg_number.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_number/agg_number.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_number/agg_number.3.ast index c3f8e5b..59c27d9 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_number/agg_number.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_number/agg_number.3.ast @@ -97,6 +97,22 @@ RecordConstructor [ ] ) ( + LiteralExpr [STRING] [stddev_pop1] + : + FunctionCall asterix.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] [count2] : FunctionCall asterix.count@1[ @@ -192,4 +208,20 @@ RecordConstructor [ ] ] ) + ( + LiteralExpr [STRING] [stddev_pop2] + : + FunctionCall asterix.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] + ] + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_number_rec/agg_number_rec.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_number_rec/agg_number_rec.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_number_rec/agg_number_rec.3.ast index ea96a9a..d92c399 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_number_rec/agg_number_rec.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/agg_number_rec/agg_number_rec.3.ast @@ -115,4 +115,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.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/scalar_stddev/scalar_stddev.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev/scalar_stddev.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev/scalar_stddev.3.ast index 67d038e..4606161 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev/scalar_stddev.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev/scalar_stddev.3.ast @@ -1,105 +1,222 @@ DataverseUse test Query: -Let Variable [ Name=$i8 ] - := - FunctionCall asterix.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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/scalar_stddev_empty/scalar_stddev_empty.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_empty/scalar_stddev_empty.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_empty/scalar_stddev_empty.3.ast index 9834bb3..cb2d59f 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_empty/scalar_stddev_empty.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_empty/scalar_stddev_empty.3.ast @@ -1,7 +1,27 @@ Query: -SELECT ELEMENT [ -FunctionCall asterix.stddev@1[ - OrderedListConstructor [ - ] -] +RecordConstructor [ + ( + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.stddev@1[ + OrderedListConstructor [ + ] + ] + ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.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/scalar_stddev_null/scalar_stddev_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_null/scalar_stddev_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_null/scalar_stddev_null.3.ast index eac0b48..a155c95 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_null/scalar_stddev_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_null/scalar_stddev_null.3.ast @@ -1,111 +1,234 @@ DataverseUse test Query: -Let Variable [ Name=$i8 ] - := - FunctionCall asterix.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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/serial_stddev_double/serial_stddev_double.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.3.ast index 43263e5..02388b6 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +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/serial_stddev_double_null/serial_stddev_double_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.3.ast index f05d552..b8ce40c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.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] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_empty/serial_stddev_empty.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_empty/serial_stddev_empty.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_empty/serial_stddev_empty.3.ast index 43263e5..02388b6 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_empty/serial_stddev_empty.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_empty/serial_stddev_empty.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +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/serial_stddev_float/serial_stddev_float.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.3.ast index 43263e5..02388b6 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +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/serial_stddev_float_null/serial_stddev_float_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.3.ast index f05d552..b8ce40c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.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] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.3.ast index 43263e5..02388b6 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +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/serial_stddev_int16_null/serial_stddev_int16_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.3.ast index f05d552..b8ce40c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.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] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.3.ast index 43263e5..02388b6 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +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/serial_stddev_int32_null/serial_stddev_int32_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32_null/serial_stddev_int32_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32_null/serial_stddev_int32_null.3.ast index f05d552..b8ce40c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32_null/serial_stddev_int32_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32_null/serial_stddev_int32_null.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.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] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int64/serial_stddev_int64.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int64/serial_stddev_int64.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int64/serial_stddev_int64.3.ast index 43263e5..02388b6 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int64/serial_stddev_int64.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int64/serial_stddev_int64.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +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/serial_stddev_int64_null/serial_stddev_int64_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int64_null/serial_stddev_int64_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int64_null/serial_stddev_int64_null.3.ast index f05d552..b8ce40c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int64_null/serial_stddev_int64_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int64_null/serial_stddev_int64_null.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.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] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int8/serial_stddev_int8.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int8/serial_stddev_int8.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int8/serial_stddev_int8.3.ast index 43263e5..02388b6 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int8/serial_stddev_int8.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int8/serial_stddev_int8.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +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/serial_stddev_int8_null/serial_stddev_int8_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int8_null/serial_stddev_int8_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int8_null/serial_stddev_int8_null.3.ast index f05d552..b8ce40c 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int8_null/serial_stddev_int8_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int8_null/serial_stddev_int8_null.3.ast @@ -17,6 +17,20 @@ FunctionCall asterix.stddev@1[ ) ] stddev +FunctionCall asterix.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] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.1.ast new file mode 100644 index 0000000..a61c9df --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.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/serial_stddev_pop_mixed/serial_stddev_pop_mixed.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.2.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.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/serial_stddev_pop_mixed/serial_stddev_pop_mixed.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.3.ast new file mode 100644 index 0000000..5edf9bd --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_pop_mixed/serial_stddev_pop_mixed.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.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/stddev_double/stddev_double.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_double/stddev_double.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_double/stddev_double.3.ast index b2fcbe8..c2a0566 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_double/stddev_double.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_double/stddev_double.3.ast @@ -1,19 +1,51 @@ Query: -SELECT ELEMENT [ -FunctionCall asterix.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.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.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 ] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_double_null/stddev_double_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_double_null/stddev_double_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_double_null/stddev_double_null.3.ast index 433f0bc..863ef3a 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_double_null/stddev_double_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_double_null/stddev_double_null.3.ast @@ -20,4 +20,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=doubleField + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_empty_01/stddev_empty_01.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_empty_01/stddev_empty_01.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_empty_01/stddev_empty_01.3.ast index fe21498..6d6b228 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_empty_01/stddev_empty_01.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_empty_01/stddev_empty_01.3.ast @@ -1,24 +1,60 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - Variable [ Name=$x ] - ] - FROM [ OrderedListConstructor [ - LiteralExpr [LONG] [1] - LiteralExpr [LONG] [2] - LiteralExpr [LONG] [3] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + LiteralExpr [LONG] [1] + LiteralExpr [LONG] [2] + LiteralExpr [LONG] [3] + ] + AS Variable [ Name=$x ] + ] + Where + OperatorExpr [ + Variable [ Name=$x ] + > + LiteralExpr [LONG] [10] + ] + ) ] - AS Variable [ Name=$x ] - ] - Where - OperatorExpr [ - Variable [ Name=$x ] - > - LiteralExpr [LONG] [10] ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + LiteralExpr [LONG] [1] + LiteralExpr [LONG] [2] + LiteralExpr [LONG] [3] + ] + AS Variable [ Name=$x ] + ] + Where + OperatorExpr [ + Variable [ Name=$x ] + > + LiteralExpr [LONG] [10] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_empty_02/stddev_empty_02.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_empty_02/stddev_empty_02.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_empty_02/stddev_empty_02.3.ast index 6cb121c..ee7f74f 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_empty_02/stddev_empty_02.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_empty_02/stddev_empty_02.3.ast @@ -1,19 +1,50 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - FieldAccessor [ - Variable [ Name=$x ] - Field=val - ] - ] - FROM [ FunctionCall asterix.dataset@1[ - LiteralExpr [STRING] [test.Test] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=val + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Test] + ] + AS Variable [ Name=$x ] + ] + ) ] - AS Variable [ Name=$x ] - ] + ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=val + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Test] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_float/stddev_float.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_float/stddev_float.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_float/stddev_float.3.ast index 07e5c1a..679b6a5 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_float/stddev_float.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_float/stddev_float.3.ast @@ -1,24 +1,60 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - Variable [ Name=$x ] - ] - FROM [ OrderedListConstructor [ - FunctionCall test.float@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.float@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.float@1[ - LiteralExpr [STRING] [3] - ] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + ] + AS Variable [ Name=$x ] + ] + ) ] - AS Variable [ Name=$x ] - ] + ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_float_null/stddev_float_nu.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_float_null/stddev_float_nu.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_float_null/stddev_float_nu.3.ast index f78dba8..93e6093 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_float_null/stddev_float_nu.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_float_null/stddev_float_nu.3.ast @@ -20,4 +20,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=floatField + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_int16/stddev_int16.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_int16/stddev_int16.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_int16/stddev_int16.3.ast index 67d7880..00b7c98 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_int16/stddev_int16.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_int16/stddev_int16.3.ast @@ -1,24 +1,60 @@ DataverseUse test Query: -SELECT ELEMENT [ -FunctionCall asterix.stddev@1[ +RecordConstructor [ ( - SELECT ELEMENT [ - Variable [ Name=$x ] - ] - FROM [ OrderedListConstructor [ - FunctionCall test.int16@1[ - LiteralExpr [STRING] [1] - ] - FunctionCall test.int16@1[ - LiteralExpr [STRING] [2] - ] - FunctionCall test.int16@1[ - LiteralExpr [STRING] [3] - ] + LiteralExpr [STRING] [stddev] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + ] + AS Variable [ Name=$x ] + ] + ) ] - AS Variable [ Name=$x ] - ] + ] + ) + ) + ( + LiteralExpr [STRING] [stddev_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) ) -] ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/11d5b281/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_int16_null/stddev_int16_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_int16_null/stddev_int16_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_int16_null/stddev_int16_null.3.ast index 9f82ab2..bf1e0ad 100644 --- a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_int16_null/stddev_int16_null.3.ast +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/stddev_int16_null/stddev_int16_null.3.ast @@ -20,4 +20,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev_pop] + : + FunctionCall asterix.stddev_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=int16Field + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) ]
