Hi all, I ve got some errors while making a query that managing match (full text) and union, both on boolean mode and the other mode. When I m working with "like" i get no error. I m working with mysql 4.01 4.02. Tables have the sames number of fields ... Indexes seems to have been created ...
See what type of query i make : SELECT 'FR' as lang,* FROM `Linux-FR`.Stories WHERE match (Summary,Content,Heading) against ('words' IN BOOLEAN MODE) AND Verified = 'Y' union SELECT 'US' as lang,* FROM `Linux-US`.Stories WHERE match (Summary,Content,Heading) against ('words' IN BOOLEAN MODE) AND Verified = 'Y' I get : Got error -1 from table handler here is the create statement CREATE TABLE `Stories` ( `Rid` varchar(16) NOT NULL default '', `Verified` char(1) default NULL, `Score` int(11) default NULL, `Heading` varchar(96) default NULL, `Summary` text, `Content` text, `Author` varchar(32) default NULL, `AuthorEmail` varchar(96) default NULL, `AuthorURL` varchar(96) default NULL, `Birthstamp` datetime default NULL, PRIMARY KEY (`Rid`), FULLTEXT KEY `Summary` (`Summary`,`Content`,`Heading`,`Author`), FULLTEXT KEY `Summary_2` (`Summary`,`Content`,`Heading`,`Author`), FULLTEXT KEY `Summary_3` (`Summary`,`Content`,`Heading`,`Author`), FULLTEXT KEY `Summary_4` (`Summary`,`Content`,`Heading`,`Author`), FULLTEXT KEY `Summary_5` (`Summary`,`Content`,`Heading`,`Author`) FULLTEXT KEY `Summary_6` (`Summary`,`Content`,`Heading`,`Author`) FULLTEXT KEY `Summary_7` (`Summary`,`Content`,`Heading`,`Author`) ) TYPE=MyISAM; Thanks. _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php