blob: 3e6bb068890efa9cc33f0aec19357cf8b7ea5df9 [file] [log] [blame]
drh9a324642003-09-06 20:12:01 +00001/*
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*/
drh43f58d62016-07-09 16:14:45 +000018#ifndef SQLITE_VDBEINT_H
19#define SQLITE_VDBEINT_H
drh9a324642003-09-06 20:12:01 +000020
21/*
drh60625312013-04-06 18:06:51 +000022** 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/*
drhf7e36902015-08-13 21:32:41 +000030** 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# define VDBE_DISPLAY_P4 1
36#else
37# define VDBE_DISPLAY_P4 0
38#endif
39
40/*
drh9a324642003-09-06 20:12:01 +000041** SQL is translated into a sequence of instructions to be
42** executed by a virtual machine. Each instruction is an instance
43** of the following structure.
44*/
45typedef struct VdbeOp Op;
46
47/*
48** Boolean values
49*/
drh14da87f2013-11-20 21:51:33 +000050typedef unsigned Bool;
drh9a324642003-09-06 20:12:01 +000051
dana20fde62011-07-12 14:28:05 +000052/* Opaque type used by code in vdbesort.c */
53typedef struct VdbeSorter VdbeSorter;
54
dan0c547792013-07-18 17:12:08 +000055/* Elements of the linked list at Vdbe.pAuxData */
56typedef struct AuxData AuxData;
57
drhc960dcb2015-11-20 19:22:01 +000058/* Types of VDBE cursors */
59#define CURTYPE_BTREE 0
60#define CURTYPE_SORTER 1
61#define CURTYPE_VTAB 2
62#define CURTYPE_PSEUDO 3
63
drh9a324642003-09-06 20:12:01 +000064/*
drhc960dcb2015-11-20 19:22:01 +000065** A VdbeCursor is an superclass (a wrapper) for various cursor objects:
drh5cc10232013-11-21 01:04:02 +000066**
drhc960dcb2015-11-20 19:22:01 +000067** * A b-tree cursor
68** - In the main database or in an ephemeral database
69** - On either an index or a table
70** * A sorter
71** * A virtual table
72** * A one-row "pseudotable" stored in a single register
drh9a324642003-09-06 20:12:01 +000073*/
dande892d92016-01-29 19:29:45 +000074typedef struct VdbeCursor VdbeCursor;
drhdfe88ec2008-11-03 20:55:06 +000075struct VdbeCursor {
drhfbd8cbd2016-12-10 12:58:15 +000076 u8 eCurType; /* One of the CURTYPE_* values above */
77 i8 iDb; /* Index of cursor database in db->aDb[] (or -1) */
78 u8 nullRow; /* True if pointing to a row with no data */
79 u8 deferredMoveto; /* A call to sqlite3BtreeMoveto() is needed */
80 u8 isTable; /* True for rowid tables. False for indexes */
drhc960dcb2015-11-20 19:22:01 +000081#ifdef SQLITE_DEBUG
drhfbd8cbd2016-12-10 12:58:15 +000082 u8 seekOp; /* Most recent seek operation on this cursor */
83 u8 wrFlag; /* The wrFlag argument to sqlite3BtreeCursor() */
drhc960dcb2015-11-20 19:22:01 +000084#endif
drhfbd8cbd2016-12-10 12:58:15 +000085 Bool isEphemeral:1; /* True for an ephemeral table */
86 Bool useRandomRowid:1; /* Generate new record numbers semi-randomly */
87 Bool isOrdered:1; /* True if the table is not BTREE_UNORDERED */
88 Btree *pBtx; /* Separate file holding temporary table */
89 i64 seqCount; /* Sequence counter */
90 int *aAltMap; /* Mapping from table to index column numbers */
91
92 /* Cached OP_Column parse information is only valid if cacheStatus matches
93 ** Vdbe.cacheCtr. Vdbe.cacheCtr will never take on the value of
94 ** CACHE_STALE (0) and so setting cacheStatus=CACHE_STALE guarantees that
95 ** the cache is out of date. */
96 u32 cacheStatus; /* Cache is valid if this matches Vdbe.cacheCtr */
97 int seekResult; /* Result of previous sqlite3BtreeMoveto() or 0
98 ** if there have been no prior seeks on the cursor. */
99 /* NB: seekResult does not distinguish between "no seeks have ever occurred
100 ** on this cursor" and "the most recent seek was an exact match". */
101
102 /* When a new VdbeCursor is allocated, only the fields above are zeroed.
103 ** The fields that follow are uninitialized, and must be individually
104 ** initialized prior to first use. */
105 VdbeCursor *pAltCursor; /* Associated index cursor from which to read */
drhc960dcb2015-11-20 19:22:01 +0000106 union {
107 BtCursor *pCursor; /* CURTYPE_BTREE. Btree cursor */
108 sqlite3_vtab_cursor *pVCur; /* CURTYPE_VTAB. Vtab cursor */
109 int pseudoTableReg; /* CURTYPE_PSEUDO. Reg holding content. */
110 VdbeSorter *pSorter; /* CURTYPE_SORTER. Sorter object */
111 } uc;
drhfbd8cbd2016-12-10 12:58:15 +0000112 KeyInfo *pKeyInfo; /* Info about index keys needed by index cursors */
113 u32 iHdrOffset; /* Offset to next unparsed byte of the header */
114 Pgno pgnoRoot; /* Root page of the open btree cursor */
115 i16 nField; /* Number of fields in the header */
116 u16 nHdrParsed; /* Number of header fields parsed so far */
117 i64 movetoTarget; /* Argument to the deferred sqlite3BtreeMoveto() */
118 u32 *aOffset; /* Pointer to aType[nField] */
119 const u8 *aRow; /* Data for the current row, if all on one page */
120 u32 payloadSize; /* Total number of bytes in the record */
121 u32 szRow; /* Byte available in aRow */
drh97bae792015-06-05 15:59:57 +0000122#ifdef SQLITE_ENABLE_COLUMN_USED_MASK
drhfbd8cbd2016-12-10 12:58:15 +0000123 u64 maskUsed; /* Mask of columns used by this cursor */
drh97bae792015-06-05 15:59:57 +0000124#endif
drh9188b382004-05-14 21:12:22 +0000125
drh5cc10232013-11-21 01:04:02 +0000126 /* 2*nField extra array elements allocated for aType[], beyond the one
127 ** static element declared in the structure. nField total array slots for
128 ** aType[] and nField+1 array slots for aOffset[] */
drhfbd8cbd2016-12-10 12:58:15 +0000129 u32 aType[1]; /* Type values record decode. MUST BE LAST */
drh9a324642003-09-06 20:12:01 +0000130};
drh9a324642003-09-06 20:12:01 +0000131
drh22fa36d2016-09-29 15:53:28 +0000132
133/*
134** A value for VdbeCursor.cacheStatus that means the cache is always invalid.
135*/
136#define CACHE_STALE 0
137
dan65a7cd12009-09-01 12:16:01 +0000138/*
139** When a sub-program is executed (OP_Program), a structure of this type
140** is allocated to store the current value of the program counter, as
141** well as the current memory cell array and various other frame specific
142** values stored in the Vdbe struct. When the sub-program is finished,
143** these values are copied back to the Vdbe from the VdbeFrame structure,
144** restoring the state of the VM to as it was before the sub-program
145** began executing.
146**
dan27106572010-12-01 08:04:47 +0000147** The memory for a VdbeFrame object is allocated and managed by a memory
148** cell in the parent (calling) frame. When the memory cell is deleted or
149** overwritten, the VdbeFrame object is not freed immediately. Instead, it
150** is linked into the Vdbe.pDelFrame list. The contents of the Vdbe.pDelFrame
151** list is deleted when the VM is reset in VdbeHalt(). The reason for doing
152** this instead of deleting the VdbeFrame immediately is to avoid recursive
153** calls to sqlite3VdbeMemRelease() when the memory cells belonging to the
154** child frame are released.
155**
156** The currently executing frame is stored in Vdbe.pFrame. Vdbe.pFrame is
157** set to NULL if the currently executing frame is the main program.
dan65a7cd12009-09-01 12:16:01 +0000158*/
dan165921a2009-08-28 18:53:45 +0000159typedef struct VdbeFrame VdbeFrame;
160struct VdbeFrame {
161 Vdbe *v; /* VM this frame belongs to */
drh3fb757b2012-02-02 21:02:43 +0000162 VdbeFrame *pParent; /* Parent of this frame, or NULL if parent is main */
dan27106572010-12-01 08:04:47 +0000163 Op *aOp; /* Program instructions for parent frame */
dan43764a82014-11-01 21:00:04 +0000164 i64 *anExec; /* Event counters from parent frame */
dan27106572010-12-01 08:04:47 +0000165 Mem *aMem; /* Array of memory cells for parent frame */
dan27106572010-12-01 08:04:47 +0000166 VdbeCursor **apCsr; /* Array of Vdbe cursors for parent frame */
dan165921a2009-08-28 18:53:45 +0000167 void *token; /* Copy of SubProgram.token */
drh3fb757b2012-02-02 21:02:43 +0000168 i64 lastRowid; /* Last insert rowid (sqlite3.lastRowid) */
dan32001322016-02-19 18:54:29 +0000169 AuxData *pAuxData; /* Linked list of auxdata allocations */
drh928d9c62013-02-07 09:33:56 +0000170 int nCursor; /* Number of entries in apCsr */
drh3fb757b2012-02-02 21:02:43 +0000171 int pc; /* Program Counter in parent (calling) frame */
172 int nOp; /* Size of aOp array */
173 int nMem; /* Number of entries in aMem */
dan165921a2009-08-28 18:53:45 +0000174 int nChildMem; /* Number of memory cells for child frame */
175 int nChildCsr; /* Number of cursors for child frame */
danc3da6672014-10-28 18:24:16 +0000176 int nChange; /* Statement changes (Vdbe.nChange) */
177 int nDbChange; /* Value of db->nChange */
dan165921a2009-08-28 18:53:45 +0000178};
179
180#define VdbeFrameMem(p) ((Mem *)&((u8 *)p)[ROUND8(sizeof(VdbeFrame))])
181
drh9a324642003-09-06 20:12:01 +0000182/*
danielk19777e18c252004-05-25 11:47:24 +0000183** Internally, the vdbe manipulates nearly all SQL values as Mem
184** structures. Each Mem struct may cache multiple representations (string,
drh2e5de2f2011-01-07 02:50:40 +0000185** integer etc.) of the same value.
drh9a324642003-09-06 20:12:01 +0000186*/
187struct Mem {
drh74eaba42014-09-18 17:52:15 +0000188 union MemValue {
mistachkin26c79a02014-09-18 18:55:47 +0000189 double r; /* Real value used when MEM_Real is set in flags */
drh2e5de2f2011-01-07 02:50:40 +0000190 i64 i; /* Integer value used when MEM_Int is set in flags */
drh8df32842008-12-09 02:51:23 +0000191 int nZero; /* Used when bit MEM_Zero is set in flags */
drh3c024d62007-03-30 11:23:45 +0000192 FuncDef *pDef; /* Used only when flags==MEM_Agg */
drh3d4501e2008-12-04 20:40:10 +0000193 RowSet *pRowSet; /* Used only when flags==MEM_RowSet */
dan165921a2009-08-28 18:53:45 +0000194 VdbeFrame *pFrame; /* Used when flags==MEM_Frame */
drh3c024d62007-03-30 11:23:45 +0000195 } u;
drh69174eb2004-05-26 23:43:11 +0000196 u16 flags; /* Some combination of MEM_Null, MEM_Str, MEM_Dyn, etc. */
drhfdf972a2007-05-02 13:30:27 +0000197 u8 enc; /* SQLITE_UTF8, SQLITE_UTF16BE, SQLITE_UTF16LE */
drhbcdf78a2015-09-10 20:34:56 +0000198 u8 eSubtype; /* Subtype for this value */
drh035e5632014-09-16 14:16:31 +0000199 int n; /* Number of characters in string value, excluding '\0' */
drh035e5632014-09-16 14:16:31 +0000200 char *z; /* String or BLOB value */
drh035e5632014-09-16 14:16:31 +0000201 /* ShallowCopy only needs to copy the information above */
drh17bcb102014-09-18 21:25:33 +0000202 char *zMalloc; /* Space to hold MEM_Str or MEM_Blob if szMalloc>0 */
203 int szMalloc; /* Size of the zMalloc allocation */
drhfacf47a2014-10-13 20:12:47 +0000204 u32 uTemp; /* Transient storage for serial_type in OP_MakeRecord */
drh035e5632014-09-16 14:16:31 +0000205 sqlite3 *db; /* The associated database connection */
drhd3b74202014-09-17 16:41:15 +0000206 void (*xDel)(void*);/* Destructor for Mem.z - only valid if MEM_Dyn */
drh2b4ded92010-09-27 21:09:31 +0000207#ifdef SQLITE_DEBUG
208 Mem *pScopyFrom; /* This Mem is a shallow copy of pScopyFrom */
209 void *pFiller; /* So that sizeof(Mem) is a multiple of 8 */
210#endif
drh9a324642003-09-06 20:12:01 +0000211};
drh9a324642003-09-06 20:12:01 +0000212
drh4f03f412015-05-20 21:28:32 +0000213/*
214** Size of struct Mem not including the Mem.zMalloc member or anything that
215** follows.
216*/
217#define MEMCELLSIZE offsetof(Mem,zMalloc)
218
drh69174eb2004-05-26 23:43:11 +0000219/* One or more of the following flags are set to indicate the validOK
danielk1977b77f5da2004-05-26 13:27:00 +0000220** representations of the value stored in the Mem struct.
drh3dc0b8e2004-05-10 12:07:10 +0000221**
danielk1977b77f5da2004-05-26 13:27:00 +0000222** If the MEM_Null flag is set, then the value is an SQL NULL value.
223** No other flags may be set in this case.
drh3dc0b8e2004-05-10 12:07:10 +0000224**
danielk1977b77f5da2004-05-26 13:27:00 +0000225** If the MEM_Str flag is set then Mem.z points at a string representation.
226** Usually this is encoded in the same unicode encoding as the main
227** database (see below for exceptions). If the MEM_Term flag is also
228** set, then the string is nul terminated. The MEM_Int and MEM_Real
229** flags may coexist with the MEM_Str flag.
drh9a324642003-09-06 20:12:01 +0000230*/
drh00706be2004-01-30 14:49:16 +0000231#define MEM_Null 0x0001 /* Value is NULL */
232#define MEM_Str 0x0002 /* Value is a string */
233#define MEM_Int 0x0004 /* Value is an integer */
234#define MEM_Real 0x0008 /* Value is a real number */
drh3dc0b8e2004-05-10 12:07:10 +0000235#define MEM_Blob 0x0010 /* Value is a BLOB */
mistachkinafc14f72014-03-05 01:29:18 +0000236#define MEM_AffMask 0x001f /* Mask of affinity bits */
drh3d4501e2008-12-04 20:40:10 +0000237#define MEM_RowSet 0x0020 /* Value is a RowSet object */
dan165921a2009-08-28 18:53:45 +0000238#define MEM_Frame 0x0040 /* Value is a VdbeFrame object */
drha5750cf2014-02-07 13:20:31 +0000239#define MEM_Undefined 0x0080 /* Value is undefined */
drh053a1282012-09-19 21:15:46 +0000240#define MEM_Cleared 0x0100 /* NULL set by OP_Null, not from data */
dan5b6c8e42016-01-30 15:46:03 +0000241#define MEM_TypeMask 0x81ff /* Mask of type bits */
drh053a1282012-09-19 21:15:46 +0000242
danielk1977a7a8e142008-02-13 18:25:27 +0000243
danielk1977b77f5da2004-05-26 13:27:00 +0000244/* Whenever Mem contains a valid string or blob representation, one of
245** the following flags must be set to determine the memory management
drh69174eb2004-05-26 23:43:11 +0000246** policy for Mem.z. The MEM_Term flag tells us whether or not the
247** string is \000 or \u0000 terminated
danielk1977b77f5da2004-05-26 13:27:00 +0000248*/
drh3d4501e2008-12-04 20:40:10 +0000249#define MEM_Term 0x0200 /* String rep is nul terminated */
drhc91b2fd2014-03-01 18:13:23 +0000250#define MEM_Dyn 0x0400 /* Need to call Mem.xDel() on Mem.z */
drh3d4501e2008-12-04 20:40:10 +0000251#define MEM_Static 0x0800 /* Mem.z points to a static string */
252#define MEM_Ephem 0x1000 /* Mem.z points to an ephemeral string */
253#define MEM_Agg 0x2000 /* Mem.z points to an agg function context */
254#define MEM_Zero 0x4000 /* Mem.i contains count of 0s appended to blob */
dan5b6c8e42016-01-30 15:46:03 +0000255#define MEM_Subtype 0x8000 /* Mem.eSubtype is valid */
danielk1977246ad312007-05-16 14:23:00 +0000256#ifdef SQLITE_OMIT_INCRBLOB
257 #undef MEM_Zero
258 #define MEM_Zero 0x0000
259#endif
260
dan5b6c8e42016-01-30 15:46:03 +0000261/* Return TRUE if Mem X contains dynamically allocated content - anything
262** that needs to be deallocated to avoid a leak.
263*/
264#define VdbeMemDynamic(X) \
265 (((X)->flags&(MEM_Agg|MEM_Dyn|MEM_RowSet|MEM_Frame))!=0)
266
drh3d4501e2008-12-04 20:40:10 +0000267/*
268** Clear any existing type flags from a Mem and replace them with f
269*/
drh68ac65e2009-01-05 18:02:27 +0000270#define MemSetTypeFlag(p, f) \
271 ((p)->flags = ((p)->flags&~(MEM_TypeMask|MEM_Zero))|f)
drh3d4501e2008-12-04 20:40:10 +0000272
drh2b4ded92010-09-27 21:09:31 +0000273/*
274** Return true if a memory cell is not marked as invalid. This macro
275** is for use inside assert() statements only.
276*/
277#ifdef SQLITE_DEBUG
drha5750cf2014-02-07 13:20:31 +0000278#define memIsValid(M) ((M)->flags & MEM_Undefined)==0
drh2b4ded92010-09-27 21:09:31 +0000279#endif
280
dan0c547792013-07-18 17:12:08 +0000281/*
peter.d.reid60ec9142014-09-06 16:39:46 +0000282** Each auxiliary data pointer stored by a user defined function
dan0c547792013-07-18 17:12:08 +0000283** implementation calling sqlite3_set_auxdata() is stored in an instance
284** of this structure. All such structures associated with a single VM
285** are stored in a linked list headed at Vdbe.pAuxData. All are destroyed
286** when the VM is halted (if not before).
drh998da3a2004-06-19 15:22:56 +0000287*/
dan0c547792013-07-18 17:12:08 +0000288struct AuxData {
289 int iOp; /* Instruction number of OP_Function opcode */
290 int iArg; /* Index of function argument. */
291 void *pAux; /* Aux data pointer */
292 void (*xDelete)(void *); /* Destructor for the aux data */
293 AuxData *pNext; /* Next element in list */
danielk1977682f68b2004-06-05 10:22:17 +0000294};
danielk1977682f68b2004-06-05 10:22:17 +0000295
drh9a324642003-09-06 20:12:01 +0000296/*
peter.d.reid60ec9142014-09-06 16:39:46 +0000297** The "context" argument for an installable function. A pointer to an
drh9a324642003-09-06 20:12:01 +0000298** instance of this structure is the first argument to the routines used
299** implement the SQL functions.
300**
301** There is a typedef for this structure in sqlite.h. So all routines,
302** even the public interface to SQLite, can use a pointer to this structure.
303** But this file is the only place where the internal details of this
304** structure are known.
305**
drhabfcea22005-09-06 20:36:48 +0000306** This structure is defined inside of vdbeInt.h because it uses substructures
drh00706be2004-01-30 14:49:16 +0000307** (Mem) which are only defined there.
drh9a324642003-09-06 20:12:01 +0000308*/
danielk19770ae8b832004-05-25 12:05:56 +0000309struct sqlite3_context {
drh9c7c9132015-06-26 18:16:52 +0000310 Mem *pOut; /* The return value is stored here */
311 FuncDef *pFunc; /* Pointer to function information */
312 Mem *pMem; /* Memory cell used to store aggregate context */
313 Vdbe *pVdbe; /* The VM that owns this context */
314 int iOp; /* Instruction number of OP_Function */
315 int isError; /* Error code returned by the function. */
316 u8 skipFlag; /* Skip accumulator loading if true */
317 u8 fErrorOrAux; /* isError!=0 or pVdbe->pAuxData modified */
318 u8 argc; /* Number of arguments */
319 sqlite3_value *argv[1]; /* Argument set */
drh9a324642003-09-06 20:12:01 +0000320};
321
drh37f58e92012-09-04 21:34:26 +0000322/* A bitfield type for use inside of structures. Always follow with :N where
323** N is the number of bits.
324*/
325typedef unsigned bft; /* Bit Field Type */
326
dan037b5322014-11-03 11:25:32 +0000327typedef struct ScanStatus ScanStatus;
328struct ScanStatus {
dan6f9702e2014-11-01 20:38:06 +0000329 int addrExplain; /* OP_Explain for loop */
330 int addrLoop; /* Address of "loops" counter */
331 int addrVisit; /* Address of "rows visited" counter */
drhc6652b12014-11-06 04:42:20 +0000332 int iSelectID; /* The "Select-ID" for this loop */
drh518140e2014-11-06 03:55:10 +0000333 LogEst nEst; /* Estimated output rows per loop */
dan6f9702e2014-11-01 20:38:06 +0000334 char *zName; /* Name of table or index */
335};
336
drh7e02e5e2011-12-06 19:44:51 +0000337/*
drh9a324642003-09-06 20:12:01 +0000338** An instance of the virtual machine. This structure contains the complete
339** state of the virtual machine.
340**
drh2e5de2f2011-01-07 02:50:40 +0000341** The "sqlite3_stmt" structure pointer that is returned by sqlite3_prepare()
drh9a324642003-09-06 20:12:01 +0000342** is really a pointer to an instance of this structure.
343*/
344struct Vdbe {
drh8bfdf722009-06-19 14:06:03 +0000345 sqlite3 *db; /* The database connection that owns this statement */
drhab3182f2016-10-01 00:37:50 +0000346 Vdbe *pPrev,*pNext; /* Linked list of VDBEs with the same Vdbe.db */
347 Parse *pParse; /* Parsing context used to create this Vdbe */
348 ynVar nVar; /* Number of entries in aVar[] */
drhab3182f2016-10-01 00:37:50 +0000349 u32 magic; /* Magic number for sanity checking */
350 int nMem; /* Number of memory locations currently allocated */
351 int nCursor; /* Number of slots in apCsr[] */
352 u32 cacheCtr; /* VdbeCursor row cache generation counter */
353 int pc; /* The program counter */
354 int rc; /* Value to return */
355 int nChange; /* Number of db changes made since last reset */
356 int iStatement; /* Statement number (or 0 if has not opened stmt) */
357 i64 iCurrentTime; /* Value of julianday('now') for this statement */
358 i64 nFkConstraint; /* Number of imm. FK constraints this VM */
359 i64 nStmtDefCons; /* Number of def. constraints when stmt started */
360 i64 nStmtDefImmCons; /* Number of def. imm constraints when stmt started */
361
362 /* When allocating a new Vdbe object, all of the fields below should be
363 ** initialized to zero or NULL */
364
drh8bfdf722009-06-19 14:06:03 +0000365 Op *aOp; /* Space to hold the virtual machine's program */
drh2e5de2f2011-01-07 02:50:40 +0000366 Mem *aMem; /* The memory locations */
drh8bfdf722009-06-19 14:06:03 +0000367 Mem **apArg; /* Arguments to currently executing user function */
368 Mem *aColName; /* Column names to return */
369 Mem *pResultSet; /* Pointer to an array of results */
drh2e5de2f2011-01-07 02:50:40 +0000370 char *zErrMsg; /* Error message written here */
drh8bfdf722009-06-19 14:06:03 +0000371 VdbeCursor **apCsr; /* One element of this array for each open cursor */
drh8bfdf722009-06-19 14:06:03 +0000372 Mem *aVar; /* Values for the OP_Variable opcode. */
drh9bf755c2016-12-23 03:59:31 +0000373 VList *pVList; /* Name of variables */
drhab3182f2016-10-01 00:37:50 +0000374#ifndef SQLITE_OMIT_TRACE
375 i64 startTime; /* Time when query started - used for profiling */
376#endif
377 int nOp; /* Number of instructions in the program */
drh983b5ee2015-02-13 12:05:56 +0000378#ifdef SQLITE_DEBUG
379 int rcApp; /* errcode set by sqlite3_result_error_code() */
380#endif
drh73d5b8f2013-12-23 19:09:07 +0000381 u16 nResColumn; /* Number of columns in one row of the result set */
drh2e5de2f2011-01-07 02:50:40 +0000382 u8 errorAction; /* Recovery action to do in case of an error */
drhab3182f2016-10-01 00:37:50 +0000383 u8 minWriteFileFormat; /* Minimum file format for writable database files */
drhc5db1d42016-03-16 00:36:19 +0000384 bft expired:1; /* True if the VM needs to be recompiled */
385 bft doingRerun:1; /* True if rerunning after an auto-reprepare */
drh37f58e92012-09-04 21:34:26 +0000386 bft explain:2; /* True if EXPLAIN present on SQL command */
drh37f58e92012-09-04 21:34:26 +0000387 bft changeCntOn:1; /* True to update the change-counter */
drh37f58e92012-09-04 21:34:26 +0000388 bft runOnlyOnce:1; /* Automatically expire on reset */
389 bft usesStmtJournal:1; /* True if uses a statement journal */
drh9e92a472013-06-27 17:40:30 +0000390 bft readOnly:1; /* True for statements that do not write */
drh1713afb2013-06-28 01:24:57 +0000391 bft bIsReader:1; /* True for statements that read */
drh37f58e92012-09-04 21:34:26 +0000392 bft isPrepareV2:1; /* True if prepared with prepare_v2() */
drh64123582011-04-02 20:01:02 +0000393 yDbMask btreeMask; /* Bitmask of db->aDb[] entries referenced */
drhdc5b0472011-04-06 22:05:53 +0000394 yDbMask lockMask; /* Subset of btreeMask that requires a lock */
drh9b47ee32013-08-20 03:13:51 +0000395 u32 aCounter[5]; /* Counters used by sqlite3_stmt_status() */
drh2e5de2f2011-01-07 02:50:40 +0000396 char *zSql; /* Text of the SQL statement that generated this */
397 void *pFree; /* Free this when deleting the vdbe */
dan165921a2009-08-28 18:53:45 +0000398 VdbeFrame *pFrame; /* Parent frame */
dan27106572010-12-01 08:04:47 +0000399 VdbeFrame *pDelFrame; /* List of frame objects to free on VM reset */
dan165921a2009-08-28 18:53:45 +0000400 int nFrame; /* Number of frames in pFrame list */
dan937d0de2009-10-15 18:35:38 +0000401 u32 expmask; /* Binding to these vars invalidates VM */
dand19c9332010-07-26 12:05:17 +0000402 SubProgram *pProgram; /* Linked list of all sub-programs used by VM */
dan0c547792013-07-18 17:12:08 +0000403 AuxData *pAuxData; /* Linked list of auxdata allocations */
dan6f9702e2014-11-01 20:38:06 +0000404#ifdef SQLITE_ENABLE_STMT_SCANSTATUS
405 i64 *anExec; /* Number of times each op has been executed */
406 int nScan; /* Entries in aScan[] */
dan037b5322014-11-03 11:25:32 +0000407 ScanStatus *aScan; /* Scan definitions for sqlite3_stmt_scanstatus() */
dan6f9702e2014-11-01 20:38:06 +0000408#endif
drh9a324642003-09-06 20:12:01 +0000409};
410
411/*
412** The following are allowed values for Vdbe.magic
413*/
drhab3182f2016-10-01 00:37:50 +0000414#define VDBE_MAGIC_INIT 0x16bceaa5 /* Building a VDBE program */
415#define VDBE_MAGIC_RUN 0x2df20da3 /* VDBE is ready to execute */
416#define VDBE_MAGIC_HALT 0x319c2973 /* VDBE has completed execution */
417#define VDBE_MAGIC_RESET 0x48fa9f76 /* Reset and ready to run again */
418#define VDBE_MAGIC_DEAD 0x5606c3c8 /* The VDBE has been deallocated */
drh9a324642003-09-06 20:12:01 +0000419
420/*
dan46c47d42011-03-01 18:42:07 +0000421** Structure used to store the context required by the
422** sqlite3_preupdate_*() API functions.
423*/
424struct PreUpdate {
dan37db03b2011-03-16 19:59:18 +0000425 Vdbe *v;
dan46c47d42011-03-01 18:42:07 +0000426 VdbeCursor *pCsr; /* Cursor to read old values from */
427 int op; /* One of SQLITE_INSERT, UPDATE, DELETE */
428 u8 *aRecord; /* old.* database record */
dan4fccf432011-03-08 19:22:50 +0000429 KeyInfo keyinfo;
dan46c47d42011-03-01 18:42:07 +0000430 UnpackedRecord *pUnpacked; /* Unpacked version of aRecord[] */
dan37db03b2011-03-16 19:59:18 +0000431 UnpackedRecord *pNewUnpacked; /* Unpacked version of new.* record */
432 int iNewReg; /* Register for new.* values */
dan319eeb72011-03-19 08:38:50 +0000433 i64 iKey1; /* First key value passed to hook */
434 i64 iKey2; /* Second key value passed to hook */
dan37db03b2011-03-16 19:59:18 +0000435 Mem *aNew; /* Array of new.* values */
dane43635a2016-10-21 21:21:45 +0000436 Table *pTab; /* Schema object being upated */
dan46c47d42011-03-01 18:42:07 +0000437};
438
439/*
drh9a324642003-09-06 20:12:01 +0000440** Function prototypes
441*/
drh22c17b82015-05-15 04:13:15 +0000442void sqlite3VdbeError(Vdbe*, const char *, ...);
drhdfe88ec2008-11-03 20:55:06 +0000443void sqlite3VdbeFreeCursor(Vdbe *, VdbeCursor*);
drh9a324642003-09-06 20:12:01 +0000444void sqliteVdbePopStack(Vdbe*,int);
dande892d92016-01-29 19:29:45 +0000445int sqlite3VdbeCursorMoveto(VdbeCursor**, int*);
drhc22284f2014-10-13 16:02:20 +0000446int sqlite3VdbeCursorRestore(VdbeCursor*);
danielk19778b60e0f2005-01-12 09:10:39 +0000447#if defined(SQLITE_DEBUG) || defined(VDBE_PROFILE)
danielk19774adee202004-05-08 08:23:19 +0000448void sqlite3VdbePrintOp(FILE*, int, Op*);
drh9a324642003-09-06 20:12:01 +0000449#endif
drh35cd6432009-06-05 14:17:21 +0000450u32 sqlite3VdbeSerialTypeLen(u32);
drhfaf37272015-10-16 14:23:42 +0000451u8 sqlite3VdbeOneByteSerialTypeLen(u8);
drhbe37c122015-10-16 14:54:17 +0000452u32 sqlite3VdbeSerialType(Mem*, int, u32*);
drha9ab4812013-12-11 11:00:44 +0000453u32 sqlite3VdbeSerialPut(unsigned char*, Mem*, u32);
drh35cd6432009-06-05 14:17:21 +0000454u32 sqlite3VdbeSerialGet(const unsigned char*, u32, Mem*);
drhb9626cf2016-02-22 16:04:31 +0000455void sqlite3VdbeDeleteAuxData(sqlite3*, AuxData**, int, int);
danielk19774adee202004-05-08 08:23:19 +0000456
danielk1977189621d2004-05-09 23:23:56 +0000457int sqlite2BtreeKeyCompare(BtCursor *, const void *, int, int, int *);
drhd3b74202014-09-17 16:41:15 +0000458int sqlite3VdbeIdxKeyCompare(sqlite3*,VdbeCursor*,UnpackedRecord*,int*);
459int sqlite3VdbeIdxRowid(sqlite3*, BtCursor*, i64*);
danielk1977106bb232004-05-21 10:08:53 +0000460int sqlite3VdbeExec(Vdbe*);
461int sqlite3VdbeList(Vdbe*);
drh92f02c32004-09-02 14:57:08 +0000462int sqlite3VdbeHalt(Vdbe*);
drhb21c8cd2007-08-21 19:33:56 +0000463int sqlite3VdbeChangeEncoding(Mem *, int);
drh023ae032007-05-08 12:12:16 +0000464int sqlite3VdbeMemTooBig(Mem*);
drhb21c8cd2007-08-21 19:33:56 +0000465int sqlite3VdbeMemCopy(Mem*, const Mem*);
drhfebe1062004-08-28 18:17:48 +0000466void sqlite3VdbeMemShallowCopy(Mem*, const Mem*, int);
drh643167f2008-01-22 21:30:53 +0000467void sqlite3VdbeMemMove(Mem*, Mem*);
drhb21c8cd2007-08-21 19:33:56 +0000468int sqlite3VdbeMemNulTerminate(Mem*);
469int sqlite3VdbeMemSetStr(Mem*, const char*, int, u8, void(*)(void*));
drhefad9992004-06-22 12:13:55 +0000470void sqlite3VdbeMemSetInt64(Mem*, i64);
drh7ec5ea92010-01-13 00:04:13 +0000471#ifdef SQLITE_OMIT_FLOATING_POINT
472# define sqlite3VdbeMemSetDouble sqlite3VdbeMemSetInt64
473#else
474 void sqlite3VdbeMemSetDouble(Mem*, double);
475#endif
drhd3b74202014-09-17 16:41:15 +0000476void sqlite3VdbeMemInit(Mem*,sqlite3*,u16);
drhf4479502004-05-27 03:12:53 +0000477void sqlite3VdbeMemSetNull(Mem*);
drhb026e052007-05-02 01:34:31 +0000478void sqlite3VdbeMemSetZeroBlob(Mem*,int);
drh3d4501e2008-12-04 20:40:10 +0000479void sqlite3VdbeMemSetRowSet(Mem*);
drhb21c8cd2007-08-21 19:33:56 +0000480int sqlite3VdbeMemMakeWriteable(Mem*);
drhbd9507c2014-08-23 17:21:37 +0000481int sqlite3VdbeMemStringify(Mem*, u8, u8);
drh6a6124e2004-06-27 01:56:33 +0000482i64 sqlite3VdbeIntValue(Mem*);
drheb2e1762004-05-27 01:53:56 +0000483int sqlite3VdbeMemIntegerify(Mem*);
drh6a6124e2004-06-27 01:56:33 +0000484double sqlite3VdbeRealValue(Mem*);
drh8df447f2005-11-01 15:48:24 +0000485void sqlite3VdbeIntegerAffinity(Mem*);
drheb2e1762004-05-27 01:53:56 +0000486int sqlite3VdbeMemRealify(Mem*);
drh8a512562005-11-14 22:29:05 +0000487int sqlite3VdbeMemNumerify(Mem*);
drh4169e432014-08-25 20:11:52 +0000488void sqlite3VdbeMemCast(Mem*,u8,u8);
drhcb3cabd2016-11-25 19:18:28 +0000489int sqlite3VdbeMemFromBtree(BtCursor*,u32,u32,Mem*);
danielk1977d8123362004-06-12 09:25:12 +0000490void sqlite3VdbeMemRelease(Mem *p);
drh90669c12006-01-20 15:45:36 +0000491int sqlite3VdbeMemFinalize(Mem*, FuncDef*);
drh46c99e02007-08-27 23:26:59 +0000492const char *sqlite3OpcodeName(int);
danielk1977a7a8e142008-02-13 18:25:27 +0000493int sqlite3VdbeMemGrow(Mem *pMem, int n, int preserve);
drh322f2852014-09-19 00:43:39 +0000494int sqlite3VdbeMemClearAndResize(Mem *pMem, int n);
danielk1977bd434552009-03-18 10:33:00 +0000495int sqlite3VdbeCloseStatement(Vdbe *, int);
dan165921a2009-08-28 18:53:45 +0000496void sqlite3VdbeFrameDelete(VdbeFrame*);
497int sqlite3VdbeFrameRestore(VdbeFrame *);
drh74c33022016-03-30 12:56:55 +0000498#ifdef SQLITE_ENABLE_PREUPDATE_HOOK
499void sqlite3VdbePreUpdateHook(Vdbe*,VdbeCursor*,int,const char*,Table*,i64,int);
500#endif
dan029ead62011-10-27 15:19:58 +0000501int sqlite3VdbeTransferError(Vdbe *p);
drhe54e0512011-04-05 17:31:56 +0000502
danfad9f9a2014-04-01 18:41:51 +0000503int sqlite3VdbeSorterInit(sqlite3 *, int, VdbeCursor *);
drh65ea12c2014-03-19 17:41:36 +0000504void sqlite3VdbeSorterReset(sqlite3 *, VdbeSorter *);
dana20fde62011-07-12 14:28:05 +0000505void sqlite3VdbeSorterClose(sqlite3 *, VdbeCursor *);
drhc041c162012-07-24 19:46:38 +0000506int sqlite3VdbeSorterRowkey(const VdbeCursor *, Mem *);
507int sqlite3VdbeSorterNext(sqlite3 *, const VdbeCursor *, int *);
drh958d2612014-04-18 13:40:07 +0000508int sqlite3VdbeSorterRewind(const VdbeCursor *, int *);
509int sqlite3VdbeSorterWrite(const VdbeCursor *, Mem *);
drh1153c7b2013-11-01 22:02:56 +0000510int sqlite3VdbeSorterCompare(const VdbeCursor *, Mem *, int, int *);
dan7fe62702011-08-02 10:56:22 +0000511
dan20d876f2016-01-07 16:06:22 +0000512#if !defined(SQLITE_OMIT_SHARED_CACHE)
drhe54e0512011-04-05 17:31:56 +0000513 void sqlite3VdbeEnter(Vdbe*);
drhe54e0512011-04-05 17:31:56 +0000514#else
515# define sqlite3VdbeEnter(X)
dan20d876f2016-01-07 16:06:22 +0000516#endif
517
518#if !defined(SQLITE_OMIT_SHARED_CACHE) && SQLITE_THREADSAFE>0
519 void sqlite3VdbeLeave(Vdbe*);
520#else
drhe54e0512011-04-05 17:31:56 +0000521# define sqlite3VdbeLeave(X)
522#endif
drh46c99e02007-08-27 23:26:59 +0000523
drh2b4ded92010-09-27 21:09:31 +0000524#ifdef SQLITE_DEBUG
drhe4c88c02012-01-04 12:57:45 +0000525void sqlite3VdbeMemAboutToChange(Vdbe*,Mem*);
drh75fd0542014-03-01 16:24:44 +0000526int sqlite3VdbeCheckMemInvariants(Mem*);
drh2b4ded92010-09-27 21:09:31 +0000527#endif
528
dan1da40a32009-09-19 17:00:31 +0000529#ifndef SQLITE_OMIT_FOREIGN_KEY
dan8a2fff72009-09-23 18:07:22 +0000530int sqlite3VdbeCheckFk(Vdbe *, int);
dan1da40a32009-09-19 17:00:31 +0000531#else
dan8a2fff72009-09-23 18:07:22 +0000532# define sqlite3VdbeCheckFk(p,i) 0
dan1da40a32009-09-19 17:00:31 +0000533#endif
534
drhb21c8cd2007-08-21 19:33:56 +0000535int sqlite3VdbeMemTranslate(Mem*, u8);
drh87cc3b32007-05-08 21:45:27 +0000536#ifdef SQLITE_DEBUG
537 void sqlite3VdbePrintSql(Vdbe*);
538 void sqlite3VdbeMemPrettyPrint(Mem *pMem, char *zBuf);
539#endif
drhb21c8cd2007-08-21 19:33:56 +0000540int sqlite3VdbeMemHandleBom(Mem *pMem);
drh4e78be62007-01-26 21:08:04 +0000541
danielk1977246ad312007-05-16 14:23:00 +0000542#ifndef SQLITE_OMIT_INCRBLOB
drhb21c8cd2007-08-21 19:33:56 +0000543 int sqlite3VdbeMemExpandBlob(Mem *);
drh45d29302012-01-08 22:18:33 +0000544 #define ExpandBlob(P) (((P)->flags&MEM_Zero)?sqlite3VdbeMemExpandBlob(P):0)
danielk1977246ad312007-05-16 14:23:00 +0000545#else
drhb21c8cd2007-08-21 19:33:56 +0000546 #define sqlite3VdbeMemExpandBlob(x) SQLITE_OK
drh45d29302012-01-08 22:18:33 +0000547 #define ExpandBlob(P) SQLITE_OK
danielk1977246ad312007-05-16 14:23:00 +0000548#endif
549
drh43f58d62016-07-09 16:14:45 +0000550#endif /* !defined(SQLITE_VDBEINT_H) */