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] -----------------------------------------------------------------------------