1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/sqlite3api/SQLite/delete.c Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,550 @@
1.4 +/*
1.5 +** 2001 September 15
1.6 +**
1.7 +** The author disclaims copyright to this source code. In place of
1.8 +** a legal notice, here is a blessing:
1.9 +**
1.10 +** May you do good and not evil.
1.11 +** May you find forgiveness for yourself and forgive others.
1.12 +** May you share freely, never taking more than you give.
1.13 +**
1.14 +*************************************************************************
1.15 +** This file contains C code routines that are called by the parser
1.16 +** in order to generate code for DELETE FROM statements.
1.17 +**
1.18 +** $Id: delete.c,v 1.175 2008/09/01 21:59:43 shane Exp $
1.19 +*/
1.20 +#include "sqliteInt.h"
1.21 +
1.22 +/*
1.23 +** Look up every table that is named in pSrc. If any table is not found,
1.24 +** add an error message to pParse->zErrMsg and return NULL. If all tables
1.25 +** are found, return a pointer to the last table.
1.26 +*/
1.27 +Table *sqlite3SrcListLookup(Parse *pParse, SrcList *pSrc){
1.28 + Table *pTab = 0;
1.29 + int i;
1.30 + struct SrcList_item *pItem;
1.31 + for(i=0, pItem=pSrc->a; i<pSrc->nSrc; i++, pItem++){
1.32 + pTab = sqlite3LocateTable(pParse, 0, pItem->zName, pItem->zDatabase);
1.33 + sqlite3DeleteTable(pItem->pTab);
1.34 + pItem->pTab = pTab;
1.35 + if( pTab ){
1.36 + pTab->nRef++;
1.37 + }
1.38 + }
1.39 + return pTab;
1.40 +}
1.41 +
1.42 +/*
1.43 +** Check to make sure the given table is writable. If it is not
1.44 +** writable, generate an error message and return 1. If it is
1.45 +** writable return 0;
1.46 +*/
1.47 +int sqlite3IsReadOnly(Parse *pParse, Table *pTab, int viewOk){
1.48 + if( ((pTab->tabFlags & TF_Readonly)!=0
1.49 + && (pParse->db->flags & SQLITE_WriteSchema)==0
1.50 + && pParse->nested==0)
1.51 +#ifndef SQLITE_OMIT_VIRTUALTABLE
1.52 + || (pTab->pMod && pTab->pMod->pModule->xUpdate==0)
1.53 +#endif
1.54 + ){
1.55 + sqlite3ErrorMsg(pParse, "table %s may not be modified", pTab->zName);
1.56 + return 1;
1.57 + }
1.58 +#ifndef SQLITE_OMIT_VIEW
1.59 + if( !viewOk && pTab->pSelect ){
1.60 + sqlite3ErrorMsg(pParse,"cannot modify %s because it is a view",pTab->zName);
1.61 + return 1;
1.62 + }
1.63 +#endif
1.64 + return 0;
1.65 +}
1.66 +
1.67 +/*
1.68 +** Generate code that will open a table for reading.
1.69 +*/
1.70 +void sqlite3OpenTable(
1.71 + Parse *p, /* Generate code into this VDBE */
1.72 + int iCur, /* The cursor number of the table */
1.73 + int iDb, /* The database index in sqlite3.aDb[] */
1.74 + Table *pTab, /* The table to be opened */
1.75 + int opcode /* OP_OpenRead or OP_OpenWrite */
1.76 +){
1.77 + Vdbe *v;
1.78 + if( IsVirtual(pTab) ) return;
1.79 + v = sqlite3GetVdbe(p);
1.80 + assert( opcode==OP_OpenWrite || opcode==OP_OpenRead );
1.81 + sqlite3TableLock(p, iDb, pTab->tnum, (opcode==OP_OpenWrite), pTab->zName);
1.82 + sqlite3VdbeAddOp2(v, OP_SetNumColumns, 0, pTab->nCol);
1.83 + sqlite3VdbeAddOp3(v, opcode, iCur, pTab->tnum, iDb);
1.84 + VdbeComment((v, "%s", pTab->zName));
1.85 +}
1.86 +
1.87 +
1.88 +#if !defined(SQLITE_OMIT_VIEW) && !defined(SQLITE_OMIT_TRIGGER)
1.89 +/*
1.90 +** Evaluate a view and store its result in an ephemeral table. The
1.91 +** pWhere argument is an optional WHERE clause that restricts the
1.92 +** set of rows in the view that are to be added to the ephemeral table.
1.93 +*/
1.94 +void sqlite3MaterializeView(
1.95 + Parse *pParse, /* Parsing context */
1.96 + Table *pView, /* View definition */
1.97 + Expr *pWhere, /* Optional WHERE clause to be added */
1.98 + int iCur /* Cursor number for ephemerial table */
1.99 +){
1.100 + SelectDest dest;
1.101 + Select *pDup;
1.102 + sqlite3 *db = pParse->db;
1.103 +
1.104 + pDup = sqlite3SelectDup(db, pView->pSelect);
1.105 + if( pWhere ){
1.106 + SrcList *pFrom;
1.107 + Token viewName;
1.108 +
1.109 + pWhere = sqlite3ExprDup(db, pWhere);
1.110 + viewName.z = (u8*)pView->zName;
1.111 + viewName.n = (unsigned int)strlen((const char*)viewName.z);
1.112 + pFrom = sqlite3SrcListAppendFromTerm(pParse, 0, 0, 0, &viewName, pDup, 0,0);
1.113 + pDup = sqlite3SelectNew(pParse, 0, pFrom, pWhere, 0, 0, 0, 0, 0, 0);
1.114 + }
1.115 + sqlite3SelectDestInit(&dest, SRT_EphemTab, iCur);
1.116 + sqlite3Select(pParse, pDup, &dest);
1.117 + sqlite3SelectDelete(db, pDup);
1.118 +}
1.119 +#endif /* !defined(SQLITE_OMIT_VIEW) && !defined(SQLITE_OMIT_TRIGGER) */
1.120 +
1.121 +
1.122 +/*
1.123 +** Generate code for a DELETE FROM statement.
1.124 +**
1.125 +** DELETE FROM table_wxyz WHERE a<5 AND b NOT NULL;
1.126 +** \________/ \________________/
1.127 +** pTabList pWhere
1.128 +*/
1.129 +void sqlite3DeleteFrom(
1.130 + Parse *pParse, /* The parser context */
1.131 + SrcList *pTabList, /* The table from which we should delete things */
1.132 + Expr *pWhere /* The WHERE clause. May be null */
1.133 +){
1.134 + Vdbe *v; /* The virtual database engine */
1.135 + Table *pTab; /* The table from which records will be deleted */
1.136 + const char *zDb; /* Name of database holding pTab */
1.137 + int end, addr = 0; /* A couple addresses of generated code */
1.138 + int i; /* Loop counter */
1.139 + WhereInfo *pWInfo; /* Information about the WHERE clause */
1.140 + Index *pIdx; /* For looping over indices of the table */
1.141 + int iCur; /* VDBE Cursor number for pTab */
1.142 + sqlite3 *db; /* Main database structure */
1.143 + AuthContext sContext; /* Authorization context */
1.144 + int oldIdx = -1; /* Cursor for the OLD table of AFTER triggers */
1.145 + NameContext sNC; /* Name context to resolve expressions in */
1.146 + int iDb; /* Database number */
1.147 + int memCnt = 0; /* Memory cell used for change counting */
1.148 +
1.149 +#ifndef SQLITE_OMIT_TRIGGER
1.150 + int isView; /* True if attempting to delete from a view */
1.151 + int triggers_exist = 0; /* True if any triggers exist */
1.152 +#endif
1.153 + int iBeginAfterTrigger; /* Address of after trigger program */
1.154 + int iEndAfterTrigger; /* Exit of after trigger program */
1.155 + int iBeginBeforeTrigger; /* Address of before trigger program */
1.156 + int iEndBeforeTrigger; /* Exit of before trigger program */
1.157 + u32 old_col_mask = 0; /* Mask of OLD.* columns in use */
1.158 +
1.159 + sContext.pParse = 0;
1.160 + db = pParse->db;
1.161 + if( pParse->nErr || db->mallocFailed ){
1.162 + goto delete_from_cleanup;
1.163 + }
1.164 + assert( pTabList->nSrc==1 );
1.165 +
1.166 + /* Locate the table which we want to delete. This table has to be
1.167 + ** put in an SrcList structure because some of the subroutines we
1.168 + ** will be calling are designed to work with multiple tables and expect
1.169 + ** an SrcList* parameter instead of just a Table* parameter.
1.170 + */
1.171 + pTab = sqlite3SrcListLookup(pParse, pTabList);
1.172 + if( pTab==0 ) goto delete_from_cleanup;
1.173 +
1.174 + /* Figure out if we have any triggers and if the table being
1.175 + ** deleted from is a view
1.176 + */
1.177 +#ifndef SQLITE_OMIT_TRIGGER
1.178 + triggers_exist = sqlite3TriggersExist(pParse, pTab, TK_DELETE, 0);
1.179 + isView = pTab->pSelect!=0;
1.180 +#else
1.181 +# define triggers_exist 0
1.182 +# define isView 0
1.183 +#endif
1.184 +#ifdef SQLITE_OMIT_VIEW
1.185 +# undef isView
1.186 +# define isView 0
1.187 +#endif
1.188 +
1.189 + if( sqlite3IsReadOnly(pParse, pTab, triggers_exist) ){
1.190 + goto delete_from_cleanup;
1.191 + }
1.192 + iDb = sqlite3SchemaToIndex(db, pTab->pSchema);
1.193 + assert( iDb<db->nDb );
1.194 + zDb = db->aDb[iDb].zName;
1.195 + if( sqlite3AuthCheck(pParse, SQLITE_DELETE, pTab->zName, 0, zDb) ){
1.196 + goto delete_from_cleanup;
1.197 + }
1.198 +
1.199 + /* If pTab is really a view, make sure it has been initialized.
1.200 + */
1.201 + if( sqlite3ViewGetColumnNames(pParse, pTab) ){
1.202 + goto delete_from_cleanup;
1.203 + }
1.204 +
1.205 + /* Allocate a cursor used to store the old.* data for a trigger.
1.206 + */
1.207 + if( triggers_exist ){
1.208 + oldIdx = pParse->nTab++;
1.209 + }
1.210 +
1.211 + /* Assign cursor number to the table and all its indices.
1.212 + */
1.213 + assert( pTabList->nSrc==1 );
1.214 + iCur = pTabList->a[0].iCursor = pParse->nTab++;
1.215 + for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){
1.216 + pParse->nTab++;
1.217 + }
1.218 +
1.219 + /* Start the view context
1.220 + */
1.221 + if( isView ){
1.222 + sqlite3AuthContextPush(pParse, &sContext, pTab->zName);
1.223 + }
1.224 +
1.225 + /* Begin generating code.
1.226 + */
1.227 + v = sqlite3GetVdbe(pParse);
1.228 + if( v==0 ){
1.229 + goto delete_from_cleanup;
1.230 + }
1.231 + if( pParse->nested==0 ) sqlite3VdbeCountChanges(v);
1.232 + sqlite3BeginWriteOperation(pParse, triggers_exist, iDb);
1.233 +
1.234 + if( triggers_exist ){
1.235 + int orconf = ((pParse->trigStack)?pParse->trigStack->orconf:OE_Default);
1.236 + int iGoto = sqlite3VdbeAddOp0(v, OP_Goto);
1.237 + addr = sqlite3VdbeMakeLabel(v);
1.238 +
1.239 + iBeginBeforeTrigger = sqlite3VdbeCurrentAddr(v);
1.240 + (void)sqlite3CodeRowTrigger(pParse, TK_DELETE, 0, TRIGGER_BEFORE, pTab,
1.241 + -1, oldIdx, orconf, addr, &old_col_mask, 0);
1.242 + iEndBeforeTrigger = sqlite3VdbeAddOp0(v, OP_Goto);
1.243 +
1.244 + iBeginAfterTrigger = sqlite3VdbeCurrentAddr(v);
1.245 + (void)sqlite3CodeRowTrigger(pParse, TK_DELETE, 0, TRIGGER_AFTER, pTab, -1,
1.246 + oldIdx, orconf, addr, &old_col_mask, 0);
1.247 + iEndAfterTrigger = sqlite3VdbeAddOp0(v, OP_Goto);
1.248 +
1.249 + sqlite3VdbeJumpHere(v, iGoto);
1.250 + }
1.251 +
1.252 + /* If we are trying to delete from a view, realize that view into
1.253 + ** a ephemeral table.
1.254 + */
1.255 +#if !defined(SQLITE_OMIT_VIEW) && !defined(SQLITE_OMIT_TRIGGER)
1.256 + if( isView ){
1.257 + sqlite3MaterializeView(pParse, pTab, pWhere, iCur);
1.258 + }
1.259 +#endif
1.260 +
1.261 + /* Resolve the column names in the WHERE clause.
1.262 + */
1.263 + memset(&sNC, 0, sizeof(sNC));
1.264 + sNC.pParse = pParse;
1.265 + sNC.pSrcList = pTabList;
1.266 + if( sqlite3ResolveExprNames(&sNC, pWhere) ){
1.267 + goto delete_from_cleanup;
1.268 + }
1.269 +
1.270 + /* Initialize the counter of the number of rows deleted, if
1.271 + ** we are counting rows.
1.272 + */
1.273 + if( db->flags & SQLITE_CountRows ){
1.274 + memCnt = ++pParse->nMem;
1.275 + sqlite3VdbeAddOp2(v, OP_Integer, 0, memCnt);
1.276 + }
1.277 +
1.278 + /* Special case: A DELETE without a WHERE clause deletes everything.
1.279 + ** It is easier just to erase the whole table. Note, however, that
1.280 + ** this means that the row change count will be incorrect.
1.281 + */
1.282 + if( pWhere==0 && !triggers_exist && !IsVirtual(pTab) ){
1.283 + if( db->flags & SQLITE_CountRows ){
1.284 + /* If counting rows deleted, just count the total number of
1.285 + ** entries in the table. */
1.286 + int addr2;
1.287 + if( !isView ){
1.288 + sqlite3OpenTable(pParse, iCur, iDb, pTab, OP_OpenRead);
1.289 + }
1.290 + sqlite3VdbeAddOp2(v, OP_Rewind, iCur, sqlite3VdbeCurrentAddr(v)+2);
1.291 + addr2 = sqlite3VdbeAddOp2(v, OP_AddImm, memCnt, 1);
1.292 + sqlite3VdbeAddOp2(v, OP_Next, iCur, addr2);
1.293 + sqlite3VdbeAddOp1(v, OP_Close, iCur);
1.294 + }
1.295 + if( !isView ){
1.296 + sqlite3VdbeAddOp2(v, OP_Clear, pTab->tnum, iDb);
1.297 + if( !pParse->nested ){
1.298 + sqlite3VdbeChangeP4(v, -1, pTab->zName, P4_STATIC);
1.299 + }
1.300 + for(pIdx=pTab->pIndex; pIdx; pIdx=pIdx->pNext){
1.301 + assert( pIdx->pSchema==pTab->pSchema );
1.302 + sqlite3VdbeAddOp2(v, OP_Clear, pIdx->tnum, iDb);
1.303 + }
1.304 + }
1.305 + }
1.306 + /* The usual case: There is a WHERE clause so we have to scan through
1.307 + ** the table and pick which records to delete.
1.308 + */
1.309 + else{
1.310 + int iRowid = ++pParse->nMem; /* Used for storing rowid values. */
1.311 +
1.312 + /* Begin the database scan
1.313 + */
1.314 + pWInfo = sqlite3WhereBegin(pParse, pTabList, pWhere, 0, 0);
1.315 + if( pWInfo==0 ) goto delete_from_cleanup;
1.316 +
1.317 + /* Remember the rowid of every item to be deleted.
1.318 + */
1.319 + sqlite3VdbeAddOp2(v, IsVirtual(pTab) ? OP_VRowid : OP_Rowid, iCur, iRowid);
1.320 + sqlite3VdbeAddOp1(v, OP_FifoWrite, iRowid);
1.321 + if( db->flags & SQLITE_CountRows ){
1.322 + sqlite3VdbeAddOp2(v, OP_AddImm, memCnt, 1);
1.323 + }
1.324 +
1.325 + /* End the database scan loop.
1.326 + */
1.327 + sqlite3WhereEnd(pWInfo);
1.328 +
1.329 + /* Open the pseudo-table used to store OLD if there are triggers.
1.330 + */
1.331 + if( triggers_exist ){
1.332 + sqlite3VdbeAddOp2(v, OP_SetNumColumns, 0, pTab->nCol);
1.333 + sqlite3VdbeAddOp1(v, OP_OpenPseudo, oldIdx);
1.334 + }
1.335 +
1.336 + /* Delete every item whose key was written to the list during the
1.337 + ** database scan. We have to delete items after the scan is complete
1.338 + ** because deleting an item can change the scan order.
1.339 + */
1.340 + end = sqlite3VdbeMakeLabel(v);
1.341 +
1.342 + if( !isView ){
1.343 + /* Open cursors for the table we are deleting from and
1.344 + ** all its indices.
1.345 + */
1.346 + sqlite3OpenTableAndIndices(pParse, pTab, iCur, OP_OpenWrite);
1.347 + }
1.348 +
1.349 + /* This is the beginning of the delete loop. If a trigger encounters
1.350 + ** an IGNORE constraint, it jumps back to here.
1.351 + */
1.352 + if( triggers_exist ){
1.353 + sqlite3VdbeResolveLabel(v, addr);
1.354 + }
1.355 + addr = sqlite3VdbeAddOp2(v, OP_FifoRead, iRowid, end);
1.356 +
1.357 + if( triggers_exist ){
1.358 + int iData = ++pParse->nMem; /* For storing row data of OLD table */
1.359 +
1.360 + /* If the record is no longer present in the table, jump to the
1.361 + ** next iteration of the loop through the contents of the fifo.
1.362 + */
1.363 + sqlite3VdbeAddOp3(v, OP_NotExists, iCur, addr, iRowid);
1.364 +
1.365 + /* Populate the OLD.* pseudo-table */
1.366 + if( old_col_mask ){
1.367 + sqlite3VdbeAddOp2(v, OP_RowData, iCur, iData);
1.368 + }else{
1.369 + sqlite3VdbeAddOp2(v, OP_Null, 0, iData);
1.370 + }
1.371 + sqlite3VdbeAddOp3(v, OP_Insert, oldIdx, iData, iRowid);
1.372 +
1.373 + /* Jump back and run the BEFORE triggers */
1.374 + sqlite3VdbeAddOp2(v, OP_Goto, 0, iBeginBeforeTrigger);
1.375 + sqlite3VdbeJumpHere(v, iEndBeforeTrigger);
1.376 + }
1.377 +
1.378 + if( !isView ){
1.379 + /* Delete the row */
1.380 +#ifndef SQLITE_OMIT_VIRTUALTABLE
1.381 + if( IsVirtual(pTab) ){
1.382 + const char *pVtab = (const char *)pTab->pVtab;
1.383 + sqlite3VtabMakeWritable(pParse, pTab);
1.384 + sqlite3VdbeAddOp4(v, OP_VUpdate, 0, 1, iRowid, pVtab, P4_VTAB);
1.385 + }else
1.386 +#endif
1.387 + {
1.388 + sqlite3GenerateRowDelete(pParse, pTab, iCur, iRowid, pParse->nested==0);
1.389 + }
1.390 + }
1.391 +
1.392 + /* If there are row triggers, close all cursors then invoke
1.393 + ** the AFTER triggers
1.394 + */
1.395 + if( triggers_exist ){
1.396 + /* Jump back and run the AFTER triggers */
1.397 + sqlite3VdbeAddOp2(v, OP_Goto, 0, iBeginAfterTrigger);
1.398 + sqlite3VdbeJumpHere(v, iEndAfterTrigger);
1.399 + }
1.400 +
1.401 + /* End of the delete loop */
1.402 + sqlite3VdbeAddOp2(v, OP_Goto, 0, addr);
1.403 + sqlite3VdbeResolveLabel(v, end);
1.404 +
1.405 + /* Close the cursors after the loop if there are no row triggers */
1.406 + if( !isView && !IsVirtual(pTab) ){
1.407 + for(i=1, pIdx=pTab->pIndex; pIdx; i++, pIdx=pIdx->pNext){
1.408 + sqlite3VdbeAddOp2(v, OP_Close, iCur + i, pIdx->tnum);
1.409 + }
1.410 + sqlite3VdbeAddOp1(v, OP_Close, iCur);
1.411 + }
1.412 + }
1.413 +
1.414 + /*
1.415 + ** Return the number of rows that were deleted. If this routine is
1.416 + ** generating code because of a call to sqlite3NestedParse(), do not
1.417 + ** invoke the callback function.
1.418 + */
1.419 + if( db->flags & SQLITE_CountRows && pParse->nested==0 && !pParse->trigStack ){
1.420 + sqlite3VdbeAddOp2(v, OP_ResultRow, memCnt, 1);
1.421 + sqlite3VdbeSetNumCols(v, 1);
1.422 + sqlite3VdbeSetColName(v, 0, COLNAME_NAME, "rows deleted", P4_STATIC);
1.423 + }
1.424 +
1.425 +delete_from_cleanup:
1.426 + sqlite3AuthContextPop(&sContext);
1.427 + sqlite3SrcListDelete(db, pTabList);
1.428 + sqlite3ExprDelete(db, pWhere);
1.429 + return;
1.430 +}
1.431 +
1.432 +/*
1.433 +** This routine generates VDBE code that causes a single row of a
1.434 +** single table to be deleted.
1.435 +**
1.436 +** The VDBE must be in a particular state when this routine is called.
1.437 +** These are the requirements:
1.438 +**
1.439 +** 1. A read/write cursor pointing to pTab, the table containing the row
1.440 +** to be deleted, must be opened as cursor number "base".
1.441 +**
1.442 +** 2. Read/write cursors for all indices of pTab must be open as
1.443 +** cursor number base+i for the i-th index.
1.444 +**
1.445 +** 3. The record number of the row to be deleted must be stored in
1.446 +** memory cell iRowid.
1.447 +**
1.448 +** This routine pops the top of the stack to remove the record number
1.449 +** and then generates code to remove both the table record and all index
1.450 +** entries that point to that record.
1.451 +*/
1.452 +void sqlite3GenerateRowDelete(
1.453 + Parse *pParse, /* Parsing context */
1.454 + Table *pTab, /* Table containing the row to be deleted */
1.455 + int iCur, /* Cursor number for the table */
1.456 + int iRowid, /* Memory cell that contains the rowid to delete */
1.457 + int count /* Increment the row change counter */
1.458 +){
1.459 + int addr;
1.460 + Vdbe *v;
1.461 +
1.462 + v = pParse->pVdbe;
1.463 + addr = sqlite3VdbeAddOp3(v, OP_NotExists, iCur, 0, iRowid);
1.464 + sqlite3GenerateRowIndexDelete(pParse, pTab, iCur, 0);
1.465 + sqlite3VdbeAddOp2(v, OP_Delete, iCur, (count?OPFLAG_NCHANGE:0));
1.466 + if( count ){
1.467 + sqlite3VdbeChangeP4(v, -1, pTab->zName, P4_STATIC);
1.468 + }
1.469 + sqlite3VdbeJumpHere(v, addr);
1.470 +}
1.471 +
1.472 +/*
1.473 +** This routine generates VDBE code that causes the deletion of all
1.474 +** index entries associated with a single row of a single table.
1.475 +**
1.476 +** The VDBE must be in a particular state when this routine is called.
1.477 +** These are the requirements:
1.478 +**
1.479 +** 1. A read/write cursor pointing to pTab, the table containing the row
1.480 +** to be deleted, must be opened as cursor number "iCur".
1.481 +**
1.482 +** 2. Read/write cursors for all indices of pTab must be open as
1.483 +** cursor number iCur+i for the i-th index.
1.484 +**
1.485 +** 3. The "iCur" cursor must be pointing to the row that is to be
1.486 +** deleted.
1.487 +*/
1.488 +void sqlite3GenerateRowIndexDelete(
1.489 + Parse *pParse, /* Parsing and code generating context */
1.490 + Table *pTab, /* Table containing the row to be deleted */
1.491 + int iCur, /* Cursor number for the table */
1.492 + int *aRegIdx /* Only delete if aRegIdx!=0 && aRegIdx[i]>0 */
1.493 +){
1.494 + int i;
1.495 + Index *pIdx;
1.496 + int r1;
1.497 +
1.498 + for(i=1, pIdx=pTab->pIndex; pIdx; i++, pIdx=pIdx->pNext){
1.499 + if( aRegIdx!=0 && aRegIdx[i-1]==0 ) continue;
1.500 + r1 = sqlite3GenerateIndexKey(pParse, pIdx, iCur, 0, 0);
1.501 + sqlite3VdbeAddOp3(pParse->pVdbe, OP_IdxDelete, iCur+i, r1,pIdx->nColumn+1);
1.502 + }
1.503 +}
1.504 +
1.505 +/*
1.506 +** Generate code that will assemble an index key and put it in register
1.507 +** regOut. The key with be for index pIdx which is an index on pTab.
1.508 +** iCur is the index of a cursor open on the pTab table and pointing to
1.509 +** the entry that needs indexing.
1.510 +**
1.511 +** Return a register number which is the first in a block of
1.512 +** registers that holds the elements of the index key. The
1.513 +** block of registers has already been deallocated by the time
1.514 +** this routine returns.
1.515 +*/
1.516 +int sqlite3GenerateIndexKey(
1.517 + Parse *pParse, /* Parsing context */
1.518 + Index *pIdx, /* The index for which to generate a key */
1.519 + int iCur, /* Cursor number for the pIdx->pTable table */
1.520 + int regOut, /* Write the new index key to this register */
1.521 + int doMakeRec /* Run the OP_MakeRecord instruction if true */
1.522 +){
1.523 + Vdbe *v = pParse->pVdbe;
1.524 + int j;
1.525 + Table *pTab = pIdx->pTable;
1.526 + int regBase;
1.527 + int nCol;
1.528 +
1.529 + nCol = pIdx->nColumn;
1.530 + regBase = sqlite3GetTempRange(pParse, nCol+1);
1.531 + sqlite3VdbeAddOp2(v, OP_Rowid, iCur, regBase+nCol);
1.532 + for(j=0; j<nCol; j++){
1.533 + int idx = pIdx->aiColumn[j];
1.534 + if( idx==pTab->iPKey ){
1.535 + sqlite3VdbeAddOp2(v, OP_SCopy, regBase+nCol, regBase+j);
1.536 + }else{
1.537 + sqlite3VdbeAddOp3(v, OP_Column, iCur, idx, regBase+j);
1.538 + sqlite3ColumnDefault(v, pTab, idx);
1.539 + }
1.540 + }
1.541 + if( doMakeRec ){
1.542 + sqlite3VdbeAddOp3(v, OP_MakeRecord, regBase, nCol+1, regOut);
1.543 + sqlite3IndexAffinityStr(v, pIdx);
1.544 + sqlite3ExprCacheAffinityChange(pParse, regBase, nCol+1);
1.545 + }
1.546 + sqlite3ReleaseTempRange(pParse, regBase, nCol+1);
1.547 + return regBase;
1.548 +}
1.549 +
1.550 +/* Make sure "isView" gets undefined in case this file becomes part of
1.551 +** the amalgamation - so that subsequent files do not see isView as a
1.552 +** macro. */
1.553 +#undef isView