Changeset: 6ae778afafea for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6ae778afafea
Modified Files:
sql/test/analytics/Tests/analytics06.sql
sql/test/analytics/Tests/analytics06.stable.out
Branch: analytics
Log Message:
Approve new output
diffs (35 lines):
diff --git a/sql/test/analytics/Tests/analytics06.sql
b/sql/test/analytics/Tests/analytics06.sql
--- a/sql/test/analytics/Tests/analytics06.sql
+++ b/sql/test/analytics/Tests/analytics06.sql
@@ -9,7 +9,7 @@ with relation as (select row_number() ov
select aa, bb, dd,
count(aa) over (partition by bb rows between dd preceding and current
row),
count(aa) over (partition by bb rows between dd preceding and dd
following),
- count(aa) over (partition by bb rows between dd + 1 preceding and dd
preceding) from relation where bb <> 1;
+ count(aa) over (partition by bb rows between dd + 1 preceding and dd
preceding) from relation;
rollback;
diff --git a/sql/test/analytics/Tests/analytics06.stable.out
b/sql/test/analytics/Tests/analytics06.stable.out
--- a/sql/test/analytics/Tests/analytics06.stable.out
+++ b/sql/test/analytics/Tests/analytics06.stable.out
@@ -89,13 +89,13 @@ Ready.
% aa, bb, dd, L20, L24, L30 # name
% int, int, int, bigint, bigint, bigint # type
% 2, 1, 1, 1, 1, 1 # length
-[ 15, 0, 1, 1, 2, 0 ]
-[ 15, 0, 1, 2, 3, 1 ]
-[ 5, 0, 2, 3, 3, 1 ]
-[ 15, 3, 1, 1, 2, 0 ]
-[ 15, 3, 1, 2, 3, 1 ]
+[ 3, 0, 4, 1, 2, 0 ]
+[ NULL, 0, 3, 1, 2, 0 ]
+[ 8, 0, 6, 2, 2, 0 ]
+[ 5, 3, 2, 1, 3, 0 ]
+[ 6, 3, 5, 2, 3, 0 ]
[ 15, 3, 1, 2, 2, 2 ]
-[ NULL, 4, 3, 0, 0, 0 ]
+[ NULL, 4, 7, 0, 0, 0 ]
#rollback;
#drop table testing;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
