diff options
| author | drh <> | 2023-06-01 20:38:22 +0000 |
|---|---|---|
| committer | drh <> | 2023-06-01 20:38:22 +0000 |
| commit | 179c32cb579af1cb2244c7397b7fb8c1666bfe06 (patch) | |
| tree | 12817ca0e90a2d154c462f359c1eb143acd0c4e9 /src/expr.c | |
| parent | 39a7a1a9bed4f8dd5aee65bd8e1f7ecbd466e4ba (diff) | |
| download | sqlite-179c32cb579af1cb2244c7397b7fb8c1666bfe06.tar.gz sqlite-179c32cb579af1cb2244c7397b7fb8c1666bfe06.zip | |
Generalize the LEFT JOIN strength reduction optimization so that it works for
RIGHT and FULL JOIN as well. Rename it to the "OUTER JOIN strength reduction"
optimization.
FossilOrigin-Name: d747afda5683ca5feb92866a14ccc4c5127d3378ece5cad2c3da819f2477b457
Diffstat (limited to 'src/expr.c')
| -rw-r--r-- | src/expr.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/expr.c b/src/expr.c index 7eef6c6ab..707a9ca6b 100644 --- a/src/expr.c +++ b/src/expr.c @@ -6017,7 +6017,7 @@ static void bothImplyNotNullRow(Walker *pWalker, Expr *pE1, Expr *pE2){ static int impliesNotNullRow(Walker *pWalker, Expr *pExpr){ testcase( pExpr->op==TK_AGG_COLUMN ); testcase( pExpr->op==TK_AGG_FUNCTION ); - if( ExprHasProperty(pExpr, EP_OuterON) ) return WRC_Prune; + if( ExprHasProperty(pExpr, EP_OuterON|EP_InnerON) ) return WRC_Prune; switch( pExpr->op ){ case TK_ISNOT: case TK_ISNULL: |