Re: Variable in LIMIT clause

[Kian Ryan]

Ah, I'm not the only person then whos discovered this problem.

I've got a slightly prettier workaround than some of the other's I've seen. It's using user variables again as local versions of the procedureal parameters.

--SQL--

DROP PROCEDURE IF EXISTS get_product_range $$
CREATE PROCEDURE get_product_range (
IN _START INTEGER,
IN _LIMIT INTEGER
)
BEGIN
PREPARE STMT FROM
" SELECT *
FROM products LIMIT ?,? ";
SET @START = _START;
SET @LIMIT = _LIMIT;
EXECUTE STMT USING @START, @LIMIT; /* Known bug in mySQL5 - exists as feature req. */
END $$

--SQL--

It should also make it pretty straightforward to strip out the extra details when this bug/feature (how on earth can this be a feature?) is fixed in a later version.