diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_bugs/r/3083.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb_bugs/r/3083.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/r/3083.result b/storage/tokudb/mysql-test/tokudb_bugs/r/3083.result new file mode 100644 index 00000000000..fd8b98076fa --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb_bugs/r/3083.result @@ -0,0 +1,23 @@ +SET DEFAULT_STORAGE_ENGINE = 'tokudb'; +DROP TABLE IF EXISTS foo; +set session tokudb_prelock_empty=0; +create table foo (a int, b int, c int, primary key (a), key (b) clustering=yes); +insert into foo values (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5); +# Both explains should use primary key; +explain select * from foo; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE foo ALL NULL NULL NULL NULL 5 +explain select a from foo; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE foo index NULL PRIMARY 4 NULL 5 Using index +DROP table foo; +create table foo (a int, b int, c int, key (b) clustering=yes, primary key (a)); +insert into foo values (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5); +# Both explains should use primary key; +explain select * from foo; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE foo ALL NULL NULL NULL NULL 5 +explain select a from foo; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE foo index NULL PRIMARY 4 NULL 5 Using index +DROP TABLE foo; |