Changeset: f46ac80613cc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f46ac80613cc Added Files: sql/test/BugTracker-2020/Tests/release_old_savepoint.Bug-7020.test sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.test sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.test sql/test/BugTracker-2020/Tests/transaction_with_unreleased_savepoint.Bug-7022.test sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.test Branch: mtest Log Message:
add .test files for new tests diffs (truncated from 362 to 300 lines): diff --git a/sql/test/BugTracker-2020/Tests/release_old_savepoint.Bug-7020.test b/sql/test/BugTracker-2020/Tests/release_old_savepoint.Bug-7020.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/release_old_savepoint.Bug-7020.test @@ -0,0 +1,67 @@ +statement ok +start transaction + +statement ok +create table savepointtest (id int, primary key(id)) + +statement ok +savepoint name1 + +statement ok +insert into savepointtest values(1), (2), (3) + +query I rowsort +select * from savepointtest +---- +1 +2 +3 + +statement ok +savepoint name2 + +statement ok +insert into savepointtest values(4), (5), (6) + +statement ok +insert into savepointtest values(7), (8), (9) + +query I rowsort +select * from savepointtest +---- +1 +2 +3 +4 +5 +6 +7 +8 +9 + +statement ok +savepoint name3 + +statement ok +release savepoint name1 + +query I rowsort +select * from savepointtest +---- +1 +2 +3 +4 +5 +6 +7 +8 +9 + +statement ok +commit + +statement ok +drop table if exists savepointtest + + diff --git a/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.test b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.test @@ -0,0 +1,60 @@ +statement ok +-- triggers a SIGSEGV in sql/storage/store.c:185: if ( +start transaction + +statement ok +create table savepointtest (id int, primary key(id)) + +statement ok +savepoint name1 + +statement ok +insert into savepointtest values(1), (2), (3) + +statement ok +savepoint name2 + +statement ok +insert into savepointtest values(4), (5), (6) + +statement ok +insert into savepointtest values(7), (8), (9) + +query I rowsort +select * from savepointtest +---- +1 +2 +3 +4 +5 +6 +7 +8 +9 + +statement ok +commit + +query I rowsort +select 42 +---- +42 + +query I rowsort +select * from savepointtest +---- +1 +2 +3 +4 +5 +6 +7 +8 +9 + +statement ok +drop table if exists savepointtest + + diff --git a/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.test b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.test @@ -0,0 +1,59 @@ +statement ok +start transaction + +statement ok +create table savepointtest (id int, primary key(id)) + +statement ok +savepoint name1 + +statement ok +insert into savepointtest values(1), (2), (3) + +statement ok +insert into savepointtest values(4), (5), (6) + +statement ok +insert into savepointtest values(7), (8), (9) + +statement ok +savepoint name3 + +query I rowsort +select * from savepointtest +---- +1 +2 +3 +4 +5 +6 +7 +8 +9 + +statement ok +commit + +query I rowsort +select 42 +---- +42 + +query I rowsort +select * from savepointtest +---- +1 +2 +3 +4 +5 +6 +7 +8 +9 + +statement ok +drop table if exists savepointtest + + diff --git a/sql/test/BugTracker-2020/Tests/transaction_with_unreleased_savepoint.Bug-7022.test b/sql/test/BugTracker-2020/Tests/transaction_with_unreleased_savepoint.Bug-7022.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/transaction_with_unreleased_savepoint.Bug-7022.test @@ -0,0 +1,130 @@ +statement ok +start transaction + +statement ok +create table savepointtest (id int, primary key(id)) + +statement ok +savepoint name1 + +statement ok +insert into savepointtest values(24) + +statement ok +release savepoint name1 + +statement ok +commit + +query TITITIII rowsort +select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest' +---- +savepointtest +2000 +NULL +0 +False +0 +0 +0 + +query I rowsort +select * from savepointtest +---- +24 + +statement error +create table savepointtest (id int, primary key(id)) + +statement ok +insert into savepointtest values(42) + +query TITITIII rowsort +select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest' +---- +savepointtest +2000 +NULL +0 +False +0 +0 +0 + +query I rowsort +select * from savepointtest +---- +24 +42 + +statement ok +drop table savepointtest + +query TITITIII rowsort +select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest' +---- + +statement ok +start transaction + +statement ok +create table savepointtest (id int, primary key(id)) + +statement ok +savepoint name1 + +statement ok +insert into savepointtest values(24) + +statement ok +commit + +query TITITIII rowsort +select name, schema_id, query, type, system, commit_action, access, temporary from tables where name = 'savepointtest' +---- +savepointtest +2000 +NULL +0 +False +0 +0 +0 + +query I rowsort _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
