Changeset: 6cfbc7fb1e59 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6cfbc7fb1e59 Added Files: sql/test/miscellaneous/Tests/view-deps.test Modified Files: sql/test/miscellaneous/Tests/All Branch: Jul2021 Log Message:
add view + alter table test diffs (47 lines): diff --git a/sql/test/miscellaneous/Tests/All b/sql/test/miscellaneous/Tests/All --- a/sql/test/miscellaneous/Tests/All +++ b/sql/test/miscellaneous/Tests/All @@ -22,3 +22,4 @@ prepare transaction_isolation transaction_isolation2 mergetable-deps-crash +view-deps diff --git a/sql/test/miscellaneous/Tests/view-deps.test b/sql/test/miscellaneous/Tests/view-deps.test new file mode 100644 --- /dev/null +++ b/sql/test/miscellaneous/Tests/view-deps.test @@ -0,0 +1,34 @@ +@connection(id=1, username=monetdb, password=monetdb) +statement ok +create table fine(y int, z int); + +@connection(id=1) +statement ok +start transaction; + +@connection(id=2, username=monetdb, password=monetdb) +statement ok +start transaction; + +@connection(id=1) +statement ok +alter table fine drop column y; + +@connection(id=2) +statement ok +create view myv7(a,b) as select y, z from sys.fine; + +@connection(id=1) +statement ok +commit; + +@connection(id=2) +statement ok +commit; + +@connection(id=2) +query I,I roworder +select * from myv7; +---- + +statement error code 40000 message "COMMIT: transaction is aborted because of concurrency conflicts, will ROLLBACK instead" _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
