MYSQL 自定义函数

DELIMITER $
DROP FUNCTION IF EXISTS ownProjectPermis$
CREATE FUNCTION ownProjectPermis(userId varchar(64), projectId varchar(64)) RETURNS int(2)
    READS SQL DATA
BEGIN
    DECLARE flag boolean;
    set @userId = userId;
    set @projectId = projectId;
    set flag = if((select 1
                from biz_project p
                where id = @projectId
                  and exists(select 1
                             from sys_user u
                             where u.id = @userId and (u.project_all_permission = 1 or u.factory_id = p.factory_id)))=1,true,false);
    return flag;
END $;