Bug 452591 - sqlite-devel compiled with incorrect gcc flag fast math
sqlite-devel compiled with incorrect gcc flag fast math
Status: CLOSED DUPLICATE of bug 474260
Product: Fedora
Classification: Fedora
Component: sqlite (Show other bugs)
10
All Linux
low Severity high
: ---
: ---
Assigned To: Panu Matilainen
Fedora Extras Quality Assurance
:
Depends On:
Blocks: F10Target
  Show dependency treegraph
 
Reported: 2008-06-23 18:35 EDT by Mike Chirico
Modified: 2009-01-29 03:03 EST (History)
3 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed: 2009-01-29 03:03:57 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)

  None (edit)
Description Mike Chirico 2008-06-23 18:35:16 EDT
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.
Comment 1 Bug Zapper 2008-11-25 21:27:43 EST
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
Comment 2 Panu Matilainen 2009-01-29 03:03:57 EST
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 ***

Note You need to log in before you can comment on or make changes to this bug.