| Subject | query Integer overflow |
|---|---|
| Author | Mr. John |
| Post date | 2019-06-22T19:47:37Z |
Hi
I'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64:
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Integer overflow. The result of an integer operation caused the most significant bit of the result to carry.
on this query
SELECT b.cant* IIF(b.PR_EAT_T<>0, b.PR_EAT_T-b.PR_EAT_T* b.P_TV_E /(100+b.P_TV_E), b.PR_I)
FROM GS_FIED a INNER JOIN GS_FIEP b on a.id=b.id_doc
cant NUMERIC(15,4)
PR_EAT_T NUMERIC(16,4)
P_TV_E NUMERIC (9,2)
PR_I NUMERIC(16,4)
I have 2 records with same values:
cant =5993.3160
PR_EAT_T=0.0000
P_TV_E=0.00
PR_I= 1580.3472
thanks