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.
This bug appears to have been reported against 'rawhide' during the Fedora 10 development cycle. Changing version to '10'. More information and reason for this action is here: http://fedoraproject.org/wiki/BugZappers/HouseKeeping
Hum, this has been reported against "sqlite3" component, which doesn't really exist (sqlite is the right one) and the owner email is long since invalid, so this gone completely unnoticed :-/ Anyway, this is dupe of 474260. *** This bug has been marked as a duplicate of bug 474260 ***