Still present in 3.22.0:
! e_expr-32.2.5 expected: [integer 9223372036854775807]
! e_expr-32.2.5 got: [real 9.22337203685478e+18]
! e_expr-32.2.6 expected: [integer 9223372036854775807]
! e_expr-32.2.6 got: [real 9.22337203685478e+18]
! e_expr-32.2.8 expected: [integer 9000000000000000001 integer
9000000000000000001 integer 9000000000000000001 integer 9000000000000000001
integer 9000000000000000001 integer 9000000000000000001 integer
9223372036854775807 integer 9223372036854775807 integer 9223372036854775807
real 9.22337203685478e+18 real 9.22337203685478e+18 integer 9223372036854775807
integer 9223372036854775807 integer -5 integer -5]
! e_expr-32.2.8 got: [integer 9000000000000000001 real 9.0e+18 real
9.0e+18 real 9.0e+18 integer 9000000000000000001 real 9.0e+18 integer
9223372036854775807 real 9.22337203685478e+18 real 9.22337203685478e+18 real
9.22337203685478e+18 real 9.22337203685478e+18 real 9.22337203685478e+18 real
9.22337203685478e+18 integer -5 integer -5]
This seems to be happening whenever a string not ending with a number
('9000000000000000001x', '9000000000000000001 ',' 9000000000000000001.')
gets cast to NUMERIC.
Is there any more information I can provide to get this looked at?
On 11/01/2017 01:07 PM, Petr Kubat wrote:
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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users