You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by dl...@apache.org on 2018/10/25 21:32:10 UTC
[06/11] asterixdb git commit: [ASTERIXDB-2459][FUN] Add var() and
var_pop() aggregate function
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 ]
+ ]
+ )
+ ]
+ ]
+ )
+ )
+]