Bugs item #2921310, was opened at 2009-12-26 06:01 Message generated for change (Tracker Item Submitted) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2921310&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: SQL: return null for summation of two small values Initial Comment: sql>select (4.4054292 - 4.40572025343667)^2; +------------------------+ | sql_sub_single_value | +========================+ | 8.4712102997417702e-08 | +------------------------+ 1 tuple sql>select (52.0903881 - 52.091375762174)^2; +------------------------+ | sql_sub_single_value | +========================+ | 9.7547656995040638e-07 | +------------------------+ 1 tuple sql>select (4.4054292 - 4.40572025343667)^2 + (52.0903881 - 52.091375762174)^2; +------------------------+ | sql_sub_single_value | +========================+ | null | +------------------------+ 1 tuple I would expect 1.0602e-06. As the outcome of the following would be: sql>select cast((4.4054292 - 4.40572025343667)^2 as double) + cast((52.0903881 - 52.091375762174)^2 as double); +------------------------+ | sql_sub_single_value | +========================+ | 1.0601886729478242e-06 | +------------------------+ 1 tuple sql>select cast((4.4054292 - 4.40572025343667)^2 + (52.0903881 - 52.091375762174)^2 as double); +------------------------+ | sql_sub_single_value | +========================+ | null | +------------------------+ 1 tuple ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2921310&group_id=56967 ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
