MySQL函数 查询树的父节点

DELIMITER $$
CREATE FUNCTION getParentList (rootId VARCHAR (50)) RETURNS VARCHAR (1000)
BEGIN
  DECLARE sParentList VARCHAR (1000) ;
  DECLARE sParentTemp VARCHAR(1000);
  SET sParentTemp =CAST(rootId AS CHAR);
  WHILE sParentTemp IS NOT NULL DO
  IF (sParentList IS NOT NULL) THEN
  SET sParentList = CONCAT(sParentTemp,'/',sParentList);
  ELSE
  SET sParentList = CONCAT(sParentTemp);
  END IF;
SELECT GROUP_CONCAT(dep_parent_id) INTO sParentTemp FROM DEPART_INFO WHERE FIND_IN_SET(dep_id,sParentTemp)>0;
END WHILE;
RETURN sParentList;
END $$
DELIMITER;

如果报如下错误：
　　Error Code: 1418. This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled 
    (you *might* want to use the less safe log_bin_trust_function_creators variable)

则执行下面sql:
set global log_bin_trust_function_creators=TRUE;