Changeset: 8f0cdfbe7601 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8f0cdfbe7601
Added Files:
sql/test/BugTracker-2023/Tests/temp-on-savepoint-truncate-rollback-crash-7382.test
Modified Files:
sql/storage/bat/bat_storage.c
sql/test/BugTracker-2023/Tests/All
Branch: Sep2022
Log Message:
add test for bug 7382, make sure truncate changes are cleaned once
diffs (51 lines):
diff --git a/sql/storage/bat/bat_storage.c b/sql/storage/bat/bat_storage.c
--- a/sql/storage/bat/bat_storage.c
+++ b/sql/storage/bat/bat_storage.c
@@ -4213,7 +4213,7 @@ commit_update_delta( sql_trans *tr, sql_
}
if (!tr->parent)
t->base.new = base->new = 0;
-
+ change->handled = true;
return ok;
}
if (commit_ts)
diff --git a/sql/test/BugTracker-2023/Tests/All
b/sql/test/BugTracker-2023/Tests/All
--- a/sql/test/BugTracker-2023/Tests/All
+++ b/sql/test/BugTracker-2023/Tests/All
@@ -1,6 +1,7 @@
ambiguous-identifiers-7372
temp-table-foreign-key-crash-7378
add-drop-column-crash-7381
+temp-on-savepoint-truncate-rollback-crash-7382
recursive-trigger-crash-7383
view-on-alias-crash-7386
alter-inc-seq-crash-7387
diff --git
a/sql/test/BugTracker-2023/Tests/temp-on-savepoint-truncate-rollback-crash-7382.test
b/sql/test/BugTracker-2023/Tests/temp-on-savepoint-truncate-rollback-crash-7382.test
new file mode 100644
--- /dev/null
+++
b/sql/test/BugTracker-2023/Tests/temp-on-savepoint-truncate-rollback-crash-7382.test
@@ -0,0 +1,23 @@
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TEMPORARY TABLE t1 (keyc INT, c1 VARCHAR(100), c2 VARCHAR(100), PRIMARY
KEY(keyc)) on commit delete rows
+
+statement ok
+CREATE TABLE c1(c2 DECIMAL(9,4) NOT NULL)
+
+statement ok
+SAVEPOINT a_a
+
+statement error
+TRUNCATE TABLE t1
+
+statement error
+DELETE FROM w
+
+statement ok
+ROLLBACK
+
+statement ok
+SELECT 1
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
