diff options
author | drh <> | 2023-03-15 17:58:51 +0000 |
---|---|---|
committer | drh <> | 2023-03-15 17:58:51 +0000 |
commit | ffcad5893aa40c52629d02851b05de20cee60f0d (patch) | |
tree | 47831f5b2c696dac1b080b3cfd7d8596627e1092 /src/resolve.c | |
parent | eb5d71ed58ce1b5b9a68c928f48063e4e3969467 (diff) | |
download | sqlite-ffcad5893aa40c52629d02851b05de20cee60f0d.tar.gz sqlite-ffcad5893aa40c52629d02851b05de20cee60f0d.zip |
Disallow the one-pass optimization for DELETE if the WHERE clause contains
a subquery. Fix for the problem reported by
[forum:/forumpost/e61252062c9d286d|forum post e61252062c9d286d]. This fix
is more restrictive than necessary. It could be relaxed if the subquery does
not involve the table that is the subject of the DELETE.
FossilOrigin-Name: 73f0036f045bf37193b6e87ae45b578c5831614c530488257c69666178da3aa5
Diffstat (limited to 'src/resolve.c')
-rw-r--r-- | src/resolve.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/resolve.c b/src/resolve.c index dfb343439..4b36ecca3 100644 --- a/src/resolve.c +++ b/src/resolve.c @@ -1252,8 +1252,8 @@ static int resolveExprStep(Walker *pWalker, Expr *pExpr){ assert( pNC->nRef>=nRef ); if( nRef!=pNC->nRef ){ ExprSetProperty(pExpr, EP_VarSelect); - pNC->ncFlags |= NC_VarSelect; } + pNC->ncFlags |= NC_Subquery; } break; } |