At 11:27 03/03/2015, you wrote: ???? >- the full table scan returns rows in rowID order, which is the order >in which the rows were added to the table `---
No and no. An SQL engine doesn't guarantee any row "order" unless you explicitely force an ORDER BY clause. Think of row order as random, where rowid order is just a possibility among zillions others. Of course neither SQLite nor other engines willingly use random() to foil your expectations but you should never rely on such an implementation detail. Also rowids are technically independant of insertion order: you may feed any valid random literal rowids at insert time. -- <mailto:jcd at q-e-d.org>jcd at antichoc.net
