Changeset: 5bf0bc6548d7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5bf0bc6548d7
Modified Files:
sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.sql
sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.stable.out
Branch: window-tunning
Log Message:
Approved output
diffs (42 lines):
diff --git
a/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
b/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
---
a/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
+++
b/sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out
@@ -113,7 +113,7 @@ project (
| | | | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" ASC ]
| | | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" NULLS
LAST ]
| | | | | | ) [ "f"."id", "p"."number" ] [ "f"."id" ASC, "p"."number" ASC ]
-| | | | | ) [ "f"."id", sys.row_number(sys.star(), boolean "false",
sys.diff(sys.diff("f"."id" ASC), "p"."number" ASC)) as "line" ]
+| | | | | ) [ "f"."id", sys.row_number(sys.star(), boolean "false",
sys.diff(sys.diff("f"."id"), "p"."number")) as "line" ]
| | | | ) [ "f"."id" as "fid", "line" ]
| | | ) [ "fid" ] [ "line" ASC ]
| | ) [ "fid" as "commented_function_signatures_6542"."fid" ]
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
--- a/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.sql
+++ b/sql/test/BugTracker-2020/Tests/window-function-order.Bug-6997.sql
@@ -4,10 +4,10 @@ create table "ordertest"(str text, order
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
+cast(sum("num") over(order by orderA) as bigint) as orderbyA,
+cast(sum("num") over(order by orderA,orderB) as bigint) as orderbyAB,
+cast(sum("num") over(order by orderB,orderA) as bigint) as orderbyBA,
+cast(sum("num") over(order by orderB) as bigint) as orderbyB
from "ordertest";
rollback;
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
--- 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
@@ -17,7 +17,7 @@ stdout of test 'window-function-order.Bu
#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
+% clob, int, int, int, bigint, bigint, bigint, bigint # 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 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
