SQLite

Check-in [0ba6d709b5]
Login

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

Overview
Comment:Do not assume that "x IS NOT ?" implies "x NOT NULL" when considering partial indexes. Fix for ticket [8025674847].
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 0ba6d709b50d92db1542f2ff30535a80184b00dadf759d51e5cae7a6e37b1764
User & Date: dan 2019-05-11 13:04:33.943
References
2019-05-11
13:05 Closed ticket [8025674847]: Incorrect use of "WHERE x NOT NULL" index for query with a "WHERE x IS NOT ?" term plus 4 other changes (artifact: 6f695f82c4 user: dan)
Context
2019-05-11
16:14
When considering partial indexes, do not assume that a "CASE x ..." expression implies "x IS NOT NULL". (check-in: 1b24303220 user: dan tags: trunk)
13:04
Do not assume that "x IS NOT ?" implies "x NOT NULL" when considering partial indexes. Fix for ticket [8025674847]. (check-in: 0ba6d709b5 user: dan tags: trunk)
2019-05-10
20:44
Add tests for the RBU module. (check-in: a194e53670 user: dan tags: trunk)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/expr.c.
Changes to test/index6.test.