Package: sqlite3 Version: 3.5.9-3 Severity: normal Sending to Debian Bug Tracking System and the sqlite-users list.
On the sqlite-users mailing list, bakers wrote: > Igor Tandetnik wrote: > > Scott Baker <[EMAIL PROTECTED]> wrote: > >> Did I do something wrong? > >> > >> SQLite version 3.5.9 > >> Enter ".help" for instructions > >> sqlite> select 1219441430151/1000, 1219441430151/1000.0; > >> 1219441430| > > > > Works for me. Did you perhaps compile without floating point support, or > > something like that? I'm running Windows pre-built binaries. > > I'm using the fedora packages: > sqlite-3.5.9-1.fc9.i386 > > It works for small numbers: > sqlite> select 1.0 / 2.0; > 0.5 Debian's 3.5.9 shows similar behaviour, although older versions work. Is this something inate to the sqlite code or a problem with the build? $ cat /etc/debian_version 3.1 $ uname -m i686 $ dpkg -l sqlite3 | awk '/^.i/{print $3}' 3.2.8-1+zeno : no code changes from debian package, just rebuilt under sarge $ echo 'select 1219441430151/2.0, 1219441430151/20.0;' | sqlite3 609720715075.5|60972071507.55 $ cat /etc/debian_version 4.0 $ uname -m x86_64 $ dpkg -l sqlite3 | awk '/^.i/{print $3}' 3.3.8-1.1 $ echo 'select 1219441430151/2.0, 1219441430151/20.0;' | sqlite3 609720715075.5|60972071507.55 $ cat /etc/debian_version lenny/sid $ uname -m i686 $ dpkg -l sqlite3 | awk '/^.i/{print $3}' 3.5.9-3 $ echo 'select 1219441430151/2.0, 1219441430151/20.0;' | sqlite3 609720715075.5| -jonathan -- Jonathan H N Chin, 2 dan | deputy computer | Newton Institute, Cambridge, UK <[EMAIL PROTECTED]> | systems mangler | tel/fax: +44 1223 767091/330508 "respondeo etsi mutabor" --Rosenstock-Huessy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users