summaryrefslogtreecommitdiff
path: root/mysql-test/t/fulltext2.test
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2004-09-03 22:04:08 +0200
committerunknown <serg@serg.mylan>2004-09-03 22:04:08 +0200
commitf45655138e52808f691329d0ab4572bd9074e1c9 (patch)
tree053c8ad4d9647677258e7d0f66086adb673e3149 /mysql-test/t/fulltext2.test
parentf7f85eb664fc2308ad34b6d28c5f6aaa3934cca8 (diff)
downloadmariadb-git-f45655138e52808f691329d0ab4572bd9074e1c9.tar.gz
BUG#5327 - mi_sort_index() of 2-level tree
Diffstat (limited to 'mysql-test/t/fulltext2.test')
-rw-r--r--mysql-test/t/fulltext2.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext2.test b/mysql-test/t/fulltext2.test
index cab1d096fe7..1d3a5307412 100644
--- a/mysql-test/t/fulltext2.test
+++ b/mysql-test/t/fulltext2.test
@@ -44,6 +44,9 @@ while ($1)
# converting to two-level
repair table t1 quick;
+check table t1;
+optimize table t1; # BUG#5327 - mi_sort_index() of 2-level tree
+check table t1;
select count(*) from t1 where match a against ('aaaxxx');
select count(*) from t1 where match a against ('aaayyy');
@@ -102,6 +105,11 @@ CREATE TABLE t1 (
FULLTEXT KEY (a)
) ENGINE=MyISAM;
+#
+# now same as about but w/o repair table
+# 2-level tree created by mi_write
+#
+
# two-level entry, second-level tree with depth 2
--disable_query_log
let $1=260;