diff options
| author | dan <dan@noemail.net> | 2018-04-10 12:10:01 +0000 |
|---|---|---|
| committer | dan <dan@noemail.net> | 2018-04-10 12:10:01 +0000 |
| commit | a1054dcc3f50b212ffe89d3fa25e60261341b5ba (patch) | |
| tree | 904c0db938ebc3d8dc9106fbf66e3d8d25c7f533 /src/expr.c | |
| parent | a2ce1b99a853031e18f1b283b5f1397712867726 (diff) | |
| download | sqlite-a1054dcc3f50b212ffe89d3fa25e60261341b5ba.tar.gz sqlite-a1054dcc3f50b212ffe89d3fa25e60261341b5ba.zip | |
Fix a problem causing the LEFT JOIN strength reduction optimization to be
incorrectly applied in some cases where the WHERE clause of the query contains
a filter expression of the form NOT(x AND y). Ticket [1e39b966].
FossilOrigin-Name: 38d319c153641ea4138fab2d5a47c31a86f57a071a1e1c299ca54c980cfb2b60
Diffstat (limited to 'src/expr.c')
| -rw-r--r-- | src/expr.c | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/expr.c b/src/expr.c index 5180044a5..6516348e7 100644 --- a/src/expr.c +++ b/src/expr.c @@ -5018,6 +5018,7 @@ static int impliesNotNullRow(Walker *pWalker, Expr *pExpr){ if( ExprHasProperty(pExpr, EP_FromJoin) ) return WRC_Prune; switch( pExpr->op ){ + case TK_NOT: case TK_ISNULL: case TK_IS: case TK_OR: |