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

Reply via email to