From bc52b4a28032c8922099bd9d59986d7874feec8e Mon Sep 17 00:00:00 2001 From: "sasha@mysql.sashanet.com" <> Date: Thu, 1 Mar 2001 11:49:06 -0700 Subject: text/blob fields in some cases were not handled properly --- mysql-test/t/fulltext.test | 17 +++++++++-------- 1 file changed, 9 insertions(+), 8 deletions(-) (limited to 'mysql-test/t/fulltext.test') 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; + -- cgit v1.2.1