/ Check-in [0a7f2051]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Where possible insert the set of new keys for each index in sorted order within "INSERT INTO ... SELECT" statements.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | insert-select-opt
Files: files | file ages | folders
SHA1: 0a7f2051b2cc9b4e060fd6081587502124e16c9e
User & Date: dan 2015-03-20 20:30:26
Context
2015-03-21
07:03
Disable the sorter optimization used by INSERT INTO SELECT statements if the statement explicitly specifies REPLACE, IGNORE or FAIL conflict handling. check-in: d4215942 user: dan tags: insert-select-opt
2015-03-20
20:30
Where possible insert the set of new keys for each index in sorted order within "INSERT INTO ... SELECT" statements. check-in: 0a7f2051 user: dan tags: insert-select-opt
08:43
Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. check-in: eddc05e7 user: dan tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/insert.c.

Changes to src/sqliteInt.h.

Changes to src/update.c.

Changes to src/vdbe.c.

Changes to test/e_vacuum.test.

Added test/insert6.test.

Changes to test/stat.test.

Changes to test/wal.test.