http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var/scalar_var.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var/scalar_var.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var/scalar_var.3.ast new file mode 100644 index 0000000..71b0a16 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var/scalar_var.3.ast @@ -0,0 +1,222 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + ( + Let Variable [ Name=$i8 ] + := + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + FunctionCall test.int8@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i16 ] + := + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i32 ] + := + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + FunctionCall test.int32@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i64 ] + := + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + FunctionCall test.int64@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$f ] + := + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$d ] + := + FunctionCall asterix.sql-var@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] [var_pop] + : + ( + Let Variable [ Name=$i8 ] + := + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + FunctionCall test.int8@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i16 ] + := + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i32 ] + := + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + FunctionCall test.int32@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$i64 ] + := + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + FunctionCall test.int64@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$f ] + := + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + ] + ] + Let Variable [ Name=$d ] + := + FunctionCall asterix.sql-var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_empty/scalar_var_empty.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_empty/scalar_var_empty.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_empty/scalar_var_empty.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_empty/scalar_var_empty.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_empty/scalar_var_empty.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_empty/scalar_var_empty.3.ast new file mode 100644 index 0000000..a4126bb --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_empty/scalar_var_empty.3.ast @@ -0,0 +1,27 @@ +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + ] + ] + ] + ) + ) + ( + LiteralExpr [STRING] [var_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + ] + ] + ] + ) + ) +] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_null/scalar_var_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_null/scalar_var_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_null/scalar_var_null.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_null/scalar_var_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_null/scalar_var_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_null/scalar_var_null.3.ast new file mode 100644 index 0000000..22e3104 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var_null/scalar_var_null.3.ast @@ -0,0 +1,234 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + ( + Let Variable [ Name=$i8 ] + := + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + FunctionCall test.int8@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i16 ] + := + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i32 ] + := + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + FunctionCall test.int32@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i64 ] + := + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + FunctionCall test.int64@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$f ] + := + FunctionCall asterix.sql-var@1[ + OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$d ] + := + FunctionCall asterix.sql-var@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] [var_pop] + : + ( + Let Variable [ Name=$i8 ] + := + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + FunctionCall test.int8@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int8@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i16 ] + := + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + FunctionCall test.int16@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int16@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i32 ] + := + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + FunctionCall test.int32@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int32@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$i64 ] + := + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + FunctionCall test.int64@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.int64@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$f ] + := + FunctionCall asterix.sql-var_pop@1[ + OrderedListConstructor [ + FunctionCall test.float@1[ + LiteralExpr [STRING] [1] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [2] + ] + FunctionCall test.float@1[ + LiteralExpr [STRING] [3] + ] + LiteralExpr [NULL] + ] + ] + Let Variable [ Name=$d ] + := + FunctionCall asterix.sql-var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double/serial_var_double.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double/serial_var_double.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double/serial_var_double.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_var_double/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double/serial_var_double.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double/serial_var_double.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double/serial_var_double.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_var_double/serial_var_double.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double/serial_var_double.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double/serial_var_double.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double/serial_var_double.3.ast new file mode 100644 index 0000000..91b3b2f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double/serial_var_double.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double_null/serial_var_double_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double_null/serial_var_double_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double_null/serial_var_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-sql/serial_var_double_null/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double_null/serial_var_double_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double_null/serial_var_double_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double_null/serial_var_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-sql/serial_var_double_null/serial_var_double_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double_null/serial_var_double_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double_null/serial_var_double_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double_null/serial_var_double_null.3.ast new file mode 100644 index 0000000..a5e419b --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_double_null/serial_var_double_null.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_empty/serial_var_empty.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_empty/serial_var_empty.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_empty/serial_var_empty.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_var_empty/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_empty/serial_var_empty.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_empty/serial_var_empty.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_empty/serial_var_empty.3.ast new file mode 100644 index 0000000..91b3b2f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_empty/serial_var_empty.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_float.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_float.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_float.1.ast new file mode 100644 index 0000000..9af248f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_float.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_float.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_float.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_var_float/serial_var_float.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_float.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_float.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_float.3.ast new file mode 100644 index 0000000..91b3b2f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float/serial_var_float.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float_null/serial_var_float_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float_null/serial_var_float_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float_null/serial_var_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-sql/serial_var_float_null/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float_null/serial_var_float_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float_null/serial_var_float_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float_null/serial_var_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-sql/serial_var_float_null/serial_var_float_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float_null/serial_var_float_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float_null/serial_var_float_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float_null/serial_var_float_null.3.ast new file mode 100644 index 0000000..a5e419b --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_float_null/serial_var_float_null.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_int16.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_int16.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_int16.1.ast new file mode 100644 index 0000000..16d25a8 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_int16.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_int16.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_int16.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_var_int16/serial_var_int16.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_int16.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_int16.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_int16.3.ast new file mode 100644 index 0000000..91b3b2f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16/serial_var_int16.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16_null/serial_var_int16_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16_null/serial_var_int16_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16_null/serial_var_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-sql/serial_var_int16_null/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16_null/serial_var_int16_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16_null/serial_var_int16_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16_null/serial_var_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-sql/serial_var_int16_null/serial_var_int16_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16_null/serial_var_int16_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16_null/serial_var_int16_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16_null/serial_var_int16_null.3.ast new file mode 100644 index 0000000..a5e419b --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int16_null/serial_var_int16_null.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32/serial_var_int32.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32/serial_var_int32.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32/serial_var_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_var_int32/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32/serial_var_int32.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32/serial_var_int32.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32/serial_var_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_var_int32/serial_var_int32.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32/serial_var_int32.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32/serial_var_int32.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32/serial_var_int32.3.ast new file mode 100644 index 0000000..91b3b2f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32/serial_var_int32.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32_null/serial_var_int32_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32_null/serial_var_int32_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32_null/serial_var_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_var_int32_null/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32_null/serial_var_int32_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32_null/serial_var_int32_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32_null/serial_var_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_var_int32_null/serial_var_int32_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32_null/serial_var_int32_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32_null/serial_var_int32_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32_null/serial_var_int32_null.3.ast new file mode 100644 index 0000000..a5e419b --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int32_null/serial_var_int32_null.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64/serial_var_int64.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64/serial_var_int64.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64/serial_var_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_var_int64/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64/serial_var_int64.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64/serial_var_int64.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64/serial_var_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_var_int64/serial_var_int64.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64/serial_var_int64.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64/serial_var_int64.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64/serial_var_int64.3.ast new file mode 100644 index 0000000..91b3b2f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64/serial_var_int64.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64_null/serial_var_int64_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64_null/serial_var_int64_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64_null/serial_var_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_var_int64_null/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64_null/serial_var_int64_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64_null/serial_var_int64_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64_null/serial_var_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_var_int64_null/serial_var_int64_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64_null/serial_var_int64_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64_null/serial_var_int64_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64_null/serial_var_int64_null.3.ast new file mode 100644 index 0000000..a5e419b --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int64_null/serial_var_int64_null.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8/serial_var_int8.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8/serial_var_int8.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8/serial_var_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_var_int8/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8/serial_var_int8.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8/serial_var_int8.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8/serial_var_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_var_int8/serial_var_int8.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8/serial_var_int8.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8/serial_var_int8.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8/serial_var_int8.3.ast new file mode 100644 index 0000000..91b3b2f --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8/serial_var_int8.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=val + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8_null/serial_var_int8_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8_null/serial_var_int8_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8_null/serial_var_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_var_int8_null/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8_null/serial_var_int8_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8_null/serial_var_int8_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8_null/serial_var_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_var_int8_null/serial_var_int8_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8_null/serial_var_int8_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8_null/serial_var_int8_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8_null/serial_var_int8_null.3.ast new file mode 100644 index 0000000..a5e419b --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_int8_null/serial_var_int8_null.3.ast @@ -0,0 +1,57 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#2 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#2 ] + ] + ) +] +var +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + FieldAccessor [ + Variable [ Name=#3 ] + Field=t + ] + Field=valplus + ] + ] + FROM [ Variable [ Name=#1 ] + AS Variable [ Name=#3 ] + ] + ) +] +var_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=#1 ] + ( + t:=Variable [ Name=$t ] + ) + http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_mixed/serial_var_int64_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_mixed/serial_var_int64_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_mixed/serial_var_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_var_mixed/serial_var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_mixed/serial_var_int64_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_mixed/serial_var_int64_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_mixed/serial_var_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_var_mixed/serial_var_int64_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_mixed/serial_var_int64_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_mixed/serial_var_int64_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_mixed/serial_var_int64_null.3.ast new file mode 100644 index 0000000..5ed5c3a --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_mixed/serial_var_int64_null.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=valplus + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +var +] +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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.1.ast new file mode 100644 index 0000000..a61c9df --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.1.ast @@ -0,0 +1,9 @@ +DataverseUse test +TypeDecl TestType [ + open RecordType { + id : bigint, + gid : bigint, + val : double + } +] +DatasetDecl Test(TestType) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.2.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.2.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.2.ast new file mode 100644 index 0000000..916a59e --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.2.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.3.ast new file mode 100644 index 0000000..fff6e1a --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/serial_var_pop_mixed/serial_var_pop_int64_null.3.ast @@ -0,0 +1,40 @@ +DataverseUse test +Query: +SELECT [ +Variable [ Name=$gid ] +gid +FunctionCall asterix.sql-var_pop@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$g ] + Field=valplus + ] + ] + FROM [ Variable [ Name=$g ] + AS Variable [ Name=$g ] + ] + ) +] +var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double/var_double.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double/var_double.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double/var_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/var_double/var_double.1.ast @@ -0,0 +1 @@ +DataverseUse test http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double/var_double.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double/var_double.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double/var_double.3.ast new file mode 100644 index 0000000..9037555 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double/var_double.3.ast @@ -0,0 +1,51 @@ +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var@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 ] + ] + ) + ] + ] + ) + ) + ( + LiteralExpr [STRING] [var_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double_null/var_double_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double_null/var_double_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double_null/var_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/var_double_null/var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double_null/var_double_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double_null/var_double_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double_null/var_double_null.3.ast new file mode 100644 index 0000000..0060c07 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_double_null/var_double_null.3.ast @@ -0,0 +1,42 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=doubleField + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) + ( + LiteralExpr [STRING] [var_pop] + : + FunctionCall asterix.sql-var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_01/var_empty_01.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_01/var_empty_01.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_01/var_empty_01.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_01/var_empty_01.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_01/var_empty_01.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_01/var_empty_01.3.ast new file mode 100644 index 0000000..c724d18 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_01/var_empty_01.3.ast @@ -0,0 +1,60 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var@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] + ] + ) + ] + ] + ) + ) + ( + LiteralExpr [STRING] [var_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_02/var_empty_02.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_02/var_empty_02.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_02/var_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/var_empty_02/var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_02/var_empty_02.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_02/var_empty_02.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_02/var_empty_02.3.ast new file mode 100644 index 0000000..1705103 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_empty_02/var_empty_02.3.ast @@ -0,0 +1,50 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=val + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Test] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ] + ) + ) + ( + LiteralExpr [STRING] [var_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float/var_float.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float/var_float.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float/var_float.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float/var_float.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float/var_float.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float/var_float.3.ast new file mode 100644 index 0000000..592907d --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float/var_float.3.ast @@ -0,0 +1,60 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var@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 ] + ] + ) + ] + ] + ) + ) + ( + LiteralExpr [STRING] [var_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float_null/var_float_nu.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float_null/var_float_nu.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float_null/var_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/var_float_null/var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float_null/var_float_nu.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float_null/var_float_nu.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float_null/var_float_nu.3.ast new file mode 100644 index 0000000..0587de5 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_float_null/var_float_nu.3.ast @@ -0,0 +1,42 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=floatField + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) + ( + LiteralExpr [STRING] [var_pop] + : + FunctionCall asterix.sql-var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16/var_int16.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16/var_int16.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16/var_int16.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16/var_int16.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16/var_int16.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16/var_int16.3.ast new file mode 100644 index 0000000..f741ad6 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16/var_int16.3.ast @@ -0,0 +1,60 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var@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 ] + ] + ) + ] + ] + ) + ) + ( + LiteralExpr [STRING] [var_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16_null/var_int16_null.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16_null/var_int16_null.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16_null/var_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/var_int16_null/var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16_null/var_int16_null.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16_null/var_int16_null.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16_null/var_int16_null.3.ast new file mode 100644 index 0000000..1d41f05 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int16_null/var_int16_null.3.ast @@ -0,0 +1,42 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + FunctionCall asterix.sql-var@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=$x ] + Field=int16Field + ] + ] + FROM [ FunctionCall asterix.dataset@1[ + LiteralExpr [STRING] [test.Numeric] + ] + AS Variable [ Name=$x ] + ] + ) + ] + ) + ( + LiteralExpr [STRING] [var_pop] + : + FunctionCall asterix.sql-var_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/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int32/var_int32.1.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int32/var_int32.1.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int32/var_int32.1.ast new file mode 100644 index 0000000..e69de29 http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int32/var_int32.3.ast ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int32/var_int32.3.ast b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int32/var_int32.3.ast new file mode 100644 index 0000000..d7dd2a2 --- /dev/null +++ b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/var_int32/var_int32.3.ast @@ -0,0 +1,60 @@ +DataverseUse test +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [var] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var@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 ] + ] + ) + ] + ] + ) + ) + ( + LiteralExpr [STRING] [var_pop] + : + ( + SELECT ELEMENT [ + FunctionCall asterix.sql-var_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 ] + ] + ) + ] + ] + ) + ) +]
