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: |
2131a5ca53f0e9b0b98a9dd9a20e495d |
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
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.