diff options
| author | unknown <serg@serg.mysql.com> | 2002-05-07 18:27:39 +0000 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2002-05-07 18:27:39 +0000 |
| commit | 3e404b750c6121b77531160ec3b590fba393bcf7 (patch) | |
| tree | e9bee3f55ed25deedaa5f52a52658b1252643623 /mysql-test | |
| parent | 90bd3236370ea78ee3a1e6bc04620093c08d4035 (diff) | |
| download | mariadb-git-3e404b750c6121b77531160ec3b590fba393bcf7.tar.gz | |
"duplicated rows" bug
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/fulltext.result | 5 | ||||
| -rw-r--r-- | mysql-test/t/fulltext.test | 4 |
2 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index e8d9c9aa708..5ee90c38585 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -173,4 +173,9 @@ CREATE TABLE t1 (a int(11), b text, FULLTEXT KEY (b)) TYPE=MyISAM; insert into t1 values (1,"I wonder why the fulltext index doesnt work?"); SELECT * from t1 where MATCH (b) AGAINST ('apples'); a b +insert into t1 values (2,"fullaaa fullzzz"); +select * from t1 where match b against ('full*' in boolean mode); +a b +2 fullaaa fullzzz +1 I wonder why the fulltext index doesnt work? drop table t1; diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 0334910fe6c..a7a40706e89 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -145,4 +145,8 @@ CREATE TABLE t1 (a int(11), b text, FULLTEXT KEY (b)) TYPE=MyISAM; insert into t1 values (1,"I wonder why the fulltext index doesnt work?"); SELECT * from t1 where MATCH (b) AGAINST ('apples'); +insert into t1 values (2,"fullaaa fullzzz"); +select * from t1 where match b against ('full*' in boolean mode); + drop table t1; + |