Re: [sqlite] Calling sqlite3_column_int on a column with a too large number?

2013-07-10 Thread Richard Hipp
On Wed, Jul 10, 2013 at 9:55 AM, Paolo Bolzoni < paolo.bolzoni.br...@gmail.com> wrote: > The subject pretty much says it all. > I am curious to know what sqlite3 does when asking for the result value of > a column passing a type that is too small. > > For example in my system int are 32 bits as

Re: [sqlite] Calling sqlite3_column_int on a column with a too large number?

2013-07-10 Thread Igor Tandetnik
On 7/10/2013 9:55 AM, Paolo Bolzoni wrote: The subject pretty much says it all. I am curious to know what sqlite3 does when asking for the result value of a column passing a type that is too small. Casts it down to int. For example in my system int are 32 bits as result of a query I got a 10

[sqlite] Calling sqlite3_column_int on a column with a too large number?

2013-07-10 Thread Paolo Bolzoni
The subject pretty much says it all. I am curious to know what sqlite3 does when asking for the result value of a column passing a type that is too small. For example in my system int are 32 bits as result of a query I got a 10 billions: what happens using sqlite3_column_int to get that result?