blob: 366496bf6a40ec7d3b1aff4862e2be58418abac4 [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 */
drhab087d42017-03-24 17:59:56 +0000167 u8 *aOnce; /* Bitmask used by OP_Once */
dan165921a2009-08-28 18:53:45 +0000168 void *token; /* Copy of SubProgram.token */
drh3fb757b2012-02-02 21:02:43 +0000169 i64 lastRowid; /* Last insert rowid (sqlite3.lastRowid) */
dan32001322016-02-19 18:54:29 +0000170 AuxData *pAuxData; /* Linked list of auxdata allocations */
drh928d9c62013-02-07 09:33:56 +0000171 int nCursor; /* Number of entries in apCsr */
drh3fb757b2012-02-02 21:02:43 +0000172 int pc; /* Program Counter in parent (calling) frame */
173 int nOp; /* Size of aOp array */
174 int nMem; /* Number of entries in aMem */
dan165921a2009-08-28 18:53:45 +0000175 int nChildMem; /* Number of memory cells for child frame */
176 int nChildCsr; /* Number of cursors for child frame */
danc3da6672014-10-28 18:24:16 +0000177 int nChange; /* Statement changes (Vdbe.nChange) */
178 int nDbChange; /* Value of db->nChange */
dan165921a2009-08-28 18:53:45 +0000179};
180
181#define VdbeFrameMem(p) ((Mem *)&((u8 *)p)[ROUND8(sizeof(VdbeFrame))])
182
drh9a324642003-09-06 20:12:01 +0000183/*
danielk19777e18c252004-05-25 11:47:24 +0000184** Internally, the vdbe manipulates nearly all SQL values as Mem
185** structures. Each Mem struct may cache multiple representations (string,
drh2e5de2f2011-01-07 02:50:40 +0000186** integer etc.) of the same value.
drh9a324642003-09-06 20:12:01 +0000187*/
drh7a6ea932017-04-09 19:23:55 +0000188struct sqlite3_value {
drh74eaba42014-09-18 17:52:15 +0000189 union MemValue {
mistachkin26c79a02014-09-18 18:55:47 +0000190 double r; /* Real value used when MEM_Real is set in flags */
drh2e5de2f2011-01-07 02:50:40 +0000191 i64 i; /* Integer value used when MEM_Int is set in flags */
drh22930062017-07-27 03:48:02 +0000192 int nZero; /* Extra zero bytes when MEM_Zero and MEM_Blob set */
193 const char *zPType; /* Pointer type when MEM_Pointer and MEM_Null set */
drh3c024d62007-03-30 11:23:45 +0000194 FuncDef *pDef; /* Used only when flags==MEM_Agg */
drh3d4501e2008-12-04 20:40:10 +0000195 RowSet *pRowSet; /* Used only when flags==MEM_RowSet */
dan165921a2009-08-28 18:53:45 +0000196 VdbeFrame *pFrame; /* Used when flags==MEM_Frame */
drh3c024d62007-03-30 11:23:45 +0000197 } u;
drh69174eb2004-05-26 23:43:11 +0000198 u16 flags; /* Some combination of MEM_Null, MEM_Str, MEM_Dyn, etc. */
drhfdf972a2007-05-02 13:30:27 +0000199 u8 enc; /* SQLITE_UTF8, SQLITE_UTF16BE, SQLITE_UTF16LE */
drhbcdf78a2015-09-10 20:34:56 +0000200 u8 eSubtype; /* Subtype for this value */
drh035e5632014-09-16 14:16:31 +0000201 int n; /* Number of characters in string value, excluding '\0' */
drh035e5632014-09-16 14:16:31 +0000202 char *z; /* String or BLOB value */
drh035e5632014-09-16 14:16:31 +0000203 /* ShallowCopy only needs to copy the information above */
drh17bcb102014-09-18 21:25:33 +0000204 char *zMalloc; /* Space to hold MEM_Str or MEM_Blob if szMalloc>0 */
205 int szMalloc; /* Size of the zMalloc allocation */
drhfacf47a2014-10-13 20:12:47 +0000206 u32 uTemp; /* Transient storage for serial_type in OP_MakeRecord */
drh035e5632014-09-16 14:16:31 +0000207 sqlite3 *db; /* The associated database connection */
drhd3b74202014-09-17 16:41:15 +0000208 void (*xDel)(void*);/* Destructor for Mem.z - only valid if MEM_Dyn */
drh2b4ded92010-09-27 21:09:31 +0000209#ifdef SQLITE_DEBUG
210 Mem *pScopyFrom; /* This Mem is a shallow copy of pScopyFrom */
211 void *pFiller; /* So that sizeof(Mem) is a multiple of 8 */
212#endif
drh9a324642003-09-06 20:12:01 +0000213};
drh9a324642003-09-06 20:12:01 +0000214
drh4f03f412015-05-20 21:28:32 +0000215/*
216** Size of struct Mem not including the Mem.zMalloc member or anything that
217** follows.
218*/
219#define MEMCELLSIZE offsetof(Mem,zMalloc)
220
drh69174eb2004-05-26 23:43:11 +0000221/* One or more of the following flags are set to indicate the validOK
danielk1977b77f5da2004-05-26 13:27:00 +0000222** representations of the value stored in the Mem struct.
drh3dc0b8e2004-05-10 12:07:10 +0000223**
danielk1977b77f5da2004-05-26 13:27:00 +0000224** If the MEM_Null flag is set, then the value is an SQL NULL value.
225** No other flags may be set in this case.
drh3dc0b8e2004-05-10 12:07:10 +0000226**
danielk1977b77f5da2004-05-26 13:27:00 +0000227** If the MEM_Str flag is set then Mem.z points at a string representation.
228** Usually this is encoded in the same unicode encoding as the main
229** database (see below for exceptions). If the MEM_Term flag is also
230** set, then the string is nul terminated. The MEM_Int and MEM_Real
231** flags may coexist with the MEM_Str flag.
drh9a324642003-09-06 20:12:01 +0000232*/
drh00706be2004-01-30 14:49:16 +0000233#define MEM_Null 0x0001 /* Value is NULL */
234#define MEM_Str 0x0002 /* Value is a string */
235#define MEM_Int 0x0004 /* Value is an integer */
236#define MEM_Real 0x0008 /* Value is a real number */
drh3dc0b8e2004-05-10 12:07:10 +0000237#define MEM_Blob 0x0010 /* Value is a BLOB */
mistachkinafc14f72014-03-05 01:29:18 +0000238#define MEM_AffMask 0x001f /* Mask of affinity bits */
drh3d4501e2008-12-04 20:40:10 +0000239#define MEM_RowSet 0x0020 /* Value is a RowSet object */
dan165921a2009-08-28 18:53:45 +0000240#define MEM_Frame 0x0040 /* Value is a VdbeFrame object */
drha5750cf2014-02-07 13:20:31 +0000241#define MEM_Undefined 0x0080 /* Value is undefined */
drh053a1282012-09-19 21:15:46 +0000242#define MEM_Cleared 0x0100 /* NULL set by OP_Null, not from data */
drh22930062017-07-27 03:48:02 +0000243#define MEM_TypeMask 0xc1ff /* Mask of type bits */
drh053a1282012-09-19 21:15:46 +0000244
danielk1977a7a8e142008-02-13 18:25:27 +0000245
danielk1977b77f5da2004-05-26 13:27:00 +0000246/* Whenever Mem contains a valid string or blob representation, one of
247** the following flags must be set to determine the memory management
drh69174eb2004-05-26 23:43:11 +0000248** policy for Mem.z. The MEM_Term flag tells us whether or not the
249** string is \000 or \u0000 terminated
drh22930062017-07-27 03:48:02 +0000250**
251** NB: MEM_Zero and MEM_Pointer are the same value. But MEM_Zero is
252** only value if MEM_Blob is also set, and MEM_Pointer is only valid
253** if MEM_Null is also set.
danielk1977b77f5da2004-05-26 13:27:00 +0000254*/
drh3d4501e2008-12-04 20:40:10 +0000255#define MEM_Term 0x0200 /* String rep is nul terminated */
drhc91b2fd2014-03-01 18:13:23 +0000256#define MEM_Dyn 0x0400 /* Need to call Mem.xDel() on Mem.z */
drh3d4501e2008-12-04 20:40:10 +0000257#define MEM_Static 0x0800 /* Mem.z points to a static string */
258#define MEM_Ephem 0x1000 /* Mem.z points to an ephemeral string */
259#define MEM_Agg 0x2000 /* Mem.z points to an agg function context */
260#define MEM_Zero 0x4000 /* Mem.i contains count of 0s appended to blob */
drh22930062017-07-27 03:48:02 +0000261#define MEM_Pointer 0x4000 /* Mem.z is an extension pointer */
dan5b6c8e42016-01-30 15:46:03 +0000262#define MEM_Subtype 0x8000 /* Mem.eSubtype is valid */
danielk1977246ad312007-05-16 14:23:00 +0000263#ifdef SQLITE_OMIT_INCRBLOB
264 #undef MEM_Zero
265 #define MEM_Zero 0x0000
266#endif
267
dan5b6c8e42016-01-30 15:46:03 +0000268/* Return TRUE if Mem X contains dynamically allocated content - anything
269** that needs to be deallocated to avoid a leak.
270*/
271#define VdbeMemDynamic(X) \
272 (((X)->flags&(MEM_Agg|MEM_Dyn|MEM_RowSet|MEM_Frame))!=0)
273
drh3d4501e2008-12-04 20:40:10 +0000274/*
275** Clear any existing type flags from a Mem and replace them with f
276*/
drh68ac65e2009-01-05 18:02:27 +0000277#define MemSetTypeFlag(p, f) \
278 ((p)->flags = ((p)->flags&~(MEM_TypeMask|MEM_Zero))|f)
drh3d4501e2008-12-04 20:40:10 +0000279
drh2b4ded92010-09-27 21:09:31 +0000280/*
281** Return true if a memory cell is not marked as invalid. This macro
282** is for use inside assert() statements only.
283*/
284#ifdef SQLITE_DEBUG
drha5750cf2014-02-07 13:20:31 +0000285#define memIsValid(M) ((M)->flags & MEM_Undefined)==0
drh2b4ded92010-09-27 21:09:31 +0000286#endif
287
dan0c547792013-07-18 17:12:08 +0000288/*
peter.d.reid60ec9142014-09-06 16:39:46 +0000289** Each auxiliary data pointer stored by a user defined function
dan0c547792013-07-18 17:12:08 +0000290** implementation calling sqlite3_set_auxdata() is stored in an instance
291** of this structure. All such structures associated with a single VM
292** are stored in a linked list headed at Vdbe.pAuxData. All are destroyed
293** when the VM is halted (if not before).
drh998da3a2004-06-19 15:22:56 +0000294*/
dan0c547792013-07-18 17:12:08 +0000295struct AuxData {
drhe6941392017-05-10 19:42:52 +0000296 int iAuxOp; /* Instruction number of OP_Function opcode */
297 int iAuxArg; /* Index of function argument. */
dan0c547792013-07-18 17:12:08 +0000298 void *pAux; /* Aux data pointer */
drhe6941392017-05-10 19:42:52 +0000299 void (*xDeleteAux)(void*); /* Destructor for the aux data */
300 AuxData *pNextAux; /* Next element in list */
danielk1977682f68b2004-06-05 10:22:17 +0000301};
danielk1977682f68b2004-06-05 10:22:17 +0000302
drh9a324642003-09-06 20:12:01 +0000303/*
peter.d.reid60ec9142014-09-06 16:39:46 +0000304** The "context" argument for an installable function. A pointer to an
drh9a324642003-09-06 20:12:01 +0000305** instance of this structure is the first argument to the routines used
306** implement the SQL functions.
307**
308** There is a typedef for this structure in sqlite.h. So all routines,
309** even the public interface to SQLite, can use a pointer to this structure.
310** But this file is the only place where the internal details of this
311** structure are known.
312**
drhabfcea22005-09-06 20:36:48 +0000313** This structure is defined inside of vdbeInt.h because it uses substructures
drh00706be2004-01-30 14:49:16 +0000314** (Mem) which are only defined there.
drh9a324642003-09-06 20:12:01 +0000315*/
danielk19770ae8b832004-05-25 12:05:56 +0000316struct sqlite3_context {
drh9c7c9132015-06-26 18:16:52 +0000317 Mem *pOut; /* The return value is stored here */
318 FuncDef *pFunc; /* Pointer to function information */
319 Mem *pMem; /* Memory cell used to store aggregate context */
320 Vdbe *pVdbe; /* The VM that owns this context */
321 int iOp; /* Instruction number of OP_Function */
322 int isError; /* Error code returned by the function. */
323 u8 skipFlag; /* Skip accumulator loading if true */
324 u8 fErrorOrAux; /* isError!=0 or pVdbe->pAuxData modified */
325 u8 argc; /* Number of arguments */
326 sqlite3_value *argv[1]; /* Argument set */
drh9a324642003-09-06 20:12:01 +0000327};
328
drh37f58e92012-09-04 21:34:26 +0000329/* A bitfield type for use inside of structures. Always follow with :N where
330** N is the number of bits.
331*/
332typedef unsigned bft; /* Bit Field Type */
333
dan037b5322014-11-03 11:25:32 +0000334typedef struct ScanStatus ScanStatus;
335struct ScanStatus {
dan6f9702e2014-11-01 20:38:06 +0000336 int addrExplain; /* OP_Explain for loop */
337 int addrLoop; /* Address of "loops" counter */
338 int addrVisit; /* Address of "rows visited" counter */
drhc6652b12014-11-06 04:42:20 +0000339 int iSelectID; /* The "Select-ID" for this loop */
drh518140e2014-11-06 03:55:10 +0000340 LogEst nEst; /* Estimated output rows per loop */
dan6f9702e2014-11-01 20:38:06 +0000341 char *zName; /* Name of table or index */
342};
343
drh7e02e5e2011-12-06 19:44:51 +0000344/*
drh9a324642003-09-06 20:12:01 +0000345** An instance of the virtual machine. This structure contains the complete
346** state of the virtual machine.
347**
drh2e5de2f2011-01-07 02:50:40 +0000348** The "sqlite3_stmt" structure pointer that is returned by sqlite3_prepare()
drh9a324642003-09-06 20:12:01 +0000349** is really a pointer to an instance of this structure.
350*/
351struct Vdbe {
drh8bfdf722009-06-19 14:06:03 +0000352 sqlite3 *db; /* The database connection that owns this statement */
drhab3182f2016-10-01 00:37:50 +0000353 Vdbe *pPrev,*pNext; /* Linked list of VDBEs with the same Vdbe.db */
354 Parse *pParse; /* Parsing context used to create this Vdbe */
355 ynVar nVar; /* Number of entries in aVar[] */
drhab3182f2016-10-01 00:37:50 +0000356 u32 magic; /* Magic number for sanity checking */
357 int nMem; /* Number of memory locations currently allocated */
358 int nCursor; /* Number of slots in apCsr[] */
359 u32 cacheCtr; /* VdbeCursor row cache generation counter */
360 int pc; /* The program counter */
361 int rc; /* Value to return */
362 int nChange; /* Number of db changes made since last reset */
363 int iStatement; /* Statement number (or 0 if has not opened stmt) */
364 i64 iCurrentTime; /* Value of julianday('now') for this statement */
365 i64 nFkConstraint; /* Number of imm. FK constraints this VM */
366 i64 nStmtDefCons; /* Number of def. constraints when stmt started */
367 i64 nStmtDefImmCons; /* Number of def. imm constraints when stmt started */
368
369 /* When allocating a new Vdbe object, all of the fields below should be
370 ** initialized to zero or NULL */
371
drh8bfdf722009-06-19 14:06:03 +0000372 Op *aOp; /* Space to hold the virtual machine's program */
drh2e5de2f2011-01-07 02:50:40 +0000373 Mem *aMem; /* The memory locations */
drh8bfdf722009-06-19 14:06:03 +0000374 Mem **apArg; /* Arguments to currently executing user function */
375 Mem *aColName; /* Column names to return */
376 Mem *pResultSet; /* Pointer to an array of results */
drh2e5de2f2011-01-07 02:50:40 +0000377 char *zErrMsg; /* Error message written here */
drh8bfdf722009-06-19 14:06:03 +0000378 VdbeCursor **apCsr; /* One element of this array for each open cursor */
drh8bfdf722009-06-19 14:06:03 +0000379 Mem *aVar; /* Values for the OP_Variable opcode. */
drh9bf755c2016-12-23 03:59:31 +0000380 VList *pVList; /* Name of variables */
drhab3182f2016-10-01 00:37:50 +0000381#ifndef SQLITE_OMIT_TRACE
382 i64 startTime; /* Time when query started - used for profiling */
383#endif
384 int nOp; /* Number of instructions in the program */
drh983b5ee2015-02-13 12:05:56 +0000385#ifdef SQLITE_DEBUG
386 int rcApp; /* errcode set by sqlite3_result_error_code() */
387#endif
drh73d5b8f2013-12-23 19:09:07 +0000388 u16 nResColumn; /* Number of columns in one row of the result set */
drh2e5de2f2011-01-07 02:50:40 +0000389 u8 errorAction; /* Recovery action to do in case of an error */
drhab3182f2016-10-01 00:37:50 +0000390 u8 minWriteFileFormat; /* Minimum file format for writable database files */
drh2c2f3922017-06-01 00:54:35 +0000391 u8 prepFlags; /* SQLITE_PREPARE_* flags */
drhc5db1d42016-03-16 00:36:19 +0000392 bft expired:1; /* True if the VM needs to be recompiled */
393 bft doingRerun:1; /* True if rerunning after an auto-reprepare */
drh37f58e92012-09-04 21:34:26 +0000394 bft explain:2; /* True if EXPLAIN present on SQL command */
drh37f58e92012-09-04 21:34:26 +0000395 bft changeCntOn:1; /* True to update the change-counter */
drh37f58e92012-09-04 21:34:26 +0000396 bft runOnlyOnce:1; /* Automatically expire on reset */
397 bft usesStmtJournal:1; /* True if uses a statement journal */
drh9e92a472013-06-27 17:40:30 +0000398 bft readOnly:1; /* True for statements that do not write */
drh1713afb2013-06-28 01:24:57 +0000399 bft bIsReader:1; /* True for statements that read */
drh64123582011-04-02 20:01:02 +0000400 yDbMask btreeMask; /* Bitmask of db->aDb[] entries referenced */
drhdc5b0472011-04-06 22:05:53 +0000401 yDbMask lockMask; /* Subset of btreeMask that requires a lock */
drh00d11d42017-06-29 12:49:18 +0000402 u32 aCounter[7]; /* Counters used by sqlite3_stmt_status() */
drh2e5de2f2011-01-07 02:50:40 +0000403 char *zSql; /* Text of the SQL statement that generated this */
404 void *pFree; /* Free this when deleting the vdbe */
dan165921a2009-08-28 18:53:45 +0000405 VdbeFrame *pFrame; /* Parent frame */
dan27106572010-12-01 08:04:47 +0000406 VdbeFrame *pDelFrame; /* List of frame objects to free on VM reset */
dan165921a2009-08-28 18:53:45 +0000407 int nFrame; /* Number of frames in pFrame list */
dan937d0de2009-10-15 18:35:38 +0000408 u32 expmask; /* Binding to these vars invalidates VM */
dand19c9332010-07-26 12:05:17 +0000409 SubProgram *pProgram; /* Linked list of all sub-programs used by VM */
dan0c547792013-07-18 17:12:08 +0000410 AuxData *pAuxData; /* Linked list of auxdata allocations */
dan6f9702e2014-11-01 20:38:06 +0000411#ifdef SQLITE_ENABLE_STMT_SCANSTATUS
412 i64 *anExec; /* Number of times each op has been executed */
413 int nScan; /* Entries in aScan[] */
dan037b5322014-11-03 11:25:32 +0000414 ScanStatus *aScan; /* Scan definitions for sqlite3_stmt_scanstatus() */
dan6f9702e2014-11-01 20:38:06 +0000415#endif
drh9a324642003-09-06 20:12:01 +0000416};
417
418/*
419** The following are allowed values for Vdbe.magic
420*/
drhab3182f2016-10-01 00:37:50 +0000421#define VDBE_MAGIC_INIT 0x16bceaa5 /* Building a VDBE program */
422#define VDBE_MAGIC_RUN 0x2df20da3 /* VDBE is ready to execute */
423#define VDBE_MAGIC_HALT 0x319c2973 /* VDBE has completed execution */
424#define VDBE_MAGIC_RESET 0x48fa9f76 /* Reset and ready to run again */
425#define VDBE_MAGIC_DEAD 0x5606c3c8 /* The VDBE has been deallocated */
drh9a324642003-09-06 20:12:01 +0000426
427/*
dan46c47d42011-03-01 18:42:07 +0000428** Structure used to store the context required by the
429** sqlite3_preupdate_*() API functions.
430*/
431struct PreUpdate {
dan37db03b2011-03-16 19:59:18 +0000432 Vdbe *v;
dan46c47d42011-03-01 18:42:07 +0000433 VdbeCursor *pCsr; /* Cursor to read old values from */
434 int op; /* One of SQLITE_INSERT, UPDATE, DELETE */
435 u8 *aRecord; /* old.* database record */
dan4fccf432011-03-08 19:22:50 +0000436 KeyInfo keyinfo;
dan46c47d42011-03-01 18:42:07 +0000437 UnpackedRecord *pUnpacked; /* Unpacked version of aRecord[] */
dan37db03b2011-03-16 19:59:18 +0000438 UnpackedRecord *pNewUnpacked; /* Unpacked version of new.* record */
439 int iNewReg; /* Register for new.* values */
dan319eeb72011-03-19 08:38:50 +0000440 i64 iKey1; /* First key value passed to hook */
441 i64 iKey2; /* Second key value passed to hook */
dan37db03b2011-03-16 19:59:18 +0000442 Mem *aNew; /* Array of new.* values */
dane43635a2016-10-21 21:21:45 +0000443 Table *pTab; /* Schema object being upated */
dancb9a3642017-01-30 19:44:53 +0000444 Index *pPk; /* PK index if pTab is WITHOUT ROWID */
dan46c47d42011-03-01 18:42:07 +0000445};
446
447/*
drh9a324642003-09-06 20:12:01 +0000448** Function prototypes
449*/
drh22c17b82015-05-15 04:13:15 +0000450void sqlite3VdbeError(Vdbe*, const char *, ...);
drhdfe88ec2008-11-03 20:55:06 +0000451void sqlite3VdbeFreeCursor(Vdbe *, VdbeCursor*);
drh9a324642003-09-06 20:12:01 +0000452void sqliteVdbePopStack(Vdbe*,int);
dande892d92016-01-29 19:29:45 +0000453int sqlite3VdbeCursorMoveto(VdbeCursor**, int*);
drhc22284f2014-10-13 16:02:20 +0000454int sqlite3VdbeCursorRestore(VdbeCursor*);
danielk19778b60e0f2005-01-12 09:10:39 +0000455#if defined(SQLITE_DEBUG) || defined(VDBE_PROFILE)
danielk19774adee202004-05-08 08:23:19 +0000456void sqlite3VdbePrintOp(FILE*, int, Op*);
drh9a324642003-09-06 20:12:01 +0000457#endif
drh35cd6432009-06-05 14:17:21 +0000458u32 sqlite3VdbeSerialTypeLen(u32);
drhfaf37272015-10-16 14:23:42 +0000459u8 sqlite3VdbeOneByteSerialTypeLen(u8);
drhbe37c122015-10-16 14:54:17 +0000460u32 sqlite3VdbeSerialType(Mem*, int, u32*);
drha9ab4812013-12-11 11:00:44 +0000461u32 sqlite3VdbeSerialPut(unsigned char*, Mem*, u32);
drh35cd6432009-06-05 14:17:21 +0000462u32 sqlite3VdbeSerialGet(const unsigned char*, u32, Mem*);
drhb9626cf2016-02-22 16:04:31 +0000463void sqlite3VdbeDeleteAuxData(sqlite3*, AuxData**, int, int);
danielk19774adee202004-05-08 08:23:19 +0000464
danielk1977189621d2004-05-09 23:23:56 +0000465int sqlite2BtreeKeyCompare(BtCursor *, const void *, int, int, int *);
drhd3b74202014-09-17 16:41:15 +0000466int sqlite3VdbeIdxKeyCompare(sqlite3*,VdbeCursor*,UnpackedRecord*,int*);
467int sqlite3VdbeIdxRowid(sqlite3*, BtCursor*, i64*);
danielk1977106bb232004-05-21 10:08:53 +0000468int sqlite3VdbeExec(Vdbe*);
469int sqlite3VdbeList(Vdbe*);
drh92f02c32004-09-02 14:57:08 +0000470int sqlite3VdbeHalt(Vdbe*);
drhb21c8cd2007-08-21 19:33:56 +0000471int sqlite3VdbeChangeEncoding(Mem *, int);
drh023ae032007-05-08 12:12:16 +0000472int sqlite3VdbeMemTooBig(Mem*);
drhb21c8cd2007-08-21 19:33:56 +0000473int sqlite3VdbeMemCopy(Mem*, const Mem*);
drhfebe1062004-08-28 18:17:48 +0000474void sqlite3VdbeMemShallowCopy(Mem*, const Mem*, int);
drh643167f2008-01-22 21:30:53 +0000475void sqlite3VdbeMemMove(Mem*, Mem*);
drhb21c8cd2007-08-21 19:33:56 +0000476int sqlite3VdbeMemNulTerminate(Mem*);
477int sqlite3VdbeMemSetStr(Mem*, const char*, int, u8, void(*)(void*));
drhefad9992004-06-22 12:13:55 +0000478void sqlite3VdbeMemSetInt64(Mem*, i64);
drh7ec5ea92010-01-13 00:04:13 +0000479#ifdef SQLITE_OMIT_FLOATING_POINT
480# define sqlite3VdbeMemSetDouble sqlite3VdbeMemSetInt64
481#else
482 void sqlite3VdbeMemSetDouble(Mem*, double);
483#endif
drh22930062017-07-27 03:48:02 +0000484void sqlite3VdbeMemSetPointer(Mem*, void*, const char*, void(*)(void*));
drhd3b74202014-09-17 16:41:15 +0000485void sqlite3VdbeMemInit(Mem*,sqlite3*,u16);
drhf4479502004-05-27 03:12:53 +0000486void sqlite3VdbeMemSetNull(Mem*);
drhb026e052007-05-02 01:34:31 +0000487void sqlite3VdbeMemSetZeroBlob(Mem*,int);
drh3d4501e2008-12-04 20:40:10 +0000488void sqlite3VdbeMemSetRowSet(Mem*);
drhb21c8cd2007-08-21 19:33:56 +0000489int sqlite3VdbeMemMakeWriteable(Mem*);
drhbd9507c2014-08-23 17:21:37 +0000490int sqlite3VdbeMemStringify(Mem*, u8, u8);
drh6a6124e2004-06-27 01:56:33 +0000491i64 sqlite3VdbeIntValue(Mem*);
drheb2e1762004-05-27 01:53:56 +0000492int sqlite3VdbeMemIntegerify(Mem*);
drh6a6124e2004-06-27 01:56:33 +0000493double sqlite3VdbeRealValue(Mem*);
drh8df447f2005-11-01 15:48:24 +0000494void sqlite3VdbeIntegerAffinity(Mem*);
drheb2e1762004-05-27 01:53:56 +0000495int sqlite3VdbeMemRealify(Mem*);
drh8a512562005-11-14 22:29:05 +0000496int sqlite3VdbeMemNumerify(Mem*);
drh4169e432014-08-25 20:11:52 +0000497void sqlite3VdbeMemCast(Mem*,u8,u8);
drhcb3cabd2016-11-25 19:18:28 +0000498int sqlite3VdbeMemFromBtree(BtCursor*,u32,u32,Mem*);
danielk1977d8123362004-06-12 09:25:12 +0000499void sqlite3VdbeMemRelease(Mem *p);
drh90669c12006-01-20 15:45:36 +0000500int sqlite3VdbeMemFinalize(Mem*, FuncDef*);
drh46c99e02007-08-27 23:26:59 +0000501const char *sqlite3OpcodeName(int);
danielk1977a7a8e142008-02-13 18:25:27 +0000502int sqlite3VdbeMemGrow(Mem *pMem, int n, int preserve);
drh322f2852014-09-19 00:43:39 +0000503int sqlite3VdbeMemClearAndResize(Mem *pMem, int n);
danielk1977bd434552009-03-18 10:33:00 +0000504int sqlite3VdbeCloseStatement(Vdbe *, int);
dan165921a2009-08-28 18:53:45 +0000505void sqlite3VdbeFrameDelete(VdbeFrame*);
506int sqlite3VdbeFrameRestore(VdbeFrame *);
drh74c33022016-03-30 12:56:55 +0000507#ifdef SQLITE_ENABLE_PREUPDATE_HOOK
508void sqlite3VdbePreUpdateHook(Vdbe*,VdbeCursor*,int,const char*,Table*,i64,int);
509#endif
dan029ead62011-10-27 15:19:58 +0000510int sqlite3VdbeTransferError(Vdbe *p);
drhe54e0512011-04-05 17:31:56 +0000511
danfad9f9a2014-04-01 18:41:51 +0000512int sqlite3VdbeSorterInit(sqlite3 *, int, VdbeCursor *);
drh65ea12c2014-03-19 17:41:36 +0000513void sqlite3VdbeSorterReset(sqlite3 *, VdbeSorter *);
dana20fde62011-07-12 14:28:05 +0000514void sqlite3VdbeSorterClose(sqlite3 *, VdbeCursor *);
drhc041c162012-07-24 19:46:38 +0000515int sqlite3VdbeSorterRowkey(const VdbeCursor *, Mem *);
drh2ab792e2017-05-30 18:34:07 +0000516int sqlite3VdbeSorterNext(sqlite3 *, const VdbeCursor *);
drh958d2612014-04-18 13:40:07 +0000517int sqlite3VdbeSorterRewind(const VdbeCursor *, int *);
518int sqlite3VdbeSorterWrite(const VdbeCursor *, Mem *);
drh1153c7b2013-11-01 22:02:56 +0000519int sqlite3VdbeSorterCompare(const VdbeCursor *, Mem *, int, int *);
dan7fe62702011-08-02 10:56:22 +0000520
dan20d876f2016-01-07 16:06:22 +0000521#if !defined(SQLITE_OMIT_SHARED_CACHE)
drhe54e0512011-04-05 17:31:56 +0000522 void sqlite3VdbeEnter(Vdbe*);
drhe54e0512011-04-05 17:31:56 +0000523#else
524# define sqlite3VdbeEnter(X)
dan20d876f2016-01-07 16:06:22 +0000525#endif
526
527#if !defined(SQLITE_OMIT_SHARED_CACHE) && SQLITE_THREADSAFE>0
528 void sqlite3VdbeLeave(Vdbe*);
529#else
drhe54e0512011-04-05 17:31:56 +0000530# define sqlite3VdbeLeave(X)
531#endif
drh46c99e02007-08-27 23:26:59 +0000532
drh2b4ded92010-09-27 21:09:31 +0000533#ifdef SQLITE_DEBUG
drhe4c88c02012-01-04 12:57:45 +0000534void sqlite3VdbeMemAboutToChange(Vdbe*,Mem*);
drh75fd0542014-03-01 16:24:44 +0000535int sqlite3VdbeCheckMemInvariants(Mem*);
drh2b4ded92010-09-27 21:09:31 +0000536#endif
537
dan1da40a32009-09-19 17:00:31 +0000538#ifndef SQLITE_OMIT_FOREIGN_KEY
dan8a2fff72009-09-23 18:07:22 +0000539int sqlite3VdbeCheckFk(Vdbe *, int);
dan1da40a32009-09-19 17:00:31 +0000540#else
dan8a2fff72009-09-23 18:07:22 +0000541# define sqlite3VdbeCheckFk(p,i) 0
dan1da40a32009-09-19 17:00:31 +0000542#endif
543
drh87cc3b32007-05-08 21:45:27 +0000544#ifdef SQLITE_DEBUG
545 void sqlite3VdbePrintSql(Vdbe*);
546 void sqlite3VdbeMemPrettyPrint(Mem *pMem, char *zBuf);
547#endif
drhf0f44b72017-07-12 12:19:33 +0000548#ifndef SQLITE_OMIT_UTF16
549 int sqlite3VdbeMemTranslate(Mem*, u8);
550 int sqlite3VdbeMemHandleBom(Mem *pMem);
551#endif
drh4e78be62007-01-26 21:08:04 +0000552
danielk1977246ad312007-05-16 14:23:00 +0000553#ifndef SQLITE_OMIT_INCRBLOB
drhb21c8cd2007-08-21 19:33:56 +0000554 int sqlite3VdbeMemExpandBlob(Mem *);
drh45d29302012-01-08 22:18:33 +0000555 #define ExpandBlob(P) (((P)->flags&MEM_Zero)?sqlite3VdbeMemExpandBlob(P):0)
danielk1977246ad312007-05-16 14:23:00 +0000556#else
drhb21c8cd2007-08-21 19:33:56 +0000557 #define sqlite3VdbeMemExpandBlob(x) SQLITE_OK
drh45d29302012-01-08 22:18:33 +0000558 #define ExpandBlob(P) SQLITE_OK
danielk1977246ad312007-05-16 14:23:00 +0000559#endif
560
drh43f58d62016-07-09 16:14:45 +0000561#endif /* !defined(SQLITE_VDBEINT_H) */