DELIMITER $$
CREATE FUNCTION getChildList (rootId VARCHAR(50)) RETURNS varchar(1000)
BEGIN
DECLARE sChildList VARCHAR(1000);
DECLARE sChildTemp VARCHAR(1000);
SET sChildTemp =cast(rootId as CHAR);
WHILE sChildTemp is not null DO
IF (sChildList is not null) THEN
SET sChildList = concat(sChildList,'@',sChildTemp);
ELSE
SET sChildList = concat (sChildTemp);
END IF;
SELECT group_concat(bop_object_id) INTO sChildTemp FROM base_bs_recycle_oldpath where FIND_IN_SET(bop_fol_id,sChildTemp)>0;
END WHILE;
RETURN sChildList;
END;
CREATE FUNCTION getChildList (rootId VARCHAR(50)) RETURNS varchar(1000)
BEGIN
DECLARE sChildList VARCHAR(1000);
DECLARE sChildTemp VARCHAR(1000);
SET sChildTemp =cast(rootId as CHAR);
WHILE sChildTemp is not null DO
IF (sChildList is not null) THEN
SET sChildList = concat(sChildList,'@',sChildTemp);
ELSE
SET sChildList = concat (sChildTemp);
END IF;
SELECT group_concat(bop_object_id) INTO sChildTemp FROM base_bs_recycle_oldpath where FIND_IN_SET(bop_fol_id,sChildTemp)>0;
END WHILE;
RETURN sChildList;
END;