http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.1.ast new file mode 100644 index 0000000..6eaf31a --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : integer + } +] +DatasetDecl Test(TestType) partitioned by [[id]]
http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.2.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.ast new file mode 100644 index 0000000..3bd59ff --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32/serial_stddev_int32.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +stddev +] +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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.1.ast new file mode 100644 index 0000000..6eaf31a --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : integer + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.2.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.ast new file mode 100644 index 0000000..8dae584 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int32_null/serial_stddev_int32_null.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +stddev +] +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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.1.ast new file mode 100644 index 0000000..7911712 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : bigint + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.2.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.ast new file mode 100644 index 0000000..3bd59ff --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64/serial_stddev_int64.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +stddev +] +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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.1.ast new file mode 100644 index 0000000..7911712 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : bigint + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.2.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.ast new file mode 100644 index 0000000..8dae584 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int64_null/serial_stddev_int64_null.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +stddev +] +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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.1.ast new file mode 100644 index 0000000..44c9cde --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : tinyint + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.2.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.ast new file mode 100644 index 0000000..3bd59ff --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8/serial_stddev_int8.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +stddev +] +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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.1.ast new file mode 100644 index 0000000..44c9cde --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : tinyint + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.2.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.ast new file mode 100644 index 0000000..8dae584 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_int8_null/serial_stddev_int8_null.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +stddev +] +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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.1.ast new file mode 100644 index 0000000..a61c9df --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : double + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.2.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.3.ast new file mode 100644 index 0000000..8a897bc --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_stddev_mixed/serial_stddev_int64_null.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=valplus + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +stddev +] +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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.1.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.1.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.3.ast new file mode 100644 index 0000000..c0e7dac --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double/stddev_double.3.ast @@ -0,0 +1,19 @@ +Query: +SELECT ELEMENT [ +FunctionCall asterix.sql-stddev@1[ + ( + SELECT ELEMENT [ + Variable [ Name=$x ] + ] + FROM [ OrderedListConstructor [ + LiteralExpr [DOUBLE] [1.0] + LiteralExpr [DOUBLE] [2.0] + FunctionCall null.double@1[ + LiteralExpr [STRING] [3.0] + ] + ] + AS Variable [ Name=$x ] + ] + ) +] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.1.ast new file mode 100644 index 0000000..2b387f8 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.1.ast @@ -0,0 +1,13 @@ +DataverseUse test +TypeDecl NumericType [ + open RecordType { + id : integer, + int8Field : tinyint?, + int16Field : smallint?, + int32Field : integer?, + int64Field : bigint?, + floatField : float?, + doubleField : double? + } +] +DatasetDecl Numeric(NumericType)is an external dataset http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..e01f5cc --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_double_null/stddev_double_null.3.ast @@ -0,0 +1,23 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [stddev] + : + FunctionCall asterix.sql-stddev@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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..f85f450 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_01/stddev_empty_01.3.ast @@ -0,0 +1,24 @@ +DataverseUse test +Query: +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] + ] + ) +] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.1.ast new file mode 100644 index 0000000..baf977e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.1.ast @@ -0,0 +1,8 @@ +DataverseUse test +TypeDecl TestType [ + closed RecordType { + id : bigint, + val : double + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..1e74018 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_empty_02/stddev_empty_02.3.ast @@ -0,0 +1,19 @@ +DataverseUse test +Query: +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 ] + ] + ) +] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float/stddev_float.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float/stddev_float.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float/stddev_float.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..139a799 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float/stddev_float.3.ast @@ -0,0 +1,24 @@ +DataverseUse test +Query: +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 ] + ] + ) +] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.1.ast new file mode 100644 index 0000000..b01283e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.1.ast @@ -0,0 +1,13 @@ +DataverseUse test +TypeDecl NumericType [ + open RecordType { + id : bigint, + int8Field : tinyint?, + int16Field : smallint?, + int32Field : integer?, + int64Field : bigint?, + floatField : float?, + doubleField : double? + } +] +DatasetDecl Numeric(NumericType)is an external dataset http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..2fd1ef4 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_float_null/stddev_float_nu.3.ast @@ -0,0 +1,23 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [stddev] + : + FunctionCall asterix.sql-stddev@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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16/stddev_int16.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16/stddev_int16.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16/stddev_int16.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..e1d4be2 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16/stddev_int16.3.ast @@ -0,0 +1,24 @@ +DataverseUse test +Query: +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 ] + ] + ) +] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.1.ast new file mode 100644 index 0000000..b01283e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.1.ast @@ -0,0 +1,13 @@ +DataverseUse test +TypeDecl NumericType [ + open RecordType { + id : bigint, + int8Field : tinyint?, + int16Field : smallint?, + int32Field : integer?, + int64Field : bigint?, + floatField : float?, + doubleField : double? + } +] +DatasetDecl Numeric(NumericType)is an external dataset http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..ee1fdc7 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int16_null/stddev_int16_null.3.ast @@ -0,0 +1,23 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [stddev] + : + FunctionCall asterix.sql-stddev@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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32/stddev_int32.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32/stddev_int32.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32/stddev_int32.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..d40a004 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32/stddev_int32.3.ast @@ -0,0 +1,24 @@ +DataverseUse test +Query: +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 ] + ] + ) +] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.1.ast new file mode 100644 index 0000000..b01283e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.1.ast @@ -0,0 +1,13 @@ +DataverseUse test +TypeDecl NumericType [ + open RecordType { + id : bigint, + int8Field : tinyint?, + int16Field : smallint?, + int32Field : integer?, + int64Field : bigint?, + floatField : float?, + doubleField : double? + } +] +DatasetDecl Numeric(NumericType)is an external dataset http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..55da89c --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int32_null/stddev_int32_null.3.ast @@ -0,0 +1,23 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [stddev] + : + FunctionCall asterix.sql-stddev@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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64/stddev_int64.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64/stddev_int64.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64/stddev_int64.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..0583b7f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64/stddev_int64.3.ast @@ -0,0 +1,24 @@ +DataverseUse test +Query: +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 ] + ] + ) +] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.1.ast new file mode 100644 index 0000000..b01283e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.1.ast @@ -0,0 +1,13 @@ +DataverseUse test +TypeDecl NumericType [ + open RecordType { + id : bigint, + int8Field : tinyint?, + int16Field : smallint?, + int32Field : integer?, + int64Field : bigint?, + floatField : float?, + doubleField : double? + } +] +DatasetDecl Numeric(NumericType)is an external dataset http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..e8787dd --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int64_null/stddev_int64_null.3.ast @@ -0,0 +1,23 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [stddev] + : + FunctionCall asterix.sql-stddev@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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8/stddev_int8.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8/stddev_int8.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8/stddev_int8.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..2ec6818 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8/stddev_int8.3.ast @@ -0,0 +1,24 @@ +DataverseUse test +Query: +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 ] + ] + ) +] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.1.ast new file mode 100644 index 0000000..b01283e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.1.ast @@ -0,0 +1,13 @@ +DataverseUse test +TypeDecl NumericType [ + open RecordType { + id : bigint, + int8Field : tinyint?, + int16Field : smallint?, + int32Field : integer?, + int64Field : bigint?, + floatField : float?, + doubleField : double? + } +] +DatasetDecl Numeric(NumericType)is an external dataset http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..a7c371c --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_int8_null/stddev_int8_null.3.ast @@ -0,0 +1,23 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [stddev] + : + FunctionCall asterix.sql-stddev@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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_mixed/stddev_mixed.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_mixed/stddev_mixed.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_mixed/stddev_mixed.3.ast new file mode 100644 index 0000000..14781dd --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/stddev_mixed/stddev_mixed.3.ast @@ -0,0 +1,22 @@ +Query: +SELECT ELEMENT [ +FunctionCall asterix.sql-stddev@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/ab4bed0c/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 d5ab72c..42aab0a 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 @@ -46,6 +46,15 @@ RecordConstructor [ ] ) ( + LiteralExpr [STRING] [stddev1] + : + FunctionCall asterix.stddev@1[ + OrderedListConstructor [ + LiteralExpr [NULL] + ] + ] + ) + ( LiteralExpr [STRING] [count2] : FunctionCall asterix.count@1[ @@ -95,4 +104,14 @@ RecordConstructor [ ] ] ) + ( + LiteralExpr [STRING] [stddev2] + : + FunctionCall asterix.stddev@1[ + UnorderedListConstructor [ + LiteralExpr [NULL] + LiteralExpr [NULL] + ] + ] + ) ] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 f2fe7a8..ea96a9a 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 @@ -96,4 +96,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev] + : + FunctionCall asterix.stddev@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/ab4bed0c/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 f7d2b25..5668cdb 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 @@ -121,4 +121,31 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev] + : + FunctionCall asterix.stddev@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/ab4bed0c/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 7a0b73c..c3f8e5b 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 @@ -81,6 +81,22 @@ RecordConstructor [ ] ) ( + LiteralExpr [STRING] [stddev1] + : + FunctionCall asterix.stddev@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[ @@ -160,4 +176,20 @@ RecordConstructor [ ] ] ) + ( + LiteralExpr [STRING] [stddev2] + : + FunctionCall asterix.stddev@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/ab4bed0c/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 f2fe7a8..ea96a9a 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 @@ -96,4 +96,23 @@ RecordConstructor [ ) ] ) + ( + LiteralExpr [STRING] [stddev] + : + FunctionCall asterix.stddev@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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev/scalar_stddev.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev/scalar_stddev.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev/scalar_stddev.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..67d038e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev/scalar_stddev.3.ast @@ -0,0 +1,105 @@ +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 ] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_empty/scalar_stddev_empty.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_empty/scalar_stddev_empty.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_empty/scalar_stddev_empty.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..9834bb3 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_empty/scalar_stddev_empty.3.ast @@ -0,0 +1,7 @@ +Query: +SELECT ELEMENT [ +FunctionCall asterix.stddev@1[ + OrderedListConstructor [ + ] +] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_null/scalar_stddev_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_null/scalar_stddev_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_null/scalar_stddev_null.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..eac0b48 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/scalar_stddev_null/scalar_stddev_null.3.ast @@ -0,0 +1,111 @@ +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 ] +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.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_double/serial_stddev_double.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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.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_double/serial_stddev_double.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..43263e5 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double/serial_stddev_double.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +stddev +] +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 ] + ( + val:=FunctionCall asterix.field-access-by-name@2[ + Variable [ Name=$t ] + LiteralExpr [STRING] [val] +] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.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_double_null/serial_stddev_double_null.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : double + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.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_double_null/serial_stddev_double_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..f05d552 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_double_null/serial_stddev_double_null.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=valplus + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +stddev +] +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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_empty/serial_stddev_empty.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_empty/serial_stddev_empty.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_empty/serial_stddev_empty.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_empty/serial_stddev_empty.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/ab4bed0c/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 new file mode 100644 index 0000000..43263e5 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_empty/serial_stddev_empty.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +stddev +] +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 ] + ( + val:=FunctionCall asterix.field-access-by-name@2[ + Variable [ Name=$t ] + LiteralExpr [STRING] [val] +] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.1.ast new file mode 100644 index 0000000..9af248f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : float + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.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_float/serial_stddev_float.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..43263e5 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float/serial_stddev_float.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +stddev +] +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 ] + ( + val:=FunctionCall asterix.field-access-by-name@2[ + Variable [ Name=$t ] + LiteralExpr [STRING] [val] +] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.1.ast new file mode 100644 index 0000000..9af248f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : float + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.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_float_null/serial_stddev_float_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..f05d552 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_float_null/serial_stddev_float_null.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=valplus + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +stddev +] +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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.1.ast new file mode 100644 index 0000000..16d25a8 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : smallint + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.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_int16/serial_stddev_int16.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..43263e5 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16/serial_stddev_int16.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=val + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +stddev +] +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 ] + ( + val:=FunctionCall asterix.field-access-by-name@2[ + Variable [ Name=$t ] + LiteralExpr [STRING] [val] +] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.1.ast new file mode 100644 index 0000000..16d25a8 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : smallint + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.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_int16_null/serial_stddev_int16_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/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 new file mode 100644 index 0000000..f05d552 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int16_null/serial_stddev_int16_null.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.stddev@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=valplus + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +stddev +] +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/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.1.ast new file mode 100644 index 0000000..6eaf31a --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : integer + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/ab4bed0c/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate/serial_stddev_int32/serial_stddev_int32.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_int32/serial_stddev_int32.2.ast @@ -0,0 +1 @@ +DataverseUse test
