Err 1292 - Truncated incorrect DOUBLE value:'70,40,77,28,23,72,82,38,29'
<p>When I execute this function like this:</p>

<p><a href="https://i.stack.imgur.com/bbQOU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bbQOU.png" alt="enter image description here"></a></p>

<p>This is my function defined:</p>

<pre><code>CREATE FUNCTION kyf_getFormationComat(heroSdIds VARCHAR(128), uid VARCHAR(128))
RETURNS INT(11)
BEGIN
    DECLARE comat INT(11);
    SET comat = (SELECT SUM(a.comat) FROM ky_heroinfo a WHERE a.uid = uid AND a.staticdata_id in (heroSdIds));
    RETURN comat;
END
</code></pre>