http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64/var_int64.3.query.sqlpp
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64/var_int64.3.query.sqlpp
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64/var_int64.3.query.sqlpp
new file mode 100644
index 0000000..082552a
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64/var_int64.3.query.sqlpp
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+{'var': (select element test.strict_var((
+    select element x
+    from  [test.bigint('1'),test.bigint('2'),test.bigint('3')] as x
+))), 'var_pop': (select element test.strict_var_pop((
+    select element x
+    from  [test.bigint('1'),test.bigint('2'),test.bigint('3')] as x
+)))};

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64_null/var_int64_null.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64_null/var_int64_null.1.ddl.sqlpp
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64_null/var_int64_null.1.ddl.sqlpp
new file mode 100644
index 0000000..3f2c5bf
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64_null/var_int64_null.1.ddl.sqlpp
@@ -0,0 +1,38 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+drop  dataverse test if exists;
+create  dataverse test;
+
+use test;
+
+
+create type test.NumericType as
+{
+  id : integer,
+  int8Field : tinyint?,
+  int16Field : smallint?,
+  int32Field : integer?,
+  int64Field : bigint?,
+  floatField : float?,
+  doubleField : double?
+};
+
+create external  dataset Numeric(NumericType) using 
localfs((`path`=`asterix_nc1://data/nontagged/numericData.json`),(`format`=`adm`));
+

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64_null/var_int64_null.3.query.sqlpp
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64_null/var_int64_null.3.query.sqlpp
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64_null/var_int64_null.3.query.sqlpp
new file mode 100644
index 0000000..0d988c6
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int64_null/var_int64_null.3.query.sqlpp
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+{'var':test.strict_var((
+    select element x.int64Field
+    from  Numeric as x
+)), 'var_pop':test.strict_var_pop((
+    select element x.int64Field
+    from  Numeric as x
+))};

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8/var_int8.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8/var_int8.1.ddl.sqlpp
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8/var_int8.1.ddl.sqlpp
new file mode 100644
index 0000000..21479a2
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8/var_int8.1.ddl.sqlpp
@@ -0,0 +1,22 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+drop  dataverse test if exists;
+create  dataverse test;
+

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8/var_int8.3.query.sqlpp
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8/var_int8.3.query.sqlpp
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8/var_int8.3.query.sqlpp
new file mode 100644
index 0000000..6965f4e
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8/var_int8.3.query.sqlpp
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+{'var': (select element test.strict_var((
+    select element x
+    from  [test.tinyint('1'),test.tinyint('2'),test.tinyint('3')] as x
+))), 'var_pop': (select element test.strict_var_pop((
+    select element x
+    from  [test.tinyint('1'),test.tinyint('2'),test.tinyint('3')] as x
+)))};

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8_null/var_int8_null.1.ddl.sqlpp
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8_null/var_int8_null.1.ddl.sqlpp
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8_null/var_int8_null.1.ddl.sqlpp
new file mode 100644
index 0000000..3f2c5bf
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8_null/var_int8_null.1.ddl.sqlpp
@@ -0,0 +1,38 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+drop  dataverse test if exists;
+create  dataverse test;
+
+use test;
+
+
+create type test.NumericType as
+{
+  id : integer,
+  int8Field : tinyint?,
+  int16Field : smallint?,
+  int32Field : integer?,
+  int64Field : bigint?,
+  floatField : float?,
+  doubleField : double?
+};
+
+create external  dataset Numeric(NumericType) using 
localfs((`path`=`asterix_nc1://data/nontagged/numericData.json`),(`format`=`adm`));
+

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8_null/var_int8_null.3.query.sqlpp
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8_null/var_int8_null.3.query.sqlpp
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8_null/var_int8_null.3.query.sqlpp
new file mode 100644
index 0000000..d661a87
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_int8_null/var_int8_null.3.query.sqlpp
@@ -0,0 +1,29 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test;
+
+
+{'var':test.strict_var((
+    select element x.int8Field
+    from  Numeric as x
+)), 'var_pop':test.strict_var_pop((
+    select element x.int8Field
+    from  Numeric as x
+))};

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_mixed/var_mixed.3.query.sqlpp
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_mixed/var_mixed.3.query.sqlpp
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_mixed/var_mixed.3.query.sqlpp
new file mode 100644
index 0000000..761a4d2
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_mixed/var_mixed.3.query.sqlpp
@@ -0,0 +1,28 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Run var over an multiset with mixed types
+* Expected Res : Failure
+* Date         : March 5th 2018
+*/
+
+select element strict_var((
+    select element x
+    from  [float('2.0'),'hello world',93847382783847382,date('2013-01-01')] as 
x
+));

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_pop_mixed/var_pop_mixed.3.query.sqlpp
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_pop_mixed/var_pop_mixed.3.query.sqlpp
 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_pop_mixed/var_pop_mixed.3.query.sqlpp
new file mode 100644
index 0000000..9169d41
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/aggregate/var_pop_mixed/var_pop_mixed.3.query.sqlpp
@@ -0,0 +1,28 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+/*
+* Description  : Run var_pop over an multiset with mixed types
+* Expected Res : Failure
+* Date         : Jun 2nd 2013
+*/
+
+select element strict_var_pop((
+    select element x
+    from  [float('2.0'),'hello world',93847382783847382,date('2013-01-01')] as 
x
+));

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null/agg_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null/agg_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null/agg_null.1.adm
index a8c918b..f99998e 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null/agg_null.1.adm
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null/agg_null.1.adm
@@ -1 +1 @@
-{ "sql-count1": 0, "average1": null, "sql-sum1": null, "sql-min1": null, 
"sql-max1": null, "sql-stddev1": null, "sql-stddev_pop1": null, "sql-count2": 
0, "average2": null, "sql-sum2": null, "sql-min2": null, "sql-max2": null, 
"sql-stddev2": null, "sql-stddev_pop2": null }
+{ "sql-count1": 0, "average1": null, "sql-sum1": null, "sql-min1": null, 
"sql-max1": null, "sql-stddev1": null, "sql-stddev_pop1": null, "sql-var1": 
null, "sql-var_pop1": null, "sql-count2": 0, "average2": null, "sql-sum2": 
null, "sql-min2": null, "sql-max2": null, "sql-stddev2": null, 
"sql-stddev_pop2": null, "sql-var2": null, "sql-var_pop2": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null_rec/agg_null_rec.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null_rec/agg_null_rec.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null_rec/agg_null_rec.1.adm
index 99d052a..7041077 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null_rec/agg_null_rec.1.adm
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null_rec/agg_null_rec.1.adm
@@ -1 +1 @@
-{ "sql-count": 2, "average": 26.0, "sql-stddev": 7.0710678118654755, 
"sql-stddev_pop": 5.0, "sql-sum": 52, "sql-min": 21, "sql-max": 31 }
+{ "sql-count": 2, "average": 26.0, "sql-stddev": 7.0710678118654755, 
"sql-stddev_pop": 5.0, "sql-var": 50.0, "sql-var_pop": 25.0, "sql-sum": 52, 
"sql-min": 21, "sql-max": 31 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null_rec_1/agg_null_rec.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null_rec_1/agg_null_rec.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null_rec_1/agg_null_rec.1.adm
index 988d2e4..d0fa295 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null_rec_1/agg_null_rec.1.adm
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_null_rec_1/agg_null_rec.1.adm
@@ -1 +1 @@
-{ "sql-count": 3, "average": 5.32, "sql-sum": 15.96, "sql-stddev": 
2.720510431232472E16, "sql-stddev_pop": 1.9236913742132196E16, "sql-min": 
473847, "sql-max": 38473827484738239 }
+{ "sql-count": 3, "average": 5.32, "sql-sum": 15.96, "sql-stddev": 
2.720510431232472E16, "sql-stddev_pop": 1.9236913742132196E16, "sql-var": 
7.40117700644469E32, "sql-var_pop": 3.700588503222345E32, "sql-min": 473847, 
"sql-max": 38473827484738239 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_number/agg_number.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_number/agg_number.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_number/agg_number.1.adm
index 37f109c..08843c5 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_number/agg_number.1.adm
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_number/agg_number.1.adm
@@ -1 +1 @@
-{ "sql-count1": 4, "average1": 2.3461845695961844E16, "sql-stddev1": 
4.6923691391923688E16, "sql-stddev_pop1": 4.0637108784747104E16, "sql-count2": 
4, "average2": 2.3461845695961844E16, "sql-stddev2": 4.6923691391923688E16, 
"sql-stddev_pop2": 4.0637108784747104E16, "sql-sum1": 9.3847382783847376E16, 
"sql-min1": 1.0, "sql-max1": 9.3847382783847376E16, "sql-sum2": 
9.3847382783847376E16, "sql-min2": 1.0, "sql-max2": 9.3847382783847376E16 }
+{ "sql-count1": 4, "average1": 2.3461845695961844E16, "sql-stddev1": 
4.6923691391923688E16, "sql-stddev_pop1": 4.0637108784747104E16, "sql-var1": 
2.2018328138444933E33, "sql-var_pop1": 1.65137461038337E33, "sql-count2": 4, 
"average2": 2.3461845695961844E16, "sql-stddev2": 4.6923691391923688E16, 
"sql-stddev_pop2": 4.0637108784747104E16, "sql-var2": 2.2018328138444933E33, 
"sql-var_pop2": 1.65137461038337E33, "sql-sum1": 9.3847382783847376E16, 
"sql-min1": 1.0, "sql-max1": 9.3847382783847376E16, "sql-sum2": 
9.3847382783847376E16, "sql-min2": 1.0, "sql-max2": 9.3847382783847376E16 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_number_rec/agg_number_rec.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_number_rec/agg_number_rec.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_number_rec/agg_number_rec.1.adm
index 19f61fd..0a8fb2f 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_number_rec/agg_number_rec.1.adm
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/agg_number_rec/agg_number_rec.1.adm
@@ -1 +1 @@
-{ "sql-count": 3, "average": 1.2824609161579424E16, "sql-stddev": 
2.2212874655068836E16, "sql-stddev_pop": 1.8136736208439848E16, "sql-sum": 
3.8473827484738272E16, "sql-min": 2.0, "sql-max": 3.847382748473824E16 }
+{ "sql-count": 3, "average": 1.2824609161579424E16, "sql-stddev": 
2.2212874655068836E16, "sql-stddev_pop": 1.8136736208439848E16, "sql-var": 
4.934118004417994E32, "sql-var_pop": 3.28941200294533E32, "sql-sum": 
3.8473827484738272E16, "sql-min": 2.0, "sql-max": 3.847382748473824E16 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var/scalar_var.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var/scalar_var.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var/scalar_var.1.adm
new file mode 100644
index 0000000..8b66369
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var/scalar_var.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0, 1.0, 1.0, 1.0, 1.0, 1.0 ], "var_pop": [ 0.6666666666666666, 
0.6666666666666666, 0.6666666666666666, 0.6666666666666666, 0.6666666666666666, 
0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var_empty/scalar_var_empty.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var_empty/scalar_var_empty.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var_empty/scalar_var_empty.1.adm
new file mode 100644
index 0000000..abf4b45
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var_empty/scalar_var_empty.1.adm
@@ -0,0 +1 @@
+{ "var": [ null ], "var_pop": [ null ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var_null/scalar_var_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var_null/scalar_var_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var_null/scalar_var_null.1.adm
new file mode 100644
index 0000000..8b66369
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/scalar_var_null/scalar_var_null.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0, 1.0, 1.0, 1.0, 1.0, 1.0 ], "var_pop": [ 0.6666666666666666, 
0.6666666666666666, 0.6666666666666666, 0.6666666666666666, 0.6666666666666666, 
0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_double/serial_var_double.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_double/serial_var_double.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_double/serial_var_double.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_double/serial_var_double.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_double_null/serial_var_double_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_double_null/serial_var_double_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_double_null/serial_var_double_null.1.adm
new file mode 100644
index 0000000..1d1b2a6
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_double_null/serial_var_double_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 4.934118004270163E32, "var_pop": 3.289412002846775E32 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_empty/serial_var_empty.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_empty/serial_var_empty.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_empty/serial_var_empty.1.adm
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/aggregate-sql/serial_var_float/serial_var_float.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_float/serial_var_float.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_float/serial_var_float.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_float/serial_var_float.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_float_null/serial_var_float_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_float_null/serial_var_float_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_float_null/serial_var_float_null.1.adm
new file mode 100644
index 0000000..2335482
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_float_null/serial_var_float_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 1.0, "var_pop": 0.6666666666666666 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int16/serial_var_int16.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int16/serial_var_int16.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int16/serial_var_int16.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int16/serial_var_int16.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int16_null/serial_var_int16_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int16_null/serial_var_int16_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int16_null/serial_var_int16_null.1.adm
new file mode 100644
index 0000000..2335482
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int16_null/serial_var_int16_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 1.0, "var_pop": 0.6666666666666666 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int32/serial_var_int32.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int32/serial_var_int32.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int32/serial_var_int32.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int32/serial_var_int32.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int32_null/serial_var_int32_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int32_null/serial_var_int32_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int32_null/serial_var_int32_null.1.adm
new file mode 100644
index 0000000..2335482
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int32_null/serial_var_int32_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 1.0, "var_pop": 0.6666666666666666 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int64/serial_var_int64.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int64/serial_var_int64.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int64/serial_var_int64.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int64/serial_var_int64.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int64_null/serial_var_int64_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int64_null/serial_var_int64_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int64_null/serial_var_int64_null.1.adm
new file mode 100644
index 0000000..2335482
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int64_null/serial_var_int64_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 1.0, "var_pop": 0.6666666666666666 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int8/serial_var_int8.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int8/serial_var_int8.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int8/serial_var_int8.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int8/serial_var_int8.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int8_null/serial_var_int8_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int8_null/serial_var_int8_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int8_null/serial_var_int8_null.1.adm
new file mode 100644
index 0000000..2335482
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_int8_null/serial_var_int8_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 1.0, "var_pop": 0.6666666666666666 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_mixed/serial_var_mixed.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_mixed/serial_var_mixed.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_mixed/serial_var_mixed.1.adm
new file mode 100644
index 0000000..e3b97f5
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_mixed/serial_var_mixed.1.adm
@@ -0,0 +1 @@
+[  ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_pop_mixed/serial_var_pop_mixed.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_pop_mixed/serial_var_pop_mixed.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_pop_mixed/serial_var_pop_mixed.1.adm
new file mode 100644
index 0000000..e3b97f5
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/serial_var_pop_mixed/serial_var_pop_mixed.1.adm
@@ -0,0 +1 @@
+[  ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_distinct/var_distinct.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_distinct/var_distinct.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_distinct/var_distinct.1.adm
new file mode 100644
index 0000000..f2ed238
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_distinct/var_distinct.1.adm
@@ -0,0 +1 @@
+{ "t1": 100, "t2": null, "t3": 50, "t4": null, "t5": 66, "t6": null, "t7": 25, 
"t8": null }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_double/var_double.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_double/var_double.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_double/var_double.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_double/var_double.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_double_null/var_double_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_double_null/var_double_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_double_null/var_double_null.1.adm
new file mode 100644
index 0000000..99c6acf
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_double_null/var_double_null.1.adm
@@ -0,0 +1 @@
+{ "var": 0.0, "var_pop": 0.0 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_empty_01/var_empty_01.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_empty_01/var_empty_01.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_empty_01/var_empty_01.1.adm
new file mode 100644
index 0000000..abf4b45
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_empty_01/var_empty_01.1.adm
@@ -0,0 +1 @@
+{ "var": [ null ], "var_pop": [ null ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_empty_02/var_empty_02.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_empty_02/var_empty_02.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_empty_02/var_empty_02.1.adm
new file mode 100644
index 0000000..abf4b45
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_empty_02/var_empty_02.1.adm
@@ -0,0 +1 @@
+{ "var": [ null ], "var_pop": [ null ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_float/var_float.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_float/var_float.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_float/var_float.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_float/var_float.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_float_null/var_float_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_float_null/var_float_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_float_null/var_float_null.1.adm
new file mode 100644
index 0000000..99c6acf
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_float_null/var_float_null.1.adm
@@ -0,0 +1 @@
+{ "var": 0.0, "var_pop": 0.0 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int16/var_int16.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int16/var_int16.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int16/var_int16.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int16/var_int16.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int16_null/var_int16_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int16_null/var_int16_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int16_null/var_int16_null.1.adm
new file mode 100644
index 0000000..99c6acf
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int16_null/var_int16_null.1.adm
@@ -0,0 +1 @@
+{ "var": 0.0, "var_pop": 0.0 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int32/var_int32.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int32/var_int32.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int32/var_int32.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int32/var_int32.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int32_null/var_int32_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int32_null/var_int32_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int32_null/var_int32_null.1.adm
new file mode 100644
index 0000000..99c6acf
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int32_null/var_int32_null.1.adm
@@ -0,0 +1 @@
+{ "var": 0.0, "var_pop": 0.0 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int64/var_int64.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int64/var_int64.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int64/var_int64.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int64/var_int64.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int64_null/var_int64_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int64_null/var_int64_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int64_null/var_int64_null.1.adm
new file mode 100644
index 0000000..99c6acf
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int64_null/var_int64_null.1.adm
@@ -0,0 +1 @@
+{ "var": 0.0, "var_pop": 0.0 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int8/var_int8.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int8/var_int8.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int8/var_int8.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int8/var_int8.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int8_null/var_int8_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int8_null/var_int8_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int8_null/var_int8_null.1.adm
new file mode 100644
index 0000000..f02f9f2
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_int8_null/var_int8_null.1.adm
@@ -0,0 +1 @@
+{ "var": 676.0, "var_pop": 450.6666666666667 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_mixed/var_mixed.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_mixed/var_mixed.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_mixed/var_mixed.1.adm
new file mode 100644
index 0000000..e3b97f5
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_mixed/var_mixed.1.adm
@@ -0,0 +1 @@
+[  ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_pop_mixed/var_pop_mixed.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_pop_mixed/var_pop_mixed.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_pop_mixed/var_pop_mixed.1.adm
new file mode 100644
index 0000000..e3b97f5
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate-sql/var_pop_mixed/var_pop_mixed.1.adm
@@ -0,0 +1 @@
+[  ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null/agg_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null/agg_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null/agg_null.1.adm
index 78a89a3..8977277 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null/agg_null.1.adm
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null/agg_null.1.adm
@@ -1 +1 @@
-{ "count1": 1, "average1": null, "sum1": null, "min1": null, "max1": null, 
"stddev1": null, "stddev_pop1": null, "count2": 2, "average2": null, "sum2": 
null, "min2": null, "max2": null, "stddev2": null, "stddev_pop2": null }
+{ "count1": 1, "average1": null, "sum1": null, "min1": null, "max1": null, 
"stddev1": null, "stddev_pop1": null, "var1": null, "var_pop1": null, "count2": 
2, "average2": null, "sum2": null, "min2": null, "max2": null, "stddev2": null, 
"stddev_pop2": null, "var2": null, "var_pop2": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec/agg_null_rec.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec/agg_null_rec.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec/agg_null_rec.1.adm
index 054e601..d38c950 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec/agg_null_rec.1.adm
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec/agg_null_rec.1.adm
@@ -1 +1 @@
-{ "count": 3, "average": null, "stddev": null, "stddev_pop": null, "sum": 
null, "min": null, "max": null }
+{ "count": 3, "average": null, "stddev": null, "stddev_pop": null, "var": 
null, "var_pop": null, "sum": null, "min": null, "max": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec_1/agg_null_rec.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec_1/agg_null_rec.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec_1/agg_null_rec.1.adm
index 4be73ca..1127706 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec_1/agg_null_rec.1.adm
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_null_rec_1/agg_null_rec.1.adm
@@ -1 +1 @@
-{ "count": 3, "average": 5.32, "sum": 15.96, "stddev": 1.0, "stddev_pop": 
0.816496580927726, "min": null, "max": null }
+{ "count": 3, "average": 5.32, "sum": 15.96, "stddev": 1.0, "stddev_pop": 
0.816496580927726, "var": 1.0, "var_pop": 0.6666666666666666, "min": null, 
"max": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number/agg_number.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number/agg_number.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number/agg_number.1.adm
index d6c4363..760b06c 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number/agg_number.1.adm
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number/agg_number.1.adm
@@ -1 +1 @@
-{ "count1": 4, "average1": 2.3461845695961844E16, "stddev1": 
4.6923691391923688E16, "stddev_pop1": 4.0637108784747104E16, "count2": 4, 
"average2": 2.3461845695961844E16, "stddev2": 4.6923691391923688E16, 
"stddev_pop2": 4.0637108784747104E16, "sum1": 9.3847382783847376E16, "min1": 
1.0, "max1": 9.3847382783847376E16, "sum2": 9.3847382783847376E16, "min2": 1.0, 
"max2": 9.3847382783847376E16 }
+{ "count1": 4, "average1": 2.3461845695961844E16, "stddev1": 
4.6923691391923688E16, "stddev_pop1": 4.0637108784747104E16, "var1": 
2.2018328138444933E33, "var_pop1": 1.65137461038337E33, "count2": 4, 
"average2": 2.3461845695961844E16, "stddev2": 4.6923691391923688E16, 
"stddev_pop2": 4.0637108784747104E16, "var2": 2.2018328138444933E33, 
"var_pop2": 1.65137461038337E33, "sum1": 9.3847382783847376E16, "min1": 1.0, 
"max1": 9.3847382783847376E16, "sum2": 9.3847382783847376E16, "min2": 1.0, 
"max2": 9.3847382783847376E16 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number_rec/agg_number_rec.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number_rec/agg_number_rec.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number_rec/agg_number_rec.1.adm
index 633b714..525ae14 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number_rec/agg_number_rec.1.adm
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/agg_number_rec/agg_number_rec.1.adm
@@ -1 +1 @@
-{ "count": 3, "average": 1.2824609161579424E16, "stddev": 
2.2212874655068836E16, "stddev_pop": 1.8136736208439848E16, "sum": 
3.8473827484738272E16, "min": 2.0, "max": 3.847382748473824E16 }
+{ "count": 3, "average": 1.2824609161579424E16, "stddev": 
2.2212874655068836E16, "stddev_pop": 1.8136736208439848E16, "var": 
4.934118004417994E32, "var_pop": 3.28941200294533E32, "sum": 
3.8473827484738272E16, "min": 2.0, "max": 3.847382748473824E16 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var/scalar_var.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var/scalar_var.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var/scalar_var.1.adm
new file mode 100644
index 0000000..8b66369
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var/scalar_var.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0, 1.0, 1.0, 1.0, 1.0, 1.0 ], "var_pop": [ 0.6666666666666666, 
0.6666666666666666, 0.6666666666666666, 0.6666666666666666, 0.6666666666666666, 
0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var_empty/scalar_var_empty.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var_empty/scalar_var_empty.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var_empty/scalar_var_empty.1.adm
new file mode 100644
index 0000000..abf4b45
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var_empty/scalar_var_empty.1.adm
@@ -0,0 +1 @@
+{ "var": [ null ], "var_pop": [ null ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var_null/scalar_var_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var_null/scalar_var_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var_null/scalar_var_null.1.adm
new file mode 100644
index 0000000..8bb7869
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/scalar_var_null/scalar_var_null.1.adm
@@ -0,0 +1 @@
+{ "var": [ null, null, null, null, null, null ], "var_pop": [ null, null, 
null, null, null, null ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_double/serial_var_double.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_double/serial_var_double.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_double/serial_var_double.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_double/serial_var_double.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_double_null/serial_var_double_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_double_null/serial_var_double_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_double_null/serial_var_double_null.1.adm
new file mode 100644
index 0000000..6341e9f
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_double_null/serial_var_double_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_empty/serial_var_empty.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_empty/serial_var_empty.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_empty/serial_var_empty.1.adm
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/aggregate/serial_var_float/serial_var_float.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_float/serial_var_float.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_float/serial_var_float.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_float/serial_var_float.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_float_null/serial_var_float_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_float_null/serial_var_float_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_float_null/serial_var_float_null.1.adm
new file mode 100644
index 0000000..6341e9f
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_float_null/serial_var_float_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int16/serial_var_int16.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int16/serial_var_int16.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int16/serial_var_int16.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int16/serial_var_int16.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int16_null/serial_var_int16_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int16_null/serial_var_int16_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int16_null/serial_var_int16_null.1.adm
new file mode 100644
index 0000000..6341e9f
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int16_null/serial_var_int16_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int32/serial_var_int32.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int32/serial_var_int32.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int32/serial_var_int32.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int32/serial_var_int32.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int32_null/serial_var_int32_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int32_null/serial_var_int32_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int32_null/serial_var_int32_null.1.adm
new file mode 100644
index 0000000..6341e9f
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int32_null/serial_var_int32_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int64/serial_var_int64.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int64/serial_var_int64.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int64/serial_var_int64.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int64/serial_var_int64.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int64_null/serial_var_int64_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int64_null/serial_var_int64_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int64_null/serial_var_int64_null.1.adm
new file mode 100644
index 0000000..6341e9f
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int64_null/serial_var_int64_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int8/serial_var_int8.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int8/serial_var_int8.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int8/serial_var_int8.1.adm
new file mode 100644
index 0000000..b2f05cb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int8/serial_var_int8.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": 0.8, "var_pop": 0.64 }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int8_null/serial_var_int8_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int8_null/serial_var_int8_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int8_null/serial_var_int8_null.1.adm
new file mode 100644
index 0000000..6341e9f
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_int8_null/serial_var_int8_null.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_mixed/serial_var_mixed.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_mixed/serial_var_mixed.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_mixed/serial_var_mixed.1.adm
new file mode 100644
index 0000000..ae7dd85
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_mixed/serial_var_mixed.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_pop_mixed/serial_var_pop_mixed.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_pop_mixed/serial_var_pop_mixed.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_pop_mixed/serial_var_pop_mixed.1.adm
new file mode 100644
index 0000000..be46433
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/serial_var_pop_mixed/serial_var_pop_mixed.1.adm
@@ -0,0 +1 @@
+{ "gid": 1, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_distinct/var_distinct.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_distinct/var_distinct.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_distinct/var_distinct.1.adm
new file mode 100644
index 0000000..886e024
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_distinct/var_distinct.1.adm
@@ -0,0 +1 @@
+{ "t1": 100, "t2": null, "t3": null, "t4": null, "t5": 66, "t6": null, "t7": 
null, "t8": null }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_double/var_double.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_double/var_double.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_double/var_double.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_double/var_double.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_double_null/var_double_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_double_null/var_double_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_double_null/var_double_null.1.adm
new file mode 100644
index 0000000..0a34eda
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_double_null/var_double_null.1.adm
@@ -0,0 +1 @@
+{ "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_empty_01/var_empty_01.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_empty_01/var_empty_01.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_empty_01/var_empty_01.1.adm
new file mode 100644
index 0000000..abf4b45
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_empty_01/var_empty_01.1.adm
@@ -0,0 +1 @@
+{ "var": [ null ], "var_pop": [ null ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_empty_02/var_empty_02.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_empty_02/var_empty_02.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_empty_02/var_empty_02.1.adm
new file mode 100644
index 0000000..abf4b45
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_empty_02/var_empty_02.1.adm
@@ -0,0 +1 @@
+{ "var": [ null ], "var_pop": [ null ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_float/var_float.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_float/var_float.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_float/var_float.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_float/var_float.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_float_null/var_float_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_float_null/var_float_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_float_null/var_float_null.1.adm
new file mode 100644
index 0000000..0a34eda
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_float_null/var_float_null.1.adm
@@ -0,0 +1 @@
+{ "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int16/var_int16.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int16/var_int16.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int16/var_int16.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int16/var_int16.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int16_null/var_int16_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int16_null/var_int16_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int16_null/var_int16_null.1.adm
new file mode 100644
index 0000000..0a34eda
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int16_null/var_int16_null.1.adm
@@ -0,0 +1 @@
+{ "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int32/var_int32.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int32/var_int32.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int32/var_int32.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int32/var_int32.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int32_null/var_int32_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int32_null/var_int32_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int32_null/var_int32_null.1.adm
new file mode 100644
index 0000000..0a34eda
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int32_null/var_int32_null.1.adm
@@ -0,0 +1 @@
+{ "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int64/var_int64.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int64/var_int64.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int64/var_int64.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int64/var_int64.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int64_null/var_int64_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int64_null/var_int64_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int64_null/var_int64_null.1.adm
new file mode 100644
index 0000000..0a34eda
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int64_null/var_int64_null.1.adm
@@ -0,0 +1 @@
+{ "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int8/var_int8.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int8/var_int8.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int8/var_int8.1.adm
new file mode 100644
index 0000000..b6c4979
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int8/var_int8.1.adm
@@ -0,0 +1 @@
+{ "var": [ 1.0 ], "var_pop": [ 0.6666666666666666 ] }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int8_null/var_int8_null.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int8_null/var_int8_null.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int8_null/var_int8_null.1.adm
new file mode 100644
index 0000000..0a34eda
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_int8_null/var_int8_null.1.adm
@@ -0,0 +1 @@
+{ "var": null, "var_pop": null }

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_mixed/var_mixed.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_mixed/var_mixed.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_mixed/var_mixed.1.adm
new file mode 100644
index 0000000..e3b97f5
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_mixed/var_mixed.1.adm
@@ -0,0 +1 @@
+[  ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_pop_mixed/var_pop_mixed.1.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_pop_mixed/var_pop_mixed.1.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_pop_mixed/var_pop_mixed.1.adm
new file mode 100644
index 0000000..e3b97f5
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/aggregate/var_pop_mixed/var_pop_mixed.1.adm
@@ -0,0 +1 @@
+[  ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null/agg_null.3.ast
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null/agg_null.3.ast
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null/agg_null.3.ast
index 0e8f3ea..f370f90 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null/agg_null.3.ast
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null/agg_null.3.ast
@@ -64,6 +64,24 @@ RecordConstructor [
     ]
   )
   (
+    LiteralExpr [STRING] [sql-var1]
+    :
+    FunctionCall asterix.sql-var@1[
+      OrderedListConstructor [
+        LiteralExpr [NULL]
+      ]
+    ]
+  )
+  (
+    LiteralExpr [STRING] [sql-var_pop1]
+    :
+    FunctionCall asterix.sql-var_pop@1[
+      OrderedListConstructor [
+        LiteralExpr [NULL]
+      ]
+    ]
+  )
+  (
     LiteralExpr [STRING] [sql-count2]
     :
     FunctionCall asterix.sql-count@1[
@@ -133,4 +151,24 @@ RecordConstructor [
       ]
     ]
   )
+  (
+    LiteralExpr [STRING] [sql-var2]
+    :
+    FunctionCall asterix.sql-var@1[
+      UnorderedListConstructor [
+        LiteralExpr [NULL]
+        LiteralExpr [NULL]
+      ]
+    ]
+  )
+  (
+    LiteralExpr [STRING] [sql-var_pop2]
+    :
+    FunctionCall asterix.sql-var_pop@1[
+      UnorderedListConstructor [
+        LiteralExpr [NULL]
+        LiteralExpr [NULL]
+      ]
+    ]
+  )
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.ast
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.ast
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.ast
index 96cbb48..110949e 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.ast
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec/agg_null_rec.3.ast
@@ -134,4 +134,42 @@ RecordConstructor [
       )
     ]
   )
+  (
+    LiteralExpr [STRING] [sql-var]
+    :
+    FunctionCall asterix.sql-var@1[
+      (
+        SELECT ELEMENT [
+        FieldAccessor [
+          Variable [ Name=$t ]
+          Field=valplus
+        ]
+        ]
+        FROM [          FunctionCall asterix.dataset@1[
+            LiteralExpr [STRING] [test.Test]
+          ]
+          AS Variable [ Name=$t ]
+        ]
+      )
+    ]
+  )
+  (
+    LiteralExpr [STRING] [sql-var_pop]
+    :
+    FunctionCall asterix.sql-var_pop@1[
+      (
+        SELECT ELEMENT [
+        FieldAccessor [
+          Variable [ Name=$t ]
+          Field=valplus
+        ]
+        ]
+        FROM [          FunctionCall asterix.dataset@1[
+            LiteralExpr [STRING] [test.Test]
+          ]
+          AS Variable [ Name=$t ]
+        ]
+      )
+    ]
+  )
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.ast
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.ast
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.ast
index c411817..f10192b 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.ast
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_null_rec_1/agg_null_rec_1.3.ast
@@ -173,4 +173,56 @@ RecordConstructor [
       )
     ]
   )
+  (
+    LiteralExpr [STRING] [sql-var]
+    :
+    FunctionCall asterix.sql-var@1[
+      (
+        SELECT ELEMENT [
+        FieldAccessor [
+          Variable [ Name=$i ]
+          Field=valplus
+        ]
+        ]
+        FROM [          (
+            SELECT ELEMENT [
+            Variable [ Name=$t ]
+            ]
+            FROM [              FunctionCall asterix.dataset@1[
+                LiteralExpr [STRING] [test.Test]
+              ]
+              AS Variable [ Name=$t ]
+            ]
+          )
+          AS Variable [ Name=$i ]
+        ]
+      )
+    ]
+  )
+  (
+    LiteralExpr [STRING] [sql-var_pop]
+    :
+    FunctionCall asterix.sql-var_pop@1[
+      (
+        SELECT ELEMENT [
+        FieldAccessor [
+          Variable [ Name=$i ]
+          Field=valplus
+        ]
+        ]
+        FROM [          (
+            SELECT ELEMENT [
+            Variable [ Name=$t ]
+            ]
+            FROM [              FunctionCall asterix.dataset@1[
+                LiteralExpr [STRING] [test.Test]
+              ]
+              AS Variable [ Name=$t ]
+            ]
+          )
+          AS Variable [ Name=$i ]
+        ]
+      )
+    ]
+  )
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number/agg_number.3.ast
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number/agg_number.3.ast
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number/agg_number.3.ast
index cbaebaa..bcc764d 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number/agg_number.3.ast
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number/agg_number.3.ast
@@ -113,6 +113,38 @@ RecordConstructor [
     ]
   )
   (
+    LiteralExpr [STRING] [sql-var1]
+    :
+    FunctionCall asterix.sql-var@1[
+      OrderedListConstructor [
+        FunctionCall null.float@1[
+          LiteralExpr [STRING] [2.0]
+        ]
+        FunctionCall null.double@1[
+          LiteralExpr [STRING] [3.0]
+        ]
+        LiteralExpr [LONG] [93847382783847382]
+        LiteralExpr [LONG] [1]
+      ]
+    ]
+  )
+  (
+    LiteralExpr [STRING] [sql-var_pop1]
+    :
+    FunctionCall asterix.sql-var_pop@1[
+      OrderedListConstructor [
+        FunctionCall null.float@1[
+          LiteralExpr [STRING] [2.0]
+        ]
+        FunctionCall null.double@1[
+          LiteralExpr [STRING] [3.0]
+        ]
+        LiteralExpr [LONG] [93847382783847382]
+        LiteralExpr [LONG] [1]
+      ]
+    ]
+  )
+  (
     LiteralExpr [STRING] [sql-count2]
     :
     FunctionCall asterix.sql-count@1[
@@ -224,4 +256,36 @@ RecordConstructor [
       ]
     ]
   )
+  (
+    LiteralExpr [STRING] [sql-var2]
+    :
+    FunctionCall asterix.sql-var@1[
+      UnorderedListConstructor [
+        FunctionCall null.float@1[
+          LiteralExpr [STRING] [2.0]
+        ]
+        FunctionCall null.double@1[
+          LiteralExpr [STRING] [3.0]
+        ]
+        LiteralExpr [LONG] [93847382783847382]
+        LiteralExpr [LONG] [1]
+      ]
+    ]
+  )
+  (
+    LiteralExpr [STRING] [sql-var_pop2]
+    :
+    FunctionCall asterix.sql-var_pop@1[
+      UnorderedListConstructor [
+        FunctionCall null.float@1[
+          LiteralExpr [STRING] [2.0]
+        ]
+        FunctionCall null.double@1[
+          LiteralExpr [STRING] [3.0]
+        ]
+        LiteralExpr [LONG] [93847382783847382]
+        LiteralExpr [LONG] [1]
+      ]
+    ]
+  )
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.ast
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.ast
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.ast
index 96cbb48..110949e 100644
--- 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.ast
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/agg_number_rec/agg_number_rec.3.ast
@@ -134,4 +134,42 @@ RecordConstructor [
       )
     ]
   )
+  (
+    LiteralExpr [STRING] [sql-var]
+    :
+    FunctionCall asterix.sql-var@1[
+      (
+        SELECT ELEMENT [
+        FieldAccessor [
+          Variable [ Name=$t ]
+          Field=valplus
+        ]
+        ]
+        FROM [          FunctionCall asterix.dataset@1[
+            LiteralExpr [STRING] [test.Test]
+          ]
+          AS Variable [ Name=$t ]
+        ]
+      )
+    ]
+  )
+  (
+    LiteralExpr [STRING] [sql-var_pop]
+    :
+    FunctionCall asterix.sql-var_pop@1[
+      (
+        SELECT ELEMENT [
+        FieldAccessor [
+          Variable [ Name=$t ]
+          Field=valplus
+        ]
+        ]
+        FROM [          FunctionCall asterix.dataset@1[
+            LiteralExpr [STRING] [test.Test]
+          ]
+          AS Variable [ Name=$t ]
+        ]
+      )
+    ]
+  )
 ]

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/2a42da45/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var/scalar_var.1.ast
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var/scalar_var.1.ast
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/aggregate-sql/scalar_var/scalar_var.1.ast
new file mode 100644
index 0000000..e69de29

Reply via email to