forcemerge 488864 497047 thanks I suck. I should have looked at the existing bugs. It is a problem. It has already been fixed.
See: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=488864 Perhaps fedora has an updated package too? I wrote: > On the sqlite-users mailing list, bakers wrote: > > Igor Tandetnik wrote: > > > Scott Baker <[EMAIL PROTECTED]> wrote: > > >> 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 [...] > 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 > 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