Any reason I haven't heard back about this bug? Thanks _____
From: Gene Connor [mailto:neothreeei...@hotmail.com] Sent: Wednesday, April 30, 2014 12:21 AM To: sqlite-users@sqlite.org 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users