Changeset: 6b2527eb7a16 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/6b2527eb7a16
Modified Files:
sql/test/SQLancer/Tests/sqlancer13.test
sql/test/SQLancer/Tests/sqlancer16.test
Branch: Jul2021
Log Message:
Fix some test output types.
diffs (255 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer13.test
b/sql/test/SQLancer/Tests/sqlancer13.test
--- a/sql/test/SQLancer/Tests/sqlancer13.test
+++ b/sql/test/SQLancer/Tests/sqlancer13.test
@@ -191,7 +191,7 @@ query I rowsort
SELECT 1 FROM t2, t1 WHERE (t2.c0 > 4 OR false) AND (CASE WHEN 9 IN (t2.c0,
t1.c2) THEN TRUE END)
----
-query T rowsort
+query I rowsort
SELECT t1.c2 FROM t2, t1 WHERE (((((((((t2.c0)^(2))) NOT BETWEEN SYMMETRIC
(least(t1.c2, t1.c2)) AND (4))AND(NOT (TRUE))))OR(least(FALSE,
FALSE))))AND(CASE WHEN (9) NOT IN (t2.c0, t1.c2) THEN TRUE ELSE greatest(TRUE,
FALSE) END))
----
@@ -388,7 +388,64 @@ 108
query I rowsort
SELECT 1 FROM t0, t1 CROSS JOIN (SELECT DISTINCT t1.c0 > 4 FROM t1, t2 WHERE
t2.c2) AS sub0 WHERE (('Bw') NOT IN (least(t0.c2, t0.c2), CAST(t1.c0 AS
VARCHAR(64)))) IS NULL
----
-58 values hashing to 8fdc0683e1f7f9ff9590af46dca75282
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
statement ok
ROLLBACK
@@ -399,13 +456,13 @@ START TRANSACTION
statement ok
CREATE TABLE "sys"."t1" ("c3" BOOLEAN)
-query T rowsort
+query R rowsort
select (345*(case when t1.c3 then 0 else 58.9 end))*3 from t1
union all
select (345*(case when t1.c3 then 0 else 58.9 end))*3 from t1
----
-query T rowsort
+query R rowsort
select (11*(case when t1.c3 then 0 else 0.57 end))*3 from t1
union all
select (11*(case when t1.c3 then 0 else 0.57 end))*3 from t1
@@ -414,10 +471,10 @@ select (11*(case when t1.c3 then 0 else
statement ok
ROLLBACK
-query T rowsort
+query R rowsort
select round((0.52)*(0.10), -8)
----
-0.0000
+0.000
statement ok
START TRANSACTION
@@ -551,26 +608,26 @@ SELECT CAST(((((10)+(0.3607000614109831)
----
102 values hashing to a98471bd784fc82e6e3165302bc0080a
-query T rowsort
+query I rowsort
SELECT t1.c2 > 10 + 0.3607000614109831 FROM t1
----
-False
-False
-False
+0
+0
+0
-query T rowsort
+query I rowsort
SELECT t1.c2 > 10 + 0.3611111111 FROM t1
----
-False
-False
-False
+0
+0
+0
-query T rowsort
+query I rowsort
SELECT t1.c2 > 10 + 0.361111111 FROM t1
----
-False
-False
-False
+0
+0
+0
query I rowsort
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT
CAST(((((10)+(0.3607000614109831)))<(least(t1.c2, t1.c2))) AS INT) as count
FROM t0, t1) as res
@@ -761,43 +818,43 @@ INSERT INTO t0(c0) VALUES(BLOB ''), (BLO
statement ok
INSERT INTO t2(c0) VALUES(BLOB '050aC56fd0')
-query T rowsort
+query I rowsort
SELECT '' >= t1.c3 FROM t0, t1, t2
----
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
-False
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
statement ok
DROP TABLE t0
diff --git a/sql/test/SQLancer/Tests/sqlancer16.test
b/sql/test/SQLancer/Tests/sqlancer16.test
--- a/sql/test/SQLancer/Tests/sqlancer16.test
+++ b/sql/test/SQLancer/Tests/sqlancer16.test
@@ -106,7 +106,7 @@ CREATE TABLE "t1" ("c2" BIGINT NOT NULL,
statement ok rowcount 4
INSERT INTO "t1" VALUES (69), (-12), (9), (0)
-query T rowsort
+query I rowsort
SELECT -3 < least((SELECT 1 WHERE FALSE), (SELECT DISTINCT 2 FROM t1)) FROM t1
----
True
@@ -122,7 +122,7 @@ 0
69
9
-query T rowsort
+query I rowsort
SELECT least((SELECT 1 WHERE FALSE), (SELECT DISTINCT 2 FROM t1)) > -3 FROM t1
----
True
@@ -151,7 +151,7 @@ statement ok rowcount 9
INSERT INTO "t0" VALUES (INTERVAL '6' SECOND),(INTERVAL '9' SECOND),(INTERVAL
'1' SECOND),
(INTERVAL '0' SECOND),(INTERVAL '9' SECOND),(INTERVAL '4' SECOND),(INTERVAL
'6' SECOND),(INTERVAL '1' SECOND),(NULL)
-query T rowsort
+query I rowsort
SELECT (SELECT 2 WHERE FALSE) = ANY(SELECT 3 WHERE FALSE)
----
False
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
