On Mon, Aug 22, 2011 at 4:09 PM, Black, Michael (IS) <michael.bla...@ngc.com > wrote:
> sqlite3 does NOT guarantee rowid always increments and never gives FULL > return (at least according to the docs). > > autoincrement does. > > http://www.sqlite.org/autoinc.html My apologies, i wasn't aware that autoincrement causes a different algorithm to be used. i skimmed over the docs and saw this: "The ROWID chosen for the new row is at least one larger than the largest ROWID... If the table has previously held a row with the largest possible ROWID, then new INSERTs are not allowed and any attempt to insert a new row will fail with an SQLITE_FULL error." and didn't consider that there might be different algorithms in play. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
