src/vdbeInt.h

   1 /*
   2 ** 2003 September 6
   3 **
   4 ** The author disclaims copyright to this source code.  In place of
   5 ** a legal notice, here is a blessing:
   6 **
   7 **    May you do good and not evil.
   8 **    May you find forgiveness for yourself and forgive others.
   9 **    May you share freely, never taking more than you give.
  10 **
  11 *************************************************************************
  12 ** This is the header file for information that is private to the
  13 ** VDBE.  This information used to all be at the top of the single
  14 ** source code file "vdbe.c".  When that file became too big (over
  15 ** 6000 lines long) it was split up into several smaller files and
  16 ** this header information was factored out.
  17 */
  18 #ifndef SQLITE_VDBEINT_H
  19 #define SQLITE_VDBEINT_H
  20
  21 /*
  22 ** The maximum number of times that a statement will try to reparse
  23 ** itself before giving up and returning SQLITE_SCHEMA.
  24 */
  25 #ifndef SQLITE_MAX_SCHEMA_RETRY
  26 # define SQLITE_MAX_SCHEMA_RETRY 50
  27 #endif
  28
  29 /*
  30 ** VDBE_DISPLAY_P4 is true or false depending on whether or not the
  31 ** "explain" P4 display logic is enabled.
  32 */
  33 #if !defined(SQLITE_OMIT_EXPLAIN) || !defined(NDEBUG) \
  34      || defined(VDBE_PROFILE) || defined(SQLITE_DEBUG) \
  35      || defined(SQLITE_ENABLE_BYTECODE_VTAB)
  36 # define VDBE_DISPLAY_P4 1
  37 #else
  38 # define VDBE_DISPLAY_P4 0
  39 #endif
  40
  41 /*
  42 ** SQL is translated into a sequence of instructions to be
  43 ** executed by a virtual machine.  Each instruction is an instance
  44 ** of the following structure.
  45 */
  46 typedef struct VdbeOp Op;
  47
  48 /*
  49 ** Boolean values
  50 */
  51 typedef unsigned Bool;
  52
  53 /* Opaque type used by code in vdbesort.c */
  54 typedef struct VdbeSorter VdbeSorter;
  55
  56 /* Elements of the linked list at Vdbe.pAuxData */
  57 typedef struct AuxData AuxData;
  58
  59 /* Types of VDBE cursors */
  60 #define CURTYPE_BTREE       0
  61 #define CURTYPE_SORTER      1
  62 #define CURTYPE_VTAB        2
  63 #define CURTYPE_PSEUDO      3
  64
  65 /*
  66 ** A VdbeCursor is an superclass (a wrapper) for various cursor objects:
  67 **
  68 **      * A b-tree cursor
  69 **          -  In the main database or in an ephemeral database
  70 **          -  On either an index or a table
  71 **      * A sorter
  72 **      * A virtual table
  73 **      * A one-row "pseudotable" stored in a single register
  74 */
  75 typedef struct VdbeCursor VdbeCursor;
  76 struct VdbeCursor {
  77   u8 eCurType;            /* One of the CURTYPE_* values above */
  78   i8 iDb;                 /* Index of cursor database in db->aDb[] (or -1) */
  79   u8 nullRow;             /* True if pointing to a row with no data */
  80   u8 deferredMoveto;      /* A call to sqlite3BtreeMoveto() is needed */
  81   u8 isTable;             /* True for rowid tables.  False for indexes */
  82 #ifdef SQLITE_DEBUG
  83   u8 seekOp;              /* Most recent seek operation on this cursor */
  84   u8 wrFlag;              /* The wrFlag argument to sqlite3BtreeCursor() */
  85 #endif
  86   Bool isEphemeral:1;     /* True for an ephemeral table */
  87   Bool useRandomRowid:1;  /* Generate new record numbers semi-randomly */
  88   Bool isOrdered:1;       /* True if the table is not BTREE_UNORDERED */
  89   Bool hasBeenDuped:1;    /* This cursor was source or target of OP_OpenDup */
  90   u16 seekHit;            /* See the OP_SeekHit and OP_IfNoHope opcodes */
  91   Btree *pBtx;            /* Separate file holding temporary table */
  92   i64 seqCount;           /* Sequence counter */
  93   u32 *aAltMap;           /* Mapping from table to index column numbers */
  94
  95   /* Cached OP_Column parse information is only valid if cacheStatus matches
  96   ** Vdbe.cacheCtr.  Vdbe.cacheCtr will never take on the value of
  97   ** CACHE_STALE (0) and so setting cacheStatus=CACHE_STALE guarantees that
  98   ** the cache is out of date. */
  99   u32 cacheStatus;        /* Cache is valid if this matches Vdbe.cacheCtr */
 100   int seekResult;         /* Result of previous sqlite3BtreeMoveto() or 0
 101                           ** if there have been no prior seeks on the cursor. */
 102   /* seekResult does not distinguish between "no seeks have ever occurred
 103   ** on this cursor" and "the most recent seek was an exact match".
 104   ** For CURTYPE_PSEUDO, seekResult is the register holding the record */
 105
 106   /* When a new VdbeCursor is allocated, only the fields above are zeroed.
 107   ** The fields that follow are uninitialized, and must be individually
 108   ** initialized prior to first use. */
 109   VdbeCursor *pAltCursor; /* Associated index cursor from which to read */
 110   union {
 111     BtCursor *pCursor;          /* CURTYPE_BTREE or _PSEUDO.  Btree cursor */
 112     sqlite3_vtab_cursor *pVCur; /* CURTYPE_VTAB.              Vtab cursor */
 113     VdbeSorter *pSorter;        /* CURTYPE_SORTER.            Sorter object */
 114   } uc;
 115   KeyInfo *pKeyInfo;      /* Info about index keys needed by index cursors */
 116   u32 iHdrOffset;         /* Offset to next unparsed byte of the header */
 117   Pgno pgnoRoot;          /* Root page of the open btree cursor */
 118   i16 nField;             /* Number of fields in the header */
 119   u16 nHdrParsed;         /* Number of header fields parsed so far */
 120   i64 movetoTarget;       /* Argument to the deferred sqlite3BtreeMoveto() */
 121   u32 *aOffset;           /* Pointer to aType[nField] */
 122   const u8 *aRow;         /* Data for the current row, if all on one page */
 123   u32 payloadSize;        /* Total number of bytes in the record */
 124   u32 szRow;              /* Byte available in aRow */
 125 #ifdef SQLITE_ENABLE_COLUMN_USED_MASK
 126   u64 maskUsed;           /* Mask of columns used by this cursor */
 127 #endif
 128
 129   /* 2*nField extra array elements allocated for aType[], beyond the one
 130   ** static element declared in the structure.  nField total array slots for
 131   ** aType[] and nField+1 array slots for aOffset[] */
 132   u32 aType[1];           /* Type values record decode.  MUST BE LAST */
 133 };
 134
 135
 136 /*
 137 ** A value for VdbeCursor.cacheStatus that means the cache is always invalid.
 138 */
 139 #define CACHE_STALE 0
 140
 141 /*
 142 ** When a sub-program is executed (OP_Program), a structure of this type
 143 ** is allocated to store the current value of the program counter, as
 144 ** well as the current memory cell array and various other frame specific
 145 ** values stored in the Vdbe struct. When the sub-program is finished,
 146 ** these values are copied back to the Vdbe from the VdbeFrame structure,
 147 ** restoring the state of the VM to as it was before the sub-program
 148 ** began executing.
 149 **
 150 ** The memory for a VdbeFrame object is allocated and managed by a memory
 151 ** cell in the parent (calling) frame. When the memory cell is deleted or
 152 ** overwritten, the VdbeFrame object is not freed immediately. Instead, it
 153 ** is linked into the Vdbe.pDelFrame list. The contents of the Vdbe.pDelFrame
 154 ** list is deleted when the VM is reset in VdbeHalt(). The reason for doing
 155 ** this instead of deleting the VdbeFrame immediately is to avoid recursive
 156 ** calls to sqlite3VdbeMemRelease() when the memory cells belonging to the
 157 ** child frame are released.
 158 **
 159 ** The currently executing frame is stored in Vdbe.pFrame. Vdbe.pFrame is
 160 ** set to NULL if the currently executing frame is the main program.
 161 */
 162 typedef struct VdbeFrame VdbeFrame;
 163 struct VdbeFrame {
 164   Vdbe *v;                /* VM this frame belongs to */
 165   VdbeFrame *pParent;     /* Parent of this frame, or NULL if parent is main */
 166   Op *aOp;                /* Program instructions for parent frame */
 167   i64 *anExec;            /* Event counters from parent frame */
 168   Mem *aMem;              /* Array of memory cells for parent frame */
 169   VdbeCursor **apCsr;     /* Array of Vdbe cursors for parent frame */
 170   u8 *aOnce;              /* Bitmask used by OP_Once */
 171   void *token;            /* Copy of SubProgram.token */
 172   i64 lastRowid;          /* Last insert rowid (sqlite3.lastRowid) */
 173   AuxData *pAuxData;      /* Linked list of auxdata allocations */
 174 #if SQLITE_DEBUG
 175   u32 iFrameMagic;        /* magic number for sanity checking */
 176 #endif
 177   int nCursor;            /* Number of entries in apCsr */
 178   int pc;                 /* Program Counter in parent (calling) frame */
 179   int nOp;                /* Size of aOp array */
 180   int nMem;               /* Number of entries in aMem */
 181   int nChildMem;          /* Number of memory cells for child frame */
 182   int nChildCsr;          /* Number of cursors for child frame */
 183   i64 nChange;            /* Statement changes (Vdbe.nChange)     */
 184   i64 nDbChange;          /* Value of db->nChange */
 185 };
 186
 187 /* Magic number for sanity checking on VdbeFrame objects */
 188 #define SQLITE_FRAME_MAGIC 0x879fb71e
 189
 190 /*
 191 ** Return a pointer to the array of registers allocated for use
 192 ** by a VdbeFrame.
 193 */
 194 #define VdbeFrameMem(p) ((Mem *)&((u8 *)p)[ROUND8(sizeof(VdbeFrame))])
 195
 196 /*
 197 ** Internally, the vdbe manipulates nearly all SQL values as Mem
 198 ** structures. Each Mem struct may cache multiple representations (string,
 199 ** integer etc.) of the same value.
 200 */
 201 struct sqlite3_value {
 202   union MemValue {
 203     double r;           /* Real value used when MEM_Real is set in flags */
 204     i64 i;              /* Integer value used when MEM_Int is set in flags */
 205     int nZero;          /* Extra zero bytes when MEM_Zero and MEM_Blob set */
 206     const char *zPType; /* Pointer type when MEM_Term|MEM_Subtype|MEM_Null */
 207     FuncDef *pDef;      /* Used only when flags==MEM_Agg */
 208   } u;
 209   u16 flags;          /* Some combination of MEM_Null, MEM_Str, MEM_Dyn, etc. */
 210   u8  enc;            /* SQLITE_UTF8, SQLITE_UTF16BE, SQLITE_UTF16LE */
 211   u8  eSubtype;       /* Subtype for this value */
 212   int n;              /* Number of characters in string value, excluding '\0' */
 213   char *z;            /* String or BLOB value */
 214   /* ShallowCopy only needs to copy the information above */
 215   char *zMalloc;      /* Space to hold MEM_Str or MEM_Blob if szMalloc>0 */
 216   int szMalloc;       /* Size of the zMalloc allocation */
 217   u32 uTemp;          /* Transient storage for serial_type in OP_MakeRecord */
 218   sqlite3 *db;        /* The associated database connection */
 219   void (*xDel)(void*);/* Destructor for Mem.z - only valid if MEM_Dyn */
 220 #ifdef SQLITE_DEBUG
 221   Mem *pScopyFrom;    /* This Mem is a shallow copy of pScopyFrom */
 222   u16 mScopyFlags;    /* flags value immediately after the shallow copy */
 223 #endif
 224 };
 225
 226 /*
 227 ** Size of struct Mem not including the Mem.zMalloc member or anything that
 228 ** follows.
 229 */
 230 #define MEMCELLSIZE offsetof(Mem,zMalloc)
 231
 232 /* One or more of the following flags are set to indicate the validOK
 233 ** representations of the value stored in the Mem struct.
 234 **
 235 ** If the MEM_Null flag is set, then the value is an SQL NULL value.
 236 ** For a pointer type created using sqlite3_bind_pointer() or
 237 ** sqlite3_result_pointer() the MEM_Term and MEM_Subtype flags are also set.
 238 **
 239 ** If the MEM_Str flag is set then Mem.z points at a string representation.
 240 ** Usually this is encoded in the same unicode encoding as the main
 241 ** database (see below for exceptions). If the MEM_Term flag is also
 242 ** set, then the string is nul terminated. The MEM_Int and MEM_Real
 243 ** flags may coexist with the MEM_Str flag.
 244 */
 245 #define MEM_Null      0x0001   /* Value is NULL (or a pointer) */
 246 #define MEM_Str       0x0002   /* Value is a string */
 247 #define MEM_Int       0x0004   /* Value is an integer */
 248 #define MEM_Real      0x0008   /* Value is a real number */
 249 #define MEM_Blob      0x0010   /* Value is a BLOB */
 250 #define MEM_IntReal   0x0020   /* MEM_Int that stringifies like MEM_Real */
 251 #define MEM_AffMask   0x003f   /* Mask of affinity bits */
 252 #define MEM_FromBind  0x0040   /* Value originates from sqlite3_bind() */
 253 #define MEM_Undefined 0x0080   /* Value is undefined */
 254 #define MEM_Cleared   0x0100   /* NULL set by OP_Null, not from data */
 255 #define MEM_TypeMask  0xc1bf   /* Mask of type bits */
 256
 257
 258 /* Whenever Mem contains a valid string or blob representation, one of
 259 ** the following flags must be set to determine the memory management
 260 ** policy for Mem.z.  The MEM_Term flag tells us whether or not the
 261 ** string is \000 or \u0000 terminated
 262 */
 263 #define MEM_Term      0x0200   /* String in Mem.z is zero terminated */
 264 #define MEM_Dyn       0x0400   /* Need to call Mem.xDel() on Mem.z */
 265 #define MEM_Static    0x0800   /* Mem.z points to a static string */
 266 #define MEM_Ephem     0x1000   /* Mem.z points to an ephemeral string */
 267 #define MEM_Agg       0x2000   /* Mem.z points to an agg function context */
 268 #define MEM_Zero      0x4000   /* Mem.i contains count of 0s appended to blob */
 269 #define MEM_Subtype   0x8000   /* Mem.eSubtype is valid */
 270 #ifdef SQLITE_OMIT_INCRBLOB
 271   #undef MEM_Zero
 272   #define MEM_Zero 0x0000
 273 #endif
 274
 275 /* Return TRUE if Mem X contains dynamically allocated content - anything
 276 ** that needs to be deallocated to avoid a leak.
 277 */
 278 #define VdbeMemDynamic(X)  \
 279   (((X)->flags&(MEM_Agg|MEM_Dyn))!=0)
 280
 281 /*
 282 ** Clear any existing type flags from a Mem and replace them with f
 283 */
 284 #define MemSetTypeFlag(p, f) \
 285    ((p)->flags = ((p)->flags&~(MEM_TypeMask|MEM_Zero))|f)
 286
 287 /*
 288 ** True if Mem X is a NULL-nochng type.
 289 */
 290 #define MemNullNochng(X) \
 291   (((X)->flags&MEM_TypeMask)==(MEM_Null|MEM_Zero) \
 292     && (X)->n==0 && (X)->u.nZero==0)
 293
 294 /*
 295 ** Return true if a memory cell is not marked as invalid.  This macro
 296 ** is for use inside assert() statements only.
 297 */
 298 #ifdef SQLITE_DEBUG
 299 #define memIsValid(M)  ((M)->flags & MEM_Undefined)==0
 300 #endif
 301
 302 /*
 303 ** Each auxiliary data pointer stored by a user defined function
 304 ** implementation calling sqlite3_set_auxdata() is stored in an instance
 305 ** of this structure. All such structures associated with a single VM
 306 ** are stored in a linked list headed at Vdbe.pAuxData. All are destroyed
 307 ** when the VM is halted (if not before).
 308 */
 309 struct AuxData {
 310   int iAuxOp;                     /* Instruction number of OP_Function opcode */
 311   int iAuxArg;                    /* Index of function argument. */
 312   void *pAux;                     /* Aux data pointer */
 313   void (*xDeleteAux)(void*);      /* Destructor for the aux data */
 314   AuxData *pNextAux;              /* Next element in list */
 315 };
 316
 317 /*
 318 ** The "context" argument for an installable function.  A pointer to an
 319 ** instance of this structure is the first argument to the routines used
 320 ** implement the SQL functions.
 321 **
 322 ** There is a typedef for this structure in sqlite.h.  So all routines,
 323 ** even the public interface to SQLite, can use a pointer to this structure.
 324 ** But this file is the only place where the internal details of this
 325 ** structure are known.
 326 **
 327 ** This structure is defined inside of vdbeInt.h because it uses substructures
 328 ** (Mem) which are only defined there.
 329 */
 330 struct sqlite3_context {
 331   Mem *pOut;              /* The return value is stored here */
 332   FuncDef *pFunc;         /* Pointer to function information */
 333   Mem *pMem;              /* Memory cell used to store aggregate context */
 334   Vdbe *pVdbe;            /* The VM that owns this context */
 335   int iOp;                /* Instruction number of OP_Function */
 336   int isError;            /* Error code returned by the function. */
 337   u8 skipFlag;            /* Skip accumulator loading if true */
 338   u8 argc;                /* Number of arguments */
 339   sqlite3_value *argv[1]; /* Argument set */
 340 };
 341
 342 /* A bitfield type for use inside of structures.  Always follow with :N where
 343 ** N is the number of bits.
 344 */
 345 typedef unsigned bft;  /* Bit Field Type */
 346
 347 /* The ScanStatus object holds a single value for the
 348 ** sqlite3_stmt_scanstatus() interface.
 349 */
 350 typedef struct ScanStatus ScanStatus;
 351 struct ScanStatus {
 352   int addrExplain;                /* OP_Explain for loop */
 353   int addrLoop;                   /* Address of "loops" counter */
 354   int addrVisit;                  /* Address of "rows visited" counter */
 355   int iSelectID;                  /* The "Select-ID" for this loop */
 356   LogEst nEst;                    /* Estimated output rows per loop */
 357   char *zName;                    /* Name of table or index */
 358 };
 359
 360 /* The DblquoteStr object holds the text of a double-quoted
 361 ** string for a prepared statement.  A linked list of these objects
 362 ** is constructed during statement parsing and is held on Vdbe.pDblStr.
 363 ** When computing a normalized SQL statement for an SQL statement, that
 364 ** list is consulted for each double-quoted identifier to see if the
 365 ** identifier should really be a string literal.
 366 */
 367 typedef struct DblquoteStr DblquoteStr;
 368 struct DblquoteStr {
 369   DblquoteStr *pNextStr;   /* Next string literal in the list */
 370   char z[8];               /* Dequoted value for the string */
 371 };
 372
 373 /*
 374 ** An instance of the virtual machine.  This structure contains the complete
 375 ** state of the virtual machine.
 376 **
 377 ** The "sqlite3_stmt" structure pointer that is returned by sqlite3_prepare()
 378 ** is really a pointer to an instance of this structure.
 379 */
 380 struct Vdbe {
 381   sqlite3 *db;            /* The database connection that owns this statement */
 382   Vdbe *pPrev,*pNext;     /* Linked list of VDBEs with the same Vdbe.db */
 383   Parse *pParse;          /* Parsing context used to create this Vdbe */
 384   ynVar nVar;             /* Number of entries in aVar[] */
 385   u32 iVdbeMagic;         /* Magic number defining state of the SQL statement */
 386   int nMem;               /* Number of memory locations currently allocated */
 387   int nCursor;            /* Number of slots in apCsr[] */
 388   u32 cacheCtr;           /* VdbeCursor row cache generation counter */
 389   int pc;                 /* The program counter */
 390   int rc;                 /* Value to return */
 391   i64 nChange;            /* Number of db changes made since last reset */
 392   int iStatement;         /* Statement number (or 0 if has no opened stmt) */
 393   i64 iCurrentTime;       /* Value of julianday('now') for this statement */
 394   i64 nFkConstraint;      /* Number of imm. FK constraints this VM */
 395   i64 nStmtDefCons;       /* Number of def. constraints when stmt started */
 396   i64 nStmtDefImmCons;    /* Number of def. imm constraints when stmt started */
 397   Mem *aMem;              /* The memory locations */
 398   Mem **apArg;            /* Arguments to currently executing user function */
 399   VdbeCursor **apCsr;     /* One element of this array for each open cursor */
 400   Mem *aVar;              /* Values for the OP_Variable opcode. */
 401
 402   /* When allocating a new Vdbe object, all of the fields below should be
 403   ** initialized to zero or NULL */
 404
 405   Op *aOp;                /* Space to hold the virtual machine's program */
 406   int nOp;                /* Number of instructions in the program */
 407   int nOpAlloc;           /* Slots allocated for aOp[] */
 408   Mem *aColName;          /* Column names to return */
 409   Mem *pResultSet;        /* Pointer to an array of results */
 410   char *zErrMsg;          /* Error message written here */
 411   VList *pVList;          /* Name of variables */
 412 #ifndef SQLITE_OMIT_TRACE
 413   i64 startTime;          /* Time when query started - used for profiling */
 414 #endif
 415 #ifdef SQLITE_DEBUG
 416   int rcApp;              /* errcode set by sqlite3_result_error_code() */
 417   u32 nWrite;             /* Number of write operations that have occurred */
 418 #endif
 419   u16 nResColumn;         /* Number of columns in one row of the result set */
 420   u8 errorAction;         /* Recovery action to do in case of an error */
 421   u8 minWriteFileFormat;  /* Minimum file format for writable database files */
 422   u8 prepFlags;           /* SQLITE_PREPARE_* flags */
 423   u8 doingRerun;          /* True if rerunning after an auto-reprepare */
 424   bft expired:2;          /* 1: recompile VM immediately  2: when convenient */
 425   bft explain:2;          /* True if EXPLAIN present on SQL command */
 426   bft changeCntOn:1;      /* True to update the change-counter */
 427   bft runOnlyOnce:1;      /* Automatically expire on reset */
 428   bft usesStmtJournal:1;  /* True if uses a statement journal */
 429   bft readOnly:1;         /* True for statements that do not write */
 430   bft bIsReader:1;        /* True for statements that read */
 431   yDbMask btreeMask;      /* Bitmask of db->aDb[] entries referenced */
 432   yDbMask lockMask;       /* Subset of btreeMask that requires a lock */
 433   u32 aCounter[7];        /* Counters used by sqlite3_stmt_status() */
 434   char *zSql;             /* Text of the SQL statement that generated this */
 435 #ifdef SQLITE_ENABLE_NORMALIZE
 436   char *zNormSql;         /* Normalization of the associated SQL statement */
 437   DblquoteStr *pDblStr;   /* List of double-quoted string literals */
 438 #endif
 439   void *pFree;            /* Free this when deleting the vdbe */
 440   VdbeFrame *pFrame;      /* Parent frame */
 441   VdbeFrame *pDelFrame;   /* List of frame objects to free on VM reset */
 442   int nFrame;             /* Number of frames in pFrame list */
 443   u32 expmask;            /* Binding to these vars invalidates VM */
 444   SubProgram *pProgram;   /* Linked list of all sub-programs used by VM */
 445   AuxData *pAuxData;      /* Linked list of auxdata allocations */
 446 #ifdef SQLITE_ENABLE_STMT_SCANSTATUS
 447   i64 *anExec;            /* Number of times each op has been executed */
 448   int nScan;              /* Entries in aScan[] */
 449   ScanStatus *aScan;      /* Scan definitions for sqlite3_stmt_scanstatus() */
 450 #endif
 451 };
 452
 453 /*
 454 ** The following are allowed values for Vdbe.magic
 455 */
 456 #define VDBE_MAGIC_INIT     0x16bceaa5    /* Building a VDBE program */
 457 #define VDBE_MAGIC_RUN      0x2df20da3    /* VDBE is ready to execute */
 458 #define VDBE_MAGIC_HALT     0x319c2973    /* VDBE has completed execution */
 459 #define VDBE_MAGIC_RESET    0x48fa9f76    /* Reset and ready to run again */
 460 #define VDBE_MAGIC_DEAD     0x5606c3c8    /* The VDBE has been deallocated */
 461
 462 /*
 463 ** Structure used to store the context required by the
 464 ** sqlite3_preupdate_*() API functions.
 465 */
 466 struct PreUpdate {
 467   Vdbe *v;
 468   VdbeCursor *pCsr;               /* Cursor to read old values from */
 469   int op;                         /* One of SQLITE_INSERT, UPDATE, DELETE */
 470   u8 *aRecord;                    /* old.* database record */
 471   KeyInfo keyinfo;
 472   UnpackedRecord *pUnpacked;      /* Unpacked version of aRecord[] */
 473   UnpackedRecord *pNewUnpacked;   /* Unpacked version of new.* record */
 474   int iNewReg;                    /* Register for new.* values */
 475   int iBlobWrite;                 /* Value returned by preupdate_blobwrite() */
 476   i64 iKey1;                      /* First key value passed to hook */
 477   i64 iKey2;                      /* Second key value passed to hook */
 478   Mem *aNew;                      /* Array of new.* values */
 479   Table *pTab;                    /* Schema object being upated */
 480   Index *pPk;                     /* PK index if pTab is WITHOUT ROWID */
 481 };
 482
 483 /*
 484 ** Function prototypes
 485 */
 486 void sqlite3VdbeError(Vdbe*, const char *, ...);
 487 void sqlite3VdbeFreeCursor(Vdbe *, VdbeCursor*);
 488 void sqliteVdbePopStack(Vdbe*,int);
 489 int SQLITE_NOINLINE sqlite3VdbeFinishMoveto(VdbeCursor*);
 490 int sqlite3VdbeCursorMoveto(VdbeCursor**, u32*);
 491 int sqlite3VdbeCursorRestore(VdbeCursor*);
 492 u32 sqlite3VdbeSerialTypeLen(u32);
 493 u8 sqlite3VdbeOneByteSerialTypeLen(u8);
 494 u32 sqlite3VdbeSerialPut(unsigned char*, Mem*, u32);
 495 u32 sqlite3VdbeSerialGet(const unsigned char*, u32, Mem*);
 496 void sqlite3VdbeDeleteAuxData(sqlite3*, AuxData**, int, int);
 497
 498 int sqlite2BtreeKeyCompare(BtCursor *, const void *, int, int, int *);
 499 int sqlite3VdbeIdxKeyCompare(sqlite3*,VdbeCursor*,UnpackedRecord*,int*);
 500 int sqlite3VdbeIdxRowid(sqlite3*, BtCursor*, i64*);
 501 int sqlite3VdbeExec(Vdbe*);
 502 #if !defined(SQLITE_OMIT_EXPLAIN) || defined(SQLITE_ENABLE_BYTECODE_VTAB)
 503 int sqlite3VdbeNextOpcode(Vdbe*,Mem*,int,int*,int*,Op**);
 504 char *sqlite3VdbeDisplayP4(sqlite3*,Op*);
 505 #endif
 506 #if defined(SQLITE_ENABLE_EXPLAIN_COMMENTS)
 507 char *sqlite3VdbeDisplayComment(sqlite3*,const Op*,const char*);
 508 #endif
 509 #if !defined(SQLITE_OMIT_EXPLAIN)
 510 int sqlite3VdbeList(Vdbe*);
 511 #endif
 512 int sqlite3VdbeHalt(Vdbe*);
 513 int sqlite3VdbeChangeEncoding(Mem *, int);
 514 int sqlite3VdbeMemTooBig(Mem*);
 515 int sqlite3VdbeMemCopy(Mem*, const Mem*);
 516 void sqlite3VdbeMemShallowCopy(Mem*, const Mem*, int);
 517 void sqlite3VdbeMemMove(Mem*, Mem*);
 518 int sqlite3VdbeMemNulTerminate(Mem*);
 519 int sqlite3VdbeMemSetStr(Mem*, const char*, i64, u8, void(*)(void*));
 520 void sqlite3VdbeMemSetInt64(Mem*, i64);
 521 #ifdef SQLITE_OMIT_FLOATING_POINT
 522 # define sqlite3VdbeMemSetDouble sqlite3VdbeMemSetInt64
 523 #else
 524   void sqlite3VdbeMemSetDouble(Mem*, double);
 525 #endif
 526 void sqlite3VdbeMemSetPointer(Mem*, void*, const char*, void(*)(void*));
 527 void sqlite3VdbeMemInit(Mem*,sqlite3*,u16);
 528 void sqlite3VdbeMemSetNull(Mem*);
 529 #ifndef SQLITE_OMIT_INCRBLOB
 530 void sqlite3VdbeMemSetZeroBlob(Mem*,int);
 531 #else
 532 int sqlite3VdbeMemSetZeroBlob(Mem*,int);
 533 #endif
 534 #ifdef SQLITE_DEBUG
 535 int sqlite3VdbeMemIsRowSet(const Mem*);
 536 #endif
 537 int sqlite3VdbeMemSetRowSet(Mem*);
 538 int sqlite3VdbeMemMakeWriteable(Mem*);
 539 int sqlite3VdbeMemStringify(Mem*, u8, u8);
 540 int sqlite3IntFloatCompare(i64,double);
 541 i64 sqlite3VdbeIntValue(Mem*);
 542 int sqlite3VdbeMemIntegerify(Mem*);
 543 double sqlite3VdbeRealValue(Mem*);
 544 int sqlite3VdbeBooleanValue(Mem*, int ifNull);
 545 void sqlite3VdbeIntegerAffinity(Mem*);
 546 int sqlite3VdbeMemRealify(Mem*);
 547 int sqlite3VdbeMemNumerify(Mem*);
 548 int sqlite3VdbeMemCast(Mem*,u8,u8);
 549 int sqlite3VdbeMemFromBtree(BtCursor*,u32,u32,Mem*);
 550 int sqlite3VdbeMemFromBtreeZeroOffset(BtCursor*,u32,Mem*);
 551 void sqlite3VdbeMemRelease(Mem *p);
 552 int sqlite3VdbeMemFinalize(Mem*, FuncDef*);
 553 #ifndef SQLITE_OMIT_WINDOWFUNC
 554 int sqlite3VdbeMemAggValue(Mem*, Mem*, FuncDef*);
 555 #endif
 556 #if !defined(SQLITE_OMIT_EXPLAIN) || defined(SQLITE_ENABLE_BYTECODE_VTAB)
 557 const char *sqlite3OpcodeName(int);
 558 #endif
 559 int sqlite3VdbeMemGrow(Mem *pMem, int n, int preserve);
 560 int sqlite3VdbeMemClearAndResize(Mem *pMem, int n);
 561 int sqlite3VdbeCloseStatement(Vdbe *, int);
 562 #ifdef SQLITE_DEBUG
 563 int sqlite3VdbeFrameIsValid(VdbeFrame*);
 564 #endif
 565 void sqlite3VdbeFrameMemDel(void*);      /* Destructor on Mem */
 566 void sqlite3VdbeFrameDelete(VdbeFrame*); /* Actually deletes the Frame */
 567 int sqlite3VdbeFrameRestore(VdbeFrame *);
 568 #ifdef SQLITE_ENABLE_PREUPDATE_HOOK
 569 void sqlite3VdbePreUpdateHook(
 570     Vdbe*,VdbeCursor*,int,const char*,Table*,i64,int,int);
 571 #endif
 572 int sqlite3VdbeTransferError(Vdbe *p);
 573
 574 int sqlite3VdbeSorterInit(sqlite3 *, int, VdbeCursor *);
 575 void sqlite3VdbeSorterReset(sqlite3 *, VdbeSorter *);
 576 void sqlite3VdbeSorterClose(sqlite3 *, VdbeCursor *);
 577 int sqlite3VdbeSorterRowkey(const VdbeCursor *, Mem *);
 578 int sqlite3VdbeSorterNext(sqlite3 *, const VdbeCursor *);
 579 int sqlite3VdbeSorterRewind(const VdbeCursor *, int *);
 580 int sqlite3VdbeSorterWrite(const VdbeCursor *, Mem *);
 581 int sqlite3VdbeSorterCompare(const VdbeCursor *, Mem *, int, int *);
 582
 583 #ifdef SQLITE_DEBUG
 584   void sqlite3VdbeIncrWriteCounter(Vdbe*, VdbeCursor*);
 585   void sqlite3VdbeAssertAbortable(Vdbe*);
 586 #else
 587 # define sqlite3VdbeIncrWriteCounter(V,C)
 588 # define sqlite3VdbeAssertAbortable(V)
 589 #endif
 590
 591 #if !defined(SQLITE_OMIT_SHARED_CACHE)
 592   void sqlite3VdbeEnter(Vdbe*);
 593 #else
 594 # define sqlite3VdbeEnter(X)
 595 #endif
 596
 597 #if !defined(SQLITE_OMIT_SHARED_CACHE) && SQLITE_THREADSAFE>0
 598   void sqlite3VdbeLeave(Vdbe*);
 599 #else
 600 # define sqlite3VdbeLeave(X)
 601 #endif
 602
 603 #ifdef SQLITE_DEBUG
 604 void sqlite3VdbeMemAboutToChange(Vdbe*,Mem*);
 605 int sqlite3VdbeCheckMemInvariants(Mem*);
 606 #endif
 607
 608 #ifndef SQLITE_OMIT_FOREIGN_KEY
 609 int sqlite3VdbeCheckFk(Vdbe *, int);
 610 #else
 611 # define sqlite3VdbeCheckFk(p,i) 0
 612 #endif
 613
 614 #ifdef SQLITE_DEBUG
 615   void sqlite3VdbePrintSql(Vdbe*);
 616   void sqlite3VdbeMemPrettyPrint(Mem *pMem, StrAccum *pStr);
 617 #endif
 618 #ifndef SQLITE_OMIT_UTF16
 619   int sqlite3VdbeMemTranslate(Mem*, u8);
 620   int sqlite3VdbeMemHandleBom(Mem *pMem);
 621 #endif
 622
 623 #ifndef SQLITE_OMIT_INCRBLOB
 624   int sqlite3VdbeMemExpandBlob(Mem *);
 625   #define ExpandBlob(P) (((P)->flags&MEM_Zero)?sqlite3VdbeMemExpandBlob(P):0)
 626 #else
 627   #define sqlite3VdbeMemExpandBlob(x) SQLITE_OK
 628   #define ExpandBlob(P) SQLITE_OK
 629 #endif
 630
 631 #endif /* !defined(SQLITE_VDBEINT_H) */