/ Check-in [b23ae131]
Login

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

Overview
Comment:Improved handling of OR terms in the WHERE clause with multi-column indexes.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b23ae131874bc5c621f0f5ea8d76fce1ec089cc2
User & Date: drh 2011-10-07 17:52:40
References
2013-05-09
13:38 New ticket [f2369304] Incorrect results when OR is used in the ON clause of a LEFT JOIN. artifact: 979fa9ab user: drh
2012-03-09
16:58 New ticket [b7c8682c] Incorrect result from LEFT JOIN with OR in the WHERE clause. artifact: 7aedf2b6 user: drh
Context
2011-10-07
18:24
Make sure sqlite3_data_count() behaves as documented, even for EXPLAIN QUERY PLAN queries. check-in: d4f95b3b user: drh tags: trunk
17:52
Improved handling of OR terms in the WHERE clause with multi-column indexes. check-in: b23ae131 user: drh tags: trunk
17:45
Add testcase() macros to ensure good test coverage. Closed-Leaf check-in: 5c132592 user: drh tags: or-opt
16:57
Add the SQLITE_FCNTL_OVERWRITE file-control. Used by SQLite to indicate to the OS layer that the current transaction will overwrite the entire file. check-in: 1da87fcd user: dan tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/sqliteInt.h.

Changes to src/where.c.

Changes to test/where7.test.

Changes to test/where9.test.