Changeset: 153f401628b1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/153f401628b1
Modified Files:
sql/test/SQLancer/Tests/sqlancer20.SQL.py
Branch: Jan2022
Log Message:
Sequence of serial statements giving transaction conflict when there is only
one client around. Looking at this bug
diffs (30 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer20.SQL.py
b/sql/test/SQLancer/Tests/sqlancer20.SQL.py
--- a/sql/test/SQLancer/Tests/sqlancer20.SQL.py
+++ b/sql/test/SQLancer/Tests/sqlancer20.SQL.py
@@ -46,6 +46,26 @@ with SQLTestCase() as cli:
DROP TABLE mt2;
COMMIT;""").assertSucceeded()
+ # testing remote tables with transaction isolation
+ cli.execute("""
+ START TRANSACTION;
+ CREATE TABLE rt0(c0 INT);
+ CREATE REMOTE TABLE rrt0(c0 INT) on
'mapi:monetdb://localhost:%s/%s/sys/rt0';
+ COMMIT;""" % (port, db)).assertSucceeded()
+
+ cli.execute('SELECT "setmasklen"(INET \'9.49.240.200/13\', 48061431) FROM
rrt0;') \
+ .assertFailed(err_message="(mapi:monetdb://monetdb@localhost/%s)
Illegal netmask length value: 48061431" % (db,))
+ cli.execute('INSERT INTO rt0(c0) VALUES(1);') \
+ .assertSucceeded().assertRowCount(1)
+ cli.execute('ALTER TABLE rt0 ADD CONSTRAINT con3 UNIQUE(c0);') \
+ .assertSucceeded()
+
+ cli.execute("""
+ START TRANSACTION;
+ DROP TABLE rrt0;
+ DROP TABLE rt0;
+ COMMIT;""").assertSucceeded()
+
# testing temporary tables
with SQLTestCase() as mdb1:
mdb1.connect(username="monetdb", password="monetdb")
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
