Changeset: e41db66c3a67 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e41db66c3a67
Modified Files:
sql/test/mergetables/Tests/mergetable01.test
Branch: Sep2022
Log Message:
fixed test
diffs (49 lines):
diff --git a/sql/test/mergetables/Tests/mergetable01.test
b/sql/test/mergetables/Tests/mergetable01.test
--- a/sql/test/mergetables/Tests/mergetable01.test
+++ b/sql/test/mergetables/Tests/mergetable01.test
@@ -14,6 +14,10 @@ CREATE TABLE child2(a int)
statement ok rowcount 2
INSERT INTO child2 VALUES (3),(4)
+@connection(id=2)
+statement ok
+start transaction
+
@connection(id=1, username=monetdb, password=monetdb)
statement ok
start transaction
@@ -22,10 +26,6 @@ start transaction
statement ok
CREATE MERGE TABLE parent(a int)
-@connection(id=2)
-statement ok
-start transaction
-
@connection(id=1)
statement ok
alter table parent add table child1
@@ -38,8 +38,12 @@ alter table parent add table child2
statement ok
drop table child2;
+@connection(id=1)
+statement ok
+commit
+
@connection(id=2)
-statement ok
+statement error 40001!COMMIT: transaction is aborted because of concurrency
conflicts, will ROLLBACK instead
commit
@connection(id=1)
@@ -58,6 +62,6 @@ drop table parent;
statement ok
drop table child1;
-#@connection(id=1)
-#statement ok
-#drop table child2;
+@connection(id=1)
+statement ok
+drop table child2;
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
