SQLite

Check-in [2131a5ca53]
Login

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

Overview
Comment:Add support for CREATE INDEX statements that use deterministic expressions rather than only column names.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 2131a5ca53f0e9b0b98a9dd9a20e495d54d146a7
User & Date: drh 2015-09-04 17:32:19.351
References
2023-03-24
16:57
Fix byte-code register allocation in ANALYZE for STAT4 when there multiple indexes with differing numbers of columns. forum post bc39e531e5. This problem arose when expression indexes were added by check-in [2131a5ca53f0e9b0]. (check-in: 2bf5413dc2 user: drh tags: trunk)
2018-04-24
14:30 New ticket [4ba5abf65c] Index on expression leads to an incorrect LEFT JOIN. (artifact: e5a141f806 user: drh)
Context
2015-09-04
18:03
Fix over-length source code lines in Lemon. (check-in: 1efece95ff user: drh tags: trunk)
17:32
Add support for CREATE INDEX statements that use deterministic expressions rather than only column names. (check-in: 2131a5ca53 user: drh tags: trunk)
13:02
Merge trunk enhancements, and espeically the fix for allowing strings as column identifers in CREATE INDEX statements. (Closed-Leaf check-in: 5ff8552938 user: drh tags: index-expr)
12:54
Continue to support the (broken) legacy syntax of allowing strings for column names in CREATE INDEX statements and in UNIQUE and PRIMARY KEY constraints. (check-in: 3d3df79bfa user: drh tags: trunk)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/analyze.c.
Changes to src/build.c.
Changes to src/date.c.
Changes to src/delete.c.
Changes to src/expr.c.
Changes to src/func.c.
Changes to src/insert.c.
Changes to src/resolve.c.
Changes to src/shell.c.
Changes to src/sqliteInt.h.
Changes to src/update.c.
Changes to src/vdbeblob.c.
Changes to src/where.c.
Changes to src/whereInt.h.
Changes to src/wherecode.c.
Changes to src/whereexpr.c.
Changes to test/index.test.
Added test/indexexpr1.test.
Changes to test/rowid.test.