这是函数
CREATE FUNCTION myFunction (rootId VARCHAR(255))
RETURNS VARCHAR(255)
BEGIN
DECLARE sTemp VARCHAR (1000);
DECLARE sTempChd VARCHAR (1000);
SET sTemp = '$';
SET sTempChd = cast(rootId AS CHAR);
WHILE sTempChd IS NOT NULL DO
SET sTemp = concat(sTemp, ',', sTempChd);
SELECT
group_concat(TASKCODE) INTO sTempChd
FROM
treeNodes
WHERE
FIND_IN_SET(PARENTCODE, sTempChd) > 0;
END
WHILE;
END
这是错误
[Err] 1320 - No RETURN found in FUNCTION salestest.myFunction