Michael Sizaki <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> in java, the smallest long is
>    -9223372036854775808
> 
> in SQLite it seems to be
>    -9223372036854775807
> 
> sqlite> create temp table t as select 
> -9223372036854775807,-9223372036854775808;
> sqlite> select * from t;
> -9223372036854775807|-9.22337203685478e+18
> 
> ==> -9223372036854775808 is converted to a float!
> 
> Bug or feature?
> 

Call it what you like.  I deliberately omitted the
lower end to make the last line of sqlite3atoi64()
a little simpler.  (Nobody has noticed in 2.5 years.)

--
D. Richard Hipp   <[EMAIL PROTECTED]>


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to