SELECT cast((5411.000455/0.20) as numeric(16,6)) as mount FROM
MON$ATTACHMENTS r
This particular query can be rewritten as
SELECT 5411.000455*cast(1/0.20 as integer) as mount FROM MON$ATTACHMENTS r
Though it will not work equally well with other numbers, at least not if
||
=
- Original Message -
From: Svein Erling Tysvær
To: 'firebird-support@yahoogroups.com'
Sent: Thursday, March 29, 2012 3:24 AM
Subject: RE: [firebird-support] Arithmetic overflow or division by zero has
occurred.
SELECT cast((5411.000455/0.20) as numeric(16,6)) as mount FROM
FB 2.5.1 superclasic
SELECT cast((5411.000455/0.20) as numeric(16,6)) as mount
FROM MON$ATTACHMENTS r
*** IBPP::SQLException ***
Context: Statement::Fetch
Message: isc_dsql_fetch failed.
SQL Message : -802
Arithmetic overflow or division by zero has occurred.
Engine Code: 335544321