diff options
| author | dan <Dan Kennedy> | 2024-11-05 18:25:32 +0000 |
|---|---|---|
| committer | dan <Dan Kennedy> | 2024-11-05 18:25:32 +0000 |
| commit | 19c4fa92dda7ed7e2fee4d91fb3be456b59e83c7 (patch) | |
| tree | 8cf099f32977b3016939eddf5c152797ea02db52 /ext/misc | |
| parent | 2ad29f3611e47d83d69bb6fbbad47a852a839907 (diff) | |
| download | sqlite-19c4fa92dda7ed7e2fee4d91fb3be456b59e83c7.tar.gz sqlite-19c4fa92dda7ed7e2fee4d91fb3be456b59e83c7.zip | |
Have the xBestIndex method of the generate_series virtual table ignore contraints on the "value" column with usable=0.
FossilOrigin-Name: f5113a2ef84831ad2da723fa7e29e0d575e74e10585741ff51db8c2e37332cd2
Diffstat (limited to 'ext/misc')
| -rw-r--r-- | ext/misc/series.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/ext/misc/series.c b/ext/misc/series.c index 64f3be2c0..aff979692 100644 --- a/ext/misc/series.c +++ b/ext/misc/series.c @@ -659,7 +659,7 @@ static int seriesBestIndex( continue; } if( pConstraint->iColumn<SERIES_COLUMN_START ){ - if( pConstraint->iColumn==SERIES_COLUMN_VALUE ){ + if( pConstraint->iColumn==SERIES_COLUMN_VALUE && pConstraint->usable ){ switch( op ){ case SQLITE_INDEX_CONSTRAINT_EQ: case SQLITE_INDEX_CONSTRAINT_IS: { |