CREATE FUNCTION test()
RETURNS VARCHAR(200)
BEGIN
    DECLARE ret VARCHAR(200);
    SELECT 'foo' INTO ret;
    RETURN ret;
END;