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:
https://www.sqlite.org/2018/sqlite-tools-win32-x86-3220000.zip
Running on Windows 7:
SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT CAST ('9223372036854775807 ' AS NUMERIC);
9.22337203685478e+18
sqlite> SELECT CAST ('9223372036854775807' AS NUMERIC);
9223372036854775807
Notice the trailing white space which makes the difference.
Ralf
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users