Changeset: 7f63b61e5cd8 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/7f63b61e5cd8
Modified Files:
sql/test/miscellaneous/Tests/transaction_isolation.SQL.py
Branch: Jul2021
Log Message:
This count goes wrong. Client 2 sees uncommitted changes of client 1
diffs (17 lines):
diff --git a/sql/test/miscellaneous/Tests/transaction_isolation.SQL.py
b/sql/test/miscellaneous/Tests/transaction_isolation.SQL.py
--- a/sql/test/miscellaneous/Tests/transaction_isolation.SQL.py
+++ b/sql/test/miscellaneous/Tests/transaction_isolation.SQL.py
@@ -95,6 +95,13 @@ with SQLTestCase() as mdb1:
mdb1.execute("delete from integers where i <
101;").assertRowCount(170) # 101 - 200, 101 - 300
mdb1.execute('SELECT count(*) FROM
integers;').assertDataResultMatch([(300,)])
mdb2.execute('SELECT count(*) FROM
integers;').assertDataResultMatch([(470,)])
+ mdb1.execute("insert into integers (select value from
generate_series(41,161,1));").assertRowCount(120) # 101 - 200, 101 - 300, 41 -
160
+ mdb1.execute('SELECT count(*) FROM
integers;').assertDataResultMatch([(420,)])
+ mdb2.execute('SELECT count(*) FROM
integers;').assertDataResultMatch([(470,)])
+ mdb1.execute("delete from integers where i between 91 and
120;").assertRowCount(70) # 121 - 200, 121 - 300, 41 - 90, 121 - 160
+ mdb1.execute('SELECT count(*) FROM
integers;').assertDataResultMatch([(350,)])
+ mdb2.execute('SELECT count(*) FROM
integers;').assertDataResultMatch([(470,)])
+
mdb1.execute('commit;').assertSucceeded()
mdb1.execute("drop table integers;")
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
