diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/r/card_drop_index.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb/r/card_drop_index.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/r/card_drop_index.result b/storage/tokudb/mysql-test/tokudb/r/card_drop_index.result index 2cfdfe11296..f924c8cd12b 100644 --- a/storage/tokudb/mysql-test/tokudb/r/card_drop_index.result +++ b/storage/tokudb/mysql-test/tokudb/r/card_drop_index.result @@ -1,5 +1,7 @@ set default_storage_engine='tokudb'; drop table if exists tt; +set @save_use_stat_tables = @@use_stat_tables; +set @@use_stat_tables = COMPLEMENTARY; create table tt (a int, b int, c int, key(b), key(c), primary key(a)); insert into tt values (1,0,0),(2,0,0),(3,0,1),(4,0,1); show indexes from tt; @@ -9,6 +11,7 @@ tt 1 b 1 b A 4 NULL NULL YES BTREE tt 1 c 1 c A 4 NULL NULL YES BTREE analyze table tt; Table Op Msg_type Msg_text +test.tt analyze status Engine-independent statistics collected test.tt analyze status OK show indexes from tt; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment @@ -28,4 +31,5 @@ flush tables; show indexes from tt; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment tt 0 PRIMARY 1 a A 4 NULL NULL BTREE +set @@use_stat_tables = @save_use_stat_tables; drop table tt; |