Changeset: bef7876f1d6e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/bef7876f1d6e
Added Files:
sql/test/bugs/Tests/delete-or-not-in-bug.test
Modified Files:
sql/test/bugs/Tests/All
Branch: Jun2023
Log Message:
Added test for bug in older versions.
diffs (63 lines):
diff --git a/sql/test/bugs/Tests/All b/sql/test/bugs/Tests/All
--- a/sql/test/bugs/Tests/All
+++ b/sql/test/bugs/Tests/All
@@ -115,3 +115,4 @@ rtrim_bug
savepoint-release
procedure-recompile
rse_bug
+delete-or-not-in-bug
diff --git a/sql/test/bugs/Tests/delete-or-not-in-bug.test
b/sql/test/bugs/Tests/delete-or-not-in-bug.test
new file mode 100644
--- /dev/null
+++ b/sql/test/bugs/Tests/delete-or-not-in-bug.test
@@ -0,0 +1,50 @@
+statement ok
+CREATE TABLE "sys"."foo" (
+ "id" INTEGER NOT NULL,
+ "cid" INTEGER,
+ "ak" INTEGER,
+ "bk" INTEGER,
+ CONSTRAINT "foo_id_unique" UNIQUE ("id")
+);
+
+statement ok
+CREATE TABLE "sys"."bar" (
+ "cid" INTEGER,
+ "akr" INTEGER,
+ "bkr" INTEGER
+);
+
+statement ok
+INSERT INTO foo VALUES (1, 9, 10, 12), (2, 9, 11, 13), (3, 10, 20, 25), (4,
10, 452, 435), (5, 9, 130, 140);
+
+statement ok
+INSERT INTO bar VALUES (9, 120, 180), (3, 111, 134), (5, 183, 154), (9, 142,
182), (9, 102, 134);
+
+query IIII
+select * FROM foo WHERE cid = 9 AND ((ak NOT IN (SELECT akr FROM bar WHERE cid
= 9)) OR (bk NOT IN (SELECT bkr FROM bar WHERE cid = 9)));
+----
+1
+9
+10
+12
+2
+9
+11
+13
+5
+9
+130
+140
+
+statement ok
+DELETE FROM foo WHERE cid = 9 AND ((ak NOT IN (SELECT akr FROM bar WHERE cid =
9)) OR (bk NOT IN (SELECT bkr FROM bar WHERE cid = 9)));
+
+query IIII
+select * FROM foo WHERE cid = 9 AND ((ak NOT IN (SELECT akr FROM bar WHERE cid
= 9)) OR (bk NOT IN (SELECT bkr FROM bar WHERE cid = 9)));
+----
+
+statement ok
+drop table foo;
+
+statement ok
+drop table bar;
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
