Added result file & edited tests
git-svn-id: https://asterixdb.googlecode.com/svn/branches/asterix_stabilization@774 eaa15691-b419-025a-1212-ee371bd00084
diff --git a/asterix-app/src/test/resources/runtimets/queries/flwor/grpby01.aql b/asterix-app/src/test/resources/runtimets/queries/flwor/grpby01.aql
index 252016f..8447914 100644
--- a/asterix-app/src/test/resources/runtimets/queries/flwor/grpby01.aql
+++ b/asterix-app/src/test/resources/runtimets/queries/flwor/grpby01.aql
@@ -4,6 +4,8 @@
* Date : 31st July 2012
*/
+write output to nc1:"rttest/flwor_grpby01.adm";
+
for $sales in [{"storeno":"S101","itemno":"P78395","qty":125},
{"storeno":"S101","itemno":"P71395","qty":135},
{"storeno":"S102","itemno":"P78395","qty":225},
diff --git a/asterix-app/src/test/resources/runtimets/queries/flwor/grpby02.aql b/asterix-app/src/test/resources/runtimets/queries/flwor/grpby02.aql
index 252016f..52f3001 100644
--- a/asterix-app/src/test/resources/runtimets/queries/flwor/grpby02.aql
+++ b/asterix-app/src/test/resources/runtimets/queries/flwor/grpby02.aql
@@ -4,6 +4,8 @@
* Date : 31st July 2012
*/
+write output to nc1:"rttest/flwor_grpby02.adm";
+
for $sales in [{"storeno":"S101","itemno":"P78395","qty":125},
{"storeno":"S101","itemno":"P71395","qty":135},
{"storeno":"S102","itemno":"P78395","qty":225},
@@ -11,5 +13,5 @@
{"storeno":"S104","itemno":"P71395","qty":115},
{"storeno":"S105","itemno":"P74395","qty":120}]
group by $strNum:=$sales.storeno with $sales
-order by $strNum desc
+order by $strNum asc
return {"store-number":$strNum,"total-qty":sum(for $l in $sales return $l.qty)}
diff --git a/asterix-app/src/test/resources/runtimets/results/flwor/grpby01.adm b/asterix-app/src/test/resources/runtimets/results/flwor/grpby01.adm
new file mode 100644
index 0000000..e0e860b
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/results/flwor/grpby01.adm
@@ -0,0 +1,5 @@
+{ "store-number": "S105", "total-qty": 120 }
+{ "store-number": "S104", "total-qty": 115 }
+{ "store-number": "S103", "total-qty": 105 }
+{ "store-number": "S102", "total-qty": 225 }
+{ "store-number": "S101", "total-qty": 260 }
diff --git a/asterix-app/src/test/resources/runtimets/results/flwor/grpby02.adm b/asterix-app/src/test/resources/runtimets/results/flwor/grpby02.adm
new file mode 100644
index 0000000..c70b4eb
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/results/flwor/grpby02.adm
@@ -0,0 +1,5 @@
+{ "store-number": "S101", "total-qty": 260 }
+{ "store-number": "S102", "total-qty": 225 }
+{ "store-number": "S103", "total-qty": 105 }
+{ "store-number": "S104", "total-qty": 115 }
+{ "store-number": "S105", "total-qty": 120 }