MySQL Forums
Forum List  »  Full-Text Search

FULLTEXT search inside of a stored procedure
Posted by: Anton Staykov
Date: October 24, 2007 01:30AM

Hi,
(MySQL version: 5.0.37-log)
I have strange problem trying to perform fulltext search inside of a stored procedure.
If I run a stand-alone query like:
SELECT
distinct(address_id), address, city
FROM
tbl_addresses
WHERE
city = "some city" AND
match(address) against("some address")
having address = "some address"
There is no problem.
BUT
When I put this query inside of a stored procedure, the mysql says I have an error in my query (Error Code : 1064) . After several minutes wandering what could cause the problem I noticed that if I remove the HAVING clause, it creates the procedure with no problem. But if I put back the HAVING - the creation fails ....
Does anyone know what could the problem be ?

Options: ReplyQuote


Subject
Views
Written By
Posted
FULLTEXT search inside of a stored procedure
6622
October 24, 2007 01:30AM


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.