SQLite

Check-in [1e227ad9f4]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add the SQLITE_INDEX_CONSTRAINT_LIMIT and SQLITE_INDEX_CONSTRAINT_OFFSET constraints to the sqlite3_index_info for the xBestIndex method of virtual tables.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 1e227ad9f413227f767b45b91e5439b82c98a3368fb20643414dab5c0f4818c6
User & Date: drh 2022-01-28 23:44:27.760
References
2024-04-26
19:10
Fix issues in LIMIT/OFFSET support for virtual tables. The first problem was reported by forum post c243b8f856. That report prompted an enhancement to the generate_series() (also included in this merge) which in turn identified other similar issues. (check-in: 5f6c079d84 user: drh tags: trunk)
Context
2022-01-29
21:41
Documentation enhancements. No code changes. (check-in: 312642d982 user: drh tags: trunk)
2022-01-28
23:44
Add the SQLITE_INDEX_CONSTRAINT_LIMIT and SQLITE_INDEX_CONSTRAINT_OFFSET constraints to the sqlite3_index_info for the xBestIndex method of virtual tables. (check-in: 1e227ad9f4 user: drh tags: trunk)
23:19
Add a NEVER() on an unreachable branch. (Closed-Leaf check-in: 388926254b user: drh tags: vtab-limit-offset)
21:39
When nesting Parse objects, make sure the new one has nErr set if there has been an OOM error. (check-in: ae088cbc96 user: drh tags: trunk)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to ext/misc/qpvtab.c.
Changes to src/delete.c.
Changes to src/fkey.c.
Changes to src/select.c.
Changes to src/sqlite.h.in.
Changes to src/sqliteInt.h.
Changes to src/test_bestindex.c.
Changes to src/update.c.
Changes to src/vdbemem.c.
Changes to src/where.c.
Changes to src/whereInt.h.
Changes to src/wherecode.c.
Changes to src/whereexpr.c.