diff options
author | sasha@mysql.sashanet.com <> | 2001-03-01 11:49:06 -0700 |
---|---|---|
committer | sasha@mysql.sashanet.com <> | 2001-03-01 11:49:06 -0700 |
commit | bc52b4a28032c8922099bd9d59986d7874feec8e (patch) | |
tree | 2e4d93e47910811a9995561ff75ede1c04afc2d1 /mysql-test/t/fulltext.test | |
parent | 21c601760c3bf85d16503e484155d49c0495d092 (diff) | |
download | mariadb-git-bc52b4a28032c8922099bd9d59986d7874feec8e.tar.gz |
text/blob fields in some cases were not handled properly
Diffstat (limited to 'mysql-test/t/fulltext.test')
-rw-r--r-- | mysql-test/t/fulltext.test | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 555c543664e..29c115f2bdd 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -48,8 +48,8 @@ drop table t1,t2; # check for bug reported by Stephan Skusa -drop table if exists fulltextTEST; -CREATE TABLE fulltextTEST ( +drop table if exists t1; +CREATE TABLE t1 ( field1 varchar(40) NOT NULL, field2 varchar(20) NOT NULL, field3 varchar(40) NOT NULL, @@ -57,9 +57,10 @@ CREATE TABLE fulltextTEST ( FULLTEXT idx_fulltext (field1, field2, field3) ); -INSERT INTO fulltextTEST VALUES ( 'test1', 'test1.1', 'test1.1.1'); -INSERT INTO fulltextTEST VALUES ( 'test2', 'test2.1', 'test2.1.1'); -select * -from fulltextTEST -where MATCH (field1,field2,field3) AGAINST (NULL); -drop table fulltextTEST; +INSERT INTO t1 VALUES ( 'test1', 'test1.1', 'test1.1.1'); +INSERT INTO t1 VALUES ( 'test2', 'test2.1', 'test2.1.1'); +#select * +#from t1 +#where MATCH (field1,field2,field3) AGAINST (NULL); +drop table t1; + |