On Fri, Mar 28, 2014 at 8:52 AM, Stephan Beal <[email protected]> wrote:
> On Fri, Mar 28, 2014 at 1:50 PM, Simon Slavin <[email protected]> > wrote: > > > But this is not a documented specification for SQLite. It is allowed to > > use any integer which is currently unused. I have no idea whether it's > > allowed to use negative integers. > > > > This is not a definitive answer but is possibly a hint: fossil > (primarily/originally authored by DRH) relies very much on the fact that > record IDs (auto-incremented) have values greater than 0. Based on that, my > strong assumption is that autoinc will never produce a negative value. > > SQLite prefers small positive rowids, since such rowids take up less space on disk using the variable-length integer encoding. ( http://www.sqlite.org/fileformat2.html#varint). But there are no guarantees. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
