Implement new 16 byte floating point datatype
---------------------------------------------
Key: CORE-4188
URL: http://tracker.firebirdsql.org/browse/CORE-4188
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Affects Versions: 3.0 Alpha 1
Reporter: Pavel Zotov
Priority: Minor
Usage of DOUBLE type often leads to wrong results, e.g.:
POWER(2, 52) gives *odd* number (this can not occur with any power of 2 except
0),
POWER(3, 38) gives 1350851717672992000 rather than (correct)
1350851717672992089 (delta = 89)
and so on.
This errors can lead to wrong result of calculations even with numbers of small
magnitude, e.g:
SQL> set list on; select mon$sql_dialect from mon$database;
MON$SQL_DIALECT 3
SQL> select round(1608.90 * 5 / 100, 2) from rdb$database;
ROUND 80.44 -- NB: correct result is 80.45 !
SQL> show version;
ISQL Version: LI-T3.0.0.30590 Firebird 3.0 Alpha 1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T3.0.0.30590 Firebird
3.0 Alpha 1"
I think that necessity of new datatype (maybe name it "EXTENDED" ?) is evident.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Introducing Performance Central, a new site from SourceForge and
AppDynamics. Performance Central is your source for news, insights,
analysis and resources for efficient Application Performance Management.
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
