summaryrefslogtreecommitdiff
path: root/mysql-test/t/analyze.test
diff options
context:
space:
mode:
authorunknown <SergeyV@selena.>2005-12-01 20:29:48 +0300
committerunknown <SergeyV@selena.>2005-12-01 20:29:48 +0300
commit9dcae0472cacaab1ee00b99321c820f0e8ab1af3 (patch)
tree07f333115d4887c14494bf77b99ca19999ff34ef /mysql-test/t/analyze.test
parentbabaa74e8a2c6548a726ace86ab1cf0c7c323e0e (diff)
parent147be17067dc699aec2f12e7a52992ffc329d8b1 (diff)
downloadmariadb-git-9dcae0472cacaab1ee00b99321c820f0e8ab1af3.tar.gz
Merge svlasenko@bk-internal.mysql.com:/home/bk/mysql-5.0
into selena.:H:/MYSQL/src/#14902-mysql-5.0 mysql-test/r/analyze.result: SCCS merged mysql-test/t/analyze.test: SCCS merged
Diffstat (limited to 'mysql-test/t/analyze.test')
-rw-r--r--mysql-test/t/analyze.test14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/analyze.test b/mysql-test/t/analyze.test
index 5d653b65579..656ff752c9b 100644
--- a/mysql-test/t/analyze.test
+++ b/mysql-test/t/analyze.test
@@ -39,6 +39,20 @@ 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;
+
#
# procedure in PS BUG#13673
#