> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 21, 2007 2:40 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Re: does select reliably return insert order? > > > > If you use LIMIT/OFFSET without an > > explicit ORDER BY, you are relying on an implementation detail. > > Yes, but SQLite is an implementation. If it returns rows allways in the > same > order I don't see why it shouldn't be acknowledged - one mention in a > documentation would make it a feature, and I think quite usefull one.
If the current implementation of SQLite returns rows always in the same order and is documented as such, then future versions of SQLite will be bound by that. While that may seem like a Good Thing for now, it will hamper future optimizations or changes to the pager, btree or other modules. By leaving it undocumented and not committing to today's implementation, DRH leaves himself open to change or optimize it later without breaking backward compatibility. Robert ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
