Changeset: e3f3f19b47d6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e3f3f19b47d6
Added Files:
        
sql/test/BugTracker-2021/Tests/replace-transaction-conflict.Bug-7168.test
Modified Files:
        sql/test/BugTracker-2021/Tests/All
Branch: default
Log Message:

Added test for bug 7168. It's fixed but I didn't add the test


diffs (71 lines):

diff --git a/sql/test/BugTracker-2021/Tests/All 
b/sql/test/BugTracker-2021/Tests/All
--- a/sql/test/BugTracker-2021/Tests/All
+++ b/sql/test/BugTracker-2021/Tests/All
@@ -26,6 +26,7 @@ distinct-union.Bug-7148
 HAVE_LIBPY3?python-aggregates-empty.Bug-7158
 remote-join-idxs.Bug-7165
 shutdown-force.Bug-7167
+replace-transaction-conflict.Bug-7168
 merge-table-join.Bug-7172
 truncate-restart.Bug-7173
 remote-table-large.Bug-7178
diff --git 
a/sql/test/BugTracker-2021/Tests/replace-transaction-conflict.Bug-7168.test 
b/sql/test/BugTracker-2021/Tests/replace-transaction-conflict.Bug-7168.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2021/Tests/replace-transaction-conflict.Bug-7168.test
@@ -0,0 +1,55 @@
+@connection(id=1, username=monetdb, password=monetdb)
+statement ok
+CREATE OR REPLACE FUNCTION mybooludf(a bool) RETURNS BOOL RETURN a
+
+@connection(id=1)
+statement ok
+start transaction
+
+@connection(id=2, username=monetdb, password=monetdb)
+statement ok
+start transaction
+
+@connection(id=1)
+statement ok
+PLAN CREATE OR REPLACE FUNCTION mybooludf(a bool) RETURNS BOOL RETURN a
+
+@connection(id=2)
+statement ok
+PLAN CREATE OR REPLACE FUNCTION mybooludf(a bool) RETURNS BOOL RETURN a
+
+@connection(id=1)
+statement ok
+commit
+
+@connection(id=2)
+statement ok
+commit
+
+@connection(id=1)
+statement ok
+start transaction
+
+@connection(id=2, username=monetdb, password=monetdb)
+statement ok
+start transaction
+
+@connection(id=1)
+statement ok
+CREATE OR REPLACE FUNCTION mybooludf(a bool) RETURNS BOOL RETURN a
+
+@connection(id=2)
+statement ok
+CREATE OR REPLACE FUNCTION mybooludf(a bool) RETURNS BOOL RETURN a
+
+@connection(id=1)
+statement ok
+commit
+
+@connection(id=2)
+statement ok
+commit
+
+@connection(id=1)
+statement ok
+DROP FUNCTION mybooludf(bool)
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to