sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

Timothy J. Lee
sqlite 3.21.0, built from source on Scientific Linux 6
(which is derived from Red Hat Enterprise Linux 6).

configure options were:
--enable-threadsafe --enable-threads-override-locks --enable-load-extension

CFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_DISABLE_DIRSYNC=1 -DSQLITE_ENABLE_FTS3=3 -DSQLITE_ENABLE_RTREE=1 -DSQLITE_SECURE_DELETE=1 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 -Wall -fno-strict-aliasing"

On i386:

sqlite> SELECT CAST ('9223372036854775807 ' AS NUMERIC);
9.22337203685478e+18
sqlite>

On x86_64:

sqlite> SELECT CAST ('9223372036854775807 ' AS NUMERIC);
9223372036854775807
sqlite>

This difference causes self-tests e_expr-32.2.5 e_expr-32.2.6 e_expr-32.2.8
to fail on i386 (the output on x86_64 is the expected output).
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

Petr Kubat
Encountering this in Fedora as well while trying to package latest
3.21.0 version. Only on i386.

Additionally the test suite fails on some architectures (aarch64, ppc64,
s390x) when running the test case fts3expr5-1.5:

! fts3expr5-1.5 expected: [1 {invalid matchinfo blob passed to function rank()}]
! fts3expr5-1.5 got:      [1 {wrong number of arguments to function rank()}]


On 10/28/2017 12:43 AM, Timothy J. Lee wrote:

> sqlite 3.21.0, built from source on Scientific Linux 6
> (which is derived from Red Hat Enterprise Linux 6).
>
> configure options were:
> --enable-threadsafe --enable-threads-override-locks
> --enable-load-extension
>
> CFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_DISABLE_DIRSYNC=1
> -DSQLITE_ENABLE_FTS3=3 -DSQLITE_ENABLE_RTREE=1
> -DSQLITE_SECURE_DELETE=1 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 -Wall
> -fno-strict-aliasing"
>
> On i386:
>
> sqlite> SELECT CAST ('9223372036854775807 ' AS NUMERIC);
> 9.22337203685478e+18
> sqlite>
>
> On x86_64:
>
> sqlite> SELECT CAST ('9223372036854775807 ' AS NUMERIC);
> 9223372036854775807
> sqlite>
>
> This difference causes self-tests e_expr-32.2.5 e_expr-32.2.6
> e_expr-32.2.8
> to fail on i386 (the output on x86_64 is the expected output).
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users