Package: sqlite3 Version: 3.5.9-3 Severity: normal sqlite3 seems to have changed how division is calculated. Please compare the results following sqlite3 select against those from sqlite (version 2) that follow. I expected the sqlite answers rather than those that sqlite3 is giving.
>sqlite3 SQLite version 3.5.9 Enter ".help" for instructions sqlite> select 1.0/2.0; 0.5 sqlite> select 1.0/3.0; sqlite> select 1.0/4.0; 0.25 sqlite> select 1.0/5.0; sqlite> select 1.0/6.0; sqlite> select 1.0/7.0; sqlite> select 1.0/8.0; 0.125 sqlite> select 1.0/9.0; sqlite> select 1.0/10.0; sqlite> Here are the version 2 results. >sqlite SQLite version 2.8.17 Enter ".help" for instructions sqlite> select 1.0/2.0; 0.5 sqlite> select 1.0/3.0; 0.333333333333333 sqlite> select 1.0/4.0; 0.25 sqlite> select 1.0/5.0; 0.2 sqlite> select 1.0/6.0; 0.166666666666667 sqlite> select 1.0/7.0; 0.142857142857143 sqlite> select 1.0/8.0; 0.125 sqlite> select 1.0/9.10; 0.10989010989011 sqlite> select 1.0/10.0; 0.1 sqlite> -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (500, 'unstable'), (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.25-2-686 (SMP w/1 CPU core) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/bash Versions of packages sqlite3 depends on: ii libc6 2.7-12 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. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]