stored procedure not working on win 2k3
L P <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
Folks,
when I try and implement this stored procedure on mysql 5.0.18 running on
win 2k3, i get a 1064 error for syntax on the the following line:
select SQL_CALC_FOUND_ROWS * from currentbidding where expired='N' AND
match(itemname) against (? IN BOOLEAN MODE) limit ?,?
DELIMITER $$
DROP PROCEDURE IF EXISTS `emp`.`test4` $$
CREATE PROCEDURE `test4`(startRow int, pageSize int, keywords char(120))
BEGIN
set @sRow = startRow;
set @pSize = pageSize;
set @kWords = keywords;
prepare stmt from "select SQL_CALC_FOUND_ROWS * from currentbidding where
expired='N' AND match(itemname) against (? IN BOOLEAN MODE) limit ?,?";
execute stmt using @kWords, @sRow, @pSize;
select found_rows();
END $$
DELIMITER ;
Table definition:
CREATE TABLE "emp"."currentbidding" (
"itemid" int(10) unsigned NOT NULL auto_increment,
"itemName" varchar(120) NOT NULL default '',
"expired" char(1) NOT NULL default 'N',
PRIMARY KEY ("itemid"),
KEY "ActiveListing" ("expired"),
FULLTEXT KEY "fulltext" ("itemName")
);
The stored procedure works without any problems on windows xp with the same
version of mysql.
I just did a backup of the database and restored it on the win2k3 box and
get the
Any help is appreciated.
Thanks,
LP