diff options
| author | serg@serg.mysql.com <> | 2001-10-20 16:37:26 +0200 |
|---|---|---|
| committer | serg@serg.mysql.com <> | 2001-10-20 16:37:26 +0200 |
| commit | c4229a8dcdcdac7d69ca37a2bc4ebfa8ebae5a0f (patch) | |
| tree | 9204318ede8dbfbab0c53a870efc455a248b40cd /mysql-test/r/fulltext.result | |
| parent | ccb7bb485b050c195cf1416ec1e069e99df31e5d (diff) | |
| download | mariadb-git-c4229a8dcdcdac7d69ca37a2bc4ebfa8ebae5a0f.tar.gz | |
two bugs in ft_update
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -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 |