Changeset: bd3bcb4332dc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/bd3bcb4332dc Modified Files: sql/test/miscellaneous/Tests/mergetable-deps-crash.test Branch: iso Log Message:
Second transaction conflicts diffs (55 lines): diff --git a/sql/test/miscellaneous/Tests/mergetable-deps-crash.test b/sql/test/miscellaneous/Tests/mergetable-deps-crash.test --- a/sql/test/miscellaneous/Tests/mergetable-deps-crash.test +++ b/sql/test/miscellaneous/Tests/mergetable-deps-crash.test @@ -1,40 +1,40 @@ @connection(id=1, username=monetdb, password=monetdb) statement ok -create table child (i int); +create table child (i int) @connection(id=1) statement ok -start transaction; +start transaction @connection(id=2, username=monetdb, password=monetdb) statement ok -start transaction; +start transaction @connection(id=1) statement ok -create merge table mt (i int); +create merge table mt (i int) @connection(id=1) statement ok -alter table mt add table child; +alter table mt add table child @connection(id=2) statement ok -drop table child; +drop table child @connection(id=1) statement ok -commit; +commit @connection(id=2) -statement ok -commit; +statement error 40000!COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead +commit @connection(id=1) query I rowsort -select * from mt; +select * from mt ---- @connection(id=1) statement ok -drop table mt; +drop table mt _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
