MySQL Forums
Forum List  »  Full-Text Search

Null result set returning
Posted by: Daniel Neilsen
Date: November 17, 2005 12:17AM

Ever since I have upgraded to mysql 4.1.14 I have been having this issue in both my previously created databases and the new databases I am creating.
In 4.0.x I did not have any issue at all.

Here is a sample of the table and data I am using

CREATE TABLE supplier (
id bigint(20) NOT NULL auto_increment,
name varchar(64) NOT NULL default '',
contact varchar(64) default NULL,
UNIQUE KEY name (name),
FULLTEXT KEY name_search (name,contact),

INSERT INTO supplier (id, name, contact) VALUES (1, 'Test Supplier', 'Joe Smith');
INSERT INTO supplier (id, name, contact) VALUES (3, 'test joe', 'bla bla');

Now if I do this query
select * from supplier where match(name,contact) against ('test')
it will return both rows.... no problem

If I try this however
select * from supplier where match(name,contact) against ('supp')
I get no rows returned.... likewise for anything else I have tried.

Does anyone have any idea why this would be and how I can fix it?
Like I said, when I did this in 4.0.x it all seemed to work fine.

Thanks in Advance

Options: ReplyQuote

Written By
Null result set returning
November 17, 2005 12:17AM
November 17, 2005 12:54AM
November 17, 2005 12:55AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.