Subject Re: [firebird-support] ERROR: arithmetic exception in select statement
Author Svein Erling Tysvaer
I tried

SELECT (1000000 * 0.029717682) * 200000 FROM rdb$database

on a Firebird 1.5.2 database (through DB Workbench) and I didn't have
any problems. What tool are you using for executing this query and what
dialect is the database?

Set

elkins_villalona wrote:
> Hello
> I need some help to understand the ISC ERROR CODE:335544321 comming
> from the firebird engine(version 1.5.3) when i try the following sql
> statement
>
> SELECT (1000000 * 0.029717682) * 20 FROM ANY_TABLE.
>
> If i use
>
> SELECT (1000000 * 0.029717682) * 2 FROM ANY_TABLE
>
> it works fine.
>
> Thanks in advance
>
> Elkins