diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/t/mvcc-13.test')
-rwxr-xr-x | storage/tokudb/mysql-test/tokudb/t/mvcc-13.test | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/mvcc-13.test b/storage/tokudb/mysql-test/tokudb/t/mvcc-13.test new file mode 100755 index 00000000000..bbaa0769b0d --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb/t/mvcc-13.test @@ -0,0 +1,35 @@ +# ticket 895 is a query optimization problem with the primary key + +--source include/have_tokudb.inc +SET DEFAULT_STORAGE_ENGINE = 'tokudb'; + +--echo # Establish connection conn1 (user = root) +connect (conn1,localhost,root,,); + +--disable_warnings +DROP TABLE IF EXISTS foo,foo1; +--enable_warnings + +connection default; +set session transaction isolation level repeatable read; +create table foo (a int) engine=TokuDB; +show create table foo; +begin; +select * from foo; + +connection conn1; +set session transaction isolation level repeatable read; +create table foo1(a int) engine=TokuDB; +insert into foo1 values(1); + +connection default; +--error ER_TABLE_DEF_CHANGED +select * from foo1; + +connection default; +disconnect conn1; + +connection default; +# Final cleanup. +set session transaction isolation level serializable; +DROP TABLE foo,foo1;
\ No newline at end of file |