Subject | Re: [ib-support] Re: integer division & casting |
---|---|
Author | Víctor Barcaz González |
Post date | 2002-05-30T19:55:08Z |
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
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