wrong addition in select ------------------------ Key: CORE-3760 URL: http://tracker.firebirdsql.org/browse/CORE-3760 Project: Firebird Core Issue Type: Bug Affects Versions: 2.5.1, 2.1.4 Environment: Windows 7 Professional, Intel Core i5/i7 (multiple Machines), Dialect 1, Reporter: Jan Kohlmeyer
Hello, my select with a harmless addition brings a wrong result, this was executes with isql.exe: SQL> select 138 + 70 -79.86 - 85.27 from rdb$database; SUBTRACT ======================= 42.86999999999999 The correct result ist 42.87. You can also execute this: select 138 + 70 -79.86 - 85.27 from rdb$database where 138 + 70 -79.86 - 85.27 <> 42.87; And you will get a result. This is better if you are using an IDE that uses Displayformats, likeIBExpert, instead isql.exe. You can also create a table with this values and select them with the sum-function and you will recive a similar result: SQL> select sum(test) from tbltest having sum(test) <> 42.87; SUM ======================= 42.87 Here is the Script to create the table: CREATE TABLE tbltest ( ID INTEGER NOT NULL, test numeric(15,2), CONSTRAINT PK_tbltest PRIMARY KEY (ID)); INSERT INTO tbltest (ID, test) VALUES (1, 138); INSERT INTO tbltest (ID, test) VALUES (2, 70); INSERT INTO tbltest (ID, test) VALUES (3, -79.86); INSERT INTO tbltest (ID, test) VALUES (4, -85.27); Greetings Jan -- 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 ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel