Changeset: 66bfe3ae648e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=66bfe3ae648e
Modified Files:
sql/test/SQLancer/Tests/sqlancer07.sql
Branch: Oct2020
Log Message:
New SQLancer crash and prepared statement undefined error
diffs (24 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
@@ -40,3 +40,20 @@ CREATE TABLE "t2" ("c0" DATE NOT NULL);
SELECT 0 <= ANY(SELECT CASE INTERVAL '2' SECOND WHEN INTERVAL '6' SECOND THEN
t1.c1 ELSE (SELECT t1.c1 FROM t1) END FROM t1) FROM t1;
-- empty
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" BOOLEAN NOT NULL);
+CREATE TABLE "t1" ("c0" DECIMAL(18,3));
+CREATE TABLE "t2" ("c0" DECIMAL(18,3),"c2" DATE);
+PREPARE (SELECT DISTINCT t0.c0, INTERVAL '1734780053' SECOND FROM t0, t1)
UNION ALL (SELECT ?, ? FROM t2);
+ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" INTERVAL MONTH NOT NULL,CONSTRAINT "t0_c0_pkey"
PRIMARY KEY ("c0"),CONSTRAINT "t0_c0_unique" UNIQUE ("c0"),CONSTRAINT
"t0_c0_unique" UNIQUE ("c0"));
+INSERT INTO "t0" VALUES (INTERVAL '2101098338' MONTH);
+CREATE TABLE "t1" ("c0" INTERVAL MONTH,"c1" BOOLEAN);
+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;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
