Changeset: a76a67f42fb0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a76a67f42fb0
Modified Files:
sql/test/SQLancer/Tests/sqlancer07.sql
Branch: Oct2020
Log Message:
New SQLancer crash
diffs (19 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
@@ -101,3 +101,15 @@ 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;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c1" VARCHAR(388) NOT NULL,CONSTRAINT "t0_c1_pkey" PRIMARY
KEY ("c1"),CONSTRAINT "t0_c1_unique" UNIQUE ("c1"));
+INSERT INTO "t0" VALUES (''), ('Ral%}?U*A'), ('Dz '), ('P');
+CREATE TABLE "t2" ("c1" VARCHAR(388) NOT NULL);
+INSERT INTO "t2" VALUES
('4'),('4'),('3eSU8,'),(''),('5E~쟱'),('~'),('1386006226'),('0.19005213960704492'),('''{Mdd뒆VB'''),('\015%L%]'),('+'),(''),('㕚o+k');
+
+select t0.c1 from t0 where (-5) in (case when t0.c1 then 1 end, (select -3
from t0));
+ -- empty
+select t0.c1 from t0 where (-5) in (case when t0.c1 then 1 else -2 end,
(select -3 from t0, t2 where false));
+ -- empty
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
