存储过程在mysql5.1有返回但是在5.3或5.5无返回，怎么处理

存储过程在mysql5.1有返回但是在5.3或5.5无返回，怎么办？

SQL code

DELIMITER //CREATE PROCEDURE gennid ()BEGIN  DECLARE st VARCHAR(100);  START TRANSACTION;      IF NOT EXISTS (SELECT 1 FROM order_key) THEN  SET @sqlstr=CONCAT('insert into order_key select substring(`key`,8) from order', DATE_FORMAT(CURDATE(), '%Y%m'), ' order by id desc limit 1');  PREPARE st FROM @sqlstr;  EXECUTE st;  ELSE     UPDATE order_key SET id=id+1;  END IF;   SELECT id INTO @iid FROM order_key;  COMMIT;END//