[Bug 277870] Re: SQLite returns NULL when subtracting
*** This bug is a duplicate of bug 254228 *** https://bugs.launchpad.net/bugs/254228 Well, I tested the packages you suggested on Intrepid, and it worked fine. So, I'm marking this bug as a duplicate of bug 254228. ** This bug has been marked a duplicate of bug 254228 division error in sqlite 3.5.9-5 -- SQLite returns NULL when subtracting https://bugs.launchpad.net/bugs/277870 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 277870] Re: SQLite returns NULL when subtracting
*** This bug is a duplicate of bug 254228 *** https://bugs.launchpad.net/bugs/254228 Thanks, Allan, for giving it a shot and reporting back. -- SQLite returns NULL when subtracting https://bugs.launchpad.net/bugs/277870 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 277870] Re: SQLite returns NULL when subtracting
Can those affected by this bug please try installing sqlite3 and libsqlite3 from my PPA (https://launchpad.net/~r0lf/+archive) and report if that fixes the problem? In that case, we'd see a duplicate of bug 254228 where you can read more about the background. ** Changed in: sqlite3 (Ubuntu) Status: Confirmed = Incomplete -- SQLite returns NULL when subtracting https://bugs.launchpad.net/bugs/277870 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 277870] Re: SQLite returns NULL when subtracting
** Changed in: sqlite3 (Ubuntu) Status: New = Confirmed -- SQLite returns NULL when subtracting https://bugs.launchpad.net/bugs/277870 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 277870] Re: SQLite returns NULL when subtracting
miraks, I think the only workaround is doing the math in the application code, and not in SQLite. That is, if you are using SQLite bindings for a programming language. However, this is not a good solution... -- SQLite returns NULL when subtracting https://bugs.launchpad.net/bugs/277870 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 277870] Re: SQLite returns NULL when subtracting
I also do it: http://www.sqlite.org/cvstrac/tktview?tn=3465,35 Do you know a work around because it's a blocking point for me ? -- SQLite returns NULL when subtracting https://bugs.launchpad.net/bugs/277870 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 277870] Re: SQLite returns NULL when subtracting
It's a major issue because of this also happens when selecting direct values: sqlite select 6.6989+22.912345; sqlite select 6.5989+22.912345; 29.511245 Crazy ! no ? WARNING: I think that libsql3-0 is impacted too. -- SQLite returns NULL when subtracting https://bugs.launchpad.net/bugs/277870 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 277870] Re: SQLite returns NULL when subtracting
I also reported this bug directly to the SQLite team: http://www.sqlite.org/cvstrac/tktview?tn=3414,35 The bug seems to be caused by compiling with the --fast-math option, though I did not try this solution myself. -- SQLite returns NULL when subtracting https://bugs.launchpad.net/bugs/277870 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs