summaryrefslogtreecommitdiff
path: root/mysql-test/t/fulltext2.test
diff options
context:
space:
mode:
authorserg@serg.mylan <>2004-09-03 22:04:08 +0200
committerserg@serg.mylan <>2004-09-03 22:04:08 +0200
commit9b0468bc96e10ddf28b3541e8a64d7472620f0fa (patch)
tree053c8ad4d9647677258e7d0f66086adb673e3149 /mysql-test/t/fulltext2.test
parente66d0fa7d83339880c72e84181794c9851babe18 (diff)
downloadmariadb-git-9b0468bc96e10ddf28b3541e8a64d7472620f0fa.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;