Any reason I haven't heard back about this bug? Thanks _____
From: Gene Connor [mailto:[email protected]] Sent: Wednesday, April 30, 2014 12:21 AM To: [email protected] Subject: Bug in division? SELECT DISTINCT 2/4 AS RESULT FROM TABLE; returns 0 SELECT DISTINCT 2/4.0 AS RESULT FROM TABLE; returns 0.5 (correct) SELECT DISTINCT 2.0/4 AS RESULT FROM TABLE; returns 0.5 (correct) SELECT DISTINCT 2.0/4.0 AS RESULT FROM TABLE; returns 0.5 (correct) SELECT DISTINCT 2.0/4.01 AS RESULT FROM TABLE; returns 0.49875 (correct) As long as one or both numbers has at least one decimal place, it calcs correctly. Verified that it also happens in queries using tables and real data. Windows SQLite version 3.8.4.3 2014-04-03 16:53:12 Thanks _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
