Changeset: de705d478215 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=de705d478215
Modified Files:
sql/test/SQLancer/Tests/sqlancer07.sql
Branch: Oct2020
Log Message:
New SQLancer crash
diffs (26 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer07.sql
b/sql/test/SQLancer/Tests/sqlancer07.sql
--- a/sql/test/SQLancer/Tests/sqlancer07.sql
+++ b/sql/test/SQLancer/Tests/sqlancer07.sql
@@ -57,3 +57,22 @@ CREATE TABLE "t2" ("c0" INTERVAL MONTH);
SELECT CAST(t1.c1 AS INT) FROM t1, t0 RIGHT OUTER JOIN t2 ON ((SELECT DISTINCT
t1.c0 FROM t1, t0 WHERE FALSE)) NOT IN (t0.c0);
-- empty
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" CHAR(315));
+INSERT INTO "t0" VALUES ('(y/l'), (''), ('*J');
+CREATE TABLE "t1" ("c0" VARCHAR(512), "c1" DOUBLE PRECISION);
+INSERT INTO "t1" VALUES ('0.9295919173154146', NULL);
+CREATE TABLE "t2" ("c0" CHAR(315));
+INSERT INTO "t2" VALUES ('1753268987.000'), ('(y/l'), ('(y/l'), ('');
+
+SELECT '1' > COALESCE(((SELECT t1.c0 FROM t1) INTERSECT (SELECT '2')), t0.c0)
FROM t0;
+ -- False
+ -- True
+ -- False
+SELECT CAST(((COALESCE(t0.c0, t0.c0, t0.c0))>(COALESCE(((SELECT DISTINCT t1.c0
FROM t1, t0, t2 WHERE FALSE) INTERSECT DISTINCT (SELECT ALL t0.c0 FROM t0 WHERE
TRUE)),
+t0.c0, CASE INTERVAL '720497648' MONTH WHEN INTERVAL '1899785652' MONTH THEN
t0.c0 ELSE t0.c0 END))) AS INT) FROM t0;
+ -- 0
+ -- 0
+ -- 0
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
