Subject Re: [firebird-support] query Integer overflow
Author Dimitry Sibiryakov
22.06.2019 21:47, 'Mr. John' mr_johnmr@... [firebird-support] wrote:
> I'm facing with this error on FB 2.5.8(latest stable version)/ W10 x64

My advice is "never perform calculations (especially multiplication and division) in SQL".
Your expression has result of type NUMERIC(18,14) and result of calculation is bigger
than 9999.


--
WBR, SD.