Index: src/where.c ================================================================== --- src/where.c +++ src/where.c @@ -703,11 +703,11 @@ } if( sqlite3StrICmp(pColl->zName, pIdx->azColl[j]) ){ continue; } } - if( pTerm->prereqRight==0 ){ + if( pTerm->prereqRight==0 && (pTerm->eOperator&WO_EQ)!=0 ){ pResult = pTerm; goto findTerm_success; }else if( pResult==0 ){ pResult = pTerm; }