/ Check-in [6251e438]

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

Comment:Merge recent enhancements from trunk.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | location-function
Files: files | file ages | folders
SHA3-256: 6251e438f2a76170fd1e95aa512a46086ed88ab93b9b97a1dba97c4558689305
User & Date: drh 2017-12-29 13:35:09
Enhance location(X) so that it works with indexes and WITHOUT ROWID tables. The function might return an offset to the main table or to an index, depending on whether the column X would be loaded from the main table or from the index. check-in: dd94d6a8 user: drh tags: location-function
Merge recent enhancements from trunk. check-in: 6251e438 user: drh tags: location-function
Add test cases for the undocumented behavior of duplicate columns on an INSERT or UPDATE. check-in: f4349c0c user: drh tags: trunk
Add an experimental location(X) SQL function that attempt to return the location of the payload within the database for the record that contains column X. location(X) returns NULL if X is not an ordinary table column or if SQLite cannot figure out the location because it is using a covering index. check-in: 51be9558 user: drh tags: location-function
Unified Diffs Side-by-Side Diffs Patch

Changes to ext/expert/expert1.test.

Changes to ext/expert/sqlite3expert.c.

Changes to ext/fts5/fts5_aux.c.

Changes to ext/fts5/test/fts5af.test.

Changes to ext/misc/shathree.c.

Changes to main.mk.

Changes to src/build.c.

Changes to src/expr.c.

Changes to src/loadext.c.

Changes to src/main.c.

Changes to src/malloc.c.

Changes to src/parse.y.

Changes to src/select.c.

Changes to src/shell.c.in.

Changes to src/sqlite.h.in.

Changes to src/sqliteInt.h.

Changes to src/treeview.c.

Changes to src/trigger.c.

Changes to src/util.c.

Changes to src/vdbe.c.

Changes to src/vdbeaux.c.

Changes to src/where.c.

Changes to src/wherecode.c.

Changes to test/capi2.test.

Changes to test/colname.test.

Changes to test/fkey1.test.

Changes to test/misc1.test.

Changes to test/speedtest1.c.

Changes to test/tester.tcl.

Changes to test/trace.test.

Changes to tool/lemon.c.

Changes to tool/lempar.c.

Changes to tool/speed-check.sh.