CREATE FUNCTION test()  RETURNS INT
DETERMINISTIC
BEGIN
DECLARE a,_limit INT;
SET _limit = 1;
SELECT id INTO a FROM Idea LIMIT _limit;
RETURN a;
END
|