diff options
| author | dan <Dan Kennedy> | 2024-05-02 19:22:23 +0000 |
|---|---|---|
| committer | dan <Dan Kennedy> | 2024-05-02 19:22:23 +0000 |
| commit | 9c0d777a9f4a84f09b6145b74184a38a3abd7db0 (patch) | |
| tree | 89df9f0934b3ff98afec0ec634dde846848dfe13 /src/wherecode.c | |
| parent | 72814933b9f072685788e49c6df409ba3f16668e (diff) | |
| download | sqlite-9c0d777a9f4a84f09b6145b74184a38a3abd7db0.tar.gz sqlite-9c0d777a9f4a84f09b6145b74184a38a3abd7db0.zip | |
Fix a problem with queries that use "IN(...) ORDER BY ... NULLS LAST" or similar introduced by [d7648e21605a0b38].
FossilOrigin-Name: 26b2d9390f1273ee0e3f3c96f6bc5bf0e9c1dcfd0d9ecd993dba487ef5a07f7e
Diffstat (limited to 'src/wherecode.c')
| -rw-r--r-- | src/wherecode.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/wherecode.c b/src/wherecode.c index a895d3935..4aca6eb62 100644 --- a/src/wherecode.c +++ b/src/wherecode.c @@ -2106,7 +2106,7 @@ Bitmask sqlite3WhereCodeOneLoopStart( /* Record the instruction used to terminate the loop. */ if( (pLoop->wsFlags & WHERE_ONEROW) - || (pLevel->u.in.nIn && whereLoopIsOneRow(pLoop)) + || (pLevel->u.in.nIn && regBignull==0 && whereLoopIsOneRow(pLoop)) ){ pLevel->op = OP_Noop; }else if( bRev ){ |