diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_bugs/t/1913.test')
-rwxr-xr-x | storage/tokudb/mysql-test/tokudb_bugs/t/1913.test | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/t/1913.test b/storage/tokudb/mysql-test/tokudb_bugs/t/1913.test new file mode 100755 index 00000000000..18c8eb52ff9 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb_bugs/t/1913.test @@ -0,0 +1,27 @@ +# ticket 895 is a query optimization problem with the primary key + +--source include/have_tokudb.inc +SET DEFAULT_STORAGE_ENGINE = 'tokudb'; + +--disable_warnings +DROP TABLE IF EXISTS foo; +--enable_warnings +set session unique_checks=off; + +create table foo (a int, b int, c int, primary key (a), key(b)); +insert into foo values (1,10,100),(2,20,200),(3,30,300),(4,40,400),(5,50,500),(6,60,600); +explain select * from foo; +select * from foo; +explain select b from foo; +select b from foo; + +replace into foo values (1,1,1); +explain select * from foo; +select * from foo; +explain select b from foo; +select b from foo; + +set session unique_checks=on; + +# Final cleanup. +DROP TABLE foo;
\ No newline at end of file |