diff options
| author | unknown <serg@sergbook.mysql.com> | 2003-04-23 00:53:07 +0400 |
|---|---|---|
| committer | unknown <serg@sergbook.mysql.com> | 2003-04-23 00:53:07 +0400 |
| commit | b534154b12c6b592594588efb3dacc5dbf2e33e7 (patch) | |
| tree | a44e0d897043291528cd13d047883b02a400ae1f /mysql-test/t/alter_table.test | |
| parent | 8cad4f7090f50c19a1e0a247c57d9d965b7b7a6e (diff) | |
| download | mariadb-git-b534154b12c6b592594588efb3dacc5dbf2e33e7.tar.gz | |
do not mark the table as analyzed unless all the key parts are REALLY analyzed.
Diffstat (limited to 'mysql-test/t/alter_table.test')
| -rw-r--r-- | mysql-test/t/alter_table.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 1c3987e2a31..301a50bf07d 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -115,3 +115,19 @@ alter table t1 rename t2; alter table t2 rename t1, add c char(10) comment "no comment"; show columns from t1; drop table t1; + +# implicit analyze + +create table t1 (a int, b int); +let $1=100; +while ($1) +{ + eval insert into t1 values(1,$1), (2,$1), (3, $1); + dec $1; +} +alter table t1 add unique (a,b), add key (b); +show keys from t1; +analyze table t1; +show keys from t1; +drop table t1; + |