Changeset: 00d2e1272406 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=00d2e1272406
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
Use smaller numbers for platforms without 128-bit integers
diffs (18 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer06.sql
b/sql/test/SQLancer/Tests/sqlancer06.sql
--- a/sql/test/SQLancer/Tests/sqlancer06.sql
+++ b/sql/test/SQLancer/Tests/sqlancer06.sql
@@ -395,12 +395,12 @@ SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1
-- NULL
-- NULL
-- 20:32:11
-SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1 ON NOT (t2.c1) WHERE
(((((((0.9842272043385978) NOT IN (1721458345))OR(t2.c0)))AND((t2.c0) BETWEEN
ASYMMETRIC (t2.c0) AND
+SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1 ON NOT (t2.c1) WHERE (((((((0.98) NOT
IN (17))OR(t2.c0)))AND((t2.c0) BETWEEN ASYMMETRIC (t2.c0) AND
((SELECT ALL t2.c0 FROM t2, t0 WHERE t2.c1)))))OR((SELECT t1.c2 FROM t1, t2) =
ALL(SELECT ALL t0.c2 FROM t0, t1, t2)));
-- NULL
-- NULL
-- 20:32:11
-SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((((((((0.9842272043385978)
NOT IN (1721458345))OR(t2.c0)))AND((t2.c0) BETWEEN ASYMMETRIC (t2.c0) AND
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((((((((0.98) NOT IN
(17))OR(t2.c0)))AND((t2.c0) BETWEEN ASYMMETRIC (t2.c0) AND
((SELECT t2.c0 FROM t2, t0 WHERE t2.c1)))))OR((SELECT ALL t1.c2 FROM t1, t2) =
ALL(SELECT t0.c2 FROM t0, t1, t2))) AS INT) as count FROM t2 RIGHT OUTER JOIN
t1 ON NOT (t2.c1)) as res;
-- 3
DROP TABLE t0;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
