diff options
| author | SergeyV@selena. <> | 2005-11-23 18:18:41 +0300 |
|---|---|---|
| committer | SergeyV@selena. <> | 2005-11-23 18:18:41 +0300 |
| commit | e4cfca0758fc2a9128c50305c45d8b89f4efecc2 (patch) | |
| tree | f9ea928b82ec56b1452eec4323f6459b725d3bd3 /mysql-test/t/analyze.test | |
| parent | 43bbd352e3aa4af23f479e33ba80a6dfdeb6774f (diff) | |
| download | mariadb-git-e4cfca0758fc2a9128c50305c45d8b89f4efecc2.tar.gz | |
Fixes bug #14902. When analysing a table with FT index that contains stopwords
table statistics is not updated, so the next execution of analyze table will
try to update statistics again.
Diffstat (limited to 'mysql-test/t/analyze.test')
| -rw-r--r-- | mysql-test/t/analyze.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/analyze.test b/mysql-test/t/analyze.test index 3c3b3933bc3..9d94f5da9d9 100644 --- a/mysql-test/t/analyze.test +++ b/mysql-test/t/analyze.test @@ -39,4 +39,18 @@ check table t1; drop table t1; +# Bug #14902 ANALYZE TABLE fails to recognize up-to-date tables +# minimal test case to get an error. +# The problem is happening when analysing table with FT index that +# contains stopwords only. The first execution of analyze table should +# mark index statistics as up to date so that next execution of this +# statement will end up with Table is up to date status. +create table t1 (a mediumtext, fulltext key key1(a)) charset utf8 collate utf8_general_ci engine myisam; +insert into t1 values ('hello'); + +analyze table t1; +analyze table t1; + +drop table t1; + # End of 4.1 tests |