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