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