Index: src/where.c ================================================================== --- src/where.c +++ src/where.c @@ -3530,12 +3530,12 @@ pIn->iCur = iTab; if( eType==IN_INDEX_ROWID ){ pIn->addrInTop = sqlite3VdbeAddOp2(v, OP_Rowid, iTab, iReg); }else{ pIn->addrInTop = sqlite3VdbeAddOp3(v, OP_Column, iTab, 0, iReg); + sqlite3VdbeAddOp1(v, OP_IsNull, iReg); } - sqlite3VdbeAddOp1(v, OP_IsNull, iReg); }else{ pLevel->u.in.nIn = 0; } #endif }