blob: ed9f44584df15611c7ecb994a38b42fdd6f65e1a [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** Internal interface definitions for SQLite.
13**
drh75897232000-05-29 14:26:00 +000014*/
danielk1977e3026632004-06-22 11:29:02 +000015#ifndef _SQLITEINT_H_
16#define _SQLITEINT_H_
drh71674ce2007-10-23 15:51:26 +000017
mlcreechbd0ae112008-03-06 09:16:24 +000018/*
drh2210dcc2009-08-12 11:45:40 +000019** These #defines should enable >2GB file support on POSIX if the
20** underlying operating system supports it. If the OS lacks
21** large file support, or if the OS is windows, these should be no-ops.
22**
23** Ticket #2739: The _LARGEFILE_SOURCE macro must appear before any
24** system #includes. Hence, this block of code must be the very first
25** code in all source files.
26**
27** Large file support can be disabled using the -DSQLITE_DISABLE_LFS switch
28** on the compiler command line. This is necessary if you are compiling
29** on a recent machine (ex: Red Hat 7.2) but you want your code to work
30** on an older machine (ex: Red Hat 6.0). If you compile on Red Hat 7.2
31** without this option, LFS is enable. But LFS does not exist in the kernel
32** in Red Hat 6.0, so the code won't work. Hence, for maximum binary
33** portability you should omit LFS.
34**
drhdddf6972014-02-07 19:33:31 +000035** The previous paragraph was written in 2005. (This paragraph is written
36** on 2008-11-28.) These days, all Linux kernels support large files, so
37** you should probably leave LFS enabled. But some embedded platforms might
38** lack LFS in which case the SQLITE_DISABLE_LFS macro might still be useful.
39**
drh2210dcc2009-08-12 11:45:40 +000040** Similar is true for Mac OS X. LFS is only supported on Mac OS X 9 and later.
41*/
42#ifndef SQLITE_DISABLE_LFS
43# define _LARGE_FILE 1
44# ifndef _FILE_OFFSET_BITS
45# define _FILE_OFFSET_BITS 64
46# endif
47# define _LARGEFILE_SOURCE 1
48#endif
49
50/*
mistachkina7b3b632014-02-14 23:35:49 +000051** For MinGW, check to see if we can include the header file containing its
52** version information, among other things. Normally, this internal MinGW
53** header file would [only] be included automatically by other MinGW header
54** files; however, the contained version information is now required by this
55** header file to work around binary compatibility issues (see below) and
56** this is the only known way to reliably obtain it. This entire #if block
57** would be completely unnecessary if there was any other way of detecting
58** MinGW via their preprocessor (e.g. if they customized their GCC to define
59** some MinGW-specific macros). When compiling for MinGW, either the
60** _HAVE_MINGW_H or _HAVE__MINGW_H (note the extra underscore) macro must be
61** defined; otherwise, detection of conditions specific to MinGW will be
62** disabled.
63*/
64#if defined(_HAVE_MINGW_H)
65# include "mingw.h"
66#elif defined(_HAVE__MINGW_H)
67# include "_mingw.h"
68#endif
69
70/*
71** For MinGW version 4.x (and higher), check to see if the _USE_32BIT_TIME_T
72** define is required to maintain binary compatibility with the MSVC runtime
73** library in use (e.g. for Windows XP).
74*/
75#if !defined(_USE_32BIT_TIME_T) && !defined(_USE_64BIT_TIME_T) && \
76 defined(_WIN32) && !defined(_WIN64) && \
mistachkin65acf372014-02-16 19:20:00 +000077 defined(__MINGW_MAJOR_VERSION) && __MINGW_MAJOR_VERSION >= 4 && \
mistachkina7b3b632014-02-14 23:35:49 +000078 defined(__MSVCRT__)
79# define _USE_32BIT_TIME_T
80#endif
81
drh5e990be2014-02-25 14:52:01 +000082/* The public SQLite interface. The _FILE_OFFSET_BITS macro must appear
mistachkin0d71d122014-03-06 00:28:57 +000083** first in QNX. Also, the _USE_32BIT_TIME_T macro must appear first for
84** MinGW.
drh5e990be2014-02-25 14:52:01 +000085*/
86#include "sqlite3.h"
87
mlcreechbd0ae112008-03-06 09:16:24 +000088/*
mlcreech1e12d432008-05-07 02:42:01 +000089** Include the configuration header output by 'configure' if we're using the
90** autoconf-based build
mlcreechbd0ae112008-03-06 09:16:24 +000091*/
mlcreech1e12d432008-05-07 02:42:01 +000092#ifdef _HAVE_SQLITE_CONFIG_H
mlcreech98dc4b12008-03-06 16:28:58 +000093#include "config.h"
mlcreech1e12d432008-05-07 02:42:01 +000094#endif
95
drhbb4957f2008-03-20 14:03:29 +000096#include "sqliteLimit.h"
mlcreech98dc4b12008-03-06 16:28:58 +000097
drhe2965822008-04-10 16:47:41 +000098/* Disable nuisance warnings on Borland compilers */
99#if defined(__BORLANDC__)
100#pragma warn -rch /* unreachable code */
101#pragma warn -ccc /* Condition is always true or false */
102#pragma warn -aus /* Assigned value is never used */
103#pragma warn -csu /* Comparing signed and unsigned */
shane467bcf32008-11-24 20:01:32 +0000104#pragma warn -spa /* Suspicious pointer arithmetic */
drhe2965822008-04-10 16:47:41 +0000105#endif
106
mlcreech98dc4b12008-03-06 16:28:58 +0000107/* Needed for various definitions... */
drh60323412008-07-31 17:35:45 +0000108#ifndef _GNU_SOURCE
109# define _GNU_SOURCE
110#endif
mlcreech98dc4b12008-03-06 16:28:58 +0000111
dan881bd792013-03-11 13:37:52 +0000112#if defined(__OpenBSD__) && !defined(_BSD_SOURCE)
113# define _BSD_SOURCE
114#endif
115
mlcreech98dc4b12008-03-06 16:28:58 +0000116/*
drh06af7632008-04-28 12:54:15 +0000117** Include standard header files as necessary
118*/
119#ifdef HAVE_STDINT_H
120#include <stdint.h>
121#endif
122#ifdef HAVE_INTTYPES_H
123#include <inttypes.h>
124#endif
125
drha2460e02010-01-14 00:39:26 +0000126/*
drhc05a9a82010-03-04 16:12:34 +0000127** The following macros are used to cast pointers to integers and
128** integers to pointers. The way you do this varies from one compiler
129** to the next, so we have developed the following set of #if statements
130** to generate appropriate macros for a wide range of compilers.
drh875e9e72009-05-16 17:38:21 +0000131**
drhc05a9a82010-03-04 16:12:34 +0000132** The correct "ANSI" way to do this is to use the intptr_t type.
133** Unfortunately, that typedef is not available on all compilers, or
134** if it is available, it requires an #include of specific headers
drhc92271c2010-03-10 14:06:35 +0000135** that vary from one machine to the next.
drh875e9e72009-05-16 17:38:21 +0000136**
137** Ticket #3860: The llvm-gcc-4.2 compiler from Apple chokes on
138** the ((void*)&((char*)0)[X]) construct. But MSVC chokes on ((void*)(X)).
drh5e49edc2009-05-18 13:34:37 +0000139** So we have to define the macros in different ways depending on the
drh875e9e72009-05-16 17:38:21 +0000140** compiler.
141*/
drhc05a9a82010-03-04 16:12:34 +0000142#if defined(__PTRDIFF_TYPE__) /* This case should work for GCC */
143# define SQLITE_INT_TO_PTR(X) ((void*)(__PTRDIFF_TYPE__)(X))
144# define SQLITE_PTR_TO_INT(X) ((int)(__PTRDIFF_TYPE__)(X))
145#elif !defined(__GNUC__) /* Works for compilers other than LLVM */
146# define SQLITE_INT_TO_PTR(X) ((void*)&((char*)0)[X])
147# define SQLITE_PTR_TO_INT(X) ((int)(((char*)X)-(char*)0))
148#elif defined(HAVE_STDINT_H) /* Use this case if we have ANSI headers */
149# define SQLITE_INT_TO_PTR(X) ((void*)(intptr_t)(X))
150# define SQLITE_PTR_TO_INT(X) ((int)(intptr_t)(X))
151#else /* Generates a warning - but it always works */
152# define SQLITE_INT_TO_PTR(X) ((void*)(X))
153# define SQLITE_PTR_TO_INT(X) ((int)(X))
drh875e9e72009-05-16 17:38:21 +0000154#endif
drhb6dbc002007-11-27 02:38:00 +0000155
drhe5e7a902007-10-01 17:47:00 +0000156/*
drh38c67c32010-09-08 02:30:27 +0000157** The SQLITE_THREADSAFE macro must be defined as 0, 1, or 2.
158** 0 means mutexes are permanently disable and the library is never
159** threadsafe. 1 means the library is serialized which is the highest
drhf7b54962013-05-28 12:11:54 +0000160** level of threadsafety. 2 means the library is multithreaded - multiple
drh38c67c32010-09-08 02:30:27 +0000161** threads can use SQLite as long as no two threads try to use the same
162** database connection at the same time.
163**
drhe5e7a902007-10-01 17:47:00 +0000164** Older versions of SQLite used an optional THREADSAFE macro.
drh38c67c32010-09-08 02:30:27 +0000165** We support that for legacy.
drhe5e7a902007-10-01 17:47:00 +0000166*/
167#if !defined(SQLITE_THREADSAFE)
drhd16d0bc2013-04-16 18:24:34 +0000168# if defined(THREADSAFE)
169# define SQLITE_THREADSAFE THREADSAFE
170# else
171# define SQLITE_THREADSAFE 1 /* IMP: R-07272-22309 */
172# endif
drhe5e7a902007-10-01 17:47:00 +0000173#endif
174
drh67080612007-10-01 14:30:14 +0000175/*
drhcb15f352011-12-23 01:04:17 +0000176** Powersafe overwrite is on by default. But can be turned off using
177** the -DSQLITE_POWERSAFE_OVERWRITE=0 command-line option.
178*/
179#ifndef SQLITE_POWERSAFE_OVERWRITE
180# define SQLITE_POWERSAFE_OVERWRITE 1
181#endif
182
183/*
danielk19770a732f52008-09-04 17:17:38 +0000184** The SQLITE_DEFAULT_MEMSTATUS macro must be defined as either 0 or 1.
185** It determines whether or not the features related to
shane467bcf32008-11-24 20:01:32 +0000186** SQLITE_CONFIG_MEMSTATUS are available by default or not. This value can
danielk19770a732f52008-09-04 17:17:38 +0000187** be overridden at runtime using the sqlite3_config() API.
188*/
189#if !defined(SQLITE_DEFAULT_MEMSTATUS)
190# define SQLITE_DEFAULT_MEMSTATUS 1
191#endif
192
193/*
drh0d180202008-02-14 23:26:56 +0000194** Exactly one of the following macros must be defined in order to
195** specify which memory allocation subsystem to use.
196**
197** SQLITE_SYSTEM_MALLOC // Use normal system malloc()
mistachkin1b186a92011-08-24 16:13:57 +0000198** SQLITE_WIN32_MALLOC // Use Win32 native heap API
drhd1b0afc2012-06-21 14:25:17 +0000199** SQLITE_ZERO_MALLOC // Use a stub allocator that always fails
drh0d180202008-02-14 23:26:56 +0000200** SQLITE_MEMDEBUG // Debugging version of system malloc()
drha2460e02010-01-14 00:39:26 +0000201**
mistachkin753c5442011-08-25 02:02:25 +0000202** On Windows, if the SQLITE_WIN32_MALLOC_VALIDATE macro is defined and the
203** assert() macro is enabled, each call into the Win32 native heap subsystem
204** will cause HeapValidate to be called. If heap validation should fail, an
205** assertion will be triggered.
206**
drh0d180202008-02-14 23:26:56 +0000207** If none of the above are defined, then set SQLITE_SYSTEM_MALLOC as
208** the default.
209*/
drhd1b0afc2012-06-21 14:25:17 +0000210#if defined(SQLITE_SYSTEM_MALLOC) \
211 + defined(SQLITE_WIN32_MALLOC) \
212 + defined(SQLITE_ZERO_MALLOC) \
213 + defined(SQLITE_MEMDEBUG)>1
214# error "Two or more of the following compile-time configuration options\
mistachkin20b1ff02012-06-21 15:12:30 +0000215 are defined but at most one is allowed:\
drhd1b0afc2012-06-21 14:25:17 +0000216 SQLITE_SYSTEM_MALLOC, SQLITE_WIN32_MALLOC, SQLITE_MEMDEBUG,\
217 SQLITE_ZERO_MALLOC"
drh0d180202008-02-14 23:26:56 +0000218#endif
drhd1b0afc2012-06-21 14:25:17 +0000219#if defined(SQLITE_SYSTEM_MALLOC) \
220 + defined(SQLITE_WIN32_MALLOC) \
221 + defined(SQLITE_ZERO_MALLOC) \
222 + defined(SQLITE_MEMDEBUG)==0
drh0d180202008-02-14 23:26:56 +0000223# define SQLITE_SYSTEM_MALLOC 1
224#endif
225
226/*
drh8a1e5942009-04-28 15:43:45 +0000227** If SQLITE_MALLOC_SOFT_LIMIT is not zero, then try to keep the
drheee4c8c2008-02-18 22:24:57 +0000228** sizes of memory allocations below this value where possible.
229*/
drh8a1e5942009-04-28 15:43:45 +0000230#if !defined(SQLITE_MALLOC_SOFT_LIMIT)
drheee4c8c2008-02-18 22:24:57 +0000231# define SQLITE_MALLOC_SOFT_LIMIT 1024
232#endif
233
234/*
drh67080612007-10-01 14:30:14 +0000235** We need to define _XOPEN_SOURCE as follows in order to enable
drh40b521f2013-05-24 12:47:26 +0000236** recursive mutexes on most Unix systems and fchmod() on OpenBSD.
237** But _XOPEN_SOURCE define causes problems for Mac OS X, so omit
238** it.
drh67080612007-10-01 14:30:14 +0000239*/
drh40b521f2013-05-24 12:47:26 +0000240#if !defined(_XOPEN_SOURCE) && !defined(__DARWIN__) && !defined(__APPLE__)
241# define _XOPEN_SOURCE 600
drh67080612007-10-01 14:30:14 +0000242#endif
danielk1977e3026632004-06-22 11:29:02 +0000243
drh7d10d5a2008-08-20 16:35:10 +0000244/*
drh1b28b892012-05-29 19:25:20 +0000245** NDEBUG and SQLITE_DEBUG are opposites. It should always be true that
246** defined(NDEBUG)==!defined(SQLITE_DEBUG). If this is not currently true,
247** make it true by defining or undefining NDEBUG.
248**
drh443dbcf2013-07-29 15:54:06 +0000249** Setting NDEBUG makes the code smaller and faster by disabling the
250** assert() statements in the code. So we want the default action
drh1b28b892012-05-29 19:25:20 +0000251** to be for NDEBUG to be set and NDEBUG to be undefined only if SQLITE_DEBUG
252** is set. Thus NDEBUG becomes an opt-in rather than an opt-out
drh4b529d92005-09-13 00:00:00 +0000253** feature.
254*/
danielk1977771151b2006-01-17 13:21:40 +0000255#if !defined(NDEBUG) && !defined(SQLITE_DEBUG)
drh4b529d92005-09-13 00:00:00 +0000256# define NDEBUG 1
257#endif
drh1b28b892012-05-29 19:25:20 +0000258#if defined(NDEBUG) && defined(SQLITE_DEBUG)
259# undef NDEBUG
260#endif
drh4b529d92005-09-13 00:00:00 +0000261
drh64022502009-01-09 14:11:04 +0000262/*
drhc7379ce2013-10-30 02:28:23 +0000263** Enable SQLITE_ENABLE_EXPLAIN_COMMENTS if SQLITE_DEBUG is turned on.
264*/
265#if !defined(SQLITE_ENABLE_EXPLAIN_COMMENTS) && defined(SQLITE_DEBUG)
266# define SQLITE_ENABLE_EXPLAIN_COMMENTS 1
267#endif
268
269/*
drh47c3b3e2009-01-10 16:15:20 +0000270** The testcase() macro is used to aid in coverage testing. When
271** doing coverage testing, the condition inside the argument to
272** testcase() must be evaluated both true and false in order to
273** get full branch coverage. The testcase() macro is inserted
274** to help ensure adequate test coverage in places where simple
275** condition/decision coverage is inadequate. For example, testcase()
276** can be used to make sure boundary values are tested. For
277** bitmask tests, testcase() can be used to make sure each bit
278** is significant and used at least once. On switch statements
279** where multiple cases go to the same block of code, testcase()
280** can insure that all cases are evaluated.
281**
drh47c3b3e2009-01-10 16:15:20 +0000282*/
283#ifdef SQLITE_COVERAGE_TEST
284 void sqlite3Coverage(int);
285# define testcase(X) if( X ){ sqlite3Coverage(__LINE__); }
drh47c3b3e2009-01-10 16:15:20 +0000286#else
287# define testcase(X)
drh8f941bc2009-01-14 23:03:40 +0000288#endif
289
290/*
291** The TESTONLY macro is used to enclose variable declarations or
292** other bits of code that are needed to support the arguments
293** within testcase() and assert() macros.
294*/
295#if !defined(NDEBUG) || defined(SQLITE_COVERAGE_TEST)
296# define TESTONLY(X) X
297#else
drh47c3b3e2009-01-10 16:15:20 +0000298# define TESTONLY(X)
299#endif
300
301/*
drh61495262009-04-22 15:32:59 +0000302** Sometimes we need a small amount of code such as a variable initialization
303** to setup for a later assert() statement. We do not want this code to
304** appear when assert() is disabled. The following macro is therefore
305** used to contain that setup code. The "VVA" acronym stands for
306** "Verification, Validation, and Accreditation". In other words, the
307** code within VVA_ONLY() will only run during verification processes.
308*/
309#ifndef NDEBUG
310# define VVA_ONLY(X) X
311#else
312# define VVA_ONLY(X)
313#endif
314
315/*
drh47c3b3e2009-01-10 16:15:20 +0000316** The ALWAYS and NEVER macros surround boolean expressions which
317** are intended to always be true or false, respectively. Such
318** expressions could be omitted from the code completely. But they
319** are included in a few cases in order to enhance the resilience
320** of SQLite to unexpected behavior - to make the code "self-healing"
321** or "ductile" rather than being "brittle" and crashing at the first
322** hint of unplanned behavior.
323**
324** In other words, ALWAYS and NEVER are added for defensive code.
325**
326** When doing coverage testing ALWAYS and NEVER are hard-coded to
drh443dbcf2013-07-29 15:54:06 +0000327** be true and false so that the unreachable code they specify will
drh47c3b3e2009-01-10 16:15:20 +0000328** not be counted as untested code.
329*/
330#if defined(SQLITE_COVERAGE_TEST)
331# define ALWAYS(X) (1)
332# define NEVER(X) (0)
333#elif !defined(NDEBUG)
drh2de80f42009-06-24 10:26:32 +0000334# define ALWAYS(X) ((X)?1:(assert(0),0))
335# define NEVER(X) ((X)?(assert(0),1):0)
drh47c3b3e2009-01-10 16:15:20 +0000336#else
337# define ALWAYS(X) (X)
338# define NEVER(X) (X)
339#endif
340
341/*
drh3e8e7ec2010-07-07 13:43:19 +0000342** Return true (non-zero) if the input is a integer that is too large
343** to fit in 32-bits. This macro is used inside of various testcase()
344** macros to verify that we have tested SQLite for large-file support.
345*/
danb31a6af2010-07-14 06:20:26 +0000346#define IS_BIG_INT(X) (((X)&~(i64)0xffffffff)!=0)
drh3e8e7ec2010-07-07 13:43:19 +0000347
348/*
drh47c3b3e2009-01-10 16:15:20 +0000349** The macro unlikely() is a hint that surrounds a boolean
350** expression that is usually false. Macro likely() surrounds
drh443dbcf2013-07-29 15:54:06 +0000351** a boolean expression that is usually true. These hints could,
352** in theory, be used by the compiler to generate better code, but
353** currently they are just comments for human readers.
drh47c3b3e2009-01-10 16:15:20 +0000354*/
drh443dbcf2013-07-29 15:54:06 +0000355#define likely(X) (X)
356#define unlikely(X) (X)
drh47c3b3e2009-01-10 16:15:20 +0000357
drhbeae3192001-09-22 18:12:08 +0000358#include "hash.h"
drh75897232000-05-29 14:26:00 +0000359#include "parse.h"
drh75897232000-05-29 14:26:00 +0000360#include <stdio.h>
361#include <stdlib.h>
362#include <string.h>
363#include <assert.h>
drh52370e22005-01-21 21:31:40 +0000364#include <stddef.h>
drh75897232000-05-29 14:26:00 +0000365
drh967e8b72000-06-21 13:59:10 +0000366/*
drhb37df7b2005-10-13 02:09:49 +0000367** If compiling for a processor that lacks floating point support,
368** substitute integer for floating-point
369*/
370#ifdef SQLITE_OMIT_FLOATING_POINT
371# define double sqlite_int64
drh8b307fb2010-04-06 15:57:05 +0000372# define float sqlite_int64
drhb37df7b2005-10-13 02:09:49 +0000373# define LONGDOUBLE_TYPE sqlite_int64
drhd1167392006-01-23 13:00:35 +0000374# ifndef SQLITE_BIG_DBL
drhcdaca552009-08-20 13:45:07 +0000375# define SQLITE_BIG_DBL (((sqlite3_int64)1)<<50)
drhd1167392006-01-23 13:00:35 +0000376# endif
drhb37df7b2005-10-13 02:09:49 +0000377# define SQLITE_OMIT_DATETIME_FUNCS 1
378# define SQLITE_OMIT_TRACE 1
drh110daac2007-05-04 11:59:31 +0000379# undef SQLITE_MIXED_ENDIAN_64BIT_FLOAT
drh0b3bf922009-06-15 20:45:34 +0000380# undef SQLITE_HAVE_ISNAN
drhb37df7b2005-10-13 02:09:49 +0000381#endif
drhd1167392006-01-23 13:00:35 +0000382#ifndef SQLITE_BIG_DBL
383# define SQLITE_BIG_DBL (1e99)
384#endif
drhb37df7b2005-10-13 02:09:49 +0000385
386/*
danielk197753c0f742005-03-29 03:10:59 +0000387** OMIT_TEMPDB is set to 1 if SQLITE_OMIT_TEMPDB is defined, or 0
388** afterward. Having this macro allows us to cause the C compiler
389** to omit code used by TEMP tables without messy #ifndef statements.
390*/
391#ifdef SQLITE_OMIT_TEMPDB
392#define OMIT_TEMPDB 1
393#else
394#define OMIT_TEMPDB 0
395#endif
396
397/*
drhd946db02005-12-29 19:23:06 +0000398** The "file format" number is an integer that is incremented whenever
399** the VDBE-level file format changes. The following macros define the
400** the default file format for new databases and the maximum file format
401** that the library can read.
402*/
403#define SQLITE_MAX_FILE_FORMAT 4
404#ifndef SQLITE_DEFAULT_FILE_FORMAT
drhbf3f5f82011-11-07 13:05:23 +0000405# define SQLITE_DEFAULT_FILE_FORMAT 4
drhd946db02005-12-29 19:23:06 +0000406#endif
407
drha2460e02010-01-14 00:39:26 +0000408/*
409** Determine whether triggers are recursive by default. This can be
410** changed at run-time using a pragma.
411*/
dan5bde73c2009-09-01 17:11:07 +0000412#ifndef SQLITE_DEFAULT_RECURSIVE_TRIGGERS
413# define SQLITE_DEFAULT_RECURSIVE_TRIGGERS 0
414#endif
415
drhd946db02005-12-29 19:23:06 +0000416/*
danielk1977b06a0b62008-06-26 10:54:12 +0000417** Provide a default value for SQLITE_TEMP_STORE in case it is not specified
drh49766d62005-01-08 18:42:28 +0000418** on the command-line
419*/
danielk1977b06a0b62008-06-26 10:54:12 +0000420#ifndef SQLITE_TEMP_STORE
421# define SQLITE_TEMP_STORE 1
drhd16d0bc2013-04-16 18:24:34 +0000422# define SQLITE_TEMP_STORE_xc 1 /* Exclude from ctime.c */
drh49766d62005-01-08 18:42:28 +0000423#endif
424
425/*
drhf1974842004-11-05 03:56:00 +0000426** GCC does not define the offsetof() macro so we'll have to do it
427** ourselves.
428*/
429#ifndef offsetof
430#define offsetof(STRUCTURE,FIELD) ((int)((char*)&((STRUCTURE*)0)->FIELD))
431#endif
432
433/*
drhe1e2e9a2013-06-13 15:16:53 +0000434** Macros to compute minimum and maximum of two numbers.
435*/
436#define MIN(A,B) ((A)<(B)?(A):(B))
437#define MAX(A,B) ((A)>(B)?(A):(B))
438
439/*
drh9b8f4472006-04-04 01:54:55 +0000440** Check to see if this machine uses EBCDIC. (Yes, believe it or
441** not, there are still machines out there that use EBCDIC.)
442*/
443#if 'A' == '\301'
444# define SQLITE_EBCDIC 1
445#else
446# define SQLITE_ASCII 1
447#endif
448
449/*
drh5a2c2c22001-11-21 02:21:11 +0000450** Integers of known sizes. These typedefs might change for architectures
451** where the sizes very. Preprocessor macros are available so that the
452** types can be conveniently redefined at compile-type. Like this:
453**
454** cc '-DUINTPTR_TYPE=long long int' ...
drh41a2b482001-01-20 19:52:49 +0000455*/
drh5a2c2c22001-11-21 02:21:11 +0000456#ifndef UINT32_TYPE
mlcreechdda5b682008-03-14 13:02:08 +0000457# ifdef HAVE_UINT32_T
458# define UINT32_TYPE uint32_t
459# else
460# define UINT32_TYPE unsigned int
461# endif
drh5a2c2c22001-11-21 02:21:11 +0000462#endif
463#ifndef UINT16_TYPE
mlcreechdda5b682008-03-14 13:02:08 +0000464# ifdef HAVE_UINT16_T
465# define UINT16_TYPE uint16_t
466# else
467# define UINT16_TYPE unsigned short int
468# endif
drh5a2c2c22001-11-21 02:21:11 +0000469#endif
drh939a16d2004-07-15 13:37:22 +0000470#ifndef INT16_TYPE
mlcreechdda5b682008-03-14 13:02:08 +0000471# ifdef HAVE_INT16_T
472# define INT16_TYPE int16_t
473# else
474# define INT16_TYPE short int
475# endif
drh939a16d2004-07-15 13:37:22 +0000476#endif
drh5a2c2c22001-11-21 02:21:11 +0000477#ifndef UINT8_TYPE
mlcreechdda5b682008-03-14 13:02:08 +0000478# ifdef HAVE_UINT8_T
479# define UINT8_TYPE uint8_t
480# else
481# define UINT8_TYPE unsigned char
482# endif
drh5a2c2c22001-11-21 02:21:11 +0000483#endif
drh905793e2004-02-21 13:31:09 +0000484#ifndef INT8_TYPE
mlcreechdda5b682008-03-14 13:02:08 +0000485# ifdef HAVE_INT8_T
486# define INT8_TYPE int8_t
487# else
488# define INT8_TYPE signed char
489# endif
drh905793e2004-02-21 13:31:09 +0000490#endif
drhefad9992004-06-22 12:13:55 +0000491#ifndef LONGDOUBLE_TYPE
492# define LONGDOUBLE_TYPE long double
493#endif
drhefad9992004-06-22 12:13:55 +0000494typedef sqlite_int64 i64; /* 8-byte signed integer */
drh27436af2006-03-28 23:57:17 +0000495typedef sqlite_uint64 u64; /* 8-byte unsigned integer */
drh5a2c2c22001-11-21 02:21:11 +0000496typedef UINT32_TYPE u32; /* 4-byte unsigned integer */
497typedef UINT16_TYPE u16; /* 2-byte unsigned integer */
drh939a16d2004-07-15 13:37:22 +0000498typedef INT16_TYPE i16; /* 2-byte signed integer */
drh5a2c2c22001-11-21 02:21:11 +0000499typedef UINT8_TYPE u8; /* 1-byte unsigned integer */
drh70a8ca32008-08-21 18:49:27 +0000500typedef INT8_TYPE i8; /* 1-byte signed integer */
drh5a2c2c22001-11-21 02:21:11 +0000501
502/*
drh35cd6432009-06-05 14:17:21 +0000503** SQLITE_MAX_U32 is a u64 constant that is the maximum u64 value
504** that can be stored in a u32 without loss of data. The value
505** is 0x00000000ffffffff. But because of quirks of some compilers, we
506** have to specify the value in the less intuitive manner shown:
507*/
508#define SQLITE_MAX_U32 ((((u64)1)<<32)-1)
509
510/*
drhfaacf172011-08-12 01:51:45 +0000511** The datatype used to store estimates of the number of rows in a
512** table or index. This is an unsigned integer type. For 99.9% of
513** the world, a 32-bit integer is sufficient. But a 64-bit integer
514** can be used at compile-time if desired.
515*/
516#ifdef SQLITE_64BIT_STATS
517 typedef u64 tRowcnt; /* 64-bit only if requested at compile-time */
518#else
519 typedef u32 tRowcnt; /* 32-bit is the default */
520#endif
521
522/*
drhbf539c42013-10-05 18:16:02 +0000523** Estimated quantities used for query planning are stored as 16-bit
524** logarithms. For quantity X, the value stored is 10*log2(X). This
525** gives a possible range of values of approximately 1.0e986 to 1e-986.
526** But the allowed values are "grainy". Not every value is representable.
527** For example, quantities 16 and 17 are both represented by a LogEst
drh224155d2014-04-30 13:19:09 +0000528** of 40. However, since LogEst quantaties are suppose to be estimates,
drhbf539c42013-10-05 18:16:02 +0000529** not exact values, this imprecision is not a problem.
530**
drh224155d2014-04-30 13:19:09 +0000531** "LogEst" is short for "Logarithmic Estimate".
drhbf539c42013-10-05 18:16:02 +0000532**
533** Examples:
534** 1 -> 0 20 -> 43 10000 -> 132
535** 2 -> 10 25 -> 46 25000 -> 146
536** 3 -> 16 100 -> 66 1000000 -> 199
537** 4 -> 20 1000 -> 99 1048576 -> 200
538** 10 -> 33 1024 -> 100 4294967296 -> 320
539**
540** The LogEst can be negative to indicate fractional values.
541** Examples:
542**
543** 0.5 -> -10 0.1 -> -33 0.0625 -> -40
544*/
545typedef INT16_TYPE LogEst;
546
547/*
drhbbd42a62004-05-22 17:41:58 +0000548** Macros to determine whether the machine is big or little endian,
drh71794db2014-04-18 00:49:29 +0000549** and whether or not that determination is run-time or compile-time.
550**
551** For best performance, an attempt is made to guess at the byte-order
552** using C-preprocessor macros. If that is unsuccessful, or if
553** -DSQLITE_RUNTIME_BYTEORDER=1 is set, then byte-order is determined
554** at run-time.
drhbbd42a62004-05-22 17:41:58 +0000555*/
drh46c99e02007-08-27 23:26:59 +0000556#ifdef SQLITE_AMALGAMATION
drhb3190c12008-12-08 21:37:14 +0000557const int sqlite3one = 1;
drh46c99e02007-08-27 23:26:59 +0000558#else
drhbbd42a62004-05-22 17:41:58 +0000559extern const int sqlite3one;
drh46c99e02007-08-27 23:26:59 +0000560#endif
drh71794db2014-04-18 00:49:29 +0000561#if (defined(i386) || defined(__i386__) || defined(_M_IX86) || \
562 defined(__x86_64) || defined(__x86_64__) || defined(_M_X64) || \
563 defined(_M_AMD64) || defined(_M_ARM) || defined(__x86) || \
564 defined(__arm__)) && !defined(SQLITE_RUNTIME_BYTEORDER)
drh2cf4acb2014-04-18 00:06:02 +0000565# define SQLITE_BYTEORDER 1234
drh38def052007-03-31 15:27:59 +0000566# define SQLITE_BIGENDIAN 0
567# define SQLITE_LITTLEENDIAN 1
568# define SQLITE_UTF16NATIVE SQLITE_UTF16LE
drh71794db2014-04-18 00:49:29 +0000569#endif
570#if (defined(sparc) || defined(__ppc__)) \
571 && !defined(SQLITE_RUNTIME_BYTEORDER)
572# define SQLITE_BYTEORDER 4321
573# define SQLITE_BIGENDIAN 1
574# define SQLITE_LITTLEENDIAN 0
575# define SQLITE_UTF16NATIVE SQLITE_UTF16BE
576#endif
577#if !defined(SQLITE_BYTEORDER)
drh2cf4acb2014-04-18 00:06:02 +0000578# define SQLITE_BYTEORDER 0 /* 0 means "unknown at compile-time" */
drh38def052007-03-31 15:27:59 +0000579# define SQLITE_BIGENDIAN (*(char *)(&sqlite3one)==0)
580# define SQLITE_LITTLEENDIAN (*(char *)(&sqlite3one)==1)
drh2cf4acb2014-04-18 00:06:02 +0000581# define SQLITE_UTF16NATIVE (SQLITE_BIGENDIAN?SQLITE_UTF16BE:SQLITE_UTF16LE)
drh38def052007-03-31 15:27:59 +0000582#endif
drhbbd42a62004-05-22 17:41:58 +0000583
584/*
drh0f050352008-05-09 18:03:13 +0000585** Constants for the largest and smallest possible 64-bit signed integers.
586** These macros are designed to work correctly on both 32-bit and 64-bit
587** compilers.
588*/
589#define LARGEST_INT64 (0xffffffff|(((i64)0x7fffffff)<<32))
590#define SMALLEST_INT64 (((i64)-1) - LARGEST_INT64)
591
danielk1977be229652009-03-20 14:18:51 +0000592/*
593** Round up a number to the next larger multiple of 8. This is used
594** to force 8-byte alignment on 64-bit architectures.
595*/
danielk1977bc739712009-03-23 04:33:32 +0000596#define ROUND8(x) (((x)+7)&~7)
597
598/*
599** Round down to the nearest multiple of 8
600*/
601#define ROUNDDOWN8(x) ((x)&~7)
danielk1977be229652009-03-20 14:18:51 +0000602
drh0f050352008-05-09 18:03:13 +0000603/*
drh8e14c592009-12-04 23:10:12 +0000604** Assert that the pointer X is aligned to an 8-byte boundary. This
605** macro is used only within assert() to verify that the code gets
606** all alignment restrictions correct.
607**
608** Except, if SQLITE_4_BYTE_ALIGNED_MALLOC is defined, then the
609** underlying malloc() implemention might return us 4-byte aligned
610** pointers. In that case, only verify 4-byte alignment.
drhea598cb2009-04-05 12:22:08 +0000611*/
drh8e14c592009-12-04 23:10:12 +0000612#ifdef SQLITE_4_BYTE_ALIGNED_MALLOC
613# define EIGHT_BYTE_ALIGNMENT(X) ((((char*)(X) - (char*)0)&3)==0)
614#else
615# define EIGHT_BYTE_ALIGNMENT(X) ((((char*)(X) - (char*)0)&7)==0)
616#endif
drhea598cb2009-04-05 12:22:08 +0000617
drh188d4882013-04-08 20:47:49 +0000618/*
drh9b4c59f2013-04-15 17:03:42 +0000619** Disable MMAP on platforms where it is known to not work
drh188d4882013-04-08 20:47:49 +0000620*/
621#if defined(__OpenBSD__) || defined(__QNXNTO__)
drh9b4c59f2013-04-15 17:03:42 +0000622# undef SQLITE_MAX_MMAP_SIZE
623# define SQLITE_MAX_MMAP_SIZE 0
drh188d4882013-04-08 20:47:49 +0000624#endif
625
drh9b4c59f2013-04-15 17:03:42 +0000626/*
627** Default maximum size of memory used by memory-mapped I/O in the VFS
628*/
629#ifdef __APPLE__
630# include <TargetConditionals.h>
631# if TARGET_OS_IPHONE
632# undef SQLITE_MAX_MMAP_SIZE
633# define SQLITE_MAX_MMAP_SIZE 0
634# endif
635#endif
636#ifndef SQLITE_MAX_MMAP_SIZE
637# if defined(__linux__) \
638 || defined(_WIN32) \
639 || (defined(__APPLE__) && defined(__MACH__)) \
640 || defined(__sun)
drh2bba8c22013-04-26 12:08:29 +0000641# define SQLITE_MAX_MMAP_SIZE 0x7fff0000 /* 2147418112 */
drh9b4c59f2013-04-15 17:03:42 +0000642# else
643# define SQLITE_MAX_MMAP_SIZE 0
644# endif
drhd16d0bc2013-04-16 18:24:34 +0000645# define SQLITE_MAX_MMAP_SIZE_xc 1 /* exclude from ctime.c */
drh9b4c59f2013-04-15 17:03:42 +0000646#endif
647
648/*
649** The default MMAP_SIZE is zero on all platforms. Or, even if a larger
650** default MMAP_SIZE is specified at compile-time, make sure that it does
651** not exceed the maximum mmap size.
652*/
653#ifndef SQLITE_DEFAULT_MMAP_SIZE
654# define SQLITE_DEFAULT_MMAP_SIZE 0
drhd16d0bc2013-04-16 18:24:34 +0000655# define SQLITE_DEFAULT_MMAP_SIZE_xc 1 /* Exclude from ctime.c */
drh9b4c59f2013-04-15 17:03:42 +0000656#endif
657#if SQLITE_DEFAULT_MMAP_SIZE>SQLITE_MAX_MMAP_SIZE
658# undef SQLITE_DEFAULT_MMAP_SIZE
659# define SQLITE_DEFAULT_MMAP_SIZE SQLITE_MAX_MMAP_SIZE
660#endif
drhe7b347072009-06-01 18:18:20 +0000661
drhea598cb2009-04-05 12:22:08 +0000662/*
drh1435a9a2013-08-27 23:15:44 +0000663** Only one of SQLITE_ENABLE_STAT3 or SQLITE_ENABLE_STAT4 can be defined.
664** Priority is given to SQLITE_ENABLE_STAT4. If either are defined, also
665** define SQLITE_ENABLE_STAT3_OR_STAT4
666*/
667#ifdef SQLITE_ENABLE_STAT4
668# undef SQLITE_ENABLE_STAT3
669# define SQLITE_ENABLE_STAT3_OR_STAT4 1
670#elif SQLITE_ENABLE_STAT3
671# define SQLITE_ENABLE_STAT3_OR_STAT4 1
672#elif SQLITE_ENABLE_STAT3_OR_STAT4
673# undef SQLITE_ENABLE_STAT3_OR_STAT4
674#endif
675
676/*
drh90f5ecb2004-07-22 01:19:35 +0000677** An instance of the following structure is used to store the busy-handler
678** callback for a given sqlite handle.
679**
680** The sqlite.busyHandler member of the sqlite struct contains the busy
681** callback for the database handle. Each pager opened via the sqlite
682** handle is passed a pointer to sqlite.busyHandler. The busy-handler
683** callback is currently invoked only from within pager.c.
684*/
685typedef struct BusyHandler BusyHandler;
686struct BusyHandler {
687 int (*xFunc)(void *,int); /* The busy callback */
688 void *pArg; /* First arg to busy callback */
drha4afb652005-07-09 02:16:02 +0000689 int nBusy; /* Incremented with each busy call */
drh90f5ecb2004-07-22 01:19:35 +0000690};
691
692/*
drh75897232000-05-29 14:26:00 +0000693** Name of the master database table. The master database table
694** is a special table that holds the names and attributes of all
695** user tables and indices.
696*/
drhe0bc4042002-06-25 01:09:11 +0000697#define MASTER_NAME "sqlite_master"
698#define TEMP_MASTER_NAME "sqlite_temp_master"
drh75897232000-05-29 14:26:00 +0000699
700/*
danielk19778e150812004-05-10 01:17:37 +0000701** The root-page of the master database table.
702*/
703#define MASTER_ROOT 1
704
705/*
drhed6c8672003-01-12 18:02:16 +0000706** The name of the schema table.
707*/
danielk197753c0f742005-03-29 03:10:59 +0000708#define SCHEMA_TABLE(x) ((!OMIT_TEMPDB)&&(x==1)?TEMP_MASTER_NAME:MASTER_NAME)
drhed6c8672003-01-12 18:02:16 +0000709
710/*
drh75897232000-05-29 14:26:00 +0000711** A convenience macro that returns the number of elements in
712** an array.
713*/
danielk197723432972008-11-17 16:42:00 +0000714#define ArraySize(X) ((int)(sizeof(X)/sizeof(X[0])))
drh75897232000-05-29 14:26:00 +0000715
716/*
drh7a5bcc02013-01-16 17:08:58 +0000717** Determine if the argument is a power of two
718*/
719#define IsPowerOfTwo(X) (((X)&((X)-1))==0)
720
721/*
drh633e6d52008-07-28 19:34:53 +0000722** The following value as a destructor means to use sqlite3DbFree().
drhaa538a52012-01-19 16:57:16 +0000723** The sqlite3DbFree() routine requires two parameters instead of the
724** one parameter that destructors normally want. So we have to introduce
725** this magic value that the code knows to handle differently. Any
726** pointer will work here as long as it is distinct from SQLITE_STATIC
727** and SQLITE_TRANSIENT.
drh633e6d52008-07-28 19:34:53 +0000728*/
drhaa538a52012-01-19 16:57:16 +0000729#define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3MallocSize)
drh633e6d52008-07-28 19:34:53 +0000730
drh78f82d12008-09-02 00:52:52 +0000731/*
732** When SQLITE_OMIT_WSD is defined, it means that the target platform does
733** not support Writable Static Data (WSD) such as global and static variables.
734** All variables must either be on the stack or dynamically allocated from
735** the heap. When WSD is unsupported, the variable declarations scattered
736** throughout the SQLite code must become constants instead. The SQLITE_WSD
737** macro is used for this purpose. And instead of referencing the variable
738** directly, we use its constant as a key to lookup the run-time allocated
739** buffer that holds real variable. The constant is also the initializer
740** for the run-time allocated buffer.
741**
shane2479de32008-11-10 18:05:35 +0000742** In the usual case where WSD is supported, the SQLITE_WSD and GLOBAL
drh78f82d12008-09-02 00:52:52 +0000743** macros become no-ops and have zero performance impact.
744*/
danielk1977075c23a2008-09-01 18:34:20 +0000745#ifdef SQLITE_OMIT_WSD
746 #define SQLITE_WSD const
747 #define GLOBAL(t,v) (*(t*)sqlite3_wsd_find((void*)&(v), sizeof(v)))
748 #define sqlite3GlobalConfig GLOBAL(struct Sqlite3Config, sqlite3Config)
drhd1d38482008-10-07 23:46:38 +0000749 int sqlite3_wsd_init(int N, int J);
750 void *sqlite3_wsd_find(void *K, int L);
danielk1977075c23a2008-09-01 18:34:20 +0000751#else
752 #define SQLITE_WSD
753 #define GLOBAL(t,v) v
754 #define sqlite3GlobalConfig sqlite3Config
755#endif
756
danielk1977f3d3c272008-11-19 16:52:44 +0000757/*
758** The following macros are used to suppress compiler warnings and to
759** make it clear to human readers when a function parameter is deliberately
760** left unused within the body of a function. This usually happens when
761** a function is called via a function pointer. For example the
762** implementation of an SQL aggregate step callback may not use the
763** parameter indicating the number of arguments passed to the aggregate,
764** if it knows that this is enforced elsewhere.
765**
766** When a function parameter is not used at all within the body of a function,
767** it is generally named "NotUsed" or "NotUsed2" to make things even clearer.
768** However, these macros may also be used to suppress warnings related to
769** parameters that may or may not be used depending on compilation options.
770** For example those parameters only used in assert() statements. In these
771** cases the parameters are named as per the usual conventions.
772*/
danielk197762c14b32008-11-19 09:05:26 +0000773#define UNUSED_PARAMETER(x) (void)(x)
danielk1977f3d3c272008-11-19 16:52:44 +0000774#define UNUSED_PARAMETER2(x,y) UNUSED_PARAMETER(x),UNUSED_PARAMETER(y)
danielk197762c14b32008-11-19 09:05:26 +0000775
drh633e6d52008-07-28 19:34:53 +0000776/*
drh75897232000-05-29 14:26:00 +0000777** Forward references to structures
778*/
drh13449892005-09-07 21:22:45 +0000779typedef struct AggInfo AggInfo;
drhfe05af82005-07-21 03:14:59 +0000780typedef struct AuthContext AuthContext;
drh0b9f50d2009-06-23 20:28:53 +0000781typedef struct AutoincInfo AutoincInfo;
drhf5e7bb52008-02-18 14:47:33 +0000782typedef struct Bitvec Bitvec;
drhfe05af82005-07-21 03:14:59 +0000783typedef struct CollSeq CollSeq;
drh7020f652000-06-03 18:06:52 +0000784typedef struct Column Column;
drhfe05af82005-07-21 03:14:59 +0000785typedef struct Db Db;
danielk1977e501b892006-01-09 06:29:47 +0000786typedef struct Schema Schema;
drh75897232000-05-29 14:26:00 +0000787typedef struct Expr Expr;
788typedef struct ExprList ExprList;
drhb7916a72009-05-27 10:31:29 +0000789typedef struct ExprSpan ExprSpan;
drhc2eef3b2002-08-31 18:53:06 +0000790typedef struct FKey FKey;
dand2199f02010-08-27 17:48:52 +0000791typedef struct FuncDestructor FuncDestructor;
drhfe05af82005-07-21 03:14:59 +0000792typedef struct FuncDef FuncDef;
drh70a8ca32008-08-21 18:49:27 +0000793typedef struct FuncDefHash FuncDefHash;
drhfe05af82005-07-21 03:14:59 +0000794typedef struct IdList IdList;
795typedef struct Index Index;
dan02fa4692009-08-17 17:06:58 +0000796typedef struct IndexSample IndexSample;
danielk19778d059842004-05-12 11:24:02 +0000797typedef struct KeyClass KeyClass;
drhd3d39e92004-05-20 22:16:29 +0000798typedef struct KeyInfo KeyInfo;
drh633e6d52008-07-28 19:34:53 +0000799typedef struct Lookaside Lookaside;
800typedef struct LookasideSlot LookasideSlot;
danielk1977d1ab1ba2006-06-15 04:28:13 +0000801typedef struct Module Module;
drh626a8792005-01-17 22:08:19 +0000802typedef struct NameContext NameContext;
drhfe05af82005-07-21 03:14:59 +0000803typedef struct Parse Parse;
drha5c14162013-12-17 15:03:06 +0000804typedef struct PrintfArguments PrintfArguments;
drha2460e02010-01-14 00:39:26 +0000805typedef struct RowSet RowSet;
danielk1977fd7f0452008-12-17 17:30:26 +0000806typedef struct Savepoint Savepoint;
drhfe05af82005-07-21 03:14:59 +0000807typedef struct Select Select;
drh634d81d2012-09-20 15:41:31 +0000808typedef struct SelectDest SelectDest;
drhfe05af82005-07-21 03:14:59 +0000809typedef struct SrcList SrcList;
drhade86482007-11-28 22:36:40 +0000810typedef struct StrAccum StrAccum;
drhfe05af82005-07-21 03:14:59 +0000811typedef struct Table Table;
danielk1977c00da102006-01-07 13:21:04 +0000812typedef struct TableLock TableLock;
drhfe05af82005-07-21 03:14:59 +0000813typedef struct Token Token;
drha2460e02010-01-14 00:39:26 +0000814typedef struct Trigger Trigger;
dan2832ad42009-08-31 15:27:27 +0000815typedef struct TriggerPrg TriggerPrg;
drhfe05af82005-07-21 03:14:59 +0000816typedef struct TriggerStep TriggerStep;
drhe63d9992008-08-13 19:11:48 +0000817typedef struct UnpackedRecord UnpackedRecord;
danielk1977595a5232009-07-24 17:58:53 +0000818typedef struct VTable VTable;
danb061d052011-04-25 18:49:57 +0000819typedef struct VtabCtx VtabCtx;
drh7d10d5a2008-08-20 16:35:10 +0000820typedef struct Walker Walker;
drhfe05af82005-07-21 03:14:59 +0000821typedef struct WhereInfo WhereInfo;
dan7d562db2014-01-11 19:19:36 +0000822typedef struct With With;
drhd3d39e92004-05-20 22:16:29 +0000823
danielk19772dca4ac2008-01-03 11:50:29 +0000824/*
825** Defer sourcing vdbe.h and btree.h until after the "u8" and
826** "BusyHandler" typedefs. vdbe.h also requires a few of the opaque
827** pointer types (i.e. FuncDef) defined above.
828*/
829#include "btree.h"
830#include "vdbe.h"
831#include "pager.h"
danielk19778c0a7912008-08-20 14:49:23 +0000832#include "pcache.h"
danielk19772dca4ac2008-01-03 11:50:29 +0000833
danielk19771cc5ed82007-05-16 17:28:43 +0000834#include "os.h"
drhc7ce76a2007-08-30 14:10:30 +0000835#include "mutex.h"
danielk19771cc5ed82007-05-16 17:28:43 +0000836
drheee4c8c2008-02-18 22:24:57 +0000837
drh001bbcb2003-03-19 03:14:00 +0000838/*
839** Each database file to be accessed by the system is an instance
840** of the following structure. There are normally two of these structures
841** in the sqlite.aDb[] array. aDb[0] is the main database file and
drha69d9162003-04-17 22:57:53 +0000842** aDb[1] is the database file used to hold temporary tables. Additional
843** databases may be attached.
drh001bbcb2003-03-19 03:14:00 +0000844*/
845struct Db {
846 char *zName; /* Name of this database */
847 Btree *pBt; /* The B*Tree structure for this database file */
shane467bcf32008-11-24 20:01:32 +0000848 u8 safety_level; /* How aggressive at syncing data to disk */
danielk1977e501b892006-01-09 06:29:47 +0000849 Schema *pSchema; /* Pointer to database schema (possibly shared) */
danielk1977da184232006-01-05 11:34:32 +0000850};
851
852/*
853** An instance of the following structure stores a database schema.
drh21206082011-04-04 18:22:02 +0000854**
855** Most Schema objects are associated with a Btree. The exception is
856** the Schema for the TEMP databaes (sqlite3.aDb[1]) which is free-standing.
857** In shared cache mode, a single Schema object can be shared by multiple
858** Btrees that refer to the same underlying BtShared object.
859**
860** Schema objects are automatically deallocated when the last Btree that
861** references them is destroyed. The TEMP Schema is manually freed by
862** sqlite3_close().
863*
864** A thread must be holding a mutex on the corresponding Btree in order
865** to access Schema content. This implies that the thread must also be
866** holding a mutex on the sqlite3 connection pointer that owns the Btree.
drh55a09592011-06-07 18:31:14 +0000867** For a TEMP Schema, only the connection mutex is required.
danielk1977da184232006-01-05 11:34:32 +0000868*/
danielk1977e501b892006-01-09 06:29:47 +0000869struct Schema {
drh001bbcb2003-03-19 03:14:00 +0000870 int schema_cookie; /* Database schema version number for this file */
drhc2a75552011-03-18 21:55:46 +0000871 int iGeneration; /* Generation counter. Incremented with each change */
drhd24cc422003-03-27 12:51:24 +0000872 Hash tblHash; /* All tables indexed by name */
873 Hash idxHash; /* All (named) indices indexed by name */
874 Hash trigHash; /* All triggers indexed by name */
dan1da40a32009-09-19 17:00:31 +0000875 Hash fkeyHash; /* All foreign keys by referenced table name */
drh4794f732004-11-05 17:17:50 +0000876 Table *pSeqTab; /* The sqlite_sequence table used by AUTOINCREMENT */
danielk1977da184232006-01-05 11:34:32 +0000877 u8 file_format; /* Schema format version for this file */
drh8079a0d2006-01-12 17:20:50 +0000878 u8 enc; /* Text encoding used by this database */
drh2c5e35f2014-08-05 11:04:21 +0000879 u16 schemaFlags; /* Flags associated with this schema */
danielk197714db2662006-01-09 16:12:04 +0000880 int cache_size; /* Number of pages to use in the cache */
drh001bbcb2003-03-19 03:14:00 +0000881};
drh75897232000-05-29 14:26:00 +0000882
883/*
drh8bf8dc92003-05-17 17:35:10 +0000884** These macros can be used to test, set, or clear bits in the
drha2460e02010-01-14 00:39:26 +0000885** Db.pSchema->flags field.
drh8bf8dc92003-05-17 17:35:10 +0000886*/
drh2c5e35f2014-08-05 11:04:21 +0000887#define DbHasProperty(D,I,P) (((D)->aDb[I].pSchema->schemaFlags&(P))==(P))
888#define DbHasAnyProperty(D,I,P) (((D)->aDb[I].pSchema->schemaFlags&(P))!=0)
889#define DbSetProperty(D,I,P) (D)->aDb[I].pSchema->schemaFlags|=(P)
890#define DbClearProperty(D,I,P) (D)->aDb[I].pSchema->schemaFlags&=~(P)
drh8bf8dc92003-05-17 17:35:10 +0000891
892/*
drha2460e02010-01-14 00:39:26 +0000893** Allowed values for the DB.pSchema->flags field.
drh8bf8dc92003-05-17 17:35:10 +0000894**
drh8bf8dc92003-05-17 17:35:10 +0000895** The DB_SchemaLoaded flag is set after the database schema has been
896** read into internal hash tables.
897**
898** DB_UnresetViews means that one or more views have column names that
899** have been filled out. If the schema changes, these column names might
900** changes and so the view will need to be reset.
901*/
drh124b27e2004-06-19 16:06:10 +0000902#define DB_SchemaLoaded 0x0001 /* The schema has been loaded */
903#define DB_UnresetViews 0x0002 /* Some views have defined column names */
danielk1977b82e7ed2006-01-11 14:09:31 +0000904#define DB_Empty 0x0004 /* The file is empty (length 0 bytes) */
drh8bf8dc92003-05-17 17:35:10 +0000905
drhcaa639f2008-03-20 00:32:20 +0000906/*
907** The number of different kinds of things that can be limited
908** using the sqlite3_limit() interface.
909*/
drh417168a2009-09-07 18:14:02 +0000910#define SQLITE_N_LIMIT (SQLITE_LIMIT_TRIGGER_DEPTH+1)
drh8bf8dc92003-05-17 17:35:10 +0000911
912/*
drh633e6d52008-07-28 19:34:53 +0000913** Lookaside malloc is a set of fixed-size buffers that can be used
shane467bcf32008-11-24 20:01:32 +0000914** to satisfy small transient memory allocation requests for objects
drh633e6d52008-07-28 19:34:53 +0000915** associated with a particular database connection. The use of
916** lookaside malloc provides a significant performance enhancement
917** (approx 10%) by avoiding numerous malloc/free requests while parsing
918** SQL statements.
919**
920** The Lookaside structure holds configuration information about the
921** lookaside malloc subsystem. Each available memory allocation in
922** the lookaside subsystem is stored on a linked list of LookasideSlot
923** objects.
drhd9da78a2009-03-24 15:08:09 +0000924**
925** Lookaside allocations are only allowed for objects that are associated
926** with a particular database connection. Hence, schema information cannot
927** be stored in lookaside because in shared cache mode the schema information
928** is shared by multiple database connections. Therefore, while parsing
929** schema information, the Lookaside.bEnabled flag is cleared so that
930** lookaside allocations are not used to construct the schema objects.
drh633e6d52008-07-28 19:34:53 +0000931*/
932struct Lookaside {
933 u16 sz; /* Size of each buffer in bytes */
drhd9da78a2009-03-24 15:08:09 +0000934 u8 bEnabled; /* False to disable new lookaside allocations */
drhe9d1c722008-08-04 20:13:26 +0000935 u8 bMalloced; /* True if pStart obtained from sqlite3_malloc() */
drh633e6d52008-07-28 19:34:53 +0000936 int nOut; /* Number of buffers currently checked out */
937 int mxOut; /* Highwater mark for nOut */
drh0b12e7f2010-12-20 15:51:58 +0000938 int anStat[3]; /* 0: hits. 1: size misses. 2: full misses */
drh7d10d5a2008-08-20 16:35:10 +0000939 LookasideSlot *pFree; /* List of available buffers */
drh633e6d52008-07-28 19:34:53 +0000940 void *pStart; /* First byte of available memory space */
941 void *pEnd; /* First byte past end of available space */
942};
943struct LookasideSlot {
944 LookasideSlot *pNext; /* Next buffer in the list of free buffers */
945};
946
947/*
drh70a8ca32008-08-21 18:49:27 +0000948** A hash table for function definitions.
949**
950** Hash each FuncDef structure into one of the FuncDefHash.a[] slots.
951** Collisions are on the FuncDef.pHash chain.
952*/
953struct FuncDefHash {
954 FuncDef *a[23]; /* Hash table for functions */
955};
956
957/*
drha2460e02010-01-14 00:39:26 +0000958** Each database connection is an instance of the following structure.
drh75897232000-05-29 14:26:00 +0000959*/
drh9bb575f2004-09-06 17:24:11 +0000960struct sqlite3 {
drh90f6a5b2007-08-15 13:04:54 +0000961 sqlite3_vfs *pVfs; /* OS Interface */
drha4510172012-02-02 15:50:17 +0000962 struct Vdbe *pVdbe; /* List of active virtual machines */
963 CollSeq *pDfltColl; /* The default collating sequence (BINARY) */
964 sqlite3_mutex *mutex; /* Connection mutex */
drh001bbcb2003-03-19 03:14:00 +0000965 Db *aDb; /* All backends */
drha4510172012-02-02 15:50:17 +0000966 int nDb; /* Number of backends currently in use */
shane467bcf32008-11-24 20:01:32 +0000967 int flags; /* Miscellaneous flags. See below */
drha4510172012-02-02 15:50:17 +0000968 i64 lastRowid; /* ROWID of most recent insert (see above) */
drh9b4c59f2013-04-15 17:03:42 +0000969 i64 szMmap; /* Default mmap_size setting */
drh522c26f2011-05-07 14:40:29 +0000970 unsigned int openFlags; /* Flags passed to sqlite3_vfs.xOpen() */
drhfcd35c72005-05-21 02:48:08 +0000971 int errCode; /* Most recent error code (SQLITE_*) */
drh4ac285a2006-09-15 07:28:50 +0000972 int errMask; /* & result codes with this before returning */
drha5759672012-10-30 14:39:12 +0000973 u16 dbOptFlags; /* Flags to enable/disable optimizations */
drhfcd35c72005-05-21 02:48:08 +0000974 u8 autoCommit; /* The auto-commit flag. */
drh90f5ecb2004-07-22 01:19:35 +0000975 u8 temp_store; /* 1: file 2: memory 0: default */
drh17435752007-08-16 04:30:38 +0000976 u8 mallocFailed; /* True if we have seen a malloc failure */
drh3b020132008-04-17 17:02:01 +0000977 u8 dfltLockMode; /* Default locking-mode for attached dbs */
drh98757152008-01-09 23:04:12 +0000978 signed char nextAutovac; /* Autovac setting after VACUUM if >=0 */
drha7564662010-02-22 19:32:31 +0000979 u8 suppressErr; /* Do not issue error messages if true */
danb061d052011-04-25 18:49:57 +0000980 u8 vtabOnConflict; /* Value to return for s3_vtab_on_conflict() */
drha4510172012-02-02 15:50:17 +0000981 u8 isTransactionSavepoint; /* True if the outermost savepoint is a TS */
danielk1977f653d782008-03-20 11:04:21 +0000982 int nextPagesize; /* Pagesize after VACUUM if >0 */
danielk197764202cf2008-11-17 15:31:47 +0000983 u32 magic; /* Magic number for detect library misuse */
danielk1977b28af712004-06-21 06:50:26 +0000984 int nChange; /* Value returned by sqlite3_changes() */
985 int nTotalChange; /* Value returned by sqlite3_total_changes() */
drhcaa639f2008-03-20 00:32:20 +0000986 int aLimit[SQLITE_N_LIMIT]; /* Limits */
danielk1977b28af712004-06-21 06:50:26 +0000987 struct sqlite3InitInfo { /* Information used during initialization */
danielk1977b28af712004-06-21 06:50:26 +0000988 int newTnum; /* Rootpage of table being initialized */
drha4510172012-02-02 15:50:17 +0000989 u8 iDb; /* Which db file is being initialized */
danielk1977b28af712004-06-21 06:50:26 +0000990 u8 busy; /* TRUE if currently initializing */
drh3d5f74b2009-08-06 17:43:31 +0000991 u8 orphanTrigger; /* Last statement is orphaned TEMP trigger */
drh1d85d932004-02-14 23:05:52 +0000992 } init;
drh1713afb2013-06-28 01:24:57 +0000993 int nVdbeActive; /* Number of VDBEs currently running */
994 int nVdbeRead; /* Number of active VDBEs that read or write */
995 int nVdbeWrite; /* Number of active VDBEs that read and write */
996 int nVdbeExec; /* Number of nested calls to VdbeExec() */
drha4510172012-02-02 15:50:17 +0000997 int nExtension; /* Number of loaded extensions */
998 void **aExtension; /* Array of shared library handles */
drh19e2d372005-08-29 23:00:03 +0000999 void (*xTrace)(void*,const char*); /* Trace function */
1000 void *pTraceArg; /* Argument to the trace function */
1001 void (*xProfile)(void*,const char*,u64); /* Profiling function */
1002 void *pProfileArg; /* Argument to profile function */
danielk197771fd80b2005-12-16 06:54:01 +00001003 void *pCommitArg; /* Argument to xCommitCallback() */
1004 int (*xCommitCallback)(void*); /* Invoked at every commit. */
1005 void *pRollbackArg; /* Argument to xRollbackCallback() */
1006 void (*xRollbackCallback)(void*); /* Invoked at every commit. */
danielk197794eb6a12005-12-15 15:22:08 +00001007 void *pUpdateArg;
1008 void (*xUpdateCallback)(void*,int, const char*,const char*,sqlite_int64);
dan5cf53532010-05-01 16:40:20 +00001009#ifndef SQLITE_OMIT_WAL
drh7ed91f22010-04-29 22:34:07 +00001010 int (*xWalCallback)(void *, sqlite3 *, const char *, int);
1011 void *pWalArg;
dan5cf53532010-05-01 16:40:20 +00001012#endif
drhfcd35c72005-05-21 02:48:08 +00001013 void(*xCollNeeded)(void*,sqlite3*,int eTextRep,const char*);
1014 void(*xCollNeeded16)(void*,sqlite3*,int eTextRep,const void*);
1015 void *pCollNeededArg;
drhfcd35c72005-05-21 02:48:08 +00001016 sqlite3_value *pErr; /* Most recent error message */
drh881feaa2006-07-26 01:39:30 +00001017 union {
drh39001e72008-09-12 16:03:47 +00001018 volatile int isInterrupted; /* True if sqlite3_interrupt has been called */
drh881feaa2006-07-26 01:39:30 +00001019 double notUsed1; /* Spacer */
1020 } u1;
drh633e6d52008-07-28 19:34:53 +00001021 Lookaside lookaside; /* Lookaside malloc configuration */
drhed6c8672003-01-12 18:02:16 +00001022#ifndef SQLITE_OMIT_AUTHORIZATION
drhe22a3342003-04-22 20:30:37 +00001023 int (*xAuth)(void*,int,const char*,const char*,const char*,const char*);
1024 /* Access authorization function */
drhed6c8672003-01-12 18:02:16 +00001025 void *pAuthArg; /* 1st argument to the access auth function */
1026#endif
danielk1977348bb5d2003-10-18 09:37:26 +00001027#ifndef SQLITE_OMIT_PROGRESS_CALLBACK
1028 int (*xProgress)(void *); /* The progress callback */
1029 void *pProgressArg; /* Argument to the progress callback */
drh8f8c65f2013-07-10 18:14:29 +00001030 unsigned nProgressOps; /* Number of opcodes for progress callback */
danielk1977348bb5d2003-10-18 09:37:26 +00001031#endif
drhb9bb7c12006-06-11 23:41:55 +00001032#ifndef SQLITE_OMIT_VIRTUALTABLE
drha4510172012-02-02 15:50:17 +00001033 int nVTrans; /* Allocated size of aVTrans */
drhb9bb7c12006-06-11 23:41:55 +00001034 Hash aModule; /* populated by sqlite3_create_module() */
danb061d052011-04-25 18:49:57 +00001035 VtabCtx *pVtabCtx; /* Context for active vtab connect/create */
danielk1977595a5232009-07-24 17:58:53 +00001036 VTable **aVTrans; /* Virtual tables with open transactions */
danielk1977595a5232009-07-24 17:58:53 +00001037 VTable *pDisconnect; /* Disconnect these in next sqlite3_prepare() */
danielk19776b456a22005-03-21 04:04:02 +00001038#endif
drh70a8ca32008-08-21 18:49:27 +00001039 FuncDefHash aFunc; /* Hash table of connection functions */
drhfcd35c72005-05-21 02:48:08 +00001040 Hash aCollSeq; /* All collating sequences */
1041 BusyHandler busyHandler; /* Busy callback */
1042 Db aDbStatic[2]; /* Static space for the 2 default backends */
danielk1977fd7f0452008-12-17 17:30:26 +00001043 Savepoint *pSavepoint; /* List of active savepoints */
drha4510172012-02-02 15:50:17 +00001044 int busyTimeout; /* Busy handler timeout, in msec */
danielk1977fd7f0452008-12-17 17:30:26 +00001045 int nSavepoint; /* Number of non-transaction savepoints */
danielk1977bd434552009-03-18 10:33:00 +00001046 int nStatement; /* Number of nested statement-transactions */
dan1da40a32009-09-19 17:00:31 +00001047 i64 nDeferredCons; /* Net deferred constraints this transaction. */
drh648e2642013-07-11 15:03:32 +00001048 i64 nDeferredImmCons; /* Net deferred immediate constraints */
dand46def72010-07-24 11:28:28 +00001049 int *pnBytesFreed; /* If not NULL, increment this in DbFree() */
danielk1977404ca072009-03-16 13:19:36 +00001050
1051#ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
1052 /* The following variables are all protected by the STATIC_MASTER
1053 ** mutex, not by sqlite3.mutex. They are used by code in notify.c.
drh65a73ba2009-04-07 22:06:57 +00001054 **
1055 ** When X.pUnlockConnection==Y, that means that X is waiting for Y to
1056 ** unlock so that it can proceed.
1057 **
1058 ** When X.pBlockingConnection==Y, that means that something that X tried
1059 ** tried to do recently failed with an SQLITE_LOCKED error due to locks
1060 ** held by Y.
danielk1977404ca072009-03-16 13:19:36 +00001061 */
1062 sqlite3 *pBlockingConnection; /* Connection that caused SQLITE_LOCKED */
1063 sqlite3 *pUnlockConnection; /* Connection to watch for unlock */
1064 void *pUnlockArg; /* Argument to xUnlockNotify */
1065 void (*xUnlockNotify)(void **, int); /* Unlock notify callback */
1066 sqlite3 *pNextBlocked; /* Next in list of all blocked connections */
1067#endif
drh75897232000-05-29 14:26:00 +00001068};
1069
drh03b808a2006-03-13 15:06:05 +00001070/*
1071** A macro to discover the encoding of a database.
1072*/
danielk197714db2662006-01-09 16:12:04 +00001073#define ENC(db) ((db)->aDb[0].pSchema->enc)
1074
drh75897232000-05-29 14:26:00 +00001075/*
drh07096f62009-12-22 23:52:32 +00001076** Possible values for the sqlite3.flags.
drh75897232000-05-29 14:26:00 +00001077*/
drh7e5418e2012-09-27 15:05:54 +00001078#define SQLITE_VdbeTrace 0x00000001 /* True to trace VDBE execution */
1079#define SQLITE_InternChanges 0x00000002 /* Uncommitted Hash table changes */
drh40c39412013-08-16 20:42:20 +00001080#define SQLITE_FullFSync 0x00000004 /* Use full fsync on the backend */
1081#define SQLITE_CkptFullFSync 0x00000008 /* Use full fsync for checkpoint */
1082#define SQLITE_CacheSpill 0x00000010 /* OK to spill pager cache */
1083#define SQLITE_FullColNames 0x00000020 /* Show full column names on SELECT */
1084#define SQLITE_ShortColNames 0x00000040 /* Show short columns names */
1085#define SQLITE_CountRows 0x00000080 /* Count rows changed by INSERT, */
drh1bee3d72001-10-15 00:44:35 +00001086 /* DELETE, or UPDATE and return */
1087 /* the count using a callback. */
drh40c39412013-08-16 20:42:20 +00001088#define SQLITE_NullCallback 0x00000100 /* Invoke the callback once if the */
drh6a535342001-10-19 16:44:56 +00001089 /* result set is empty */
drh40c39412013-08-16 20:42:20 +00001090#define SQLITE_SqlTrace 0x00000200 /* Debug print SQL as it executes */
1091#define SQLITE_VdbeListing 0x00000400 /* Debug listings of VDBE programs */
1092#define SQLITE_WriteSchema 0x00000800 /* OK to update SQLITE_MASTER */
1093#define SQLITE_VdbeAddopTrace 0x00001000 /* Trace sqlite3VdbeAddOp() calls */
1094#define SQLITE_IgnoreChecks 0x00002000 /* Do not enforce check constraints */
1095#define SQLITE_ReadUncommitted 0x0004000 /* For shared-cache mode */
1096#define SQLITE_LegacyFileFmt 0x00008000 /* Create new databases in format 1 */
1097#define SQLITE_RecoveryMode 0x00010000 /* Ignore schema errors */
1098#define SQLITE_ReverseOrder 0x00020000 /* Reverse unordered SELECTs */
1099#define SQLITE_RecTriggers 0x00040000 /* Enable recursive triggers */
1100#define SQLITE_ForeignKeys 0x00080000 /* Enforce foreign key constraints */
1101#define SQLITE_AutoIndex 0x00100000 /* Enable automatic indexes */
1102#define SQLITE_PreferBuiltin 0x00200000 /* Preference to built-in funcs */
1103#define SQLITE_LoadExtension 0x00400000 /* Enable load_extension */
1104#define SQLITE_EnableTrigger 0x00800000 /* True to enable triggers */
1105#define SQLITE_DeferFKs 0x01000000 /* Defer all FK constraints */
1106#define SQLITE_QueryOnly 0x02000000 /* Disable database changes */
drh84e55a82013-11-13 17:58:23 +00001107#define SQLITE_VdbeEQP 0x04000000 /* Debug EXPLAIN QUERY PLAN */
drhb1eaa712013-07-11 15:22:31 +00001108
drh07096f62009-12-22 23:52:32 +00001109
1110/*
drh7e5418e2012-09-27 15:05:54 +00001111** Bits of the sqlite3.dbOptFlags field that are used by the
1112** sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS,...) interface to
1113** selectively disable various optimizations.
drh07096f62009-12-22 23:52:32 +00001114*/
drh7e5418e2012-09-27 15:05:54 +00001115#define SQLITE_QueryFlattener 0x0001 /* Query flattening */
1116#define SQLITE_ColumnCache 0x0002 /* Column cache */
1117#define SQLITE_GroupByOrder 0x0004 /* GROUPBY cover of ORDERBY */
1118#define SQLITE_FactorOutConst 0x0008 /* Constant factoring */
drh762c1c42014-01-02 19:35:30 +00001119/* not used 0x0010 // Was: SQLITE_IdxRealAsInt */
drh7e5418e2012-09-27 15:05:54 +00001120#define SQLITE_DistinctOpt 0x0020 /* DISTINCT using indexes */
1121#define SQLITE_CoverIdxScan 0x0040 /* Covering index scans */
drha9e3fc02012-09-27 23:27:23 +00001122#define SQLITE_OrderByIdxJoin 0x0080 /* ORDER BY of joins via index */
drha5759672012-10-30 14:39:12 +00001123#define SQLITE_SubqCoroutine 0x0100 /* Evaluate subqueries as coroutines */
drheb5bc922013-01-17 16:43:33 +00001124#define SQLITE_Transitive 0x0200 /* Transitive constraints */
drh1031bd92013-06-22 15:44:26 +00001125#define SQLITE_OmitNoopJoin 0x0400 /* Omit unused tables in joins */
drh40aa9362013-06-28 17:29:25 +00001126#define SQLITE_Stat3 0x0800 /* Use the SQLITE_STAT3 table */
drhadd5ce32013-09-07 00:29:06 +00001127#define SQLITE_AdjustOutEst 0x1000 /* Adjust output estimates using WHERE */
drha5759672012-10-30 14:39:12 +00001128#define SQLITE_AllOpts 0xffff /* All optimizations */
drh7e5418e2012-09-27 15:05:54 +00001129
1130/*
1131** Macros for testing whether or not optimizations are enabled or disabled.
1132*/
1133#ifndef SQLITE_OMIT_BUILTIN_TEST
1134#define OptimizationDisabled(db, mask) (((db)->dbOptFlags&(mask))!=0)
1135#define OptimizationEnabled(db, mask) (((db)->dbOptFlags&(mask))==0)
1136#else
1137#define OptimizationDisabled(db, mask) 0
1138#define OptimizationEnabled(db, mask) 1
1139#endif
danielk197734c68fb2007-03-14 15:37:04 +00001140
drh58b95762000-06-02 01:17:37 +00001141/*
drhd9f158e2013-11-21 20:48:42 +00001142** Return true if it OK to factor constant expressions into the initialization
1143** code. The argument is a Parse object for the code generator.
1144*/
drhaceb31b2014-02-08 01:40:27 +00001145#define ConstFactorOk(P) ((P)->okConstFactor)
drhd9f158e2013-11-21 20:48:42 +00001146
1147/*
drh247be432002-05-10 05:44:55 +00001148** Possible values for the sqlite.magic field.
1149** The numbers are obtained at random and have no special meaning, other
1150** than being distinct from one another.
1151*/
1152#define SQLITE_MAGIC_OPEN 0xa029a697 /* Database is open */
1153#define SQLITE_MAGIC_CLOSED 0x9f3c2d33 /* Database is closed */
drh7e8b8482008-01-23 03:03:05 +00001154#define SQLITE_MAGIC_SICK 0x4b771290 /* Error and awaiting close */
drh247be432002-05-10 05:44:55 +00001155#define SQLITE_MAGIC_BUSY 0xf03b7906 /* Database currently in use */
1156#define SQLITE_MAGIC_ERROR 0xb5357930 /* An SQLITE_MISUSE error occurred */
drh4245c402012-06-02 14:32:21 +00001157#define SQLITE_MAGIC_ZOMBIE 0x64cffc7f /* Close with last statement close */
drh247be432002-05-10 05:44:55 +00001158
1159/*
drh0bce8352002-02-28 00:41:10 +00001160** Each SQL function is defined by an instance of the following
1161** structure. A pointer to this structure is stored in the sqlite.aFunc
drh8e0a2f92002-02-23 23:45:45 +00001162** hash table. When multiple functions have the same name, the hash table
1163** points to a linked list of these structures.
drh28037572000-08-02 13:47:41 +00001164*/
drh0bce8352002-02-28 00:41:10 +00001165struct FuncDef {
drhe82f5d02008-10-07 19:53:14 +00001166 i16 nArg; /* Number of arguments. -1 means unlimited */
drhd36e1042013-09-06 13:10:12 +00001167 u16 funcFlags; /* Some combination of SQLITE_FUNC_* */
drhf9b596e2004-05-26 16:54:42 +00001168 void *pUserData; /* User data parameter */
1169 FuncDef *pNext; /* Next function with same name */
1170 void (*xFunc)(sqlite3_context*,int,sqlite3_value**); /* Regular function */
1171 void (*xStep)(sqlite3_context*,int,sqlite3_value**); /* Aggregate step */
shane467bcf32008-11-24 20:01:32 +00001172 void (*xFinalize)(sqlite3_context*); /* Aggregate finalizer */
danielk19778c0a7912008-08-20 14:49:23 +00001173 char *zName; /* SQL name of the function. */
drh70a8ca32008-08-21 18:49:27 +00001174 FuncDef *pHash; /* Next with a different name but the same hash */
dand2199f02010-08-27 17:48:52 +00001175 FuncDestructor *pDestructor; /* Reference counted destructor function */
1176};
1177
1178/*
1179** This structure encapsulates a user-function destructor callback (as
1180** configured using create_function_v2()) and a reference counter. When
1181** create_function_v2() is called to create a function with a destructor,
1182** a single object of this type is allocated. FuncDestructor.nRef is set to
1183** the number of FuncDef objects created (either 1 or 3, depending on whether
1184** or not the specified encoding is SQLITE_ANY). The FuncDef.pDestructor
1185** member of each of the new FuncDef objects is set to point to the allocated
1186** FuncDestructor.
1187**
1188** Thereafter, when one of the FuncDef objects is deleted, the reference
1189** count on this object is decremented. When it reaches 0, the destructor
1190** is invoked and the FuncDestructor structure freed.
1191*/
1192struct FuncDestructor {
1193 int nRef;
1194 void (*xDestroy)(void *);
1195 void *pUserData;
drh8e0a2f92002-02-23 23:45:45 +00001196};
drh28037572000-08-02 13:47:41 +00001197
1198/*
drha748fdc2012-03-28 01:34:47 +00001199** Possible values for FuncDef.flags. Note that the _LENGTH and _TYPEOF
1200** values must correspond to OPFLAG_LENGTHARG and OPFLAG_TYPEOFARG. There
1201** are assert() statements in the code to verify this.
drh7d10d5a2008-08-20 16:35:10 +00001202*/
drhd36e1042013-09-06 13:10:12 +00001203#define SQLITE_FUNC_ENCMASK 0x003 /* SQLITE_UTF8, SQLITE_UTF16BE or UTF16LE */
1204#define SQLITE_FUNC_LIKE 0x004 /* Candidate for the LIKE optimization */
1205#define SQLITE_FUNC_CASE 0x008 /* Case-sensitive LIKE-type function */
1206#define SQLITE_FUNC_EPHEM 0x010 /* Ephemeral. Delete with VDBE */
1207#define SQLITE_FUNC_NEEDCOLL 0x020 /* sqlite3GetFuncCollSeq() might be called */
1208#define SQLITE_FUNC_LENGTH 0x040 /* Built-in length() function */
1209#define SQLITE_FUNC_TYPEOF 0x080 /* Built-in typeof() function */
1210#define SQLITE_FUNC_COUNT 0x100 /* Built-in count(*) aggregate */
1211#define SQLITE_FUNC_COALESCE 0x200 /* Built-in coalesce() or ifnull() */
1212#define SQLITE_FUNC_UNLIKELY 0x400 /* Built-in unlikely() function */
drhb1fba282013-11-21 14:33:48 +00001213#define SQLITE_FUNC_CONSTANT 0x800 /* Constant inputs give a constant output */
drh7d10d5a2008-08-20 16:35:10 +00001214
1215/*
drh777c5382008-08-21 20:21:34 +00001216** The following three macros, FUNCTION(), LIKEFUNC() and AGGREGATE() are
1217** used to create the initializers for the FuncDef structures.
1218**
1219** FUNCTION(zName, nArg, iArg, bNC, xFunc)
1220** Used to create a scalar function definition of a function zName
1221** implemented by C function xFunc that accepts nArg arguments. The
1222** value passed as iArg is cast to a (void*) and made available
1223** as the user-data (sqlite3_user_data()) for the function. If
drhf7bca572009-05-30 14:16:31 +00001224** argument bNC is true, then the SQLITE_FUNC_NEEDCOLL flag is set.
drh777c5382008-08-21 20:21:34 +00001225**
drhb1fba282013-11-21 14:33:48 +00001226** VFUNCTION(zName, nArg, iArg, bNC, xFunc)
1227** Like FUNCTION except it omits the SQLITE_FUNC_CONSTANT flag.
1228**
drh777c5382008-08-21 20:21:34 +00001229** AGGREGATE(zName, nArg, iArg, bNC, xStep, xFinal)
1230** Used to create an aggregate function definition implemented by
1231** the C functions xStep and xFinal. The first four parameters
1232** are interpreted in the same way as the first 4 parameters to
1233** FUNCTION().
1234**
1235** LIKEFUNC(zName, nArg, pArg, flags)
1236** Used to create a scalar function definition of a function zName
1237** that accepts nArg arguments and is implemented by a call to C
1238** function likeFunc. Argument pArg is cast to a (void *) and made
1239** available as the function user-data (sqlite3_user_data()). The
1240** FuncDef.flags variable is set to the value passed as the flags
1241** parameter.
1242*/
1243#define FUNCTION(zName, nArg, iArg, bNC, xFunc) \
drhb1fba282013-11-21 14:33:48 +00001244 {nArg, SQLITE_FUNC_CONSTANT|SQLITE_UTF8|(bNC*SQLITE_FUNC_NEEDCOLL), \
1245 SQLITE_INT_TO_PTR(iArg), 0, xFunc, 0, 0, #zName, 0, 0}
1246#define VFUNCTION(zName, nArg, iArg, bNC, xFunc) \
drhd36e1042013-09-06 13:10:12 +00001247 {nArg, SQLITE_UTF8|(bNC*SQLITE_FUNC_NEEDCOLL), \
drha748fdc2012-03-28 01:34:47 +00001248 SQLITE_INT_TO_PTR(iArg), 0, xFunc, 0, 0, #zName, 0, 0}
1249#define FUNCTION2(zName, nArg, iArg, bNC, xFunc, extraFlags) \
drhb1fba282013-11-21 14:33:48 +00001250 {nArg,SQLITE_FUNC_CONSTANT|SQLITE_UTF8|(bNC*SQLITE_FUNC_NEEDCOLL)|extraFlags,\
drh6ac78a02010-09-28 14:26:36 +00001251 SQLITE_INT_TO_PTR(iArg), 0, xFunc, 0, 0, #zName, 0, 0}
drh21717ed2008-10-13 15:35:08 +00001252#define STR_FUNCTION(zName, nArg, pArg, bNC, xFunc) \
drhb1fba282013-11-21 14:33:48 +00001253 {nArg, SQLITE_FUNC_CONSTANT|SQLITE_UTF8|(bNC*SQLITE_FUNC_NEEDCOLL), \
drh6ac78a02010-09-28 14:26:36 +00001254 pArg, 0, xFunc, 0, 0, #zName, 0, 0}
drh777c5382008-08-21 20:21:34 +00001255#define LIKEFUNC(zName, nArg, arg, flags) \
drhb1fba282013-11-21 14:33:48 +00001256 {nArg, SQLITE_FUNC_CONSTANT|SQLITE_UTF8|flags, \
1257 (void *)arg, 0, likeFunc, 0, 0, #zName, 0, 0}
drh777c5382008-08-21 20:21:34 +00001258#define AGGREGATE(zName, nArg, arg, nc, xStep, xFinal) \
drhd36e1042013-09-06 13:10:12 +00001259 {nArg, SQLITE_UTF8|(nc*SQLITE_FUNC_NEEDCOLL), \
drh6ac78a02010-09-28 14:26:36 +00001260 SQLITE_INT_TO_PTR(arg), 0, 0, xStep,xFinal,#zName,0,0}
drh777c5382008-08-21 20:21:34 +00001261
danielk1977fd7f0452008-12-17 17:30:26 +00001262/*
1263** All current savepoints are stored in a linked list starting at
1264** sqlite3.pSavepoint. The first element in the list is the most recently
1265** opened savepoint. Savepoints are added to the list by the vdbe
1266** OP_Savepoint instruction.
1267*/
1268struct Savepoint {
1269 char *zName; /* Savepoint name (nul-terminated) */
drhfcb9f7a2009-10-13 19:19:23 +00001270 i64 nDeferredCons; /* Number of deferred fk violations */
drh648e2642013-07-11 15:03:32 +00001271 i64 nDeferredImmCons; /* Number of deferred imm fk. */
danielk1977fd7f0452008-12-17 17:30:26 +00001272 Savepoint *pNext; /* Parent savepoint (if any) */
1273};
1274
1275/*
1276** The following are used as the second parameter to sqlite3Savepoint(),
1277** and as the P1 argument to the OP_Savepoint instruction.
1278*/
1279#define SAVEPOINT_BEGIN 0
1280#define SAVEPOINT_RELEASE 1
1281#define SAVEPOINT_ROLLBACK 2
1282
drh777c5382008-08-21 20:21:34 +00001283
1284/*
danielk1977d1ab1ba2006-06-15 04:28:13 +00001285** Each SQLite module (virtual table definition) is defined by an
1286** instance of the following structure, stored in the sqlite3.aModule
1287** hash table.
1288*/
1289struct Module {
1290 const sqlite3_module *pModule; /* Callback pointers */
1291 const char *zName; /* Name passed to create_module() */
1292 void *pAux; /* pAux passed to create_module() */
danielk1977832a58a2007-06-22 15:21:15 +00001293 void (*xDestroy)(void *); /* Module destructor function */
danielk1977d1ab1ba2006-06-15 04:28:13 +00001294};
1295
1296/*
drh967e8b72000-06-21 13:59:10 +00001297** information about each column of an SQL table is held in an instance
drh7020f652000-06-03 18:06:52 +00001298** of this structure.
1299*/
1300struct Column {
drh967e8b72000-06-21 13:59:10 +00001301 char *zName; /* Name of this column */
danielk19777977a172004-11-09 12:44:37 +00001302 Expr *pDflt; /* Default value of this column */
drhb7916a72009-05-27 10:31:29 +00001303 char *zDflt; /* Original text of the default value */
drh382c0242001-10-06 16:33:02 +00001304 char *zType; /* Data type for this column */
danielk1977b3bf5562006-01-10 17:58:23 +00001305 char *zColl; /* Collating sequence. If NULL, use the default */
drha371ace2012-09-13 14:22:47 +00001306 u8 notNull; /* An OE_ code for handling a NOT NULL constraint */
danielk1977a37cdde2004-05-16 11:15:36 +00001307 char affinity; /* One of the SQLITE_AFF_... values */
drhfdaac672013-10-04 15:30:21 +00001308 u8 szEst; /* Estimated size of this column. INT==1 */
1309 u8 colFlags; /* Boolean properties. See COLFLAG_ defines below */
drh7020f652000-06-03 18:06:52 +00001310};
1311
drha371ace2012-09-13 14:22:47 +00001312/* Allowed values for Column.colFlags:
1313*/
1314#define COLFLAG_PRIMKEY 0x0001 /* Column is part of the primary key */
1315#define COLFLAG_HIDDEN 0x0002 /* A hidden column in a virtual table */
1316
drh7020f652000-06-03 18:06:52 +00001317/*
drha9fd84b2004-05-18 23:21:35 +00001318** A "Collating Sequence" is defined by an instance of the following
danielk19770202b292004-06-09 09:55:16 +00001319** structure. Conceptually, a collating sequence consists of a name and
1320** a comparison routine that defines the order of that sequence.
drha9fd84b2004-05-18 23:21:35 +00001321**
drhe6f1e762012-12-06 01:03:15 +00001322** If CollSeq.xCmp is NULL, it means that the
danielk19770202b292004-06-09 09:55:16 +00001323** collating sequence is undefined. Indices built on an undefined
1324** collating sequence may not be read or written.
drha9fd84b2004-05-18 23:21:35 +00001325*/
1326struct CollSeq {
danielk1977a9808b32007-05-07 09:32:45 +00001327 char *zName; /* Name of the collating sequence, UTF-8 encoded */
1328 u8 enc; /* Text encoding handled by xCmp() */
danielk1977a9808b32007-05-07 09:32:45 +00001329 void *pUser; /* First argument to xCmp() */
danielk19770202b292004-06-09 09:55:16 +00001330 int (*xCmp)(void*,int, const void*, int, const void*);
danielk1977a9808b32007-05-07 09:32:45 +00001331 void (*xDel)(void*); /* Destructor for pUser */
drha9fd84b2004-05-18 23:21:35 +00001332};
1333
1334/*
drhd3d39e92004-05-20 22:16:29 +00001335** A sort order can be either ASC or DESC.
drh8e2ca022002-06-17 17:07:19 +00001336*/
drh8e2ca022002-06-17 17:07:19 +00001337#define SQLITE_SO_ASC 0 /* Sort in ascending order */
drhd3d39e92004-05-20 22:16:29 +00001338#define SQLITE_SO_DESC 1 /* Sort in ascending order */
drh8e2ca022002-06-17 17:07:19 +00001339
1340/*
danielk1977a37cdde2004-05-16 11:15:36 +00001341** Column affinity types.
drh8a512562005-11-14 22:29:05 +00001342**
1343** These used to have mnemonic name like 'i' for SQLITE_AFF_INTEGER and
1344** 't' for SQLITE_AFF_TEXT. But we can save a little space and improve
drh7d10d5a2008-08-20 16:35:10 +00001345** the speed a little by numbering the values consecutively.
drh8a512562005-11-14 22:29:05 +00001346**
1347** But rather than start with 0 or 1, we begin with 'a'. That way,
1348** when multiple affinity types are concatenated into a string and
drh66a51672008-01-03 00:01:23 +00001349** used as the P4 operand, they will be more readable.
drh8a512562005-11-14 22:29:05 +00001350**
1351** Note also that the numeric types are grouped together so that testing
1352** for a numeric type is a single comparison.
danielk1977a37cdde2004-05-16 11:15:36 +00001353*/
drh8a512562005-11-14 22:29:05 +00001354#define SQLITE_AFF_TEXT 'a'
1355#define SQLITE_AFF_NONE 'b'
1356#define SQLITE_AFF_NUMERIC 'c'
1357#define SQLITE_AFF_INTEGER 'd'
1358#define SQLITE_AFF_REAL 'e'
danielk1977a37cdde2004-05-16 11:15:36 +00001359
drh8a512562005-11-14 22:29:05 +00001360#define sqlite3IsNumericAffinity(X) ((X)>=SQLITE_AFF_NUMERIC)
danielk1977a37cdde2004-05-16 11:15:36 +00001361
1362/*
drh35573352008-01-08 23:54:25 +00001363** The SQLITE_AFF_MASK values masks off the significant bits of an
1364** affinity value.
1365*/
1366#define SQLITE_AFF_MASK 0x67
1367
1368/*
1369** Additional bit values that can be ORed with an affinity without
1370** changing the affinity.
drh3d77dee2014-02-19 14:20:49 +00001371**
1372** The SQLITE_NOTNULL flag is a combination of NULLEQ and JUMPIFNULL.
1373** It causes an assert() to fire if either operand to a comparison
1374** operator is NULL. It is added to certain comparison operators to
1375** prove that the operands are always NOT NULL.
drh35573352008-01-08 23:54:25 +00001376*/
1377#define SQLITE_JUMPIFNULL 0x08 /* jumps if either operand is NULL */
drh93a960a2008-07-10 00:32:42 +00001378#define SQLITE_STOREP2 0x10 /* Store result in reg[P2] rather than jump */
drh6a2fe092009-09-23 02:29:36 +00001379#define SQLITE_NULLEQ 0x80 /* NULL=NULL */
drh3d77dee2014-02-19 14:20:49 +00001380#define SQLITE_NOTNULL 0x88 /* Assert that operands are never NULL */
drh35573352008-01-08 23:54:25 +00001381
1382/*
danielk1977595a5232009-07-24 17:58:53 +00001383** An object of this type is created for each virtual table present in
1384** the database schema.
1385**
1386** If the database schema is shared, then there is one instance of this
1387** structure for each database connection (sqlite3*) that uses the shared
1388** schema. This is because each database connection requires its own unique
1389** instance of the sqlite3_vtab* handle used to access the virtual table
1390** implementation. sqlite3_vtab* handles can not be shared between
1391** database connections, even when the rest of the in-memory database
1392** schema is shared, as the implementation often stores the database
1393** connection handle passed to it via the xConnect() or xCreate() method
1394** during initialization internally. This database connection handle may
drh9bbc2e22011-04-04 20:40:22 +00001395** then be used by the virtual table implementation to access real tables
danielk1977595a5232009-07-24 17:58:53 +00001396** within the database. So that they appear as part of the callers
1397** transaction, these accesses need to be made via the same database
1398** connection as that used to execute SQL operations on the virtual table.
1399**
1400** All VTable objects that correspond to a single table in a shared
1401** database schema are initially stored in a linked-list pointed to by
1402** the Table.pVTable member variable of the corresponding Table object.
1403** When an sqlite3_prepare() operation is required to access the virtual
1404** table, it searches the list for the VTable that corresponds to the
1405** database connection doing the preparing so as to use the correct
1406** sqlite3_vtab* handle in the compiled query.
1407**
1408** When an in-memory Table object is deleted (for example when the
1409** schema is being reloaded for some reason), the VTable objects are not
1410** deleted and the sqlite3_vtab* handles are not xDisconnect()ed
1411** immediately. Instead, they are moved from the Table.pVTable list to
1412** another linked list headed by the sqlite3.pDisconnect member of the
1413** corresponding sqlite3 structure. They are then deleted/xDisconnected
1414** next time a statement is prepared using said sqlite3*. This is done
1415** to avoid deadlock issues involving multiple sqlite3.mutex mutexes.
1416** Refer to comments above function sqlite3VtabUnlockList() for an
1417** explanation as to why it is safe to add an entry to an sqlite3.pDisconnect
1418** list without holding the corresponding sqlite3.mutex mutex.
1419**
1420** The memory for objects of this type is always allocated by
1421** sqlite3DbMalloc(), using the connection handle stored in VTable.db as
1422** the first argument.
1423*/
1424struct VTable {
1425 sqlite3 *db; /* Database connection associated with this table */
1426 Module *pMod; /* Pointer to module implementation */
1427 sqlite3_vtab *pVtab; /* Pointer to vtab instance */
1428 int nRef; /* Number of pointers to this structure */
danb061d052011-04-25 18:49:57 +00001429 u8 bConstraint; /* True if constraints are supported */
drhaddd8f82011-05-25 15:54:09 +00001430 int iSavepoint; /* Depth of the SAVEPOINT stack */
danielk1977595a5232009-07-24 17:58:53 +00001431 VTable *pNext; /* Next in linked list (see above) */
1432};
1433
1434/*
drh22f70c32002-02-18 01:17:00 +00001435** Each SQL table is represented in memory by an instance of the
1436** following structure.
1437**
drhd24cc422003-03-27 12:51:24 +00001438** Table.zName is the name of the table. The case of the original
drh22f70c32002-02-18 01:17:00 +00001439** CREATE TABLE statement is stored, but case is not significant for
1440** comparisons.
1441**
drhd24cc422003-03-27 12:51:24 +00001442** Table.nCol is the number of columns in this table. Table.aCol is a
drh22f70c32002-02-18 01:17:00 +00001443** pointer to an array of Column structures, one for each column.
1444**
drhd24cc422003-03-27 12:51:24 +00001445** If the table has an INTEGER PRIMARY KEY, then Table.iPKey is the index of
1446** the column that is that key. Otherwise Table.iPKey is negative. Note
drh22f70c32002-02-18 01:17:00 +00001447** that the datatype of the PRIMARY KEY must be INTEGER for this field to
1448** be set. An INTEGER PRIMARY KEY is used as the rowid for each row of
1449** the table. If a table has no INTEGER PRIMARY KEY, then a random rowid
drh7d10d5a2008-08-20 16:35:10 +00001450** is generated for each row of the table. TF_HasPrimaryKey is set if
drh22f70c32002-02-18 01:17:00 +00001451** the table has any PRIMARY KEY, INTEGER or otherwise.
1452**
drhd24cc422003-03-27 12:51:24 +00001453** Table.tnum is the page number for the root BTree page of the table in the
1454** database file. If Table.iDb is the index of the database table backend
1455** in sqlite.aDb[]. 0 is for the main database and 1 is for the file that
drh7d10d5a2008-08-20 16:35:10 +00001456** holds temporary tables and indices. If TF_Ephemeral is set
1457** then the table is stored in a file that is automatically deleted
drhd24cc422003-03-27 12:51:24 +00001458** when the VDBE cursor to the table is closed. In this case Table.tnum
drh22f70c32002-02-18 01:17:00 +00001459** refers VDBE cursor number that holds the table open, not to the root
1460** page number. Transient tables are used to hold the results of a
1461** sub-query that appears instead of a real table name in the FROM clause
1462** of a SELECT statement.
drh75897232000-05-29 14:26:00 +00001463*/
1464struct Table {
drh7d10d5a2008-08-20 16:35:10 +00001465 char *zName; /* Name of the table or view */
drh7d10d5a2008-08-20 16:35:10 +00001466 Column *aCol; /* Information about each column */
1467 Index *pIndex; /* List of SQL indexes on this table. */
drh7d10d5a2008-08-20 16:35:10 +00001468 Select *pSelect; /* NULL for tables. Points to definition if a view. */
drh7d10d5a2008-08-20 16:35:10 +00001469 FKey *pFKey; /* Linked list of all foreign keys in this table */
1470 char *zColAff; /* String defining the affinity of each column */
drhffe07b22005-11-03 00:41:17 +00001471#ifndef SQLITE_OMIT_CHECK
drh2938f922012-03-07 19:13:29 +00001472 ExprList *pCheck; /* All CHECK constraints */
drhffe07b22005-11-03 00:41:17 +00001473#endif
dancfc9df72014-04-25 15:01:01 +00001474 LogEst nRowLogEst; /* Estimated rows in table - from sqlite_stat1 table */
drhd815f172012-09-13 14:42:43 +00001475 int tnum; /* Root BTree node for this table (see note above) */
1476 i16 iPKey; /* If not negative, use aCol[iPKey] as the primary key */
1477 i16 nCol; /* Number of columns in this table */
1478 u16 nRef; /* Number of pointers to this Table */
drhbf539c42013-10-05 18:16:02 +00001479 LogEst szTabRow; /* Estimated size of each table row in bytes */
drhdbd94862014-07-23 23:57:42 +00001480#ifdef SQLITE_ENABLE_COSTMULT
1481 LogEst costMult; /* Cost multiplier for using this table */
1482#endif
drhd815f172012-09-13 14:42:43 +00001483 u8 tabFlags; /* Mask of TF_* values */
1484 u8 keyConf; /* What to do in case of uniqueness conflict on iPKey */
danielk197719a8e7e2005-03-17 05:03:38 +00001485#ifndef SQLITE_OMIT_ALTERTABLE
drh7d10d5a2008-08-20 16:35:10 +00001486 int addColOffset; /* Offset in CREATE TABLE stmt to add a new column */
danielk197719a8e7e2005-03-17 05:03:38 +00001487#endif
drhe09daa92006-06-10 13:29:31 +00001488#ifndef SQLITE_OMIT_VIRTUALTABLE
drh7d10d5a2008-08-20 16:35:10 +00001489 int nModuleArg; /* Number of arguments to the module */
1490 char **azModuleArg; /* Text of all module args. [0] is module name */
drhd815f172012-09-13 14:42:43 +00001491 VTable *pVTable; /* List of VTable objects. */
drhe09daa92006-06-10 13:29:31 +00001492#endif
danielk19772f886d12009-02-28 10:47:41 +00001493 Trigger *pTrigger; /* List of triggers stored in pSchema */
drh7d10d5a2008-08-20 16:35:10 +00001494 Schema *pSchema; /* Schema that contains this table */
drh588a9a12008-09-01 15:52:10 +00001495 Table *pNextZombie; /* Next on the Parse.pZombieTab list */
drh75897232000-05-29 14:26:00 +00001496};
1497
1498/*
dan8ce71842014-01-14 20:14:09 +00001499** Allowed values for Table.tabFlags.
drh7d10d5a2008-08-20 16:35:10 +00001500*/
1501#define TF_Readonly 0x01 /* Read-only system table */
shane467bcf32008-11-24 20:01:32 +00001502#define TF_Ephemeral 0x02 /* An ephemeral table */
drh7d10d5a2008-08-20 16:35:10 +00001503#define TF_HasPrimaryKey 0x04 /* Table has a primary key */
1504#define TF_Autoincrement 0x08 /* Integer primary key is autoincrement */
1505#define TF_Virtual 0x10 /* Is a virtual table */
drh81eba732013-10-19 23:31:56 +00001506#define TF_WithoutRowid 0x20 /* No rowid used. PRIMARY KEY is the key */
drh7d10d5a2008-08-20 16:35:10 +00001507
1508
1509/*
drh4cbdda92006-06-14 19:00:20 +00001510** Test to see whether or not a table is a virtual table. This is
1511** done as a macro so that it will be optimized out when virtual
1512** table support is omitted from the build.
1513*/
1514#ifndef SQLITE_OMIT_VIRTUALTABLE
drh7d10d5a2008-08-20 16:35:10 +00001515# define IsVirtual(X) (((X)->tabFlags & TF_Virtual)!=0)
drha371ace2012-09-13 14:22:47 +00001516# define IsHiddenColumn(X) (((X)->colFlags & COLFLAG_HIDDEN)!=0)
drh4cbdda92006-06-14 19:00:20 +00001517#else
danielk1977034ca142007-06-26 10:38:54 +00001518# define IsVirtual(X) 0
1519# define IsHiddenColumn(X) 0
drh4cbdda92006-06-14 19:00:20 +00001520#endif
1521
drhec95c442013-10-23 01:57:32 +00001522/* Does the table have a rowid */
1523#define HasRowid(X) (((X)->tabFlags & TF_WithoutRowid)==0)
1524
drh4cbdda92006-06-14 19:00:20 +00001525/*
drhc2eef3b2002-08-31 18:53:06 +00001526** Each foreign key constraint is an instance of the following structure.
1527**
1528** A foreign key is associated with two tables. The "from" table is
1529** the table that contains the REFERENCES clause that creates the foreign
1530** key. The "to" table is the table that is named in the REFERENCES clause.
1531** Consider this example:
1532**
1533** CREATE TABLE ex1(
1534** a INTEGER PRIMARY KEY,
1535** b INTEGER CONSTRAINT fk1 REFERENCES ex2(x)
1536** );
1537**
1538** For foreign key "fk1", the from-table is "ex1" and the to-table is "ex2".
drhbd50a922013-11-03 02:27:58 +00001539** Equivalent names:
1540**
1541** from-table == child-table
1542** to-table == parent-table
drhc2eef3b2002-08-31 18:53:06 +00001543**
1544** Each REFERENCES clause generates an instance of the following structure
1545** which is attached to the from-table. The to-table need not exist when
drhe61922a2009-05-02 13:29:37 +00001546** the from-table is created. The existence of the to-table is not checked.
drhbd50a922013-11-03 02:27:58 +00001547**
1548** The list of all parents for child Table X is held at X.pFKey.
1549**
1550** A list of all children for a table named Z (which might not even exist)
1551** is held in Schema.fkeyHash with a hash key of Z.
drhc2eef3b2002-08-31 18:53:06 +00001552*/
1553struct FKey {
drh1f638ce2009-09-24 13:48:10 +00001554 Table *pFrom; /* Table containing the REFERENCES clause (aka: Child) */
drhbd50a922013-11-03 02:27:58 +00001555 FKey *pNextFrom; /* Next FKey with the same in pFrom. Next parent of pFrom */
drh1f638ce2009-09-24 13:48:10 +00001556 char *zTo; /* Name of table that the key points to (aka: Parent) */
drhbd50a922013-11-03 02:27:58 +00001557 FKey *pNextTo; /* Next with the same zTo. Next child of zTo. */
1558 FKey *pPrevTo; /* Previous with the same zTo */
drhc2eef3b2002-08-31 18:53:06 +00001559 int nCol; /* Number of columns in this key */
drh4c429832009-10-12 22:30:49 +00001560 /* EV: R-30323-21917 */
drhbd50a922013-11-03 02:27:58 +00001561 u8 isDeferred; /* True if constraint checking is deferred till COMMIT */
1562 u8 aAction[2]; /* ON DELETE and ON UPDATE actions, respectively */
1563 Trigger *apTrigger[2];/* Triggers for aAction[] actions */
1564 struct sColMap { /* Mapping of columns in pFrom to columns in zTo */
1565 int iFrom; /* Index of column in pFrom */
1566 char *zCol; /* Name of column in zTo. If NULL use PRIMARY KEY */
1567 } aCol[1]; /* One entry for each of nCol columns */
drhc2eef3b2002-08-31 18:53:06 +00001568};
1569
1570/*
danielk1977aaa40c12007-09-21 04:28:16 +00001571** SQLite supports many different ways to resolve a constraint
drh22f70c32002-02-18 01:17:00 +00001572** error. ROLLBACK processing means that a constraint violation
drh0bd1f4e2002-06-06 18:54:39 +00001573** causes the operation in process to fail and for the current transaction
drh1c928532002-01-31 15:54:21 +00001574** to be rolled back. ABORT processing means the operation in process
1575** fails and any prior changes from that one operation are backed out,
1576** but the transaction is not rolled back. FAIL processing means that
1577** the operation in progress stops and returns an error code. But prior
1578** changes due to the same operation are not backed out and no rollback
1579** occurs. IGNORE means that the particular row that caused the constraint
1580** error is not inserted or updated. Processing continues and no error
1581** is returned. REPLACE means that preexisting database rows that caused
1582** a UNIQUE constraint violation are removed so that the new insert or
1583** update can proceed. Processing continues and no error is reported.
drhc2eef3b2002-08-31 18:53:06 +00001584**
1585** RESTRICT, SETNULL, and CASCADE actions apply only to foreign keys.
1586** RESTRICT is the same as ABORT for IMMEDIATE foreign keys and the
1587** same as ROLLBACK for DEFERRED keys. SETNULL means that the foreign
1588** key is set to NULL. CASCADE means that a DELETE or UPDATE of the
1589** referenced table row is propagated into the row that holds the
1590** foreign key.
drh1c928532002-01-31 15:54:21 +00001591**
drh968af522003-02-11 14:55:40 +00001592** The following symbolic values are used to record which type
drh1c928532002-01-31 15:54:21 +00001593** of action to take.
drh9cfcf5d2002-01-29 18:41:24 +00001594*/
drh1c928532002-01-31 15:54:21 +00001595#define OE_None 0 /* There is no constraint to check */
1596#define OE_Rollback 1 /* Fail the operation and rollback the transaction */
1597#define OE_Abort 2 /* Back out changes but do no rollback transaction */
1598#define OE_Fail 3 /* Stop the operation but leave all prior changes */
1599#define OE_Ignore 4 /* Ignore the error. Do not do the INSERT or UPDATE */
1600#define OE_Replace 5 /* Delete existing record, then do INSERT or UPDATE */
drhc2eef3b2002-08-31 18:53:06 +00001601
1602#define OE_Restrict 6 /* OE_Abort for IMMEDIATE, OE_Rollback for DEFERRED */
1603#define OE_SetNull 7 /* Set the foreign key value to NULL */
1604#define OE_SetDflt 8 /* Set the foreign key value to its default */
1605#define OE_Cascade 9 /* Cascade the changes */
1606
drhc28c4e52013-10-03 19:21:41 +00001607#define OE_Default 10 /* Do whatever the default action is */
drh9cfcf5d2002-01-29 18:41:24 +00001608
drhd3d39e92004-05-20 22:16:29 +00001609
1610/*
1611** An instance of the following structure is passed as the first
1612** argument to sqlite3VdbeKeyCompare and is used to control the
1613** comparison of the two index keys.
drh323df792013-08-05 19:11:29 +00001614**
1615** Note that aSortOrder[] and aColl[] have nField+1 slots. There
1616** are nField slots for the columns of an index then one extra slot
1617** for the rowid at the end.
drhd3d39e92004-05-20 22:16:29 +00001618*/
1619struct KeyInfo {
drh2ec2fb22013-11-06 19:59:23 +00001620 u32 nRef; /* Number of references to this KeyInfo object */
drh9b8d0272010-08-09 15:44:21 +00001621 u8 enc; /* Text encoding - one of the SQLITE_UTF* values */
drhad124322013-10-23 13:30:58 +00001622 u16 nField; /* Number of key columns in the index */
drh6fbe41a2013-10-30 20:22:55 +00001623 u16 nXField; /* Number of columns beyond the key columns */
drh2ec2fb22013-11-06 19:59:23 +00001624 sqlite3 *db; /* The database connection */
drh323df792013-08-05 19:11:29 +00001625 u8 *aSortOrder; /* Sort order for each column. */
drhd3d39e92004-05-20 22:16:29 +00001626 CollSeq *aColl[1]; /* Collating sequence for each term of the key */
1627};
1628
drh9cfcf5d2002-01-29 18:41:24 +00001629/*
drhe63d9992008-08-13 19:11:48 +00001630** An instance of the following structure holds information about a
1631** single index record that has already been parsed out into individual
1632** values.
1633**
1634** A record is an object that contains one or more fields of data.
1635** Records are used to store the content of a table row and to store
1636** the key of an index. A blob encoding of a record is created by
shane467bcf32008-11-24 20:01:32 +00001637** the OP_MakeRecord opcode of the VDBE and is disassembled by the
drhe63d9992008-08-13 19:11:48 +00001638** OP_Column opcode.
1639**
1640** This structure holds a record that has already been disassembled
shane467bcf32008-11-24 20:01:32 +00001641** into its constituent fields.
dan3833e932014-03-01 19:44:56 +00001642**
1643** The r1 and r2 member variables are only used by the optimized comparison
1644** functions vdbeRecordCompareInt() and vdbeRecordCompareString().
drhe63d9992008-08-13 19:11:48 +00001645*/
1646struct UnpackedRecord {
1647 KeyInfo *pKeyInfo; /* Collation and sort-order information */
1648 u16 nField; /* Number of entries in apMem[] */
drha9e0aeb2014-03-04 00:15:16 +00001649 i8 default_rc; /* Comparison result if keys are equal */
drha1f7c0a2014-03-28 03:12:48 +00001650 u8 isCorrupt; /* Corruption detected by xRecordCompare() */
drhe63d9992008-08-13 19:11:48 +00001651 Mem *aMem; /* Values */
dan3833e932014-03-01 19:44:56 +00001652 int r1; /* Value to return if (lhs > rhs) */
1653 int r2; /* Value to return if (rhs < lhs) */
drhe63d9992008-08-13 19:11:48 +00001654};
1655
drhe63d9992008-08-13 19:11:48 +00001656
1657/*
drh66b89c82000-11-28 20:47:17 +00001658** Each SQL index is represented in memory by an
drh75897232000-05-29 14:26:00 +00001659** instance of the following structure.
drh967e8b72000-06-21 13:59:10 +00001660**
1661** The columns of the table that are to be indexed are described
1662** by the aiColumn[] field of this structure. For example, suppose
1663** we have the following table and index:
1664**
1665** CREATE TABLE Ex1(c1 int, c2 int, c3 text);
1666** CREATE INDEX Ex2 ON Ex1(c3,c1);
1667**
1668** In the Table structure describing Ex1, nCol==3 because there are
1669** three columns in the table. In the Index structure describing
1670** Ex2, nColumn==2 since 2 of the 3 columns of Ex1 are indexed.
1671** The value of aiColumn is {2, 0}. aiColumn[0]==2 because the
1672** first column to be indexed (c3) has an index of 2 in Ex1.aCol[].
1673** The second column to be indexed (c1) has an index of 0 in
1674** Ex1.aCol[], hence Ex2.aiColumn[1]==0.
drhea1ba172003-04-20 00:00:23 +00001675**
1676** The Index.onError field determines whether or not the indexed columns
1677** must be unique and what to do if they are not. When Index.onError=OE_None,
1678** it means this is not a unique index. Otherwise it is a unique index
1679** and the value of Index.onError indicate the which conflict resolution
1680** algorithm to employ whenever an attempt is made to insert a non-unique
1681** element.
drh75897232000-05-29 14:26:00 +00001682*/
1683struct Index {
drhb376dae2013-01-01 14:01:28 +00001684 char *zName; /* Name of this index */
drhbbbdc832013-10-22 18:01:40 +00001685 i16 *aiColumn; /* Which columns are used by this index. 1st is 0 */
dancfc9df72014-04-25 15:01:01 +00001686 LogEst *aiRowLogEst; /* From ANALYZE: Est. rows selected by each column */
drhb376dae2013-01-01 14:01:28 +00001687 Table *pTable; /* The SQL table being indexed */
1688 char *zColAff; /* String defining the affinity of each column */
1689 Index *pNext; /* The next index associated with the same table */
1690 Schema *pSchema; /* Schema containing this index */
1691 u8 *aSortOrder; /* for each column: True==DESC, False==ASC */
1692 char **azColl; /* Array of collation sequence names for index */
drh1fe05372013-07-31 18:12:26 +00001693 Expr *pPartIdxWhere; /* WHERE clause for partial indices */
drh2ec2fb22013-11-06 19:59:23 +00001694 KeyInfo *pKeyInfo; /* A KeyInfo object suitable for this index */
drhb376dae2013-01-01 14:01:28 +00001695 int tnum; /* DB Page containing root of this index */
drhbf539c42013-10-05 18:16:02 +00001696 LogEst szIdxRow; /* Estimated average row size in bytes */
drhbbbdc832013-10-22 18:01:40 +00001697 u16 nKeyCol; /* Number of columns forming the key */
1698 u16 nColumn; /* Number of columns stored in the index */
drhbf539c42013-10-05 18:16:02 +00001699 u8 onError; /* OE_Abort, OE_Ignore, OE_Replace, or OE_None */
drh48dd1d82014-05-27 18:18:58 +00001700 unsigned idxType:2; /* 1==UNIQUE, 2==PRIMARY KEY, 0==CREATE INDEX */
drhb376dae2013-01-01 14:01:28 +00001701 unsigned bUnordered:1; /* Use this index for == or IN queries only */
drh7699d1c2013-06-04 12:42:29 +00001702 unsigned uniqNotNull:1; /* True if UNIQUE and NOT NULL for all columns */
drh7f9c5db2013-10-23 00:32:58 +00001703 unsigned isResized:1; /* True if resizeIndexObject() has been called */
drhec95c442013-10-23 01:57:32 +00001704 unsigned isCovering:1; /* True if this is a covering index */
drh1435a9a2013-08-27 23:15:44 +00001705#ifdef SQLITE_ENABLE_STAT3_OR_STAT4
drh2b9cf662011-09-22 20:52:56 +00001706 int nSample; /* Number of elements in aSample[] */
dan8ad169a2013-08-12 20:14:04 +00001707 int nSampleCol; /* Size of IndexSample.anEq[] and so on */
daneea568d2013-08-07 19:46:15 +00001708 tRowcnt *aAvgEq; /* Average nEq values for keys not in aSample */
drhfaacf172011-08-12 01:51:45 +00001709 IndexSample *aSample; /* Samples of the left-most key */
1710#endif
dan02fa4692009-08-17 17:06:58 +00001711};
1712
1713/*
drh48dd1d82014-05-27 18:18:58 +00001714** Allowed values for Index.idxType
1715*/
1716#define SQLITE_IDXTYPE_APPDEF 0 /* Created using CREATE INDEX */
1717#define SQLITE_IDXTYPE_UNIQUE 1 /* Implements a UNIQUE constraint */
1718#define SQLITE_IDXTYPE_PRIMARYKEY 2 /* Is the PRIMARY KEY for the table */
1719
1720/* Return true if index X is a PRIMARY KEY index */
1721#define IsPrimaryKeyIndex(X) ((X)->idxType==SQLITE_IDXTYPE_PRIMARYKEY)
1722
drh5f1d1d92014-07-31 22:59:04 +00001723/* Return true if index X is a UNIQUE index */
1724#define IsUniqueIndex(X) ((X)->onError!=OE_None)
1725
drh48dd1d82014-05-27 18:18:58 +00001726/*
drh74e7c8f2011-10-21 19:06:32 +00001727** Each sample stored in the sqlite_stat3 table is represented in memory
1728** using a structure of this type. See documentation at the top of the
1729** analyze.c source file for additional information.
dan02fa4692009-08-17 17:06:58 +00001730*/
1731struct IndexSample {
danf52bb8d2013-08-03 20:24:58 +00001732 void *p; /* Pointer to sampled record */
1733 int n; /* Size of record in bytes */
1734 tRowcnt *anEq; /* Est. number of rows where the key equals this sample */
1735 tRowcnt *anLt; /* Est. number of rows where key is less than this sample */
1736 tRowcnt *anDLt; /* Est. number of distinct keys less than this sample */
drh75897232000-05-29 14:26:00 +00001737};
1738
1739/*
1740** Each token coming out of the lexer is an instance of
drh4b59ab52002-08-24 18:24:51 +00001741** this structure. Tokens are also used as part of an expression.
drh4efc4752004-01-16 15:55:37 +00001742**
1743** Note if Token.z==0 then Token.dyn and Token.n are undefined and
shane467bcf32008-11-24 20:01:32 +00001744** may contain random values. Do not make any assumptions about Token.dyn
drh4efc4752004-01-16 15:55:37 +00001745** and Token.n when Token.z==0.
drh75897232000-05-29 14:26:00 +00001746*/
1747struct Token {
drhb7916a72009-05-27 10:31:29 +00001748 const char *z; /* Text of the token. Not NULL-terminated! */
1749 unsigned int n; /* Number of characters in this token */
drh75897232000-05-29 14:26:00 +00001750};
1751
1752/*
drh13449892005-09-07 21:22:45 +00001753** An instance of this structure contains information needed to generate
1754** code for a SELECT that contains aggregate functions.
1755**
1756** If Expr.op==TK_AGG_COLUMN or TK_AGG_FUNCTION then Expr.pAggInfo is a
1757** pointer to this structure. The Expr.iColumn field is the index in
1758** AggInfo.aCol[] or AggInfo.aFunc[] of information needed to generate
1759** code for that node.
1760**
1761** AggInfo.pGroupBy and AggInfo.aFunc.pExpr point to fields within the
1762** original Select structure that describes the SELECT statement. These
1763** fields do not need to be freed when deallocating the AggInfo structure.
1764*/
1765struct AggInfo {
1766 u8 directMode; /* Direct rendering mode means take data directly
1767 ** from source tables rather than from accumulators */
1768 u8 useSortingIdx; /* In direct mode, reference the sorting index rather
1769 ** than the source table */
1770 int sortingIdx; /* Cursor number of the sorting index */
dan5134d132011-09-02 10:31:11 +00001771 int sortingIdxPTab; /* Cursor number of pseudo-table */
drh13449892005-09-07 21:22:45 +00001772 int nSortingColumn; /* Number of columns in the sorting index */
drh7e61d182013-12-20 13:11:45 +00001773 int mnReg, mxReg; /* Range of registers allocated for aCol and aFunc */
drha4510172012-02-02 15:50:17 +00001774 ExprList *pGroupBy; /* The group by clause */
drh13449892005-09-07 21:22:45 +00001775 struct AggInfo_col { /* For each column used in source tables */
danielk19770817d0d2007-02-14 09:19:36 +00001776 Table *pTab; /* Source table */
drh13449892005-09-07 21:22:45 +00001777 int iTable; /* Cursor number of the source table */
1778 int iColumn; /* Column number within the source table */
1779 int iSorterColumn; /* Column number in the sorting index */
1780 int iMem; /* Memory location that acts as accumulator */
drh5774b802005-09-07 22:48:16 +00001781 Expr *pExpr; /* The original expression */
drh13449892005-09-07 21:22:45 +00001782 } *aCol;
1783 int nColumn; /* Number of used entries in aCol[] */
drh13449892005-09-07 21:22:45 +00001784 int nAccumulator; /* Number of columns that show through to the output.
1785 ** Additional columns are used only as parameters to
1786 ** aggregate functions */
1787 struct AggInfo_func { /* For each aggregate function */
1788 Expr *pExpr; /* Expression encoding the function */
1789 FuncDef *pFunc; /* The aggregate function implementation */
1790 int iMem; /* Memory location that acts as accumulator */
shane467bcf32008-11-24 20:01:32 +00001791 int iDistinct; /* Ephemeral table used to enforce DISTINCT */
drh13449892005-09-07 21:22:45 +00001792 } *aFunc;
1793 int nFunc; /* Number of entries in aFunc[] */
drh13449892005-09-07 21:22:45 +00001794};
1795
1796/*
drh8677d302009-11-04 13:17:14 +00001797** The datatype ynVar is a signed integer, either 16-bit or 32-bit.
1798** Usually it is 16-bits. But if SQLITE_MAX_VARIABLE_NUMBER is greater
1799** than 32767 we have to make it 32-bit. 16-bit is preferred because
1800** it uses less memory in the Expr object, which is a big memory user
1801** in systems with lots of prepared statements. And few applications
1802** need more than about 10 or 20 variables. But some extreme users want
1803** to have prepared statements with over 32767 variables, and for them
1804** the option is available (at compile-time).
1805*/
1806#if SQLITE_MAX_VARIABLE_NUMBER<=32767
drh481aa742009-11-05 18:46:02 +00001807typedef i16 ynVar;
drh8677d302009-11-04 13:17:14 +00001808#else
1809typedef int ynVar;
1810#endif
1811
1812/*
drh75897232000-05-29 14:26:00 +00001813** Each node of an expression in the parse tree is an instance
drh22f70c32002-02-18 01:17:00 +00001814** of this structure.
1815**
danielk19776ab3a2e2009-02-19 14:39:25 +00001816** Expr.op is the opcode. The integer parser token codes are reused
1817** as opcodes here. For example, the parser defines TK_GE to be an integer
1818** code representing the ">=" operator. This same integer code is reused
drh22f70c32002-02-18 01:17:00 +00001819** to represent the greater-than-or-equal-to operator in the expression
1820** tree.
1821**
danielk19776ab3a2e2009-02-19 14:39:25 +00001822** If the expression is an SQL literal (TK_INTEGER, TK_FLOAT, TK_BLOB,
1823** or TK_STRING), then Expr.token contains the text of the SQL literal. If
1824** the expression is a variable (TK_VARIABLE), then Expr.token contains the
1825** variable name. Finally, if the expression is an SQL function (TK_FUNCTION),
1826** then Expr.token contains the name of the function.
drh22f70c32002-02-18 01:17:00 +00001827**
danielk19776ab3a2e2009-02-19 14:39:25 +00001828** Expr.pRight and Expr.pLeft are the left and right subexpressions of a
1829** binary operator. Either or both may be NULL.
1830**
1831** Expr.x.pList is a list of arguments if the expression is an SQL function,
1832** a CASE expression or an IN expression of the form "<lhs> IN (<y>, <z>...)".
1833** Expr.x.pSelect is used if the expression is a sub-select or an expression of
1834** the form "<lhs> IN (SELECT ...)". If the EP_xIsSelect bit is set in the
1835** Expr.flags mask, then Expr.x.pSelect is valid. Otherwise, Expr.x.pList is
1836** valid.
drh22f70c32002-02-18 01:17:00 +00001837**
1838** An expression of the form ID or ID.ID refers to a column in a table.
1839** For such expressions, Expr.op is set to TK_COLUMN and Expr.iTable is
1840** the integer cursor number of a VDBE cursor pointing to that table and
1841** Expr.iColumn is the column number for the specific column. If the
1842** expression is used as a result in an aggregate SELECT, then the
1843** value is also stored in the Expr.iAgg column in the aggregate so that
1844** it can be accessed after all aggregates are computed.
1845**
danielk19776ab3a2e2009-02-19 14:39:25 +00001846** If the expression is an unbound variable marker (a question mark
1847** character '?' in the original SQL) then the Expr.iTable holds the index
1848** number for that variable.
drh22f70c32002-02-18 01:17:00 +00001849**
drh1398ad32005-01-19 23:24:50 +00001850** If the expression is a subquery then Expr.iColumn holds an integer
1851** register number containing the result of the subquery. If the
1852** subquery gives a constant result, then iTable is -1. If the subquery
1853** gives a different answer at different times during statement processing
1854** then iTable is the address of a subroutine that computes the subquery.
1855**
danielk1977aee18ef2005-03-09 12:26:50 +00001856** If the Expr is of type OP_Column, and the table it is selecting from
1857** is a disk table or the "old.*" pseudo-table, then pTab points to the
1858** corresponding table definition.
danielk19776ab3a2e2009-02-19 14:39:25 +00001859**
1860** ALLOCATION NOTES:
1861**
drh12ffee82009-04-08 13:51:51 +00001862** Expr objects can use a lot of memory space in database schema. To
1863** help reduce memory requirements, sometimes an Expr object will be
1864** truncated. And to reduce the number of memory allocations, sometimes
1865** two or more Expr objects will be stored in a single memory allocation,
drh33e619f2009-05-28 01:00:55 +00001866** together with Expr.zToken strings.
danielk19776ab3a2e2009-02-19 14:39:25 +00001867**
drhb7916a72009-05-27 10:31:29 +00001868** If the EP_Reduced and EP_TokenOnly flags are set when
drh12ffee82009-04-08 13:51:51 +00001869** an Expr object is truncated. When EP_Reduced is set, then all
1870** the child Expr objects in the Expr.pLeft and Expr.pRight subtrees
1871** are contained within the same memory allocation. Note, however, that
1872** the subtrees in Expr.x.pList or Expr.x.pSelect are always separately
1873** allocated, regardless of whether or not EP_Reduced is set.
drh75897232000-05-29 14:26:00 +00001874*/
1875struct Expr {
drh1cc093c2002-06-24 22:01:57 +00001876 u8 op; /* Operation performed by this node */
drha9fd84b2004-05-18 23:21:35 +00001877 char affinity; /* The affinity of the column or 0 if not a column */
drhc5cd1242013-09-12 16:50:49 +00001878 u32 flags; /* Various flags. EP_* See below */
drh33e619f2009-05-28 01:00:55 +00001879 union {
1880 char *zToken; /* Token value. Zero terminated and dequoted */
drhd50ffc42011-03-08 02:38:28 +00001881 int iValue; /* Non-negative integer value if EP_IntValue */
drh33e619f2009-05-28 01:00:55 +00001882 } u;
danielk19776ab3a2e2009-02-19 14:39:25 +00001883
1884 /* If the EP_TokenOnly flag is set in the Expr.flags mask, then no
1885 ** space is allocated for the fields below this point. An attempt to
1886 ** access them will result in a segfault or malfunction.
1887 *********************************************************************/
1888
danielk19776ab3a2e2009-02-19 14:39:25 +00001889 Expr *pLeft; /* Left subnode */
1890 Expr *pRight; /* Right subnode */
1891 union {
drhc5cd1242013-09-12 16:50:49 +00001892 ExprList *pList; /* op = IN, EXISTS, SELECT, CASE, FUNCTION, BETWEEN */
1893 Select *pSelect; /* EP_xIsSelect and op = IN, EXISTS, SELECT */
danielk19776ab3a2e2009-02-19 14:39:25 +00001894 } x;
danielk19776ab3a2e2009-02-19 14:39:25 +00001895
1896 /* If the EP_Reduced flag is set in the Expr.flags mask, then no
1897 ** space is allocated for the fields below this point. An attempt to
1898 ** access them will result in a segfault or malfunction.
1899 *********************************************************************/
1900
drh6ec65492012-09-13 19:59:09 +00001901#if SQLITE_MAX_EXPR_DEPTH>0
1902 int nHeight; /* Height of the tree headed by this node */
1903#endif
drhb7916a72009-05-27 10:31:29 +00001904 int iTable; /* TK_COLUMN: cursor number of table holding column
dan2832ad42009-08-31 15:27:27 +00001905 ** TK_REGISTER: register number
drhcca9f3d2013-09-06 15:23:29 +00001906 ** TK_TRIGGER: 1 -> new, 0 -> old
drha4c3c872013-09-12 17:29:25 +00001907 ** EP_Unlikely: 1000 times likelihood */
drh8677d302009-11-04 13:17:14 +00001908 ynVar iColumn; /* TK_COLUMN: column index. -1 for rowid.
dan937d0de2009-10-15 18:35:38 +00001909 ** TK_VARIABLE: variable number (always >= 1). */
drhb7916a72009-05-27 10:31:29 +00001910 i16 iAgg; /* Which entry in pAggInfo->aCol[] or ->aFunc[] */
1911 i16 iRightJoinTable; /* If EP_FromJoin, the right table of the join */
drh030796d2012-08-23 16:18:10 +00001912 u8 op2; /* TK_REGISTER: original value of Expr.op
1913 ** TK_COLUMN: the value of p5 for OP_Column
1914 ** TK_AGG_FUNCTION: nesting depth */
drh13449892005-09-07 21:22:45 +00001915 AggInfo *pAggInfo; /* Used by TK_AGG_COLUMN and TK_AGG_FUNCTION */
drh7d10d5a2008-08-20 16:35:10 +00001916 Table *pTab; /* Table for TK_COLUMN expressions. */
drh75897232000-05-29 14:26:00 +00001917};
1918
1919/*
drh1f162302002-10-27 19:35:33 +00001920** The following are the meanings of bits in the Expr.flags field.
1921*/
drhc5cd1242013-09-12 16:50:49 +00001922#define EP_FromJoin 0x000001 /* Originated in ON or USING clause of a join */
1923#define EP_Agg 0x000002 /* Contains one or more aggregate functions */
1924#define EP_Resolved 0x000004 /* IDs have been resolved to COLUMNs */
1925#define EP_Error 0x000008 /* Expression contains one or more errors */
1926#define EP_Distinct 0x000010 /* Aggregate function with DISTINCT keyword */
1927#define EP_VarSelect 0x000020 /* pSelect is correlated, not constant */
1928#define EP_DblQuoted 0x000040 /* token.z was originally in "..." */
1929#define EP_InfixFunc 0x000080 /* True for an infix function: LIKE, GLOB, etc */
drhfbb24d12014-03-20 17:03:30 +00001930#define EP_Collate 0x000100 /* Tree contains a TK_COLLATE operator */
1931#define EP_Generic 0x000200 /* Ignore COLLATE or affinity on this tree */
drhc5cd1242013-09-12 16:50:49 +00001932#define EP_IntValue 0x000400 /* Integer value contained in u.iValue */
1933#define EP_xIsSelect 0x000800 /* x.pSelect is valid (otherwise x.pList is) */
drha4c3c872013-09-12 17:29:25 +00001934#define EP_Skip 0x001000 /* COLLATE, AS, or UNLIKELY */
drhc5cd1242013-09-12 16:50:49 +00001935#define EP_Reduced 0x002000 /* Expr struct EXPR_REDUCEDSIZE bytes only */
1936#define EP_TokenOnly 0x004000 /* Expr struct EXPR_TOKENONLYSIZE bytes only */
1937#define EP_Static 0x008000 /* Held in memory not obtained from malloc() */
1938#define EP_MemToken 0x010000 /* Need to sqlite3DbFree() Expr.zToken */
drhebb6a652013-09-12 23:42:22 +00001939#define EP_NoReduce 0x020000 /* Cannot EXPRDUP_REDUCE this Expr */
drha4c3c872013-09-12 17:29:25 +00001940#define EP_Unlikely 0x040000 /* unlikely() or likelihood() function */
drhb1fba282013-11-21 14:33:48 +00001941#define EP_Constant 0x080000 /* Node is a constant */
drh33e619f2009-05-28 01:00:55 +00001942
1943/*
drh1f162302002-10-27 19:35:33 +00001944** These macros can be used to test, set, or clear bits in the
1945** Expr.flags field.
1946*/
drhc5cd1242013-09-12 16:50:49 +00001947#define ExprHasProperty(E,P) (((E)->flags&(P))!=0)
1948#define ExprHasAllProperty(E,P) (((E)->flags&(P))==(P))
drh1f162302002-10-27 19:35:33 +00001949#define ExprSetProperty(E,P) (E)->flags|=(P)
1950#define ExprClearProperty(E,P) (E)->flags&=~(P)
1951
drhebb6a652013-09-12 23:42:22 +00001952/* The ExprSetVVAProperty() macro is used for Verification, Validation,
1953** and Accreditation only. It works like ExprSetProperty() during VVA
1954** processes but is a no-op for delivery.
1955*/
1956#ifdef SQLITE_DEBUG
1957# define ExprSetVVAProperty(E,P) (E)->flags|=(P)
1958#else
1959# define ExprSetVVAProperty(E,P)
1960#endif
1961
drh1f162302002-10-27 19:35:33 +00001962/*
danielk19776ab3a2e2009-02-19 14:39:25 +00001963** Macros to determine the number of bytes required by a normal Expr
1964** struct, an Expr struct with the EP_Reduced flag set in Expr.flags
1965** and an Expr struct with the EP_TokenOnly flag set.
1966*/
drh12ffee82009-04-08 13:51:51 +00001967#define EXPR_FULLSIZE sizeof(Expr) /* Full size */
1968#define EXPR_REDUCEDSIZE offsetof(Expr,iTable) /* Common features */
drhb7916a72009-05-27 10:31:29 +00001969#define EXPR_TOKENONLYSIZE offsetof(Expr,pLeft) /* Fewer features */
danielk19776ab3a2e2009-02-19 14:39:25 +00001970
1971/*
1972** Flags passed to the sqlite3ExprDup() function. See the header comment
1973** above sqlite3ExprDup() for details.
1974*/
drh12ffee82009-04-08 13:51:51 +00001975#define EXPRDUP_REDUCE 0x0001 /* Used reduced-size Expr nodes */
danielk19776ab3a2e2009-02-19 14:39:25 +00001976
1977/*
drh75897232000-05-29 14:26:00 +00001978** A list of expressions. Each expression may optionally have a
1979** name. An expr/name combination can be used in several ways, such
1980** as the list of "expr AS ID" fields following a "SELECT" or in the
1981** list of "ID = expr" items in an UPDATE. A list of expressions can
drhad3cab52002-05-24 02:04:32 +00001982** also be used as the argument to a function, in which case the a.zName
drh75897232000-05-29 14:26:00 +00001983** field is not used.
drh0dde4732012-12-19 13:41:03 +00001984**
1985** By default the Expr.zSpan field holds a human-readable description of
1986** the expression that is used in the generation of error messages and
1987** column labels. In this case, Expr.zSpan is typically the text of a
1988** column expression as it exists in a SELECT statement. However, if
1989** the bSpanIsTab flag is set, then zSpan is overloaded to mean the name
drh3e3f1a52013-01-03 00:45:56 +00001990** of the result column in the form: DATABASE.TABLE.COLUMN. This later
1991** form is used for name resolution with nested FROM clauses.
drh75897232000-05-29 14:26:00 +00001992*/
1993struct ExprList {
1994 int nExpr; /* Number of expressions on the list */
drhd872bb12012-02-02 01:58:08 +00001995 struct ExprList_item { /* For each expression in the list */
drh0dde4732012-12-19 13:41:03 +00001996 Expr *pExpr; /* The list of expressions */
1997 char *zName; /* Token associated with this expression */
1998 char *zSpan; /* Original text of the expression */
1999 u8 sortOrder; /* 1 for DESC or 0 for ASC */
2000 unsigned done :1; /* A flag to indicate when processing is finished */
drh3e3f1a52013-01-03 00:45:56 +00002001 unsigned bSpanIsTab :1; /* zSpan holds DB.TABLE.COLUMN */
drhd673cdd2013-11-21 21:23:31 +00002002 unsigned reusable :1; /* Constant expression is reusable */
drhc2acc4e2013-11-15 18:15:19 +00002003 union {
2004 struct {
2005 u16 iOrderByCol; /* For ORDER BY, column number in result set */
2006 u16 iAlias; /* Index into Parse.aAlias[] for zName */
2007 } x;
2008 int iConstExprReg; /* Register in which Expr value is cached */
2009 } u;
drhd872bb12012-02-02 01:58:08 +00002010 } *a; /* Alloc a power of two greater or equal to nExpr */
drh75897232000-05-29 14:26:00 +00002011};
2012
2013/*
drhb7916a72009-05-27 10:31:29 +00002014** An instance of this structure is used by the parser to record both
2015** the parse tree for an expression and the span of input text for an
2016** expression.
2017*/
2018struct ExprSpan {
2019 Expr *pExpr; /* The expression parse tree */
2020 const char *zStart; /* First character of input text */
2021 const char *zEnd; /* One character past the end of input text */
2022};
2023
2024/*
drhad3cab52002-05-24 02:04:32 +00002025** An instance of this structure can hold a simple list of identifiers,
2026** such as the list "a,b,c" in the following statements:
2027**
2028** INSERT INTO t(a,b,c) VALUES ...;
2029** CREATE INDEX idx ON t(a,b,c);
2030** CREATE TRIGGER trig BEFORE UPDATE ON t(a,b,c) ...;
2031**
2032** The IdList.a.idx field is used when the IdList represents the list of
2033** column names after a table name in an INSERT statement. In the statement
2034**
2035** INSERT INTO t(a,b,c) ...
2036**
2037** If "a" is the k-th column of table "t", then IdList.a[0].idx==k.
drh75897232000-05-29 14:26:00 +00002038*/
2039struct IdList {
drh6d4abfb2001-10-22 02:58:08 +00002040 struct IdList_item {
drhad3cab52002-05-24 02:04:32 +00002041 char *zName; /* Name of the identifier */
drh967e8b72000-06-21 13:59:10 +00002042 int idx; /* Index in some Table.aCol[] of a column named zName */
drhad3cab52002-05-24 02:04:32 +00002043 } *a;
drh13449892005-09-07 21:22:45 +00002044 int nId; /* Number of identifiers on the list */
drhad3cab52002-05-24 02:04:32 +00002045};
2046
2047/*
drh51669862004-12-18 18:40:26 +00002048** The bitmask datatype defined below is used for various optimizations.
drhca83ac52007-02-01 01:40:44 +00002049**
2050** Changing this from a 64-bit to a 32-bit type limits the number of
2051** tables in a join to 32 instead of 64. But it also reduces the size
2052** of the library by 738 bytes on ix86.
drh51669862004-12-18 18:40:26 +00002053*/
drhca83ac52007-02-01 01:40:44 +00002054typedef u64 Bitmask;
drh51669862004-12-18 18:40:26 +00002055
2056/*
danielk197700e13612008-11-17 19:18:54 +00002057** The number of bits in a Bitmask. "BMS" means "BitMask Size".
2058*/
2059#define BMS ((int)(sizeof(Bitmask)*8))
2060
2061/*
drh7699d1c2013-06-04 12:42:29 +00002062** A bit in a Bitmask
2063*/
2064#define MASKBIT(n) (((Bitmask)1)<<(n))
drh693e6712014-01-24 22:58:00 +00002065#define MASKBIT32(n) (((unsigned int)1)<<(n))
drh7699d1c2013-06-04 12:42:29 +00002066
2067/*
drhad3cab52002-05-24 02:04:32 +00002068** The following structure describes the FROM clause of a SELECT statement.
2069** Each table or subquery in the FROM clause is a separate element of
2070** the SrcList.a[] array.
drhd24cc422003-03-27 12:51:24 +00002071**
2072** With the addition of multiple database support, the following structure
2073** can also be used to describe a particular table such as the table that
2074** is modified by an INSERT, DELETE, or UPDATE statement. In standard SQL,
2075** such a table must be a simple name: ID. But in SQLite, the table can
2076** now be identified by a database name, a dot, then the table name: ID.ID.
drhc49de5d2007-01-19 01:06:01 +00002077**
2078** The jointype starts out showing the join type between the current table
2079** and the next table on the list. The parser builds the list this way.
2080** But sqlite3SrcListShiftJoinType() later shifts the jointypes so that each
2081** jointype expresses the join between the table and the previous table.
drh2a6a7ee2010-04-07 14:33:07 +00002082**
2083** In the colUsed field, the high-order bit (bit 63) is set if the table
2084** contains more than 63 columns and the 64-th or later column is used.
drhad3cab52002-05-24 02:04:32 +00002085*/
2086struct SrcList {
drh6d1626e2014-03-05 15:52:43 +00002087 int nSrc; /* Number of tables or subqueries in the FROM clause */
2088 u32 nAlloc; /* Number of entries allocated in a[] below */
drhad3cab52002-05-24 02:04:32 +00002089 struct SrcList_item {
dan41fb5cd2012-10-04 19:33:00 +00002090 Schema *pSchema; /* Schema to which this item is fixed */
drh113088e2003-03-20 01:16:58 +00002091 char *zDatabase; /* Name of database holding this table */
drhad3cab52002-05-24 02:04:32 +00002092 char *zName; /* Name of the table */
2093 char *zAlias; /* The "B" part of a "A AS B" phrase. zName is the "A" */
drhdaffd0e2001-04-11 14:28:42 +00002094 Table *pTab; /* An SQL table corresponding to zName */
2095 Select *pSelect; /* A SELECT statement used in place of a table name */
drh5b6a9ed2011-09-15 23:58:14 +00002096 int addrFillSub; /* Address of subroutine to manifest a subquery */
2097 int regReturn; /* Register holding return address of addrFillSub */
drh5f612292014-02-08 23:20:32 +00002098 int regResult; /* Registers holding results of a co-routine */
drhc49de5d2007-01-19 01:06:01 +00002099 u8 jointype; /* Type of join between this able and the previous */
drh21172c42012-10-30 00:29:07 +00002100 unsigned notIndexed :1; /* True if there is a NOT INDEXED clause */
2101 unsigned isCorrelated :1; /* True if sub-query is correlated */
2102 unsigned viaCoroutine :1; /* Implemented as a co-routine */
danf43fe6e2014-01-15 18:12:00 +00002103 unsigned isRecursive :1; /* True for recursive reference in WITH */
dance7e1892010-12-01 19:00:48 +00002104#ifndef SQLITE_OMIT_EXPLAIN
2105 u8 iSelectId; /* If pSelect!=0, the id of the sub-select in EQP */
2106#endif
drhe68fbe72007-02-13 12:49:24 +00002107 int iCursor; /* The VDBE cursor number used to access this table */
drhad3cab52002-05-24 02:04:32 +00002108 Expr *pOn; /* The ON clause of a join */
2109 IdList *pUsing; /* The USING clause of a join */
danielk1977cd38d522009-01-02 17:33:46 +00002110 Bitmask colUsed; /* Bit N (1<<N) set if column N of pTab is used */
danielk197785574e32008-10-06 05:32:18 +00002111 char *zIndex; /* Identifier from "INDEXED BY <zIndex>" clause */
2112 Index *pIndex; /* Index structure corresponding to zIndex, if any */
drh113088e2003-03-20 01:16:58 +00002113 } a[1]; /* One entry for each identifier on the list */
drh75897232000-05-29 14:26:00 +00002114};
2115
2116/*
drh01f3f252002-05-24 16:14:15 +00002117** Permitted values of the SrcList.a.jointype field
2118*/
2119#define JT_INNER 0x0001 /* Any kind of inner or cross join */
drh3dec2232005-09-10 15:28:09 +00002120#define JT_CROSS 0x0002 /* Explicit use of the CROSS keyword */
2121#define JT_NATURAL 0x0004 /* True for a "natural" join */
2122#define JT_LEFT 0x0008 /* Left outer join */
2123#define JT_RIGHT 0x0010 /* Right outer join */
2124#define JT_OUTER 0x0020 /* The "OUTER" keyword is present */
2125#define JT_ERROR 0x0040 /* unknown or unsupported join type */
drh01f3f252002-05-24 16:14:15 +00002126
drh111a6a72008-12-21 03:51:16 +00002127
2128/*
drh336a5302009-04-24 15:46:21 +00002129** Flags appropriate for the wctrlFlags parameter of sqlite3WhereBegin()
2130** and the WhereInfo.wctrlFlags member.
drh08c88eb2008-04-10 13:33:18 +00002131*/
drh6df2acd2008-12-28 16:55:25 +00002132#define WHERE_ORDERBY_NORMAL 0x0000 /* No-op */
2133#define WHERE_ORDERBY_MIN 0x0001 /* ORDER BY processing for min() func */
2134#define WHERE_ORDERBY_MAX 0x0002 /* ORDER BY processing for max() func */
2135#define WHERE_ONEPASS_DESIRED 0x0004 /* Want to do one-pass UPDATE/DELETE */
drh336a5302009-04-24 15:46:21 +00002136#define WHERE_DUPLICATES_OK 0x0008 /* Ok to return a row more than once */
drh9ef61f42011-10-07 14:40:59 +00002137#define WHERE_OMIT_OPEN_CLOSE 0x0010 /* Table cursors are already open */
2138#define WHERE_FORCE_TABLE 0x0020 /* Do not use an index-only search */
2139#define WHERE_ONETABLE_ONLY 0x0040 /* Only code the 1st table in pTabList */
2140#define WHERE_AND_ONLY 0x0080 /* Don't use indices for OR terms */
drh319f6772013-05-14 15:31:07 +00002141#define WHERE_GROUPBY 0x0100 /* pOrderBy is really a GROUP BY */
drh4f402f22013-06-11 18:59:38 +00002142#define WHERE_DISTINCTBY 0x0200 /* pOrderby is really a DISTINCT clause */
drh6457a352013-06-21 00:35:37 +00002143#define WHERE_WANT_DISTINCT 0x0400 /* All output needs to be distinct */
dan374cd782014-04-21 13:21:56 +00002144#define WHERE_SORTBYGROUP 0x0800 /* Support sqlite3WhereIsSorted() */
drh35263192014-07-22 20:02:19 +00002145#define WHERE_REOPEN_IDX 0x1000 /* Try to use OP_ReopenIdx */
danielk1977a9d1ccb2008-01-05 17:39:29 +00002146
drh4f402f22013-06-11 18:59:38 +00002147/* Allowed return values from sqlite3WhereIsDistinct()
2148*/
drhe8e4af72012-09-21 00:04:28 +00002149#define WHERE_DISTINCT_NOOP 0 /* DISTINCT keyword not used */
2150#define WHERE_DISTINCT_UNIQUE 1 /* No duplicates */
2151#define WHERE_DISTINCT_ORDERED 2 /* All duplicates are adjacent */
2152#define WHERE_DISTINCT_UNORDERED 3 /* Duplicates are scattered */
dan38cc40c2011-06-30 20:17:15 +00002153
drh75897232000-05-29 14:26:00 +00002154/*
danielk1977b3bce662005-01-29 08:32:43 +00002155** A NameContext defines a context in which to resolve table and column
2156** names. The context consists of a list of tables (the pSrcList) field and
2157** a list of named expression (pEList). The named expression list may
2158** be NULL. The pSrc corresponds to the FROM clause of a SELECT or
2159** to the table being operated on by INSERT, UPDATE, or DELETE. The
2160** pEList corresponds to the result set of a SELECT and is NULL for
2161** other statements.
2162**
2163** NameContexts can be nested. When resolving names, the inner-most
2164** context is searched first. If no match is found, the next outer
2165** context is checked. If there is still no match, the next context
2166** is checked. This process continues until either a match is found
2167** or all contexts are check. When a match is found, the nRef member of
2168** the context containing the match is incremented.
2169**
2170** Each subquery gets a new NameContext. The pNext field points to the
2171** NameContext in the parent query. Thus the process of scanning the
2172** NameContext list corresponds to searching through successively outer
2173** subqueries looking for a match.
2174*/
2175struct NameContext {
2176 Parse *pParse; /* The parser */
2177 SrcList *pSrcList; /* One or more tables used to resolve names */
drh26080d92013-08-15 14:27:42 +00002178 ExprList *pEList; /* Optional list of result-set columns */
drh13449892005-09-07 21:22:45 +00002179 AggInfo *pAggInfo; /* Information about aggregates at this level */
danielk1977b3bce662005-01-29 08:32:43 +00002180 NameContext *pNext; /* Next outer name context. NULL for outermost */
drha51009b2012-05-21 19:11:25 +00002181 int nRef; /* Number of names resolved by this context */
2182 int nErr; /* Number of errors encountered while resolving names */
2183 u8 ncFlags; /* Zero or more NC_* flags defined below */
danielk1977b3bce662005-01-29 08:32:43 +00002184};
2185
2186/*
drha51009b2012-05-21 19:11:25 +00002187** Allowed values for the NameContext, ncFlags field.
2188*/
2189#define NC_AllowAgg 0x01 /* Aggregate functions are allowed here */
2190#define NC_HasAgg 0x02 /* One or more aggregate functions seen */
2191#define NC_IsCheck 0x04 /* True if resolving names in a CHECK constraint */
drh3a8c4be2012-05-21 20:13:39 +00002192#define NC_InAggFunc 0x08 /* True if analyzing arguments to an agg func */
drhe35463b2013-08-15 20:24:27 +00002193#define NC_PartIdx 0x10 /* True if resolving a partial index WHERE */
drha51009b2012-05-21 19:11:25 +00002194
2195/*
drh9bb61fe2000-06-05 16:01:39 +00002196** An instance of the following structure contains all information
2197** needed to generate code for a single SELECT statement.
drha76b5df2002-02-23 02:32:10 +00002198**
drhd11d3822002-06-21 23:01:49 +00002199** nLimit is set to -1 if there is no LIMIT clause. nOffset is set to 0.
2200** If there is a LIMIT clause, the parser sets nLimit to the value of the
2201** limit and nOffset to the value of the offset (or 0 if there is not
2202** offset). But later on, nLimit and nOffset become the memory locations
2203** in the VDBE that record the limit and offset counters.
drh0342b1f2005-09-01 03:07:44 +00002204**
drhb9bb7c12006-06-11 23:41:55 +00002205** addrOpenEphm[] entries contain the address of OP_OpenEphemeral opcodes.
drh0342b1f2005-09-01 03:07:44 +00002206** These addresses must be stored so that we can go back and fill in
drh66a51672008-01-03 00:01:23 +00002207** the P4_KEYINFO and P2 parameters later. Neither the KeyInfo nor
drh0342b1f2005-09-01 03:07:44 +00002208** the number of columns in P2 can be computed at the same time
drhb9bb7c12006-06-11 23:41:55 +00002209** as the OP_OpenEphm instruction is coded because not
drh0342b1f2005-09-01 03:07:44 +00002210** enough information about the compound query is known at that point.
drhb9bb7c12006-06-11 23:41:55 +00002211** The KeyInfo for addrOpenTran[0] and [1] contains collating sequences
drh2c797332012-09-20 14:26:22 +00002212** for the result set. The KeyInfo for addrOpenEphm[2] contains collating
drh0342b1f2005-09-01 03:07:44 +00002213** sequences for the ORDER BY clause.
drh9bb61fe2000-06-05 16:01:39 +00002214*/
2215struct Select {
drh9bb61fe2000-06-05 16:01:39 +00002216 ExprList *pEList; /* The fields of the result */
drh7b58dae2003-07-20 01:16:46 +00002217 u8 op; /* One of: TK_UNION TK_ALL TK_INTERSECT TK_EXCEPT */
drh7d10d5a2008-08-20 16:35:10 +00002218 u16 selFlags; /* Various SF_* values */
drha4510172012-02-02 15:50:17 +00002219 int iLimit, iOffset; /* Memory registers holding LIMIT & OFFSET counters */
drh079a3072014-03-19 14:10:55 +00002220 int addrOpenEphm[2]; /* OP_OpenEphem opcodes related to this select */
drhc63367e2013-06-10 20:46:50 +00002221 u64 nSelectRow; /* Estimated number of result rows */
drhad3cab52002-05-24 02:04:32 +00002222 SrcList *pSrc; /* The FROM clause */
drh9bb61fe2000-06-05 16:01:39 +00002223 Expr *pWhere; /* The WHERE clause */
2224 ExprList *pGroupBy; /* The GROUP BY clause */
2225 Expr *pHaving; /* The HAVING clause */
2226 ExprList *pOrderBy; /* The ORDER BY clause */
drh967e8b72000-06-21 13:59:10 +00002227 Select *pPrior; /* Prior select in a compound select statement */
drh1e281292007-12-13 03:45:07 +00002228 Select *pNext; /* Next select to the left in a compound */
danielk1977a2dc3b12005-02-05 12:48:48 +00002229 Expr *pLimit; /* LIMIT expression. NULL means not used. */
2230 Expr *pOffset; /* OFFSET expression. NULL means not used. */
dan4e9119d2014-01-13 15:12:23 +00002231 With *pWith; /* WITH clause attached to this select. Or NULL. */
drh9bb61fe2000-06-05 16:01:39 +00002232};
2233
2234/*
drh7d10d5a2008-08-20 16:35:10 +00002235** Allowed values for Select.selFlags. The "SF" prefix stands for
2236** "Select Flag".
2237*/
drh21172c42012-10-30 00:29:07 +00002238#define SF_Distinct 0x0001 /* Output should be DISTINCT */
2239#define SF_Resolved 0x0002 /* Identifiers have been resolved */
2240#define SF_Aggregate 0x0004 /* Contains aggregate functions */
2241#define SF_UsesEphemeral 0x0008 /* Uses the OpenEphemeral opcode */
2242#define SF_Expanded 0x0010 /* sqlite3SelectExpand() called on this */
2243#define SF_HasTypeInfo 0x0020 /* FROM subqueries have Table metadata */
drh079a3072014-03-19 14:10:55 +00002244 /* 0x0040 NOT USED */
drh21172c42012-10-30 00:29:07 +00002245#define SF_Values 0x0080 /* Synthesized from VALUES clause */
drh079a3072014-03-19 14:10:55 +00002246 /* 0x0100 NOT USED */
drh832ee3d2012-12-18 19:36:11 +00002247#define SF_NestedFrom 0x0200 /* Part of a parenthesized FROM clause */
drhd58d3272013-08-05 22:05:02 +00002248#define SF_MaybeConvert 0x0400 /* Need convertCompoundSelectToSubquery() */
daneae73fb2014-01-16 18:34:33 +00002249#define SF_Recursive 0x0800 /* The recursive part of a recursive CTE */
drhd227a292014-02-09 18:02:09 +00002250#define SF_Compound 0x1000 /* Part of a compound query */
drh7d10d5a2008-08-20 16:35:10 +00002251
2252
2253/*
drh340309f2014-01-22 00:23:49 +00002254** The results of a SELECT can be distributed in several ways, as defined
2255** by one of the following macros. The "SRT" prefix means "SELECT Result
2256** Type".
2257**
2258** SRT_Union Store results as a key in a temporary index
2259** identified by pDest->iSDParm.
2260**
2261** SRT_Except Remove results from the temporary index pDest->iSDParm.
2262**
2263** SRT_Exists Store a 1 in memory cell pDest->iSDParm if the result
2264** set is not empty.
2265**
2266** SRT_Discard Throw the results away. This is used by SELECT
2267** statements within triggers whose only purpose is
2268** the side-effects of functions.
2269**
2270** All of the above are free to ignore their ORDER BY clause. Those that
2271** follow must honor the ORDER BY clause.
2272**
2273** SRT_Output Generate a row of output (using the OP_ResultRow
2274** opcode) for each row in the result set.
2275**
2276** SRT_Mem Only valid if the result is a single column.
2277** Store the first column of the first result row
2278** in register pDest->iSDParm then abandon the rest
2279** of the query. This destination implies "LIMIT 1".
2280**
2281** SRT_Set The result must be a single column. Store each
2282** row of result as the key in table pDest->iSDParm.
2283** Apply the affinity pDest->affSdst before storing
2284** results. Used to implement "IN (SELECT ...)".
2285**
drh340309f2014-01-22 00:23:49 +00002286** SRT_EphemTab Create an temporary table pDest->iSDParm and store
2287** the result there. The cursor is left open after
2288** returning. This is like SRT_Table except that
2289** this destination uses OP_OpenEphemeral to create
2290** the table first.
2291**
2292** SRT_Coroutine Generate a co-routine that returns a new row of
2293** results each time it is invoked. The entry point
2294** of the co-routine is stored in register pDest->iSDParm
2295** and the result row is stored in pDest->nDest registers
2296** starting with pDest->iSdst.
2297**
drh781def22014-01-22 13:35:53 +00002298** SRT_Table Store results in temporary table pDest->iSDParm.
drh8e1ee882014-03-21 19:56:09 +00002299** SRT_Fifo This is like SRT_EphemTab except that the table
2300** is assumed to already be open. SRT_Fifo has
2301** the additional property of being able to ignore
2302** the ORDER BY clause.
drh781def22014-01-22 13:35:53 +00002303**
drh8e1ee882014-03-21 19:56:09 +00002304** SRT_DistFifo Store results in a temporary table pDest->iSDParm.
drh340309f2014-01-22 00:23:49 +00002305** But also use temporary table pDest->iSDParm+1 as
2306** a record of all prior results and ignore any duplicate
drh8e1ee882014-03-21 19:56:09 +00002307** rows. Name means: "Distinct Fifo".
drh781def22014-01-22 13:35:53 +00002308**
2309** SRT_Queue Store results in priority queue pDest->iSDParm (really
2310** an index). Append a sequence number so that all entries
2311** are distinct.
2312**
2313** SRT_DistQueue Store results in priority queue pDest->iSDParm only if
2314** the same record has never been stored before. The
2315** index at pDest->iSDParm+1 hold all prior stores.
drhfef52082000-06-06 01:50:43 +00002316*/
drh13449892005-09-07 21:22:45 +00002317#define SRT_Union 1 /* Store result as keys in an index */
2318#define SRT_Except 2 /* Remove result from a UNION index */
danielk19779ed1dfa2008-01-02 17:11:14 +00002319#define SRT_Exists 3 /* Store 1 if the result is not empty */
2320#define SRT_Discard 4 /* Do not save the results anywhere */
drh8e1ee882014-03-21 19:56:09 +00002321#define SRT_Fifo 5 /* Store result as data with an automatic rowid */
2322#define SRT_DistFifo 6 /* Like SRT_Fifo, but unique results only */
2323#define SRT_Queue 7 /* Store result in an queue */
2324#define SRT_DistQueue 8 /* Like SRT_Queue, but unique results only */
drhfef52082000-06-06 01:50:43 +00002325
drh13449892005-09-07 21:22:45 +00002326/* The ORDER BY clause is ignored for all of the above */
drh8e1ee882014-03-21 19:56:09 +00002327#define IgnorableOrderby(X) ((X->eDest)<=SRT_DistQueue)
drh13449892005-09-07 21:22:45 +00002328
drh8e1ee882014-03-21 19:56:09 +00002329#define SRT_Output 9 /* Output each row of result */
2330#define SRT_Mem 10 /* Store result in a memory cell */
2331#define SRT_Set 11 /* Store results as keys in an index */
2332#define SRT_EphemTab 12 /* Create transient tab and store like SRT_Table */
2333#define SRT_Coroutine 13 /* Generate a single row of result */
2334#define SRT_Table 14 /* Store result as data with an automatic rowid */
drh22827922000-06-06 17:27:05 +00002335
2336/*
drh634d81d2012-09-20 15:41:31 +00002337** An instance of this object describes where to put of the results of
2338** a SELECT statement.
danielk19776c8c8ce2008-01-02 16:27:09 +00002339*/
danielk19776c8c8ce2008-01-02 16:27:09 +00002340struct SelectDest {
drhfe1c6bb2014-01-22 17:28:35 +00002341 u8 eDest; /* How to dispose of the results. On of SRT_* above. */
2342 char affSdst; /* Affinity used when eDest==SRT_Set */
2343 int iSDParm; /* A parameter used by the eDest disposal method */
2344 int iSdst; /* Base register where results are written */
2345 int nSdst; /* Number of registers allocated */
2346 ExprList *pOrderBy; /* Key columns for SRT_Queue and SRT_DistQueue */
danielk19776c8c8ce2008-01-02 16:27:09 +00002347};
2348
2349/*
drh0b9f50d2009-06-23 20:28:53 +00002350** During code generation of statements that do inserts into AUTOINCREMENT
2351** tables, the following information is attached to the Table.u.autoInc.p
2352** pointer of each autoincrement table to record some side information that
2353** the code generator needs. We have to keep per-table autoincrement
2354** information in case inserts are down within triggers. Triggers do not
2355** normally coordinate their activities, but we do need to coordinate the
2356** loading and saving of autoincrement information.
2357*/
2358struct AutoincInfo {
2359 AutoincInfo *pNext; /* Next info block in a list of them all */
2360 Table *pTab; /* Table this info block refers to */
2361 int iDb; /* Index in sqlite3.aDb[] of database holding pTab */
2362 int regCtr; /* Memory register holding the rowid counter */
2363};
2364
2365/*
drhceea3322009-04-23 13:22:42 +00002366** Size of the column cache
2367*/
2368#ifndef SQLITE_N_COLCACHE
2369# define SQLITE_N_COLCACHE 10
2370#endif
2371
dan2832ad42009-08-31 15:27:27 +00002372/*
2373** At least one instance of the following structure is created for each
2374** trigger that may be fired while parsing an INSERT, UPDATE or DELETE
2375** statement. All such objects are stored in the linked list headed at
2376** Parse.pTriggerPrg and deleted once statement compilation has been
2377** completed.
2378**
2379** A Vdbe sub-program that implements the body and WHEN clause of trigger
2380** TriggerPrg.pTrigger, assuming a default ON CONFLICT clause of
2381** TriggerPrg.orconf, is stored in the TriggerPrg.pProgram variable.
2382** The Parse.pTriggerPrg list never contains two entries with the same
2383** values for both pTrigger and orconf.
dan65a7cd12009-09-01 12:16:01 +00002384**
danbb5f1682009-11-27 12:12:34 +00002385** The TriggerPrg.aColmask[0] variable is set to a mask of old.* columns
dan65a7cd12009-09-01 12:16:01 +00002386** accessed (or set to 0 for triggers fired as a result of INSERT
danbb5f1682009-11-27 12:12:34 +00002387** statements). Similarly, the TriggerPrg.aColmask[1] variable is set to
2388** a mask of new.* columns used by the program.
dan2832ad42009-08-31 15:27:27 +00002389*/
2390struct TriggerPrg {
2391 Trigger *pTrigger; /* Trigger this program was coded from */
dan2832ad42009-08-31 15:27:27 +00002392 TriggerPrg *pNext; /* Next entry in Parse.pTriggerPrg list */
drha4510172012-02-02 15:50:17 +00002393 SubProgram *pProgram; /* Program implementing pTrigger/orconf */
2394 int orconf; /* Default ON CONFLICT policy */
2395 u32 aColmask[2]; /* Masks of old.*, new.* columns accessed */
dan165921a2009-08-28 18:53:45 +00002396};
2397
drh64123582011-04-02 20:01:02 +00002398/*
2399** The yDbMask datatype for the bitmask of all attached databases.
2400*/
drh01c7dc82011-03-23 18:22:34 +00002401#if SQLITE_MAX_ATTACHED>30
drha7ab6d82014-07-21 15:44:39 +00002402 typedef unsigned char yDbMask[(SQLITE_MAX_ATTACHED+9)/8];
2403# define DbMaskTest(M,I) (((M)[(I)/8]&(1<<((I)&7)))!=0)
2404# define DbMaskZero(M) memset((M),0,sizeof(M))
2405# define DbMaskSet(M,I) (M)[(I)/8]|=(1<<((I)&7))
2406# define DbMaskAllZero(M) sqlite3DbMaskAllZero(M)
2407# define DbMaskNonZero(M) (sqlite3DbMaskAllZero(M)==0)
drh01c7dc82011-03-23 18:22:34 +00002408#else
drh64123582011-04-02 20:01:02 +00002409 typedef unsigned int yDbMask;
drha7ab6d82014-07-21 15:44:39 +00002410# define DbMaskTest(M,I) (((M)&(((yDbMask)1)<<(I)))!=0)
2411# define DbMaskZero(M) (M)=0
2412# define DbMaskSet(M,I) (M)|=(((yDbMask)1)<<(I))
2413# define DbMaskAllZero(M) (M)==0
2414# define DbMaskNonZero(M) (M)!=0
drh01c7dc82011-03-23 18:22:34 +00002415#endif
2416
drhceea3322009-04-23 13:22:42 +00002417/*
drhf57b3392001-10-08 13:22:32 +00002418** An SQL parser context. A copy of this structure is passed through
2419** the parser and down into all the parser action routine in order to
2420** carry around information that is global to the entire parse.
drhf1974842004-11-05 03:56:00 +00002421**
2422** The structure is divided into two parts. When the parser and code
2423** generate call themselves recursively, the first part of the structure
2424** is constant but the second part is reset at the beginning and end of
2425** each recursion.
danielk1977c00da102006-01-07 13:21:04 +00002426**
2427** The nTableLock and aTableLock variables are only used if the shared-cache
2428** feature is enabled (if sqlite3Tsd()->useSharedData is true). They are
2429** used to store the set of table-locks required by the statement being
2430** compiled. Function sqlite3TableLock() is used to add entries to the
2431** list.
drh75897232000-05-29 14:26:00 +00002432*/
2433struct Parse {
drh9bb575f2004-09-06 17:24:11 +00002434 sqlite3 *db; /* The main database structure */
drh75897232000-05-29 14:26:00 +00002435 char *zErrMsg; /* An error message */
drh75897232000-05-29 14:26:00 +00002436 Vdbe *pVdbe; /* An engine for executing database bytecode */
drha4510172012-02-02 15:50:17 +00002437 int rc; /* Return code from execution */
drh836faa42003-01-11 13:30:57 +00002438 u8 colNamesSet; /* TRUE after OP_ColumnName has been issued to pVdbe */
drha6ecd332004-06-10 00:29:09 +00002439 u8 checkSchema; /* Causes schema cookie check after an error */
drh205f48e2004-11-05 00:43:11 +00002440 u8 nested; /* Number of nested calls to the parser/code generator */
drh892d3172008-01-10 03:46:36 +00002441 u8 nTempReg; /* Number of temporary registers in aTempReg[] */
drha4510172012-02-02 15:50:17 +00002442 u8 isMultiWrite; /* True if statement may modify/insert multiple rows */
2443 u8 mayAbort; /* True if statement may throw an ABORT exception */
drhd58d3272013-08-05 22:05:02 +00002444 u8 hasCompound; /* Need to invoke convertCompoundSelectToSubquery() */
drhaceb31b2014-02-08 01:40:27 +00002445 u8 okConstFactor; /* OK to factor out constants */
drh892d3172008-01-10 03:46:36 +00002446 int aTempReg[8]; /* Holding area for temporary registers */
2447 int nRangeReg; /* Size of the temporary register block */
2448 int iRangeReg; /* First register in temporary register block */
drh75897232000-05-29 14:26:00 +00002449 int nErr; /* Number of errors seen */
drh832508b2002-03-02 17:04:07 +00002450 int nTab; /* Number of previously allocated VDBE cursors */
drh19a775c2000-06-05 18:54:46 +00002451 int nMem; /* Number of memory cells used so far */
drhfef52082000-06-06 01:50:43 +00002452 int nSet; /* Number of sets used so far */
dan1d8cb212011-12-09 13:24:16 +00002453 int nOnce; /* Number of OP_Once instructions so far */
drh73d5b8f2013-12-23 19:09:07 +00002454 int nOpAlloc; /* Number of slots allocated for Vdbe.aOp[] */
drh61019c72014-01-04 16:49:02 +00002455 int iFixedOp; /* Never back out opcodes iFixedOp-1 or earlier */
drhaa9b8962008-01-08 02:57:55 +00002456 int ckBase; /* Base register of data during check constraints */
drhb2b9d3d2013-08-01 01:14:43 +00002457 int iPartIdxTab; /* Table corresponding to a partial index */
drhceea3322009-04-23 13:22:42 +00002458 int iCacheLevel; /* ColCache valid when aColCache[].iLevel<=iCacheLevel */
2459 int iCacheCnt; /* Counter used to generate aColCache[].lru values */
drh7df89c82014-02-04 15:55:25 +00002460 int nLabel; /* Number of labels used */
2461 int *aLabel; /* Space to hold the labels */
drh2f7794c2008-04-01 03:27:39 +00002462 struct yColCache {
drhe55cbd72008-03-31 23:48:03 +00002463 int iTable; /* Table cursor number */
drh7df89c82014-02-04 15:55:25 +00002464 i16 iColumn; /* Table column number */
drhceea3322009-04-23 13:22:42 +00002465 u8 tempReg; /* iReg is a temp register that needs to be freed */
2466 int iLevel; /* Nesting level */
2467 int iReg; /* Reg with value of this column. 0 means none. */
2468 int lru; /* Least recently used entry has the smallest value */
2469 } aColCache[SQLITE_N_COLCACHE]; /* One for each column cache entry */
drhf30a9692013-11-15 01:10:18 +00002470 ExprList *pConstExpr;/* Constant expressions */
drh7df89c82014-02-04 15:55:25 +00002471 Token constraintName;/* Name of the constraint currently being parsed */
drh64123582011-04-02 20:01:02 +00002472 yDbMask writeMask; /* Start a write transaction on these databases */
2473 yDbMask cookieMask; /* Bitmask of schema verified databases */
drhc797d4d2007-05-08 01:08:49 +00002474 int cookieValue[SQLITE_MAX_ATTACHED+2]; /* Values of cookies to verify */
drha4510172012-02-02 15:50:17 +00002475 int regRowid; /* Register holding rowid of CREATE TABLE entry */
2476 int regRoot; /* Register holding root page number for new objects */
2477 int nMaxArg; /* Max args passed to user function by sub-program */
danielk1977c00da102006-01-07 13:21:04 +00002478#ifndef SQLITE_OMIT_SHARED_CACHE
2479 int nTableLock; /* Number of locks in aTableLock */
2480 TableLock *aTableLock; /* Required table locks for shared-cache mode */
2481#endif
drh0b9f50d2009-06-23 20:28:53 +00002482 AutoincInfo *pAinc; /* Information about AUTOINCREMENT counters */
drhf1974842004-11-05 03:56:00 +00002483
dan165921a2009-08-28 18:53:45 +00002484 /* Information used while coding trigger programs. */
dan65a7cd12009-09-01 12:16:01 +00002485 Parse *pToplevel; /* Parse structure for main program (or NULL) */
dan165921a2009-08-28 18:53:45 +00002486 Table *pTriggerTab; /* Table triggers are being coded for */
drhc6bd4e42013-11-02 14:37:18 +00002487 int addrCrTab; /* Address of OP_CreateTable opcode on CREATE TABLE */
2488 int addrSkipPK; /* Address of instruction to skip PRIMARY KEY index */
drh4f402f22013-06-11 18:59:38 +00002489 u32 nQueryLoop; /* Est number of iterations of a query (10*log2(N)) */
dan65a7cd12009-09-01 12:16:01 +00002490 u32 oldmask; /* Mask of old.* columns referenced */
danbb5f1682009-11-27 12:12:34 +00002491 u32 newmask; /* Mask of new.* columns referenced */
dan65a7cd12009-09-01 12:16:01 +00002492 u8 eTriggerOp; /* TK_UPDATE, TK_INSERT or TK_DELETE */
2493 u8 eOrconf; /* Default ON CONFLICT policy for trigger steps */
dand66c8302009-09-28 14:49:01 +00002494 u8 disableTriggers; /* True to disable triggers */
dan165921a2009-08-28 18:53:45 +00002495
drh7df89c82014-02-04 15:55:25 +00002496 /************************************************************************
2497 ** Above is constant between recursions. Below is reset before and after
2498 ** each recursion. The boundary between these two regions is determined
2499 ** using offsetof(Parse,nVar) so the nVar field must be the first field
2500 ** in the recursive region.
2501 ************************************************************************/
drhf1974842004-11-05 03:56:00 +00002502
drha4510172012-02-02 15:50:17 +00002503 int nVar; /* Number of '?' variables seen in the SQL so far */
2504 int nzVar; /* Number of available slots in azVar[] */
drh7f9c5db2013-10-23 00:32:58 +00002505 u8 iPkSortOrder; /* ASC or DESC for INTEGER PRIMARY KEY */
drh7df89c82014-02-04 15:55:25 +00002506 u8 bFreeWith; /* True if pWith should be freed with parser */
drha4510172012-02-02 15:50:17 +00002507 u8 explain; /* True if the EXPLAIN flag is found on the query */
2508#ifndef SQLITE_OMIT_VIRTUALTABLE
2509 u8 declareVtab; /* True if inside sqlite3_declare_vtab() */
2510 int nVtabLock; /* Number of virtual tables to lock */
2511#endif
2512 int nAlias; /* Number of aliased result set columns */
2513 int nHeight; /* Expression tree height of current sub-select */
2514#ifndef SQLITE_OMIT_EXPLAIN
2515 int iSelectId; /* ID of current select for EXPLAIN output */
2516 int iNextSelectId; /* Next available select ID for EXPLAIN output */
2517#endif
2518 char **azVar; /* Pointers to names of parameters */
2519 Vdbe *pReprepare; /* VM being reprepared (sqlite3Reprepare()) */
drha4510172012-02-02 15:50:17 +00002520 const char *zTail; /* All SQL text past the last semicolon parsed */
2521 Table *pNewTable; /* A table being constructed by CREATE TABLE */
drhf1974842004-11-05 03:56:00 +00002522 Trigger *pNewTrigger; /* Trigger under construct by a CREATE TRIGGER */
drhf1974842004-11-05 03:56:00 +00002523 const char *zAuthContext; /* The 6th parameter to db->xAuth callbacks */
drha4510172012-02-02 15:50:17 +00002524 Token sNameToken; /* Token with unqualified schema object name */
2525 Token sLastToken; /* The last token parsed */
drhb9bb7c12006-06-11 23:41:55 +00002526#ifndef SQLITE_OMIT_VIRTUALTABLE
drha4510172012-02-02 15:50:17 +00002527 Token sArg; /* Complete text of a module argument */
2528 Table **apVtabLock; /* Pointer to virtual tables needing locking */
drhb9bb7c12006-06-11 23:41:55 +00002529#endif
drha4510172012-02-02 15:50:17 +00002530 Table *pZombieTab; /* List of Table objects to delete after code gen */
2531 TriggerPrg *pTriggerPrg; /* Linked list of coded triggers */
dan4e9119d2014-01-13 15:12:23 +00002532 With *pWith; /* Current WITH clause, or NULL */
drh75897232000-05-29 14:26:00 +00002533};
2534
drha4510172012-02-02 15:50:17 +00002535/*
2536** Return true if currently inside an sqlite3_declare_vtab() call.
2537*/
danielk19777e6ebfb2006-06-12 11:24:37 +00002538#ifdef SQLITE_OMIT_VIRTUALTABLE
2539 #define IN_DECLARE_VTAB 0
2540#else
2541 #define IN_DECLARE_VTAB (pParse->declareVtab)
2542#endif
2543
danielk1977d99bc932002-05-16 00:13:12 +00002544/*
drh85e20962003-04-25 17:52:11 +00002545** An instance of the following structure can be declared on a stack and used
2546** to save the Parse.zAuthContext value so that it can be restored later.
2547*/
2548struct AuthContext {
2549 const char *zAuthContext; /* Put saved Parse.zAuthContext here */
2550 Parse *pParse; /* The Parse structure */
2551};
2552
2553/*
drha748fdc2012-03-28 01:34:47 +00002554** Bitfield flags for P5 value in various opcodes.
rdcb0c374f2004-02-20 22:53:38 +00002555*/
drh3e9ca092009-09-08 01:14:48 +00002556#define OPFLAG_NCHANGE 0x01 /* Set to update db->nChange */
2557#define OPFLAG_LASTROWID 0x02 /* Set to update db->lastRowid */
2558#define OPFLAG_ISUPDATE 0x04 /* This OP_Insert is an sql UPDATE */
2559#define OPFLAG_APPEND 0x08 /* This is likely to be an append */
2560#define OPFLAG_USESEEKRESULT 0x10 /* Try to avoid a seek in BtreeInsert() */
2561#define OPFLAG_CLEARCACHE 0x20 /* Clear pseudo-table cache in OP_Column */
drha748fdc2012-03-28 01:34:47 +00002562#define OPFLAG_LENGTHARG 0x40 /* OP_Column only used for length() */
2563#define OPFLAG_TYPEOFARG 0x80 /* OP_Column only used for typeof() */
dan428c2182012-08-06 18:50:11 +00002564#define OPFLAG_BULKCSR 0x01 /* OP_Open** used to open bulk cursor */
2565#define OPFLAG_P2ISREG 0x02 /* P2 to OP_Open** is a register number */
drh953f7612012-12-07 22:18:54 +00002566#define OPFLAG_PERMUTE 0x01 /* OP_Compare: use the permutation */
rdcb0c374f2004-02-20 22:53:38 +00002567
2568/*
danielk1977d99bc932002-05-16 00:13:12 +00002569 * Each trigger present in the database schema is stored as an instance of
2570 * struct Trigger.
2571 *
2572 * Pointers to instances of struct Trigger are stored in two ways.
drh9bb575f2004-09-06 17:24:11 +00002573 * 1. In the "trigHash" hash table (part of the sqlite3* that represents the
danielk1977d99bc932002-05-16 00:13:12 +00002574 * database). This allows Trigger structures to be retrieved by name.
2575 * 2. All triggers associated with a single table form a linked list, using the
drhad3cab52002-05-24 02:04:32 +00002576 * pNext member of struct Trigger. A pointer to the first element of the
2577 * linked list is stored as the "pTrigger" member of the associated
2578 * struct Table.
danielk1977d99bc932002-05-16 00:13:12 +00002579 *
drhad3cab52002-05-24 02:04:32 +00002580 * The "step_list" member points to the first element of a linked list
2581 * containing the SQL statements specified as the trigger program.
danielk1977d99bc932002-05-16 00:13:12 +00002582 */
danielk1977c3f9bad2002-05-15 08:30:12 +00002583struct Trigger {
dan165921a2009-08-28 18:53:45 +00002584 char *zName; /* The name of the trigger */
drhdc379452002-05-15 12:45:43 +00002585 char *table; /* The table or view to which the trigger applies */
drhf0f258b2003-04-21 18:48:45 +00002586 u8 op; /* One of TK_DELETE, TK_UPDATE, TK_INSERT */
drhdca76842004-12-07 14:06:13 +00002587 u8 tr_tm; /* One of TRIGGER_BEFORE, TRIGGER_AFTER */
shane467bcf32008-11-24 20:01:32 +00002588 Expr *pWhen; /* The WHEN clause of the expression (may be NULL) */
drhdc379452002-05-15 12:45:43 +00002589 IdList *pColumns; /* If this is an UPDATE OF <column-list> trigger,
danielk1977d99bc932002-05-16 00:13:12 +00002590 the <column-list> is stored here */
danielk1977e501b892006-01-09 06:29:47 +00002591 Schema *pSchema; /* Schema containing the trigger */
2592 Schema *pTabSchema; /* Schema containing the table */
drhdc379452002-05-15 12:45:43 +00002593 TriggerStep *step_list; /* Link list of trigger program steps */
drhdc379452002-05-15 12:45:43 +00002594 Trigger *pNext; /* Next trigger associated with the table */
danielk1977c3f9bad2002-05-15 08:30:12 +00002595};
2596
danielk1977d99bc932002-05-16 00:13:12 +00002597/*
drhdca76842004-12-07 14:06:13 +00002598** A trigger is either a BEFORE or an AFTER trigger. The following constants
2599** determine which.
2600**
2601** If there are multiple triggers, you might of some BEFORE and some AFTER.
2602** In that cases, the constants below can be ORed together.
2603*/
2604#define TRIGGER_BEFORE 1
2605#define TRIGGER_AFTER 2
2606
2607/*
danielk1977d99bc932002-05-16 00:13:12 +00002608 * An instance of struct TriggerStep is used to store a single SQL statement
2609 * that is a part of a trigger-program.
2610 *
2611 * Instances of struct TriggerStep are stored in a singly linked list (linked
2612 * using the "pNext" member) referenced by the "step_list" member of the
2613 * associated struct Trigger instance. The first element of the linked list is
2614 * the first step of the trigger-program.
2615 *
2616 * The "op" member indicates whether this is a "DELETE", "INSERT", "UPDATE" or
2617 * "SELECT" statement. The meanings of the other members is determined by the
2618 * value of "op" as follows:
2619 *
2620 * (op == TK_INSERT)
2621 * orconf -> stores the ON CONFLICT algorithm
2622 * pSelect -> If this is an INSERT INTO ... SELECT ... statement, then
2623 * this stores a pointer to the SELECT statement. Otherwise NULL.
drhb7916a72009-05-27 10:31:29 +00002624 * target -> A token holding the quoted name of the table to insert into.
danielk1977d99bc932002-05-16 00:13:12 +00002625 * pExprList -> If this is an INSERT INTO ... VALUES ... statement, then
2626 * this stores values to be inserted. Otherwise NULL.
2627 * pIdList -> If this is an INSERT INTO ... (<column-names>) VALUES ...
drhad3cab52002-05-24 02:04:32 +00002628 * statement, then this stores the column-names to be
2629 * inserted into.
danielk1977d99bc932002-05-16 00:13:12 +00002630 *
2631 * (op == TK_DELETE)
drhb7916a72009-05-27 10:31:29 +00002632 * target -> A token holding the quoted name of the table to delete from.
danielk1977d99bc932002-05-16 00:13:12 +00002633 * pWhere -> The WHERE clause of the DELETE statement if one is specified.
2634 * Otherwise NULL.
2635 *
2636 * (op == TK_UPDATE)
drhb7916a72009-05-27 10:31:29 +00002637 * target -> A token holding the quoted name of the table to update rows of.
danielk1977d99bc932002-05-16 00:13:12 +00002638 * pWhere -> The WHERE clause of the UPDATE statement if one is specified.
2639 * Otherwise NULL.
2640 * pExprList -> A list of the columns to update and the expressions to update
danielk19774adee202004-05-08 08:23:19 +00002641 * them to. See sqlite3Update() documentation of "pChanges"
drhad3cab52002-05-24 02:04:32 +00002642 * argument.
danielk1977d99bc932002-05-16 00:13:12 +00002643 *
2644 */
2645struct TriggerStep {
drhb1819a02009-07-03 15:37:27 +00002646 u8 op; /* One of TK_DELETE, TK_UPDATE, TK_INSERT, TK_SELECT */
2647 u8 orconf; /* OE_Rollback etc. */
drha69d9162003-04-17 22:57:53 +00002648 Trigger *pTrig; /* The trigger that this step is a part of */
drhb1819a02009-07-03 15:37:27 +00002649 Select *pSelect; /* SELECT statment or RHS of INSERT INTO .. SELECT ... */
2650 Token target; /* Target table for DELETE, UPDATE, INSERT */
2651 Expr *pWhere; /* The WHERE clause for DELETE or UPDATE steps */
drh75593d92014-01-10 20:46:55 +00002652 ExprList *pExprList; /* SET clause for UPDATE. */
drhb1819a02009-07-03 15:37:27 +00002653 IdList *pIdList; /* Column names for INSERT */
drh187e4c62006-02-27 22:22:27 +00002654 TriggerStep *pNext; /* Next in the link-list */
2655 TriggerStep *pLast; /* Last element in link-list. Valid for 1st elem only */
danielk1977d99bc932002-05-16 00:13:12 +00002656};
2657
2658/*
drhf26e09c2003-05-31 16:21:12 +00002659** The following structure contains information used by the sqliteFix...
2660** routines as they walk the parse tree to make database references
2661** explicit.
2662*/
2663typedef struct DbFixer DbFixer;
2664struct DbFixer {
2665 Parse *pParse; /* The parsing context. Error messages written here */
dan41fb5cd2012-10-04 19:33:00 +00002666 Schema *pSchema; /* Fix items to this schema */
dan46539d72013-10-03 12:29:38 +00002667 int bVarOnly; /* Check for variable references only */
drhf26e09c2003-05-31 16:21:12 +00002668 const char *zDb; /* Make sure all objects are contained in this database */
2669 const char *zType; /* Type of the container - used for error messages */
2670 const Token *pName; /* Name of the container - used for error messages */
2671};
2672
2673/*
drhade86482007-11-28 22:36:40 +00002674** An objected used to accumulate the text of a string where we
2675** do not necessarily know how big the string will be in the end.
2676*/
2677struct StrAccum {
drh633e6d52008-07-28 19:34:53 +00002678 sqlite3 *db; /* Optional database for lookaside. Can be NULL */
2679 char *zBase; /* A base allocation. Not from malloc. */
2680 char *zText; /* The string collected so far */
2681 int nChar; /* Length of the string so far */
2682 int nAlloc; /* Amount of space allocated in zText */
drhbb4957f2008-03-20 14:03:29 +00002683 int mxAlloc; /* Maximum allowed string length */
drhb9755982010-07-24 16:34:37 +00002684 u8 useMalloc; /* 0: none, 1: sqlite3DbMalloc, 2: sqlite3_malloc */
drhb49bc862013-08-21 21:12:10 +00002685 u8 accError; /* STRACCUM_NOMEM or STRACCUM_TOOBIG */
drhade86482007-11-28 22:36:40 +00002686};
drhb49bc862013-08-21 21:12:10 +00002687#define STRACCUM_NOMEM 1
2688#define STRACCUM_TOOBIG 2
drhade86482007-11-28 22:36:40 +00002689
2690/*
drh234c39d2004-07-24 03:30:47 +00002691** A pointer to this structure is used to communicate information
2692** from sqlite3Init and OP_ParseSchema into the sqlite3InitCallback.
2693*/
2694typedef struct {
drh9bb575f2004-09-06 17:24:11 +00002695 sqlite3 *db; /* The database being initialized */
drh234c39d2004-07-24 03:30:47 +00002696 char **pzErrMsg; /* Error message stored here */
drha4510172012-02-02 15:50:17 +00002697 int iDb; /* 0 for main database. 1 for TEMP, 2.. for ATTACHed */
drh15ca1df2006-07-26 13:43:30 +00002698 int rc; /* Result code stored here */
drh234c39d2004-07-24 03:30:47 +00002699} InitData;
2700
drhb6c29892004-11-22 19:12:19 +00002701/*
drh40257ff2008-06-13 18:24:27 +00002702** Structure containing global configuration data for the SQLite library.
drh33589792008-06-18 13:27:46 +00002703**
2704** This structure also contains some state information.
drh40257ff2008-06-13 18:24:27 +00002705*/
2706struct Sqlite3Config {
drhfec00ea2008-06-14 16:56:21 +00002707 int bMemstat; /* True to enable memory status */
2708 int bCoreMutex; /* True to enable core mutexing */
2709 int bFullMutex; /* True to enable full mutexing */
dancd74b612011-04-22 19:37:32 +00002710 int bOpenUri; /* True to interpret filenames as URIs */
drhde9a7b82012-09-17 20:44:46 +00002711 int bUseCis; /* Use covering indices for full-scans */
drh0a687d12008-07-08 14:52:07 +00002712 int mxStrlen; /* Maximum string length */
drh09fe6142013-11-29 15:06:27 +00002713 int neverCorrupt; /* Database is always well-formed */
drh633e6d52008-07-28 19:34:53 +00002714 int szLookaside; /* Default lookaside buffer size */
2715 int nLookaside; /* Default lookaside buffer count */
drhfec00ea2008-06-14 16:56:21 +00002716 sqlite3_mem_methods m; /* Low-level memory allocation interface */
danielk19776d2ab0e2008-06-17 17:21:18 +00002717 sqlite3_mutex_methods mutex; /* Low-level mutex interface */
dan22e21ff2011-11-08 20:08:44 +00002718 sqlite3_pcache_methods2 pcache2; /* Low-level page-cache interface */
drh40257ff2008-06-13 18:24:27 +00002719 void *pHeap; /* Heap storage space */
drh33589792008-06-18 13:27:46 +00002720 int nHeap; /* Size of pHeap[] */
2721 int mnReq, mxReq; /* Min and max heap requests sizes */
drh9b4c59f2013-04-15 17:03:42 +00002722 sqlite3_int64 szMmap; /* mmap() space per open file */
2723 sqlite3_int64 mxMmap; /* Maximum value for szMmap */
drh33589792008-06-18 13:27:46 +00002724 void *pScratch; /* Scratch memory */
2725 int szScratch; /* Size of each scratch buffer */
2726 int nScratch; /* Number of scratch buffers */
2727 void *pPage; /* Page cache memory */
2728 int szPage; /* Size of each page in pPage[] */
2729 int nPage; /* Number of pages in pPage[] */
drh1875f7a2008-12-08 18:19:17 +00002730 int mxParserStack; /* maximum depth of the parser stack */
2731 int sharedCacheEnabled; /* true if shared-cache mode enabled */
2732 /* The above might be initialized to non-zero. The following need to always
2733 ** initially be zero, however. */
danielk197771bc31c2008-06-26 08:29:34 +00002734 int isInit; /* True after initialization has finished */
danielk1977502b4e02008-09-02 14:07:24 +00002735 int inProgress; /* True while initialization in progress */
dane1ab2192009-08-17 15:16:19 +00002736 int isMutexInit; /* True after mutexes are initialized */
danielk197771bc31c2008-06-26 08:29:34 +00002737 int isMallocInit; /* True after malloc is initialized */
dane1ab2192009-08-17 15:16:19 +00002738 int isPCacheInit; /* True after malloc is initialized */
drh93ed56d2008-08-12 15:21:11 +00002739 int nRefInitMutex; /* Number of users of pInitMutex */
drhc007f612014-05-16 14:17:01 +00002740 sqlite3_mutex *pInitMutex; /* Mutex used by sqlite3_initialize() */
drh3f280702010-02-18 18:45:09 +00002741 void (*xLog)(void*,int,const char*); /* Function for logging */
2742 void *pLogArg; /* First argument to xLog() */
danac455932012-11-26 19:50:41 +00002743#ifdef SQLITE_ENABLE_SQLLOG
2744 void(*xSqllog)(void*,sqlite3*,const char*, int);
2745 void *pSqllogArg;
2746#endif
drh688852a2014-02-17 22:40:43 +00002747#ifdef SQLITE_VDBE_COVERAGE
2748 /* The following callback (if not NULL) is invoked on every VDBE branch
2749 ** operation. Set the callback using SQLITE_TESTCTRL_VDBE_COVERAGE.
2750 */
2751 void (*xVdbeBranch)(void*,int iSrcLine,u8 eThis,u8 eMx); /* Callback */
2752 void *pVdbeBranchArg; /* 1st argument */
2753#endif
drhc007f612014-05-16 14:17:01 +00002754#ifndef SQLITE_OMIT_BUILTIN_TEST
2755 int (*xTestCallback)(int); /* Invoked by sqlite3FaultSim() */
2756#endif
2757 int bLocaltimeFault; /* True to fail localtime() calls */
drh40257ff2008-06-13 18:24:27 +00002758};
2759
2760/*
drh09fe6142013-11-29 15:06:27 +00002761** This macro is used inside of assert() statements to indicate that
2762** the assert is only valid on a well-formed database. Instead of:
2763**
2764** assert( X );
2765**
2766** One writes:
2767**
drhb2023662013-11-29 15:39:36 +00002768** assert( X || CORRUPT_DB );
drh09fe6142013-11-29 15:06:27 +00002769**
drhb2023662013-11-29 15:39:36 +00002770** CORRUPT_DB is true during normal operation. CORRUPT_DB does not indicate
2771** that the database is definitely corrupt, only that it might be corrupt.
2772** For most test cases, CORRUPT_DB is set to false using a special
2773** sqlite3_test_control(). This enables assert() statements to prove
2774** things that are always true for well-formed databases.
drh09fe6142013-11-29 15:06:27 +00002775*/
drhb2023662013-11-29 15:39:36 +00002776#define CORRUPT_DB (sqlite3Config.neverCorrupt==0)
drh09fe6142013-11-29 15:06:27 +00002777
2778/*
drh7d10d5a2008-08-20 16:35:10 +00002779** Context pointer passed down through the tree-walk.
2780*/
2781struct Walker {
2782 int (*xExprCallback)(Walker*, Expr*); /* Callback for expressions */
2783 int (*xSelectCallback)(Walker*,Select*); /* Callback for SELECTs */
danb290f112014-01-17 14:59:27 +00002784 void (*xSelectCallback2)(Walker*,Select*);/* Second callback for SELECTs */
drh7d10d5a2008-08-20 16:35:10 +00002785 Parse *pParse; /* Parser context. */
drh030796d2012-08-23 16:18:10 +00002786 int walkerDepth; /* Number of subqueries */
drh7d10d5a2008-08-20 16:35:10 +00002787 union { /* Extra data for callback */
2788 NameContext *pNC; /* Naming context */
2789 int i; /* Integer value */
drh374fdce2012-04-17 16:38:53 +00002790 SrcList *pSrcList; /* FROM clause */
drh030796d2012-08-23 16:18:10 +00002791 struct SrcCount *pSrcCount; /* Counting column references */
drh7d10d5a2008-08-20 16:35:10 +00002792 } u;
2793};
2794
2795/* Forward declarations */
2796int sqlite3WalkExpr(Walker*, Expr*);
2797int sqlite3WalkExprList(Walker*, ExprList*);
2798int sqlite3WalkSelect(Walker*, Select*);
2799int sqlite3WalkSelectExpr(Walker*, Select*);
2800int sqlite3WalkSelectFrom(Walker*, Select*);
2801
2802/*
2803** Return code from the parse-tree walking primitives and their
2804** callbacks.
2805*/
drh2bf90f12008-12-09 13:04:29 +00002806#define WRC_Continue 0 /* Continue down into children */
2807#define WRC_Prune 1 /* Omit children but continue walking siblings */
2808#define WRC_Abort 2 /* Abandon the tree walk */
drh7d10d5a2008-08-20 16:35:10 +00002809
2810/*
daneae73fb2014-01-16 18:34:33 +00002811** An instance of this structure represents a set of one or more CTEs
drhc49832c2014-01-15 18:35:52 +00002812** (common table expressions) created by a single WITH clause.
dan7d562db2014-01-11 19:19:36 +00002813*/
2814struct With {
drhc49832c2014-01-15 18:35:52 +00002815 int nCte; /* Number of CTEs in the WITH clause */
dan4e9119d2014-01-13 15:12:23 +00002816 With *pOuter; /* Containing WITH clause, or NULL */
drhc49832c2014-01-15 18:35:52 +00002817 struct Cte { /* For each CTE in the WITH clause.... */
2818 char *zName; /* Name of this CTE */
2819 ExprList *pCols; /* List of explicit column names, or NULL */
2820 Select *pSelect; /* The definition of this CTE */
danf2655fe2014-01-16 21:02:02 +00002821 const char *zErr; /* Error message for circular references */
dan7d562db2014-01-11 19:19:36 +00002822 } a[1];
2823};
2824
2825/*
drh66150952007-07-23 19:12:41 +00002826** Assuming zIn points to the first byte of a UTF-8 character,
2827** advance zIn to point to the first byte of the next UTF-8 character.
drh4a919112007-05-15 11:55:09 +00002828*/
drh4a919112007-05-15 11:55:09 +00002829#define SQLITE_SKIP_UTF8(zIn) { \
2830 if( (*(zIn++))>=0xc0 ){ \
2831 while( (*zIn & 0xc0)==0x80 ){ zIn++; } \
2832 } \
2833}
2834
drh4a919112007-05-15 11:55:09 +00002835/*
drh9978c972010-02-23 17:36:32 +00002836** The SQLITE_*_BKPT macros are substitutes for the error codes with
2837** the same name but without the _BKPT suffix. These macros invoke
2838** routines that report the line-number on which the error originated
2839** using sqlite3_log(). The routines also provide a convenient place
2840** to set a debugger breakpoint.
drh49285702005-09-17 15:20:26 +00002841*/
drh9978c972010-02-23 17:36:32 +00002842int sqlite3CorruptError(int);
2843int sqlite3MisuseError(int);
2844int sqlite3CantopenError(int);
2845#define SQLITE_CORRUPT_BKPT sqlite3CorruptError(__LINE__)
2846#define SQLITE_MISUSE_BKPT sqlite3MisuseError(__LINE__)
2847#define SQLITE_CANTOPEN_BKPT sqlite3CantopenError(__LINE__)
2848
drh49285702005-09-17 15:20:26 +00002849
2850/*
drhb4a1fed2010-02-03 19:55:13 +00002851** FTS4 is really an extension for FTS3. It is enabled using the
2852** SQLITE_ENABLE_FTS3 macro. But to avoid confusion we also all
2853** the SQLITE_ENABLE_FTS4 macro to serve as an alisse for SQLITE_ENABLE_FTS3.
2854*/
2855#if defined(SQLITE_ENABLE_FTS4) && !defined(SQLITE_ENABLE_FTS3)
2856# define SQLITE_ENABLE_FTS3
2857#endif
2858
2859/*
drh79f02ce2009-05-07 14:11:52 +00002860** The ctype.h header is needed for non-ASCII systems. It is also
2861** needed by FTS3 when FTS3 is included in the amalgamation.
2862*/
2863#if !defined(SQLITE_ASCII) || \
2864 (defined(SQLITE_ENABLE_FTS3) && defined(SQLITE_AMALGAMATION))
2865# include <ctype.h>
2866#endif
2867
2868/*
danielk197778ca0e72009-01-20 16:53:39 +00002869** The following macros mimic the standard library functions toupper(),
2870** isspace(), isalnum(), isdigit() and isxdigit(), respectively. The
2871** sqlite versions only work for ASCII characters, regardless of locale.
2872*/
2873#ifdef SQLITE_ASCII
2874# define sqlite3Toupper(x) ((x)&~(sqlite3CtypeMap[(unsigned char)(x)]&0x20))
2875# define sqlite3Isspace(x) (sqlite3CtypeMap[(unsigned char)(x)]&0x01)
drhdc86e2b2009-01-24 11:30:42 +00002876# define sqlite3Isalnum(x) (sqlite3CtypeMap[(unsigned char)(x)]&0x06)
2877# define sqlite3Isalpha(x) (sqlite3CtypeMap[(unsigned char)(x)]&0x02)
danielk197778ca0e72009-01-20 16:53:39 +00002878# define sqlite3Isdigit(x) (sqlite3CtypeMap[(unsigned char)(x)]&0x04)
2879# define sqlite3Isxdigit(x) (sqlite3CtypeMap[(unsigned char)(x)]&0x08)
2880# define sqlite3Tolower(x) (sqlite3UpperToLower[(unsigned char)(x)])
2881#else
danielk197778ca0e72009-01-20 16:53:39 +00002882# define sqlite3Toupper(x) toupper((unsigned char)(x))
2883# define sqlite3Isspace(x) isspace((unsigned char)(x))
2884# define sqlite3Isalnum(x) isalnum((unsigned char)(x))
drhdc86e2b2009-01-24 11:30:42 +00002885# define sqlite3Isalpha(x) isalpha((unsigned char)(x))
danielk197778ca0e72009-01-20 16:53:39 +00002886# define sqlite3Isdigit(x) isdigit((unsigned char)(x))
2887# define sqlite3Isxdigit(x) isxdigit((unsigned char)(x))
2888# define sqlite3Tolower(x) tolower((unsigned char)(x))
2889#endif
2890
2891/*
drh75897232000-05-29 14:26:00 +00002892** Internal function prototypes
2893*/
drh3fa97302012-02-22 16:58:36 +00002894#define sqlite3StrICmp sqlite3_stricmp
drhea678832008-12-10 19:26:22 +00002895int sqlite3Strlen30(const char*);
danielk1977ee0484c2009-07-28 16:44:26 +00002896#define sqlite3StrNICmp sqlite3_strnicmp
danielk19772e588c72005-12-09 14:25:08 +00002897
drh40257ff2008-06-13 18:24:27 +00002898int sqlite3MallocInit(void);
drhfec00ea2008-06-14 16:56:21 +00002899void sqlite3MallocEnd(void);
2900void *sqlite3Malloc(int);
2901void *sqlite3MallocZero(int);
2902void *sqlite3DbMallocZero(sqlite3*, int);
2903void *sqlite3DbMallocRaw(sqlite3*, int);
drh17435752007-08-16 04:30:38 +00002904char *sqlite3DbStrDup(sqlite3*,const char*);
2905char *sqlite3DbStrNDup(sqlite3*,const char*, int);
drhfec00ea2008-06-14 16:56:21 +00002906void *sqlite3Realloc(void*, int);
drh97c8ec32007-08-27 21:49:34 +00002907void *sqlite3DbReallocOrFree(sqlite3 *, void *, int);
danielk1977a1644fd2007-08-29 12:31:25 +00002908void *sqlite3DbRealloc(sqlite3 *, void *, int);
drh633e6d52008-07-28 19:34:53 +00002909void sqlite3DbFree(sqlite3*, void*);
2910int sqlite3MallocSize(void*);
2911int sqlite3DbMallocSize(sqlite3*, void*);
drhfacf0302008-06-17 15:12:00 +00002912void *sqlite3ScratchMalloc(int);
2913void sqlite3ScratchFree(void*);
2914void *sqlite3PageMalloc(int);
2915void sqlite3PageFree(void*);
drhfec00ea2008-06-14 16:56:21 +00002916void sqlite3MemSetDefault(void);
danielk1977171bfed2008-06-23 09:50:50 +00002917void sqlite3BenignMallocHooks(void (*)(void), void (*)(void));
drh50d1b5f2010-08-27 12:21:06 +00002918int sqlite3HeapNearlyFull(void);
danielk19772e588c72005-12-09 14:25:08 +00002919
drhe7b347072009-06-01 18:18:20 +00002920/*
2921** On systems with ample stack space and that support alloca(), make
2922** use of alloca() to obtain space for large automatic objects. By default,
2923** obtain space from malloc().
2924**
2925** The alloca() routine never returns NULL. This will cause code paths
2926** that deal with sqlite3StackAlloc() failures to be unreachable.
2927*/
2928#ifdef SQLITE_USE_ALLOCA
2929# define sqlite3StackAllocRaw(D,N) alloca(N)
2930# define sqlite3StackAllocZero(D,N) memset(alloca(N), 0, N)
2931# define sqlite3StackFree(D,P)
2932#else
2933# define sqlite3StackAllocRaw(D,N) sqlite3DbMallocRaw(D,N)
2934# define sqlite3StackAllocZero(D,N) sqlite3DbMallocZero(D,N)
2935# define sqlite3StackFree(D,P) sqlite3DbFree(D,P)
2936#endif
2937
danielk1977f3d3c272008-11-19 16:52:44 +00002938#ifdef SQLITE_ENABLE_MEMSYS3
2939const sqlite3_mem_methods *sqlite3MemGetMemsys3(void);
2940#endif
2941#ifdef SQLITE_ENABLE_MEMSYS5
2942const sqlite3_mem_methods *sqlite3MemGetMemsys5(void);
2943#endif
2944
2945
drh18472fa2008-10-07 15:25:48 +00002946#ifndef SQLITE_MUTEX_OMIT
dan558814f2010-06-02 05:53:53 +00002947 sqlite3_mutex_methods const *sqlite3DefaultMutex(void);
2948 sqlite3_mutex_methods const *sqlite3NoopMutex(void);
drh65bbf292008-06-19 01:03:17 +00002949 sqlite3_mutex *sqlite3MutexAlloc(int);
2950 int sqlite3MutexInit(void);
2951 int sqlite3MutexEnd(void);
2952#endif
danielk19776d2ab0e2008-06-17 17:21:18 +00002953
drhf7141992008-06-19 00:16:08 +00002954int sqlite3StatusValue(int);
2955void sqlite3StatusAdd(int, int);
2956void sqlite3StatusSet(int, int);
2957
drh85c8f292010-01-13 17:39:53 +00002958#ifndef SQLITE_OMIT_FLOATING_POINT
2959 int sqlite3IsNaN(double);
2960#else
2961# define sqlite3IsNaN(X) 0
2962#endif
drh0de3ae92008-04-28 16:55:26 +00002963
drha5c14162013-12-17 15:03:06 +00002964/*
2965** An instance of the following structure holds information about SQL
2966** functions arguments that are the parameters to the printf() function.
2967*/
2968struct PrintfArguments {
2969 int nArg; /* Total number of arguments */
2970 int nUsed; /* Number of arguments used so far */
2971 sqlite3_value **apArg; /* The argument values */
2972};
2973
2974#define SQLITE_PRINTF_INTERNAL 0x01
2975#define SQLITE_PRINTF_SQLFUNC 0x02
2976void sqlite3VXPrintf(StrAccum*, u32, const char*, va_list);
2977void sqlite3XPrintf(StrAccum*, u32, const char*, ...);
drh17435752007-08-16 04:30:38 +00002978char *sqlite3MPrintf(sqlite3*,const char*, ...);
2979char *sqlite3VMPrintf(sqlite3*,const char*, va_list);
drh633e6d52008-07-28 19:34:53 +00002980char *sqlite3MAppendf(sqlite3*,char*,const char*,...);
drh87cc3b32007-05-08 21:45:27 +00002981#if defined(SQLITE_TEST) || defined(SQLITE_DEBUG)
2982 void sqlite3DebugPrintf(const char*, ...);
drhd919fe12007-12-11 19:34:44 +00002983#endif
2984#if defined(SQLITE_TEST)
drhe8f52c52008-07-12 14:52:20 +00002985 void *sqlite3TestTextToPtr(const char*);
drh87cc3b32007-05-08 21:45:27 +00002986#endif
drh7e02e5e2011-12-06 19:44:51 +00002987
2988/* Output formatting for SQLITE_TESTCTRL_EXPLAIN */
drh678a9aa2011-12-10 15:55:01 +00002989#if defined(SQLITE_ENABLE_TREE_EXPLAIN)
drh7e02e5e2011-12-06 19:44:51 +00002990 void sqlite3ExplainBegin(Vdbe*);
2991 void sqlite3ExplainPrintf(Vdbe*, const char*, ...);
2992 void sqlite3ExplainNL(Vdbe*);
2993 void sqlite3ExplainPush(Vdbe*);
2994 void sqlite3ExplainPop(Vdbe*);
2995 void sqlite3ExplainFinish(Vdbe*);
2996 void sqlite3ExplainSelect(Vdbe*, Select*);
2997 void sqlite3ExplainExpr(Vdbe*, Expr*);
2998 void sqlite3ExplainExprList(Vdbe*, ExprList*);
2999 const char *sqlite3VdbeExplanation(Vdbe*);
3000#else
3001# define sqlite3ExplainBegin(X)
3002# define sqlite3ExplainSelect(A,B)
3003# define sqlite3ExplainExpr(A,B)
3004# define sqlite3ExplainExprList(A,B)
3005# define sqlite3ExplainFinish(X)
3006# define sqlite3VdbeExplanation(X) 0
3007#endif
3008
3009
drhf089aa42008-07-08 19:34:06 +00003010void sqlite3SetString(char **, sqlite3*, const char*, ...);
danielk19774adee202004-05-08 08:23:19 +00003011void sqlite3ErrorMsg(Parse*, const char*, ...);
drh24fb6272009-05-01 21:13:36 +00003012int sqlite3Dequote(char*);
drh2646da72005-12-09 20:02:05 +00003013int sqlite3KeywordCode(const unsigned char*, int);
danielk19774adee202004-05-08 08:23:19 +00003014int sqlite3RunParser(Parse*, const char*, char **);
drh80242052004-06-09 00:48:12 +00003015void sqlite3FinishCoding(Parse*);
drh892d3172008-01-10 03:46:36 +00003016int sqlite3GetTempReg(Parse*);
3017void sqlite3ReleaseTempReg(Parse*,int);
3018int sqlite3GetTempRange(Parse*,int);
3019void sqlite3ReleaseTempRange(Parse*,int,int);
drhcdc69552011-12-06 13:24:59 +00003020void sqlite3ClearTempRegCache(Parse*);
drhb7916a72009-05-27 10:31:29 +00003021Expr *sqlite3ExprAlloc(sqlite3*,int,const Token*,int);
3022Expr *sqlite3Expr(sqlite3*,int,const char*);
3023void sqlite3ExprAttachSubtrees(sqlite3*,Expr*,Expr*,Expr*);
drh17435752007-08-16 04:30:38 +00003024Expr *sqlite3PExpr(Parse*, int, Expr*, Expr*, const Token*);
danielk19771e536952007-08-16 10:09:01 +00003025Expr *sqlite3ExprAnd(sqlite3*,Expr*, Expr*);
drh17435752007-08-16 04:30:38 +00003026Expr *sqlite3ExprFunction(Parse*,ExprList*, Token*);
drhfa6bc002004-09-07 16:19:52 +00003027void sqlite3ExprAssignVarNumber(Parse*, Expr*);
drh633e6d52008-07-28 19:34:53 +00003028void sqlite3ExprDelete(sqlite3*, Expr*);
drhb7916a72009-05-27 10:31:29 +00003029ExprList *sqlite3ExprListAppend(Parse*,ExprList*,Expr*);
3030void sqlite3ExprListSetName(Parse*,ExprList*,Token*,int);
3031void sqlite3ExprListSetSpan(Parse*,ExprList*,ExprSpan*);
drh633e6d52008-07-28 19:34:53 +00003032void sqlite3ExprListDelete(sqlite3*, ExprList*);
drh9bb575f2004-09-06 17:24:11 +00003033int sqlite3Init(sqlite3*, char**);
drh234c39d2004-07-24 03:30:47 +00003034int sqlite3InitCallback(void*, int, char**, char**);
danielk197791cf71b2004-06-26 06:37:06 +00003035void sqlite3Pragma(Parse*,Token*,Token*,Token*,int);
drh81028a42012-05-15 18:28:27 +00003036void sqlite3ResetAllSchemasOfConnection(sqlite3*);
3037void sqlite3ResetOneSchema(sqlite3*,int);
3038void sqlite3CollapseDatabaseArray(sqlite3*);
danielk19774adee202004-05-08 08:23:19 +00003039void sqlite3BeginParse(Parse*,int);
drh9bb575f2004-09-06 17:24:11 +00003040void sqlite3CommitInternalChanges(sqlite3*);
drh7d10d5a2008-08-20 16:35:10 +00003041Table *sqlite3ResultSetOfSelect(Parse*,Select*);
danielk1977c00da102006-01-07 13:21:04 +00003042void sqlite3OpenMasterTable(Parse *, int);
drh44156282013-10-23 22:23:03 +00003043Index *sqlite3PrimaryKeyIndex(Table*);
3044i16 sqlite3ColumnOfIndex(Index*, i16);
danielk1977f1a381e2006-06-16 08:01:02 +00003045void sqlite3StartTable(Parse*,Token*,Token*,int,int,int,int);
danielk19774adee202004-05-08 08:23:19 +00003046void sqlite3AddColumn(Parse*,Token*);
3047void sqlite3AddNotNull(Parse*, int);
drhfdd6e852005-12-16 01:06:16 +00003048void sqlite3AddPrimaryKey(Parse*, ExprList*, int, int, int);
drhffe07b22005-11-03 00:41:17 +00003049void sqlite3AddCheckConstraint(Parse*, Expr*);
drh487e2622005-06-25 18:42:14 +00003050void sqlite3AddColumnType(Parse*,Token*);
drhb7916a72009-05-27 10:31:29 +00003051void sqlite3AddDefaultValue(Parse*,ExprSpan*);
danielk197739002502007-11-12 09:50:26 +00003052void sqlite3AddCollateType(Parse*, Token*);
drh5969da42013-10-21 02:14:45 +00003053void sqlite3EndTable(Parse*,Token*,Token*,u8,Select*);
drh522c26f2011-05-07 14:40:29 +00003054int sqlite3ParseUri(const char*,const char*,unsigned int*,
3055 sqlite3_vfs**,char**,char **);
drh421377e2012-03-15 21:28:54 +00003056Btree *sqlite3DbNameToBtree(sqlite3*,const char*);
dan1d8cb212011-12-09 13:24:16 +00003057int sqlite3CodeOnce(Parse *);
drhb7f91642004-10-31 02:22:47 +00003058
drhc007f612014-05-16 14:17:01 +00003059#ifdef SQLITE_OMIT_BUILTIN_TEST
3060# define sqlite3FaultSim(X) SQLITE_OK
3061#else
3062 int sqlite3FaultSim(int);
3063#endif
3064
drhf5e7bb52008-02-18 14:47:33 +00003065Bitvec *sqlite3BitvecCreate(u32);
3066int sqlite3BitvecTest(Bitvec*, u32);
3067int sqlite3BitvecSet(Bitvec*, u32);
drhe98c9042009-06-02 21:31:38 +00003068void sqlite3BitvecClear(Bitvec*, u32, void*);
drhf5e7bb52008-02-18 14:47:33 +00003069void sqlite3BitvecDestroy(Bitvec*);
danielk1977bea2a942009-01-20 17:06:27 +00003070u32 sqlite3BitvecSize(Bitvec*);
drh3088d592008-03-21 16:45:47 +00003071int sqlite3BitvecBuiltinTest(int,int*);
drhf5e7bb52008-02-18 14:47:33 +00003072
drh3d4501e2008-12-04 20:40:10 +00003073RowSet *sqlite3RowSetInit(sqlite3*, void*, unsigned int);
3074void sqlite3RowSetClear(RowSet*);
3075void sqlite3RowSetInsert(RowSet*, i64);
drhd83cad22014-04-10 02:24:48 +00003076int sqlite3RowSetTest(RowSet*, int iBatch, i64);
drh3d4501e2008-12-04 20:40:10 +00003077int sqlite3RowSetNext(RowSet*, i64*);
3078
drhfdd48a72006-09-11 23:45:48 +00003079void sqlite3CreateView(Parse*,Token*,Token*,Token*,Select*,int,int);
danielk1977fe3fcbe22006-06-12 12:08:45 +00003080
3081#if !defined(SQLITE_OMIT_VIEW) || !defined(SQLITE_OMIT_VIRTUALTABLE)
drhb7f91642004-10-31 02:22:47 +00003082 int sqlite3ViewGetColumnNames(Parse*,Table*);
3083#else
3084# define sqlite3ViewGetColumnNames(A,B) 0
3085#endif
3086
drha7ab6d82014-07-21 15:44:39 +00003087#if SQLITE_MAX_ATTACHED>30
3088 int sqlite3DbMaskAllZero(yDbMask);
3089#endif
drha0733842005-12-29 01:11:36 +00003090void sqlite3DropTable(Parse*, SrcList*, int, int);
drhfaacf172011-08-12 01:51:45 +00003091void sqlite3CodeDropTable(Parse*, Table*, int, int);
dan1feeaed2010-07-23 15:41:47 +00003092void sqlite3DeleteTable(sqlite3*, Table*);
drh0b9f50d2009-06-23 20:28:53 +00003093#ifndef SQLITE_OMIT_AUTOINCREMENT
3094 void sqlite3AutoincrementBegin(Parse *pParse);
3095 void sqlite3AutoincrementEnd(Parse *pParse);
3096#else
3097# define sqlite3AutoincrementBegin(X)
3098# define sqlite3AutoincrementEnd(X)
3099#endif
drh75593d92014-01-10 20:46:55 +00003100void sqlite3Insert(Parse*, SrcList*, Select*, IdList*, int);
drh6c535152012-02-02 03:38:30 +00003101void *sqlite3ArrayAllocate(sqlite3*,void*,int,int*,int*);
drh17435752007-08-16 04:30:38 +00003102IdList *sqlite3IdListAppend(sqlite3*, IdList*, Token*);
danielk19774adee202004-05-08 08:23:19 +00003103int sqlite3IdListIndex(IdList*,const char*);
drha78c22c2008-11-11 18:28:58 +00003104SrcList *sqlite3SrcListEnlarge(sqlite3*, SrcList*, int, int);
drh17435752007-08-16 04:30:38 +00003105SrcList *sqlite3SrcListAppend(sqlite3*, SrcList*, Token*, Token*);
danielk1977b1c685b2008-10-06 16:18:39 +00003106SrcList *sqlite3SrcListAppendFromTerm(Parse*, SrcList*, Token*, Token*,
danielk197785574e32008-10-06 05:32:18 +00003107 Token*, Select*, Expr*, IdList*);
danielk1977b1c685b2008-10-06 16:18:39 +00003108void sqlite3SrcListIndexedBy(Parse *, SrcList *, Token *);
3109int sqlite3IndexedByLookup(Parse *, struct SrcList_item *);
drh61dfc312006-12-16 16:25:15 +00003110void sqlite3SrcListShiftJoinType(SrcList*);
danielk19774adee202004-05-08 08:23:19 +00003111void sqlite3SrcListAssignCursors(Parse*, SrcList*);
drh633e6d52008-07-28 19:34:53 +00003112void sqlite3IdListDelete(sqlite3*, IdList*);
3113void sqlite3SrcListDelete(sqlite3*, SrcList*);
drhbbbdc832013-10-22 18:01:40 +00003114Index *sqlite3AllocateIndexObject(sqlite3*,i16,int,char**);
dan1da40a32009-09-19 17:00:31 +00003115Index *sqlite3CreateIndex(Parse*,Token*,Token*,SrcList*,ExprList*,int,Token*,
drh8a9789b2013-08-01 03:36:59 +00003116 Expr*, int, int);
drh4d91a702006-01-04 15:54:36 +00003117void sqlite3DropIndex(Parse*, SrcList*, int);
drh7d10d5a2008-08-20 16:35:10 +00003118int sqlite3Select(Parse*, Select*, SelectDest*);
drh17435752007-08-16 04:30:38 +00003119Select *sqlite3SelectNew(Parse*,ExprList*,SrcList*,Expr*,ExprList*,
drh832ee3d2012-12-18 19:36:11 +00003120 Expr*,ExprList*,u16,Expr*,Expr*);
drh633e6d52008-07-28 19:34:53 +00003121void sqlite3SelectDelete(sqlite3*, Select*);
danielk19774adee202004-05-08 08:23:19 +00003122Table *sqlite3SrcListLookup(Parse*, SrcList*);
3123int sqlite3IsReadOnly(Parse*, Table*, int);
danielk1977c00da102006-01-07 13:21:04 +00003124void sqlite3OpenTable(Parse*, int iCur, int iDb, Table*, int);
shane273f6192008-10-10 04:34:16 +00003125#if defined(SQLITE_ENABLE_UPDATE_DELETE_LIMIT) && !defined(SQLITE_OMIT_SUBQUERY)
drh4bde3702013-02-19 18:34:12 +00003126Expr *sqlite3LimitWhere(Parse*,SrcList*,Expr*,ExprList*,Expr*,Expr*,char*);
shane4281bd42008-10-07 05:27:11 +00003127#endif
danielk19774adee202004-05-08 08:23:19 +00003128void sqlite3DeleteFrom(Parse*, SrcList*, Expr*);
3129void sqlite3Update(Parse*, SrcList*, ExprList*, Expr*, int);
drh46ec5b62012-09-24 15:30:54 +00003130WhereInfo *sqlite3WhereBegin(Parse*,SrcList*,Expr*,ExprList*,ExprList*,u16,int);
danielk19774adee202004-05-08 08:23:19 +00003131void sqlite3WhereEnd(WhereInfo*);
drhc63367e2013-06-10 20:46:50 +00003132u64 sqlite3WhereOutputRowCount(WhereInfo*);
drh6f328482013-06-05 23:39:34 +00003133int sqlite3WhereIsDistinct(WhereInfo*);
3134int sqlite3WhereIsOrdered(WhereInfo*);
dan374cd782014-04-21 13:21:56 +00003135int sqlite3WhereIsSorted(WhereInfo*);
drh6f328482013-06-05 23:39:34 +00003136int sqlite3WhereContinueLabel(WhereInfo*);
3137int sqlite3WhereBreakLabel(WhereInfo*);
drhfc8d4f92013-11-08 15:19:46 +00003138int sqlite3WhereOkOnePass(WhereInfo*, int*);
drha748fdc2012-03-28 01:34:47 +00003139int sqlite3ExprCodeGetColumn(Parse*, Table*, int, int, int, u8);
drh5c092e82010-05-14 19:24:02 +00003140void sqlite3ExprCodeGetColumnOfTable(Vdbe*, Table*, int, int, int);
drhb21e7c72008-06-22 12:37:57 +00003141void sqlite3ExprCodeMove(Parse*, int, int, int);
drhceea3322009-04-23 13:22:42 +00003142void sqlite3ExprCacheStore(Parse*, int, int, int);
3143void sqlite3ExprCachePush(Parse*);
drhd2490902014-04-13 19:28:15 +00003144void sqlite3ExprCachePop(Parse*);
drhf49f3522009-12-30 14:12:38 +00003145void sqlite3ExprCacheRemove(Parse*, int, int);
drhceea3322009-04-23 13:22:42 +00003146void sqlite3ExprCacheClear(Parse*);
drhda250ea2008-04-01 05:07:14 +00003147void sqlite3ExprCacheAffinityChange(Parse*, int, int);
drh05a86c52014-02-16 01:55:49 +00003148void sqlite3ExprCode(Parse*, Expr*, int);
3149void sqlite3ExprCodeFactorable(Parse*, Expr*, int);
drhd673cdd2013-11-21 21:23:31 +00003150void sqlite3ExprCodeAtInit(Parse*, Expr*, int, u8);
drh2dcef112008-01-12 19:03:48 +00003151int sqlite3ExprCodeTemp(Parse*, Expr*, int*);
drh678ccce2008-03-31 18:19:54 +00003152int sqlite3ExprCodeTarget(Parse*, Expr*, int);
drh05a86c52014-02-16 01:55:49 +00003153void sqlite3ExprCodeAndCache(Parse*, Expr*, int);
drhd1a01ed2013-11-21 16:08:52 +00003154int sqlite3ExprCodeExprList(Parse*, ExprList*, int, u8);
3155#define SQLITE_ECEL_DUP 0x01 /* Deep, not shallow copies */
3156#define SQLITE_ECEL_FACTOR 0x02 /* Factor out constant terms */
danielk19774adee202004-05-08 08:23:19 +00003157void sqlite3ExprIfTrue(Parse*, Expr*, int, int);
3158void sqlite3ExprIfFalse(Parse*, Expr*, int, int);
drh9bb575f2004-09-06 17:24:11 +00003159Table *sqlite3FindTable(sqlite3*,const char*, const char*);
drhca424112008-01-25 15:04:48 +00003160Table *sqlite3LocateTable(Parse*,int isView,const char*, const char*);
dan41fb5cd2012-10-04 19:33:00 +00003161Table *sqlite3LocateTableItem(Parse*,int isView,struct SrcList_item *);
drh9bb575f2004-09-06 17:24:11 +00003162Index *sqlite3FindIndex(sqlite3*,const char*, const char*);
3163void sqlite3UnlinkAndDeleteTable(sqlite3*,int,const char*);
3164void sqlite3UnlinkAndDeleteIndex(sqlite3*,int,const char*);
drh74161702006-02-24 02:53:49 +00003165void sqlite3Vacuum(Parse*);
drh9bb575f2004-09-06 17:24:11 +00003166int sqlite3RunVacuum(char**, sqlite3*);
drh17435752007-08-16 04:30:38 +00003167char *sqlite3NameFromToken(sqlite3*, Token*);
drh619a1302013-08-01 13:04:46 +00003168int sqlite3ExprCompare(Expr*, Expr*, int);
3169int sqlite3ExprListCompare(ExprList*, ExprList*, int);
drh4bd5f732013-07-31 23:22:39 +00003170int sqlite3ExprImpliesExpr(Expr*, Expr*, int);
drhd2b3e232008-01-23 14:51:49 +00003171void sqlite3ExprAnalyzeAggregates(NameContext*, Expr*);
3172void sqlite3ExprAnalyzeAggList(NameContext*,ExprList*);
drh030796d2012-08-23 16:18:10 +00003173int sqlite3FunctionUsesThisSrc(Expr*, SrcList*);
danielk19774adee202004-05-08 08:23:19 +00003174Vdbe *sqlite3GetVdbe(Parse*);
drh2fa18682008-03-19 14:15:34 +00003175void sqlite3PrngSaveState(void);
3176void sqlite3PrngRestoreState(void);
drh0f198a72012-02-13 16:43:16 +00003177void sqlite3RollbackAll(sqlite3*,int);
danielk19774adee202004-05-08 08:23:19 +00003178void sqlite3CodeVerifySchema(Parse*, int);
dan57966752011-04-09 17:32:58 +00003179void sqlite3CodeVerifyNamedSchema(Parse*, const char *zDb);
drh684917c2004-10-05 02:41:42 +00003180void sqlite3BeginTransaction(Parse*, int);
danielk19774adee202004-05-08 08:23:19 +00003181void sqlite3CommitTransaction(Parse*);
3182void sqlite3RollbackTransaction(Parse*);
danielk1977fd7f0452008-12-17 17:30:26 +00003183void sqlite3Savepoint(Parse*, int, Token*);
3184void sqlite3CloseSavepoints(sqlite3 *);
drh4245c402012-06-02 14:32:21 +00003185void sqlite3LeaveMutexAndCloseZombie(sqlite3*);
danielk19774adee202004-05-08 08:23:19 +00003186int sqlite3ExprIsConstant(Expr*);
drh0a168372007-06-08 00:20:47 +00003187int sqlite3ExprIsConstantNotJoin(Expr*);
drheb55bd22005-06-30 17:04:21 +00003188int sqlite3ExprIsConstantOrFunction(Expr*);
danielk19774adee202004-05-08 08:23:19 +00003189int sqlite3ExprIsInteger(Expr*, int*);
drh039fc322009-11-17 18:31:47 +00003190int sqlite3ExprCanBeNull(const Expr*);
3191int sqlite3ExprNeedsNoAffinityChange(const Expr*, char);
danielk19774adee202004-05-08 08:23:19 +00003192int sqlite3IsRowid(const char*);
drh392ee212013-11-08 16:54:56 +00003193void sqlite3GenerateRowDelete(Parse*,Table*,Trigger*,int,int,int,i16,u8,u8,u8);
drh26198bb2013-10-31 11:15:09 +00003194void sqlite3GenerateRowIndexDelete(Parse*, Table*, int, int, int*);
drh1c2c0b72014-01-04 19:27:05 +00003195int sqlite3GenerateIndexKey(Parse*, Index*, int, int, int, int*,Index*,int);
drh87744512014-04-13 19:15:49 +00003196void sqlite3ResolvePartIdxLabel(Parse*,int);
drhf8ffb272013-11-01 17:08:56 +00003197void sqlite3GenerateConstraintChecks(Parse*,Table*,int*,int,int,int,int,
3198 u8,u8,int,int*);
drh26198bb2013-10-31 11:15:09 +00003199void sqlite3CompleteInsertion(Parse*,Table*,int,int,int,int*,int,int,int);
drh6a534992013-11-16 20:13:39 +00003200int sqlite3OpenTableAndIndices(Parse*, Table*, int, int, u8*, int*, int*);
danielk19774adee202004-05-08 08:23:19 +00003201void sqlite3BeginWriteOperation(Parse*, int, int);
drhff738bc2009-09-24 00:09:58 +00003202void sqlite3MultiWrite(Parse*);
3203void sqlite3MayAbort(Parse*);
drhf9c8ce32013-11-05 13:33:55 +00003204void sqlite3HaltConstraint(Parse*, int, int, char*, i8, u8);
3205void sqlite3UniqueConstraint(Parse*, int, Index*);
3206void sqlite3RowidConstraint(Parse*, int, Table*);
danielk19776ab3a2e2009-02-19 14:39:25 +00003207Expr *sqlite3ExprDup(sqlite3*,Expr*,int);
danielk19776ab3a2e2009-02-19 14:39:25 +00003208ExprList *sqlite3ExprListDup(sqlite3*,ExprList*,int);
3209SrcList *sqlite3SrcListDup(sqlite3*,SrcList*,int);
drh17435752007-08-16 04:30:38 +00003210IdList *sqlite3IdListDup(sqlite3*,IdList*);
danielk19776ab3a2e2009-02-19 14:39:25 +00003211Select *sqlite3SelectDup(sqlite3*,Select*,int);
drh70a8ca32008-08-21 18:49:27 +00003212void sqlite3FuncDefInsert(FuncDefHash*, FuncDef*);
drh89d5d6a2012-04-07 00:09:21 +00003213FuncDef *sqlite3FindFunction(sqlite3*,const char*,int,int,u8,u8);
drh9bb575f2004-09-06 17:24:11 +00003214void sqlite3RegisterBuiltinFunctions(sqlite3*);
drh777c5382008-08-21 20:21:34 +00003215void sqlite3RegisterDateTimeFunctions(void);
drh70a8ca32008-08-21 18:49:27 +00003216void sqlite3RegisterGlobalFunctions(void);
drh7e8b8482008-01-23 03:03:05 +00003217int sqlite3SafetyCheckOk(sqlite3*);
3218int sqlite3SafetyCheckSickOrOk(sqlite3*);
drh9cbf3422008-01-17 16:22:13 +00003219void sqlite3ChangeCookie(Parse*, int);
shanefa4e62f2008-09-01 21:59:42 +00003220
3221#if !defined(SQLITE_OMIT_VIEW) && !defined(SQLITE_OMIT_TRIGGER)
drh2a5d8252008-08-22 12:30:52 +00003222void sqlite3MaterializeView(Parse*, Table*, Expr*, int);
shanefa4e62f2008-09-01 21:59:42 +00003223#endif
drhb7f91642004-10-31 02:22:47 +00003224
3225#ifndef SQLITE_OMIT_TRIGGER
3226 void sqlite3BeginTrigger(Parse*, Token*,Token*,int,int,IdList*,SrcList*,
drh60218d22007-04-06 11:26:00 +00003227 Expr*,int, int);
drhb7f91642004-10-31 02:22:47 +00003228 void sqlite3FinishTrigger(Parse*, TriggerStep*, Token*);
drhfdd48a72006-09-11 23:45:48 +00003229 void sqlite3DropTrigger(Parse*, SrcList*, int);
drh74161702006-02-24 02:53:49 +00003230 void sqlite3DropTriggerPtr(Parse*, Trigger*);
danielk19772f886d12009-02-28 10:47:41 +00003231 Trigger *sqlite3TriggersExist(Parse *, Table*, int, ExprList*, int *pMask);
3232 Trigger *sqlite3TriggerList(Parse *, Table *);
dan165921a2009-08-28 18:53:45 +00003233 void sqlite3CodeRowTrigger(Parse*, Trigger *, int, ExprList*, int, Table *,
dan94d7f502009-09-24 09:05:49 +00003234 int, int, int);
dan1da40a32009-09-19 17:00:31 +00003235 void sqlite3CodeRowTriggerDirect(Parse *, Trigger *, Table *, int, int, int);
drhb7f91642004-10-31 02:22:47 +00003236 void sqliteViewTriggers(Parse*, Table*, Expr*, int, ExprList*);
drh633e6d52008-07-28 19:34:53 +00003237 void sqlite3DeleteTriggerStep(sqlite3*, TriggerStep*);
drh17435752007-08-16 04:30:38 +00003238 TriggerStep *sqlite3TriggerSelectStep(sqlite3*,Select*);
3239 TriggerStep *sqlite3TriggerInsertStep(sqlite3*,Token*, IdList*,
drh75593d92014-01-10 20:46:55 +00003240 Select*,u8);
shane5eff7cf2009-08-10 03:57:58 +00003241 TriggerStep *sqlite3TriggerUpdateStep(sqlite3*,Token*,ExprList*, Expr*, u8);
drh17435752007-08-16 04:30:38 +00003242 TriggerStep *sqlite3TriggerDeleteStep(sqlite3*,Token*, Expr*);
drh633e6d52008-07-28 19:34:53 +00003243 void sqlite3DeleteTrigger(sqlite3*, Trigger*);
drhb7f91642004-10-31 02:22:47 +00003244 void sqlite3UnlinkAndDeleteTrigger(sqlite3*,int,const char*);
danbb5f1682009-11-27 12:12:34 +00003245 u32 sqlite3TriggerColmask(Parse*,Trigger*,ExprList*,int,int,Table*,int);
dan65a7cd12009-09-01 12:16:01 +00003246# define sqlite3ParseToplevel(p) ((p)->pToplevel ? (p)->pToplevel : (p))
drhb7f91642004-10-31 02:22:47 +00003247#else
danielk197762c14b32008-11-19 09:05:26 +00003248# define sqlite3TriggersExist(B,C,D,E,F) 0
drh633e6d52008-07-28 19:34:53 +00003249# define sqlite3DeleteTrigger(A,B)
drhcdd536f2006-03-17 00:04:03 +00003250# define sqlite3DropTriggerPtr(A,B)
drhb7f91642004-10-31 02:22:47 +00003251# define sqlite3UnlinkAndDeleteTrigger(A,B,C)
dan94d7f502009-09-24 09:05:49 +00003252# define sqlite3CodeRowTrigger(A,B,C,D,E,F,G,H,I)
dan75cbd982009-09-21 16:06:03 +00003253# define sqlite3CodeRowTriggerDirect(A,B,C,D,E,F)
danielk19772943c372009-04-07 14:14:22 +00003254# define sqlite3TriggerList(X, Y) 0
dan65a7cd12009-09-01 12:16:01 +00003255# define sqlite3ParseToplevel(p) p
danbb5f1682009-11-27 12:12:34 +00003256# define sqlite3TriggerColmask(A,B,C,D,E,F,G) 0
drhb7f91642004-10-31 02:22:47 +00003257#endif
3258
danielk19774adee202004-05-08 08:23:19 +00003259int sqlite3JoinType(Parse*, Token*, Token*, Token*);
danielk19770202b292004-06-09 09:55:16 +00003260void sqlite3CreateForeignKey(Parse*, ExprList*, Token*, ExprList*, int);
danielk19774adee202004-05-08 08:23:19 +00003261void sqlite3DeferForeignKey(Parse*, int);
drhed6c8672003-01-12 18:02:16 +00003262#ifndef SQLITE_OMIT_AUTHORIZATION
drh728b5772007-09-18 15:55:07 +00003263 void sqlite3AuthRead(Parse*,Expr*,Schema*,SrcList*);
danielk19774adee202004-05-08 08:23:19 +00003264 int sqlite3AuthCheck(Parse*,int, const char*, const char*, const char*);
3265 void sqlite3AuthContextPush(Parse*, AuthContext*, const char*);
3266 void sqlite3AuthContextPop(AuthContext*);
dan02470b22009-10-03 07:04:11 +00003267 int sqlite3AuthReadCol(Parse*, const char *, const char *, int);
drhed6c8672003-01-12 18:02:16 +00003268#else
danielk1977b5258c32007-10-04 18:11:15 +00003269# define sqlite3AuthRead(a,b,c,d)
danielk19774adee202004-05-08 08:23:19 +00003270# define sqlite3AuthCheck(a,b,c,d,e) SQLITE_OK
3271# define sqlite3AuthContextPush(a,b,c)
3272# define sqlite3AuthContextPop(a) ((void)(a))
drhed6c8672003-01-12 18:02:16 +00003273#endif
danielk1977f744bb52005-12-06 17:19:11 +00003274void sqlite3Attach(Parse*, Expr*, Expr*, Expr*);
3275void sqlite3Detach(Parse*, Expr*);
drhd100f692013-10-03 15:39:44 +00003276void sqlite3FixInit(DbFixer*, Parse*, int, const char*, const Token*);
danielk19774adee202004-05-08 08:23:19 +00003277int sqlite3FixSrcList(DbFixer*, SrcList*);
3278int sqlite3FixSelect(DbFixer*, Select*);
3279int sqlite3FixExpr(DbFixer*, Expr*);
3280int sqlite3FixExprList(DbFixer*, ExprList*);
3281int sqlite3FixTriggerStep(DbFixer*, TriggerStep*);
drh9339da12010-09-30 00:50:49 +00003282int sqlite3AtoF(const char *z, double*, int, u8);
drhfec19aa2004-05-19 20:41:03 +00003283int sqlite3GetInt32(const char *, int*);
drh60ac3f42010-11-23 18:59:27 +00003284int sqlite3Atoi(const char*);
drhee858132007-05-08 20:37:38 +00003285int sqlite3Utf16ByteLen(const void *pData, int nChar);
3286int sqlite3Utf8CharLen(const char *pData, int nByte);
drh42610962012-09-17 18:56:32 +00003287u32 sqlite3Utf8Read(const u8**);
drhbf539c42013-10-05 18:16:02 +00003288LogEst sqlite3LogEst(u64);
3289LogEst sqlite3LogEstAdd(LogEst,LogEst);
3290#ifndef SQLITE_OMIT_VIRTUALTABLE
3291LogEst sqlite3LogEstFromDouble(double);
3292#endif
3293u64 sqlite3LogEstToInt(LogEst);
shane3f8d5cf2008-04-24 19:15:09 +00003294
3295/*
3296** Routines to read and write variable-length integers. These used to
3297** be defined locally, but now we use the varint routines in the util.c
shane952856a2008-04-28 17:41:30 +00003298** file. Code should use the MACRO forms below, as the Varint32 versions
3299** are coded to assume the single byte case is already handled (which
3300** the MACRO form does).
shane3f8d5cf2008-04-24 19:15:09 +00003301*/
drh35b5a332008-04-05 18:41:42 +00003302int sqlite3PutVarint(unsigned char*, u64);
3303int sqlite3PutVarint32(unsigned char*, u32);
drh1bd10f82008-12-10 21:19:56 +00003304u8 sqlite3GetVarint(const unsigned char *, u64 *);
3305u8 sqlite3GetVarint32(const unsigned char *, u32 *);
danielk1977192ac1d2004-05-10 07:17:30 +00003306int sqlite3VarintLen(u64 v);
shane3f8d5cf2008-04-24 19:15:09 +00003307
3308/*
3309** The header of a record consists of a sequence variable-length integers.
3310** These integers are almost always small and are encoded as a single byte.
3311** The following macros take advantage this fact to provide a fast encode
3312** and decode of the integers in a record header. It is faster for the common
3313** case where the integer is a single byte. It is a little slower when the
3314** integer is two or more bytes. But overall it is faster.
3315**
3316** The following expressions are equivalent:
3317**
3318** x = sqlite3GetVarint32( A, &B );
3319** x = sqlite3PutVarint32( A, B );
3320**
3321** x = getVarint32( A, B );
3322** x = putVarint32( A, B );
3323**
3324*/
drh4bde3702013-02-19 18:34:12 +00003325#define getVarint32(A,B) \
3326 (u8)((*(A)<(u8)0x80)?((B)=(u32)*(A)),1:sqlite3GetVarint32((A),(u32 *)&(B)))
3327#define putVarint32(A,B) \
3328 (u8)(((u32)(B)<(u32)0x80)?(*(A)=(unsigned char)(B)),1:\
3329 sqlite3PutVarint32((A),(B)))
shane3f8d5cf2008-04-24 19:15:09 +00003330#define getVarint sqlite3GetVarint
3331#define putVarint sqlite3PutVarint
3332
3333
dan69f8bb92009-08-13 19:21:16 +00003334const char *sqlite3IndexAffinityStr(Vdbe *, Index *);
drh57bf4a82014-02-17 14:59:22 +00003335void sqlite3TableAffinity(Vdbe*, Table*, int);
danielk1977e014a832004-05-17 10:48:57 +00003336char sqlite3CompareAffinity(Expr *pExpr, char aff2);
danielk1977e014a832004-05-17 10:48:57 +00003337int sqlite3IndexAffinityOk(Expr *pExpr, char idx_affinity);
danielk1977bf3b7212004-05-18 10:06:24 +00003338char sqlite3ExprAffinity(Expr *pExpr);
drh9339da12010-09-30 00:50:49 +00003339int sqlite3Atoi64(const char*, i64*, int, u8);
drh9296c182014-07-23 13:40:49 +00003340int sqlite3DecOrHexToI64(const char*, i64*);
drh9bb575f2004-09-06 17:24:11 +00003341void sqlite3Error(sqlite3*, int, const char*,...);
drhca48c902008-01-18 14:08:24 +00003342void *sqlite3HexToBlob(sqlite3*, const char *z, int n);
dancd74b612011-04-22 19:37:32 +00003343u8 sqlite3HexToInt(int h);
danielk1977ef2cb632004-05-29 02:37:19 +00003344int sqlite3TwoPartName(Parse *, Token *, Token *, Token **);
mistachkindd08ca02013-04-30 07:58:15 +00003345
drh685e3c42013-12-21 17:07:13 +00003346#if defined(SQLITE_TEST)
mistachkinf2c1c992013-04-28 01:44:43 +00003347const char *sqlite3ErrName(int);
mistachkindd08ca02013-04-30 07:58:15 +00003348#endif
3349
danielk1977f20b21c2004-05-31 23:56:42 +00003350const char *sqlite3ErrStr(int);
danielk19778a414492004-06-29 08:59:35 +00003351int sqlite3ReadSchema(Parse *pParse);
drhc4a64fa2009-05-11 20:53:28 +00003352CollSeq *sqlite3FindCollSeq(sqlite3*,u8 enc, const char*,int);
3353CollSeq *sqlite3LocateCollSeq(Parse *pParse, const char*zName);
danielk19777cedc8d2004-06-10 10:50:08 +00003354CollSeq *sqlite3ExprCollSeq(Parse *pParse, Expr *pExpr);
drh4ef7efa2014-03-20 15:14:08 +00003355Expr *sqlite3ExprAddCollateToken(Parse *pParse, Expr*, const Token*);
drh0a8a4062012-12-07 18:38:16 +00003356Expr *sqlite3ExprAddCollateString(Parse*,Expr*,const char*);
3357Expr *sqlite3ExprSkipCollate(Expr*);
danielk19777cedc8d2004-06-10 10:50:08 +00003358int sqlite3CheckCollSeq(Parse *, CollSeq *);
danielk1977d8123362004-06-12 09:25:12 +00003359int sqlite3CheckObjectName(Parse *, const char *);
danielk1977b28af712004-06-21 06:50:26 +00003360void sqlite3VdbeSetChanges(sqlite3 *, int);
drh158b9cb2011-03-05 20:59:46 +00003361int sqlite3AddInt64(i64*,i64);
3362int sqlite3SubInt64(i64*,i64);
3363int sqlite3MulInt64(i64*,i64);
drhd50ffc42011-03-08 02:38:28 +00003364int sqlite3AbsInt32(int);
drh81cc5162011-05-17 20:36:21 +00003365#ifdef SQLITE_ENABLE_8_3_NAMES
3366void sqlite3FileSuffix3(const char*, char*);
3367#else
3368# define sqlite3FileSuffix3(X,Y)
3369#endif
drheac5bd72014-07-25 21:35:39 +00003370u8 sqlite3GetBoolean(const char *z,u8);
danielk19774e6af132004-06-10 14:01:08 +00003371
drhb21c8cd2007-08-21 19:33:56 +00003372const void *sqlite3ValueText(sqlite3_value*, u8);
3373int sqlite3ValueBytes(sqlite3_value*, u8);
3374void sqlite3ValueSetStr(sqlite3_value*, int, const void *,u8,
danielk19771e536952007-08-16 10:09:01 +00003375 void(*)(void*));
drha3cc0072013-12-13 16:23:55 +00003376void sqlite3ValueSetNull(sqlite3_value*);
danielk19774e6af132004-06-10 14:01:08 +00003377void sqlite3ValueFree(sqlite3_value*);
danielk19771e536952007-08-16 10:09:01 +00003378sqlite3_value *sqlite3ValueNew(sqlite3 *);
danb7dca7d2010-03-05 16:32:12 +00003379char *sqlite3Utf16to8(sqlite3 *, const void*, int, u8);
danielk19771e536952007-08-16 10:09:01 +00003380int sqlite3ValueFromExpr(sqlite3 *, Expr *, u8, u8, sqlite3_value **);
drhb21c8cd2007-08-21 19:33:56 +00003381void sqlite3ValueApplyAffinity(sqlite3_value *, u8, u8);
drh46c99e02007-08-27 23:26:59 +00003382#ifndef SQLITE_AMALGAMATION
drha6c2ed92009-11-14 23:22:23 +00003383extern const unsigned char sqlite3OpcodeProperty[];
drh4e5ffc52004-08-31 00:52:37 +00003384extern const unsigned char sqlite3UpperToLower[];
danielk197778ca0e72009-01-20 16:53:39 +00003385extern const unsigned char sqlite3CtypeMap[];
drh094430e2010-07-14 18:24:06 +00003386extern const Token sqlite3IntTokens[];
danielk1977075c23a2008-09-01 18:34:20 +00003387extern SQLITE_WSD struct Sqlite3Config sqlite3Config;
3388extern SQLITE_WSD FuncDefHash sqlite3GlobalFunctions;
drhf83dc1e2010-06-03 12:09:52 +00003389#ifndef SQLITE_OMIT_WSD
drhddb68e12009-02-05 16:53:43 +00003390extern int sqlite3PendingByte;
drh46c99e02007-08-27 23:26:59 +00003391#endif
drhf83dc1e2010-06-03 12:09:52 +00003392#endif
drhcdf011d2011-04-04 21:25:28 +00003393void sqlite3RootPageMoved(sqlite3*, int, int, int);
drh4343fea2004-11-05 23:46:15 +00003394void sqlite3Reindex(Parse*, Token*, Token*);
drh545f5872010-04-24 14:02:59 +00003395void sqlite3AlterFunctions(void);
danielk19779fd2a9a2004-11-12 13:42:30 +00003396void sqlite3AlterRenameTable(Parse*, SrcList*, Token*);
3397int sqlite3GetToken(const unsigned char *, int *);
drh2958a4e2004-11-12 03:56:15 +00003398void sqlite3NestedParse(Parse*, const char*, ...);
drhd89bd002005-01-22 03:03:54 +00003399void sqlite3ExpirePreparedStatements(sqlite3*);
drh1450bc62009-10-30 13:25:56 +00003400int sqlite3CodeSubselect(Parse *, Expr *, int, int);
drh7d10d5a2008-08-20 16:35:10 +00003401void sqlite3SelectPrep(Parse*, Select*, NameContext*);
drh3e3f1a52013-01-03 00:45:56 +00003402int sqlite3MatchSpanName(const char*, const char*, const char*, const char*);
drh7d10d5a2008-08-20 16:35:10 +00003403int sqlite3ResolveExprNames(NameContext*, Expr*);
drh7d10d5a2008-08-20 16:35:10 +00003404void sqlite3ResolveSelectNames(Parse*, Select*, NameContext*);
drh3780be12013-07-31 19:05:22 +00003405void sqlite3ResolveSelfReference(Parse*,Table*,int,Expr*,ExprList*);
drh7d10d5a2008-08-20 16:35:10 +00003406int sqlite3ResolveOrderGroupBy(Parse*, Select*, ExprList*, const char*);
danielk1977c7538b52009-07-27 10:05:04 +00003407void sqlite3ColumnDefault(Vdbe *, Table *, int, int);
danielk197719a8e7e2005-03-17 05:03:38 +00003408void sqlite3AlterFinishAddColumn(Parse *, Token *);
3409void sqlite3AlterBeginAddColumn(Parse *, SrcList *);
drh79e72a52012-10-05 14:43:40 +00003410CollSeq *sqlite3GetCollSeq(Parse*, u8, CollSeq *, const char*);
drhfdaac672013-10-04 15:30:21 +00003411char sqlite3AffinityType(const char*, u8*);
drh9f18e8a2005-07-08 12:13:04 +00003412void sqlite3Analyze(Parse*, Token*, Token*);
drha4afb652005-07-09 02:16:02 +00003413int sqlite3InvokeBusyHandler(BusyHandler*);
drhff2d5ea2005-07-23 00:41:48 +00003414int sqlite3FindDb(sqlite3*, Token*);
danielk197704103022009-02-03 16:51:24 +00003415int sqlite3FindDbName(sqlite3 *, const char *);
drhcf1be452007-05-12 12:08:51 +00003416int sqlite3AnalysisLoad(sqlite3*,int iDB);
dand46def72010-07-24 11:28:28 +00003417void sqlite3DeleteIndexSamples(sqlite3*,Index*);
drh51147ba2005-07-23 22:59:55 +00003418void sqlite3DefaultRowEst(Index*);
drh55ef4d92005-08-14 01:20:37 +00003419void sqlite3RegisterLikeFunctions(sqlite3*, int);
drhd64fe2f2005-08-28 17:00:23 +00003420int sqlite3IsLikeFunction(sqlite3*,Expr*,int*,char*);
drhfdd6e852005-12-16 01:06:16 +00003421void sqlite3MinimumFileFormat(Parse*, int, int);
drhb6ee6602011-04-04 13:40:53 +00003422void sqlite3SchemaClear(void *);
danielk19771e536952007-08-16 10:09:01 +00003423Schema *sqlite3SchemaGet(sqlite3 *, Btree *);
danielk1977e501b892006-01-09 06:29:47 +00003424int sqlite3SchemaToIndex(sqlite3 *db, Schema *);
drhad124322013-10-23 13:30:58 +00003425KeyInfo *sqlite3KeyInfoAlloc(sqlite3*,int,int);
drh2ec2fb22013-11-06 19:59:23 +00003426void sqlite3KeyInfoUnref(KeyInfo*);
3427KeyInfo *sqlite3KeyInfoRef(KeyInfo*);
3428KeyInfo *sqlite3KeyInfoOfIndex(Parse*, Index*);
3429#ifdef SQLITE_DEBUG
3430int sqlite3KeyInfoIsWriteable(KeyInfo*);
3431#endif
danielk1977771151b2006-01-17 13:21:40 +00003432int sqlite3CreateFunc(sqlite3 *, const char *, int, int, void *,
3433 void (*)(sqlite3_context*,int,sqlite3_value **),
dand2199f02010-08-27 17:48:52 +00003434 void (*)(sqlite3_context*,int,sqlite3_value **), void (*)(sqlite3_context*),
3435 FuncDestructor *pDestructor
3436);
danielk197754f01982006-01-18 15:25:17 +00003437int sqlite3ApiExit(sqlite3 *db, int);
danielk1977ddfb2f02006-02-17 12:25:14 +00003438int sqlite3OpenTempDatabase(Parse *);
drh69dab1d2006-06-27 14:37:20 +00003439
drhf089aa42008-07-08 19:34:06 +00003440void sqlite3StrAccumInit(StrAccum*, char*, int, int);
drhade86482007-11-28 22:36:40 +00003441void sqlite3StrAccumAppend(StrAccum*,const char*,int);
drha6353a32013-12-09 19:03:26 +00003442void sqlite3StrAccumAppendAll(StrAccum*,const char*);
drh7e02e5e2011-12-06 19:44:51 +00003443void sqlite3AppendSpace(StrAccum*,int);
drhade86482007-11-28 22:36:40 +00003444char *sqlite3StrAccumFinish(StrAccum*);
3445void sqlite3StrAccumReset(StrAccum*);
drh1013c932008-01-06 00:25:21 +00003446void sqlite3SelectDestInit(SelectDest*,int,int);
danf7b0b0a2009-10-19 15:52:32 +00003447Expr *sqlite3CreateColumnExpr(sqlite3 *, SrcList *, int, int);
danielk19771e536952007-08-16 10:09:01 +00003448
danielk197704103022009-02-03 16:51:24 +00003449void sqlite3BackupRestart(sqlite3_backup *);
3450void sqlite3BackupUpdate(sqlite3_backup *, Pgno, const u8 *);
3451
drh1435a9a2013-08-27 23:15:44 +00003452#ifdef SQLITE_ENABLE_STAT3_OR_STAT4
drh9fecc542013-08-27 20:16:48 +00003453void sqlite3AnalyzeFunctions(void);
dan87cd9322013-08-07 15:52:41 +00003454int sqlite3Stat4ProbeSetValue(Parse*,Index*,UnpackedRecord**,Expr*,u8,int,int*);
danb0b82902014-06-26 20:21:46 +00003455int sqlite3Stat4ValueFromExpr(Parse*, Expr*, u8, sqlite3_value**);
dan7a419232013-08-06 20:01:43 +00003456void sqlite3Stat4ProbeFree(UnpackedRecord*);
danb0b82902014-06-26 20:21:46 +00003457int sqlite3Stat4Column(sqlite3*, const void*, int, int, sqlite3_value**);
drh9fecc542013-08-27 20:16:48 +00003458#endif
dan7a419232013-08-06 20:01:43 +00003459
drh95bdbbb2007-07-23 19:31:16 +00003460/*
3461** The interface to the LEMON-generated parser
3462*/
3463void *sqlite3ParserAlloc(void*(*)(size_t));
3464void sqlite3ParserFree(void*, void(*)(void*));
3465void sqlite3Parser(void*, int, Token, Parse*);
drhec424a52008-07-25 15:39:03 +00003466#ifdef YYTRACKMAXSTACKDEPTH
3467 int sqlite3ParserStackPeak(void*);
3468#endif
drh95bdbbb2007-07-23 19:31:16 +00003469
drh7aaa8782009-05-20 02:40:45 +00003470void sqlite3AutoLoadExtensions(sqlite3*);
drh69dab1d2006-06-27 14:37:20 +00003471#ifndef SQLITE_OMIT_LOAD_EXTENSION
3472 void sqlite3CloseExtensions(sqlite3*);
3473#else
3474# define sqlite3CloseExtensions(X)
3475#endif
danielk1977e3026632004-06-22 11:29:02 +00003476
danielk1977c00da102006-01-07 13:21:04 +00003477#ifndef SQLITE_OMIT_SHARED_CACHE
3478 void sqlite3TableLock(Parse *, int, int, u8, const char *);
3479#else
3480 #define sqlite3TableLock(v,w,x,y,z)
3481#endif
3482
drh53c14022007-05-10 17:23:11 +00003483#ifdef SQLITE_TEST
3484 int sqlite3Utf8To8(unsigned char*);
3485#endif
3486
drhb9bb7c12006-06-11 23:41:55 +00003487#ifdef SQLITE_OMIT_VIRTUALTABLE
danielk1977595a5232009-07-24 17:58:53 +00003488# define sqlite3VtabClear(Y)
danielk19779dbee7d2008-08-02 15:32:39 +00003489# define sqlite3VtabSync(X,Y) SQLITE_OK
danielk1977f9e7dda2006-06-16 16:08:53 +00003490# define sqlite3VtabRollback(X)
3491# define sqlite3VtabCommit(X)
danielk1977093e0f62008-11-13 18:00:14 +00003492# define sqlite3VtabInSync(db) 0
danielk1977595a5232009-07-24 17:58:53 +00003493# define sqlite3VtabLock(X)
3494# define sqlite3VtabUnlock(X)
3495# define sqlite3VtabUnlockList(X)
dana311b802011-04-26 19:21:34 +00003496# define sqlite3VtabSavepoint(X, Y, Z) SQLITE_OK
drhc3c8dac2011-10-12 19:04:07 +00003497# define sqlite3GetVTable(X,Y) ((VTable*)0)
drhb9bb7c12006-06-11 23:41:55 +00003498#else
dan1feeaed2010-07-23 15:41:47 +00003499 void sqlite3VtabClear(sqlite3 *db, Table*);
danbba02a92012-05-15 17:15:34 +00003500 void sqlite3VtabDisconnect(sqlite3 *db, Table *p);
dan016f7812013-08-21 17:35:48 +00003501 int sqlite3VtabSync(sqlite3 *db, Vdbe*);
danielk1977f9e7dda2006-06-16 16:08:53 +00003502 int sqlite3VtabRollback(sqlite3 *db);
3503 int sqlite3VtabCommit(sqlite3 *db);
danielk1977595a5232009-07-24 17:58:53 +00003504 void sqlite3VtabLock(VTable *);
3505 void sqlite3VtabUnlock(VTable *);
3506 void sqlite3VtabUnlockList(sqlite3*);
dana311b802011-04-26 19:21:34 +00003507 int sqlite3VtabSavepoint(sqlite3 *, int, int);
dan016f7812013-08-21 17:35:48 +00003508 void sqlite3VtabImportErrmsg(Vdbe*, sqlite3_vtab*);
drhc3c8dac2011-10-12 19:04:07 +00003509 VTable *sqlite3GetVTable(sqlite3*, Table*);
danielk1977093e0f62008-11-13 18:00:14 +00003510# define sqlite3VtabInSync(db) ((db)->nVTrans>0 && (db)->aVTrans==0)
drhb9bb7c12006-06-11 23:41:55 +00003511#endif
drh4f3dd152008-04-28 18:46:43 +00003512void sqlite3VtabMakeWritable(Parse*,Table*);
drhb421b892012-01-28 19:41:53 +00003513void sqlite3VtabBeginParse(Parse*, Token*, Token*, Token*, int);
drhb9bb7c12006-06-11 23:41:55 +00003514void sqlite3VtabFinishParse(Parse*, Token*);
3515void sqlite3VtabArgInit(Parse*);
3516void sqlite3VtabArgExtend(Parse*, Token*);
danielk197778efaba2006-06-12 06:09:17 +00003517int sqlite3VtabCallCreate(sqlite3*, int, const char *, char **);
danielk19777e6ebfb2006-06-12 11:24:37 +00003518int sqlite3VtabCallConnect(Parse*, Table*);
danielk19779e39ce82006-06-12 16:01:21 +00003519int sqlite3VtabCallDestroy(sqlite3*, int, const char *);
danielk1977595a5232009-07-24 17:58:53 +00003520int sqlite3VtabBegin(sqlite3 *, VTable *);
danielk19771e536952007-08-16 10:09:01 +00003521FuncDef *sqlite3VtabOverloadFunction(sqlite3 *,FuncDef*, int nArg, Expr*);
drhb7481e72006-09-16 21:45:14 +00003522void sqlite3InvalidFunction(sqlite3_context*,int,sqlite3_value**);
drh95a7b3e2013-09-16 12:57:19 +00003523sqlite3_int64 sqlite3StmtCurrentTime(sqlite3_context*);
drh5f18a222009-11-26 14:01:53 +00003524int sqlite3VdbeParameterIndex(Vdbe*, const char*, int);
shane4a27a282008-09-04 04:32:49 +00003525int sqlite3TransferBindings(sqlite3_stmt *, sqlite3_stmt *);
drhf30a9692013-11-15 01:10:18 +00003526void sqlite3ParserReset(Parse*);
drhb900aaf2006-11-09 00:24:53 +00003527int sqlite3Reprepare(Vdbe*);
drhb1a6c3c2008-03-20 16:30:17 +00003528void sqlite3ExprListCheckLength(Parse*, ExprList*, const char*);
drh0a0e1312007-08-07 17:04:59 +00003529CollSeq *sqlite3BinaryCompareCollSeq(Parse *, Expr *, Expr *);
drh1c514142009-04-30 12:25:10 +00003530int sqlite3TempInMemory(const sqlite3*);
dan28e53862010-04-21 06:19:12 +00003531const char *sqlite3JournalModename(int);
dan06a2d822012-10-10 09:46:29 +00003532#ifndef SQLITE_OMIT_WAL
3533 int sqlite3Checkpoint(sqlite3*, int, int, int*, int*);
3534 int sqlite3WalDefaultHook(void*,sqlite3*,const char*,int);
3535#endif
drh8b471862014-01-11 13:22:17 +00003536#ifndef SQLITE_OMIT_CTE
dan4e9119d2014-01-13 15:12:23 +00003537 With *sqlite3WithAdd(Parse*,With*,Token*,ExprList*,Select*);
dan7d562db2014-01-11 19:19:36 +00003538 void sqlite3WithDelete(sqlite3*,With*);
danb290f112014-01-17 14:59:27 +00003539 void sqlite3WithPush(Parse*, With*, u8);
dan4e9119d2014-01-13 15:12:23 +00003540#else
danb290f112014-01-17 14:59:27 +00003541#define sqlite3WithPush(x,y,z)
daneede6a52014-01-15 19:42:23 +00003542#define sqlite3WithDelete(x,y)
drh8b471862014-01-11 13:22:17 +00003543#endif
danielk1977d8293352009-04-30 09:10:37 +00003544
dan75cbd982009-09-21 16:06:03 +00003545/* Declarations for functions in fkey.c. All of these are replaced by
3546** no-op macros if OMIT_FOREIGN_KEY is defined. In this case no foreign
3547** key functionality is available. If OMIT_TRIGGER is defined but
3548** OMIT_FOREIGN_KEY is not, only some of the functions are no-oped. In
3549** this case foreign keys are parsed, but no other functionality is
3550** provided (enforcement of FK constraints requires the triggers sub-system).
3551*/
3552#if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
dan8ff2d952013-09-05 18:40:29 +00003553 void sqlite3FkCheck(Parse*, Table*, int, int, int*, int);
dand66c8302009-09-28 14:49:01 +00003554 void sqlite3FkDropTable(Parse*, SrcList *, Table*);
dan8ff2d952013-09-05 18:40:29 +00003555 void sqlite3FkActions(Parse*, Table*, ExprList*, int, int*, int);
dane7a94d82009-10-01 16:09:04 +00003556 int sqlite3FkRequired(Parse*, Table*, int*, int);
3557 u32 sqlite3FkOldmask(Parse*, Table*);
dan432cc5b2009-09-26 17:51:48 +00003558 FKey *sqlite3FkReferences(Table *);
dan1da40a32009-09-19 17:00:31 +00003559#else
dan8ff2d952013-09-05 18:40:29 +00003560 #define sqlite3FkActions(a,b,c,d,e,f)
dan67896ce2013-10-14 15:41:39 +00003561 #define sqlite3FkCheck(a,b,c,d,e,f)
dand66c8302009-09-28 14:49:01 +00003562 #define sqlite3FkDropTable(a,b,c)
dan67896ce2013-10-14 15:41:39 +00003563 #define sqlite3FkOldmask(a,b) 0
3564 #define sqlite3FkRequired(a,b,c,d) 0
dan1da40a32009-09-19 17:00:31 +00003565#endif
dan75cbd982009-09-21 16:06:03 +00003566#ifndef SQLITE_OMIT_FOREIGN_KEY
dan1feeaed2010-07-23 15:41:47 +00003567 void sqlite3FkDelete(sqlite3 *, Table*);
drh6c5b9152012-12-17 16:46:37 +00003568 int sqlite3FkLocateIndex(Parse*,Table*,FKey*,Index**,int**);
dan75cbd982009-09-21 16:06:03 +00003569#else
dan1feeaed2010-07-23 15:41:47 +00003570 #define sqlite3FkDelete(a,b)
drh6c5b9152012-12-17 16:46:37 +00003571 #define sqlite3FkLocateIndex(a,b,c,d,e)
dan75cbd982009-09-21 16:06:03 +00003572#endif
3573
drh643167f2008-01-22 21:30:53 +00003574
3575/*
3576** Available fault injectors. Should be numbered beginning with 0.
3577*/
3578#define SQLITE_FAULTINJECTOR_MALLOC 0
drh7e8b8482008-01-23 03:03:05 +00003579#define SQLITE_FAULTINJECTOR_COUNT 1
drh643167f2008-01-22 21:30:53 +00003580
3581/*
danielk1977ef05f2d2008-06-20 11:05:37 +00003582** The interface to the code in fault.c used for identifying "benign"
3583** malloc failures. This is only present if SQLITE_OMIT_BUILTIN_TEST
3584** is not defined.
drh643167f2008-01-22 21:30:53 +00003585*/
drh3088d592008-03-21 16:45:47 +00003586#ifndef SQLITE_OMIT_BUILTIN_TEST
danielk19772d1d86f2008-06-20 14:59:51 +00003587 void sqlite3BeginBenignMalloc(void);
3588 void sqlite3EndBenignMalloc(void);
drh643167f2008-01-22 21:30:53 +00003589#else
danielk19772d1d86f2008-06-20 14:59:51 +00003590 #define sqlite3BeginBenignMalloc()
danielk1977867d05a2008-06-23 14:03:45 +00003591 #define sqlite3EndBenignMalloc()
drh643167f2008-01-22 21:30:53 +00003592#endif
drh643167f2008-01-22 21:30:53 +00003593
drh3a856252014-08-01 14:46:57 +00003594/*
3595** Allowed return values from sqlite3FindInIndex()
3596*/
3597#define IN_INDEX_ROWID 1 /* Search the rowid of the table */
3598#define IN_INDEX_EPH 2 /* Search an ephemeral b-tree */
3599#define IN_INDEX_INDEX_ASC 3 /* Existing index ASCENDING */
3600#define IN_INDEX_INDEX_DESC 4 /* Existing index DESCENDING */
drh3a856252014-08-01 14:46:57 +00003601/*
3602** Allowed flags for the 3rd parameter to sqlite3FindInIndex().
3603*/
drhe80c9b92014-08-01 15:34:36 +00003604#define IN_INDEX_MEMBERSHIP 0x0001 /* IN operator used for membership test */
3605#define IN_INDEX_LOOP 0x0002 /* IN operator used as a loop */
drh3a856252014-08-01 14:46:57 +00003606int sqlite3FindInIndex(Parse *, Expr *, u32, int*);
danielk19779a96b662007-11-29 17:05:18 +00003607
danielk1977c7b60172007-08-22 11:22:03 +00003608#ifdef SQLITE_ENABLE_ATOMIC_WRITE
3609 int sqlite3JournalOpen(sqlite3_vfs *, const char *, sqlite3_file *, int, int);
3610 int sqlite3JournalSize(sqlite3_vfs *);
danielk1977f55b8992007-08-24 08:15:53 +00003611 int sqlite3JournalCreate(sqlite3_file *);
dan3de0f182012-12-05 10:01:35 +00003612 int sqlite3JournalExists(sqlite3_file *p);
danielk1977c7b60172007-08-22 11:22:03 +00003613#else
3614 #define sqlite3JournalSize(pVfs) ((pVfs)->szOsFile)
dan3de0f182012-12-05 10:01:35 +00003615 #define sqlite3JournalExists(p) 1
danielk1977c7b60172007-08-22 11:22:03 +00003616#endif
3617
danielk1977b3175382008-10-17 18:51:52 +00003618void sqlite3MemJournalOpen(sqlite3_file *);
drh3a5990a2008-12-20 02:14:39 +00003619int sqlite3MemJournalSize(void);
danielk1977b3175382008-10-17 18:51:52 +00003620int sqlite3IsMemJournal(sqlite3_file *);
3621
drh0224d262008-05-28 13:49:34 +00003622#if SQLITE_MAX_EXPR_DEPTH>0
danielk19774b5255a2008-06-05 16:47:39 +00003623 void sqlite3ExprSetHeight(Parse *pParse, Expr *p);
danielk1977fc976062007-05-10 10:46:56 +00003624 int sqlite3SelectExprHeight(Select *);
drh7d10d5a2008-08-20 16:35:10 +00003625 int sqlite3ExprCheckHeight(Parse*, int);
danielk1977fc976062007-05-10 10:46:56 +00003626#else
danielk19774b5255a2008-06-05 16:47:39 +00003627 #define sqlite3ExprSetHeight(x,y)
drh0224d262008-05-28 13:49:34 +00003628 #define sqlite3SelectExprHeight(x) 0
drh7d10d5a2008-08-20 16:35:10 +00003629 #define sqlite3ExprCheckHeight(x,y)
danielk1977fc976062007-05-10 10:46:56 +00003630#endif
3631
drha3152892007-05-05 11:48:52 +00003632u32 sqlite3Get4byte(const u8*);
drha3152892007-05-05 11:48:52 +00003633void sqlite3Put4byte(u8*, u32);
3634
danielk1977404ca072009-03-16 13:19:36 +00003635#ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
3636 void sqlite3ConnectionBlocked(sqlite3 *, sqlite3 *);
3637 void sqlite3ConnectionUnlocked(sqlite3 *db);
3638 void sqlite3ConnectionClosed(sqlite3 *db);
3639#else
3640 #define sqlite3ConnectionBlocked(x,y)
3641 #define sqlite3ConnectionUnlocked(x)
3642 #define sqlite3ConnectionClosed(x)
3643#endif
3644
drh6e736832007-05-11 12:30:03 +00003645#ifdef SQLITE_DEBUG
3646 void sqlite3ParserTrace(FILE*, char *);
3647#endif
3648
drhb0603412007-02-28 04:47:26 +00003649/*
3650** If the SQLITE_ENABLE IOTRACE exists then the global variable
mlcreech3a00f902008-03-04 17:45:01 +00003651** sqlite3IoTrace is a pointer to a printf-like routine used to
drhb0603412007-02-28 04:47:26 +00003652** print I/O tracing messages.
3653*/
3654#ifdef SQLITE_ENABLE_IOTRACE
mlcreech3a00f902008-03-04 17:45:01 +00003655# define IOTRACE(A) if( sqlite3IoTrace ){ sqlite3IoTrace A; }
danielk1977b4622b62007-03-02 06:24:19 +00003656 void sqlite3VdbeIOTraceSql(Vdbe*);
drhe265b082008-05-01 17:03:49 +00003657SQLITE_EXTERN void (*sqlite3IoTrace)(const char*,...);
drhb0603412007-02-28 04:47:26 +00003658#else
3659# define IOTRACE(A)
danielk1977b4622b62007-03-02 06:24:19 +00003660# define sqlite3VdbeIOTraceSql(X)
drhb0603412007-02-28 04:47:26 +00003661#endif
drhb0603412007-02-28 04:47:26 +00003662
drh107b56e2010-03-12 16:32:53 +00003663/*
3664** These routines are available for the mem2.c debugging memory allocator
3665** only. They are used to verify that different "types" of memory
3666** allocations are properly tracked by the system.
3667**
3668** sqlite3MemdebugSetType() sets the "type" of an allocation to one of
3669** the MEMTYPE_* macros defined below. The type must be a bitmask with
3670** a single bit set.
3671**
3672** sqlite3MemdebugHasType() returns true if any of the bits in its second
3673** argument match the type set by the previous sqlite3MemdebugSetType().
3674** sqlite3MemdebugHasType() is intended for use inside assert() statements.
drh107b56e2010-03-12 16:32:53 +00003675**
drh174b9a12010-07-26 11:07:20 +00003676** sqlite3MemdebugNoType() returns true if none of the bits in its second
3677** argument match the type set by the previous sqlite3MemdebugSetType().
drh107b56e2010-03-12 16:32:53 +00003678**
3679** Perhaps the most important point is the difference between MEMTYPE_HEAP
drh174b9a12010-07-26 11:07:20 +00003680** and MEMTYPE_LOOKASIDE. If an allocation is MEMTYPE_LOOKASIDE, that means
3681** it might have been allocated by lookaside, except the allocation was
3682** too large or lookaside was already full. It is important to verify
3683** that allocations that might have been satisfied by lookaside are not
3684** passed back to non-lookaside free() routines. Asserts such as the
3685** example above are placed on the non-lookaside free() routines to verify
3686** this constraint.
drh107b56e2010-03-12 16:32:53 +00003687**
3688** All of this is no-op for a production build. It only comes into
3689** play when the SQLITE_MEMDEBUG compile-time option is used.
3690*/
3691#ifdef SQLITE_MEMDEBUG
3692 void sqlite3MemdebugSetType(void*,u8);
3693 int sqlite3MemdebugHasType(void*,u8);
drh174b9a12010-07-26 11:07:20 +00003694 int sqlite3MemdebugNoType(void*,u8);
drh107b56e2010-03-12 16:32:53 +00003695#else
3696# define sqlite3MemdebugSetType(X,Y) /* no-op */
3697# define sqlite3MemdebugHasType(X,Y) 1
drh174b9a12010-07-26 11:07:20 +00003698# define sqlite3MemdebugNoType(X,Y) 1
danielk1977e3026632004-06-22 11:29:02 +00003699#endif
drh174b9a12010-07-26 11:07:20 +00003700#define MEMTYPE_HEAP 0x01 /* General heap allocations */
3701#define MEMTYPE_LOOKASIDE 0x02 /* Might have been lookaside memory */
3702#define MEMTYPE_SCRATCH 0x04 /* Scratch allocations */
3703#define MEMTYPE_PCACHE 0x08 /* Page cache allocations */
3704#define MEMTYPE_DB 0x10 /* Uses sqlite3DbMalloc, not sqlite_malloc */
drh107b56e2010-03-12 16:32:53 +00003705
3706#endif /* _SQLITEINT_H_ */