Changeset: 052fd96ba437 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/052fd96ba437
Modified Files:
sql/test/miscellaneous/Tests/transaction_isolation2.SQL.py
Branch: Jul2021
Log Message:
Added test for sql type transaction conflict
diffs (19 lines):
diff --git a/sql/test/miscellaneous/Tests/transaction_isolation2.SQL.py
b/sql/test/miscellaneous/Tests/transaction_isolation2.SQL.py
--- a/sql/test/miscellaneous/Tests/transaction_isolation2.SQL.py
+++ b/sql/test/miscellaneous/Tests/transaction_isolation2.SQL.py
@@ -59,7 +59,15 @@ with SQLTestCase() as mdb1:
mdb2.execute('rollback;').assertSucceeded()
mdb1.execute('start transaction;').assertSucceeded()
+ mdb2.execute('start transaction;').assertSucceeded()
+ mdb1.execute('CREATE TYPE myurl EXTERNAL NAME url;').assertSucceeded()
+ mdb2.execute('CREATE TYPE myurl EXTERNAL NAME
url;').assertFailed(err_code="42000", err_message="CREATE TYPE: transaction
conflict detected")
+ mdb1.execute('commit;').assertSucceeded()
+ mdb2.execute('rollback;').assertSucceeded()
+
+ mdb1.execute('start transaction;').assertSucceeded()
mdb1.execute('DROP schema mysch;').assertSucceeded()
+ mdb1.execute('DROP TYPE myurl;').assertSucceeded()
mdb1.execute("drop table integers;").assertSucceeded()
mdb1.execute("drop table longs;").assertSucceeded()
mdb1.execute("drop table doubles;").assertSucceeded()
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
