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 ** * MEM_Undefined An undefined and/or uninitialized value. 270 ** Trying to use an Undefined value is an error. 271 ** 272 ** If the MEM_Null flag is set, then the value is an SQL NULL value. 273 ** For a pointer type created using sqlite3_bind_pointer() or 274 ** sqlite3_result_pointer() the MEM_Term and MEM_Subtype flags are also set. 275 ** 276 ** If the MEM_Str flag is set then Mem.z points at a string representation. 277 ** Usually this is encoded in the same unicode encoding as the main 278 ** database (see below for exceptions). If the MEM_Term flag is also 279 ** set, then the string is nul terminated. The MEM_Int and MEM_Real 280 ** flags may coexist with the MEM_Str flag. 281 */ 282 #define MEM_Null 0x0001 /* Value is NULL (or a pointer) */ 283 #define MEM_Str 0x0002 /* Value is a string */ 284 #define MEM_Int 0x0004 /* Value is an integer */ 285 #define MEM_Real 0x0008 /* Value is a real number */ 286 #define MEM_Blob 0x0010 /* Value is a BLOB */ 287 #define MEM_IntReal 0x0020 /* MEM_Int that stringifies like MEM_Real */ 288 #define MEM_AffMask 0x003f /* Mask of affinity bits */ 289 #define MEM_FromBind 0x0040 /* Value originates from sqlite3_bind() */ 290 #define MEM_Undefined 0x0080 /* Value is undefined */ 291 #define MEM_Cleared 0x0100 /* NULL set by OP_Null, not from data */ 292 #define MEM_TypeMask 0xc1bf /* Mask of type bits */ 293 294 295 /* Whenever Mem contains a valid string or blob representation, one of 296 ** the following flags must be set to determine the memory management 297 ** policy for Mem.z. The MEM_Term flag tells us whether or not the 298 ** string is \000 or \u0000 terminated 299 */ 300 #define MEM_Term 0x0200 /* String in Mem.z is zero terminated */ 301 #define MEM_Dyn 0x0400 /* Need to call Mem.xDel() on Mem.z */ 302 #define MEM_Static 0x0800 /* Mem.z points to a static string */ 303 #define MEM_Ephem 0x1000 /* Mem.z points to an ephemeral string */ 304 #define MEM_Agg 0x2000 /* Mem.z points to an agg function context */ 305 #define MEM_Zero 0x4000 /* Mem.i contains count of 0s appended to blob */ 306 #define MEM_Subtype 0x8000 /* Mem.eSubtype is valid */ 307 #ifdef SQLITE_OMIT_INCRBLOB 308 #undef MEM_Zero 309 #define MEM_Zero 0x0000 310 #endif 311 312 /* Return TRUE if Mem X contains dynamically allocated content - anything 313 ** that needs to be deallocated to avoid a leak. 314 */ 315 #define VdbeMemDynamic(X) \ 316 (((X)->flags&(MEM_Agg|MEM_Dyn))!=0) 317 318 /* 319 ** Clear any existing type flags from a Mem and replace them with f 320 */ 321 #define MemSetTypeFlag(p, f) \ 322 ((p)->flags = ((p)->flags&~(MEM_TypeMask|MEM_Zero))|f) 323 324 /* 325 ** True if Mem X is a NULL-nochng type. 326 */ 327 #define MemNullNochng(X) \ 328 (((X)->flags&MEM_TypeMask)==(MEM_Null|MEM_Zero) \ 329 && (X)->n==0 && (X)->u.nZero==0) 330 331 /* 332 ** Return true if a memory cell is not marked as invalid. This macro 333 ** is for use inside assert() statements only. 334 */ 335 #ifdef SQLITE_DEBUG 336 #define memIsValid(M) ((M)->flags & MEM_Undefined)==0 337 #endif 338 339 /* 340 ** Each auxiliary data pointer stored by a user defined function 341 ** implementation calling sqlite3_set_auxdata() is stored in an instance 342 ** of this structure. All such structures associated with a single VM 343 ** are stored in a linked list headed at Vdbe.pAuxData. All are destroyed 344 ** when the VM is halted (if not before). 345 */ 346 struct AuxData { 347 int iAuxOp; /* Instruction number of OP_Function opcode */ 348 int iAuxArg; /* Index of function argument. */ 349 void *pAux; /* Aux data pointer */ 350 void (*xDeleteAux)(void*); /* Destructor for the aux data */ 351 AuxData *pNextAux; /* Next element in list */ 352 }; 353 354 /* 355 ** The "context" argument for an installable function. A pointer to an 356 ** instance of this structure is the first argument to the routines used 357 ** implement the SQL functions. 358 ** 359 ** There is a typedef for this structure in sqlite.h. So all routines, 360 ** even the public interface to SQLite, can use a pointer to this structure. 361 ** But this file is the only place where the internal details of this 362 ** structure are known. 363 ** 364 ** This structure is defined inside of vdbeInt.h because it uses substructures 365 ** (Mem) which are only defined there. 366 */ 367 struct sqlite3_context { 368 Mem *pOut; /* The return value is stored here */ 369 FuncDef *pFunc; /* Pointer to function information */ 370 Mem *pMem; /* Memory cell used to store aggregate context */ 371 Vdbe *pVdbe; /* The VM that owns this context */ 372 int iOp; /* Instruction number of OP_Function */ 373 int isError; /* Error code returned by the function. */ 374 u8 skipFlag; /* Skip accumulator loading if true */ 375 u8 argc; /* Number of arguments */ 376 sqlite3_value *argv[1]; /* Argument set */ 377 }; 378 379 /* A bitfield type for use inside of structures. Always follow with :N where 380 ** N is the number of bits. 381 */ 382 typedef unsigned bft; /* Bit Field Type */ 383 384 /* The ScanStatus object holds a single value for the 385 ** sqlite3_stmt_scanstatus() interface. 386 */ 387 typedef struct ScanStatus ScanStatus; 388 struct ScanStatus { 389 int addrExplain; /* OP_Explain for loop */ 390 int addrLoop; /* Address of "loops" counter */ 391 int addrVisit; /* Address of "rows visited" counter */ 392 int iSelectID; /* The "Select-ID" for this loop */ 393 LogEst nEst; /* Estimated output rows per loop */ 394 char *zName; /* Name of table or index */ 395 }; 396 397 /* The DblquoteStr object holds the text of a double-quoted 398 ** string for a prepared statement. A linked list of these objects 399 ** is constructed during statement parsing and is held on Vdbe.pDblStr. 400 ** When computing a normalized SQL statement for an SQL statement, that 401 ** list is consulted for each double-quoted identifier to see if the 402 ** identifier should really be a string literal. 403 */ 404 typedef struct DblquoteStr DblquoteStr; 405 struct DblquoteStr { 406 DblquoteStr *pNextStr; /* Next string literal in the list */ 407 char z[8]; /* Dequoted value for the string */ 408 }; 409 410 /* 411 ** An instance of the virtual machine. This structure contains the complete 412 ** state of the virtual machine. 413 ** 414 ** The "sqlite3_stmt" structure pointer that is returned by sqlite3_prepare() 415 ** is really a pointer to an instance of this structure. 416 */ 417 struct Vdbe { 418 sqlite3 *db; /* The database connection that owns this statement */ 419 Vdbe *pPrev,*pNext; /* Linked list of VDBEs with the same Vdbe.db */ 420 Parse *pParse; /* Parsing context used to create this Vdbe */ 421 ynVar nVar; /* Number of entries in aVar[] */ 422 u32 iVdbeMagic; /* Magic number defining state of the SQL statement */ 423 int nMem; /* Number of memory locations currently allocated */ 424 int nCursor; /* Number of slots in apCsr[] */ 425 u32 cacheCtr; /* VdbeCursor row cache generation counter */ 426 int pc; /* The program counter */ 427 int rc; /* Value to return */ 428 i64 nChange; /* Number of db changes made since last reset */ 429 int iStatement; /* Statement number (or 0 if has no opened stmt) */ 430 i64 iCurrentTime; /* Value of julianday('now') for this statement */ 431 i64 nFkConstraint; /* Number of imm. FK constraints this VM */ 432 i64 nStmtDefCons; /* Number of def. constraints when stmt started */ 433 i64 nStmtDefImmCons; /* Number of def. imm constraints when stmt started */ 434 Mem *aMem; /* The memory locations */ 435 Mem **apArg; /* Arguments to currently executing user function */ 436 VdbeCursor **apCsr; /* One element of this array for each open cursor */ 437 Mem *aVar; /* Values for the OP_Variable opcode. */ 438 439 /* When allocating a new Vdbe object, all of the fields below should be 440 ** initialized to zero or NULL */ 441 442 Op *aOp; /* Space to hold the virtual machine's program */ 443 int nOp; /* Number of instructions in the program */ 444 int nOpAlloc; /* Slots allocated for aOp[] */ 445 Mem *aColName; /* Column names to return */ 446 Mem *pResultSet; /* Pointer to an array of results */ 447 char *zErrMsg; /* Error message written here */ 448 VList *pVList; /* Name of variables */ 449 #ifndef SQLITE_OMIT_TRACE 450 i64 startTime; /* Time when query started - used for profiling */ 451 #endif 452 #ifdef SQLITE_DEBUG 453 int rcApp; /* errcode set by sqlite3_result_error_code() */ 454 u32 nWrite; /* Number of write operations that have occurred */ 455 #endif 456 u16 nResColumn; /* Number of columns in one row of the result set */ 457 u8 errorAction; /* Recovery action to do in case of an error */ 458 u8 minWriteFileFormat; /* Minimum file format for writable database files */ 459 u8 prepFlags; /* SQLITE_PREPARE_* flags */ 460 u8 doingRerun; /* True if rerunning after an auto-reprepare */ 461 bft expired:2; /* 1: recompile VM immediately 2: when convenient */ 462 bft explain:2; /* True if EXPLAIN present on SQL command */ 463 bft changeCntOn:1; /* True to update the change-counter */ 464 bft runOnlyOnce:1; /* Automatically expire on reset */ 465 bft usesStmtJournal:1; /* True if uses a statement journal */ 466 bft readOnly:1; /* True for statements that do not write */ 467 bft bIsReader:1; /* True for statements that read */ 468 yDbMask btreeMask; /* Bitmask of db->aDb[] entries referenced */ 469 yDbMask lockMask; /* Subset of btreeMask that requires a lock */ 470 u32 aCounter[9]; /* Counters used by sqlite3_stmt_status() */ 471 char *zSql; /* Text of the SQL statement that generated this */ 472 #ifdef SQLITE_ENABLE_NORMALIZE 473 char *zNormSql; /* Normalization of the associated SQL statement */ 474 DblquoteStr *pDblStr; /* List of double-quoted string literals */ 475 #endif 476 void *pFree; /* Free this when deleting the vdbe */ 477 VdbeFrame *pFrame; /* Parent frame */ 478 VdbeFrame *pDelFrame; /* List of frame objects to free on VM reset */ 479 int nFrame; /* Number of frames in pFrame list */ 480 u32 expmask; /* Binding to these vars invalidates VM */ 481 SubProgram *pProgram; /* Linked list of all sub-programs used by VM */ 482 AuxData *pAuxData; /* Linked list of auxdata allocations */ 483 #ifdef SQLITE_ENABLE_STMT_SCANSTATUS 484 i64 *anExec; /* Number of times each op has been executed */ 485 int nScan; /* Entries in aScan[] */ 486 ScanStatus *aScan; /* Scan definitions for sqlite3_stmt_scanstatus() */ 487 #endif 488 }; 489 490 /* 491 ** The following are allowed values for Vdbe.magic 492 */ 493 #define VDBE_MAGIC_INIT 0x16bceaa5 /* Building a VDBE program */ 494 #define VDBE_MAGIC_RUN 0x2df20da3 /* VDBE is ready to execute */ 495 #define VDBE_MAGIC_HALT 0x319c2973 /* VDBE has completed execution */ 496 #define VDBE_MAGIC_RESET 0x48fa9f76 /* Reset and ready to run again */ 497 #define VDBE_MAGIC_DEAD 0x5606c3c8 /* The VDBE has been deallocated */ 498 499 /* 500 ** Structure used to store the context required by the 501 ** sqlite3_preupdate_*() API functions. 502 */ 503 struct PreUpdate { 504 Vdbe *v; 505 VdbeCursor *pCsr; /* Cursor to read old values from */ 506 int op; /* One of SQLITE_INSERT, UPDATE, DELETE */ 507 u8 *aRecord; /* old.* database record */ 508 KeyInfo keyinfo; 509 UnpackedRecord *pUnpacked; /* Unpacked version of aRecord[] */ 510 UnpackedRecord *pNewUnpacked; /* Unpacked version of new.* record */ 511 int iNewReg; /* Register for new.* values */ 512 int iBlobWrite; /* Value returned by preupdate_blobwrite() */ 513 i64 iKey1; /* First key value passed to hook */ 514 i64 iKey2; /* Second key value passed to hook */ 515 Mem *aNew; /* Array of new.* values */ 516 Table *pTab; /* Schema object being upated */ 517 Index *pPk; /* PK index if pTab is WITHOUT ROWID */ 518 }; 519 520 /* 521 ** An instance of this object is used to pass an vector of values into 522 ** OP_VFilter, the xFilter method of a virtual table. The vector is the 523 ** set of values on the right-hand side of an IN constraint. 524 ** 525 ** The value as passed into xFilter is an sqlite3_value with a "pointer" 526 ** type, such as is generated by sqlite3_result_pointer() and read by 527 ** sqlite3_value_pointer. Such values have MEM_Term|MEM_Subtype|MEM_Null 528 ** and a subtype of 'p'. The sqlite3_vtab_in_first() and _next() interfaces 529 ** know how to use this object to step through all the values in the 530 ** right operand of the IN constraint. 531 */ 532 typedef struct ValueList ValueList; 533 struct ValueList { 534 BtCursor *pCsr; /* An ephemeral table holding all values */ 535 sqlite3_value *pOut; /* Register to hold each decoded output value */ 536 }; 537 538 /* 539 ** Function prototypes 540 */ 541 void sqlite3VdbeError(Vdbe*, const char *, ...); 542 void sqlite3VdbeFreeCursor(Vdbe *, VdbeCursor*); 543 void sqliteVdbePopStack(Vdbe*,int); 544 int SQLITE_NOINLINE sqlite3VdbeHandleMovedCursor(VdbeCursor *p); 545 int SQLITE_NOINLINE sqlite3VdbeFinishMoveto(VdbeCursor*); 546 int sqlite3VdbeCursorRestore(VdbeCursor*); 547 u32 sqlite3VdbeSerialTypeLen(u32); 548 u8 sqlite3VdbeOneByteSerialTypeLen(u8); 549 u32 sqlite3VdbeSerialPut(unsigned char*, Mem*, u32); 550 void sqlite3VdbeSerialGet(const unsigned char*, u32, Mem*); 551 void sqlite3VdbeDeleteAuxData(sqlite3*, AuxData**, int, int); 552 553 int sqlite2BtreeKeyCompare(BtCursor *, const void *, int, int, int *); 554 int sqlite3VdbeIdxKeyCompare(sqlite3*,VdbeCursor*,UnpackedRecord*,int*); 555 int sqlite3VdbeIdxRowid(sqlite3*, BtCursor*, i64*); 556 int sqlite3VdbeExec(Vdbe*); 557 #if !defined(SQLITE_OMIT_EXPLAIN) || defined(SQLITE_ENABLE_BYTECODE_VTAB) 558 int sqlite3VdbeNextOpcode(Vdbe*,Mem*,int,int*,int*,Op**); 559 char *sqlite3VdbeDisplayP4(sqlite3*,Op*); 560 #endif 561 #if defined(SQLITE_ENABLE_EXPLAIN_COMMENTS) 562 char *sqlite3VdbeDisplayComment(sqlite3*,const Op*,const char*); 563 #endif 564 #if !defined(SQLITE_OMIT_EXPLAIN) 565 int sqlite3VdbeList(Vdbe*); 566 #endif 567 int sqlite3VdbeHalt(Vdbe*); 568 int sqlite3VdbeChangeEncoding(Mem *, int); 569 int sqlite3VdbeMemTooBig(Mem*); 570 int sqlite3VdbeMemCopy(Mem*, const Mem*); 571 void sqlite3VdbeMemShallowCopy(Mem*, const Mem*, int); 572 void sqlite3VdbeMemMove(Mem*, Mem*); 573 int sqlite3VdbeMemNulTerminate(Mem*); 574 int sqlite3VdbeMemSetStr(Mem*, const char*, i64, u8, void(*)(void*)); 575 void sqlite3VdbeMemSetInt64(Mem*, i64); 576 #ifdef SQLITE_OMIT_FLOATING_POINT 577 # define sqlite3VdbeMemSetDouble sqlite3VdbeMemSetInt64 578 #else 579 void sqlite3VdbeMemSetDouble(Mem*, double); 580 #endif 581 void sqlite3VdbeMemSetPointer(Mem*, void*, const char*, void(*)(void*)); 582 void sqlite3VdbeMemInit(Mem*,sqlite3*,u16); 583 void sqlite3VdbeMemSetNull(Mem*); 584 #ifndef SQLITE_OMIT_INCRBLOB 585 void sqlite3VdbeMemSetZeroBlob(Mem*,int); 586 #else 587 int sqlite3VdbeMemSetZeroBlob(Mem*,int); 588 #endif 589 #ifdef SQLITE_DEBUG 590 int sqlite3VdbeMemIsRowSet(const Mem*); 591 #endif 592 int sqlite3VdbeMemSetRowSet(Mem*); 593 int sqlite3VdbeMemMakeWriteable(Mem*); 594 int sqlite3VdbeMemStringify(Mem*, u8, u8); 595 int sqlite3IntFloatCompare(i64,double); 596 i64 sqlite3VdbeIntValue(const Mem*); 597 int sqlite3VdbeMemIntegerify(Mem*); 598 double sqlite3VdbeRealValue(Mem*); 599 int sqlite3VdbeBooleanValue(Mem*, int ifNull); 600 void sqlite3VdbeIntegerAffinity(Mem*); 601 int sqlite3VdbeMemRealify(Mem*); 602 int sqlite3VdbeMemNumerify(Mem*); 603 int sqlite3VdbeMemCast(Mem*,u8,u8); 604 int sqlite3VdbeMemFromBtree(BtCursor*,u32,u32,Mem*); 605 int sqlite3VdbeMemFromBtreeZeroOffset(BtCursor*,u32,Mem*); 606 void sqlite3VdbeMemRelease(Mem *p); 607 int sqlite3VdbeMemFinalize(Mem*, FuncDef*); 608 #ifndef SQLITE_OMIT_WINDOWFUNC 609 int sqlite3VdbeMemAggValue(Mem*, Mem*, FuncDef*); 610 #endif 611 #if !defined(SQLITE_OMIT_EXPLAIN) || defined(SQLITE_ENABLE_BYTECODE_VTAB) 612 const char *sqlite3OpcodeName(int); 613 #endif 614 int sqlite3VdbeMemGrow(Mem *pMem, int n, int preserve); 615 int sqlite3VdbeMemClearAndResize(Mem *pMem, int n); 616 int sqlite3VdbeCloseStatement(Vdbe *, int); 617 #ifdef SQLITE_DEBUG 618 int sqlite3VdbeFrameIsValid(VdbeFrame*); 619 #endif 620 void sqlite3VdbeFrameMemDel(void*); /* Destructor on Mem */ 621 void sqlite3VdbeFrameDelete(VdbeFrame*); /* Actually deletes the Frame */ 622 int sqlite3VdbeFrameRestore(VdbeFrame *); 623 #ifdef SQLITE_ENABLE_PREUPDATE_HOOK 624 void sqlite3VdbePreUpdateHook( 625 Vdbe*,VdbeCursor*,int,const char*,Table*,i64,int,int); 626 #endif 627 int sqlite3VdbeTransferError(Vdbe *p); 628 629 int sqlite3VdbeSorterInit(sqlite3 *, int, VdbeCursor *); 630 void sqlite3VdbeSorterReset(sqlite3 *, VdbeSorter *); 631 void sqlite3VdbeSorterClose(sqlite3 *, VdbeCursor *); 632 int sqlite3VdbeSorterRowkey(const VdbeCursor *, Mem *); 633 int sqlite3VdbeSorterNext(sqlite3 *, const VdbeCursor *); 634 int sqlite3VdbeSorterRewind(const VdbeCursor *, int *); 635 int sqlite3VdbeSorterWrite(const VdbeCursor *, Mem *); 636 int sqlite3VdbeSorterCompare(const VdbeCursor *, Mem *, int, int *); 637 638 #ifdef SQLITE_DEBUG 639 void sqlite3VdbeIncrWriteCounter(Vdbe*, VdbeCursor*); 640 void sqlite3VdbeAssertAbortable(Vdbe*); 641 #else 642 # define sqlite3VdbeIncrWriteCounter(V,C) 643 # define sqlite3VdbeAssertAbortable(V) 644 #endif 645 646 #if !defined(SQLITE_OMIT_SHARED_CACHE) 647 void sqlite3VdbeEnter(Vdbe*); 648 #else 649 # define sqlite3VdbeEnter(X) 650 #endif 651 652 #if !defined(SQLITE_OMIT_SHARED_CACHE) && SQLITE_THREADSAFE>0 653 void sqlite3VdbeLeave(Vdbe*); 654 #else 655 # define sqlite3VdbeLeave(X) 656 #endif 657 658 #ifdef SQLITE_DEBUG 659 void sqlite3VdbeMemAboutToChange(Vdbe*,Mem*); 660 int sqlite3VdbeCheckMemInvariants(Mem*); 661 #endif 662 663 #ifndef SQLITE_OMIT_FOREIGN_KEY 664 int sqlite3VdbeCheckFk(Vdbe *, int); 665 #else 666 # define sqlite3VdbeCheckFk(p,i) 0 667 #endif 668 669 #ifdef SQLITE_DEBUG 670 void sqlite3VdbePrintSql(Vdbe*); 671 void sqlite3VdbeMemPrettyPrint(Mem *pMem, StrAccum *pStr); 672 #endif 673 #ifndef SQLITE_OMIT_UTF16 674 int sqlite3VdbeMemTranslate(Mem*, u8); 675 int sqlite3VdbeMemHandleBom(Mem *pMem); 676 #endif 677 678 #ifndef SQLITE_OMIT_INCRBLOB 679 int sqlite3VdbeMemExpandBlob(Mem *); 680 #define ExpandBlob(P) (((P)->flags&MEM_Zero)?sqlite3VdbeMemExpandBlob(P):0) 681 #else 682 #define sqlite3VdbeMemExpandBlob(x) SQLITE_OK 683 #define ExpandBlob(P) SQLITE_OK 684 #endif 685 686 #endif /* !defined(SQLITE_VDBEINT_H) */ 687