[sqlite] FW: Bug in division?

2014-05-06 Thread Gene Connor 
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

[sqlite] Bug in division?

2014-04-30 Thread Gene Connor 

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