Changeset: 8b82ac42f983 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8b82ac42f983
Modified Files:
sql/test/SQLancer/Tests/sqlancer07.sql
Branch: Oct2020
Log Message:
New SQLancer crash. Enough bugs for now
diffs (17 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
@@ -91,3 +91,13 @@ t0.c0, CASE INTERVAL '720497648' MONTH W
-- 0
-- 0
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" VARCHAR(156) NOT NULL);
+INSERT INTO "t0" VALUES ('');
+CREATE TABLE "t1" ("c0" VARCHAR(156) NOT NULL);
+INSERT INTO "t1" VALUES ('i?#\t+U,s'), ('288044674'), ('b'), ('W?ykP7L+X'),
('34076821'), ('ah'), ('﹂9j0M4');
+
+SELECT CASE '1' WHEN COALESCE((SELECT t0.c0 FROM t0), COALESCE(t1.c0, '2'))
THEN 1 END FROM t1;
+ -- 7 NULL rows
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
