Changeset: 253935f264ad for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=253935f264ad Modified Files: sql/test/SQLancer/Tests/sqlancer10.test Branch: default Log Message:
Approved output diffs (18 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer10.test b/sql/test/SQLancer/Tests/sqlancer10.test --- a/sql/test/SQLancer/Tests/sqlancer10.test +++ b/sql/test/SQLancer/Tests/sqlancer10.test @@ -833,12 +833,12 @@ 0 query I rowsort SELECT 1 FROM t0, t1 WHERE least(CASE WHEN t1.c4 THEN t1.c4 WHEN t1.c5 THEN t1.c5 END, true) ---- -132 rows in the output. After getting the right result I will approve the hash +132 values hashing to 421ece02fd1d5b93ec74b250381a9e64 query T rowsort SELECT t1.c3 FROM t2, t0, t1 WHERE least(CASE WHEN t1.c4 THEN t1.c4 WHEN t1.c5 THEN t1.c5 WHEN t1.c5 THEN t1.c4 ELSE t1.c4 END, ((t1.c0)NOT LIKE(t1.c0))) ---- -120 rows in the output. After getting the right result I will approve the hash +120 values hashing to 879a831ae9fcb0a40db88988eb6e428b query I rowsort SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(least(CASE WHEN t1.c4 THEN t1.c4 WHEN t1.c5 THEN t1.c5 WHEN t1.c5 THEN t1.c4 ELSE t1.c4 END, ((t1.c0)NOT LIKE(t1.c0))) AS INT) as count FROM t2, t0, t1) as res _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list