diff options
| author | drh <> | 2021-05-29 23:07:59 +0000 |
|---|---|---|
| committer | drh <> | 2021-05-29 23:07:59 +0000 |
| commit | d65b7e36ecf05a3464c7071f92cfd304197ac66a (patch) | |
| tree | 616462b8b2c9e80c56431d9d4394d4c7989f5a2e /src | |
| parent | d36bcec9ad8ab1849f1ee4752289dc7d10dddf2e (diff) | |
| download | sqlite-d65b7e36ecf05a3464c7071f92cfd304197ac66a.tar.gz sqlite-d65b7e36ecf05a3464c7071f92cfd304197ac66a.zip | |
Do not confuse the ">" operator with IS NOT NULL when checking to see if
a partial index is usable.
[forum:/forumpost/d813704d7c|Forum post d813704d7c].
FossilOrigin-Name: 8cc23931d61b7d78521acce93fc2603649c5813c7a0869cb2c1bde2c8c4e51b4
Diffstat (limited to 'src')
| -rw-r--r-- | src/where.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/where.c b/src/where.c index 4062de7ea..9483abdc5 100644 --- a/src/where.c +++ b/src/where.c @@ -2914,7 +2914,8 @@ static int whereUsablePartialIndex( pExpr = pTerm->pExpr; if( (!ExprHasProperty(pExpr, EP_FromJoin) || pExpr->iRightJoinTable==iTab) && (isLeft==0 || ExprHasProperty(pExpr, EP_FromJoin)) - && sqlite3ExprImpliesExpr(pParse, pExpr, pWhere, iTab) + && sqlite3ExprImpliesExpr(pParse, pExpr, pWhere, iTab) + && (pTerm->wtFlags & TERM_VNULL)==0 ){ return 1; } |