On Wed, 25 Mar 2015 10:02:24 +0000 Simon Slavin <slavins at bigfraud.org> wrote:
> > On 25 Mar 2015, at 3:28am, James K. Lowden <jklowden at schemamania.org> > wrote: > > > Is there some lower bound on either the size of the IN list or the > > number of rows in the table being queried? > > There's nothing in the language to stop you from executing "... WHERE > c IN (12) ..." on a zero-row table. It won't be efficient, but it > will give the correct result. I guess I was unclear. I was asking about SQLite's implementation, specifically whether an IN clause is always sorted using an ephemeral table, or if that complexity is subject to some minimum threshhold. --jkl
