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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
