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
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