summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorserg@serg.mysql.com <>2001-11-21 19:08:33 +0100
committerserg@serg.mysql.com <>2001-11-21 19:08:33 +0100
commit4151fd0a3c2756348708449eaccf12af29249550 (patch)
treee5e66fef97973125d8068ede40647d5a627ab434 /mysql-test
parent3e231a82062fdb5c06fe1f754dee3a9de6cc2d97 (diff)
parente8b45861e981f4084c4bb6697f173a8f3990194b (diff)
downloadmariadb-git-4151fd0a3c2756348708449eaccf12af29249550.tar.gz
broken merge, fix required
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/t/fulltext.test3
-rw-r--r--mysql-test/t/myisam.test12
2 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test
index 2608a9c02a6..81993b167c6 100644
--- a/mysql-test/t/fulltext.test
+++ b/mysql-test/t/fulltext.test
@@ -23,6 +23,9 @@ select * from t1 where MATCH(a,b) AGAINST("+search +(support vector)" IN BOOLEAN
select * from t1 where MATCH(a,b) AGAINST("+search -(support vector)" IN BOOLEAN MODE);
select *, MATCH(a,b) AGAINST("support collections" IN BOOLEAN MODE) as x from t1;
delete from t1 where a like "MySQL%";
+update t1 set a='some test foobar' where MATCH a,b AGAINST ('model');
+delete from t1 where MATCH(a,b) AGAINST ("indexes");
+select * from t1;
drop table t1;
#
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test
index 48a8b5d6c65..93462534b43 100644
--- a/mysql-test/t/myisam.test
+++ b/mysql-test/t/myisam.test
@@ -38,3 +38,15 @@ check table t1;
repair table t1;
check table t1;
drop table t1;
+
+#
+# Test bug: Two optimize in a row reset index cardinality
+#
+
+create table t1 (a int not null auto_increment, b int not null, primary key (a), index(b));
+insert into t1 (b) values (1),(2),(2),(2),(2);
+optimize table t1;
+show index from t1;
+optimize table t1;
+show index from t1;
+drop table t1;