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
