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