Re: Boolean Fulltext in 4.0.2 bug

2002-03-26 Thread Sergei Golubchik
Hi! On Mar 22, Alexander Belyaev wrote: > Hi, > > I know, many fulltext bugs fixed last two weeks, thanks! > But this nice mysql4 feature are critical for us, we plan to use it in many > projects... and we test it again and again... :) > > My test case: > http://www.graphit.ru/fulltext402.tar.

Re: Boolean Fulltext in 4.0.2 bug

2002-03-22 Thread Alexander Belyaev
Hi, I know, many fulltext bugs fixed last two weeks, thanks! But this nice mysql4 feature are critical for us, we plan to use it in many projects... and we test it again and again... :) My test case: http://www.graphit.ru/fulltext402.tar.gz test.res - output from 4.0.2 cloned 2002-03-21. With

Re: Boolean Fulltext in 4.0.2 bug

2002-03-21 Thread Sergei Golubchik
Hi! On Mar 21, Alexander Belyaev wrote: > Hello, > > CREATE TABLE IF NOT EXISTS test ( > id mediumint(6) unsigned NOT NULL DEFAULT '0' , > txt text , > PRIMARY KEY (id) > ); > > #insert. 4 rows > > ALTER TABLE test ADD FULLTEXT findind (txt); > > select * from test where match(t

Boolean Fulltext in 4.0.2 bug

2002-03-21 Thread Alexander Belyaev
Hello, CREATE TABLE IF NOT EXISTS test ( id mediumint(6) unsigned NOT NULL DEFAULT '0' , txt text , PRIMARY KEY (id) ); #insert. 4 rows ALTER TABLE test ADD FULLTEXT findind (txt); select * from test where match(txt) against('+sony -playstation' in boolean mode) (25 rows returned