1# test that add index keeps cardinality for older indexes 2 3source include/have_tokudb.inc; 4set default_storage_engine='tokudb'; 5 6disable_warnings; 7drop table if exists tt; 8enable_warnings; 9 10set @save_use_stat_tables = @@use_stat_tables; 11set @@use_stat_tables = COMPLEMENTARY; 12 13create table tt (a int, b int, c int, primary key(a), key(b), key(c)); 14let $a=0; 15while ($a < 500) { 16 eval insert into tt values ($a, $a, 0), ($a+1, $a, 0), ($a+2, $a, 0), ($a+3, $a, 0); 17 inc $a; inc $a; inc $a; inc $a; 18} 19select count(*) from tt; 20 21# compute cardinality 22show indexes from tt; 23analyze table tt; 24show indexes from tt; 25 26# drop key b 27alter table tt drop key b; 28show indexes from tt; 29 30# drop key c 31alter table tt drop key c; 32show indexes from tt; 33 34# test that cardinality is persistent 35flush tables; 36show indexes from tt; 37 38set @@use_stat_tables = @save_use_stat_tables; 39drop table tt; 40