[Bug 254228] Re: division error in sqlite 3.5.9-5

[Bug Watch Updater]

** Changed in: sqlite3 (Debian)
       Status: Unknown => Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to sqlite3 in Ubuntu.
https://bugs.launchpad.net/bugs/254228

Title:
  division error in sqlite 3.5.9-5

Status in Python:
  Invalid
Status in “sqlite3” package in Ubuntu:
  Fix Released
Status in “sqlite3” source package in Intrepid:
  Fix Released
Status in “sqlite3” package in Debian:
  Fix Released

Bug description:
  Binary package hint: libsqlite3-0

  Error occur in sqlite3 3.5.9-5 (command line interface) and python 2.5.2-10ubuntu1 (when connect do sqlite db).
  When I try divide real number by real or integer sometimes I get null.

  Example:
  #sqlite3 test.db 
  SQLite version 3.5.9
  Enter ".help" for instructions
  sqlite> select 1.0/2;
  0.5
  sqlite> select 30/2;
  15
  sqlite> select 30.3/2;
  15.15
  sqlite> select 30.3/22;      ---<------- ERROR

  sqlite> select 30.3/2;
  15.15
  sqlite> select 30.3/3;      ---<------- ERROR

  sqlite> select 30.3/2;
  15.15
  sqlite> select 30.3/4;
  7.575
  sqlite> select 30.3/5;      ---<------- ERROR

  sqlite> select 30.3/6;      ---<------- ERROR

  sqlite> select 30.3/7;      ---<------- ERROR

  sqlite> select 30.3/8;
  3.7875
  sqlite> select 30.3/9;      ---<------- ERROR

  sqlite> select 30.3/10;      ---<------- ERROR

  sqlite> select 30.3/11;      ---<------- ERROR

  sqlite> select 30.3/12;      ---<------- ERROR

  sqlite> select 30.3/13;      ---<------- ERROR

  sqlite> select 30.3/14;      ---<------- ERROR

  sqlite> select 30.3/14.3;      ---<------- ERROR

  sqlite> select 30.3/15;      ---<------- ERROR

  sqlite> select 30.3/16;
  1.89375
  sqlite> select 30.3/16.0;
  1.89375
  sqlite> select 30.3/16.5;      ---<------- ERROR

  sqlite>

  Regards
  Sep


  executive summary prepared by Rolf Leggewie as per https://wiki.ubuntu.com/StableReleaseUpdates:
  2.1 impact: sqlite3 returns incorrect results, all packages using an sqlite3 backend are possibly affected by them.  I know that at least anki (ichi2.net/anki/) is completely unusable in Intrepid because of this bug.

  2.2 fix in .dev branch: dunno, but users report that jaunty packages
  (which are based off the same orig.tar.gz, I think) are not affected.
  somebody please comment.

  2.3 minimal patch:
  http://launchpadlibrarian.net/21015612/sqlite3_3.5.9-3ubuntu1.debdiff
  which is attached to this bug report

  2.4 test case: see original report above

  2.5 regression potential: dunno, sorry.  somebody please comment here.

To manage notifications about this bug go to:
https://bugs.launchpad.net/python/+bug/254228/+subscriptions