/ Check-in [93e28ea1]
Login

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

Overview
Comment:Do not use sorters for INSERT statements that insert multiple rows using the VALUES clause.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | insert-select-opt
Files: files | file ages | folders
SHA1: 93e28ea1ef41f274c5685f3bbb93a4d9ad44c880
User & Date: dan 2015-03-21 15:26:42
Context
2015-03-23
14:39
Set the OPFLAG_SEEKRESULT correctly in "INSERT INTO ... SELECT" statements. check-in: 6f7d9995 user: dan tags: insert-select-opt
2015-03-21
15:26
Do not use sorters for INSERT statements that insert multiple rows using the VALUES clause. check-in: 93e28ea1 user: dan tags: insert-select-opt
15:04
Merge latest trunk changes with this branch. check-in: 9affe7f3 user: dan tags: insert-select-opt
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/insert.c.

   782    782       **
   783    783       **    * there are no triggers to fire, and
   784    784       **    * no foreign key processing to perform, and
   785    785       **    * the on-conflict mode used for all UNIQUE and PRIMARY KEY indexes, 
   786    786       **      including INTEGER PRIMARY KEYs, is either ROLLBACK or ABORT.
   787    787       */
   788    788       if( pSelect 
          789  +     && 0==(pSelect->selFlags & SF_Values)
   789    790        && onError!=OE_Fail && onError!=OE_Replace && onError!=OE_Ignore
   790    791        && !IsVirtual(pTab) 
   791    792        && pTrigger==0 
   792    793        && 0==sqlite3FkRequired(pParse, pTab, 0, 0) 
   793    794       ){
   794    795         for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){
   795    796           u8 oe = idxConflictMode(pIdx, onError);