diff options
| author | unknown <serg@sergbook.mysql.com> | 2003-04-23 15:44:39 +0400 |
|---|---|---|
| committer | unknown <serg@sergbook.mysql.com> | 2003-04-23 15:44:39 +0400 |
| commit | b21a0be804fbff458ffbfff4e01f28f8730d3820 (patch) | |
| tree | 77d6919fed33367fdbbc9be69c2422b18bc0d16b /mysql-test | |
| parent | 29b593987d81b987a0feb1750afec23bd8cac9c7 (diff) | |
| download | mariadb-git-b21a0be804fbff458ffbfff4e01f28f8730d3820.tar.gz | |
bug 283: FULLTEXT index on a TEXT filed converted to a CHAR field doesn't work anymore
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/fulltext.result | 11 | ||||
| -rw-r--r-- | mysql-test/t/fulltext.test | 13 |
2 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index edf109fcc93..eaaaf9c8880 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -215,3 +215,14 @@ test.t1 repair status OK select * from t1 where match (a) against ('aaaa'); a drop table t1; +drop table if exists t1; +create table t1 ( ref_mag text not null, fulltext (ref_mag)); +insert into t1 values ('test'); +select ref_mag from t1 where match ref_mag against ('+test' in boolean mode); +ref_mag +test +alter table t1 change ref_mag ref_mag char (255) not null; +select ref_mag from t1 where match ref_mag against ('+test' in boolean mode); +ref_mag +test +drop table t1; diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 5a64f2614aa..128af680854 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -173,3 +173,16 @@ repair table t1; select * from t1 where match (a) against ('aaaa'); drop table t1; +# +# bug 283 by jocelyn fournier <joc@presence-pc.com> +# FULLTEXT index on a TEXT filed converted to a CHAR field doesn't work anymore +# + +drop table if exists t1; +create table t1 ( ref_mag text not null, fulltext (ref_mag)); +insert into t1 values ('test'); +select ref_mag from t1 where match ref_mag against ('+test' in boolean mode); +alter table t1 change ref_mag ref_mag char (255) not null; +select ref_mag from t1 where match ref_mag against ('+test' in boolean mode); +drop table t1; + |