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