2008-08-02 15:44:20 |
Sep870 |
bug |
|
|
added bug |
2008-08-19 10:03:51 |
Sep870 |
bug |
|
|
assigned to python |
2008-10-28 16:41:03 |
Mathieu Marquer |
sqlite3: status |
New |
In Progress |
|
2008-10-28 16:41:03 |
Mathieu Marquer |
sqlite3: statusexplanation |
|
|
|
2008-11-11 12:54:58 |
Rolf Leggewie |
bug |
|
|
added subscriber Ubuntu Sponsors for main |
2008-11-11 12:59:56 |
Rolf Leggewie |
bug |
|
|
added attachment 'sqlite3_3.5.9-3ubuntu1.debdiff' (sqlite3_3.5.9-3ubuntu1.debdiff) |
2008-11-11 13:00:36 |
Rolf Leggewie |
python: status |
New |
Incomplete |
|
2008-11-11 13:00:36 |
Rolf Leggewie |
python: statusexplanation |
|
this is not a python bug. |
|
2008-11-11 13:00:48 |
Rolf Leggewie |
python: status |
Incomplete |
Invalid |
|
2008-11-11 13:00:48 |
Rolf Leggewie |
python: statusexplanation |
this is not a python bug. |
|
|
2009-01-05 15:46:57 |
Rolf Leggewie |
bug |
|
|
added subscriber Ubuntu Sponsors for main |
2009-01-08 18:25:52 |
Rolf Leggewie |
bug |
|
|
added attachment 'sqlite3_3.5.9-3ubuntu1.debdiff' (patch for intrepid-proposed) |
2009-01-08 18:28:59 |
Rolf Leggewie |
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 |
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 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. |
|
2009-01-08 18:30:52 |
Rolf Leggewie |
sqlite3: importance |
Undecided |
High |
|
2009-01-08 18:30:52 |
Rolf Leggewie |
sqlite3: statusexplanation |
|
I support the nomination to upload a patched version to intrepid-proposed. |
|
2009-01-08 18:39:41 |
Rolf Leggewie |
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 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. |
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. |
|
2009-01-27 09:56:09 |
Martin Pitt |
sqlite3: status |
In Progress |
Fix Released |
|
2009-01-27 09:56:09 |
Martin Pitt |
sqlite3: statusexplanation |
I support the nomination to upload a patched version to intrepid-proposed. |
I confirm that I can reproduce this in intrepid, and that Jaunty works fine. |
|
2009-01-27 09:58:08 |
Martin Pitt |
bug |
|
|
assigned to sqlite3 (Debian) |
2009-01-27 10:07:38 |
Martin Pitt |
sqlite3: status |
New |
In Progress |
|
2009-01-27 10:07:38 |
Martin Pitt |
sqlite3: assignee |
|
pitti |
|
2009-01-27 10:07:38 |
Martin Pitt |
sqlite3: statusexplanation |
|
|
|
2009-01-27 10:08:12 |
Martin Pitt |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
2009-01-27 10:38:59 |
Martin Pitt |
bug |
|
|
added attachment 'sqlite3.intrepid.debdiff' (intrepid debdiff) |
2009-01-27 11:28:53 |
Steve Langasek |
sqlite3: status |
In Progress |
Fix Committed |
|
2009-01-27 11:29:25 |
Steve Langasek |
bug |
|
|
added subscriber SRU Verification |
2009-02-10 13:25:56 |
Launchpad Janitor |
sqlite3: status |
Fix Committed |
Fix Released |
|
2009-12-19 10:45:49 |
Launchpad Janitor |
branch linked |
|
lp:ubuntu/intrepid-proposed/sqlite3 |
|
2011-08-11 00:33:49 |
Bug Watch Updater |
sqlite3 (Debian): status |
Unknown |
Fix Released |
|