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