diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/t/mvcc-2.test')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/t/mvcc-2.test | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/mvcc-2.test b/storage/tokudb/mysql-test/tokudb/t/mvcc-2.test new file mode 100644 index 00000000000..2bcd2c93220 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb/t/mvcc-2.test @@ -0,0 +1,39 @@ +# test simple MVCC, that a transaction does not read something committed after it + +#--source include/have_tokudb.inc +SET DEFAULT_STORAGE_ENGINE = 'tokudb'; +set session transaction isolation level repeatable read; + +--echo # Establish connection conn1 (user = root) +connect (conn1,localhost,root,,); + +--disable_warnings +DROP TABLE IF EXISTS foo; +--enable_warnings + +connection conn1; +set session transaction isolation level repeatable read; +create table foo (a int) engine=TokuDB; +insert into foo values (1); +begin; +select * from foo; + +connection default; +insert into foo values (1000000); + +connection conn1; +select * From foo; + +connection default; +select * from foo; + +connection conn1; +commit; + +connection default; +disconnect conn1; + +connection default; +# Final cleanup. +set session transaction isolation level serializable; +DROP TABLE foo; |