diff options
| author | drh <> | 2024-06-06 15:03:16 +0000 |
|---|---|---|
| committer | drh <> | 2024-06-06 15:03:16 +0000 |
| commit | 4703b7d0921291f96bb53a45f4ab49b99bfbd33c (patch) | |
| tree | 356b665b030beb3dcfa7d4fd48b8170463cbbf3d /src/where.c | |
| parent | 404ddadbd421fd3754cab1a3e90bb2dd74467fbd (diff) | |
| download | sqlite-4703b7d0921291f96bb53a45f4ab49b99bfbd33c.tar.gz sqlite-4703b7d0921291f96bb53a45f4ab49b99bfbd33c.zip | |
Better optimize queries that use parameters in the LIMIT clause.
FossilOrigin-Name: e58cb304d1e0ec6e30260a165aaccc2cf096ce6c999efb06683c4ef600ee12ef
Diffstat (limited to 'src/where.c')
| -rw-r--r-- | src/where.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/where.c b/src/where.c index 71a8241e3..a5cf63d71 100644 --- a/src/where.c +++ b/src/where.c @@ -2942,7 +2942,7 @@ static void whereLoopOutputAdjust( Expr *pRight = pTerm->pExpr->pRight; int k = 0; testcase( pTerm->pExpr->op==TK_IS ); - if( sqlite3ExprIsInteger(pRight, &k) && k>=(-1) && k<=1 ){ + if( sqlite3ExprIsInteger(pRight, &k, 0) && k>=(-1) && k<=1 ){ k = 10; }else{ k = 20; |