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

2018-01-24 Thread Petr Kubat
Thanks for the patch! Tests on i686 are green when included. There are still some failures for other architectures but I will make separate threads for these once I investigate. Petr On 01/23/2018 06:35 PM, Richard Hipp wrote: On 1/23/18, Petr Kubat wrote: Still present

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

2018-01-23 Thread Tony Papadimitriou
If it helps, I can reproduce with the mentioned binary on Win7 but I cannot with my own compiled version (using MSVC). -Original Message- From: Ralf Junker On 23.01.2018 15:31, Richard Hipp wrote: I'm still unable to reproduce this problem. sqlite3.exe from this ZIP:

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

2018-01-23 Thread Richard Hipp
On 1/23/18, Petr Kubat wrote: > Still present in 3.22.0: > > ! e_expr-32.2.5 expected: [integer 9223372036854775807] > ! e_expr-32.2.5 got: [real 9.22337203685478e+18] > > Is there any more information I can provide to get this looked at? Ralf provided the information I

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

2018-01-23 Thread Jim Callahan
What locale? The locale setting may influence character to numeric conversions at the C language library level. sqlite> SELECT CAST ('9223372036854775807 ' AS NUMERIC); > 9.22337203685478e+18 > sqlite> SELECT CAST ('9223372036854775807' AS NUMERIC); > 9223372036854775807 > Notice the trailing

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

2018-01-23 Thread Ralf Junker
On 23.01.2018 15:31, Richard Hipp wrote: I'm still unable to reproduce this problem. sqlite3.exe from this ZIP: https://www.sqlite.org/2018/sqlite-tools-win32-x86-322.zip Running on Windows 7: SQLite version 3.22.0 2018-01-22 18:45:57 Enter ".help" for usage hints. Connected to a

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

2018-01-23 Thread Joseph R. Justice
On Jan 23, 2018 9:32 AM, "Richard Hipp" wrote: I'm still unable to reproduce this problem. I've tried on every 32-bit platform I have at hand: * Ubuntu with -m32 * Android * MacOS 10.6.8 with -m32 * MinGW (32-bit) on Win7 * MSVC (32-bit) on Win10 They all give

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

2018-01-23 Thread Richard Hipp
I'm still unable to reproduce this problem. I've tried on every 32-bit platform I have at hand: * Ubuntu with -m32 * Android * MacOS 10.6.8 with -m32 * MinGW (32-bit) on Win7 * MSVC (32-bit) on Win10 They all give the correct answer. I'm sorry you are having problems. But it

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

2018-01-23 Thread Petr Kubat
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

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

2017-11-01 Thread 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

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

2017-10-27 Thread 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