blob: 651810d4a4b75da6ede2f4a04d50107fd3f6c401 [file] [log] [blame]
drh75897232000-05-29 14:26:00 +00001/*
drhb19a2bc2001-09-16 00:13:26 +00002** 2001 September 15
drh75897232000-05-29 14:26:00 +00003**
drhb19a2bc2001-09-16 00:13:26 +00004** The author disclaims copyright to this source code. In place of
5** a legal notice, here is a blessing:
drh75897232000-05-29 14:26:00 +00006**
drhb19a2bc2001-09-16 00:13:26 +00007** 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.
drh75897232000-05-29 14:26:00 +000010**
11*************************************************************************
12** Header file for the Virtual DataBase Engine (VDBE)
13**
14** This header defines the interface to the virtual database engine
15** or VDBE. The VDBE implements an abstract machine that runs a
16** simple program to access and modify the underlying database.
drh75897232000-05-29 14:26:00 +000017*/
drh43f58d62016-07-09 16:14:45 +000018#ifndef SQLITE_VDBE_H
19#define SQLITE_VDBE_H
drh75897232000-05-29 14:26:00 +000020#include <stdio.h>
21
22/*
23** A single VDBE is an opaque structure named "Vdbe". Only routines
24** in the source file sqliteVdbe.c are allowed to see the insides
25** of this structure.
26*/
27typedef struct Vdbe Vdbe;
28
29/*
danielk19772dca4ac2008-01-03 11:50:29 +000030** The names of the following types declared in vdbeInt.h are required
31** for the VdbeOp definition.
32*/
drh7a6ea932017-04-09 19:23:55 +000033typedef struct sqlite3_value Mem;
dan165921a2009-08-28 18:53:45 +000034typedef struct SubProgram SubProgram;
danielk19772dca4ac2008-01-03 11:50:29 +000035
36/*
drh75897232000-05-29 14:26:00 +000037** A single instruction of the virtual machine has an opcode
38** and as many as three operands. The instruction is recorded
39** as an instance of the following structure:
40*/
41struct VdbeOp {
drh905793e2004-02-21 13:31:09 +000042 u8 opcode; /* What operation to perform */
drhc9206282008-01-09 18:31:45 +000043 signed char p4type; /* One of the P4_xxx constants for p4 */
drh585ce192017-01-25 14:58:27 +000044 u16 p5; /* Fifth parameter is an unsigned 16-bit integer */
drh75897232000-05-29 14:26:00 +000045 int p1; /* First operand */
46 int p2; /* Second parameter (often the jump destination) */
drh66a51672008-01-03 00:01:23 +000047 int p3; /* The third parameter */
drh9c7c9132015-06-26 18:16:52 +000048 union p4union { /* fourth parameter */
danielk19772dca4ac2008-01-03 11:50:29 +000049 int i; /* Integer value if p4type==P4_INT32 */
50 void *p; /* Generic pointer */
51 char *z; /* Pointer to data for string (char array) types */
52 i64 *pI64; /* Used when p4type is P4_INT64 */
53 double *pReal; /* Used when p4type is P4_REAL */
54 FuncDef *pFunc; /* Used when p4type is P4_FUNCDEF */
drh9c7c9132015-06-26 18:16:52 +000055 sqlite3_context *pCtx; /* Used when p4type is P4_FUNCCTX */
danielk19772dca4ac2008-01-03 11:50:29 +000056 CollSeq *pColl; /* Used when p4type is P4_COLLSEQ */
57 Mem *pMem; /* Used when p4type is P4_MEM */
danielk1977595a5232009-07-24 17:58:53 +000058 VTable *pVtab; /* Used when p4type is P4_VTAB */
danielk19772dca4ac2008-01-03 11:50:29 +000059 KeyInfo *pKeyInfo; /* Used when p4type is P4_KEYINFO */
drh0acb7e42008-06-25 00:12:41 +000060 int *ai; /* Used when p4type is P4_INTARRAY */
dan165921a2009-08-28 18:53:45 +000061 SubProgram *pProgram; /* Used when p4type is P4_SUBPROGRAM */
dan319eeb72011-03-19 08:38:50 +000062 Table *pTab; /* Used when p4type is P4_TABLE */
drh28935362013-12-07 20:39:19 +000063#ifdef SQLITE_ENABLE_CURSOR_HINTS
64 Expr *pExpr; /* Used when p4type is P4_EXPR */
65#endif
dana205a482011-08-27 18:48:57 +000066 int (*xAdvance)(BtCursor *, int *);
drh66a51672008-01-03 00:01:23 +000067 } p4;
drhc7379ce2013-10-30 02:28:23 +000068#ifdef SQLITE_ENABLE_EXPLAIN_COMMENTS
shane9bcbdad2008-05-29 20:22:37 +000069 char *zComment; /* Comment to improve readability */
drhd4e70eb2008-01-02 00:34:36 +000070#endif
drh7b396862003-01-01 23:06:20 +000071#ifdef VDBE_PROFILE
drh15ab9412014-02-24 14:24:01 +000072 u32 cnt; /* Number of times this instruction was executed */
shane9bcbdad2008-05-29 20:22:37 +000073 u64 cycles; /* Total time spent executing this instruction */
drh7b396862003-01-01 23:06:20 +000074#endif
drh688852a2014-02-17 22:40:43 +000075#ifdef SQLITE_VDBE_COVERAGE
76 int iSrcLine; /* Source-code line that generated this opcode */
77#endif
drh75897232000-05-29 14:26:00 +000078};
79typedef struct VdbeOp VdbeOp;
80
dan165921a2009-08-28 18:53:45 +000081
82/*
83** A sub-routine used to implement a trigger program.
84*/
85struct SubProgram {
86 VdbeOp *aOp; /* Array of opcodes for sub-program */
87 int nOp; /* Elements in aOp[] */
88 int nMem; /* Number of memory cells required */
89 int nCsr; /* Number of cursors required */
drhab087d42017-03-24 17:59:56 +000090 u8 *aOnce; /* Array of OP_Once flags */
dan165921a2009-08-28 18:53:45 +000091 void *token; /* id that may be used to recursive triggers */
dand46def72010-07-24 11:28:28 +000092 SubProgram *pNext; /* Next sub-program already visited */
dan165921a2009-08-28 18:53:45 +000093};
94
drh75897232000-05-29 14:26:00 +000095/*
drh905793e2004-02-21 13:31:09 +000096** A smaller version of VdbeOp used for the VdbeAddOpList() function because
97** it takes up less space.
98*/
99struct VdbeOpList {
100 u8 opcode; /* What operation to perform */
101 signed char p1; /* First operand */
drh24003452008-01-03 01:28:59 +0000102 signed char p2; /* Second parameter (often the jump destination) */
103 signed char p3; /* Third parameter */
drh905793e2004-02-21 13:31:09 +0000104};
105typedef struct VdbeOpList VdbeOpList;
106
107/*
dan165921a2009-08-28 18:53:45 +0000108** Allowed values of VdbeOp.p4type
drh99fcd712001-10-13 01:06:47 +0000109*/
drh66a51672008-01-03 00:01:23 +0000110#define P4_NOTUSED 0 /* The P4 parameter is not used */
111#define P4_DYNAMIC (-1) /* Pointer to a string obtained from sqliteMalloc() */
112#define P4_STATIC (-2) /* Pointer to a static string */
drh861b1302016-12-07 20:22:31 +0000113#define P4_COLLSEQ (-3) /* P4 is a pointer to a CollSeq structure */
114#define P4_FUNCDEF (-4) /* P4 is a pointer to a FuncDef structure */
115#define P4_KEYINFO (-5) /* P4 is a pointer to a KeyInfo structure */
116#define P4_EXPR (-6) /* P4 is a pointer to an Expr tree */
117#define P4_MEM (-7) /* P4 is a pointer to a Mem* structure */
drh8d129422011-04-05 12:25:19 +0000118#define P4_TRANSIENT 0 /* P4 is a pointer to a transient string */
drh861b1302016-12-07 20:22:31 +0000119#define P4_VTAB (-8) /* P4 is a pointer to an sqlite3_vtab structure */
120#define P4_REAL (-9) /* P4 is a 64-bit floating point value */
121#define P4_INT64 (-10) /* P4 is a 64-bit signed integer */
122#define P4_INT32 (-11) /* P4 is a 32-bit signed integer */
123#define P4_INTARRAY (-12) /* P4 is a vector of 32-bit integers */
124#define P4_SUBPROGRAM (-13) /* P4 is a pointer to a SubProgram structure */
125#define P4_ADVANCE (-14) /* P4 is a pointer to BtreeNext() or BtreePrev() */
126#define P4_TABLE (-15) /* P4 is a pointer to a Table structure */
127#define P4_FUNCCTX (-16) /* P4 is a pointer to an sqlite3_context object */
drh99fcd712001-10-13 01:06:47 +0000128
drhf9c8ce32013-11-05 13:33:55 +0000129/* Error message codes for OP_Halt */
130#define P5_ConstraintNotNull 1
131#define P5_ConstraintUnique 2
132#define P5_ConstraintCheck 3
133#define P5_ConstraintFK 4
drhffbc3082004-05-21 01:29:06 +0000134
drh99fcd712001-10-13 01:06:47 +0000135/*
danielk1977955de522006-02-10 02:27:42 +0000136** The Vdbe.aColName array contains 5n Mem structures, where n is the
137** number of columns of data returned by the statement.
138*/
139#define COLNAME_NAME 0
140#define COLNAME_DECLTYPE 1
141#define COLNAME_DATABASE 2
142#define COLNAME_TABLE 3
143#define COLNAME_COLUMN 4
drh3f913572008-03-22 01:07:17 +0000144#ifdef SQLITE_ENABLE_COLUMN_METADATA
145# define COLNAME_N 5 /* Number of COLNAME_xxx symbols */
146#else
147# ifdef SQLITE_OMIT_DECLTYPE
148# define COLNAME_N 1 /* Store only the name */
149# else
150# define COLNAME_N 2 /* Store the name and decltype */
151# endif
152#endif
danielk1977955de522006-02-10 02:27:42 +0000153
154/*
drh75897232000-05-29 14:26:00 +0000155** The following macro converts a relative address in the p2 field
156** of a VdbeOp structure into a negative number so that
danielk19774adee202004-05-08 08:23:19 +0000157** sqlite3VdbeAddOpList() knows that the address is relative. Calling
drh75897232000-05-29 14:26:00 +0000158** the macro again restores the address.
159*/
160#define ADDR(X) (-1-(X))
161
162/*
drh8f619cc2002-09-08 00:04:50 +0000163** The makefile scans the vdbe.c source file and creates the "opcodes.h"
164** header file that defines a number for each opcode used by the VDBE.
drh75897232000-05-29 14:26:00 +0000165*/
drh8f619cc2002-09-08 00:04:50 +0000166#include "opcodes.h"
drh75897232000-05-29 14:26:00 +0000167
168/*
169** Prototypes for the VDBE interface. See comments on the implementation
170** for a description of what each of these routines does.
171*/
drh9ac79622013-12-18 15:11:47 +0000172Vdbe *sqlite3VdbeCreate(Parse*);
drh66a51672008-01-03 00:01:23 +0000173int sqlite3VdbeAddOp0(Vdbe*,int);
174int sqlite3VdbeAddOp1(Vdbe*,int,int);
175int sqlite3VdbeAddOp2(Vdbe*,int,int,int);
drh076e85f2015-09-03 13:46:12 +0000176int sqlite3VdbeGoto(Vdbe*,int);
177int sqlite3VdbeLoadString(Vdbe*,int,const char*);
178void sqlite3VdbeMultiLoad(Vdbe*,int,const char*,...);
drh66a51672008-01-03 00:01:23 +0000179int sqlite3VdbeAddOp3(Vdbe*,int,int,int,int);
180int sqlite3VdbeAddOp4(Vdbe*,int,int,int,int,const char *zP4,int);
drh97bae792015-06-05 15:59:57 +0000181int sqlite3VdbeAddOp4Dup8(Vdbe*,int,int,int,int,const u8*,int);
drh8cff69d2009-11-12 19:59:44 +0000182int sqlite3VdbeAddOp4Int(Vdbe*,int,int,int,int,int);
drh2fade2f2016-02-09 02:12:20 +0000183void sqlite3VdbeEndCoroutine(Vdbe*,int);
drhdad300d2016-01-18 00:20:26 +0000184#if defined(SQLITE_DEBUG) && !defined(SQLITE_TEST_REALLOC_STRESS)
185 void sqlite3VdbeVerifyNoMallocRequired(Vdbe *p, int N);
dan9e1ab1a2017-01-05 19:32:48 +0000186 void sqlite3VdbeVerifyNoResultRow(Vdbe *p);
drh2ce18652016-01-16 20:50:21 +0000187#else
drhdad300d2016-01-18 00:20:26 +0000188# define sqlite3VdbeVerifyNoMallocRequired(A,B)
dan9e1ab1a2017-01-05 19:32:48 +0000189# define sqlite3VdbeVerifyNoResultRow(A)
drh2ce18652016-01-16 20:50:21 +0000190#endif
191VdbeOp *sqlite3VdbeAddOpList(Vdbe*, int nOp, VdbeOpList const *aOp, int iLineno);
drh5d9c9da2011-06-03 20:11:17 +0000192void sqlite3VdbeAddParseSchemaOp(Vdbe*,int,char*);
drh0ff287f2015-09-02 18:40:33 +0000193void sqlite3VdbeChangeOpcode(Vdbe*, u32 addr, u8);
drh88caeac2011-08-24 15:12:08 +0000194void sqlite3VdbeChangeP1(Vdbe*, u32 addr, int P1);
195void sqlite3VdbeChangeP2(Vdbe*, u32 addr, int P2);
196void sqlite3VdbeChangeP3(Vdbe*, u32 addr, int P3);
drh585ce192017-01-25 14:58:27 +0000197void sqlite3VdbeChangeP5(Vdbe*, u16 P5);
drhd654be82005-09-20 17:42:23 +0000198void sqlite3VdbeJumpHere(Vdbe*, int addr);
drh2ce18652016-01-16 20:50:21 +0000199int sqlite3VdbeChangeToNoop(Vdbe*, int addr);
drh61019c72014-01-04 16:49:02 +0000200int sqlite3VdbeDeletePriorOpcode(Vdbe*, u8 op);
drh66a51672008-01-03 00:01:23 +0000201void sqlite3VdbeChangeP4(Vdbe*, int addr, const char *zP4, int N);
drhf14b7fb2016-12-07 21:35:55 +0000202void sqlite3VdbeAppendP4(Vdbe*, void *pP4, int p4type);
drh2ec2fb22013-11-06 19:59:23 +0000203void sqlite3VdbeSetP4KeyInfo(Parse*, Index*);
drhfb982642007-08-30 01:19:59 +0000204void sqlite3VdbeUsesBtree(Vdbe*, int);
danielk19774adee202004-05-08 08:23:19 +0000205VdbeOp *sqlite3VdbeGetOp(Vdbe*, int);
206int sqlite3VdbeMakeLabel(Vdbe*);
drh4611d922010-02-25 14:47:01 +0000207void sqlite3VdbeRunOnlyOnce(Vdbe*);
drhf71a3662016-03-16 20:44:45 +0000208void sqlite3VdbeReusable(Vdbe*);
danielk19774adee202004-05-08 08:23:19 +0000209void sqlite3VdbeDelete(Vdbe*);
drhcb103b92012-10-26 00:11:23 +0000210void sqlite3VdbeClearObject(sqlite3*,Vdbe*);
drh124c0b42011-06-01 18:15:55 +0000211void sqlite3VdbeMakeReady(Vdbe*,Parse*);
danielk19779e6db7d2004-06-21 08:18:51 +0000212int sqlite3VdbeFinalize(Vdbe*);
danielk19774adee202004-05-08 08:23:19 +0000213void sqlite3VdbeResolveLabel(Vdbe*, int);
214int sqlite3VdbeCurrentAddr(Vdbe*);
drh87cc3b32007-05-08 21:45:27 +0000215#ifdef SQLITE_DEBUG
danf3677212009-09-10 16:14:50 +0000216 int sqlite3VdbeAssertMayAbort(Vdbe *, int);
drh87cc3b32007-05-08 21:45:27 +0000217#endif
drh3c23a882007-01-09 14:01:13 +0000218void sqlite3VdbeResetStepResult(Vdbe*);
drh124c0b42011-06-01 18:15:55 +0000219void sqlite3VdbeRewind(Vdbe*);
drhc890fec2008-08-01 20:10:08 +0000220int sqlite3VdbeReset(Vdbe*);
danielk197722322fd2004-05-25 23:35:17 +0000221void sqlite3VdbeSetNumCols(Vdbe*,int);
danielk197710fb7492008-10-31 10:53:22 +0000222int sqlite3VdbeSetColName(Vdbe*, int, int, const char *, void(*)(void*));
danielk1977b28af712004-06-21 06:50:26 +0000223void sqlite3VdbeCountChanges(Vdbe*);
danielk1977aee18ef2005-03-09 12:26:50 +0000224sqlite3 *sqlite3VdbeDb(Vdbe*);
danielk19776ab3a2e2009-02-19 14:39:25 +0000225void sqlite3VdbeSetSql(Vdbe*, const char *z, int n, int);
drhc5155252007-01-08 21:07:17 +0000226void sqlite3VdbeSwap(Vdbe*,Vdbe*);
dan165921a2009-08-28 18:53:45 +0000227VdbeOp *sqlite3VdbeTakeOpArray(Vdbe*, int*, int*);
drhcf0fd4a2013-08-01 12:21:58 +0000228sqlite3_value *sqlite3VdbeGetBoundValue(Vdbe*, int, u8);
dan1d2ce4f2009-10-19 18:11:09 +0000229void sqlite3VdbeSetVarmask(Vdbe*, int);
drhc7bc4fd2009-11-25 18:03:42 +0000230#ifndef SQLITE_OMIT_TRACE
231 char *sqlite3VdbeExpandSql(Vdbe*, const char*);
232#endif
drh3eddb232014-06-28 14:28:06 +0000233int sqlite3MemCompare(const Mem*, const Mem*, const CollSeq*);
drh75897232000-05-29 14:26:00 +0000234
dan03e9cfc2011-09-05 14:20:27 +0000235void sqlite3VdbeRecordUnpack(KeyInfo*,int,const void*,UnpackedRecord*);
drh75179de2014-09-16 14:37:35 +0000236int sqlite3VdbeRecordCompare(int,const void*,UnpackedRecord*);
dan7004f3f2015-03-30 12:06:26 +0000237int sqlite3VdbeRecordCompareWithSkip(int, const void *, UnpackedRecord *, int);
drha582b012016-12-21 19:45:54 +0000238UnpackedRecord *sqlite3VdbeAllocUnpackedRecord(KeyInfo*);
drh1e968a02008-03-25 00:22:21 +0000239
drh75179de2014-09-16 14:37:35 +0000240typedef int (*RecordCompare)(int,const void*,UnpackedRecord*);
dan3b9330f2014-02-27 20:44:18 +0000241RecordCompare sqlite3VdbeFindCompare(UnpackedRecord*);
dan1fed5da2014-02-25 21:01:25 +0000242
dand19c9332010-07-26 12:05:17 +0000243#ifndef SQLITE_OMIT_TRIGGER
244void sqlite3VdbeLinkSubProgram(Vdbe *, SubProgram *);
245#endif
246
drh72ffd092013-10-30 15:52:32 +0000247/* Use SQLITE_ENABLE_COMMENTS to enable generation of extra comments on
248** each VDBE opcode.
249**
250** Use the SQLITE_ENABLE_MODULE_COMMENTS macro to see some extra no-op
251** comments in VDBE programs that show key decision points in the code
252** generator.
253*/
drhc7379ce2013-10-30 02:28:23 +0000254#ifdef SQLITE_ENABLE_EXPLAIN_COMMENTS
drhd3d39e92004-05-20 22:16:29 +0000255 void sqlite3VdbeComment(Vdbe*, const char*, ...);
256# define VdbeComment(X) sqlite3VdbeComment X
drh16ee60f2008-06-20 18:13:25 +0000257 void sqlite3VdbeNoopComment(Vdbe*, const char*, ...);
258# define VdbeNoopComment(X) sqlite3VdbeNoopComment X
drh72ffd092013-10-30 15:52:32 +0000259# ifdef SQLITE_ENABLE_MODULE_COMMENTS
260# define VdbeModuleComment(X) sqlite3VdbeNoopComment X
261# else
262# define VdbeModuleComment(X)
263# endif
drhd3d39e92004-05-20 22:16:29 +0000264#else
265# define VdbeComment(X)
drh16ee60f2008-06-20 18:13:25 +0000266# define VdbeNoopComment(X)
drh72ffd092013-10-30 15:52:32 +0000267# define VdbeModuleComment(X)
drhd3d39e92004-05-20 22:16:29 +0000268#endif
269
drh5655c542014-02-19 19:14:34 +0000270/*
271** The VdbeCoverage macros are used to set a coverage testing point
272** for VDBE branch instructions. The coverage testing points are line
273** numbers in the sqlite3.c source file. VDBE branch coverage testing
274** only works with an amalagmation build. That's ok since a VDBE branch
275** coverage build designed for testing the test suite only. No application
276** should ever ship with VDBE branch coverage measuring turned on.
277**
278** VdbeCoverage(v) // Mark the previously coded instruction
279** // as a branch
280**
281** VdbeCoverageIf(v, conditional) // Mark previous if conditional true
282**
283** VdbeCoverageAlwaysTaken(v) // Previous branch is always taken
284**
285** VdbeCoverageNeverTaken(v) // Previous branch is never taken
286**
287** Every VDBE branch operation must be tagged with one of the macros above.
288** If not, then when "make test" is run with -DSQLITE_VDBE_COVERAGE and
289** -DSQLITE_DEBUG then an ALWAYS() will fail in the vdbeTakeBranch()
290** routine in vdbe.c, alerting the developer to the missed tag.
291*/
drh688852a2014-02-17 22:40:43 +0000292#ifdef SQLITE_VDBE_COVERAGE
293 void sqlite3VdbeSetLineNumber(Vdbe*,int);
294# define VdbeCoverage(v) sqlite3VdbeSetLineNumber(v,__LINE__)
295# define VdbeCoverageIf(v,x) if(x)sqlite3VdbeSetLineNumber(v,__LINE__)
drh5655c542014-02-19 19:14:34 +0000296# define VdbeCoverageAlwaysTaken(v) sqlite3VdbeSetLineNumber(v,2);
297# define VdbeCoverageNeverTaken(v) sqlite3VdbeSetLineNumber(v,1);
drhb06a4ec2014-03-10 18:03:09 +0000298# define VDBE_OFFSET_LINENO(x) (__LINE__+x)
drh688852a2014-02-17 22:40:43 +0000299#else
300# define VdbeCoverage(v)
301# define VdbeCoverageIf(v,x)
drh5655c542014-02-19 19:14:34 +0000302# define VdbeCoverageAlwaysTaken(v)
303# define VdbeCoverageNeverTaken(v)
drhb06a4ec2014-03-10 18:03:09 +0000304# define VDBE_OFFSET_LINENO(x) 0
drh688852a2014-02-17 22:40:43 +0000305#endif
306
dan6f9702e2014-11-01 20:38:06 +0000307#ifdef SQLITE_ENABLE_STMT_SCANSTATUS
drh518140e2014-11-06 03:55:10 +0000308void sqlite3VdbeScanStatus(Vdbe*, int, int, int, LogEst, const char*);
dan6f9702e2014-11-01 20:38:06 +0000309#else
dan037b5322014-11-03 11:25:32 +0000310# define sqlite3VdbeScanStatus(a,b,c,d,e)
dan6f9702e2014-11-01 20:38:06 +0000311#endif
312
drh43f58d62016-07-09 16:14:45 +0000313#endif /* SQLITE_VDBE_H */