Re: [sqlite] Smallest INTEGER wrong? it is -9223372036854775807 and not -9223372036854775808...

[EMAIL PROTECTED] wrote: Michael Sizaki <[EMAIL PROTECTED]> wrote: in java, the smallest long is -9223372036854775808 in SQLite it seems to be -9223372036854775807 Bug or feature? Call it what you like. I deliberately omitted the lower end to make the last line of sqlite3atoi64() a

Re: [sqlite] Smallest INTEGER wrong? it is -9223372036854775807 and not -9223372036854775808...

[EMAIL PROTECTED] wrote: Michael Sizaki <[EMAIL PROTECTED]> wrote: Hi, in java, the smallest long is -9223372036854775808 in SQLite it seems to be -9223372036854775807 Bug or feature? I deliberately omitted the lower end to make the last line of sqlite3atoi64() a little

Re: [sqlite] Smallest INTEGER wrong? it is -9223372036854775807 and not -9223372036854775808...

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

[sqlite] Smallest INTEGER wrong? it is -9223372036854775807 and not -9223372036854775808...

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