FULLTEXT search inside of a stored procedure
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 ?
Subject
Views
Written By
Posted
FULLTEXT search inside of a stored procedure
6734
October 24, 2007 01:30AM
3766
October 24, 2007 01:37AM
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.