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/r/fulltext.result | |
| 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/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 11 |
1 files changed, 11 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; |