diff options
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/fulltext.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 47a823929f4..c2b4de5f439 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -112,3 +112,19 @@ Can't find FULLTEXT index matching the column list select * from t2,t3 where MATCH (t2.inhalt,t3.inhalt) AGAINST ('foobar'); Wrong arguments to MATCH drop table t1,t2,t3; +CREATE TABLE t1 ( +id int(11) auto_increment, +title varchar(100) default '', +PRIMARY KEY (id), +KEY ind5 (title), +FULLTEXT KEY FT1 (title) +) TYPE=MyISAM; +insert into t1 (title) values ('this is a test'); +update t1 set title='this is A test' where id=1; +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +update t1 set title='this test once revealed a bug' where id=1; +select * from t1; +id title +1 this test once revealed a bug |