[sqlite] Re: index is not used for IN but it is used for =

[Martijn Voncken]

On 8/3/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-08-03 at 00:05 +0200, Martijn Voncken wrote: 
> > I'm using pysqlite2,compiled against sqlite 3.2.1
> > I thought that IN uses an index.
> > 
> 
> Versions 3.2.2 and earlier only use IN in an index if
> the column on the left of the IN operator is the
> left-most column in the index.  This constraint is
> relaxed in the latest code in CVS and in the next
> release.

Thanks for the fast reply.
I'll test CVS soon.

Martijn.