Changeset: 7b8010b3b11b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7b8010b3b11b
Modified Files:
sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
sql/test/SQLancer/Tests/sqlancer09.sql
Branch: Oct2020
Log Message:
Moved wrong error query into bug 6131 test. It's related to it
diffs (35 lines):
diff --git a/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
b/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
--- a/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
+++ b/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
@@ -51,3 +51,14 @@ CREATE TABLE "t0"("tc0" CHARACTER LARGE
CONSTRAINT "t0_tc0_fkey" FOREIGN KEY ("tc0") REFERENCES "sys"."t0" ("tc0"));
INSERT INTO t0(tc0) VALUES('b' BETWEEN 'a' AND 'c');
ROLLBACK;
+
+-- The second delete statement must not give an error
+CREATE TABLE t1(c0 FLOAT);
+ALTER TABLE t1 ADD UNIQUE(c0);
+INSERT INTO t1(c0) VALUES(13.38);
+DELETE FROM t1 WHERE true;
+INSERT INTO t1(c0) VALUES(0.9), (0.5), (-3), (0.4);
+ALTER TABLE t1 ADD FOREIGN KEY (c0) REFERENCES t1(c0);
+INSERT INTO t1(c0) VALUES(null);
+DELETE FROM t1;
+DROP TABLE t1;
diff --git a/sql/test/SQLancer/Tests/sqlancer09.sql
b/sql/test/SQLancer/Tests/sqlancer09.sql
--- a/sql/test/SQLancer/Tests/sqlancer09.sql
+++ b/sql/test/SQLancer/Tests/sqlancer09.sql
@@ -282,13 +282,3 @@ CAST(1847496204 AS BOOLEAN) WHEN CASE WH
WHEN ((t2.c1)LIKE(t2.c1)) THEN (t1.c0) IN (t2.c0, t1.c0) ELSE (t2.c1) NOT
BETWEEN SYMMETRIC (t1.c1) AND (t2.c1) END
FROM t2, t1 WHERE CAST(20726 AS BOOLEAN)) AS sub0 ON ((CAST(t1.c1 AS
STRING))ILIKE(t1.c1));
ROLLBACK;
-
-CREATE TABLE t1(c0 FLOAT);
-ALTER TABLE t1 ADD UNIQUE(c0);
-INSERT INTO t1(c0) VALUES(13.38);
-DELETE FROM t1 WHERE true;
-INSERT INTO t1(c0) VALUES(0.9), (0.5), (-3), (0.4);
-ALTER TABLE t1 ADD FOREIGN KEY (c0) REFERENCES t1(c0);
-INSERT INTO t1(c0) VALUES(null);
-DELETE FROM t1;
-DROP TABLE t1;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
