Changeset: b548d6e0f07d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b548d6e0f07d
Branch: default
Log Message:
Merged with Jul2021
diffs (129 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer14.test
b/sql/test/SQLancer/Tests/sqlancer14.test
--- a/sql/test/SQLancer/Tests/sqlancer14.test
+++ b/sql/test/SQLancer/Tests/sqlancer14.test
@@ -780,3 +780,125 @@ select 1 from t0 where t0.c4 <= all(sele
statement ok
ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t2" ("c2" INTERVAL MONTH NOT NULL)
+
+statement ok
+INSERT INTO "t2" VALUES (INTERVAL '1005575652' MONTH),(INTERVAL '808548760'
MONTH),(INTERVAL '6' MONTH),(INTERVAL '6' MONTH),(INTERVAL '2' MONTH),(INTERVAL
'5' MONTH),(INTERVAL '-806508569' MONTH),
+(INTERVAL '6' MONTH),(INTERVAL '0' MONTH),(INTERVAL '3' MONTH),(INTERVAL '0'
MONTH),(INTERVAL '3' MONTH),(INTERVAL '6' MONTH),(INTERVAL '5' MONTH),(INTERVAL
'9' MONTH),(INTERVAL '9' MONTH),
+(INTERVAL '9' MONTH),(INTERVAL '6' MONTH),(INTERVAL '3' MONTH),(INTERVAL '4'
MONTH),(INTERVAL '8' MONTH),(INTERVAL '9' MONTH),(INTERVAL '4' MONTH),(INTERVAL
'2106373240' MONTH),
+(INTERVAL '-2142385196' MONTH),(INTERVAL '-1' MONTH),(INTERVAL '6'
MONTH),(INTERVAL '1' MONTH),(INTERVAL '9' MONTH),(INTERVAL '7' MONTH),(INTERVAL
'7' MONTH),(INTERVAL '8' MONTH),
+(INTERVAL '4' MONTH),(INTERVAL '9' MONTH),(INTERVAL '2' MONTH),(INTERVAL
'-31924182' MONTH),(INTERVAL '8' MONTH),(INTERVAL '4' MONTH),(INTERVAL
'-1648452957' MONTH),(INTERVAL '9' MONTH),
+(INTERVAL '-1648452957' MONTH),(INTERVAL '386411834' MONTH),(INTERVAL '7'
MONTH),(INTERVAL '9' MONTH),(INTERVAL '5' MONTH),(INTERVAL '0' MONTH)
+
+query I rowsort
+SELECT 1 FROM t2 WHERE (CASE WHEN true and true THEN 9 ELSE 6 END) NOT IN
((VALUES (5), (3)))
+----
+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
+
+query I rowsort
+SELECT 1 FROM t2 WHERE (CASE WHEN '0' THEN 9 ELSE -1789688463 END) NOT IN (-1,
(VALUES (281921255), (-1868657623)), 2)
+----
+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
+
+query I rowsort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((CASE WHEN '0' THEN 9 ELSE
-1789688463 END) NOT IN (-1, (VALUES (281921255), (-1868657623)), 2) AS INT) as
count FROM t2) as res
+----
+46
+
+statement ok
+ROLLBACK
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
