diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_bugs/r/db756_card_part_hash_1_pick.result')
| -rw-r--r-- | storage/tokudb/mysql-test/tokudb_bugs/r/db756_card_part_hash_1_pick.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_bugs/r/db756_card_part_hash_1_pick.result b/storage/tokudb/mysql-test/tokudb_bugs/r/db756_card_part_hash_1_pick.result new file mode 100644 index 00000000000..576d1adee6c --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb_bugs/r/db756_card_part_hash_1_pick.result @@ -0,0 +1,21 @@ +set default_storage_engine='tokudb'; +drop table if exists t; +create table t (id int, x int, primary key (id), key (x)) partition by hash(id) partitions 2; +show indexes from t; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment +t 0 PRIMARY 1 id A 2 NULL NULL BTREE +t 1 x 1 x A NULL NULL NULL YES BTREE +insert into t values (1,1),(3,2),(5,3); +insert into t values (2,1),(4,1),(6,1),(8,1); +show indexes from t; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment +t 0 PRIMARY 1 id A 7 NULL NULL BTREE +t 1 x 1 x A NULL NULL NULL YES BTREE +analyze table t; +Table Op Msg_type Msg_text +test.t analyze status OK +show indexes from t; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment +t 0 PRIMARY 1 id A 7 NULL NULL BTREE +t 1 x 1 x A 1 NULL NULL YES BTREE +drop table t; |