summaryrefslogtreecommitdiff
path: root/mysql-test/r/analyze.result
diff options
context:
space:
mode:
authorunknown <SergeyV@selena.>2005-11-23 18:18:41 +0300
committerunknown <SergeyV@selena.>2005-11-23 18:18:41 +0300
commit147be17067dc699aec2f12e7a52992ffc329d8b1 (patch)
treef9ea928b82ec56b1452eec4323f6459b725d3bd3 /mysql-test/r/analyze.result
parent14637f97cdd7ff4a7d60c09052e2e280ee57c957 (diff)
downloadmariadb-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/r/analyze.result')
-rw-r--r--mysql-test/r/analyze.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/analyze.result b/mysql-test/r/analyze.result
index 0b44a502b13..3ccc3566432 100644
--- a/mysql-test/r/analyze.result
+++ b/mysql-test/r/analyze.result
@@ -30,3 +30,12 @@ check table t1;
Table Op Msg_type Msg_text
test.t1 check status OK
drop table t1;
+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;
+Table Op Msg_type Msg_text
+test.t1 analyze status OK
+analyze table t1;
+Table Op Msg_type Msg_text
+test.t1 analyze status Table is already up to date
+drop table t1;