Package: sqlite3 Version: 3.5.9-5 Severity: serious
SQLite3 doesn't return values for some divisions. 100/1.5, 100/3.1 returns no output. ; sqlite3 SQLite version 3.5.9 Enter ".help" for instructions sqlite> select 100/1.5; sqlite> select 100/2.5; 40.0 sqlite> select 100/2; 50 sqlite> select 100/3; 33 sqlite> select 100/3.1; sqlite> select 100/1.5; sqlite> select 100/1.25; 80.0 ... it doesn't work as it should compared to in sqlite2 ; sqlite SQLite version 2.8.17 Enter ".help" for instructions sqlite> select 100/1.25; 80 sqlite> select 100/1.5; 66.6666666666667 sqlite> select 100/1.25; 80 sqlite> select 100/3; 33 sqlite> select 100/3.0; 33.3333333333333 sqlite> select 100/3.1; 32.258064516129 sqlite> -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.22tickless Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages sqlite3 depends on: ii libc6 2.7-13 GNU C Library: Shared libraries ii libreadline5 5.2-3 GNU readline and history libraries ii libsqlite3-0 3.5.9-3 SQLite 3 shared library sqlite3 recommends no packages. Versions of packages sqlite3 suggests: ii sqlite3-doc 3.5.9-3 SQLite 3 documentation -- no debconf information