Changeset: 76805b818767 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=76805b818767
Added Files:
sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.sql
sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.stable.err
sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.stable.out
Modified Files:
sql/test/BugTracker-2020/Tests/All
Branch: window-tunning
Log Message:
Bug 6997 has been fixed on this branch
diffs (79 lines):
diff --git a/sql/test/BugTracker-2020/Tests/All
b/sql/test/BugTracker-2020/Tests/All
--- a/sql/test/BugTracker-2020/Tests/All
+++ b/sql/test/BugTracker-2020/Tests/All
@@ -26,3 +26,4 @@ table-udf-column-descriptor.Bug-6964
table-udf-distinct.Bug-6965
HAVE_PYMONETDB?table-udf-on-remote.Bug-6971
integers-intervals.Bug-6979
+window-function-order.Bug-6997
diff --git a/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.sql
b/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.sql
@@ -0,0 +1,13 @@
+start transaction;
+
+create table "ordertest"(str text, orderA int, orderB int, num int);
+insert into "ordertest" values('a',1,1,1), ('a',2,1,10), ('a',3,1,20),
('a',4,1,30);
+
+select *,
+sum("num") over(order by orderA) as orderbyA,
+sum("num") over(order by orderA,orderB) as orderbyAB,
+sum("num") over(order by orderB,orderA) as orderbyBA,
+sum("num") over(order by orderB) as orderbyB
+from "ordertest";
+
+rollback;
diff --git
a/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.stable.err
b/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.stable.err
@@ -0,0 +1,12 @@
+stderr of test 'window-function-order.Bug-6997` in directory
'sql/test/BugTracker-2020` itself:
+
+
+# 09:11:57 >
+# 09:11:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-6118" "--port=31970"
+# 09:11:57 >
+
+
+# 09:11:57 >
+# 09:11:57 > "Done."
+# 09:11:57 >
+
diff --git
a/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.stable.out
b/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.stable.out
@@ -0,0 +1,31 @@
+stdout of test 'window-function-order.Bug-6997` in directory
'sql/test/BugTracker-2020` itself:
+
+
+# 09:11:57 >
+# 09:11:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-6118" "--port=31970"
+# 09:11:57 >
+
+#start transaction;
+#create table "ordertest"(str text, orderA int, orderB int, num int);
+#insert into "ordertest" values('a',1,1,1), ('a',2,1,10), ('a',3,1,20),
('a',4,1,30);
+[ 4 ]
+#select *,
+#sum("num") over(order by orderA) as orderbyA,
+#sum("num") over(order by orderA,orderB) as orderbyAB,
+#sum("num") over(order by orderB,orderA) as orderbyBA,
+#sum("num") over(order by orderB) as orderbyB
+#from "ordertest";
+% sys.ordertest, sys.ordertest, sys.ordertest, sys.ordertest, sys.,
sys., sys., sys. # table_name
+% str, ordera, orderb, num, orderbya, orderbyab, orderbyba,
orderbyb # name
+% clob, int, int, int, hugeint, hugeint,
hugeint, hugeint # type
+% 1, 1, 1, 2, 2, 2, 2, 2 # length
+[ "a", 1, 1, 1, 1, 1, 1, 61 ]
+[ "a", 2, 1, 10, 11, 11, 11, 61 ]
+[ "a", 3, 1, 20, 31, 31, 31, 61 ]
+[ "a", 4, 1, 30, 61, 61, 61, 61 ]
+#rollback;
+
+# 09:11:57 >
+# 09:11:57 > "Done."
+# 09:11:57 >
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
