diff options
author | serg@serg.mysql.com <> | 2001-11-21 19:08:33 +0100 |
---|---|---|
committer | serg@serg.mysql.com <> | 2001-11-21 19:08:33 +0100 |
commit | 4151fd0a3c2756348708449eaccf12af29249550 (patch) | |
tree | e5e66fef97973125d8068ede40647d5a627ab434 /mysql-test | |
parent | 3e231a82062fdb5c06fe1f754dee3a9de6cc2d97 (diff) | |
parent | e8b45861e981f4084c4bb6697f173a8f3990194b (diff) | |
download | mariadb-git-4151fd0a3c2756348708449eaccf12af29249550.tar.gz |
broken merge, fix required
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/t/fulltext.test | 3 | ||||
-rw-r--r-- | mysql-test/t/myisam.test | 12 |
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; |