[sqlite] Numerics bigger than 32-bit and sqlite as 64-bit TCL extension

[Richard Hipp]

On 7/28/15, Rafa? Ponikwia <rp at antsolutions.pl> wrote:
> Hi,
> I'm using sqlite3 TCL extension from Teapot (version 64-bit). When I try
> to insert number bigger than signed 32-bit it inserts wrong number to
> database.
>> % db eval {
>      CREATE TABLE test (num NUMERIC);
>      INSERT INTO test (num) VALUES ($l1), ($l2), ($l3);
>      SELECT * FROM test;
> }
> 2147483647 2147483649 -2147483647
>

I get the correct answer (2147483647 2147483649 2147483649) when I try
this on 64-bit Ubuntu.
-- 
D. Richard Hipp
drh at sqlite.org