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.