diff options
| author | dan <dan@noemail.net> | 2016-07-23 20:24:06 +0000 |
|---|---|---|
| committer | dan <dan@noemail.net> | 2016-07-23 20:24:06 +0000 |
| commit | ba00e30a3a55e3800ce808373d9604983a4d1df5 (patch) | |
| tree | 89345681cb394f558831a45da332eef0ad860f2c /src/wherecode.c | |
| parent | 4097d0ca799b94ad70bab459234075f7185d55fd (diff) | |
| download | sqlite-ba00e30a3a55e3800ce808373d9604983a4d1df5.tar.gz sqlite-ba00e30a3a55e3800ce808373d9604983a4d1df5.zip | |
Allow vector IN(SELECT ...) expressions to use an index if either all the indexed columns are declared NOT NULL or if there is no difference between the expression evaluating to 0 and NULL (as in a WHERE clause).
FossilOrigin-Name: e2fd6f49b1b145bec09c581cc982b89429643ae9
Diffstat (limited to 'src/wherecode.c')
| -rw-r--r-- | src/wherecode.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/wherecode.c b/src/wherecode.c index e660b3538..0f6d32024 100644 --- a/src/wherecode.c +++ b/src/wherecode.c @@ -379,7 +379,7 @@ static int codeEqualityTerm( } assert( pX->op==TK_IN ); iReg = iTarget; - eType = sqlite3FindInIndex(pParse, pX, IN_INDEX_LOOP, 0); + eType = sqlite3FindInIndex(pParse, pX, IN_INDEX_LOOP, 0, 0); if( eType==IN_INDEX_INDEX_DESC ){ testcase( bRev ); bRev = !bRev; |