diff options
| author | unknown <SergeyV@selena.> | 2005-11-23 18:18:41 +0300 |
|---|---|---|
| committer | unknown <SergeyV@selena.> | 2005-11-23 18:18:41 +0300 |
| commit | 147be17067dc699aec2f12e7a52992ffc329d8b1 (patch) | |
| tree | f9ea928b82ec56b1452eec4323f6459b725d3bd3 /mysql-test/t/analyze.test | |
| parent | 14637f97cdd7ff4a7d60c09052e2e280ee57c957 (diff) | |
| download | mariadb-git-147be17067dc699aec2f12e7a52992ffc329d8b1.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.
mysql-test/r/analyze.result:
Updated result file for bug #14902 test.
mysql-test/t/analyze.test:
Test for bug #14902.
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 |