Red Hat Bugzilla – Bug 452591
sqlite-devel compiled with incorrect gcc flag fast math
Last modified: 2009-01-29 03:03:57 EST
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
Steps to Reproduce:
1. Run sqlite3
3. Perform simple select
Returns a null result. A faction should be returned.
sqlite> select 5/9.0;
sqlite3 was compiled with the gcc fast math option by default. This is incorrect.
Fix (forcing no-fast-math):
$ export CFLAGS=-fno-fast-math
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.24 main-3.3 misc3-2.1 misc3-2.2 misc3-2.3 misc3-2.4 misc3-2.5 misc3-2.6
misc3-2.8 misc3-2.9 select6-3.3 select6-3.6
After setting this flag:
0 errors out of 62272 tests
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:
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 ***