Subject Re: [ib-support] Re: integer division & casting
Author Víctor Barcaz González
Hello,

I executed the same script on WI-V6.2.794 Firebird 1.0,
Win98 all updates, Celeron system...

and got the same result

c> Hmmm, this is getting interesting. I executed the exact same code on
c> WI-V6.2.794 Firebird 1.0, NT4sp6, AMD Duron system...

c> you got a result of: 29.4151
c> I got a result of: 31.302

c> Can we get some confirmation on this from other linux and win users,
c> please...

c> Here's my DDL/DML for double-checking...

c> SET TERM ^ ;
c> CREATE PROCEDURE SP_TEST_2
c> (PAR INTEGER)
c> RETURNS (RESULT NUMERIC(15,4))
c> AS
c> begin
c> result = Par / Par + 1 * 3.1415 + 5.4321 * 5 - 4 / 9 * 4.2456;
c> end
c> ^
c> SET TERM ; ^

c> execute procedure sp_test_2(9);

c> Procedure executing results:
c> RESULT = 31.302