SQLite Forum

Is it possible to switch off: ability to find a full-index-scan query plan for queries using INDEXED BY ?
Login

Is it possible to switch off: ability to find a full-index-scan query plan for queries using INDEXED BY ?

(1) By anonymous on 2021-06-11 08:23:08 [source]

From: https://www.sqlite.org/changes.html version: 2020-08-14 (3.33.0), point 7a: Add the ability to find a full-index-scan query plan for queries using INDEXED BY which previously would fail with "no query solution".

Is it possible to switch this off ? So we get the old behavior(failing with "no query solution") back. Context: the tables are potentially so large that the running time would be too long. We rather have the error and fix the indices.