Description of problem:

SQLite 3 will not correct perform calculations on real numbers.


Version-Release number of selected component (if applicable):

Name       : sqlite-devel
Arch       : i386
Version    : 3.5.9
Release    : 1.fc10


How reproducible:


Steps to Reproduce:

1. Run sqlite3
3. Perform simple select 
select 5/9.0;
  
Actual results:

Returns a null result. A faction should be returned.
Expected results:

sqlite> select 5/9.0;
0.555555555555556


Additional info:

sqlite3 was compiled with the gcc fast math option by default. This is incorrect.

Fix (forcing no-fast-math):

$ export CFLAGS=-fno-fast-math
$ ./configure
$ make


Without this setting, the following tests failed, when running

$ make test

19 errors out of 58547 tests

Failures on these tests: expr-2.3 expr-2.4 expr-2.5 func-18.13 main-3.2.22
main-3.2.23 
main-3.2.24 main-3.3 misc3-2.1 misc3-2.2 misc3-2.3 misc3-2.4 misc3-2.5 misc3-2.6
misc3-2.7 
misc3-2.8 misc3-2.9 select6-3.3 select6-3.6


After setting this flag:

0 errors out of 62272 tests


Note:

It appears that Fedora release 9.90 (Rawhide) has fixed the problem
with the compiler; however, they are distributing SQLite with a
version that hasn't be compiled with this flag.