SQLite returns NULL when subtracting
Bug #277870 reported by
Allan Vidal
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
sqlite3 (Ubuntu) |
Incomplete
|
Undecided
|
Unassigned | ||
Bug Description
Binary package hint: sqlite3
When I execute the following statements in SQLite 3.4.2 on Ubuntu 8.04...
CREATE TABLE Test (rowID INTEGER PRIMARY KEY AUTOINCREMENT, value REAL);
INSERT INTO Test VALUES (NULL, 200);
UPDATE Test SET value = (value - 10.205) WHERE rowID = 1;
SELECT * FROM Test;
...the result is 189.795, as expected.
However, when executing the same statements in SQLite 3.5.9 on Ubuntu 8.10 Beta, the result is NULL.
Changed in sqlite3: | |
status: | New → Confirmed |
To post a comment you must log in.
I also reported this bug directly to the SQLite team: www.sqlite. org/cvstrac/ tktview? tn=3414, 35
http://
The bug seems to be caused by compiling with the --fast-math option, though I did not try this solution myself.