Changeset: 6d4ab6a88f2b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6d4ab6a88f2b Added Files: sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.sql sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.stable.err sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.stable.out sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.sql sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.stable.err sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.stable.out Modified Files: sql/test/BugTracker-2020/Tests/All Branch: Oct2020 Log Message:
Added tests and expected output for Bug-7021 diffs (207 lines): diff --git a/sql/test/BugTracker-2020/Tests/All b/sql/test/BugTracker-2020/Tests/All --- a/sql/test/BugTracker-2020/Tests/All +++ b/sql/test/BugTracker-2020/Tests/All @@ -34,3 +34,5 @@ deallocate-id.Bug-7010 values-groupby.Bug-7013 txtsim-parallel.Bug-7016 release_old_savepoint.Bug-7020 +savepoints_crash_mserver5_1.Bug-7021 +savepoints_crash_mserver5_2.Bug-7021 diff --git a/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.sql b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.sql @@ -0,0 +1,15 @@ +-- triggers a SIGSEGV in sql/storage/store.c:185: if (--(i->base.refcnt) > 0) +start transaction; +create table savepointtest (id int, primary key(id)); +savepoint name1; +insert into savepointtest values(1), (2), (3); +savepoint name2; +insert into savepointtest values(4), (5), (6); +insert into savepointtest values(7), (8), (9); +--savepoint name3; +select * from savepointtest; +commit; + +select 42; +select * from savepointtest; + diff --git a/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.stable.err b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.stable.err @@ -0,0 +1,12 @@ +stderr of test 'savepoints_crash_mserver5_1.Bug-7021` in directory 'sql/test/BugTracker-2020` itself: + + +# 11:57:43 > +# 11:57:43 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-153790" "--port=36420" +# 11:57:43 > + + +# 11:57:44 > +# 11:57:44 > "Done." +# 11:57:44 > + diff --git a/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.stable.out b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_1.Bug-7021.stable.out @@ -0,0 +1,57 @@ +stdout of test 'savepoints_crash_mserver5_1.Bug-7021` in directory 'sql/test/BugTracker-2020` itself: + + +# 11:57:43 > +# 11:57:43 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-153790" "--port=36420" +# 11:57:43 > + +#start transaction; +#create table savepointtest (id int, primary key(id)); +#savepoint name1; +#insert into savepointtest values(1), (2), (3); +[ 3 ] +#savepoint name2; +#insert into savepointtest values(4), (5), (6); +[ 3 ] +#insert into savepointtest values(7), (8), (9); +[ 3 ] +#select * from savepointtest; +% sys.savepointtest # table_name +% id # name +% int # type +% 1 # length +[ 1 ] +[ 2 ] +[ 3 ] +[ 4 ] +[ 5 ] +[ 6 ] +[ 7 ] +[ 8 ] +[ 9 ] +#commit; +#select 42; +% .%2 # table_name +% %2 # name +% tinyint # type +% 2 # length +[ 42 ] +#select * from savepointtest; +% sys.savepointtest # table_name +% id # name +% int # type +% 1 # length +[ 1 ] +[ 2 ] +[ 3 ] +[ 4 ] +[ 5 ] +[ 6 ] +[ 7 ] +[ 8 ] +[ 9 ] + +# 11:57:44 > +# 11:57:44 > "Done." +# 11:57:44 > + diff --git a/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.sql b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.sql @@ -0,0 +1,15 @@ +-- triggers: sql/storage/store.c:3940: trans_init: Assertion `istmp || !c->base.allocated' failed. +start transaction; +create table savepointtest (id int, primary key(id)); +savepoint name1; +insert into savepointtest values(1), (2), (3); +--savepoint name2; +insert into savepointtest values(4), (5), (6); +insert into savepointtest values(7), (8), (9); +savepoint name3; +select * from savepointtest; +commit; + +select 42; +select * from savepointtest; + diff --git a/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.stable.err b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.stable.err @@ -0,0 +1,12 @@ +stderr of test 'savepoints_crash_mserver5_2.Bug-7021` in directory 'sql/test/BugTracker-2020` itself: + + +# 12:00:17 > +# 12:00:17 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-154330" "--port=38327" +# 12:00:17 > + + +# 12:00:17 > +# 12:00:17 > "Done." +# 12:00:17 > + diff --git a/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.stable.out b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/savepoints_crash_mserver5_2.Bug-7021.stable.out @@ -0,0 +1,57 @@ +stdout of test 'savepoints_crash_mserver5_2.Bug-7021` in directory 'sql/test/BugTracker-2020` itself: + + +# 12:00:17 > +# 12:00:17 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-154330" "--port=38327" +# 12:00:17 > + +#start transaction; +#create table savepointtest (id int, primary key(id)); +#savepoint name1; +#insert into savepointtest values(1), (2), (3); +[ 3 ] +#insert into savepointtest values(4), (5), (6); +[ 3 ] +#insert into savepointtest values(7), (8), (9); +[ 3 ] +#savepoint name3; +#select * from savepointtest; +% sys.savepointtest # table_name +% id # name +% int # type +% 1 # length +[ 1 ] +[ 2 ] +[ 3 ] +[ 4 ] +[ 5 ] +[ 6 ] +[ 7 ] +[ 8 ] +[ 9 ] +#commit; +#select 42; +% .%2 # table_name +% %2 # name +% tinyint # type +% 2 # length +[ 42 ] +#select * from savepointtest; +% sys.savepointtest # table_name +% id # name +% int # type +% 1 # length +[ 1 ] +[ 2 ] +[ 3 ] +[ 4 ] +[ 5 ] +[ 6 ] +[ 7 ] +[ 8 ] +[ 9 ] + +# 12:00:17 > +# 12:00:17 > "Done." +# 12:00:17 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
