Null result set returning
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,
PRIMARY KEY (id),
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