/ Check-in [2cef8b68]
Login

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

Overview
Comment:Allow an index to be used for sorting even if prior terms of the index are constrained by IN operators.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 2cef8b68f0e1216cf68bb7dd45a5a9a330748070
User & Date: drh 2013-02-13 01:00:35
References
2013-03-12
17:34 New ticket [4dd95f69] Inverted result order with ORDER BY DESC and a DESC index.. artifact: 8f409867 user: drh
Context
2013-02-13
14:04
Add recent API additions to the extension mechanism. check-in: 7e10a62d user: drh tags: trunk
13:42
Enhancements to the query planner to make use of indices for ORDER BY even when IN constraints are in the WHERE clause. Add extended error codes for all SQLITE_CONSTRAINT errors. check-in: 7e14dc73 user: drh tags: sessions
01:00
Allow an index to be used for sorting even if prior terms of the index are constrained by IN operators. check-in: 2cef8b68 user: drh tags: trunk
2013-02-12
22:20
Improve memory allocation error handling on WinCE. check-in: cdbca259 user: drh tags: trunk
2013-02-08
23:18
Fix a potential NULL-pointer dereference following an OOM error in the query planner logic for virtual tables with OR-connected terms. Closed-Leaf check-in: 71b6c260 user: drh tags: IN-with-ORDERBY
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/sqliteInt.h.

Changes to src/where.c.

Changes to test/where.test.

Changes to test/where2.test.