/ Check-in [2131a5ca]
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 | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 2131a5ca53f0e9b0b98a9dd9a20e495d54d146a7
User & Date: drh 2015-09-04 17:32:19
References
2018-04-24
14:30 New ticket [4ba5abf6] Index on expression leads to an incorrect LEFT JOIN. artifact: e5a141f8 user: drh
Context
2015-09-04
18:03
Fix over-length source code lines in Lemon. check-in: 1efece95 user: drh tags: trunk
17:32
Add support for CREATE INDEX statements that use deterministic expressions rather than only column names. check-in: 2131a5ca 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: 5ff85529 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: 3d3df79b user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs 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.