Changeset: 613aabc70add for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/613aabc70add
Added Files:
sql/test/BugTracker-2021/Tests/merge-delete.Bug-7136.test
Modified Files:
sql/test/BugTracker-2021/Tests/All
Branch: Jul2021
Log Message:
Although this is fixed, leave the test case here
diffs (47 lines):
diff --git a/sql/test/BugTracker-2021/Tests/All
b/sql/test/BugTracker-2021/Tests/All
--- a/sql/test/BugTracker-2021/Tests/All
+++ b/sql/test/BugTracker-2021/Tests/All
@@ -13,3 +13,4 @@ batcalc-between-undefined.Bug-7129
batappend-undefined.Bug-7130
WITH-alias-DELETE-1.deletes-wrong-tuples.Bug-7133
WITH-alias-DELETE-2.deletes-too-many-tuples.Bug-7133
+merge-delete.Bug-7136
diff --git a/sql/test/BugTracker-2021/Tests/merge-delete.Bug-7136.test
b/sql/test/BugTracker-2021/Tests/merge-delete.Bug-7136.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2021/Tests/merge-delete.Bug-7136.test
@@ -0,0 +1,34 @@
+statement ok
+start transaction
+
+statement ok
+CREATE TABLE "v" ("id" INTEGER NOT NULL,"version" INTEGER NOT NULL,"value"
DOUBLE)
+
+statement ok rowcount 5
+insert into "v" values (1,1622470128,1), (2,1622470128,2), (3,1622470128,3),
(4,1622470128,4), (5,1622470128,5)
+
+statement ok rowcount 0
+MERGE INTO "v" dst
+USING (SELECT id, version FROM (SELECT id, version, DENSE_RANK() OVER
(PARTITION BY id ORDER BY id, version DESC) AS rn FROM "v")t WHERE rn > 1 ) src
+ON src.id = dst.id AND src.version = dst.version
+WHEN MATCHED THEN DELETE
+
+statement ok
+drop table v
+
+statement ok
+CREATE TABLE "v" ("id" INTEGER,"version" INTEGER,"value" DOUBLE)
+
+statement ok rowcount 5
+insert into "v" values (1,1622470128,1), (2,1622470128,2), (3,1622470128,3),
(4,1622470128,4), (5,1622470128,5)
+
+statement ok rowcount 0
+MERGE INTO "v" dst
+USING (SELECT id, version FROM (SELECT id, version, DENSE_RANK() OVER
(PARTITION BY id ORDER BY id, version DESC) AS rn FROM "v")t WHERE rn > 1 ) src
+ON src.id = dst.id AND src.version = dst.version
+WHEN MATCHED THEN DELETE
+
+statement ok
+rollback
+
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
