MySQL 存储过程不起作用，错误提示“Truncated wrong DOUBLE value"，错误发生在 MySQL 5.6.12，但同样适用于 5.6.19 [英] MySQL stored procedure doesn't work, error says "Truncated incorrect DOUBLE value", error occur on MySQL 5.6.12, but the same works on 5.6.19

问题描述

CREATE PROCEDURE `ROUTINE_CHECK_POLICY`(P_USERID INT(11), P_PRIV_ID INT, P_CUSTID INT(10), OUT F_FINAL_DEVICE_LIST varchar(600))
BEGIN

DECLARE F_USER_GROUP_LIST VARCHAR(300);

SELECT group_concat(concat(USER_USERGROUP_GROUP_ID) separator ',') INTO F_USER_GROUP_LIST
FROM   TBL_STD_USER_USERGROUP
where  USER_USERGROUP_USER_ID = P_USERID
AND    USER_USERGROUP_CUSTID  = P_CUSTID;

END

当我执行上面的存储过程如下调用 ROUTINE_CHECK_POLICY(1,3,1,@outparam);它说错误:截断了不正确的 DOUBLE 值

when i execute above stored procedure as below call ROUTINE_CHECK_POLICY(1,3,1,@outparam); it says error: Truncated incorrect DOUBLE value

Table TBL_STD_USER_USERGROUP have field USER_USERGROUP_USER_ID and USER_USERGROUP_CUSTID as int(11)

推荐答案

好的，我找到了解决方案.

Ok I got the solution.

我只是将顶部的 varchar(我认为输出很长)类型更改为 text，现在它可以正常工作了.

I simply changed the varchar(output was long I think) type to text on the top, now its working properly.

这篇关于MySQL 存储过程不起作用，错误提示“Truncated wrong DOUBLE value"，错误发生在 MySQL 5.6.12，但同样适用于 5.6.19的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！