Changeset: a688b8e6858a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a688b8e6858a Added Files: sql/test/transactions/Tests/update_drop_crash.test Branch: Dec2023 Log Message:
add test for update/drop crash diffs (47 lines): diff --git a/sql/test/transactions/Tests/update_drop_crash.test b/sql/test/transactions/Tests/update_drop_crash.test new file mode 100644 --- /dev/null +++ b/sql/test/transactions/Tests/update_drop_crash.test @@ -0,0 +1,42 @@ +statement ok +create table t1 (i int) + +statement ok +insert into t1 values (1), (2), (3), (9) + +@connection(id=reader) +statement ok +start transaction + +@connection(id=update) +statement ok +update t1 set i=10 where i=2 + +query T +select count(*) from t1; +---- +4 + +statement ok +insert into t1 values (1), (2), (3), (9) + +@connection(id=update2) +statement ok +update t1 set i=11 where i=9 + +query T +select count(*) from t1; +---- +8 + +@connection(id=drop) +statement ok +drop table t1 + +query T +select name from sys._tables where name = 't1' +---- + +@connection(id=reader) +statement ok +commit _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
