SQL Query gives result but when inserted to a table it fails [duplicate]

[Vishal Lavti]

I have a strange problem and need help/explanation and workaround.

SELECT
SUM(value)
FROM
account a,
colorCarrier p
WHERE
a.accountid= p.id
GROUP BY m1here
In original tables, accountid is varchar and id is bigint. The value column is double and amount column in tempTable is also double.

The above query returns the result fine but when I try to insert the data in a table, it fails with Error Code: 1292. Truncated incorrect DOUBLE value

insert into tempTable (amount)
SELECT
SUM(value)
FROM
account a,
colorCarrier p
WHERE
a.accountid= p.id
GROUP BY m1
What I am not able to understand is why does it have problem only when the data is inserted into table? Why the query returns the results fine when executed seperately? What can I do to resolve this issue?

The above query is being generated dynamically so I can't use cursor either.