获取错误代码:1292 在存储过程中截断了不正确的 DOUBLE 值? [英] getting Error Code: 1292 Truncated incorrect DOUBLE value in stored procedure?
本文介绍了获取错误代码:1292 在存储过程中截断了不正确的 DOUBLE 值?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在写一个程序 -
DELIMITER $$
USE `genome`$$
DROP PROCEDURE IF EXISTS `get_family`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `get_family`(p_h INT(10))
BEGIN
DECLARE rv,q,queue,queue_children VARCHAR(1024);
DECLARE queue_length,front_id,pos INT;
SET rv = '';
SET queue = p_h;
SET queue_length = 1;
WHILE queue_length > 0 DO
SET front_id = FORMAT(queue,0);
IF queue_length = 1 THEN
SET queue = '';
ELSE
SET pos = LOCATE(',',queue) + 1;
SET q = SUBSTR(queue,pos);
SET queue = q;
END IF;
SET queue_length = queue_length - 1;
SELECT IFNULL(qc,'') INTO queue_children
FROM (SELECT GROUP_CONCAT(id) qc
FROM folder WHERE parent = front_id) A;
IF LENGTH(queue_children) = 0 THEN
IF LENGTH(queue) = 0 THEN
SET queue_length = 0;
END IF;
ELSE
IF LENGTH(rv) = 0 THEN
SET rv = queue_children;
ELSE
SET rv = CONCAT(rv,',',queue_children);
END IF;
IF LENGTH(queue) = 0 THEN
SET queue = queue_children;
ELSE
SET queue = CONCAT(queue,',',queue_children);
END IF;
SET queue_length = LENGTH(queue) - LENGTH(REPLACE(queue,',','')) + 1;
END IF;
END WHILE;
SELECT rv FROM DUAL;
END$$
DELIMITER ;
它成功了,但是当我调用 proc 时,它给了我错误 -
It succeeded, but when I am calling the proc, it gives me error -
call get_family(117);
Error Code: 1292
Truncated incorrect DOUBLE value: '118,119,120,124'
但是当我在程序中传递相同的 116 时,它工作正常.我哪里做错了.请告诉我.
But when i am passing the same 116 in the procedure, its working fine. Where i am doing wrong. Please let me know.
推荐答案
好的,我找到了解决方案.
Ok I got the solution.
我只是将 varchar(我认为输出很长)类型更改为顶部的文本,现在它可以正常工作了.
I simply changed the varchar(output was long i think) type to text on the top, now its working properly.
这篇关于获取错误代码:1292 在存储过程中截断了不正确的 DOUBLE 值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文