SQLite

Check-in [a52ef2ad7c]
Login

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

Overview
Comment:Proof of concept for the ability to use the expression columns in an index on expressions in place of equivalent expressions in the result set or in the WHERE clause. This check-in compiles but is mostly untested.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | covering-index-on-expr
Files: files | file ages | folders
SHA3-256: a52ef2ad7c0e14b78b801f16a1f6ea8d8fa9ae5d7d810e18dd24c600b662a312
User & Date: drh 2017-04-07 19:41:31.032
Context
2017-04-07
19:52
Remove an unused token type. (check-in: 13a422230d user: drh tags: covering-index-on-expr)
19:41
Proof of concept for the ability to use the expression columns in an index on expressions in place of equivalent expressions in the result set or in the WHERE clause. This check-in compiles but is mostly untested. (check-in: a52ef2ad7c user: drh tags: covering-index-on-expr)
2017-04-06
14:56
Fix the ".lint fkey" shell command for cases where the child key is also an INTEGER PRIMARY KEY. (check-in: 48826b222c user: dan tags: trunk)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/expr.c.
Changes to src/select.c.
Changes to src/sqliteInt.h.
Changes to src/where.c.
Changes to src/whereInt.h.
Changes to src/wherecode.c.
Changes to tool/addopcodes.tcl.