diff options
| author | unknown <serg@serg.mysql.com> | 2001-10-20 16:37:26 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2001-10-20 16:37:26 +0200 |
| commit | b09eb958698a8a984ea8efccec08e25238f3bf3a (patch) | |
| tree | 9204318ede8dbfbab0c53a870efc455a248b40cd /mysql-test/t/fulltext.test | |
| parent | dd5f9b4a4fd2c021f3ce7d92b87014eca847f359 (diff) | |
| download | mariadb-git-b09eb958698a8a984ea8efccec08e25238f3bf3a.tar.gz | |
two bugs in ft_update
myisam/ft_update.c:
two bugfixes
mysql-test/r/fulltext.result:
new tests
mysql-test/t/fulltext.test:
new tests
Diffstat (limited to 'mysql-test/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 4f7df2ac0b0..af58c747167 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -92,3 +92,22 @@ select * from t2 where MATCH ticket AGAINST ('foobar'); select * from t2,t3 where MATCH (t2.inhalt,t3.inhalt) AGAINST ('foobar'); drop table t1,t2,t3; + +# +# two more bugtests +# + +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; +update t1 set title='this test once revealed a bug' where id=1; +select * from t1; + |