diff options
| author | dan <Dan Kennedy> | 2021-03-29 20:28:27 +0000 |
|---|---|---|
| committer | dan <Dan Kennedy> | 2021-03-29 20:28:27 +0000 |
| commit | 28a314e74da9dc2875d47365c9c6520a00a94df6 (patch) | |
| tree | a18c12722e5479a8873336fac6b4dfa102c94fce /src | |
| parent | acbae3ba10b910ffa84801f1aa89beb4a483fc90 (diff) | |
| download | sqlite-28a314e74da9dc2875d47365c9c6520a00a94df6.tar.gz sqlite-28a314e74da9dc2875d47365c9c6520a00a94df6.zip | |
Do not do the EXISTS-to-IN transformation if the sub-select has LIMIT clause.
FossilOrigin-Name: d07e246f9b6d4d7aef63a6debcb7ab2832bff6f80a245f50bcebb3f8de1bacc7
Diffstat (limited to 'src')
| -rw-r--r-- | src/whereexpr.c | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/whereexpr.c b/src/whereexpr.c index 7b80c4139..b3f48feaa 100644 --- a/src/whereexpr.c +++ b/src/whereexpr.c @@ -1216,6 +1216,7 @@ static void exprAnalyzeExists( #endif if( pSel->pPrior ) return; if( pSel->pWhere==0 ) return; + if( pSel->pLimit ) return; if( 0==exprAnalyzeExistsFindEq(pSel, 0, 0) ) return; pDup = sqlite3ExprDup(db, pExpr, 0); |