http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.114.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.114.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.114.adm
new file mode 100644
index 0000000..b8fe968
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.114.adm
@@ -0,0 +1,10 @@
+{ "id": 10, "f_timetz": time("20:00:00.000Z"), "first_value": 10, 
"last_value": 8 }
+{ "id": 9, "f_timetz": time("19:00:00.000Z"), "first_value": 10, "last_value": 
7 }
+{ "id": 8, "f_timetz": time("18:00:00.000Z"), "first_value": 9, "last_value": 
6 }
+{ "id": 7, "f_timetz": time("17:00:00.000Z"), "first_value": 8, "last_value": 
5 }
+{ "id": 6, "f_timetz": time("16:00:00.000Z"), "first_value": 7, "last_value": 
4 }
+{ "id": 5, "f_timetz": time("15:00:00.000Z"), "first_value": 6, "last_value": 
3 }
+{ "id": 4, "f_timetz": time("14:00:00.000Z"), "first_value": 5, "last_value": 
2 }
+{ "id": 3, "f_timetz": time("13:00:00.000Z"), "first_value": 4, "last_value": 
1 }
+{ "id": 2, "f_timetz": time("12:00:00.000Z"), "first_value": 3, "last_value": 
1 }
+{ "id": 1, "f_timetz": time("11:00:00.000Z"), "first_value": 2, "last_value": 
1 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.115.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.115.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.115.adm
new file mode 100644
index 0000000..1e26eb8
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.115.adm
@@ -0,0 +1,10 @@
+{ "id": 1, "f_timestamptz": datetime("2000-10-19T10:23:54.000Z"), 
"first_value": 1, "last_value": 2 }
+{ "id": 2, "f_timestamptz": datetime("2001-10-19T10:23:54.000Z"), 
"first_value": 1, "last_value": 3 }
+{ "id": 3, "f_timestamptz": datetime("2002-10-19T10:23:54.000Z"), 
"first_value": 2, "last_value": 4 }
+{ "id": 4, "f_timestamptz": datetime("2003-10-19T10:23:54.000Z"), 
"first_value": 3, "last_value": 5 }
+{ "id": 5, "f_timestamptz": datetime("2004-10-19T10:23:54.000Z"), 
"first_value": 4, "last_value": 6 }
+{ "id": 6, "f_timestamptz": datetime("2005-10-19T10:23:54.000Z"), 
"first_value": 5, "last_value": 7 }
+{ "id": 7, "f_timestamptz": datetime("2006-10-19T10:23:54.000Z"), 
"first_value": 6, "last_value": 8 }
+{ "id": 8, "f_timestamptz": datetime("2007-10-19T10:23:54.000Z"), 
"first_value": 7, "last_value": 9 }
+{ "id": 9, "f_timestamptz": datetime("2008-10-19T10:23:54.000Z"), 
"first_value": 8, "last_value": 10 }
+{ "id": 10, "f_timestamptz": datetime("2009-10-19T10:23:54.000Z"), 
"first_value": 9, "last_value": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.116.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.116.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.116.adm
new file mode 100644
index 0000000..ae6f718
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.116.adm
@@ -0,0 +1,10 @@
+{ "id": 10, "f_timestamptz": datetime("2009-10-19T10:23:54.000Z"), 
"first_value": 10, "last_value": 9 }
+{ "id": 9, "f_timestamptz": datetime("2008-10-19T10:23:54.000Z"), 
"first_value": 10, "last_value": 8 }
+{ "id": 8, "f_timestamptz": datetime("2007-10-19T10:23:54.000Z"), 
"first_value": 9, "last_value": 7 }
+{ "id": 7, "f_timestamptz": datetime("2006-10-19T10:23:54.000Z"), 
"first_value": 8, "last_value": 6 }
+{ "id": 6, "f_timestamptz": datetime("2005-10-19T10:23:54.000Z"), 
"first_value": 7, "last_value": 5 }
+{ "id": 5, "f_timestamptz": datetime("2004-10-19T10:23:54.000Z"), 
"first_value": 6, "last_value": 4 }
+{ "id": 4, "f_timestamptz": datetime("2003-10-19T10:23:54.000Z"), 
"first_value": 5, "last_value": 3 }
+{ "id": 3, "f_timestamptz": datetime("2002-10-19T10:23:54.000Z"), 
"first_value": 4, "last_value": 2 }
+{ "id": 2, "f_timestamptz": datetime("2001-10-19T10:23:54.000Z"), 
"first_value": 3, "last_value": 1 }
+{ "id": 1, "f_timestamptz": datetime("2000-10-19T10:23:54.000Z"), 
"first_value": 2, "last_value": 1 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.117.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.117.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.117.adm
new file mode 100644
index 0000000..d7680f3
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.117.adm
@@ -0,0 +1,20 @@
+{ "four": 0, "ten": 0, "sum": 0, "avg": 0.0 }
+{ "four": 0, "ten": 2, "sum": 0, "avg": 2.0 }
+{ "four": 0, "ten": 4, "sum": 0, "avg": 4.0 }
+{ "four": 0, "ten": 6, "sum": 0, "avg": 6.0 }
+{ "four": 0, "ten": 8, "sum": 0, "avg": 8.0 }
+{ "four": 1, "ten": 1, "sum": 2500, "avg": 1.0 }
+{ "four": 1, "ten": 3, "sum": 2500, "avg": 3.0 }
+{ "four": 1, "ten": 5, "sum": 2500, "avg": 5.0 }
+{ "four": 1, "ten": 7, "sum": 2500, "avg": 7.0 }
+{ "four": 1, "ten": 9, "sum": 2500, "avg": 9.0 }
+{ "four": 2, "ten": 0, "sum": 5000, "avg": 0.0 }
+{ "four": 2, "ten": 2, "sum": 5000, "avg": 2.0 }
+{ "four": 2, "ten": 4, "sum": 5000, "avg": 4.0 }
+{ "four": 2, "ten": 6, "sum": 5000, "avg": 6.0 }
+{ "four": 2, "ten": 8, "sum": 5000, "avg": 8.0 }
+{ "four": 3, "ten": 1, "sum": 7500, "avg": 1.0 }
+{ "four": 3, "ten": 3, "sum": 7500, "avg": 3.0 }
+{ "four": 3, "ten": 5, "sum": 7500, "avg": 5.0 }
+{ "four": 3, "ten": 7, "sum": 7500, "avg": 7.0 }
+{ "four": 3, "ten": 9, "sum": 7500, "avg": 9.0 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.118.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.118.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.118.adm
new file mode 100644
index 0000000..642ecf2
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.118.adm
@@ -0,0 +1,10 @@
+{ "ten": 0, "two": 0, "gsum": 45000, "wsum": 45000 }
+{ "ten": 2, "two": 0, "gsum": 47000, "wsum": 92000 }
+{ "ten": 4, "two": 0, "gsum": 49000, "wsum": 141000 }
+{ "ten": 6, "two": 0, "gsum": 51000, "wsum": 192000 }
+{ "ten": 8, "two": 0, "gsum": 53000, "wsum": 245000 }
+{ "ten": 1, "two": 1, "gsum": 46000, "wsum": 46000 }
+{ "ten": 3, "two": 1, "gsum": 48000, "wsum": 94000 }
+{ "ten": 5, "two": 1, "gsum": 50000, "wsum": 144000 }
+{ "ten": 7, "two": 1, "gsum": 52000, "wsum": 196000 }
+{ "ten": 9, "two": 1, "gsum": 54000, "wsum": 250000 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.119.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.119.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.119.adm
new file mode 100644
index 0000000..b279aa9
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.119.adm
@@ -0,0 +1,3 @@
+{ "sum": 14600, "row_number": 3, "sum_sum": 14600 }
+{ "sum": 7400, "row_number": 2, "sum_sum": 22000 }
+{ "sum": 25100, "row_number": 1, "sum_sum": 47100 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.12.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.12.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.12.adm
new file mode 100644
index 0000000..f88fb69
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.12.adm
@@ -0,0 +1,2 @@
+{ "ntile": null, "ten": 0, "four": 0 }
+{ "ntile": null, "ten": 0, "four": 0 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.13.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.13.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.13.adm
new file mode 100644
index 0000000..92efd54
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.13.adm
@@ -0,0 +1,6 @@
+{ "count": 4, "four": 1 }
+{ "count": 4, "four": 1 }
+{ "count": 4, "four": 1 }
+{ "count": 4, "four": 1 }
+{ "count": 2, "four": 3 }
+{ "count": 2, "four": 3 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.14.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.14.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.14.adm
new file mode 100644
index 0000000..2b5481b
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.14.adm
@@ -0,0 +1,10 @@
+{ "cntsum": 22 }
+{ "cntsum": 22 }
+{ "cntsum": 24 }
+{ "cntsum": 24 }
+{ "cntsum": 51 }
+{ "cntsum": 82 }
+{ "cntsum": 87 }
+{ "cntsum": 92 }
+{ "cntsum": 92 }
+{ "cntsum": 136 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.15.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.15.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.15.adm
new file mode 100644
index 0000000..f30fb49
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.15.adm
@@ -0,0 +1,10 @@
+{ "avg": 0.0 }
+{ "avg": 0.0 }
+{ "avg": 0.0 }
+{ "avg": 1.0 }
+{ "avg": 1.0 }
+{ "avg": 1.0 }
+{ "avg": 1.0 }
+{ "avg": 2.0 }
+{ "avg": 3.0 }
+{ "avg": 3.0 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.16.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.16.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.16.adm
new file mode 100644
index 0000000..bacb60c
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.16.adm
@@ -0,0 +1 @@
+{ "cnt": 0 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.17.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.17.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.17.adm
new file mode 100644
index 0000000..95536c1
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.17.adm
@@ -0,0 +1,10 @@
+{ "empno": 1, "depname": "sales", "salary": 5000, "bonus": 1000, "depadj": 
200, "min": 1000, "max": 200 }
+{ "empno": 2, "depname": "personnel", "salary": 3900, "bonus": 1000, "depadj": 
200, "min": 1000, "max": 200 }
+{ "empno": 3, "depname": "sales", "salary": 4800, "bonus": 500, "depadj": 
null, "min": 500, "max": 200 }
+{ "empno": 4, "depname": "sales", "salary": 4800, "bonus": 500, "depadj": 
null, "min": 500, "max": 200 }
+{ "empno": 5, "depname": "personnel", "salary": 3500, "bonus": 500, "depadj": 
null, "min": 500, "max": 200 }
+{ "empno": 7, "depname": "develop", "salary": 4200, "bonus": null, "depadj": 
null, "min": 500, "max": 200 }
+{ "empno": 8, "depname": "develop", "salary": 6000, "bonus": 1000, "depadj": 
200, "min": 500, "max": 200 }
+{ "empno": 9, "depname": "develop", "salary": 4500, "bonus": null, "depadj": 
null, "min": 500, "max": 200 }
+{ "empno": 10, "depname": "develop", "salary": 5200, "bonus": 500, "depadj": 
200, "min": 500, "max": 200 }
+{ "empno": 11, "depname": "develop", "salary": 5200, "bonus": 500, "depadj": 
200, "min": 500, "max": 200 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.18.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.18.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.18.adm
new file mode 100644
index 0000000..fc832de
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.18.adm
@@ -0,0 +1,10 @@
+{ "ten": 0, "res": 9976146, "rank": 4 }
+{ "ten": 1, "res": 10114187, "rank": 9 }
+{ "ten": 2, "res": 10059554, "rank": 8 }
+{ "ten": 3, "res": 9878541, "rank": 1 }
+{ "ten": 4, "res": 9881005, "rank": 2 }
+{ "ten": 5, "res": 9981670, "rank": 5 }
+{ "ten": 6, "res": 9947099, "rank": 3 }
+{ "ten": 7, "res": 10120309, "rank": 10 }
+{ "ten": 8, "res": 9991305, "rank": 6 }
+{ "ten": 9, "res": 10040184, "rank": 7 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.19.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.19.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.19.adm
new file mode 100644
index 0000000..28eff74
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.19.adm
@@ -0,0 +1,20 @@
+{ "four": 0, "ten": 0, "sum": 0, "last_value": 0 }
+{ "four": 0, "ten": 2, "sum": 2, "last_value": 2 }
+{ "four": 0, "ten": 4, "sum": 6, "last_value": 4 }
+{ "four": 0, "ten": 6, "sum": 12, "last_value": 6 }
+{ "four": 0, "ten": 8, "sum": 20, "last_value": 8 }
+{ "four": 1, "ten": 1, "sum": 1, "last_value": 1 }
+{ "four": 1, "ten": 3, "sum": 4, "last_value": 3 }
+{ "four": 1, "ten": 5, "sum": 9, "last_value": 5 }
+{ "four": 1, "ten": 7, "sum": 16, "last_value": 7 }
+{ "four": 1, "ten": 9, "sum": 25, "last_value": 9 }
+{ "four": 2, "ten": 0, "sum": 0, "last_value": 0 }
+{ "four": 2, "ten": 2, "sum": 2, "last_value": 2 }
+{ "four": 2, "ten": 4, "sum": 6, "last_value": 4 }
+{ "four": 2, "ten": 6, "sum": 12, "last_value": 6 }
+{ "four": 2, "ten": 8, "sum": 20, "last_value": 8 }
+{ "four": 3, "ten": 1, "sum": 1, "last_value": 1 }
+{ "four": 3, "ten": 3, "sum": 4, "last_value": 3 }
+{ "four": 3, "ten": 5, "sum": 9, "last_value": 5 }
+{ "four": 3, "ten": 7, "sum": 16, "last_value": 7 }
+{ "four": 3, "ten": 9, "sum": 25, "last_value": 9 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.20.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.20.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.20.adm
new file mode 100644
index 0000000..28eff74
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.20.adm
@@ -0,0 +1,20 @@
+{ "four": 0, "ten": 0, "sum": 0, "last_value": 0 }
+{ "four": 0, "ten": 2, "sum": 2, "last_value": 2 }
+{ "four": 0, "ten": 4, "sum": 6, "last_value": 4 }
+{ "four": 0, "ten": 6, "sum": 12, "last_value": 6 }
+{ "four": 0, "ten": 8, "sum": 20, "last_value": 8 }
+{ "four": 1, "ten": 1, "sum": 1, "last_value": 1 }
+{ "four": 1, "ten": 3, "sum": 4, "last_value": 3 }
+{ "four": 1, "ten": 5, "sum": 9, "last_value": 5 }
+{ "four": 1, "ten": 7, "sum": 16, "last_value": 7 }
+{ "four": 1, "ten": 9, "sum": 25, "last_value": 9 }
+{ "four": 2, "ten": 0, "sum": 0, "last_value": 0 }
+{ "four": 2, "ten": 2, "sum": 2, "last_value": 2 }
+{ "four": 2, "ten": 4, "sum": 6, "last_value": 4 }
+{ "four": 2, "ten": 6, "sum": 12, "last_value": 6 }
+{ "four": 2, "ten": 8, "sum": 20, "last_value": 8 }
+{ "four": 3, "ten": 1, "sum": 1, "last_value": 1 }
+{ "four": 3, "ten": 3, "sum": 4, "last_value": 3 }
+{ "four": 3, "ten": 5, "sum": 9, "last_value": 5 }
+{ "four": 3, "ten": 7, "sum": 16, "last_value": 7 }
+{ "four": 3, "ten": 9, "sum": 25, "last_value": 9 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.21.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.21.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.21.adm
new file mode 100644
index 0000000..97f0a4f
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.21.adm
@@ -0,0 +1,20 @@
+{ "four": 0, "ten": 0, "sum": 20, "last_value": 8 }
+{ "four": 0, "ten": 2, "sum": 20, "last_value": 8 }
+{ "four": 0, "ten": 4, "sum": 20, "last_value": 8 }
+{ "four": 0, "ten": 6, "sum": 20, "last_value": 8 }
+{ "four": 0, "ten": 8, "sum": 20, "last_value": 8 }
+{ "four": 1, "ten": 1, "sum": 25, "last_value": 9 }
+{ "four": 1, "ten": 3, "sum": 25, "last_value": 9 }
+{ "four": 1, "ten": 5, "sum": 25, "last_value": 9 }
+{ "four": 1, "ten": 7, "sum": 25, "last_value": 9 }
+{ "four": 1, "ten": 9, "sum": 25, "last_value": 9 }
+{ "four": 2, "ten": 0, "sum": 20, "last_value": 8 }
+{ "four": 2, "ten": 2, "sum": 20, "last_value": 8 }
+{ "four": 2, "ten": 4, "sum": 20, "last_value": 8 }
+{ "four": 2, "ten": 6, "sum": 20, "last_value": 8 }
+{ "four": 2, "ten": 8, "sum": 20, "last_value": 8 }
+{ "four": 3, "ten": 1, "sum": 25, "last_value": 9 }
+{ "four": 3, "ten": 3, "sum": 25, "last_value": 9 }
+{ "four": 3, "ten": 5, "sum": 25, "last_value": 9 }
+{ "four": 3, "ten": 7, "sum": 25, "last_value": 9 }
+{ "four": 3, "ten": 9, "sum": 25, "last_value": 9 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.22.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.22.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.22.adm
new file mode 100644
index 0000000..7709a85
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.22.adm
@@ -0,0 +1,20 @@
+{ "four": 0, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 0, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 0, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 0, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 0, "two": 2, "sum": 4, "last_value": 2 }
+{ "four": 1, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 1, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 1, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 1, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 1, "two": 2, "sum": 4, "last_value": 2 }
+{ "four": 2, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 2, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 2, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 2, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 2, "two": 2, "sum": 4, "last_value": 2 }
+{ "four": 3, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 3, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 3, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 3, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 3, "two": 2, "sum": 4, "last_value": 2 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.23.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.23.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.23.adm
new file mode 100644
index 0000000..25038e6
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.23.adm
@@ -0,0 +1,20 @@
+{ "four": 0, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 0, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 0, "two": 1, "sum": 1, "last_value": 1 }
+{ "four": 0, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 0, "two": 2, "sum": 4, "last_value": 2 }
+{ "four": 1, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 1, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 1, "two": 1, "sum": 1, "last_value": 1 }
+{ "four": 1, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 1, "two": 2, "sum": 4, "last_value": 2 }
+{ "four": 2, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 2, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 2, "two": 1, "sum": 1, "last_value": 1 }
+{ "four": 2, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 2, "two": 2, "sum": 4, "last_value": 2 }
+{ "four": 3, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 3, "two": 0, "sum": 0, "last_value": 0 }
+{ "four": 3, "two": 1, "sum": 1, "last_value": 1 }
+{ "four": 3, "two": 1, "sum": 2, "last_value": 1 }
+{ "four": 3, "two": 2, "sum": 4, "last_value": 2 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.24.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.24.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.24.adm
new file mode 100644
index 0000000..e6f27b1
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.24.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 45 }
+{ "unique1": 4, "four": 0, "sum": 45 }
+{ "unique1": 8, "four": 0, "sum": 45 }
+{ "unique1": 1, "four": 1, "sum": 33 }
+{ "unique1": 5, "four": 1, "sum": 33 }
+{ "unique1": 9, "four": 1, "sum": 33 }
+{ "unique1": 2, "four": 2, "sum": 18 }
+{ "unique1": 6, "four": 2, "sum": 18 }
+{ "unique1": 3, "four": 3, "sum": 10 }
+{ "unique1": 7, "four": 3, "sum": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.25.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.25.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.25.adm
new file mode 100644
index 0000000..a3634c5
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.25.adm
@@ -0,0 +1,10 @@
+{ "unique1": 4, "four": 0, "sum": 45 }
+{ "unique1": 2, "four": 2, "sum": 41 }
+{ "unique1": 1, "four": 1, "sum": 39 }
+{ "unique1": 6, "four": 2, "sum": 38 }
+{ "unique1": 9, "four": 1, "sum": 32 }
+{ "unique1": 8, "four": 0, "sum": 23 }
+{ "unique1": 5, "four": 1, "sum": 15 }
+{ "unique1": 3, "four": 3, "sum": 10 }
+{ "unique1": 7, "four": 3, "sum": 7 }
+{ "unique1": 0, "four": 0, "sum": 0 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.26.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.26.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.26.adm
new file mode 100644
index 0000000..329ea42
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.26.adm
@@ -0,0 +1,10 @@
+{ "unique1": 4, "four": 0, "sum": 7 }
+{ "unique1": 2, "four": 2, "sum": 13 }
+{ "unique1": 1, "four": 1, "sum": 22 }
+{ "unique1": 6, "four": 2, "sum": 26 }
+{ "unique1": 9, "four": 1, "sum": 29 }
+{ "unique1": 8, "four": 0, "sum": 31 }
+{ "unique1": 5, "four": 1, "sum": 32 }
+{ "unique1": 3, "four": 3, "sum": 23 }
+{ "unique1": 7, "four": 3, "sum": 15 }
+{ "unique1": 0, "four": 0, "sum": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.27.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.27.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.27.adm
new file mode 100644
index 0000000..329ea42
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.27.adm
@@ -0,0 +1,10 @@
+{ "unique1": 4, "four": 0, "sum": 7 }
+{ "unique1": 2, "four": 2, "sum": 13 }
+{ "unique1": 1, "four": 1, "sum": 22 }
+{ "unique1": 6, "four": 2, "sum": 26 }
+{ "unique1": 9, "four": 1, "sum": 29 }
+{ "unique1": 8, "four": 0, "sum": 31 }
+{ "unique1": 5, "four": 1, "sum": 32 }
+{ "unique1": 3, "four": 3, "sum": 23 }
+{ "unique1": 7, "four": 3, "sum": 15 }
+{ "unique1": 0, "four": 0, "sum": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.28.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.28.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.28.adm
new file mode 100644
index 0000000..5216945
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.28.adm
@@ -0,0 +1,10 @@
+{ "unique1": 4, "four": 0, "sum": 3 }
+{ "unique1": 2, "four": 2, "sum": 11 }
+{ "unique1": 1, "four": 1, "sum": 21 }
+{ "unique1": 6, "four": 2, "sum": 20 }
+{ "unique1": 9, "four": 1, "sum": 20 }
+{ "unique1": 8, "four": 0, "sum": 23 }
+{ "unique1": 5, "four": 1, "sum": 27 }
+{ "unique1": 3, "four": 3, "sum": 20 }
+{ "unique1": 7, "four": 3, "sum": 8 }
+{ "unique1": 0, "four": 0, "sum": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.29.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.29.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.29.adm
new file mode 100644
index 0000000..4145f34
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.29.adm
@@ -0,0 +1,10 @@
+{ "unique1": 4, "four": 0, "sum": null }
+{ "unique1": 2, "four": 2, "sum": 4 }
+{ "unique1": 1, "four": 1, "sum": 6 }
+{ "unique1": 6, "four": 2, "sum": 3 }
+{ "unique1": 9, "four": 1, "sum": 7 }
+{ "unique1": 8, "four": 0, "sum": 15 }
+{ "unique1": 5, "four": 1, "sum": 17 }
+{ "unique1": 3, "four": 3, "sum": 13 }
+{ "unique1": 7, "four": 3, "sum": 8 }
+{ "unique1": 0, "four": 0, "sum": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.3.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.3.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.3.adm
new file mode 100644
index 0000000..cb628c8
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.3.adm
@@ -0,0 +1,10 @@
+{ "depname": "develop", "empno": 7, "salary": 4200, "sum": 25100 }
+{ "depname": "develop", "empno": 9, "salary": 4500, "sum": 25100 }
+{ "depname": "develop", "empno": 10, "salary": 5200, "sum": 25100 }
+{ "depname": "develop", "empno": 11, "salary": 5200, "sum": 25100 }
+{ "depname": "develop", "empno": 8, "salary": 6000, "sum": 25100 }
+{ "depname": "personnel", "empno": 5, "salary": 3500, "sum": 7400 }
+{ "depname": "personnel", "empno": 2, "salary": 3900, "sum": 7400 }
+{ "depname": "sales", "empno": 3, "salary": 4800, "sum": 14600 }
+{ "depname": "sales", "empno": 4, "salary": 4800, "sum": 14600 }
+{ "depname": "sales", "empno": 1, "salary": 5000, "sum": 14600 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.30.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.30.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.30.adm
new file mode 100644
index 0000000..ff88d0c
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.30.adm
@@ -0,0 +1,10 @@
+{ "unique1": 4, "four": 0, "sum": 9 }
+{ "unique1": 2, "four": 2, "sum": 16 }
+{ "unique1": 1, "four": 1, "sum": 23 }
+{ "unique1": 6, "four": 2, "sum": 22 }
+{ "unique1": 9, "four": 1, "sum": 16 }
+{ "unique1": 8, "four": 0, "sum": 15 }
+{ "unique1": 5, "four": 1, "sum": 10 }
+{ "unique1": 3, "four": 3, "sum": 7 }
+{ "unique1": 7, "four": 3, "sum": 0 }
+{ "unique1": 0, "four": 0, "sum": null }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.31.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.31.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.31.adm
new file mode 100644
index 0000000..2827389
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.31.adm
@@ -0,0 +1,10 @@
+{ "unique1": 4, "four": 0, "sum": 6 }
+{ "unique1": 2, "four": 2, "sum": 7 }
+{ "unique1": 1, "four": 1, "sum": 13 }
+{ "unique1": 6, "four": 2, "sum": 22 }
+{ "unique1": 9, "four": 1, "sum": 30 }
+{ "unique1": 8, "four": 0, "sum": 35 }
+{ "unique1": 5, "four": 1, "sum": 38 }
+{ "unique1": 3, "four": 3, "sum": 45 }
+{ "unique1": 7, "four": 3, "sum": 45 }
+{ "unique1": 0, "four": 0, "sum": 45 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.32.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.32.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.32.adm
new file mode 100644
index 0000000..406183a
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.32.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 12 }
+{ "unique1": 4, "four": 0, "sum": 8 }
+{ "unique1": 8, "four": 0, "sum": 4 }
+{ "unique1": 1, "four": 1, "sum": 26 }
+{ "unique1": 5, "four": 1, "sum": 22 }
+{ "unique1": 9, "four": 1, "sum": 18 }
+{ "unique1": 2, "four": 2, "sum": 33 }
+{ "unique1": 6, "four": 2, "sum": 29 }
+{ "unique1": 3, "four": 3, "sum": 42 }
+{ "unique1": 7, "four": 3, "sum": 38 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.33.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.33.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.33.adm
new file mode 100644
index 0000000..5272039
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.33.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": null }
+{ "unique1": 4, "four": 0, "sum": null }
+{ "unique1": 8, "four": 0, "sum": null }
+{ "unique1": 1, "four": 1, "sum": 12 }
+{ "unique1": 5, "four": 1, "sum": 12 }
+{ "unique1": 9, "four": 1, "sum": 12 }
+{ "unique1": 2, "four": 2, "sum": 27 }
+{ "unique1": 6, "four": 2, "sum": 27 }
+{ "unique1": 3, "four": 3, "sum": 35 }
+{ "unique1": 7, "four": 3, "sum": 35 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.34.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.34.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.34.adm
new file mode 100644
index 0000000..b5b21a6
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.34.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 0 }
+{ "unique1": 4, "four": 0, "sum": 4 }
+{ "unique1": 8, "four": 0, "sum": 8 }
+{ "unique1": 1, "four": 1, "sum": 13 }
+{ "unique1": 5, "four": 1, "sum": 17 }
+{ "unique1": 9, "four": 1, "sum": 21 }
+{ "unique1": 2, "four": 2, "sum": 29 }
+{ "unique1": 6, "four": 2, "sum": 33 }
+{ "unique1": 3, "four": 3, "sum": 38 }
+{ "unique1": 7, "four": 3, "sum": 42 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.35.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.35.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.35.adm
new file mode 100644
index 0000000..73e6945
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.35.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "sum": 0 }
+{ "unique1": 1, "sum": 1 }
+{ "unique1": 2, "sum": 3 }
+{ "unique1": 3, "sum": 5 }
+{ "unique1": 4, "sum": 7 }
+{ "unique1": 5, "sum": 9 }
+{ "unique1": 6, "sum": 11 }
+{ "unique1": 7, "sum": 13 }
+{ "unique1": 8, "sum": 15 }
+{ "unique1": 9, "sum": 17 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.36.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.36.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.36.adm
new file mode 100644
index 0000000..54df6d9
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.36.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": null }
+{ "unique1": 4, "four": 0, "sum": null }
+{ "unique1": 8, "four": 0, "sum": null }
+{ "unique1": 1, "four": 1, "sum": 12 }
+{ "unique1": 5, "four": 1, "sum": 12 }
+{ "unique1": 9, "four": 1, "sum": 12 }
+{ "unique1": 2, "four": 2, "sum": 27 }
+{ "unique1": 6, "four": 2, "sum": 27 }
+{ "unique1": 3, "four": 3, "sum": 23 }
+{ "unique1": 7, "four": 3, "sum": 23 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.37.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.37.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.37.adm
new file mode 100644
index 0000000..8adf584
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.37.adm
@@ -0,0 +1,10 @@
+{ "unique1": 3, "four": 3, "sum": null }
+{ "unique1": 7, "four": 3, "sum": null }
+{ "unique1": 2, "four": 2, "sum": 10 }
+{ "unique1": 6, "four": 2, "sum": 10 }
+{ "unique1": 1, "four": 1, "sum": 18 }
+{ "unique1": 5, "four": 1, "sum": 18 }
+{ "unique1": 9, "four": 1, "sum": 18 }
+{ "unique1": 0, "four": 0, "sum": 23 }
+{ "unique1": 4, "four": 0, "sum": 23 }
+{ "unique1": 8, "four": 0, "sum": 23 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.38.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.38.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.38.adm
new file mode 100644
index 0000000..54df6d9
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.38.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": null }
+{ "unique1": 4, "four": 0, "sum": null }
+{ "unique1": 8, "four": 0, "sum": null }
+{ "unique1": 1, "four": 1, "sum": 12 }
+{ "unique1": 5, "four": 1, "sum": 12 }
+{ "unique1": 9, "four": 1, "sum": 12 }
+{ "unique1": 2, "four": 2, "sum": 27 }
+{ "unique1": 6, "four": 2, "sum": 27 }
+{ "unique1": 3, "four": 3, "sum": 23 }
+{ "unique1": 7, "four": 3, "sum": 23 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.39.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.39.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.39.adm
new file mode 100644
index 0000000..54df6d9
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.39.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": null }
+{ "unique1": 4, "four": 0, "sum": null }
+{ "unique1": 8, "four": 0, "sum": null }
+{ "unique1": 1, "four": 1, "sum": 12 }
+{ "unique1": 5, "four": 1, "sum": 12 }
+{ "unique1": 9, "four": 1, "sum": 12 }
+{ "unique1": 2, "four": 2, "sum": 27 }
+{ "unique1": 6, "four": 2, "sum": 27 }
+{ "unique1": 3, "four": 3, "sum": 23 }
+{ "unique1": 7, "four": 3, "sum": 23 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.4.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.4.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.4.adm
new file mode 100644
index 0000000..c669c97
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.4.adm
@@ -0,0 +1,10 @@
+{ "depname": "develop", "empno": 7, "salary": 4200, "rank": 1 }
+{ "depname": "develop", "empno": 9, "salary": 4500, "rank": 2 }
+{ "depname": "develop", "empno": 10, "salary": 5200, "rank": 3 }
+{ "depname": "develop", "empno": 11, "salary": 5200, "rank": 3 }
+{ "depname": "develop", "empno": 8, "salary": 6000, "rank": 5 }
+{ "depname": "personnel", "empno": 5, "salary": 3500, "rank": 1 }
+{ "depname": "personnel", "empno": 2, "salary": 3900, "rank": 2 }
+{ "depname": "sales", "empno": 3, "salary": 4800, "rank": 1 }
+{ "depname": "sales", "empno": 4, "salary": 4800, "rank": 1 }
+{ "depname": "sales", "empno": 1, "salary": 5000, "rank": 3 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.40.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.40.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.40.adm
new file mode 100644
index 0000000..54df6d9
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.40.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": null }
+{ "unique1": 4, "four": 0, "sum": null }
+{ "unique1": 8, "four": 0, "sum": null }
+{ "unique1": 1, "four": 1, "sum": 12 }
+{ "unique1": 5, "four": 1, "sum": 12 }
+{ "unique1": 9, "four": 1, "sum": 12 }
+{ "unique1": 2, "four": 2, "sum": 27 }
+{ "unique1": 6, "four": 2, "sum": 27 }
+{ "unique1": 3, "four": 3, "sum": 23 }
+{ "unique1": 7, "four": 3, "sum": 23 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.41.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.41.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.41.adm
new file mode 100644
index 0000000..54df6d9
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.41.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": null }
+{ "unique1": 4, "four": 0, "sum": null }
+{ "unique1": 8, "four": 0, "sum": null }
+{ "unique1": 1, "four": 1, "sum": 12 }
+{ "unique1": 5, "four": 1, "sum": 12 }
+{ "unique1": 9, "four": 1, "sum": 12 }
+{ "unique1": 2, "four": 2, "sum": 27 }
+{ "unique1": 6, "four": 2, "sum": 27 }
+{ "unique1": 3, "four": 3, "sum": 23 }
+{ "unique1": 7, "four": 3, "sum": 23 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.42.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.42.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.42.adm
new file mode 100644
index 0000000..283d875
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.42.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 33 }
+{ "unique1": 4, "four": 0, "sum": 37 }
+{ "unique1": 8, "four": 0, "sum": 41 }
+{ "unique1": 1, "four": 1, "sum": 31 }
+{ "unique1": 5, "four": 1, "sum": 35 }
+{ "unique1": 9, "four": 1, "sum": 39 }
+{ "unique1": 2, "four": 2, "sum": 39 }
+{ "unique1": 6, "four": 2, "sum": 43 }
+{ "unique1": 3, "four": 3, "sum": 26 }
+{ "unique1": 7, "four": 3, "sum": 30 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.43.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.43.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.43.adm
new file mode 100644
index 0000000..9c1c083
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.43.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 33 }
+{ "unique1": 4, "four": 0, "sum": 33 }
+{ "unique1": 8, "four": 0, "sum": 33 }
+{ "unique1": 1, "four": 1, "sum": 30 }
+{ "unique1": 5, "four": 1, "sum": 30 }
+{ "unique1": 9, "four": 1, "sum": 30 }
+{ "unique1": 2, "four": 2, "sum": 37 }
+{ "unique1": 6, "four": 2, "sum": 37 }
+{ "unique1": 3, "four": 3, "sum": 23 }
+{ "unique1": 7, "four": 3, "sum": 23 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.44.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.44.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.44.adm
new file mode 100644
index 0000000..5f09047
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.44.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 4 }
+{ "unique1": 4, "four": 0, "sum": 12 }
+{ "unique1": 8, "four": 0, "sum": 12 }
+{ "unique1": 1, "four": 1, "sum": 6 }
+{ "unique1": 5, "four": 1, "sum": 15 }
+{ "unique1": 9, "four": 1, "sum": 14 }
+{ "unique1": 2, "four": 2, "sum": 8 }
+{ "unique1": 6, "four": 2, "sum": 8 }
+{ "unique1": 3, "four": 3, "sum": 10 }
+{ "unique1": 7, "four": 3, "sum": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.45.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.45.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.45.adm
new file mode 100644
index 0000000..ea14976
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.45.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 4 }
+{ "unique1": 4, "four": 0, "sum": 8 }
+{ "unique1": 8, "four": 0, "sum": 4 }
+{ "unique1": 1, "four": 1, "sum": 5 }
+{ "unique1": 5, "four": 1, "sum": 10 }
+{ "unique1": 9, "four": 1, "sum": 5 }
+{ "unique1": 2, "four": 2, "sum": 6 }
+{ "unique1": 6, "four": 2, "sum": 2 }
+{ "unique1": 3, "four": 3, "sum": 7 }
+{ "unique1": 7, "four": 3, "sum": 3 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.46.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.46.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.46.adm
new file mode 100644
index 0000000..f1ccc39
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.46.adm
@@ -0,0 +1,10 @@
+{ "salary": 5000, "enroll_date": date("2006-10-01"), "sum": 34900 }
+{ "salary": 6000, "enroll_date": date("2006-10-01"), "sum": 34900 }
+{ "salary": 3900, "enroll_date": date("2006-12-23"), "sum": 38400 }
+{ "salary": 4800, "enroll_date": date("2007-08-01"), "sum": 47100 }
+{ "salary": 5200, "enroll_date": date("2007-08-01"), "sum": 47100 }
+{ "salary": 4800, "enroll_date": date("2007-08-08"), "sum": 47100 }
+{ "salary": 5200, "enroll_date": date("2007-08-15"), "sum": 47100 }
+{ "salary": 3500, "enroll_date": date("2007-12-10"), "sum": 36100 }
+{ "salary": 4200, "enroll_date": date("2008-01-01"), "sum": 32200 }
+{ "salary": 4500, "enroll_date": date("2008-01-01"), "sum": 32200 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.47.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.47.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.47.adm
new file mode 100644
index 0000000..f975cd4
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.47.adm
@@ -0,0 +1,10 @@
+{ "salary": 4200, "enroll_date": date("2008-01-01"), "sum": 32200 }
+{ "salary": 4500, "enroll_date": date("2008-01-01"), "sum": 32200 }
+{ "salary": 3500, "enroll_date": date("2007-12-10"), "sum": 36100 }
+{ "salary": 5200, "enroll_date": date("2007-08-15"), "sum": 47100 }
+{ "salary": 4800, "enroll_date": date("2007-08-08"), "sum": 47100 }
+{ "salary": 4800, "enroll_date": date("2007-08-01"), "sum": 47100 }
+{ "salary": 5200, "enroll_date": date("2007-08-01"), "sum": 47100 }
+{ "salary": 3900, "enroll_date": date("2006-12-23"), "sum": 38400 }
+{ "salary": 5000, "enroll_date": date("2006-10-01"), "sum": 34900 }
+{ "salary": 6000, "enroll_date": date("2006-10-01"), "sum": 34900 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.48.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.48.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.48.adm
new file mode 100644
index 0000000..54fd950
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.48.adm
@@ -0,0 +1,10 @@
+{ "salary": 5000, "enroll_date": date("2006-10-01"), "sum": null }
+{ "salary": 6000, "enroll_date": date("2006-10-01"), "sum": null }
+{ "salary": 3900, "enroll_date": date("2006-12-23"), "sum": null }
+{ "salary": 4800, "enroll_date": date("2007-08-01"), "sum": null }
+{ "salary": 5200, "enroll_date": date("2007-08-01"), "sum": null }
+{ "salary": 4800, "enroll_date": date("2007-08-08"), "sum": null }
+{ "salary": 5200, "enroll_date": date("2007-08-15"), "sum": null }
+{ "salary": 3500, "enroll_date": date("2007-12-10"), "sum": null }
+{ "salary": 4200, "enroll_date": date("2008-01-01"), "sum": null }
+{ "salary": 4500, "enroll_date": date("2008-01-01"), "sum": null }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.49.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.49.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.49.adm
new file mode 100644
index 0000000..f7fd8c9
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.49.adm
@@ -0,0 +1,10 @@
+{ "salary": 5000, "enroll_date": date("2006-10-01"), "sum": 29900 }
+{ "salary": 6000, "enroll_date": date("2006-10-01"), "sum": 28900 }
+{ "salary": 3900, "enroll_date": date("2006-12-23"), "sum": 34500 }
+{ "salary": 4800, "enroll_date": date("2007-08-01"), "sum": 42300 }
+{ "salary": 5200, "enroll_date": date("2007-08-01"), "sum": 41900 }
+{ "salary": 4800, "enroll_date": date("2007-08-08"), "sum": 42300 }
+{ "salary": 5200, "enroll_date": date("2007-08-15"), "sum": 41900 }
+{ "salary": 3500, "enroll_date": date("2007-12-10"), "sum": 32600 }
+{ "salary": 4200, "enroll_date": date("2008-01-01"), "sum": 28000 }
+{ "salary": 4500, "enroll_date": date("2008-01-01"), "sum": 27700 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.5.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.5.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.5.adm
new file mode 100644
index 0000000..b6241f5
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.5.adm
@@ -0,0 +1,10 @@
+{ "count": 10 }
+{ "count": 10 }
+{ "count": 10 }
+{ "count": 10 }
+{ "count": 10 }
+{ "count": 10 }
+{ "count": 10 }
+{ "count": 10 }
+{ "count": 10 }
+{ "count": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.50.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.50.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.50.adm
new file mode 100644
index 0000000..f6a764f
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.50.adm
@@ -0,0 +1,10 @@
+{ "salary": 5000, "enroll_date": date("2006-10-01"), "sum": 23900 }
+{ "salary": 6000, "enroll_date": date("2006-10-01"), "sum": 23900 }
+{ "salary": 3900, "enroll_date": date("2006-12-23"), "sum": 34500 }
+{ "salary": 4800, "enroll_date": date("2007-08-01"), "sum": 37100 }
+{ "salary": 5200, "enroll_date": date("2007-08-01"), "sum": 37100 }
+{ "salary": 4800, "enroll_date": date("2007-08-08"), "sum": 42300 }
+{ "salary": 5200, "enroll_date": date("2007-08-15"), "sum": 41900 }
+{ "salary": 3500, "enroll_date": date("2007-12-10"), "sum": 32600 }
+{ "salary": 4200, "enroll_date": date("2008-01-01"), "sum": 23500 }
+{ "salary": 4500, "enroll_date": date("2008-01-01"), "sum": 23500 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.51.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.51.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.51.adm
new file mode 100644
index 0000000..cf8a266
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.51.adm
@@ -0,0 +1,10 @@
+{ "salary": 5000, "enroll_date": date("2006-10-01"), "sum": 28900 }
+{ "salary": 6000, "enroll_date": date("2006-10-01"), "sum": 29900 }
+{ "salary": 3900, "enroll_date": date("2006-12-23"), "sum": 38400 }
+{ "salary": 4800, "enroll_date": date("2007-08-01"), "sum": 41900 }
+{ "salary": 5200, "enroll_date": date("2007-08-01"), "sum": 42300 }
+{ "salary": 4800, "enroll_date": date("2007-08-08"), "sum": 47100 }
+{ "salary": 5200, "enroll_date": date("2007-08-15"), "sum": 47100 }
+{ "salary": 3500, "enroll_date": date("2007-12-10"), "sum": 36100 }
+{ "salary": 4200, "enroll_date": date("2008-01-01"), "sum": 27700 }
+{ "salary": 4500, "enroll_date": date("2008-01-01"), "sum": 28000 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.52.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.52.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.52.adm
new file mode 100644
index 0000000..bdcd581
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.52.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 12 }
+{ "unique1": 4, "four": 0, "sum": 12 }
+{ "unique1": 8, "four": 0, "sum": 12 }
+{ "unique1": 1, "four": 1, "sum": 27 }
+{ "unique1": 5, "four": 1, "sum": 27 }
+{ "unique1": 9, "four": 1, "sum": 27 }
+{ "unique1": 2, "four": 2, "sum": 35 }
+{ "unique1": 6, "four": 2, "sum": 35 }
+{ "unique1": 3, "four": 3, "sum": 45 }
+{ "unique1": 7, "four": 3, "sum": 45 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.53.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.53.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.53.adm
new file mode 100644
index 0000000..5feecca
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.53.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 45 }
+{ "unique1": 4, "four": 0, "sum": 45 }
+{ "unique1": 8, "four": 0, "sum": 45 }
+{ "unique1": 1, "four": 1, "sum": 45 }
+{ "unique1": 5, "four": 1, "sum": 45 }
+{ "unique1": 9, "four": 1, "sum": 45 }
+{ "unique1": 2, "four": 2, "sum": 45 }
+{ "unique1": 6, "four": 2, "sum": 45 }
+{ "unique1": 3, "four": 3, "sum": 45 }
+{ "unique1": 7, "four": 3, "sum": 45 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.54.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.54.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.54.adm
new file mode 100644
index 0000000..e6f27b1
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.54.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 45 }
+{ "unique1": 4, "four": 0, "sum": 45 }
+{ "unique1": 8, "four": 0, "sum": 45 }
+{ "unique1": 1, "four": 1, "sum": 33 }
+{ "unique1": 5, "four": 1, "sum": 33 }
+{ "unique1": 9, "four": 1, "sum": 33 }
+{ "unique1": 2, "four": 2, "sum": 18 }
+{ "unique1": 6, "four": 2, "sum": 18 }
+{ "unique1": 3, "four": 3, "sum": 10 }
+{ "unique1": 7, "four": 3, "sum": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.55.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.55.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.55.adm
new file mode 100644
index 0000000..ba24423
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.55.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 45 }
+{ "unique1": 4, "four": 0, "sum": 45 }
+{ "unique1": 8, "four": 0, "sum": 45 }
+{ "unique1": 1, "four": 1, "sum": 45 }
+{ "unique1": 5, "four": 1, "sum": 45 }
+{ "unique1": 9, "four": 1, "sum": 45 }
+{ "unique1": 2, "four": 2, "sum": 33 }
+{ "unique1": 6, "four": 2, "sum": 33 }
+{ "unique1": 3, "four": 3, "sum": 18 }
+{ "unique1": 7, "four": 3, "sum": 18 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.56.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.56.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.56.adm
new file mode 100644
index 0000000..264dc63
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.56.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 33 }
+{ "unique1": 4, "four": 0, "sum": 33 }
+{ "unique1": 8, "four": 0, "sum": 33 }
+{ "unique1": 1, "four": 1, "sum": 18 }
+{ "unique1": 5, "four": 1, "sum": 18 }
+{ "unique1": 9, "four": 1, "sum": 18 }
+{ "unique1": 2, "four": 2, "sum": 10 }
+{ "unique1": 6, "four": 2, "sum": 10 }
+{ "unique1": 3, "four": 3, "sum": null }
+{ "unique1": 7, "four": 3, "sum": null }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.57.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.57.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.57.adm
new file mode 100644
index 0000000..f2e778e
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.57.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 35 }
+{ "unique1": 4, "four": 0, "sum": 35 }
+{ "unique1": 8, "four": 0, "sum": 35 }
+{ "unique1": 1, "four": 1, "sum": 45 }
+{ "unique1": 5, "four": 1, "sum": 45 }
+{ "unique1": 9, "four": 1, "sum": 45 }
+{ "unique1": 2, "four": 2, "sum": 45 }
+{ "unique1": 6, "four": 2, "sum": 45 }
+{ "unique1": 3, "four": 3, "sum": 45 }
+{ "unique1": 7, "four": 3, "sum": 45 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.58.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.58.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.58.adm
new file mode 100644
index 0000000..54df6d9
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.58.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": null }
+{ "unique1": 4, "four": 0, "sum": null }
+{ "unique1": 8, "four": 0, "sum": null }
+{ "unique1": 1, "four": 1, "sum": 12 }
+{ "unique1": 5, "four": 1, "sum": 12 }
+{ "unique1": 9, "four": 1, "sum": 12 }
+{ "unique1": 2, "four": 2, "sum": 27 }
+{ "unique1": 6, "four": 2, "sum": 27 }
+{ "unique1": 3, "four": 3, "sum": 23 }
+{ "unique1": 7, "four": 3, "sum": 23 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.59.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.59.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.59.adm
new file mode 100644
index 0000000..4645366
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.59.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 27 }
+{ "unique1": 4, "four": 0, "sum": 27 }
+{ "unique1": 8, "four": 0, "sum": 27 }
+{ "unique1": 1, "four": 1, "sum": 35 }
+{ "unique1": 5, "four": 1, "sum": 35 }
+{ "unique1": 9, "four": 1, "sum": 35 }
+{ "unique1": 2, "four": 2, "sum": 45 }
+{ "unique1": 6, "four": 2, "sum": 45 }
+{ "unique1": 3, "four": 3, "sum": 33 }
+{ "unique1": 7, "four": 3, "sum": 33 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.6.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.6.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.6.adm
new file mode 100644
index 0000000..6db85a2
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.6.adm
@@ -0,0 +1,10 @@
+{ "sum_1": 0, "ten": 0, "four": 0 }
+{ "sum_1": 0, "ten": 0, "four": 0 }
+{ "sum_1": 2, "ten": 0, "four": 2 }
+{ "sum_1": 3, "ten": 1, "four": 3 }
+{ "sum_1": 4, "ten": 1, "four": 1 }
+{ "sum_1": 5, "ten": 1, "four": 1 }
+{ "sum_1": 3, "ten": 3, "four": 3 }
+{ "sum_1": 0, "ten": 4, "four": 0 }
+{ "sum_1": 1, "ten": 7, "four": 1 }
+{ "sum_1": 1, "ten": 9, "four": 1 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.60.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.60.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.60.adm
new file mode 100644
index 0000000..4bbdb27
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.60.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 12 }
+{ "unique1": 4, "four": 0, "sum": 12 }
+{ "unique1": 8, "four": 0, "sum": 12 }
+{ "unique1": 1, "four": 1, "sum": 15 }
+{ "unique1": 5, "four": 1, "sum": 15 }
+{ "unique1": 9, "four": 1, "sum": 15 }
+{ "unique1": 2, "four": 2, "sum": 8 }
+{ "unique1": 6, "four": 2, "sum": 8 }
+{ "unique1": 3, "four": 3, "sum": 10 }
+{ "unique1": 7, "four": 3, "sum": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.61.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.61.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.61.adm
new file mode 100644
index 0000000..bd591e9
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.61.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 27 }
+{ "unique1": 4, "four": 0, "sum": 23 }
+{ "unique1": 8, "four": 0, "sum": 19 }
+{ "unique1": 1, "four": 1, "sum": 34 }
+{ "unique1": 5, "four": 1, "sum": 30 }
+{ "unique1": 9, "four": 1, "sum": 26 }
+{ "unique1": 2, "four": 2, "sum": 43 }
+{ "unique1": 6, "four": 2, "sum": 39 }
+{ "unique1": 3, "four": 3, "sum": 30 }
+{ "unique1": 7, "four": 3, "sum": 26 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.62.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.62.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.62.adm
new file mode 100644
index 0000000..f2d76fd
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.62.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 15 }
+{ "unique1": 4, "four": 0, "sum": 15 }
+{ "unique1": 8, "four": 0, "sum": 15 }
+{ "unique1": 1, "four": 1, "sum": 20 }
+{ "unique1": 5, "four": 1, "sum": 20 }
+{ "unique1": 9, "four": 1, "sum": 20 }
+{ "unique1": 2, "four": 2, "sum": 37 }
+{ "unique1": 6, "four": 2, "sum": 37 }
+{ "unique1": 3, "four": 3, "sum": 23 }
+{ "unique1": 7, "four": 3, "sum": 23 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.63.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.63.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.63.adm
new file mode 100644
index 0000000..d0b922c
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.63.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "sum": 15 }
+{ "unique1": 4, "four": 0, "sum": 19 }
+{ "unique1": 8, "four": 0, "sum": 23 }
+{ "unique1": 1, "four": 1, "sum": 21 }
+{ "unique1": 5, "four": 1, "sum": 25 }
+{ "unique1": 9, "four": 1, "sum": 29 }
+{ "unique1": 2, "four": 2, "sum": 39 }
+{ "unique1": 6, "four": 2, "sum": 43 }
+{ "unique1": 3, "four": 3, "sum": 26 }
+{ "unique1": 7, "four": 3, "sum": 30 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.64.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.64.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.64.adm
new file mode 100644
index 0000000..9db0518
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.64.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "ten": 0, "sum": 0 }
+{ "unique1": 1, "four": 1, "ten": 1, "sum": 1 }
+{ "unique1": 2, "four": 2, "ten": 2, "sum": 2 }
+{ "unique1": 3, "four": 3, "ten": 3, "sum": 3 }
+{ "unique1": 4, "four": 0, "ten": 4, "sum": 4 }
+{ "unique1": 5, "four": 1, "ten": 5, "sum": 5 }
+{ "unique1": 6, "four": 2, "ten": 6, "sum": 6 }
+{ "unique1": 7, "four": 3, "ten": 7, "sum": 7 }
+{ "unique1": 8, "four": 0, "ten": 8, "sum": 8 }
+{ "unique1": 9, "four": 1, "ten": 9, "sum": 9 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.65.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.65.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.65.adm
new file mode 100644
index 0000000..90c4929
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.65.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "ten": 0, "sum": null }
+{ "unique1": 1, "four": 1, "ten": 1, "sum": null }
+{ "unique1": 2, "four": 2, "ten": 2, "sum": null }
+{ "unique1": 3, "four": 3, "ten": 3, "sum": null }
+{ "unique1": 4, "four": 0, "ten": 4, "sum": null }
+{ "unique1": 5, "four": 1, "ten": 5, "sum": null }
+{ "unique1": 6, "four": 2, "ten": 6, "sum": null }
+{ "unique1": 7, "four": 3, "ten": 7, "sum": null }
+{ "unique1": 8, "four": 0, "ten": 8, "sum": null }
+{ "unique1": 9, "four": 1, "ten": 9, "sum": null }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.66.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.66.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.66.adm
new file mode 100644
index 0000000..90c4929
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.66.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "ten": 0, "sum": null }
+{ "unique1": 1, "four": 1, "ten": 1, "sum": null }
+{ "unique1": 2, "four": 2, "ten": 2, "sum": null }
+{ "unique1": 3, "four": 3, "ten": 3, "sum": null }
+{ "unique1": 4, "four": 0, "ten": 4, "sum": null }
+{ "unique1": 5, "four": 1, "ten": 5, "sum": null }
+{ "unique1": 6, "four": 2, "ten": 6, "sum": null }
+{ "unique1": 7, "four": 3, "ten": 7, "sum": null }
+{ "unique1": 8, "four": 0, "ten": 8, "sum": null }
+{ "unique1": 9, "four": 1, "ten": 9, "sum": null }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.67.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.67.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.67.adm
new file mode 100644
index 0000000..9db0518
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.67.adm
@@ -0,0 +1,10 @@
+{ "unique1": 0, "four": 0, "ten": 0, "sum": 0 }
+{ "unique1": 1, "four": 1, "ten": 1, "sum": 1 }
+{ "unique1": 2, "four": 2, "ten": 2, "sum": 2 }
+{ "unique1": 3, "four": 3, "ten": 3, "sum": 3 }
+{ "unique1": 4, "four": 0, "ten": 4, "sum": 4 }
+{ "unique1": 5, "four": 1, "ten": 5, "sum": 5 }
+{ "unique1": 6, "four": 2, "ten": 6, "sum": 6 }
+{ "unique1": 7, "four": 3, "ten": 7, "sum": 7 }
+{ "unique1": 8, "four": 0, "ten": 8, "sum": 8 }
+{ "unique1": 9, "four": 1, "ten": 9, "sum": 9 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.68.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.68.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.68.adm
new file mode 100644
index 0000000..a6036fb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.68.adm
@@ -0,0 +1,18 @@
+{ "x": 1, "sum": 4 }
+{ "x": 3, "sum": 9 }
+{ "x": 5, "sum": 15 }
+{ "x": 7, "sum": 21 }
+{ "x": 9, "sum": 27 }
+{ "x": 11, "sum": 33 }
+{ "x": 13, "sum": 39 }
+{ "x": 15, "sum": 45 }
+{ "x": 17, "sum": 51 }
+{ "x": 19, "sum": 57 }
+{ "x": 21, "sum": 63 }
+{ "x": 23, "sum": 69 }
+{ "x": 25, "sum": 75 }
+{ "x": 27, "sum": 81 }
+{ "x": 29, "sum": 87 }
+{ "x": 31, "sum": 93 }
+{ "x": 33, "sum": 99 }
+{ "x": 35, "sum": 68 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.69.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.69.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.69.adm
new file mode 100644
index 0000000..3356190
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.69.adm
@@ -0,0 +1,18 @@
+{ "x": 1, "sum": 1 }
+{ "x": 3, "sum": 3 }
+{ "x": 5, "sum": 5 }
+{ "x": 7, "sum": 7 }
+{ "x": 9, "sum": 9 }
+{ "x": 11, "sum": 11 }
+{ "x": 13, "sum": 13 }
+{ "x": 15, "sum": 15 }
+{ "x": 17, "sum": 17 }
+{ "x": 19, "sum": 19 }
+{ "x": 21, "sum": 21 }
+{ "x": 23, "sum": 23 }
+{ "x": 25, "sum": 25 }
+{ "x": 27, "sum": 27 }
+{ "x": 29, "sum": 29 }
+{ "x": 31, "sum": 31 }
+{ "x": 33, "sum": 33 }
+{ "x": 35, "sum": 35 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.7.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.7.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.7.adm
new file mode 100644
index 0000000..6c7f2dc
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.7.adm
@@ -0,0 +1,10 @@
+{ "row_number": 1 }
+{ "row_number": 2 }
+{ "row_number": 3 }
+{ "row_number": 4 }
+{ "row_number": 5 }
+{ "row_number": 6 }
+{ "row_number": 7 }
+{ "row_number": 8 }
+{ "row_number": 9 }
+{ "row_number": 10 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.70.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.70.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.70.adm
new file mode 100644
index 0000000..a6036fb
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.70.adm
@@ -0,0 +1,18 @@
+{ "x": 1, "sum": 4 }
+{ "x": 3, "sum": 9 }
+{ "x": 5, "sum": 15 }
+{ "x": 7, "sum": 21 }
+{ "x": 9, "sum": 27 }
+{ "x": 11, "sum": 33 }
+{ "x": 13, "sum": 39 }
+{ "x": 15, "sum": 45 }
+{ "x": 17, "sum": 51 }
+{ "x": 19, "sum": 57 }
+{ "x": 21, "sum": 63 }
+{ "x": 23, "sum": 69 }
+{ "x": 25, "sum": 75 }
+{ "x": 27, "sum": 81 }
+{ "x": 29, "sum": 87 }
+{ "x": 31, "sum": 93 }
+{ "x": 33, "sum": 99 }
+{ "x": 35, "sum": 68 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.71.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.71.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.71.adm
new file mode 100644
index 0000000..af6ffa1
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.71.adm
@@ -0,0 +1,26 @@
+{ "x": 1, "sum": 2 }
+{ "x": 1, "sum": 3 }
+{ "x": 1, "sum": 7 }
+{ "x": 5, "sum": 13 }
+{ "x": 7, "sum": 21 }
+{ "x": 9, "sum": 27 }
+{ "x": 11, "sum": 33 }
+{ "x": 13, "sum": 39 }
+{ "x": 15, "sum": 45 }
+{ "x": 17, "sum": 51 }
+{ "x": 19, "sum": 57 }
+{ "x": 21, "sum": 63 }
+{ "x": 23, "sum": 69 }
+{ "x": 25, "sum": 75 }
+{ "x": 27, "sum": 81 }
+{ "x": 29, "sum": 87 }
+{ "x": 31, "sum": 93 }
+{ "x": 33, "sum": 99 }
+{ "x": 35, "sum": 105 }
+{ "x": 37, "sum": 111 }
+{ "x": 39, "sum": 117 }
+{ "x": 41, "sum": 123 }
+{ "x": 43, "sum": 129 }
+{ "x": 45, "sum": 135 }
+{ "x": 47, "sum": 141 }
+{ "x": 49, "sum": 96 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.72.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.72.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.72.adm
new file mode 100644
index 0000000..e63f3be
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.72.adm
@@ -0,0 +1,26 @@
+{ "x": 1, "sum": 3 }
+{ "x": 1, "sum": 3 }
+{ "x": 1, "sum": 3 }
+{ "x": 5, "sum": 5 }
+{ "x": 7, "sum": 7 }
+{ "x": 9, "sum": 9 }
+{ "x": 11, "sum": 11 }
+{ "x": 13, "sum": 13 }
+{ "x": 15, "sum": 15 }
+{ "x": 17, "sum": 17 }
+{ "x": 19, "sum": 19 }
+{ "x": 21, "sum": 21 }
+{ "x": 23, "sum": 23 }
+{ "x": 25, "sum": 25 }
+{ "x": 27, "sum": 27 }
+{ "x": 29, "sum": 29 }
+{ "x": 31, "sum": 31 }
+{ "x": 33, "sum": 33 }
+{ "x": 35, "sum": 35 }
+{ "x": 37, "sum": 37 }
+{ "x": 39, "sum": 39 }
+{ "x": 41, "sum": 41 }
+{ "x": 43, "sum": 43 }
+{ "x": 45, "sum": 45 }
+{ "x": 47, "sum": 47 }
+{ "x": 49, "sum": 49 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.73.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.73.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.73.adm
new file mode 100644
index 0000000..d07858f
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.73.adm
@@ -0,0 +1,26 @@
+{ "x": 1, "sum": 8 }
+{ "x": 1, "sum": 8 }
+{ "x": 1, "sum": 8 }
+{ "x": 5, "sum": 15 }
+{ "x": 7, "sum": 21 }
+{ "x": 9, "sum": 27 }
+{ "x": 11, "sum": 33 }
+{ "x": 13, "sum": 39 }
+{ "x": 15, "sum": 45 }
+{ "x": 17, "sum": 51 }
+{ "x": 19, "sum": 57 }
+{ "x": 21, "sum": 63 }
+{ "x": 23, "sum": 69 }
+{ "x": 25, "sum": 75 }
+{ "x": 27, "sum": 81 }
+{ "x": 29, "sum": 87 }
+{ "x": 31, "sum": 93 }
+{ "x": 33, "sum": 99 }
+{ "x": 35, "sum": 105 }
+{ "x": 37, "sum": 111 }
+{ "x": 39, "sum": 117 }
+{ "x": 41, "sum": 123 }
+{ "x": 43, "sum": 129 }
+{ "x": 45, "sum": 135 }
+{ "x": 47, "sum": 141 }
+{ "x": 49, "sum": 96 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.74.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.74.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.74.adm
new file mode 100644
index 0000000..c51058a
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.74.adm
@@ -0,0 +1,10 @@
+{ "lag": null, "ten": 0, "four": 0 }
+{ "lag": 0, "ten": 0, "four": 0 }
+{ "lag": 0, "ten": 4, "four": 0 }
+{ "lag": null, "ten": 1, "four": 1 }
+{ "lag": 1, "ten": 1, "four": 1 }
+{ "lag": 1, "ten": 7, "four": 1 }
+{ "lag": 7, "ten": 9, "four": 1 }
+{ "lag": null, "ten": 0, "four": 2 }
+{ "lag": null, "ten": 1, "four": 3 }
+{ "lag": 1, "ten": 3, "four": 3 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.75.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.75.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.75.adm
new file mode 100644
index 0000000..c51058a
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.75.adm
@@ -0,0 +1,10 @@
+{ "lag": null, "ten": 0, "four": 0 }
+{ "lag": 0, "ten": 0, "four": 0 }
+{ "lag": 0, "ten": 4, "four": 0 }
+{ "lag": null, "ten": 1, "four": 1 }
+{ "lag": 1, "ten": 1, "four": 1 }
+{ "lag": 1, "ten": 7, "four": 1 }
+{ "lag": 7, "ten": 9, "four": 1 }
+{ "lag": null, "ten": 0, "four": 2 }
+{ "lag": null, "ten": 1, "four": 3 }
+{ "lag": 1, "ten": 3, "four": 3 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.76.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.76.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.76.adm
new file mode 100644
index 0000000..bcfb3ad
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.76.adm
@@ -0,0 +1,10 @@
+{ "lag": 0, "ten": 0, "four": 0 }
+{ "lag": 0, "ten": 0, "four": 0 }
+{ "lag": 4, "ten": 4, "four": 0 }
+{ "lag": null, "ten": 1, "four": 1 }
+{ "lag": 1, "ten": 1, "four": 1 }
+{ "lag": 1, "ten": 7, "four": 1 }
+{ "lag": 7, "ten": 9, "four": 1 }
+{ "lag": null, "ten": 0, "four": 2 }
+{ "lag": null, "ten": 1, "four": 3 }
+{ "lag": null, "ten": 3, "four": 3 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.77.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.77.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.77.adm
new file mode 100644
index 0000000..4d5be6c
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.77.adm
@@ -0,0 +1,10 @@
+{ "ten": 0, "four": 0, "lag": 0 }
+{ "ten": 0, "four": 0, "lag": 0 }
+{ "ten": 4, "four": 0, "lag": 4 }
+{ "ten": 1, "four": 1, "lag": 0 }
+{ "ten": 1, "four": 1, "lag": 1 }
+{ "ten": 7, "four": 1, "lag": 1 }
+{ "ten": 9, "four": 1, "lag": 7 }
+{ "ten": 0, "four": 2, "lag": 0 }
+{ "ten": 1, "four": 3, "lag": 0 }
+{ "ten": 3, "four": 3, "lag": 0 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.78.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.78.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.78.adm
new file mode 100644
index 0000000..5c175f7
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.78.adm
@@ -0,0 +1,10 @@
+{ "lead": 0, "ten": 0, "four": 0 }
+{ "lead": 4, "ten": 0, "four": 0 }
+{ "lead": null, "ten": 4, "four": 0 }
+{ "lead": 1, "ten": 1, "four": 1 }
+{ "lead": 7, "ten": 1, "four": 1 }
+{ "lead": 9, "ten": 7, "four": 1 }
+{ "lead": null, "ten": 9, "four": 1 }
+{ "lead": null, "ten": 0, "four": 2 }
+{ "lead": 3, "ten": 1, "four": 3 }
+{ "lead": null, "ten": 3, "four": 3 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.79.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.79.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.79.adm
new file mode 100644
index 0000000..971ad39
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.79.adm
@@ -0,0 +1,10 @@
+{ "lead": 0, "ten": 0, "four": 0 }
+{ "lead": 8, "ten": 0, "four": 0 }
+{ "lead": null, "ten": 4, "four": 0 }
+{ "lead": 2, "ten": 1, "four": 1 }
+{ "lead": 14, "ten": 1, "four": 1 }
+{ "lead": 18, "ten": 7, "four": 1 }
+{ "lead": null, "ten": 9, "four": 1 }
+{ "lead": null, "ten": 0, "four": 2 }
+{ "lead": 6, "ten": 1, "four": 3 }
+{ "lead": null, "ten": 3, "four": 3 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.8.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.8.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.8.adm
new file mode 100644
index 0000000..bbfa9e0
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.8.adm
@@ -0,0 +1,10 @@
+{ "rank_1": 1, "ten": 0, "four": 0 }
+{ "rank_1": 1, "ten": 0, "four": 0 }
+{ "rank_1": 3, "ten": 4, "four": 0 }
+{ "rank_1": 1, "ten": 1, "four": 1 }
+{ "rank_1": 1, "ten": 1, "four": 1 }
+{ "rank_1": 3, "ten": 7, "four": 1 }
+{ "rank_1": 4, "ten": 9, "four": 1 }
+{ "rank_1": 1, "ten": 0, "four": 2 }
+{ "rank_1": 1, "ten": 1, "four": 3 }
+{ "rank_1": 2, "ten": 3, "four": 3 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.80.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.80.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.80.adm
new file mode 100644
index 0000000..64e1dff
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.80.adm
@@ -0,0 +1,10 @@
+{ "lead": 0, "ten": 0, "four": 0 }
+{ "lead": 8, "ten": 0, "four": 0 }
+{ "lead": -1, "ten": 4, "four": 0 }
+{ "lead": 2, "ten": 1, "four": 1 }
+{ "lead": 14, "ten": 1, "four": 1 }
+{ "lead": 18, "ten": 7, "four": 1 }
+{ "lead": -1, "ten": 9, "four": 1 }
+{ "lead": -1, "ten": 0, "four": 2 }
+{ "lead": 6, "ten": 1, "four": 3 }
+{ "lead": -1, "ten": 3, "four": 3 }
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/asterixdb/blob/f2c18aa9/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.81.adm
----------------------------------------------------------------------
diff --git 
a/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.81.adm
 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.81.adm
new file mode 100644
index 0000000..fa1e38a
--- /dev/null
+++ 
b/asterixdb/asterix-app/src/test/resources/runtimets/results/window/pg_win/pg_win.81.adm
@@ -0,0 +1,10 @@
+{ "first_value": 0, "ten": 0, "four": 0 }
+{ "first_value": 0, "ten": 0, "four": 0 }
+{ "first_value": 0, "ten": 4, "four": 0 }
+{ "first_value": 1, "ten": 1, "four": 1 }
+{ "first_value": 1, "ten": 1, "four": 1 }
+{ "first_value": 1, "ten": 7, "four": 1 }
+{ "first_value": 1, "ten": 9, "four": 1 }
+{ "first_value": 0, "ten": 0, "four": 2 }
+{ "first_value": 1, "ten": 1, "four": 3 }
+{ "first_value": 1, "ten": 3, "four": 3 }
\ No newline at end of file

Reply via email to