Comment 0 for bug 254228

Revision history for this message
Sep870 (sep870) wrote :

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