xref: /sqlite-3.40.0/src/sqliteInt.h (revision bb53ecb1)
175897234Sdrh /*
2b19a2bc6Sdrh ** 2001 September 15
375897234Sdrh **
4b19a2bc6Sdrh ** The author disclaims copyright to this source code.  In place of
5b19a2bc6Sdrh ** a legal notice, here is a blessing:
675897234Sdrh **
7b19a2bc6Sdrh **    May you do good and not evil.
8b19a2bc6Sdrh **    May you find forgiveness for yourself and forgive others.
9b19a2bc6Sdrh **    May you share freely, never taking more than you give.
1075897234Sdrh **
1175897234Sdrh *************************************************************************
1275897234Sdrh ** Internal interface definitions for SQLite.
1375897234Sdrh **
1475897234Sdrh */
15e3026636Sdanielk1977 #ifndef _SQLITEINT_H_
16e3026636Sdanielk1977 #define _SQLITEINT_H_
1771674ce9Sdrh 
18bd0ae111Smlcreech /*
192210dcc6Sdrh ** These #defines should enable >2GB file support on POSIX if the
202210dcc6Sdrh ** underlying operating system supports it.  If the OS lacks
212210dcc6Sdrh ** large file support, or if the OS is windows, these should be no-ops.
222210dcc6Sdrh **
232210dcc6Sdrh ** Ticket #2739:  The _LARGEFILE_SOURCE macro must appear before any
242210dcc6Sdrh ** system #includes.  Hence, this block of code must be the very first
252210dcc6Sdrh ** code in all source files.
262210dcc6Sdrh **
272210dcc6Sdrh ** Large file support can be disabled using the -DSQLITE_DISABLE_LFS switch
282210dcc6Sdrh ** on the compiler command line.  This is necessary if you are compiling
292210dcc6Sdrh ** on a recent machine (ex: Red Hat 7.2) but you want your code to work
302210dcc6Sdrh ** on an older machine (ex: Red Hat 6.0).  If you compile on Red Hat 7.2
312210dcc6Sdrh ** without this option, LFS is enable.  But LFS does not exist in the kernel
322210dcc6Sdrh ** in Red Hat 6.0, so the code won't work.  Hence, for maximum binary
332210dcc6Sdrh ** portability you should omit LFS.
342210dcc6Sdrh **
35dddf6978Sdrh ** The previous paragraph was written in 2005.  (This paragraph is written
36dddf6978Sdrh ** on 2008-11-28.) These days, all Linux kernels support large files, so
37dddf6978Sdrh ** you should probably leave LFS enabled.  But some embedded platforms might
38dddf6978Sdrh ** lack LFS in which case the SQLITE_DISABLE_LFS macro might still be useful.
39dddf6978Sdrh **
402210dcc6Sdrh ** Similar is true for Mac OS X.  LFS is only supported on Mac OS X 9 and later.
412210dcc6Sdrh */
422210dcc6Sdrh #ifndef SQLITE_DISABLE_LFS
432210dcc6Sdrh # define _LARGE_FILE       1
442210dcc6Sdrh # ifndef _FILE_OFFSET_BITS
452210dcc6Sdrh #   define _FILE_OFFSET_BITS 64
462210dcc6Sdrh # endif
472210dcc6Sdrh # define _LARGEFILE_SOURCE 1
482210dcc6Sdrh #endif
492210dcc6Sdrh 
502210dcc6Sdrh /*
51a7b3b635Smistachkin ** For MinGW, check to see if we can include the header file containing its
52a7b3b635Smistachkin ** version information, among other things.  Normally, this internal MinGW
53a7b3b635Smistachkin ** header file would [only] be included automatically by other MinGW header
54a7b3b635Smistachkin ** files; however, the contained version information is now required by this
55a7b3b635Smistachkin ** header file to work around binary compatibility issues (see below) and
56a7b3b635Smistachkin ** this is the only known way to reliably obtain it.  This entire #if block
57a7b3b635Smistachkin ** would be completely unnecessary if there was any other way of detecting
58a7b3b635Smistachkin ** MinGW via their preprocessor (e.g. if they customized their GCC to define
59a7b3b635Smistachkin ** some MinGW-specific macros).  When compiling for MinGW, either the
60a7b3b635Smistachkin ** _HAVE_MINGW_H or _HAVE__MINGW_H (note the extra underscore) macro must be
61a7b3b635Smistachkin ** defined; otherwise, detection of conditions specific to MinGW will be
62a7b3b635Smistachkin ** disabled.
63a7b3b635Smistachkin */
64a7b3b635Smistachkin #if defined(_HAVE_MINGW_H)
65a7b3b635Smistachkin # include "mingw.h"
66a7b3b635Smistachkin #elif defined(_HAVE__MINGW_H)
67a7b3b635Smistachkin # include "_mingw.h"
68a7b3b635Smistachkin #endif
69a7b3b635Smistachkin 
70a7b3b635Smistachkin /*
71a7b3b635Smistachkin ** For MinGW version 4.x (and higher), check to see if the _USE_32BIT_TIME_T
72a7b3b635Smistachkin ** define is required to maintain binary compatibility with the MSVC runtime
73a7b3b635Smistachkin ** library in use (e.g. for Windows XP).
74a7b3b635Smistachkin */
75a7b3b635Smistachkin #if !defined(_USE_32BIT_TIME_T) && !defined(_USE_64BIT_TIME_T) && \
76a7b3b635Smistachkin     defined(_WIN32) && !defined(_WIN64) && \
7765acf373Smistachkin     defined(__MINGW_MAJOR_VERSION) && __MINGW_MAJOR_VERSION >= 4 && \
78a7b3b635Smistachkin     defined(__MSVCRT__)
79a7b3b635Smistachkin # define _USE_32BIT_TIME_T
80a7b3b635Smistachkin #endif
81a7b3b635Smistachkin 
825e990beaSdrh /* The public SQLite interface.  The _FILE_OFFSET_BITS macro must appear
830d71d121Smistachkin ** first in QNX.  Also, the _USE_32BIT_TIME_T macro must appear first for
840d71d121Smistachkin ** MinGW.
855e990beaSdrh */
865e990beaSdrh #include "sqlite3.h"
875e990beaSdrh 
88bd0ae111Smlcreech /*
891e12d43bSmlcreech ** Include the configuration header output by 'configure' if we're using the
901e12d43bSmlcreech ** autoconf-based build
91bd0ae111Smlcreech */
921e12d43bSmlcreech #ifdef _HAVE_SQLITE_CONFIG_H
9398dc4b1aSmlcreech #include "config.h"
941e12d43bSmlcreech #endif
951e12d43bSmlcreech 
96bb4957f8Sdrh #include "sqliteLimit.h"
9798dc4b1aSmlcreech 
98e2965827Sdrh /* Disable nuisance warnings on Borland compilers */
99e2965827Sdrh #if defined(__BORLANDC__)
100e2965827Sdrh #pragma warn -rch /* unreachable code */
101e2965827Sdrh #pragma warn -ccc /* Condition is always true or false */
102e2965827Sdrh #pragma warn -aus /* Assigned value is never used */
103e2965827Sdrh #pragma warn -csu /* Comparing signed and unsigned */
104467bcf36Sshane #pragma warn -spa /* Suspicious pointer arithmetic */
105e2965827Sdrh #endif
106e2965827Sdrh 
10798dc4b1aSmlcreech /* Needed for various definitions... */
10860323418Sdrh #ifndef _GNU_SOURCE
10998dc4b1aSmlcreech # define _GNU_SOURCE
11060323418Sdrh #endif
11198dc4b1aSmlcreech 
112881bd792Sdan #if defined(__OpenBSD__) && !defined(_BSD_SOURCE)
113881bd792Sdan # define _BSD_SOURCE
114881bd792Sdan #endif
115881bd792Sdan 
11698dc4b1aSmlcreech /*
11706af763eSdrh ** Include standard header files as necessary
11806af763eSdrh */
11906af763eSdrh #ifdef HAVE_STDINT_H
12006af763eSdrh #include <stdint.h>
12106af763eSdrh #endif
12206af763eSdrh #ifdef HAVE_INTTYPES_H
12306af763eSdrh #include <inttypes.h>
12406af763eSdrh #endif
12506af763eSdrh 
126a2460e07Sdrh /*
127c05a9a8aSdrh ** The following macros are used to cast pointers to integers and
128c05a9a8aSdrh ** integers to pointers.  The way you do this varies from one compiler
129c05a9a8aSdrh ** to the next, so we have developed the following set of #if statements
130c05a9a8aSdrh ** to generate appropriate macros for a wide range of compilers.
131875e9e7dSdrh **
132c05a9a8aSdrh ** The correct "ANSI" way to do this is to use the intptr_t type.
133c05a9a8aSdrh ** Unfortunately, that typedef is not available on all compilers, or
134c05a9a8aSdrh ** if it is available, it requires an #include of specific headers
135c92271c5Sdrh ** that vary from one machine to the next.
136875e9e7dSdrh **
137875e9e7dSdrh ** Ticket #3860:  The llvm-gcc-4.2 compiler from Apple chokes on
138875e9e7dSdrh ** the ((void*)&((char*)0)[X]) construct.  But MSVC chokes on ((void*)(X)).
1395e49edcaSdrh ** So we have to define the macros in different ways depending on the
140875e9e7dSdrh ** compiler.
1411fc4129dSshane */
142c05a9a8aSdrh #if defined(__PTRDIFF_TYPE__)  /* This case should work for GCC */
143c05a9a8aSdrh # define SQLITE_INT_TO_PTR(X)  ((void*)(__PTRDIFF_TYPE__)(X))
144c05a9a8aSdrh # define SQLITE_PTR_TO_INT(X)  ((int)(__PTRDIFF_TYPE__)(X))
145c05a9a8aSdrh #elif !defined(__GNUC__)       /* Works for compilers other than LLVM */
146c05a9a8aSdrh # define SQLITE_INT_TO_PTR(X)  ((void*)&((char*)0)[X])
147c05a9a8aSdrh # define SQLITE_PTR_TO_INT(X)  ((int)(((char*)X)-(char*)0))
148c05a9a8aSdrh #elif defined(HAVE_STDINT_H)   /* Use this case if we have ANSI headers */
149367882c2Sdrh # define SQLITE_INT_TO_PTR(X)  ((void*)(intptr_t)(X))
150367882c2Sdrh # define SQLITE_PTR_TO_INT(X)  ((int)(intptr_t)(X))
151c05a9a8aSdrh #else                          /* Generates a warning - but it always works */
152875e9e7dSdrh # define SQLITE_INT_TO_PTR(X)  ((void*)(X))
153875e9e7dSdrh # define SQLITE_PTR_TO_INT(X)  ((int)(X))
154367882c2Sdrh #endif
15571674ce9Sdrh 
156e5e7a901Sdrh /*
15738c67c36Sdrh ** The SQLITE_THREADSAFE macro must be defined as 0, 1, or 2.
15838c67c36Sdrh ** 0 means mutexes are permanently disable and the library is never
15938c67c36Sdrh ** threadsafe.  1 means the library is serialized which is the highest
160f7b5496eSdrh ** level of threadsafety.  2 means the library is multithreaded - multiple
16138c67c36Sdrh ** threads can use SQLite as long as no two threads try to use the same
16238c67c36Sdrh ** database connection at the same time.
16338c67c36Sdrh **
164e5e7a901Sdrh ** Older versions of SQLite used an optional THREADSAFE macro.
16538c67c36Sdrh ** We support that for legacy.
166e5e7a901Sdrh */
167e5e7a901Sdrh #if !defined(SQLITE_THREADSAFE)
168e5e7a901Sdrh # if defined(THREADSAFE)
169e5e7a901Sdrh #   define SQLITE_THREADSAFE THREADSAFE
170e5e7a901Sdrh # else
17138c67c36Sdrh #   define SQLITE_THREADSAFE 1 /* IMP: R-07272-22309 */
172e5e7a901Sdrh # endif
173e5e7a901Sdrh #endif
174e5e7a901Sdrh 
17567080617Sdrh /*
176cb15f35fSdrh ** Powersafe overwrite is on by default.  But can be turned off using
177cb15f35fSdrh ** the -DSQLITE_POWERSAFE_OVERWRITE=0 command-line option.
178cb15f35fSdrh */
179cb15f35fSdrh #ifndef SQLITE_POWERSAFE_OVERWRITE
180cb15f35fSdrh # define SQLITE_POWERSAFE_OVERWRITE 1
181cb15f35fSdrh #endif
182cb15f35fSdrh 
183cb15f35fSdrh /*
1840a732f59Sdanielk1977 ** The SQLITE_DEFAULT_MEMSTATUS macro must be defined as either 0 or 1.
1850a732f59Sdanielk1977 ** It determines whether or not the features related to
186467bcf36Sshane ** SQLITE_CONFIG_MEMSTATUS are available by default or not. This value can
1870a732f59Sdanielk1977 ** be overridden at runtime using the sqlite3_config() API.
1880a732f59Sdanielk1977 */
1890a732f59Sdanielk1977 #if !defined(SQLITE_DEFAULT_MEMSTATUS)
1900a732f59Sdanielk1977 # define SQLITE_DEFAULT_MEMSTATUS 1
1910a732f59Sdanielk1977 #endif
1920a732f59Sdanielk1977 
1930a732f59Sdanielk1977 /*
1940d18020bSdrh ** Exactly one of the following macros must be defined in order to
1950d18020bSdrh ** specify which memory allocation subsystem to use.
1960d18020bSdrh **
1970d18020bSdrh **     SQLITE_SYSTEM_MALLOC          // Use normal system malloc()
1981b186a99Smistachkin **     SQLITE_WIN32_MALLOC           // Use Win32 native heap API
199d1b0afc3Sdrh **     SQLITE_ZERO_MALLOC            // Use a stub allocator that always fails
2000d18020bSdrh **     SQLITE_MEMDEBUG               // Debugging version of system malloc()
201a2460e07Sdrh **
202753c5444Smistachkin ** On Windows, if the SQLITE_WIN32_MALLOC_VALIDATE macro is defined and the
203753c5444Smistachkin ** assert() macro is enabled, each call into the Win32 native heap subsystem
204753c5444Smistachkin ** will cause HeapValidate to be called.  If heap validation should fail, an
205753c5444Smistachkin ** assertion will be triggered.
206753c5444Smistachkin **
2070d18020bSdrh ** If none of the above are defined, then set SQLITE_SYSTEM_MALLOC as
2080d18020bSdrh ** the default.
2090d18020bSdrh */
210d1b0afc3Sdrh #if defined(SQLITE_SYSTEM_MALLOC) \
211d1b0afc3Sdrh   + defined(SQLITE_WIN32_MALLOC) \
212d1b0afc3Sdrh   + defined(SQLITE_ZERO_MALLOC) \
213d1b0afc3Sdrh   + defined(SQLITE_MEMDEBUG)>1
214d1b0afc3Sdrh # error "Two or more of the following compile-time configuration options\
21520b1ff07Smistachkin  are defined but at most one is allowed:\
216d1b0afc3Sdrh  SQLITE_SYSTEM_MALLOC, SQLITE_WIN32_MALLOC, SQLITE_MEMDEBUG,\
217d1b0afc3Sdrh  SQLITE_ZERO_MALLOC"
2180d18020bSdrh #endif
219d1b0afc3Sdrh #if defined(SQLITE_SYSTEM_MALLOC) \
220d1b0afc3Sdrh   + defined(SQLITE_WIN32_MALLOC) \
221d1b0afc3Sdrh   + defined(SQLITE_ZERO_MALLOC) \
222d1b0afc3Sdrh   + defined(SQLITE_MEMDEBUG)==0
2230d18020bSdrh # define SQLITE_SYSTEM_MALLOC 1
2240d18020bSdrh #endif
2250d18020bSdrh 
2260d18020bSdrh /*
2278a1e594cSdrh ** If SQLITE_MALLOC_SOFT_LIMIT is not zero, then try to keep the
228eee4c8caSdrh ** sizes of memory allocations below this value where possible.
229eee4c8caSdrh */
2308a1e594cSdrh #if !defined(SQLITE_MALLOC_SOFT_LIMIT)
231eee4c8caSdrh # define SQLITE_MALLOC_SOFT_LIMIT 1024
232eee4c8caSdrh #endif
233eee4c8caSdrh 
234eee4c8caSdrh /*
23567080617Sdrh ** We need to define _XOPEN_SOURCE as follows in order to enable
23640b521f8Sdrh ** recursive mutexes on most Unix systems and fchmod() on OpenBSD.
23740b521f8Sdrh ** But _XOPEN_SOURCE define causes problems for Mac OS X, so omit
23840b521f8Sdrh ** it.
23967080617Sdrh */
24040b521f8Sdrh #if !defined(_XOPEN_SOURCE) && !defined(__DARWIN__) && !defined(__APPLE__)
24140b521f8Sdrh #  define _XOPEN_SOURCE 600
24267080617Sdrh #endif
243e3026636Sdanielk1977 
2447d10d5a6Sdrh /*
2451b28b893Sdrh ** NDEBUG and SQLITE_DEBUG are opposites.  It should always be true that
2461b28b893Sdrh ** defined(NDEBUG)==!defined(SQLITE_DEBUG).  If this is not currently true,
2471b28b893Sdrh ** make it true by defining or undefining NDEBUG.
2481b28b893Sdrh **
249443dbcf5Sdrh ** Setting NDEBUG makes the code smaller and faster by disabling the
250443dbcf5Sdrh ** assert() statements in the code.  So we want the default action
2511b28b893Sdrh ** to be for NDEBUG to be set and NDEBUG to be undefined only if SQLITE_DEBUG
2521b28b893Sdrh ** is set.  Thus NDEBUG becomes an opt-in rather than an opt-out
2534b529d97Sdrh ** feature.
2544b529d97Sdrh */
255289ab076Sdrh #if !defined(NDEBUG) && !defined(SQLITE_DEBUG)
2564b529d97Sdrh # define NDEBUG 1
2574b529d97Sdrh #endif
2581b28b893Sdrh #if defined(NDEBUG) && defined(SQLITE_DEBUG)
2591b28b893Sdrh # undef NDEBUG
2601b28b893Sdrh #endif
2614b529d97Sdrh 
2626402250eSdrh /*
263c7379ce4Sdrh ** Enable SQLITE_ENABLE_EXPLAIN_COMMENTS if SQLITE_DEBUG is turned on.
264c7379ce4Sdrh */
265c7379ce4Sdrh #if !defined(SQLITE_ENABLE_EXPLAIN_COMMENTS) && defined(SQLITE_DEBUG)
266c7379ce4Sdrh # define SQLITE_ENABLE_EXPLAIN_COMMENTS 1
267c7379ce4Sdrh #endif
268c7379ce4Sdrh 
269c7379ce4Sdrh /*
27047c3b3e0Sdrh ** The testcase() macro is used to aid in coverage testing.  When
27147c3b3e0Sdrh ** doing coverage testing, the condition inside the argument to
27247c3b3e0Sdrh ** testcase() must be evaluated both true and false in order to
27347c3b3e0Sdrh ** get full branch coverage.  The testcase() macro is inserted
27447c3b3e0Sdrh ** to help ensure adequate test coverage in places where simple
27547c3b3e0Sdrh ** condition/decision coverage is inadequate.  For example, testcase()
27647c3b3e0Sdrh ** can be used to make sure boundary values are tested.  For
27747c3b3e0Sdrh ** bitmask tests, testcase() can be used to make sure each bit
27847c3b3e0Sdrh ** is significant and used at least once.  On switch statements
27947c3b3e0Sdrh ** where multiple cases go to the same block of code, testcase()
28047c3b3e0Sdrh ** can insure that all cases are evaluated.
28147c3b3e0Sdrh **
28247c3b3e0Sdrh */
28347c3b3e0Sdrh #ifdef SQLITE_COVERAGE_TEST
28447c3b3e0Sdrh   void sqlite3Coverage(int);
28547c3b3e0Sdrh # define testcase(X)  if( X ){ sqlite3Coverage(__LINE__); }
28647c3b3e0Sdrh #else
28747c3b3e0Sdrh # define testcase(X)
2888f941bc7Sdrh #endif
2898f941bc7Sdrh 
2908f941bc7Sdrh /*
2918f941bc7Sdrh ** The TESTONLY macro is used to enclose variable declarations or
2928f941bc7Sdrh ** other bits of code that are needed to support the arguments
2938f941bc7Sdrh ** within testcase() and assert() macros.
2948f941bc7Sdrh */
2958f941bc7Sdrh #if !defined(NDEBUG) || defined(SQLITE_COVERAGE_TEST)
2968f941bc7Sdrh # define TESTONLY(X)  X
2978f941bc7Sdrh #else
29847c3b3e0Sdrh # define TESTONLY(X)
29947c3b3e0Sdrh #endif
30047c3b3e0Sdrh 
30147c3b3e0Sdrh /*
3026149526cSdrh ** Sometimes we need a small amount of code such as a variable initialization
3036149526cSdrh ** to setup for a later assert() statement.  We do not want this code to
3046149526cSdrh ** appear when assert() is disabled.  The following macro is therefore
3056149526cSdrh ** used to contain that setup code.  The "VVA" acronym stands for
3066149526cSdrh ** "Verification, Validation, and Accreditation".  In other words, the
3076149526cSdrh ** code within VVA_ONLY() will only run during verification processes.
3086149526cSdrh */
3096149526cSdrh #ifndef NDEBUG
3106149526cSdrh # define VVA_ONLY(X)  X
3116149526cSdrh #else
3126149526cSdrh # define VVA_ONLY(X)
3136149526cSdrh #endif
3146149526cSdrh 
3156149526cSdrh /*
31647c3b3e0Sdrh ** The ALWAYS and NEVER macros surround boolean expressions which
31747c3b3e0Sdrh ** are intended to always be true or false, respectively.  Such
31847c3b3e0Sdrh ** expressions could be omitted from the code completely.  But they
31947c3b3e0Sdrh ** are included in a few cases in order to enhance the resilience
32047c3b3e0Sdrh ** of SQLite to unexpected behavior - to make the code "self-healing"
32147c3b3e0Sdrh ** or "ductile" rather than being "brittle" and crashing at the first
32247c3b3e0Sdrh ** hint of unplanned behavior.
32347c3b3e0Sdrh **
32447c3b3e0Sdrh ** In other words, ALWAYS and NEVER are added for defensive code.
32547c3b3e0Sdrh **
32647c3b3e0Sdrh ** When doing coverage testing ALWAYS and NEVER are hard-coded to
327443dbcf5Sdrh ** be true and false so that the unreachable code they specify will
32847c3b3e0Sdrh ** not be counted as untested code.
32947c3b3e0Sdrh */
33047c3b3e0Sdrh #if defined(SQLITE_COVERAGE_TEST)
33147c3b3e0Sdrh # define ALWAYS(X)      (1)
33247c3b3e0Sdrh # define NEVER(X)       (0)
33347c3b3e0Sdrh #elif !defined(NDEBUG)
3342de80f4cSdrh # define ALWAYS(X)      ((X)?1:(assert(0),0))
3352de80f4cSdrh # define NEVER(X)       ((X)?(assert(0),1):0)
33647c3b3e0Sdrh #else
33747c3b3e0Sdrh # define ALWAYS(X)      (X)
33847c3b3e0Sdrh # define NEVER(X)       (X)
33947c3b3e0Sdrh #endif
34047c3b3e0Sdrh 
34147c3b3e0Sdrh /*
3423e8e7ecbSdrh ** Return true (non-zero) if the input is a integer that is too large
3433e8e7ecbSdrh ** to fit in 32-bits.  This macro is used inside of various testcase()
3443e8e7ecbSdrh ** macros to verify that we have tested SQLite for large-file support.
3453e8e7ecbSdrh */
346b31a6afaSdan #define IS_BIG_INT(X)  (((X)&~(i64)0xffffffff)!=0)
3473e8e7ecbSdrh 
3483e8e7ecbSdrh /*
34947c3b3e0Sdrh ** The macro unlikely() is a hint that surrounds a boolean
35047c3b3e0Sdrh ** expression that is usually false.  Macro likely() surrounds
351443dbcf5Sdrh ** a boolean expression that is usually true.  These hints could,
352443dbcf5Sdrh ** in theory, be used by the compiler to generate better code, but
353443dbcf5Sdrh ** currently they are just comments for human readers.
35447c3b3e0Sdrh */
355443dbcf5Sdrh #define likely(X)    (X)
356443dbcf5Sdrh #define unlikely(X)  (X)
35747c3b3e0Sdrh 
358beae3194Sdrh #include "hash.h"
35975897234Sdrh #include "parse.h"
36075897234Sdrh #include <stdio.h>
36175897234Sdrh #include <stdlib.h>
36275897234Sdrh #include <string.h>
36375897234Sdrh #include <assert.h>
36452370e2cSdrh #include <stddef.h>
36575897234Sdrh 
366967e8b73Sdrh /*
367b37df7b9Sdrh ** If compiling for a processor that lacks floating point support,
368b37df7b9Sdrh ** substitute integer for floating-point
369b37df7b9Sdrh */
370b37df7b9Sdrh #ifdef SQLITE_OMIT_FLOATING_POINT
371b37df7b9Sdrh # define double sqlite_int64
3728b307fbfSdrh # define float sqlite_int64
373b37df7b9Sdrh # define LONGDOUBLE_TYPE sqlite_int64
374d1167393Sdrh # ifndef SQLITE_BIG_DBL
375cdaca55eSdrh #   define SQLITE_BIG_DBL (((sqlite3_int64)1)<<50)
376d1167393Sdrh # endif
377b37df7b9Sdrh # define SQLITE_OMIT_DATETIME_FUNCS 1
378b37df7b9Sdrh # define SQLITE_OMIT_TRACE 1
379110daac9Sdrh # undef SQLITE_MIXED_ENDIAN_64BIT_FLOAT
3800b3bf924Sdrh # undef SQLITE_HAVE_ISNAN
381b37df7b9Sdrh #endif
382d1167393Sdrh #ifndef SQLITE_BIG_DBL
383d1167393Sdrh # define SQLITE_BIG_DBL (1e99)
384d1167393Sdrh #endif
385b37df7b9Sdrh 
386b37df7b9Sdrh /*
38753c0f748Sdanielk1977 ** OMIT_TEMPDB is set to 1 if SQLITE_OMIT_TEMPDB is defined, or 0
38853c0f748Sdanielk1977 ** afterward. Having this macro allows us to cause the C compiler
38953c0f748Sdanielk1977 ** to omit code used by TEMP tables without messy #ifndef statements.
39053c0f748Sdanielk1977 */
39153c0f748Sdanielk1977 #ifdef SQLITE_OMIT_TEMPDB
39253c0f748Sdanielk1977 #define OMIT_TEMPDB 1
39353c0f748Sdanielk1977 #else
39453c0f748Sdanielk1977 #define OMIT_TEMPDB 0
39553c0f748Sdanielk1977 #endif
39653c0f748Sdanielk1977 
39753c0f748Sdanielk1977 /*
398d946db00Sdrh ** The "file format" number is an integer that is incremented whenever
399d946db00Sdrh ** the VDBE-level file format changes.  The following macros define the
400d946db00Sdrh ** the default file format for new databases and the maximum file format
401d946db00Sdrh ** that the library can read.
402d946db00Sdrh */
403d946db00Sdrh #define SQLITE_MAX_FILE_FORMAT 4
404d946db00Sdrh #ifndef SQLITE_DEFAULT_FILE_FORMAT
405bf3f5f8dSdrh # define SQLITE_DEFAULT_FILE_FORMAT 4
406d946db00Sdrh #endif
407d946db00Sdrh 
408a2460e07Sdrh /*
409a2460e07Sdrh ** Determine whether triggers are recursive by default.  This can be
410a2460e07Sdrh ** changed at run-time using a pragma.
411a2460e07Sdrh */
4125bde73c4Sdan #ifndef SQLITE_DEFAULT_RECURSIVE_TRIGGERS
4135bde73c4Sdan # define SQLITE_DEFAULT_RECURSIVE_TRIGGERS 0
4145bde73c4Sdan #endif
4155bde73c4Sdan 
416d946db00Sdrh /*
417b06a0b67Sdanielk1977 ** Provide a default value for SQLITE_TEMP_STORE in case it is not specified
41849766d6cSdrh ** on the command-line
41949766d6cSdrh */
420b06a0b67Sdanielk1977 #ifndef SQLITE_TEMP_STORE
421b06a0b67Sdanielk1977 # define SQLITE_TEMP_STORE 1
422d16d0bc5Sdrh # define SQLITE_TEMP_STORE_xc 1  /* Exclude from ctime.c */
42349766d6cSdrh #endif
42449766d6cSdrh 
42549766d6cSdrh /*
426f1974846Sdrh ** GCC does not define the offsetof() macro so we'll have to do it
427f1974846Sdrh ** ourselves.
428f1974846Sdrh */
429f1974846Sdrh #ifndef offsetof
430f1974846Sdrh #define offsetof(STRUCTURE,FIELD) ((int)((char*)&((STRUCTURE*)0)->FIELD))
431f1974846Sdrh #endif
432f1974846Sdrh 
433f1974846Sdrh /*
434e1e2e9acSdrh ** Macros to compute minimum and maximum of two numbers.
435e1e2e9acSdrh */
436e1e2e9acSdrh #define MIN(A,B) ((A)<(B)?(A):(B))
437e1e2e9acSdrh #define MAX(A,B) ((A)>(B)?(A):(B))
438e1e2e9acSdrh 
439e1e2e9acSdrh /*
4409b8f447bSdrh ** Check to see if this machine uses EBCDIC.  (Yes, believe it or
4419b8f447bSdrh ** not, there are still machines out there that use EBCDIC.)
4429b8f447bSdrh */
4439b8f447bSdrh #if 'A' == '\301'
4449b8f447bSdrh # define SQLITE_EBCDIC 1
4459b8f447bSdrh #else
4469b8f447bSdrh # define SQLITE_ASCII 1
4479b8f447bSdrh #endif
4489b8f447bSdrh 
4499b8f447bSdrh /*
4505a2c2c20Sdrh ** Integers of known sizes.  These typedefs might change for architectures
4515a2c2c20Sdrh ** where the sizes very.  Preprocessor macros are available so that the
4525a2c2c20Sdrh ** types can be conveniently redefined at compile-type.  Like this:
4535a2c2c20Sdrh **
4545a2c2c20Sdrh **         cc '-DUINTPTR_TYPE=long long int' ...
45541a2b48bSdrh */
4565a2c2c20Sdrh #ifndef UINT32_TYPE
457dda5b68cSmlcreech # ifdef HAVE_UINT32_T
458dda5b68cSmlcreech #  define UINT32_TYPE uint32_t
459dda5b68cSmlcreech # else
4605a2c2c20Sdrh #  define UINT32_TYPE unsigned int
4615a2c2c20Sdrh # endif
462dda5b68cSmlcreech #endif
4635a2c2c20Sdrh #ifndef UINT16_TYPE
464dda5b68cSmlcreech # ifdef HAVE_UINT16_T
465dda5b68cSmlcreech #  define UINT16_TYPE uint16_t
466dda5b68cSmlcreech # else
4675a2c2c20Sdrh #  define UINT16_TYPE unsigned short int
4685a2c2c20Sdrh # endif
469dda5b68cSmlcreech #endif
470939a16d6Sdrh #ifndef INT16_TYPE
471dda5b68cSmlcreech # ifdef HAVE_INT16_T
472dda5b68cSmlcreech #  define INT16_TYPE int16_t
473dda5b68cSmlcreech # else
474939a16d6Sdrh #  define INT16_TYPE short int
475939a16d6Sdrh # endif
476dda5b68cSmlcreech #endif
4775a2c2c20Sdrh #ifndef UINT8_TYPE
478dda5b68cSmlcreech # ifdef HAVE_UINT8_T
479dda5b68cSmlcreech #  define UINT8_TYPE uint8_t
480dda5b68cSmlcreech # else
4815a2c2c20Sdrh #  define UINT8_TYPE unsigned char
4825a2c2c20Sdrh # endif
483dda5b68cSmlcreech #endif
484905793e2Sdrh #ifndef INT8_TYPE
485dda5b68cSmlcreech # ifdef HAVE_INT8_T
486dda5b68cSmlcreech #  define INT8_TYPE int8_t
487dda5b68cSmlcreech # else
488905793e2Sdrh #  define INT8_TYPE signed char
489905793e2Sdrh # endif
490dda5b68cSmlcreech #endif
491efad9995Sdrh #ifndef LONGDOUBLE_TYPE
492efad9995Sdrh # define LONGDOUBLE_TYPE long double
493efad9995Sdrh #endif
494efad9995Sdrh typedef sqlite_int64 i64;          /* 8-byte signed integer */
49527436af7Sdrh typedef sqlite_uint64 u64;         /* 8-byte unsigned integer */
4965a2c2c20Sdrh typedef UINT32_TYPE u32;           /* 4-byte unsigned integer */
4975a2c2c20Sdrh typedef UINT16_TYPE u16;           /* 2-byte unsigned integer */
498939a16d6Sdrh typedef INT16_TYPE i16;            /* 2-byte signed integer */
4995a2c2c20Sdrh typedef UINT8_TYPE u8;             /* 1-byte unsigned integer */
50070a8ca3cSdrh typedef INT8_TYPE i8;              /* 1-byte signed integer */
5015a2c2c20Sdrh 
5025a2c2c20Sdrh /*
50335cd643cSdrh ** SQLITE_MAX_U32 is a u64 constant that is the maximum u64 value
50435cd643cSdrh ** that can be stored in a u32 without loss of data.  The value
50535cd643cSdrh ** is 0x00000000ffffffff.  But because of quirks of some compilers, we
50635cd643cSdrh ** have to specify the value in the less intuitive manner shown:
50735cd643cSdrh */
50835cd643cSdrh #define SQLITE_MAX_U32  ((((u64)1)<<32)-1)
50935cd643cSdrh 
51035cd643cSdrh /*
511faacf17cSdrh ** The datatype used to store estimates of the number of rows in a
512faacf17cSdrh ** table or index.  This is an unsigned integer type.  For 99.9% of
513faacf17cSdrh ** the world, a 32-bit integer is sufficient.  But a 64-bit integer
514faacf17cSdrh ** can be used at compile-time if desired.
515faacf17cSdrh */
516faacf17cSdrh #ifdef SQLITE_64BIT_STATS
517faacf17cSdrh  typedef u64 tRowcnt;    /* 64-bit only if requested at compile-time */
518faacf17cSdrh #else
519faacf17cSdrh  typedef u32 tRowcnt;    /* 32-bit is the default */
520faacf17cSdrh #endif
521faacf17cSdrh 
522faacf17cSdrh /*
523bf539c4dSdrh ** Estimated quantities used for query planning are stored as 16-bit
524bf539c4dSdrh ** logarithms.  For quantity X, the value stored is 10*log2(X).  This
525bf539c4dSdrh ** gives a possible range of values of approximately 1.0e986 to 1e-986.
526bf539c4dSdrh ** But the allowed values are "grainy".  Not every value is representable.
527bf539c4dSdrh ** For example, quantities 16 and 17 are both represented by a LogEst
528224155ddSdrh ** of 40.  However, since LogEst quantaties are suppose to be estimates,
529bf539c4dSdrh ** not exact values, this imprecision is not a problem.
530bf539c4dSdrh **
531224155ddSdrh ** "LogEst" is short for "Logarithmic Estimate".
532bf539c4dSdrh **
533bf539c4dSdrh ** Examples:
534bf539c4dSdrh **      1 -> 0              20 -> 43          10000 -> 132
535bf539c4dSdrh **      2 -> 10             25 -> 46          25000 -> 146
536bf539c4dSdrh **      3 -> 16            100 -> 66        1000000 -> 199
537bf539c4dSdrh **      4 -> 20           1000 -> 99        1048576 -> 200
538bf539c4dSdrh **     10 -> 33           1024 -> 100    4294967296 -> 320
539bf539c4dSdrh **
540bf539c4dSdrh ** The LogEst can be negative to indicate fractional values.
541bf539c4dSdrh ** Examples:
542bf539c4dSdrh **
543bf539c4dSdrh **    0.5 -> -10           0.1 -> -33        0.0625 -> -40
544bf539c4dSdrh */
545bf539c4dSdrh typedef INT16_TYPE LogEst;
546bf539c4dSdrh 
547bf539c4dSdrh /*
548bbd42a6dSdrh ** Macros to determine whether the machine is big or little endian,
54971794dbaSdrh ** and whether or not that determination is run-time or compile-time.
55071794dbaSdrh **
55171794dbaSdrh ** For best performance, an attempt is made to guess at the byte-order
55271794dbaSdrh ** using C-preprocessor macros.  If that is unsuccessful, or if
55371794dbaSdrh ** -DSQLITE_RUNTIME_BYTEORDER=1 is set, then byte-order is determined
55471794dbaSdrh ** at run-time.
555bbd42a6dSdrh */
55646c99e0fSdrh #ifdef SQLITE_AMALGAMATION
557b3190c15Sdrh const int sqlite3one = 1;
55846c99e0fSdrh #else
559bbd42a6dSdrh extern const int sqlite3one;
56046c99e0fSdrh #endif
56171794dbaSdrh #if (defined(i386)     || defined(__i386__)   || defined(_M_IX86) ||    \
56271794dbaSdrh      defined(__x86_64) || defined(__x86_64__) || defined(_M_X64)  ||    \
56371794dbaSdrh      defined(_M_AMD64) || defined(_M_ARM)     || defined(__x86)   ||    \
56471794dbaSdrh      defined(__arm__)) && !defined(SQLITE_RUNTIME_BYTEORDER)
5652cf4acbdSdrh # define SQLITE_BYTEORDER    1234
56638def054Sdrh # define SQLITE_BIGENDIAN    0
56738def054Sdrh # define SQLITE_LITTLEENDIAN 1
56838def054Sdrh # define SQLITE_UTF16NATIVE  SQLITE_UTF16LE
56971794dbaSdrh #endif
57071794dbaSdrh #if (defined(sparc)    || defined(__ppc__))  \
57171794dbaSdrh     && !defined(SQLITE_RUNTIME_BYTEORDER)
57271794dbaSdrh # define SQLITE_BYTEORDER    4321
57371794dbaSdrh # define SQLITE_BIGENDIAN    1
57471794dbaSdrh # define SQLITE_LITTLEENDIAN 0
57571794dbaSdrh # define SQLITE_UTF16NATIVE  SQLITE_UTF16BE
57671794dbaSdrh #endif
57771794dbaSdrh #if !defined(SQLITE_BYTEORDER)
5782cf4acbdSdrh # define SQLITE_BYTEORDER    0     /* 0 means "unknown at compile-time" */
5799c054830Sdrh # define SQLITE_BIGENDIAN    (*(char *)(&sqlite3one)==0)
5809c054830Sdrh # define SQLITE_LITTLEENDIAN (*(char *)(&sqlite3one)==1)
58138def054Sdrh # define SQLITE_UTF16NATIVE  (SQLITE_BIGENDIAN?SQLITE_UTF16BE:SQLITE_UTF16LE)
58238def054Sdrh #endif
583bbd42a6dSdrh 
584bbd42a6dSdrh /*
5850f050353Sdrh ** Constants for the largest and smallest possible 64-bit signed integers.
5860f050353Sdrh ** These macros are designed to work correctly on both 32-bit and 64-bit
5870f050353Sdrh ** compilers.
5880f050353Sdrh */
5890f050353Sdrh #define LARGEST_INT64  (0xffffffff|(((i64)0x7fffffff)<<32))
5900f050353Sdrh #define SMALLEST_INT64 (((i64)-1) - LARGEST_INT64)
5910f050353Sdrh 
5920f050353Sdrh /*
593be229650Sdanielk1977 ** Round up a number to the next larger multiple of 8.  This is used
594be229650Sdanielk1977 ** to force 8-byte alignment on 64-bit architectures.
595be229650Sdanielk1977 */
596bc73971dSdanielk1977 #define ROUND8(x)     (((x)+7)&~7)
597bc73971dSdanielk1977 
598bc73971dSdanielk1977 /*
599bc73971dSdanielk1977 ** Round down to the nearest multiple of 8
600bc73971dSdanielk1977 */
601bc73971dSdanielk1977 #define ROUNDDOWN8(x) ((x)&~7)
602be229650Sdanielk1977 
603be229650Sdanielk1977 /*
6048e14c596Sdrh ** Assert that the pointer X is aligned to an 8-byte boundary.  This
6058e14c596Sdrh ** macro is used only within assert() to verify that the code gets
6068e14c596Sdrh ** all alignment restrictions correct.
6078e14c596Sdrh **
6088e14c596Sdrh ** Except, if SQLITE_4_BYTE_ALIGNED_MALLOC is defined, then the
6098e14c596Sdrh ** underlying malloc() implemention might return us 4-byte aligned
6108e14c596Sdrh ** pointers.  In that case, only verify 4-byte alignment.
611ea598cbdSdrh */
6128e14c596Sdrh #ifdef SQLITE_4_BYTE_ALIGNED_MALLOC
6138e14c596Sdrh # define EIGHT_BYTE_ALIGNMENT(X)   ((((char*)(X) - (char*)0)&3)==0)
6148e14c596Sdrh #else
615ea598cbdSdrh # define EIGHT_BYTE_ALIGNMENT(X)   ((((char*)(X) - (char*)0)&7)==0)
6168e14c596Sdrh #endif
617ea598cbdSdrh 
618188d4884Sdrh /*
6199b4c59faSdrh ** Disable MMAP on platforms where it is known to not work
620188d4884Sdrh */
621188d4884Sdrh #if defined(__OpenBSD__) || defined(__QNXNTO__)
6229b4c59faSdrh # undef SQLITE_MAX_MMAP_SIZE
6239b4c59faSdrh # define SQLITE_MAX_MMAP_SIZE 0
624188d4884Sdrh #endif
625188d4884Sdrh 
6269b4c59faSdrh /*
6279b4c59faSdrh ** Default maximum size of memory used by memory-mapped I/O in the VFS
6289b4c59faSdrh */
6299b4c59faSdrh #ifdef __APPLE__
6309b4c59faSdrh # include <TargetConditionals.h>
6319b4c59faSdrh # if TARGET_OS_IPHONE
6329b4c59faSdrh #   undef SQLITE_MAX_MMAP_SIZE
6339b4c59faSdrh #   define SQLITE_MAX_MMAP_SIZE 0
6349b4c59faSdrh # endif
6359b4c59faSdrh #endif
6369b4c59faSdrh #ifndef SQLITE_MAX_MMAP_SIZE
6379b4c59faSdrh # if defined(__linux__) \
6389b4c59faSdrh   || defined(_WIN32) \
6399b4c59faSdrh   || (defined(__APPLE__) && defined(__MACH__)) \
6409b4c59faSdrh   || defined(__sun)
6412bba8c24Sdrh #   define SQLITE_MAX_MMAP_SIZE 0x7fff0000  /* 2147418112 */
6429b4c59faSdrh # else
6439b4c59faSdrh #   define SQLITE_MAX_MMAP_SIZE 0
6449b4c59faSdrh # endif
645d16d0bc5Sdrh # define SQLITE_MAX_MMAP_SIZE_xc 1 /* exclude from ctime.c */
6469b4c59faSdrh #endif
6479b4c59faSdrh 
6489b4c59faSdrh /*
6499b4c59faSdrh ** The default MMAP_SIZE is zero on all platforms.  Or, even if a larger
6509b4c59faSdrh ** default MMAP_SIZE is specified at compile-time, make sure that it does
6519b4c59faSdrh ** not exceed the maximum mmap size.
6529b4c59faSdrh */
6539b4c59faSdrh #ifndef SQLITE_DEFAULT_MMAP_SIZE
6549b4c59faSdrh # define SQLITE_DEFAULT_MMAP_SIZE 0
655d16d0bc5Sdrh # define SQLITE_DEFAULT_MMAP_SIZE_xc 1  /* Exclude from ctime.c */
6569b4c59faSdrh #endif
6579b4c59faSdrh #if SQLITE_DEFAULT_MMAP_SIZE>SQLITE_MAX_MMAP_SIZE
6589b4c59faSdrh # undef SQLITE_DEFAULT_MMAP_SIZE
6599b4c59faSdrh # define SQLITE_DEFAULT_MMAP_SIZE SQLITE_MAX_MMAP_SIZE
6609b4c59faSdrh #endif
661e7b34707Sdrh 
662ea598cbdSdrh /*
6631435a9a1Sdrh ** Only one of SQLITE_ENABLE_STAT3 or SQLITE_ENABLE_STAT4 can be defined.
6641435a9a1Sdrh ** Priority is given to SQLITE_ENABLE_STAT4.  If either are defined, also
6651435a9a1Sdrh ** define SQLITE_ENABLE_STAT3_OR_STAT4
6661435a9a1Sdrh */
6671435a9a1Sdrh #ifdef SQLITE_ENABLE_STAT4
6681435a9a1Sdrh # undef SQLITE_ENABLE_STAT3
6691435a9a1Sdrh # define SQLITE_ENABLE_STAT3_OR_STAT4 1
6701435a9a1Sdrh #elif SQLITE_ENABLE_STAT3
6711435a9a1Sdrh # define SQLITE_ENABLE_STAT3_OR_STAT4 1
6721435a9a1Sdrh #elif SQLITE_ENABLE_STAT3_OR_STAT4
6731435a9a1Sdrh # undef SQLITE_ENABLE_STAT3_OR_STAT4
6741435a9a1Sdrh #endif
6751435a9a1Sdrh 
6761435a9a1Sdrh /*
67790f5ecb3Sdrh ** An instance of the following structure is used to store the busy-handler
67890f5ecb3Sdrh ** callback for a given sqlite handle.
67990f5ecb3Sdrh **
68090f5ecb3Sdrh ** The sqlite.busyHandler member of the sqlite struct contains the busy
68190f5ecb3Sdrh ** callback for the database handle. Each pager opened via the sqlite
68290f5ecb3Sdrh ** handle is passed a pointer to sqlite.busyHandler. The busy-handler
68390f5ecb3Sdrh ** callback is currently invoked only from within pager.c.
68490f5ecb3Sdrh */
68590f5ecb3Sdrh typedef struct BusyHandler BusyHandler;
68690f5ecb3Sdrh struct BusyHandler {
68790f5ecb3Sdrh   int (*xFunc)(void *,int);  /* The busy callback */
68890f5ecb3Sdrh   void *pArg;                /* First arg to busy callback */
689a4afb65cSdrh   int nBusy;                 /* Incremented with each busy call */
69090f5ecb3Sdrh };
69190f5ecb3Sdrh 
69290f5ecb3Sdrh /*
69375897234Sdrh ** Name of the master database table.  The master database table
69475897234Sdrh ** is a special table that holds the names and attributes of all
69575897234Sdrh ** user tables and indices.
69675897234Sdrh */
69775897234Sdrh #define MASTER_NAME       "sqlite_master"
698e0bc4048Sdrh #define TEMP_MASTER_NAME  "sqlite_temp_master"
69975897234Sdrh 
70075897234Sdrh /*
7018e150818Sdanielk1977 ** The root-page of the master database table.
7028e150818Sdanielk1977 */
7038e150818Sdanielk1977 #define MASTER_ROOT       1
7048e150818Sdanielk1977 
7058e150818Sdanielk1977 /*
706ed6c8671Sdrh ** The name of the schema table.
707ed6c8671Sdrh */
70853c0f748Sdanielk1977 #define SCHEMA_TABLE(x)  ((!OMIT_TEMPDB)&&(x==1)?TEMP_MASTER_NAME:MASTER_NAME)
709ed6c8671Sdrh 
710ed6c8671Sdrh /*
71175897234Sdrh ** A convenience macro that returns the number of elements in
71275897234Sdrh ** an array.
71375897234Sdrh */
71423432976Sdanielk1977 #define ArraySize(X)    ((int)(sizeof(X)/sizeof(X[0])))
71575897234Sdrh 
71675897234Sdrh /*
7177a5bcc0fSdrh ** Determine if the argument is a power of two
7187a5bcc0fSdrh */
7197a5bcc0fSdrh #define IsPowerOfTwo(X) (((X)&((X)-1))==0)
7207a5bcc0fSdrh 
7217a5bcc0fSdrh /*
722633e6d57Sdrh ** The following value as a destructor means to use sqlite3DbFree().
723aa538a58Sdrh ** The sqlite3DbFree() routine requires two parameters instead of the
724aa538a58Sdrh ** one parameter that destructors normally want.  So we have to introduce
725aa538a58Sdrh ** this magic value that the code knows to handle differently.  Any
726aa538a58Sdrh ** pointer will work here as long as it is distinct from SQLITE_STATIC
727aa538a58Sdrh ** and SQLITE_TRANSIENT.
728633e6d57Sdrh */
729aa538a58Sdrh #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3MallocSize)
730633e6d57Sdrh 
73178f82d1eSdrh /*
73278f82d1eSdrh ** When SQLITE_OMIT_WSD is defined, it means that the target platform does
73378f82d1eSdrh ** not support Writable Static Data (WSD) such as global and static variables.
73478f82d1eSdrh ** All variables must either be on the stack or dynamically allocated from
73578f82d1eSdrh ** the heap.  When WSD is unsupported, the variable declarations scattered
73678f82d1eSdrh ** throughout the SQLite code must become constants instead.  The SQLITE_WSD
73778f82d1eSdrh ** macro is used for this purpose.  And instead of referencing the variable
73878f82d1eSdrh ** directly, we use its constant as a key to lookup the run-time allocated
73978f82d1eSdrh ** buffer that holds real variable.  The constant is also the initializer
74078f82d1eSdrh ** for the run-time allocated buffer.
74178f82d1eSdrh **
7422479de3aSshane ** In the usual case where WSD is supported, the SQLITE_WSD and GLOBAL
74378f82d1eSdrh ** macros become no-ops and have zero performance impact.
74478f82d1eSdrh */
745075c23afSdanielk1977 #ifdef SQLITE_OMIT_WSD
746075c23afSdanielk1977   #define SQLITE_WSD const
747075c23afSdanielk1977   #define GLOBAL(t,v) (*(t*)sqlite3_wsd_find((void*)&(v), sizeof(v)))
748075c23afSdanielk1977   #define sqlite3GlobalConfig GLOBAL(struct Sqlite3Config, sqlite3Config)
749d1d38488Sdrh   int sqlite3_wsd_init(int N, int J);
750d1d38488Sdrh   void *sqlite3_wsd_find(void *K, int L);
751075c23afSdanielk1977 #else
752075c23afSdanielk1977   #define SQLITE_WSD
753075c23afSdanielk1977   #define GLOBAL(t,v) v
754075c23afSdanielk1977   #define sqlite3GlobalConfig sqlite3Config
755075c23afSdanielk1977 #endif
756075c23afSdanielk1977 
757f3d3c27aSdanielk1977 /*
758f3d3c27aSdanielk1977 ** The following macros are used to suppress compiler warnings and to
759f3d3c27aSdanielk1977 ** make it clear to human readers when a function parameter is deliberately
760f3d3c27aSdanielk1977 ** left unused within the body of a function. This usually happens when
761f3d3c27aSdanielk1977 ** a function is called via a function pointer. For example the
762f3d3c27aSdanielk1977 ** implementation of an SQL aggregate step callback may not use the
763f3d3c27aSdanielk1977 ** parameter indicating the number of arguments passed to the aggregate,
764f3d3c27aSdanielk1977 ** if it knows that this is enforced elsewhere.
765f3d3c27aSdanielk1977 **
766f3d3c27aSdanielk1977 ** When a function parameter is not used at all within the body of a function,
767f3d3c27aSdanielk1977 ** it is generally named "NotUsed" or "NotUsed2" to make things even clearer.
768f3d3c27aSdanielk1977 ** However, these macros may also be used to suppress warnings related to
769f3d3c27aSdanielk1977 ** parameters that may or may not be used depending on compilation options.
770f3d3c27aSdanielk1977 ** For example those parameters only used in assert() statements. In these
771f3d3c27aSdanielk1977 ** cases the parameters are named as per the usual conventions.
772f3d3c27aSdanielk1977 */
77362c14b34Sdanielk1977 #define UNUSED_PARAMETER(x) (void)(x)
774f3d3c27aSdanielk1977 #define UNUSED_PARAMETER2(x,y) UNUSED_PARAMETER(x),UNUSED_PARAMETER(y)
77562c14b34Sdanielk1977 
776633e6d57Sdrh /*
77775897234Sdrh ** Forward references to structures
77875897234Sdrh */
77913449892Sdrh typedef struct AggInfo AggInfo;
780fe05af87Sdrh typedef struct AuthContext AuthContext;
7810b9f50d8Sdrh typedef struct AutoincInfo AutoincInfo;
782f5e7bb51Sdrh typedef struct Bitvec Bitvec;
783fe05af87Sdrh typedef struct CollSeq CollSeq;
7847020f651Sdrh typedef struct Column Column;
785fe05af87Sdrh typedef struct Db Db;
786e501b89aSdanielk1977 typedef struct Schema Schema;
78775897234Sdrh typedef struct Expr Expr;
78875897234Sdrh typedef struct ExprList ExprList;
789b7916a78Sdrh typedef struct ExprSpan ExprSpan;
790c2eef3b3Sdrh typedef struct FKey FKey;
791d2199f0fSdan typedef struct FuncDestructor FuncDestructor;
792fe05af87Sdrh typedef struct FuncDef FuncDef;
79370a8ca3cSdrh typedef struct FuncDefHash FuncDefHash;
794fe05af87Sdrh typedef struct IdList IdList;
795fe05af87Sdrh typedef struct Index Index;
79602fa4696Sdan typedef struct IndexSample IndexSample;
7978d059845Sdanielk1977 typedef struct KeyClass KeyClass;
798d3d39e93Sdrh typedef struct KeyInfo KeyInfo;
799633e6d57Sdrh typedef struct Lookaside Lookaside;
800633e6d57Sdrh typedef struct LookasideSlot LookasideSlot;
801d1ab1ba5Sdanielk1977 typedef struct Module Module;
802626a879aSdrh typedef struct NameContext NameContext;
803fe05af87Sdrh typedef struct Parse Parse;
804a5c1416dSdrh typedef struct PrintfArguments PrintfArguments;
805a2460e07Sdrh typedef struct RowSet RowSet;
806fd7f0452Sdanielk1977 typedef struct Savepoint Savepoint;
807fe05af87Sdrh typedef struct Select Select;
808634d81deSdrh typedef struct SelectDest SelectDest;
809fe05af87Sdrh typedef struct SrcList SrcList;
810ade86483Sdrh typedef struct StrAccum StrAccum;
811fe05af87Sdrh typedef struct Table Table;
812c00da105Sdanielk1977 typedef struct TableLock TableLock;
813fe05af87Sdrh typedef struct Token Token;
814a2460e07Sdrh typedef struct Trigger Trigger;
8152832ad42Sdan typedef struct TriggerPrg TriggerPrg;
816fe05af87Sdrh typedef struct TriggerStep TriggerStep;
817e63d9991Sdrh typedef struct UnpackedRecord UnpackedRecord;
818595a523aSdanielk1977 typedef struct VTable VTable;
819b061d058Sdan typedef struct VtabCtx VtabCtx;
8207d10d5a6Sdrh typedef struct Walker Walker;
821fe05af87Sdrh typedef struct WhereInfo WhereInfo;
8227d562dbeSdan typedef struct With With;
823d3d39e93Sdrh 
8242dca4ac1Sdanielk1977 /*
8252dca4ac1Sdanielk1977 ** Defer sourcing vdbe.h and btree.h until after the "u8" and
8262dca4ac1Sdanielk1977 ** "BusyHandler" typedefs. vdbe.h also requires a few of the opaque
8272dca4ac1Sdanielk1977 ** pointer types (i.e. FuncDef) defined above.
8282dca4ac1Sdanielk1977 */
8292dca4ac1Sdanielk1977 #include "btree.h"
8302dca4ac1Sdanielk1977 #include "vdbe.h"
8312dca4ac1Sdanielk1977 #include "pager.h"
8328c0a791aSdanielk1977 #include "pcache.h"
8332dca4ac1Sdanielk1977 
8341cc5ed81Sdanielk1977 #include "os.h"
835c7ce76afSdrh #include "mutex.h"
8361cc5ed81Sdanielk1977 
837eee4c8caSdrh 
838001bbcbbSdrh /*
839001bbcbbSdrh ** Each database file to be accessed by the system is an instance
840001bbcbbSdrh ** of the following structure.  There are normally two of these structures
841001bbcbbSdrh ** in the sqlite.aDb[] array.  aDb[0] is the main database file and
842a69d9168Sdrh ** aDb[1] is the database file used to hold temporary tables.  Additional
843a69d9168Sdrh ** databases may be attached.
844001bbcbbSdrh */
845001bbcbbSdrh struct Db {
846001bbcbbSdrh   char *zName;         /* Name of this database */
847001bbcbbSdrh   Btree *pBt;          /* The B*Tree structure for this database file */
848467bcf36Sshane   u8 safety_level;     /* How aggressive at syncing data to disk */
849e501b89aSdanielk1977   Schema *pSchema;     /* Pointer to database schema (possibly shared) */
850da184236Sdanielk1977 };
851da184236Sdanielk1977 
852da184236Sdanielk1977 /*
853da184236Sdanielk1977 ** An instance of the following structure stores a database schema.
8542120608eSdrh **
8552120608eSdrh ** Most Schema objects are associated with a Btree.  The exception is
8562120608eSdrh ** the Schema for the TEMP databaes (sqlite3.aDb[1]) which is free-standing.
8572120608eSdrh ** In shared cache mode, a single Schema object can be shared by multiple
8582120608eSdrh ** Btrees that refer to the same underlying BtShared object.
8592120608eSdrh **
8602120608eSdrh ** Schema objects are automatically deallocated when the last Btree that
8612120608eSdrh ** references them is destroyed.   The TEMP Schema is manually freed by
8622120608eSdrh ** sqlite3_close().
8632120608eSdrh *
8642120608eSdrh ** A thread must be holding a mutex on the corresponding Btree in order
8652120608eSdrh ** to access Schema content.  This implies that the thread must also be
8662120608eSdrh ** holding a mutex on the sqlite3 connection pointer that owns the Btree.
86755a0959aSdrh ** For a TEMP Schema, only the connection mutex is required.
868da184236Sdanielk1977 */
869e501b89aSdanielk1977 struct Schema {
870001bbcbbSdrh   int schema_cookie;   /* Database schema version number for this file */
871c2a75551Sdrh   int iGeneration;     /* Generation counter.  Incremented with each change */
872d24cc427Sdrh   Hash tblHash;        /* All tables indexed by name */
873d24cc427Sdrh   Hash idxHash;        /* All (named) indices indexed by name */
874d24cc427Sdrh   Hash trigHash;       /* All triggers indexed by name */
8751da40a38Sdan   Hash fkeyHash;       /* All foreign keys by referenced table name */
8764794f735Sdrh   Table *pSeqTab;      /* The sqlite_sequence table used by AUTOINCREMENT */
877da184236Sdanielk1977   u8 file_format;      /* Schema format version for this file */
8788079a0d3Sdrh   u8 enc;              /* Text encoding used by this database */
879da184236Sdanielk1977   u16 flags;           /* Flags associated with this schema */
88014db2665Sdanielk1977   int cache_size;      /* Number of pages to use in the cache */
881001bbcbbSdrh };
88275897234Sdrh 
88375897234Sdrh /*
8848bf8dc92Sdrh ** These macros can be used to test, set, or clear bits in the
885a2460e07Sdrh ** Db.pSchema->flags field.
8868bf8dc92Sdrh */
887da184236Sdanielk1977 #define DbHasProperty(D,I,P)     (((D)->aDb[I].pSchema->flags&(P))==(P))
888da184236Sdanielk1977 #define DbHasAnyProperty(D,I,P)  (((D)->aDb[I].pSchema->flags&(P))!=0)
889da184236Sdanielk1977 #define DbSetProperty(D,I,P)     (D)->aDb[I].pSchema->flags|=(P)
890da184236Sdanielk1977 #define DbClearProperty(D,I,P)   (D)->aDb[I].pSchema->flags&=~(P)
8918bf8dc92Sdrh 
8928bf8dc92Sdrh /*
893a2460e07Sdrh ** Allowed values for the DB.pSchema->flags field.
8948bf8dc92Sdrh **
8958bf8dc92Sdrh ** The DB_SchemaLoaded flag is set after the database schema has been
8968bf8dc92Sdrh ** read into internal hash tables.
8978bf8dc92Sdrh **
8988bf8dc92Sdrh ** DB_UnresetViews means that one or more views have column names that
8998bf8dc92Sdrh ** have been filled out.  If the schema changes, these column names might
9008bf8dc92Sdrh ** changes and so the view will need to be reset.
9018bf8dc92Sdrh */
902124b27e6Sdrh #define DB_SchemaLoaded    0x0001  /* The schema has been loaded */
903124b27e6Sdrh #define DB_UnresetViews    0x0002  /* Some views have defined column names */
904b82e7edaSdanielk1977 #define DB_Empty           0x0004  /* The file is empty (length 0 bytes) */
9058bf8dc92Sdrh 
906caa639f4Sdrh /*
907caa639f4Sdrh ** The number of different kinds of things that can be limited
908caa639f4Sdrh ** using the sqlite3_limit() interface.
909caa639f4Sdrh */
910417168adSdrh #define SQLITE_N_LIMIT (SQLITE_LIMIT_TRIGGER_DEPTH+1)
9118bf8dc92Sdrh 
9128bf8dc92Sdrh /*
913633e6d57Sdrh ** Lookaside malloc is a set of fixed-size buffers that can be used
914467bcf36Sshane ** to satisfy small transient memory allocation requests for objects
915633e6d57Sdrh ** associated with a particular database connection.  The use of
916633e6d57Sdrh ** lookaside malloc provides a significant performance enhancement
917633e6d57Sdrh ** (approx 10%) by avoiding numerous malloc/free requests while parsing
918633e6d57Sdrh ** SQL statements.
919633e6d57Sdrh **
920633e6d57Sdrh ** The Lookaside structure holds configuration information about the
921633e6d57Sdrh ** lookaside malloc subsystem.  Each available memory allocation in
922633e6d57Sdrh ** the lookaside subsystem is stored on a linked list of LookasideSlot
923633e6d57Sdrh ** objects.
924d9da78a2Sdrh **
925d9da78a2Sdrh ** Lookaside allocations are only allowed for objects that are associated
926d9da78a2Sdrh ** with a particular database connection.  Hence, schema information cannot
927d9da78a2Sdrh ** be stored in lookaside because in shared cache mode the schema information
928d9da78a2Sdrh ** is shared by multiple database connections.  Therefore, while parsing
929d9da78a2Sdrh ** schema information, the Lookaside.bEnabled flag is cleared so that
930d9da78a2Sdrh ** lookaside allocations are not used to construct the schema objects.
931633e6d57Sdrh */
932633e6d57Sdrh struct Lookaside {
933633e6d57Sdrh   u16 sz;                 /* Size of each buffer in bytes */
934d9da78a2Sdrh   u8 bEnabled;            /* False to disable new lookaside allocations */
935e9d1c720Sdrh   u8 bMalloced;           /* True if pStart obtained from sqlite3_malloc() */
936633e6d57Sdrh   int nOut;               /* Number of buffers currently checked out */
937633e6d57Sdrh   int mxOut;              /* Highwater mark for nOut */
9380b12e7f8Sdrh   int anStat[3];          /* 0: hits.  1: size misses.  2: full misses */
9397d10d5a6Sdrh   LookasideSlot *pFree;   /* List of available buffers */
940633e6d57Sdrh   void *pStart;           /* First byte of available memory space */
941633e6d57Sdrh   void *pEnd;             /* First byte past end of available space */
942633e6d57Sdrh };
943633e6d57Sdrh struct LookasideSlot {
944633e6d57Sdrh   LookasideSlot *pNext;    /* Next buffer in the list of free buffers */
945633e6d57Sdrh };
946633e6d57Sdrh 
947633e6d57Sdrh /*
94870a8ca3cSdrh ** A hash table for function definitions.
94970a8ca3cSdrh **
95070a8ca3cSdrh ** Hash each FuncDef structure into one of the FuncDefHash.a[] slots.
95170a8ca3cSdrh ** Collisions are on the FuncDef.pHash chain.
95270a8ca3cSdrh */
95370a8ca3cSdrh struct FuncDefHash {
95470a8ca3cSdrh   FuncDef *a[23];       /* Hash table for functions */
95570a8ca3cSdrh };
95670a8ca3cSdrh 
95770a8ca3cSdrh /*
958a2460e07Sdrh ** Each database connection is an instance of the following structure.
95975897234Sdrh */
9609bb575fdSdrh struct sqlite3 {
96190f6a5beSdrh   sqlite3_vfs *pVfs;            /* OS Interface */
962a451017dSdrh   struct Vdbe *pVdbe;           /* List of active virtual machines */
963a451017dSdrh   CollSeq *pDfltColl;           /* The default collating sequence (BINARY) */
964a451017dSdrh   sqlite3_mutex *mutex;         /* Connection mutex */
965001bbcbbSdrh   Db *aDb;                      /* All backends */
966a451017dSdrh   int nDb;                      /* Number of backends currently in use */
967467bcf36Sshane   int flags;                    /* Miscellaneous flags. See below */
968a451017dSdrh   i64 lastRowid;                /* ROWID of most recent insert (see above) */
9699b4c59faSdrh   i64 szMmap;                   /* Default mmap_size setting */
970522c26fbSdrh   unsigned int openFlags;       /* Flags passed to sqlite3_vfs.xOpen() */
971fcd35c7bSdrh   int errCode;                  /* Most recent error code (SQLITE_*) */
9724ac285a1Sdrh   int errMask;                  /* & result codes with this before returning */
973a5759677Sdrh   u16 dbOptFlags;               /* Flags to enable/disable optimizations */
974fcd35c7bSdrh   u8 autoCommit;                /* The auto-commit flag. */
97590f5ecb3Sdrh   u8 temp_store;                /* 1: file 2: memory 0: default */
97617435752Sdrh   u8 mallocFailed;              /* True if we have seen a malloc failure */
9773b02013eSdrh   u8 dfltLockMode;              /* Default locking-mode for attached dbs */
97898757157Sdrh   signed char nextAutovac;      /* Autovac setting after VACUUM if >=0 */
979a7564663Sdrh   u8 suppressErr;               /* Do not issue error messages if true */
980b061d058Sdan   u8 vtabOnConflict;            /* Value to return for s3_vtab_on_conflict() */
981a451017dSdrh   u8 isTransactionSavepoint;    /* True if the outermost savepoint is a TS */
982f653d782Sdanielk1977   int nextPagesize;             /* Pagesize after VACUUM if >0 */
98364202cfeSdanielk1977   u32 magic;                    /* Magic number for detect library misuse */
984b28af71aSdanielk1977   int nChange;                  /* Value returned by sqlite3_changes() */
985b28af71aSdanielk1977   int nTotalChange;             /* Value returned by sqlite3_total_changes() */
986caa639f4Sdrh   int aLimit[SQLITE_N_LIMIT];   /* Limits */
9874adee20fSdanielk1977   struct sqlite3InitInfo {      /* Information used during initialization */
9881d85d931Sdrh     int newTnum;                /* Rootpage of table being initialized */
989a451017dSdrh     u8 iDb;                     /* Which db file is being initialized */
9901d85d931Sdrh     u8 busy;                    /* TRUE if currently initializing */
9913d5f74b2Sdrh     u8 orphanTrigger;           /* Last statement is orphaned TEMP trigger */
9921d85d931Sdrh   } init;
9931713afb0Sdrh   int nVdbeActive;              /* Number of VDBEs currently running */
9944f7d3a5fSdrh   int nVdbeRead;                /* Number of active VDBEs that read or write */
9954f7d3a5fSdrh   int nVdbeWrite;               /* Number of active VDBEs that read and write */
9964f7d3a5fSdrh   int nVdbeExec;                /* Number of nested calls to VdbeExec() */
997a451017dSdrh   int nExtension;               /* Number of loaded extensions */
998a451017dSdrh   void **aExtension;            /* Array of shared library handles */
99918de4824Sdrh   void (*xTrace)(void*,const char*);        /* Trace function */
100018de4824Sdrh   void *pTraceArg;                          /* Argument to the trace function */
100119e2d37fSdrh   void (*xProfile)(void*,const char*,u64);  /* Profiling function */
100219e2d37fSdrh   void *pProfileArg;                        /* Argument to profile function */
1003fcd35c7bSdrh   void *pCommitArg;                 /* Argument to xCommitCallback() */
1004fcd35c7bSdrh   int (*xCommitCallback)(void*);    /* Invoked at every commit. */
100571fd80bfSdanielk1977   void *pRollbackArg;               /* Argument to xRollbackCallback() */
100671fd80bfSdanielk1977   void (*xRollbackCallback)(void*); /* Invoked at every commit. */
100794eb6a14Sdanielk1977   void *pUpdateArg;
100894eb6a14Sdanielk1977   void (*xUpdateCallback)(void*,int, const char*,const char*,sqlite_int64);
10095cf53537Sdan #ifndef SQLITE_OMIT_WAL
10107ed91f23Sdrh   int (*xWalCallback)(void *, sqlite3 *, const char *, int);
10117ed91f23Sdrh   void *pWalArg;
10125cf53537Sdan #endif
1013fcd35c7bSdrh   void(*xCollNeeded)(void*,sqlite3*,int eTextRep,const char*);
1014fcd35c7bSdrh   void(*xCollNeeded16)(void*,sqlite3*,int eTextRep,const void*);
1015fcd35c7bSdrh   void *pCollNeededArg;
1016fcd35c7bSdrh   sqlite3_value *pErr;          /* Most recent error message */
1017881feaa0Sdrh   union {
101839001e75Sdrh     volatile int isInterrupted; /* True if sqlite3_interrupt has been called */
1019881feaa0Sdrh     double notUsed1;            /* Spacer */
1020881feaa0Sdrh   } u1;
1021633e6d57Sdrh   Lookaside lookaside;          /* Lookaside malloc configuration */
1022ed6c8671Sdrh #ifndef SQLITE_OMIT_AUTHORIZATION
1023e22a334bSdrh   int (*xAuth)(void*,int,const char*,const char*,const char*,const char*);
1024e22a334bSdrh                                 /* Access authorization function */
1025ed6c8671Sdrh   void *pAuthArg;               /* 1st argument to the access auth function */
1026ed6c8671Sdrh #endif
1027348bb5d6Sdanielk1977 #ifndef SQLITE_OMIT_PROGRESS_CALLBACK
1028348bb5d6Sdanielk1977   int (*xProgress)(void *);     /* The progress callback */
1029348bb5d6Sdanielk1977   void *pProgressArg;           /* Argument to the progress callback */
10308f8c65f7Sdrh   unsigned nProgressOps;        /* Number of opcodes for progress callback */
1031348bb5d6Sdanielk1977 #endif
1032b9bb7c18Sdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
1033a451017dSdrh   int nVTrans;                  /* Allocated size of aVTrans */
1034b9bb7c18Sdrh   Hash aModule;                 /* populated by sqlite3_create_module() */
1035b061d058Sdan   VtabCtx *pVtabCtx;            /* Context for active vtab connect/create */
1036595a523aSdanielk1977   VTable **aVTrans;             /* Virtual tables with open transactions */
1037595a523aSdanielk1977   VTable *pDisconnect;    /* Disconnect these in next sqlite3_prepare() */
10386b456a2bSdanielk1977 #endif
103970a8ca3cSdrh   FuncDefHash aFunc;            /* Hash table of connection functions */
1040fcd35c7bSdrh   Hash aCollSeq;                /* All collating sequences */
1041fcd35c7bSdrh   BusyHandler busyHandler;      /* Busy callback */
1042fcd35c7bSdrh   Db aDbStatic[2];              /* Static space for the 2 default backends */
1043fd7f0452Sdanielk1977   Savepoint *pSavepoint;        /* List of active savepoints */
1044a451017dSdrh   int busyTimeout;              /* Busy handler timeout, in msec */
1045fd7f0452Sdanielk1977   int nSavepoint;               /* Number of non-transaction savepoints */
1046bd43455cSdanielk1977   int nStatement;               /* Number of nested statement-transactions  */
10471da40a38Sdan   i64 nDeferredCons;            /* Net deferred constraints this transaction. */
1048648e2643Sdrh   i64 nDeferredImmCons;         /* Net deferred immediate constraints */
1049d46def77Sdan   int *pnBytesFreed;            /* If not NULL, increment this in DbFree() */
1050404ca075Sdanielk1977 
1051404ca075Sdanielk1977 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
1052404ca075Sdanielk1977   /* The following variables are all protected by the STATIC_MASTER
1053404ca075Sdanielk1977   ** mutex, not by sqlite3.mutex. They are used by code in notify.c.
105465a73badSdrh   **
105565a73badSdrh   ** When X.pUnlockConnection==Y, that means that X is waiting for Y to
105665a73badSdrh   ** unlock so that it can proceed.
105765a73badSdrh   **
105865a73badSdrh   ** When X.pBlockingConnection==Y, that means that something that X tried
105965a73badSdrh   ** tried to do recently failed with an SQLITE_LOCKED error due to locks
106065a73badSdrh   ** held by Y.
1061404ca075Sdanielk1977   */
1062404ca075Sdanielk1977   sqlite3 *pBlockingConnection; /* Connection that caused SQLITE_LOCKED */
1063404ca075Sdanielk1977   sqlite3 *pUnlockConnection;           /* Connection to watch for unlock */
1064404ca075Sdanielk1977   void *pUnlockArg;                     /* Argument to xUnlockNotify */
1065404ca075Sdanielk1977   void (*xUnlockNotify)(void **, int);  /* Unlock notify callback */
1066404ca075Sdanielk1977   sqlite3 *pNextBlocked;        /* Next in list of all blocked connections */
1067404ca075Sdanielk1977 #endif
106875897234Sdrh };
106975897234Sdrh 
107003b808a6Sdrh /*
107103b808a6Sdrh ** A macro to discover the encoding of a database.
107203b808a6Sdrh */
107314db2665Sdanielk1977 #define ENC(db) ((db)->aDb[0].pSchema->enc)
107414db2665Sdanielk1977 
107575897234Sdrh /*
107607096f68Sdrh ** Possible values for the sqlite3.flags.
107775897234Sdrh */
10787e5418e4Sdrh #define SQLITE_VdbeTrace      0x00000001  /* True to trace VDBE execution */
10797e5418e4Sdrh #define SQLITE_InternChanges  0x00000002  /* Uncommitted Hash table changes */
108040c3941cSdrh #define SQLITE_FullFSync      0x00000004  /* Use full fsync on the backend */
108140c3941cSdrh #define SQLITE_CkptFullFSync  0x00000008  /* Use full fsync for checkpoint */
108240c3941cSdrh #define SQLITE_CacheSpill     0x00000010  /* OK to spill pager cache */
108340c3941cSdrh #define SQLITE_FullColNames   0x00000020  /* Show full column names on SELECT */
108440c3941cSdrh #define SQLITE_ShortColNames  0x00000040  /* Show short columns names */
108540c3941cSdrh #define SQLITE_CountRows      0x00000080  /* Count rows changed by INSERT, */
10861bee3d7bSdrh                                           /*   DELETE, or UPDATE and return */
10871bee3d7bSdrh                                           /*   the count using a callback. */
108840c3941cSdrh #define SQLITE_NullCallback   0x00000100  /* Invoke the callback once if the */
10896a535340Sdrh                                           /*   result set is empty */
109040c3941cSdrh #define SQLITE_SqlTrace       0x00000200  /* Debug print SQL as it executes */
109140c3941cSdrh #define SQLITE_VdbeListing    0x00000400  /* Debug listings of VDBE programs */
109240c3941cSdrh #define SQLITE_WriteSchema    0x00000800  /* OK to update SQLITE_MASTER */
109340c3941cSdrh #define SQLITE_VdbeAddopTrace 0x00001000  /* Trace sqlite3VdbeAddOp() calls */
109440c3941cSdrh #define SQLITE_IgnoreChecks   0x00002000  /* Do not enforce check constraints */
109540c3941cSdrh #define SQLITE_ReadUncommitted 0x0004000  /* For shared-cache mode */
109640c3941cSdrh #define SQLITE_LegacyFileFmt  0x00008000  /* Create new databases in format 1 */
109740c3941cSdrh #define SQLITE_RecoveryMode   0x00010000  /* Ignore schema errors */
109840c3941cSdrh #define SQLITE_ReverseOrder   0x00020000  /* Reverse unordered SELECTs */
109940c3941cSdrh #define SQLITE_RecTriggers    0x00040000  /* Enable recursive triggers */
110040c3941cSdrh #define SQLITE_ForeignKeys    0x00080000  /* Enforce foreign key constraints  */
110140c3941cSdrh #define SQLITE_AutoIndex      0x00100000  /* Enable automatic indexes */
110240c3941cSdrh #define SQLITE_PreferBuiltin  0x00200000  /* Preference to built-in funcs */
110340c3941cSdrh #define SQLITE_LoadExtension  0x00400000  /* Enable load_extension */
110440c3941cSdrh #define SQLITE_EnableTrigger  0x00800000  /* True to enable triggers */
110540c3941cSdrh #define SQLITE_DeferFKs       0x01000000  /* Defer all FK constraints */
110640c3941cSdrh #define SQLITE_QueryOnly      0x02000000  /* Disable database changes */
110784e55a80Sdrh #define SQLITE_VdbeEQP        0x04000000  /* Debug EXPLAIN QUERY PLAN */
1108b1eaa718Sdrh 
110907096f68Sdrh 
111007096f68Sdrh /*
11117e5418e4Sdrh ** Bits of the sqlite3.dbOptFlags field that are used by the
11127e5418e4Sdrh ** sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS,...) interface to
11137e5418e4Sdrh ** selectively disable various optimizations.
111407096f68Sdrh */
11157e5418e4Sdrh #define SQLITE_QueryFlattener 0x0001   /* Query flattening */
11167e5418e4Sdrh #define SQLITE_ColumnCache    0x0002   /* Column cache */
11177e5418e4Sdrh #define SQLITE_GroupByOrder   0x0004   /* GROUPBY cover of ORDERBY */
11187e5418e4Sdrh #define SQLITE_FactorOutConst 0x0008   /* Constant factoring */
1119762c1c40Sdrh /*                not used    0x0010   // Was: SQLITE_IdxRealAsInt */
11207e5418e4Sdrh #define SQLITE_DistinctOpt    0x0020   /* DISTINCT using indexes */
11217e5418e4Sdrh #define SQLITE_CoverIdxScan   0x0040   /* Covering index scans */
1122a9e3fc05Sdrh #define SQLITE_OrderByIdxJoin 0x0080   /* ORDER BY of joins via index */
1123a5759677Sdrh #define SQLITE_SubqCoroutine  0x0100   /* Evaluate subqueries as coroutines */
1124eb5bc926Sdrh #define SQLITE_Transitive     0x0200   /* Transitive constraints */
11251031bd99Sdrh #define SQLITE_OmitNoopJoin   0x0400   /* Omit unused tables in joins */
112640aa936fSdrh #define SQLITE_Stat3          0x0800   /* Use the SQLITE_STAT3 table */
1127add5ce30Sdrh #define SQLITE_AdjustOutEst   0x1000   /* Adjust output estimates using WHERE */
1128a5759677Sdrh #define SQLITE_AllOpts        0xffff   /* All optimizations */
11297e5418e4Sdrh 
11307e5418e4Sdrh /*
11317e5418e4Sdrh ** Macros for testing whether or not optimizations are enabled or disabled.
11327e5418e4Sdrh */
11337e5418e4Sdrh #ifndef SQLITE_OMIT_BUILTIN_TEST
11347e5418e4Sdrh #define OptimizationDisabled(db, mask)  (((db)->dbOptFlags&(mask))!=0)
11357e5418e4Sdrh #define OptimizationEnabled(db, mask)   (((db)->dbOptFlags&(mask))==0)
11367e5418e4Sdrh #else
11377e5418e4Sdrh #define OptimizationDisabled(db, mask)  0
11387e5418e4Sdrh #define OptimizationEnabled(db, mask)   1
11397e5418e4Sdrh #endif
114034c68fbaSdanielk1977 
114158b9576bSdrh /*
1142d9f158e7Sdrh ** Return true if it OK to factor constant expressions into the initialization
1143d9f158e7Sdrh ** code. The argument is a Parse object for the code generator.
1144d9f158e7Sdrh */
1145aceb31b1Sdrh #define ConstFactorOk(P) ((P)->okConstFactor)
1146d9f158e7Sdrh 
1147d9f158e7Sdrh /*
1148247be43dSdrh ** Possible values for the sqlite.magic field.
1149247be43dSdrh ** The numbers are obtained at random and have no special meaning, other
1150247be43dSdrh ** than being distinct from one another.
1151247be43dSdrh */
1152247be43dSdrh #define SQLITE_MAGIC_OPEN     0xa029a697  /* Database is open */
1153247be43dSdrh #define SQLITE_MAGIC_CLOSED   0x9f3c2d33  /* Database is closed */
11547e8b848aSdrh #define SQLITE_MAGIC_SICK     0x4b771290  /* Error and awaiting close */
1155247be43dSdrh #define SQLITE_MAGIC_BUSY     0xf03b7906  /* Database currently in use */
1156247be43dSdrh #define SQLITE_MAGIC_ERROR    0xb5357930  /* An SQLITE_MISUSE error occurred */
11574245c405Sdrh #define SQLITE_MAGIC_ZOMBIE   0x64cffc7f  /* Close with last statement close */
1158247be43dSdrh 
1159247be43dSdrh /*
11600bce8354Sdrh ** Each SQL function is defined by an instance of the following
11610bce8354Sdrh ** structure.  A pointer to this structure is stored in the sqlite.aFunc
11628e0a2f90Sdrh ** hash table.  When multiple functions have the same name, the hash table
11638e0a2f90Sdrh ** points to a linked list of these structures.
11642803757aSdrh */
11650bce8354Sdrh struct FuncDef {
1166e82f5d04Sdrh   i16 nArg;            /* Number of arguments.  -1 means unlimited */
1167d36e1041Sdrh   u16 funcFlags;       /* Some combination of SQLITE_FUNC_* */
11681350b030Sdrh   void *pUserData;     /* User data parameter */
11690bce8354Sdrh   FuncDef *pNext;      /* Next function with same name */
1170f9b596ebSdrh   void (*xFunc)(sqlite3_context*,int,sqlite3_value**); /* Regular function */
1171f9b596ebSdrh   void (*xStep)(sqlite3_context*,int,sqlite3_value**); /* Aggregate step */
1172467bcf36Sshane   void (*xFinalize)(sqlite3_context*);                /* Aggregate finalizer */
11738c0a791aSdanielk1977   char *zName;         /* SQL name of the function. */
117470a8ca3cSdrh   FuncDef *pHash;      /* Next with a different name but the same hash */
1175d2199f0fSdan   FuncDestructor *pDestructor;   /* Reference counted destructor function */
1176d2199f0fSdan };
1177d2199f0fSdan 
1178d2199f0fSdan /*
1179d2199f0fSdan ** This structure encapsulates a user-function destructor callback (as
1180d2199f0fSdan ** configured using create_function_v2()) and a reference counter. When
1181d2199f0fSdan ** create_function_v2() is called to create a function with a destructor,
1182d2199f0fSdan ** a single object of this type is allocated. FuncDestructor.nRef is set to
1183d2199f0fSdan ** the number of FuncDef objects created (either 1 or 3, depending on whether
1184d2199f0fSdan ** or not the specified encoding is SQLITE_ANY). The FuncDef.pDestructor
1185d2199f0fSdan ** member of each of the new FuncDef objects is set to point to the allocated
1186d2199f0fSdan ** FuncDestructor.
1187d2199f0fSdan **
1188d2199f0fSdan ** Thereafter, when one of the FuncDef objects is deleted, the reference
1189d2199f0fSdan ** count on this object is decremented. When it reaches 0, the destructor
1190d2199f0fSdan ** is invoked and the FuncDestructor structure freed.
1191d2199f0fSdan */
1192d2199f0fSdan struct FuncDestructor {
1193d2199f0fSdan   int nRef;
1194d2199f0fSdan   void (*xDestroy)(void *);
1195d2199f0fSdan   void *pUserData;
11968e0a2f90Sdrh };
11972803757aSdrh 
11982803757aSdrh /*
1199a748fdccSdrh ** Possible values for FuncDef.flags.  Note that the _LENGTH and _TYPEOF
1200a748fdccSdrh ** values must correspond to OPFLAG_LENGTHARG and OPFLAG_TYPEOFARG.  There
1201a748fdccSdrh ** are assert() statements in the code to verify this.
12027d10d5a6Sdrh */
1203d36e1041Sdrh #define SQLITE_FUNC_ENCMASK  0x003 /* SQLITE_UTF8, SQLITE_UTF16BE or UTF16LE */
1204d36e1041Sdrh #define SQLITE_FUNC_LIKE     0x004 /* Candidate for the LIKE optimization */
1205d36e1041Sdrh #define SQLITE_FUNC_CASE     0x008 /* Case-sensitive LIKE-type function */
1206d36e1041Sdrh #define SQLITE_FUNC_EPHEM    0x010 /* Ephemeral.  Delete with VDBE */
1207d36e1041Sdrh #define SQLITE_FUNC_NEEDCOLL 0x020 /* sqlite3GetFuncCollSeq() might be called */
1208d36e1041Sdrh #define SQLITE_FUNC_LENGTH   0x040 /* Built-in length() function */
1209d36e1041Sdrh #define SQLITE_FUNC_TYPEOF   0x080 /* Built-in typeof() function */
1210d36e1041Sdrh #define SQLITE_FUNC_COUNT    0x100 /* Built-in count(*) aggregate */
1211d36e1041Sdrh #define SQLITE_FUNC_COALESCE 0x200 /* Built-in coalesce() or ifnull() */
1212d36e1041Sdrh #define SQLITE_FUNC_UNLIKELY 0x400 /* Built-in unlikely() function */
1213b1fba286Sdrh #define SQLITE_FUNC_CONSTANT 0x800 /* Constant inputs give a constant output */
12147d10d5a6Sdrh 
12157d10d5a6Sdrh /*
1216777c5386Sdrh ** The following three macros, FUNCTION(), LIKEFUNC() and AGGREGATE() are
1217777c5386Sdrh ** used to create the initializers for the FuncDef structures.
1218777c5386Sdrh **
1219777c5386Sdrh **   FUNCTION(zName, nArg, iArg, bNC, xFunc)
1220777c5386Sdrh **     Used to create a scalar function definition of a function zName
1221777c5386Sdrh **     implemented by C function xFunc that accepts nArg arguments. The
1222777c5386Sdrh **     value passed as iArg is cast to a (void*) and made available
1223777c5386Sdrh **     as the user-data (sqlite3_user_data()) for the function. If
1224f7bca574Sdrh **     argument bNC is true, then the SQLITE_FUNC_NEEDCOLL flag is set.
1225777c5386Sdrh **
1226b1fba286Sdrh **   VFUNCTION(zName, nArg, iArg, bNC, xFunc)
1227b1fba286Sdrh **     Like FUNCTION except it omits the SQLITE_FUNC_CONSTANT flag.
1228b1fba286Sdrh **
1229777c5386Sdrh **   AGGREGATE(zName, nArg, iArg, bNC, xStep, xFinal)
1230777c5386Sdrh **     Used to create an aggregate function definition implemented by
1231777c5386Sdrh **     the C functions xStep and xFinal. The first four parameters
1232777c5386Sdrh **     are interpreted in the same way as the first 4 parameters to
1233777c5386Sdrh **     FUNCTION().
1234777c5386Sdrh **
1235777c5386Sdrh **   LIKEFUNC(zName, nArg, pArg, flags)
1236777c5386Sdrh **     Used to create a scalar function definition of a function zName
1237777c5386Sdrh **     that accepts nArg arguments and is implemented by a call to C
1238777c5386Sdrh **     function likeFunc. Argument pArg is cast to a (void *) and made
1239777c5386Sdrh **     available as the function user-data (sqlite3_user_data()). The
1240777c5386Sdrh **     FuncDef.flags variable is set to the value passed as the flags
1241777c5386Sdrh **     parameter.
1242777c5386Sdrh */
1243777c5386Sdrh #define FUNCTION(zName, nArg, iArg, bNC, xFunc) \
1244b1fba286Sdrh   {nArg, SQLITE_FUNC_CONSTANT|SQLITE_UTF8|(bNC*SQLITE_FUNC_NEEDCOLL), \
1245b1fba286Sdrh    SQLITE_INT_TO_PTR(iArg), 0, xFunc, 0, 0, #zName, 0, 0}
1246b1fba286Sdrh #define VFUNCTION(zName, nArg, iArg, bNC, xFunc) \
1247d36e1041Sdrh   {nArg, SQLITE_UTF8|(bNC*SQLITE_FUNC_NEEDCOLL), \
1248a748fdccSdrh    SQLITE_INT_TO_PTR(iArg), 0, xFunc, 0, 0, #zName, 0, 0}
1249a748fdccSdrh #define FUNCTION2(zName, nArg, iArg, bNC, xFunc, extraFlags) \
1250b1fba286Sdrh   {nArg,SQLITE_FUNC_CONSTANT|SQLITE_UTF8|(bNC*SQLITE_FUNC_NEEDCOLL)|extraFlags,\
12516ac78a0dSdrh    SQLITE_INT_TO_PTR(iArg), 0, xFunc, 0, 0, #zName, 0, 0}
125221717ed6Sdrh #define STR_FUNCTION(zName, nArg, pArg, bNC, xFunc) \
1253b1fba286Sdrh   {nArg, SQLITE_FUNC_CONSTANT|SQLITE_UTF8|(bNC*SQLITE_FUNC_NEEDCOLL), \
12546ac78a0dSdrh    pArg, 0, xFunc, 0, 0, #zName, 0, 0}
1255777c5386Sdrh #define LIKEFUNC(zName, nArg, arg, flags) \
1256b1fba286Sdrh   {nArg, SQLITE_FUNC_CONSTANT|SQLITE_UTF8|flags, \
1257b1fba286Sdrh    (void *)arg, 0, likeFunc, 0, 0, #zName, 0, 0}
1258777c5386Sdrh #define AGGREGATE(zName, nArg, arg, nc, xStep, xFinal) \
1259d36e1041Sdrh   {nArg, SQLITE_UTF8|(nc*SQLITE_FUNC_NEEDCOLL), \
12606ac78a0dSdrh    SQLITE_INT_TO_PTR(arg), 0, 0, xStep,xFinal,#zName,0,0}
1261777c5386Sdrh 
1262fd7f0452Sdanielk1977 /*
1263fd7f0452Sdanielk1977 ** All current savepoints are stored in a linked list starting at
1264fd7f0452Sdanielk1977 ** sqlite3.pSavepoint. The first element in the list is the most recently
1265fd7f0452Sdanielk1977 ** opened savepoint. Savepoints are added to the list by the vdbe
1266fd7f0452Sdanielk1977 ** OP_Savepoint instruction.
1267fd7f0452Sdanielk1977 */
1268fd7f0452Sdanielk1977 struct Savepoint {
1269fd7f0452Sdanielk1977   char *zName;                        /* Savepoint name (nul-terminated) */
1270fcb9f7adSdrh   i64 nDeferredCons;                  /* Number of deferred fk violations */
1271648e2643Sdrh   i64 nDeferredImmCons;               /* Number of deferred imm fk. */
1272fd7f0452Sdanielk1977   Savepoint *pNext;                   /* Parent savepoint (if any) */
1273fd7f0452Sdanielk1977 };
1274fd7f0452Sdanielk1977 
1275fd7f0452Sdanielk1977 /*
1276fd7f0452Sdanielk1977 ** The following are used as the second parameter to sqlite3Savepoint(),
1277fd7f0452Sdanielk1977 ** and as the P1 argument to the OP_Savepoint instruction.
1278fd7f0452Sdanielk1977 */
1279fd7f0452Sdanielk1977 #define SAVEPOINT_BEGIN      0
1280fd7f0452Sdanielk1977 #define SAVEPOINT_RELEASE    1
1281fd7f0452Sdanielk1977 #define SAVEPOINT_ROLLBACK   2
1282fd7f0452Sdanielk1977 
1283777c5386Sdrh 
1284777c5386Sdrh /*
1285d1ab1ba5Sdanielk1977 ** Each SQLite module (virtual table definition) is defined by an
1286d1ab1ba5Sdanielk1977 ** instance of the following structure, stored in the sqlite3.aModule
1287d1ab1ba5Sdanielk1977 ** hash table.
1288d1ab1ba5Sdanielk1977 */
1289d1ab1ba5Sdanielk1977 struct Module {
1290d1ab1ba5Sdanielk1977   const sqlite3_module *pModule;       /* Callback pointers */
1291d1ab1ba5Sdanielk1977   const char *zName;                   /* Name passed to create_module() */
1292d1ab1ba5Sdanielk1977   void *pAux;                          /* pAux passed to create_module() */
1293832a58a6Sdanielk1977   void (*xDestroy)(void *);            /* Module destructor function */
1294d1ab1ba5Sdanielk1977 };
1295d1ab1ba5Sdanielk1977 
1296d1ab1ba5Sdanielk1977 /*
1297967e8b73Sdrh ** information about each column of an SQL table is held in an instance
12987020f651Sdrh ** of this structure.
12997020f651Sdrh */
13007020f651Sdrh struct Column {
13017020f651Sdrh   char *zName;     /* Name of this column */
13027977a17fSdanielk1977   Expr *pDflt;     /* Default value of this column */
1303b7916a78Sdrh   char *zDflt;     /* Original text of the default value */
1304382c0247Sdrh   char *zType;     /* Data type for this column */
1305b3bf556eSdanielk1977   char *zColl;     /* Collating sequence.  If NULL, use the default */
1306a371ace4Sdrh   u8 notNull;      /* An OE_ code for handling a NOT NULL constraint */
1307a37cdde0Sdanielk1977   char affinity;   /* One of the SQLITE_AFF_... values */
1308fdaac671Sdrh   u8 szEst;        /* Estimated size of this column.  INT==1 */
1309fdaac671Sdrh   u8 colFlags;     /* Boolean properties.  See COLFLAG_ defines below */
13107020f651Sdrh };
13117020f651Sdrh 
1312a371ace4Sdrh /* Allowed values for Column.colFlags:
1313a371ace4Sdrh */
1314a371ace4Sdrh #define COLFLAG_PRIMKEY  0x0001    /* Column is part of the primary key */
1315a371ace4Sdrh #define COLFLAG_HIDDEN   0x0002    /* A hidden column in a virtual table */
1316a371ace4Sdrh 
13177020f651Sdrh /*
1318a9fd84b0Sdrh ** A "Collating Sequence" is defined by an instance of the following
13190202b29eSdanielk1977 ** structure. Conceptually, a collating sequence consists of a name and
13200202b29eSdanielk1977 ** a comparison routine that defines the order of that sequence.
1321a9fd84b0Sdrh **
1322e6f1e760Sdrh ** If CollSeq.xCmp is NULL, it means that the
13230202b29eSdanielk1977 ** collating sequence is undefined.  Indices built on an undefined
13240202b29eSdanielk1977 ** collating sequence may not be read or written.
1325a9fd84b0Sdrh */
1326a9fd84b0Sdrh struct CollSeq {
13270202b29eSdanielk1977   char *zName;          /* Name of the collating sequence, UTF-8 encoded */
1328466be56bSdanielk1977   u8 enc;               /* Text encoding handled by xCmp() */
1329a9fd84b0Sdrh   void *pUser;          /* First argument to xCmp() */
13300202b29eSdanielk1977   int (*xCmp)(void*,int, const void*, int, const void*);
1331a9808b31Sdanielk1977   void (*xDel)(void*);  /* Destructor for pUser */
1332a9fd84b0Sdrh };
1333a9fd84b0Sdrh 
1334a9fd84b0Sdrh /*
1335d3d39e93Sdrh ** A sort order can be either ASC or DESC.
13368e2ca029Sdrh */
13378e2ca029Sdrh #define SQLITE_SO_ASC       0  /* Sort in ascending order */
1338d3d39e93Sdrh #define SQLITE_SO_DESC      1  /* Sort in ascending order */
13398e2ca029Sdrh 
13408e2ca029Sdrh /*
1341a37cdde0Sdanielk1977 ** Column affinity types.
13428a51256cSdrh **
13438a51256cSdrh ** These used to have mnemonic name like 'i' for SQLITE_AFF_INTEGER and
13448a51256cSdrh ** 't' for SQLITE_AFF_TEXT.  But we can save a little space and improve
13457d10d5a6Sdrh ** the speed a little by numbering the values consecutively.
13468a51256cSdrh **
13478a51256cSdrh ** But rather than start with 0 or 1, we begin with 'a'.  That way,
13488a51256cSdrh ** when multiple affinity types are concatenated into a string and
134966a5167bSdrh ** used as the P4 operand, they will be more readable.
13508a51256cSdrh **
13518a51256cSdrh ** Note also that the numeric types are grouped together so that testing
13528a51256cSdrh ** for a numeric type is a single comparison.
1353a37cdde0Sdanielk1977 */
13548a51256cSdrh #define SQLITE_AFF_TEXT     'a'
13558a51256cSdrh #define SQLITE_AFF_NONE     'b'
13568a51256cSdrh #define SQLITE_AFF_NUMERIC  'c'
13578a51256cSdrh #define SQLITE_AFF_INTEGER  'd'
13588a51256cSdrh #define SQLITE_AFF_REAL     'e'
1359a37cdde0Sdanielk1977 
13608a51256cSdrh #define sqlite3IsNumericAffinity(X)  ((X)>=SQLITE_AFF_NUMERIC)
1361a37cdde0Sdanielk1977 
1362a37cdde0Sdanielk1977 /*
136335573356Sdrh ** The SQLITE_AFF_MASK values masks off the significant bits of an
136435573356Sdrh ** affinity value.
136535573356Sdrh */
136635573356Sdrh #define SQLITE_AFF_MASK     0x67
136735573356Sdrh 
136835573356Sdrh /*
136935573356Sdrh ** Additional bit values that can be ORed with an affinity without
137035573356Sdrh ** changing the affinity.
13713d77dee9Sdrh **
13723d77dee9Sdrh ** The SQLITE_NOTNULL flag is a combination of NULLEQ and JUMPIFNULL.
13733d77dee9Sdrh ** It causes an assert() to fire if either operand to a comparison
13743d77dee9Sdrh ** operator is NULL.  It is added to certain comparison operators to
13753d77dee9Sdrh ** prove that the operands are always NOT NULL.
137635573356Sdrh */
137735573356Sdrh #define SQLITE_JUMPIFNULL   0x08  /* jumps if either operand is NULL */
137893a960a0Sdrh #define SQLITE_STOREP2      0x10  /* Store result in reg[P2] rather than jump */
13796a2fe093Sdrh #define SQLITE_NULLEQ       0x80  /* NULL=NULL */
13803d77dee9Sdrh #define SQLITE_NOTNULL      0x88  /* Assert that operands are never NULL */
138135573356Sdrh 
138235573356Sdrh /*
1383595a523aSdanielk1977 ** An object of this type is created for each virtual table present in
1384595a523aSdanielk1977 ** the database schema.
1385595a523aSdanielk1977 **
1386595a523aSdanielk1977 ** If the database schema is shared, then there is one instance of this
1387595a523aSdanielk1977 ** structure for each database connection (sqlite3*) that uses the shared
1388595a523aSdanielk1977 ** schema. This is because each database connection requires its own unique
1389595a523aSdanielk1977 ** instance of the sqlite3_vtab* handle used to access the virtual table
1390595a523aSdanielk1977 ** implementation. sqlite3_vtab* handles can not be shared between
1391595a523aSdanielk1977 ** database connections, even when the rest of the in-memory database
1392595a523aSdanielk1977 ** schema is shared, as the implementation often stores the database
1393595a523aSdanielk1977 ** connection handle passed to it via the xConnect() or xCreate() method
1394595a523aSdanielk1977 ** during initialization internally. This database connection handle may
13959bbc2e28Sdrh ** then be used by the virtual table implementation to access real tables
1396595a523aSdanielk1977 ** within the database. So that they appear as part of the callers
1397595a523aSdanielk1977 ** transaction, these accesses need to be made via the same database
1398595a523aSdanielk1977 ** connection as that used to execute SQL operations on the virtual table.
1399595a523aSdanielk1977 **
1400595a523aSdanielk1977 ** All VTable objects that correspond to a single table in a shared
1401595a523aSdanielk1977 ** database schema are initially stored in a linked-list pointed to by
1402595a523aSdanielk1977 ** the Table.pVTable member variable of the corresponding Table object.
1403595a523aSdanielk1977 ** When an sqlite3_prepare() operation is required to access the virtual
1404595a523aSdanielk1977 ** table, it searches the list for the VTable that corresponds to the
1405595a523aSdanielk1977 ** database connection doing the preparing so as to use the correct
1406595a523aSdanielk1977 ** sqlite3_vtab* handle in the compiled query.
1407595a523aSdanielk1977 **
1408595a523aSdanielk1977 ** When an in-memory Table object is deleted (for example when the
1409595a523aSdanielk1977 ** schema is being reloaded for some reason), the VTable objects are not
1410595a523aSdanielk1977 ** deleted and the sqlite3_vtab* handles are not xDisconnect()ed
1411595a523aSdanielk1977 ** immediately. Instead, they are moved from the Table.pVTable list to
1412595a523aSdanielk1977 ** another linked list headed by the sqlite3.pDisconnect member of the
1413595a523aSdanielk1977 ** corresponding sqlite3 structure. They are then deleted/xDisconnected
1414595a523aSdanielk1977 ** next time a statement is prepared using said sqlite3*. This is done
1415595a523aSdanielk1977 ** to avoid deadlock issues involving multiple sqlite3.mutex mutexes.
1416595a523aSdanielk1977 ** Refer to comments above function sqlite3VtabUnlockList() for an
1417595a523aSdanielk1977 ** explanation as to why it is safe to add an entry to an sqlite3.pDisconnect
1418595a523aSdanielk1977 ** list without holding the corresponding sqlite3.mutex mutex.
1419595a523aSdanielk1977 **
1420595a523aSdanielk1977 ** The memory for objects of this type is always allocated by
1421595a523aSdanielk1977 ** sqlite3DbMalloc(), using the connection handle stored in VTable.db as
1422595a523aSdanielk1977 ** the first argument.
1423595a523aSdanielk1977 */
1424595a523aSdanielk1977 struct VTable {
1425595a523aSdanielk1977   sqlite3 *db;              /* Database connection associated with this table */
1426595a523aSdanielk1977   Module *pMod;             /* Pointer to module implementation */
1427595a523aSdanielk1977   sqlite3_vtab *pVtab;      /* Pointer to vtab instance */
1428595a523aSdanielk1977   int nRef;                 /* Number of pointers to this structure */
1429b061d058Sdan   u8 bConstraint;           /* True if constraints are supported */
1430addd8f87Sdrh   int iSavepoint;           /* Depth of the SAVEPOINT stack */
1431595a523aSdanielk1977   VTable *pNext;            /* Next in linked list (see above) */
1432595a523aSdanielk1977 };
1433595a523aSdanielk1977 
1434595a523aSdanielk1977 /*
143522f70c32Sdrh ** Each SQL table is represented in memory by an instance of the
143622f70c32Sdrh ** following structure.
143722f70c32Sdrh **
1438d24cc427Sdrh ** Table.zName is the name of the table.  The case of the original
143922f70c32Sdrh ** CREATE TABLE statement is stored, but case is not significant for
144022f70c32Sdrh ** comparisons.
144122f70c32Sdrh **
1442d24cc427Sdrh ** Table.nCol is the number of columns in this table.  Table.aCol is a
144322f70c32Sdrh ** pointer to an array of Column structures, one for each column.
144422f70c32Sdrh **
1445d24cc427Sdrh ** If the table has an INTEGER PRIMARY KEY, then Table.iPKey is the index of
1446d24cc427Sdrh ** the column that is that key.   Otherwise Table.iPKey is negative.  Note
144722f70c32Sdrh ** that the datatype of the PRIMARY KEY must be INTEGER for this field to
144822f70c32Sdrh ** be set.  An INTEGER PRIMARY KEY is used as the rowid for each row of
144922f70c32Sdrh ** the table.  If a table has no INTEGER PRIMARY KEY, then a random rowid
14507d10d5a6Sdrh ** is generated for each row of the table.  TF_HasPrimaryKey is set if
145122f70c32Sdrh ** the table has any PRIMARY KEY, INTEGER or otherwise.
145222f70c32Sdrh **
1453d24cc427Sdrh ** Table.tnum is the page number for the root BTree page of the table in the
1454d24cc427Sdrh ** database file.  If Table.iDb is the index of the database table backend
1455d24cc427Sdrh ** in sqlite.aDb[].  0 is for the main database and 1 is for the file that
14567d10d5a6Sdrh ** holds temporary tables and indices.  If TF_Ephemeral is set
14577d10d5a6Sdrh ** then the table is stored in a file that is automatically deleted
1458d24cc427Sdrh ** when the VDBE cursor to the table is closed.  In this case Table.tnum
145922f70c32Sdrh ** refers VDBE cursor number that holds the table open, not to the root
146022f70c32Sdrh ** page number.  Transient tables are used to hold the results of a
146122f70c32Sdrh ** sub-query that appears instead of a real table name in the FROM clause
146222f70c32Sdrh ** of a SELECT statement.
146375897234Sdrh */
146475897234Sdrh struct Table {
14657d10d5a6Sdrh   char *zName;         /* Name of the table or view */
14667020f651Sdrh   Column *aCol;        /* Information about each column */
1467967e8b73Sdrh   Index *pIndex;       /* List of SQL indexes on this table. */
1468a76b5dfcSdrh   Select *pSelect;     /* NULL for tables.  Points to definition if a view. */
1469c2eef3b3Sdrh   FKey *pFKey;         /* Linked list of all foreign keys in this table */
14703d1bfeaaSdanielk1977   char *zColAff;       /* String defining the affinity of each column */
1471ffe07b2dSdrh #ifndef SQLITE_OMIT_CHECK
14722938f924Sdrh   ExprList *pCheck;    /* All CHECK constraints */
1473ffe07b2dSdrh #endif
1474cfc9df76Sdan   LogEst nRowLogEst;   /* Estimated rows in table - from sqlite_stat1 table */
1475d815f17dSdrh   int tnum;            /* Root BTree node for this table (see note above) */
1476d815f17dSdrh   i16 iPKey;           /* If not negative, use aCol[iPKey] as the primary key */
1477d815f17dSdrh   i16 nCol;            /* Number of columns in this table */
1478d815f17dSdrh   u16 nRef;            /* Number of pointers to this Table */
1479bf539c4dSdrh   LogEst szTabRow;     /* Estimated size of each table row in bytes */
1480dbd9486dSdrh #ifdef SQLITE_ENABLE_COSTMULT
1481dbd9486dSdrh   LogEst costMult;     /* Cost multiplier for using this table */
1482dbd9486dSdrh #endif
1483d815f17dSdrh   u8 tabFlags;         /* Mask of TF_* values */
1484d815f17dSdrh   u8 keyConf;          /* What to do in case of uniqueness conflict on iPKey */
148519a8e7e8Sdanielk1977 #ifndef SQLITE_OMIT_ALTERTABLE
14867d10d5a6Sdrh   int addColOffset;    /* Offset in CREATE TABLE stmt to add a new column */
148719a8e7e8Sdanielk1977 #endif
1488e09daa90Sdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
1489b9bb7c18Sdrh   int nModuleArg;      /* Number of arguments to the module */
1490b9bb7c18Sdrh   char **azModuleArg;  /* Text of all module args. [0] is module name */
1491d815f17dSdrh   VTable *pVTable;     /* List of VTable objects. */
1492e09daa90Sdrh #endif
14932f886d1dSdanielk1977   Trigger *pTrigger;   /* List of triggers stored in pSchema */
1494728b5779Sdrh   Schema *pSchema;     /* Schema that contains this table */
1495588a9a1aSdrh   Table *pNextZombie;  /* Next on the Parse.pZombieTab list */
149675897234Sdrh };
149775897234Sdrh 
149875897234Sdrh /*
14998ce7184bSdan ** Allowed values for Table.tabFlags.
15007d10d5a6Sdrh */
15017d10d5a6Sdrh #define TF_Readonly        0x01    /* Read-only system table */
1502467bcf36Sshane #define TF_Ephemeral       0x02    /* An ephemeral table */
15037d10d5a6Sdrh #define TF_HasPrimaryKey   0x04    /* Table has a primary key */
15047d10d5a6Sdrh #define TF_Autoincrement   0x08    /* Integer primary key is autoincrement */
15057d10d5a6Sdrh #define TF_Virtual         0x10    /* Is a virtual table */
150681eba73eSdrh #define TF_WithoutRowid    0x20    /* No rowid used. PRIMARY KEY is the key */
15077d10d5a6Sdrh 
15087d10d5a6Sdrh 
15097d10d5a6Sdrh /*
15104cbdda9eSdrh ** Test to see whether or not a table is a virtual table.  This is
15114cbdda9eSdrh ** done as a macro so that it will be optimized out when virtual
15124cbdda9eSdrh ** table support is omitted from the build.
15134cbdda9eSdrh */
15144cbdda9eSdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
15157d10d5a6Sdrh #  define IsVirtual(X)      (((X)->tabFlags & TF_Virtual)!=0)
1516a371ace4Sdrh #  define IsHiddenColumn(X) (((X)->colFlags & COLFLAG_HIDDEN)!=0)
15174cbdda9eSdrh #else
15184cbdda9eSdrh #  define IsVirtual(X)      0
1519034ca14fSdanielk1977 #  define IsHiddenColumn(X) 0
15204cbdda9eSdrh #endif
15214cbdda9eSdrh 
1522ec95c441Sdrh /* Does the table have a rowid */
1523ec95c441Sdrh #define HasRowid(X)     (((X)->tabFlags & TF_WithoutRowid)==0)
1524ec95c441Sdrh 
15254cbdda9eSdrh /*
1526c2eef3b3Sdrh ** Each foreign key constraint is an instance of the following structure.
1527c2eef3b3Sdrh **
1528c2eef3b3Sdrh ** A foreign key is associated with two tables.  The "from" table is
1529c2eef3b3Sdrh ** the table that contains the REFERENCES clause that creates the foreign
1530c2eef3b3Sdrh ** key.  The "to" table is the table that is named in the REFERENCES clause.
1531c2eef3b3Sdrh ** Consider this example:
1532c2eef3b3Sdrh **
1533c2eef3b3Sdrh **     CREATE TABLE ex1(
1534c2eef3b3Sdrh **       a INTEGER PRIMARY KEY,
1535c2eef3b3Sdrh **       b INTEGER CONSTRAINT fk1 REFERENCES ex2(x)
1536c2eef3b3Sdrh **     );
1537c2eef3b3Sdrh **
1538c2eef3b3Sdrh ** For foreign key "fk1", the from-table is "ex1" and the to-table is "ex2".
1539bd50a926Sdrh ** Equivalent names:
1540bd50a926Sdrh **
1541bd50a926Sdrh **     from-table == child-table
1542bd50a926Sdrh **       to-table == parent-table
1543c2eef3b3Sdrh **
1544c2eef3b3Sdrh ** Each REFERENCES clause generates an instance of the following structure
1545c2eef3b3Sdrh ** which is attached to the from-table.  The to-table need not exist when
1546e61922a6Sdrh ** the from-table is created.  The existence of the to-table is not checked.
1547bd50a926Sdrh **
1548bd50a926Sdrh ** The list of all parents for child Table X is held at X.pFKey.
1549bd50a926Sdrh **
1550bd50a926Sdrh ** A list of all children for a table named Z (which might not even exist)
1551bd50a926Sdrh ** is held in Schema.fkeyHash with a hash key of Z.
1552c2eef3b3Sdrh */
1553c2eef3b3Sdrh struct FKey {
15541f638cebSdrh   Table *pFrom;     /* Table containing the REFERENCES clause (aka: Child) */
1555bd50a926Sdrh   FKey *pNextFrom;  /* Next FKey with the same in pFrom. Next parent of pFrom */
15561f638cebSdrh   char *zTo;        /* Name of table that the key points to (aka: Parent) */
1557bd50a926Sdrh   FKey *pNextTo;    /* Next with the same zTo. Next child of zTo. */
1558bd50a926Sdrh   FKey *pPrevTo;    /* Previous with the same zTo */
1559c2eef3b3Sdrh   int nCol;         /* Number of columns in this key */
15604c429839Sdrh   /* EV: R-30323-21917 */
1561c2eef3b3Sdrh   u8 isDeferred;       /* True if constraint checking is deferred till COMMIT */
15628099ce6fSdan   u8 aAction[2];        /* ON DELETE and ON UPDATE actions, respectively */
15638099ce6fSdan   Trigger *apTrigger[2];/* Triggers for aAction[] actions */
1564e61922a6Sdrh   struct sColMap {      /* Mapping of columns in pFrom to columns in zTo */
1565e61922a6Sdrh     int iFrom;            /* Index of column in pFrom */
1566bd50a926Sdrh     char *zCol;           /* Name of column in zTo.  If NULL use PRIMARY KEY */
1567e61922a6Sdrh   } aCol[1];            /* One entry for each of nCol columns */
1568c2eef3b3Sdrh };
1569c2eef3b3Sdrh 
1570c2eef3b3Sdrh /*
1571aaa40c1cSdanielk1977 ** SQLite supports many different ways to resolve a constraint
157222f70c32Sdrh ** error.  ROLLBACK processing means that a constraint violation
15730bd1f4eaSdrh ** causes the operation in process to fail and for the current transaction
15741c92853dSdrh ** to be rolled back.  ABORT processing means the operation in process
15751c92853dSdrh ** fails and any prior changes from that one operation are backed out,
15761c92853dSdrh ** but the transaction is not rolled back.  FAIL processing means that
15771c92853dSdrh ** the operation in progress stops and returns an error code.  But prior
15781c92853dSdrh ** changes due to the same operation are not backed out and no rollback
15791c92853dSdrh ** occurs.  IGNORE means that the particular row that caused the constraint
15801c92853dSdrh ** error is not inserted or updated.  Processing continues and no error
15811c92853dSdrh ** is returned.  REPLACE means that preexisting database rows that caused
15821c92853dSdrh ** a UNIQUE constraint violation are removed so that the new insert or
15831c92853dSdrh ** update can proceed.  Processing continues and no error is reported.
15841c92853dSdrh **
1585c2eef3b3Sdrh ** RESTRICT, SETNULL, and CASCADE actions apply only to foreign keys.
1586c2eef3b3Sdrh ** RESTRICT is the same as ABORT for IMMEDIATE foreign keys and the
1587c2eef3b3Sdrh ** same as ROLLBACK for DEFERRED keys.  SETNULL means that the foreign
1588c2eef3b3Sdrh ** key is set to NULL.  CASCADE means that a DELETE or UPDATE of the
1589c2eef3b3Sdrh ** referenced table row is propagated into the row that holds the
1590c2eef3b3Sdrh ** foreign key.
1591c2eef3b3Sdrh **
1592968af52aSdrh ** The following symbolic values are used to record which type
15931c92853dSdrh ** of action to take.
15949cfcf5d4Sdrh */
15959cfcf5d4Sdrh #define OE_None     0   /* There is no constraint to check */
15961c92853dSdrh #define OE_Rollback 1   /* Fail the operation and rollback the transaction */
15971c92853dSdrh #define OE_Abort    2   /* Back out changes but do no rollback transaction */
15981c92853dSdrh #define OE_Fail     3   /* Stop the operation but leave all prior changes */
15991c92853dSdrh #define OE_Ignore   4   /* Ignore the error. Do not do the INSERT or UPDATE */
16001c92853dSdrh #define OE_Replace  5   /* Delete existing record, then do INSERT or UPDATE */
1601c2eef3b3Sdrh 
1602c2eef3b3Sdrh #define OE_Restrict 6   /* OE_Abort for IMMEDIATE, OE_Rollback for DEFERRED */
1603c2eef3b3Sdrh #define OE_SetNull  7   /* Set the foreign key value to NULL */
1604c2eef3b3Sdrh #define OE_SetDflt  8   /* Set the foreign key value to its default */
1605c2eef3b3Sdrh #define OE_Cascade  9   /* Cascade the changes */
1606c2eef3b3Sdrh 
1607c28c4e50Sdrh #define OE_Default  10  /* Do whatever the default action is */
16089cfcf5d4Sdrh 
1609d3d39e93Sdrh 
1610d3d39e93Sdrh /*
1611d3d39e93Sdrh ** An instance of the following structure is passed as the first
1612d3d39e93Sdrh ** argument to sqlite3VdbeKeyCompare and is used to control the
1613d3d39e93Sdrh ** comparison of the two index keys.
1614323df790Sdrh **
1615323df790Sdrh ** Note that aSortOrder[] and aColl[] have nField+1 slots.  There
1616323df790Sdrh ** are nField slots for the columns of an index then one extra slot
1617323df790Sdrh ** for the rowid at the end.
1618d3d39e93Sdrh */
1619d3d39e93Sdrh struct KeyInfo {
16202ec2fb22Sdrh   u32 nRef;           /* Number of references to this KeyInfo object */
16219b8d0272Sdrh   u8 enc;             /* Text encoding - one of the SQLITE_UTF* values */
1622ad124329Sdrh   u16 nField;         /* Number of key columns in the index */
1623ad124329Sdrh   u16 nXField;        /* Number of columns beyond the key columns */
16242ec2fb22Sdrh   sqlite3 *db;        /* The database connection */
1625323df790Sdrh   u8 *aSortOrder;     /* Sort order for each column. */
1626d3d39e93Sdrh   CollSeq *aColl[1];  /* Collating sequence for each term of the key */
1627d3d39e93Sdrh };
1628d3d39e93Sdrh 
16299cfcf5d4Sdrh /*
1630e63d9991Sdrh ** An instance of the following structure holds information about a
1631e63d9991Sdrh ** single index record that has already been parsed out into individual
1632e63d9991Sdrh ** values.
1633e63d9991Sdrh **
1634e63d9991Sdrh ** A record is an object that contains one or more fields of data.
1635e63d9991Sdrh ** Records are used to store the content of a table row and to store
1636e63d9991Sdrh ** the key of an index.  A blob encoding of a record is created by
1637467bcf36Sshane ** the OP_MakeRecord opcode of the VDBE and is disassembled by the
1638e63d9991Sdrh ** OP_Column opcode.
1639e63d9991Sdrh **
1640e63d9991Sdrh ** This structure holds a record that has already been disassembled
1641467bcf36Sshane ** into its constituent fields.
16423833e934Sdan **
16433833e934Sdan ** The r1 and r2 member variables are only used by the optimized comparison
16443833e934Sdan ** functions vdbeRecordCompareInt() and vdbeRecordCompareString().
1645e63d9991Sdrh */
1646e63d9991Sdrh struct UnpackedRecord {
1647e63d9991Sdrh   KeyInfo *pKeyInfo;  /* Collation and sort-order information */
1648e63d9991Sdrh   u16 nField;         /* Number of entries in apMem[] */
1649a9e0aeb5Sdrh   i8 default_rc;      /* Comparison result if keys are equal */
1650a1f7c0a2Sdrh   u8 isCorrupt;       /* Corruption detected by xRecordCompare() */
1651e63d9991Sdrh   Mem *aMem;          /* Values */
16523833e934Sdan   int r1;             /* Value to return if (lhs > rhs) */
16533833e934Sdan   int r2;             /* Value to return if (rhs < lhs) */
1654e63d9991Sdrh };
1655e63d9991Sdrh 
1656e63d9991Sdrh 
1657e63d9991Sdrh /*
165866b89c8fSdrh ** Each SQL index is represented in memory by an
165975897234Sdrh ** instance of the following structure.
1660967e8b73Sdrh **
1661967e8b73Sdrh ** The columns of the table that are to be indexed are described
1662967e8b73Sdrh ** by the aiColumn[] field of this structure.  For example, suppose
1663967e8b73Sdrh ** we have the following table and index:
1664967e8b73Sdrh **
1665967e8b73Sdrh **     CREATE TABLE Ex1(c1 int, c2 int, c3 text);
1666967e8b73Sdrh **     CREATE INDEX Ex2 ON Ex1(c3,c1);
1667967e8b73Sdrh **
1668967e8b73Sdrh ** In the Table structure describing Ex1, nCol==3 because there are
1669967e8b73Sdrh ** three columns in the table.  In the Index structure describing
1670967e8b73Sdrh ** Ex2, nColumn==2 since 2 of the 3 columns of Ex1 are indexed.
1671967e8b73Sdrh ** The value of aiColumn is {2, 0}.  aiColumn[0]==2 because the
1672967e8b73Sdrh ** first column to be indexed (c3) has an index of 2 in Ex1.aCol[].
1673967e8b73Sdrh ** The second column to be indexed (c1) has an index of 0 in
1674967e8b73Sdrh ** Ex1.aCol[], hence Ex2.aiColumn[1]==0.
1675ea1ba17cSdrh **
1676ea1ba17cSdrh ** The Index.onError field determines whether or not the indexed columns
1677ea1ba17cSdrh ** must be unique and what to do if they are not.  When Index.onError=OE_None,
1678ea1ba17cSdrh ** it means this is not a unique index.  Otherwise it is a unique index
1679ea1ba17cSdrh ** and the value of Index.onError indicate the which conflict resolution
1680ea1ba17cSdrh ** algorithm to employ whenever an attempt is made to insert a non-unique
1681ea1ba17cSdrh ** element.
168275897234Sdrh */
168375897234Sdrh struct Index {
168475897234Sdrh   char *zName;             /* Name of this index */
1685bbbdc83bSdrh   i16 *aiColumn;           /* Which columns are used by this index.  1st is 0 */
1686cfc9df76Sdan   LogEst *aiRowLogEst;     /* From ANALYZE: Est. rows selected by each column */
1687967e8b73Sdrh   Table *pTable;           /* The SQL table being indexed */
1688a37cdde0Sdanielk1977   char *zColAff;           /* String defining the affinity of each column */
168975897234Sdrh   Index *pNext;            /* The next index associated with the same table */
1690b3bf556eSdanielk1977   Schema *pSchema;         /* Schema containing this index */
1691b376daebSdrh   u8 *aSortOrder;          /* for each column: True==DESC, False==ASC */
1692b3bf556eSdanielk1977   char **azColl;           /* Array of collation sequence names for index */
16931fe0537eSdrh   Expr *pPartIdxWhere;     /* WHERE clause for partial indices */
16942ec2fb22Sdrh   KeyInfo *pKeyInfo;       /* A KeyInfo object suitable for this index */
1695b376daebSdrh   int tnum;                /* DB Page containing root of this index */
1696bf539c4dSdrh   LogEst szIdxRow;         /* Estimated average row size in bytes */
1697bbbdc83bSdrh   u16 nKeyCol;             /* Number of columns forming the key */
1698bbbdc83bSdrh   u16 nColumn;             /* Number of columns stored in the index */
1699bf539c4dSdrh   u8 onError;              /* OE_Abort, OE_Ignore, OE_Replace, or OE_None */
170048dd1d8eSdrh   unsigned idxType:2;      /* 1==UNIQUE, 2==PRIMARY KEY, 0==CREATE INDEX */
1701b376daebSdrh   unsigned bUnordered:1;   /* Use this index for == or IN queries only */
17027699d1c4Sdrh   unsigned uniqNotNull:1;  /* True if UNIQUE and NOT NULL for all columns */
17037f9c5dbfSdrh   unsigned isResized:1;    /* True if resizeIndexObject() has been called */
1704ec95c441Sdrh   unsigned isCovering:1;   /* True if this is a covering index */
17051435a9a1Sdrh #ifdef SQLITE_ENABLE_STAT3_OR_STAT4
17062b9cf669Sdrh   int nSample;             /* Number of elements in aSample[] */
17078ad169abSdan   int nSampleCol;          /* Size of IndexSample.anEq[] and so on */
1708eea568d6Sdan   tRowcnt *aAvgEq;         /* Average nEq values for keys not in aSample */
1709faacf17cSdrh   IndexSample *aSample;    /* Samples of the left-most key */
1710faacf17cSdrh #endif
171102fa4696Sdan };
171202fa4696Sdan 
171302fa4696Sdan /*
171448dd1d8eSdrh ** Allowed values for Index.idxType
171548dd1d8eSdrh */
171648dd1d8eSdrh #define SQLITE_IDXTYPE_APPDEF      0   /* Created using CREATE INDEX */
171748dd1d8eSdrh #define SQLITE_IDXTYPE_UNIQUE      1   /* Implements a UNIQUE constraint */
171848dd1d8eSdrh #define SQLITE_IDXTYPE_PRIMARYKEY  2   /* Is the PRIMARY KEY for the table */
171948dd1d8eSdrh 
172048dd1d8eSdrh /* Return true if index X is a PRIMARY KEY index */
172148dd1d8eSdrh #define IsPrimaryKeyIndex(X)  ((X)->idxType==SQLITE_IDXTYPE_PRIMARYKEY)
172248dd1d8eSdrh 
17235f1d1d9cSdrh /* Return true if index X is a UNIQUE index */
17245f1d1d9cSdrh #define IsUniqueIndex(X)      ((X)->onError!=OE_None)
17255f1d1d9cSdrh 
172648dd1d8eSdrh /*
172774e7c8f5Sdrh ** Each sample stored in the sqlite_stat3 table is represented in memory
172874e7c8f5Sdrh ** using a structure of this type.  See documentation at the top of the
172974e7c8f5Sdrh ** analyze.c source file for additional information.
173002fa4696Sdan */
173102fa4696Sdan struct IndexSample {
1732f52bb8d3Sdan   void *p;          /* Pointer to sampled record */
1733f52bb8d3Sdan   int n;            /* Size of record in bytes */
1734f52bb8d3Sdan   tRowcnt *anEq;    /* Est. number of rows where the key equals this sample */
1735f52bb8d3Sdan   tRowcnt *anLt;    /* Est. number of rows where key is less than this sample */
1736f52bb8d3Sdan   tRowcnt *anDLt;   /* Est. number of distinct keys less than this sample */
173775897234Sdrh };
173875897234Sdrh 
173975897234Sdrh /*
174075897234Sdrh ** Each token coming out of the lexer is an instance of
17414b59ab5eSdrh ** this structure.  Tokens are also used as part of an expression.
17424efc4754Sdrh **
17434efc4754Sdrh ** Note if Token.z==0 then Token.dyn and Token.n are undefined and
1744467bcf36Sshane ** may contain random values.  Do not make any assumptions about Token.dyn
17454efc4754Sdrh ** and Token.n when Token.z==0.
174675897234Sdrh */
174775897234Sdrh struct Token {
1748b7916a78Sdrh   const char *z;     /* Text of the token.  Not NULL-terminated! */
1749b7916a78Sdrh   unsigned int n;    /* Number of characters in this token */
175075897234Sdrh };
175175897234Sdrh 
175275897234Sdrh /*
175313449892Sdrh ** An instance of this structure contains information needed to generate
175413449892Sdrh ** code for a SELECT that contains aggregate functions.
175513449892Sdrh **
175613449892Sdrh ** If Expr.op==TK_AGG_COLUMN or TK_AGG_FUNCTION then Expr.pAggInfo is a
175713449892Sdrh ** pointer to this structure.  The Expr.iColumn field is the index in
175813449892Sdrh ** AggInfo.aCol[] or AggInfo.aFunc[] of information needed to generate
175913449892Sdrh ** code for that node.
176013449892Sdrh **
176113449892Sdrh ** AggInfo.pGroupBy and AggInfo.aFunc.pExpr point to fields within the
176213449892Sdrh ** original Select structure that describes the SELECT statement.  These
176313449892Sdrh ** fields do not need to be freed when deallocating the AggInfo structure.
176413449892Sdrh */
176513449892Sdrh struct AggInfo {
176613449892Sdrh   u8 directMode;          /* Direct rendering mode means take data directly
176713449892Sdrh                           ** from source tables rather than from accumulators */
176813449892Sdrh   u8 useSortingIdx;       /* In direct mode, reference the sorting index rather
176913449892Sdrh                           ** than the source table */
177013449892Sdrh   int sortingIdx;         /* Cursor number of the sorting index */
17715134d135Sdan   int sortingIdxPTab;     /* Cursor number of pseudo-table */
177213449892Sdrh   int nSortingColumn;     /* Number of columns in the sorting index */
17737e61d18eSdrh   int mnReg, mxReg;       /* Range of registers allocated for aCol and aFunc */
1774a451017dSdrh   ExprList *pGroupBy;     /* The group by clause */
177513449892Sdrh   struct AggInfo_col {    /* For each column used in source tables */
17760817d0dfSdanielk1977     Table *pTab;             /* Source table */
177713449892Sdrh     int iTable;              /* Cursor number of the source table */
177813449892Sdrh     int iColumn;             /* Column number within the source table */
177913449892Sdrh     int iSorterColumn;       /* Column number in the sorting index */
178013449892Sdrh     int iMem;                /* Memory location that acts as accumulator */
17815774b806Sdrh     Expr *pExpr;             /* The original expression */
178213449892Sdrh   } *aCol;
178313449892Sdrh   int nColumn;            /* Number of used entries in aCol[] */
178413449892Sdrh   int nAccumulator;       /* Number of columns that show through to the output.
178513449892Sdrh                           ** Additional columns are used only as parameters to
178613449892Sdrh                           ** aggregate functions */
178713449892Sdrh   struct AggInfo_func {   /* For each aggregate function */
178813449892Sdrh     Expr *pExpr;             /* Expression encoding the function */
178913449892Sdrh     FuncDef *pFunc;          /* The aggregate function implementation */
179013449892Sdrh     int iMem;                /* Memory location that acts as accumulator */
1791467bcf36Sshane     int iDistinct;           /* Ephemeral table used to enforce DISTINCT */
179213449892Sdrh   } *aFunc;
179313449892Sdrh   int nFunc;              /* Number of entries in aFunc[] */
179413449892Sdrh };
179513449892Sdrh 
179613449892Sdrh /*
17978677d308Sdrh ** The datatype ynVar is a signed integer, either 16-bit or 32-bit.
17988677d308Sdrh ** Usually it is 16-bits.  But if SQLITE_MAX_VARIABLE_NUMBER is greater
17998677d308Sdrh ** than 32767 we have to make it 32-bit.  16-bit is preferred because
18008677d308Sdrh ** it uses less memory in the Expr object, which is a big memory user
18018677d308Sdrh ** in systems with lots of prepared statements.  And few applications
18028677d308Sdrh ** need more than about 10 or 20 variables.  But some extreme users want
18038677d308Sdrh ** to have prepared statements with over 32767 variables, and for them
18048677d308Sdrh ** the option is available (at compile-time).
18058677d308Sdrh */
18068677d308Sdrh #if SQLITE_MAX_VARIABLE_NUMBER<=32767
1807481aa74eSdrh typedef i16 ynVar;
18088677d308Sdrh #else
18098677d308Sdrh typedef int ynVar;
18108677d308Sdrh #endif
18118677d308Sdrh 
18128677d308Sdrh /*
181375897234Sdrh ** Each node of an expression in the parse tree is an instance
181422f70c32Sdrh ** of this structure.
181522f70c32Sdrh **
181622f70c32Sdrh ** Expr.op is the opcode. The integer parser token codes are reused
181722f70c32Sdrh ** as opcodes here. For example, the parser defines TK_GE to be an integer
181822f70c32Sdrh ** code representing the ">=" operator. This same integer code is reused
181922f70c32Sdrh ** to represent the greater-than-or-equal-to operator in the expression
182022f70c32Sdrh ** tree.
182122f70c32Sdrh **
18226ab3a2ecSdanielk1977 ** If the expression is an SQL literal (TK_INTEGER, TK_FLOAT, TK_BLOB,
18236ab3a2ecSdanielk1977 ** or TK_STRING), then Expr.token contains the text of the SQL literal. If
18246ab3a2ecSdanielk1977 ** the expression is a variable (TK_VARIABLE), then Expr.token contains the
18256ab3a2ecSdanielk1977 ** variable name. Finally, if the expression is an SQL function (TK_FUNCTION),
18266ab3a2ecSdanielk1977 ** then Expr.token contains the name of the function.
182722f70c32Sdrh **
18286ab3a2ecSdanielk1977 ** Expr.pRight and Expr.pLeft are the left and right subexpressions of a
18296ab3a2ecSdanielk1977 ** binary operator. Either or both may be NULL.
18306ab3a2ecSdanielk1977 **
18316ab3a2ecSdanielk1977 ** Expr.x.pList is a list of arguments if the expression is an SQL function,
18326ab3a2ecSdanielk1977 ** a CASE expression or an IN expression of the form "<lhs> IN (<y>, <z>...)".
18336ab3a2ecSdanielk1977 ** Expr.x.pSelect is used if the expression is a sub-select or an expression of
18346ab3a2ecSdanielk1977 ** the form "<lhs> IN (SELECT ...)". If the EP_xIsSelect bit is set in the
18356ab3a2ecSdanielk1977 ** Expr.flags mask, then Expr.x.pSelect is valid. Otherwise, Expr.x.pList is
18366ab3a2ecSdanielk1977 ** valid.
183722f70c32Sdrh **
183822f70c32Sdrh ** An expression of the form ID or ID.ID refers to a column in a table.
183922f70c32Sdrh ** For such expressions, Expr.op is set to TK_COLUMN and Expr.iTable is
184022f70c32Sdrh ** the integer cursor number of a VDBE cursor pointing to that table and
184122f70c32Sdrh ** Expr.iColumn is the column number for the specific column.  If the
184222f70c32Sdrh ** expression is used as a result in an aggregate SELECT, then the
184322f70c32Sdrh ** value is also stored in the Expr.iAgg column in the aggregate so that
184422f70c32Sdrh ** it can be accessed after all aggregates are computed.
184522f70c32Sdrh **
18466ab3a2ecSdanielk1977 ** If the expression is an unbound variable marker (a question mark
18476ab3a2ecSdanielk1977 ** character '?' in the original SQL) then the Expr.iTable holds the index
18486ab3a2ecSdanielk1977 ** number for that variable.
184922f70c32Sdrh **
18501398ad36Sdrh ** If the expression is a subquery then Expr.iColumn holds an integer
18511398ad36Sdrh ** register number containing the result of the subquery.  If the
18521398ad36Sdrh ** subquery gives a constant result, then iTable is -1.  If the subquery
18531398ad36Sdrh ** gives a different answer at different times during statement processing
18541398ad36Sdrh ** then iTable is the address of a subroutine that computes the subquery.
18551398ad36Sdrh **
1856aee18ef8Sdanielk1977 ** If the Expr is of type OP_Column, and the table it is selecting from
1857aee18ef8Sdanielk1977 ** is a disk table or the "old.*" pseudo-table, then pTab points to the
1858aee18ef8Sdanielk1977 ** corresponding table definition.
18596ab3a2ecSdanielk1977 **
18606ab3a2ecSdanielk1977 ** ALLOCATION NOTES:
18616ab3a2ecSdanielk1977 **
186212ffee8cSdrh ** Expr objects can use a lot of memory space in database schema.  To
186312ffee8cSdrh ** help reduce memory requirements, sometimes an Expr object will be
186412ffee8cSdrh ** truncated.  And to reduce the number of memory allocations, sometimes
186512ffee8cSdrh ** two or more Expr objects will be stored in a single memory allocation,
186633e619fcSdrh ** together with Expr.zToken strings.
18676ab3a2ecSdanielk1977 **
1868b7916a78Sdrh ** If the EP_Reduced and EP_TokenOnly flags are set when
186912ffee8cSdrh ** an Expr object is truncated.  When EP_Reduced is set, then all
187012ffee8cSdrh ** the child Expr objects in the Expr.pLeft and Expr.pRight subtrees
187112ffee8cSdrh ** are contained within the same memory allocation.  Note, however, that
187212ffee8cSdrh ** the subtrees in Expr.x.pList or Expr.x.pSelect are always separately
187312ffee8cSdrh ** allocated, regardless of whether or not EP_Reduced is set.
187475897234Sdrh */
187575897234Sdrh struct Expr {
18761cc093c2Sdrh   u8 op;                 /* Operation performed by this node */
1877a9fd84b0Sdrh   char affinity;         /* The affinity of the column or 0 if not a column */
1878c5cd1249Sdrh   u32 flags;             /* Various flags.  EP_* See below */
187933e619fcSdrh   union {
1880b7916a78Sdrh     char *zToken;          /* Token value. Zero terminated and dequoted */
1881d50ffc41Sdrh     int iValue;            /* Non-negative integer value if EP_IntValue */
188233e619fcSdrh   } u;
18836ab3a2ecSdanielk1977 
18846ab3a2ecSdanielk1977   /* If the EP_TokenOnly flag is set in the Expr.flags mask, then no
18856ab3a2ecSdanielk1977   ** space is allocated for the fields below this point. An attempt to
18866ab3a2ecSdanielk1977   ** access them will result in a segfault or malfunction.
18876ab3a2ecSdanielk1977   *********************************************************************/
18886ab3a2ecSdanielk1977 
18896ab3a2ecSdanielk1977   Expr *pLeft;           /* Left subnode */
18906ab3a2ecSdanielk1977   Expr *pRight;          /* Right subnode */
18916ab3a2ecSdanielk1977   union {
1892c5cd1249Sdrh     ExprList *pList;     /* op = IN, EXISTS, SELECT, CASE, FUNCTION, BETWEEN */
1893c5cd1249Sdrh     Select *pSelect;     /* EP_xIsSelect and op = IN, EXISTS, SELECT */
18946ab3a2ecSdanielk1977   } x;
18956ab3a2ecSdanielk1977 
18966ab3a2ecSdanielk1977   /* If the EP_Reduced flag is set in the Expr.flags mask, then no
18976ab3a2ecSdanielk1977   ** space is allocated for the fields below this point. An attempt to
18986ab3a2ecSdanielk1977   ** access them will result in a segfault or malfunction.
18996ab3a2ecSdanielk1977   *********************************************************************/
19006ab3a2ecSdanielk1977 
19016ec65491Sdrh #if SQLITE_MAX_EXPR_DEPTH>0
19026ec65491Sdrh   int nHeight;           /* Height of the tree headed by this node */
19036ec65491Sdrh #endif
1904b7916a78Sdrh   int iTable;            /* TK_COLUMN: cursor number of table holding column
19052832ad42Sdan                          ** TK_REGISTER: register number
1906cca9f3d2Sdrh                          ** TK_TRIGGER: 1 -> new, 0 -> old
1907a4c3c87eSdrh                          ** EP_Unlikely:  1000 times likelihood */
19088677d308Sdrh   ynVar iColumn;         /* TK_COLUMN: column index.  -1 for rowid.
1909937d0deaSdan                          ** TK_VARIABLE: variable number (always >= 1). */
1910b7916a78Sdrh   i16 iAgg;              /* Which entry in pAggInfo->aCol[] or ->aFunc[] */
1911b7916a78Sdrh   i16 iRightJoinTable;   /* If EP_FromJoin, the right table of the join */
1912030796dfSdrh   u8 op2;                /* TK_REGISTER: original value of Expr.op
1913030796dfSdrh                          ** TK_COLUMN: the value of p5 for OP_Column
1914030796dfSdrh                          ** TK_AGG_FUNCTION: nesting depth */
191513449892Sdrh   AggInfo *pAggInfo;     /* Used by TK_AGG_COLUMN and TK_AGG_FUNCTION */
19167d10d5a6Sdrh   Table *pTab;           /* Table for TK_COLUMN expressions. */
191775897234Sdrh };
191875897234Sdrh 
191975897234Sdrh /*
19201f16230bSdrh ** The following are the meanings of bits in the Expr.flags field.
19211f16230bSdrh */
1922c5cd1249Sdrh #define EP_FromJoin  0x000001 /* Originated in ON or USING clause of a join */
1923c5cd1249Sdrh #define EP_Agg       0x000002 /* Contains one or more aggregate functions */
1924c5cd1249Sdrh #define EP_Resolved  0x000004 /* IDs have been resolved to COLUMNs */
1925c5cd1249Sdrh #define EP_Error     0x000008 /* Expression contains one or more errors */
1926c5cd1249Sdrh #define EP_Distinct  0x000010 /* Aggregate function with DISTINCT keyword */
1927c5cd1249Sdrh #define EP_VarSelect 0x000020 /* pSelect is correlated, not constant */
1928c5cd1249Sdrh #define EP_DblQuoted 0x000040 /* token.z was originally in "..." */
1929c5cd1249Sdrh #define EP_InfixFunc 0x000080 /* True for an infix function: LIKE, GLOB, etc */
1930fbb24d10Sdrh #define EP_Collate   0x000100 /* Tree contains a TK_COLLATE operator */
1931fbb24d10Sdrh #define EP_Generic   0x000200 /* Ignore COLLATE or affinity on this tree */
1932c5cd1249Sdrh #define EP_IntValue  0x000400 /* Integer value contained in u.iValue */
1933c5cd1249Sdrh #define EP_xIsSelect 0x000800 /* x.pSelect is valid (otherwise x.pList is) */
1934a4c3c87eSdrh #define EP_Skip      0x001000 /* COLLATE, AS, or UNLIKELY */
1935c5cd1249Sdrh #define EP_Reduced   0x002000 /* Expr struct EXPR_REDUCEDSIZE bytes only */
1936c5cd1249Sdrh #define EP_TokenOnly 0x004000 /* Expr struct EXPR_TOKENONLYSIZE bytes only */
1937c5cd1249Sdrh #define EP_Static    0x008000 /* Held in memory not obtained from malloc() */
1938c5cd1249Sdrh #define EP_MemToken  0x010000 /* Need to sqlite3DbFree() Expr.zToken */
1939ebb6a65dSdrh #define EP_NoReduce  0x020000 /* Cannot EXPRDUP_REDUCE this Expr */
1940a4c3c87eSdrh #define EP_Unlikely  0x040000 /* unlikely() or likelihood() function */
1941b1fba286Sdrh #define EP_Constant  0x080000 /* Node is a constant */
194233e619fcSdrh 
194333e619fcSdrh /*
19441f16230bSdrh ** These macros can be used to test, set, or clear bits in the
19451f16230bSdrh ** Expr.flags field.
19461f16230bSdrh */
1947c5cd1249Sdrh #define ExprHasProperty(E,P)     (((E)->flags&(P))!=0)
1948c5cd1249Sdrh #define ExprHasAllProperty(E,P)  (((E)->flags&(P))==(P))
19491f16230bSdrh #define ExprSetProperty(E,P)     (E)->flags|=(P)
19501f16230bSdrh #define ExprClearProperty(E,P)   (E)->flags&=~(P)
19511f16230bSdrh 
1952ebb6a65dSdrh /* The ExprSetVVAProperty() macro is used for Verification, Validation,
1953ebb6a65dSdrh ** and Accreditation only.  It works like ExprSetProperty() during VVA
1954ebb6a65dSdrh ** processes but is a no-op for delivery.
1955ebb6a65dSdrh */
1956ebb6a65dSdrh #ifdef SQLITE_DEBUG
1957ebb6a65dSdrh # define ExprSetVVAProperty(E,P)  (E)->flags|=(P)
1958ebb6a65dSdrh #else
1959ebb6a65dSdrh # define ExprSetVVAProperty(E,P)
1960ebb6a65dSdrh #endif
1961ebb6a65dSdrh 
19621f16230bSdrh /*
19636ab3a2ecSdanielk1977 ** Macros to determine the number of bytes required by a normal Expr
19646ab3a2ecSdanielk1977 ** struct, an Expr struct with the EP_Reduced flag set in Expr.flags
19656ab3a2ecSdanielk1977 ** and an Expr struct with the EP_TokenOnly flag set.
19666ab3a2ecSdanielk1977 */
196712ffee8cSdrh #define EXPR_FULLSIZE           sizeof(Expr)           /* Full size */
196812ffee8cSdrh #define EXPR_REDUCEDSIZE        offsetof(Expr,iTable)  /* Common features */
1969b7916a78Sdrh #define EXPR_TOKENONLYSIZE      offsetof(Expr,pLeft)   /* Fewer features */
19706ab3a2ecSdanielk1977 
19716ab3a2ecSdanielk1977 /*
19726ab3a2ecSdanielk1977 ** Flags passed to the sqlite3ExprDup() function. See the header comment
19736ab3a2ecSdanielk1977 ** above sqlite3ExprDup() for details.
19746ab3a2ecSdanielk1977 */
197512ffee8cSdrh #define EXPRDUP_REDUCE         0x0001  /* Used reduced-size Expr nodes */
19766ab3a2ecSdanielk1977 
19776ab3a2ecSdanielk1977 /*
197875897234Sdrh ** A list of expressions.  Each expression may optionally have a
197975897234Sdrh ** name.  An expr/name combination can be used in several ways, such
198075897234Sdrh ** as the list of "expr AS ID" fields following a "SELECT" or in the
198175897234Sdrh ** list of "ID = expr" items in an UPDATE.  A list of expressions can
1982ad3cab52Sdrh ** also be used as the argument to a function, in which case the a.zName
198375897234Sdrh ** field is not used.
19840dde4739Sdrh **
19850dde4739Sdrh ** By default the Expr.zSpan field holds a human-readable description of
19860dde4739Sdrh ** the expression that is used in the generation of error messages and
19870dde4739Sdrh ** column labels.  In this case, Expr.zSpan is typically the text of a
19880dde4739Sdrh ** column expression as it exists in a SELECT statement.  However, if
19890dde4739Sdrh ** the bSpanIsTab flag is set, then zSpan is overloaded to mean the name
19903e3f1a5bSdrh ** of the result column in the form: DATABASE.TABLE.COLUMN.  This later
19913e3f1a5bSdrh ** form is used for name resolution with nested FROM clauses.
199275897234Sdrh */
199375897234Sdrh struct ExprList {
199475897234Sdrh   int nExpr;             /* Number of expressions on the list */
1995d872bb18Sdrh   struct ExprList_item { /* For each expression in the list */
199675897234Sdrh     Expr *pExpr;            /* The list of expressions */
199775897234Sdrh     char *zName;            /* Token associated with this expression */
1998b7916a78Sdrh     char *zSpan;            /* Original text of the expression */
19998e2ca029Sdrh     u8 sortOrder;           /* 1 for DESC or 0 for ASC */
20000dde4739Sdrh     unsigned done :1;       /* A flag to indicate when processing is finished */
20013e3f1a5bSdrh     unsigned bSpanIsTab :1; /* zSpan holds DB.TABLE.COLUMN */
2002d673cddaSdrh     unsigned reusable :1;   /* Constant expression is reusable */
2003c2acc4e4Sdrh     union {
2004c2acc4e4Sdrh       struct {
20054b3ac73cSdrh         u16 iOrderByCol;      /* For ORDER BY, column number in result set */
20068b213899Sdrh         u16 iAlias;           /* Index into Parse.aAlias[] for zName */
2007c2acc4e4Sdrh       } x;
2008c2acc4e4Sdrh       int iConstExprReg;      /* Register in which Expr value is cached */
2009c2acc4e4Sdrh     } u;
2010d872bb18Sdrh   } *a;                  /* Alloc a power of two greater or equal to nExpr */
201175897234Sdrh };
201275897234Sdrh 
201375897234Sdrh /*
2014b7916a78Sdrh ** An instance of this structure is used by the parser to record both
2015b7916a78Sdrh ** the parse tree for an expression and the span of input text for an
2016b7916a78Sdrh ** expression.
2017b7916a78Sdrh */
2018b7916a78Sdrh struct ExprSpan {
2019b7916a78Sdrh   Expr *pExpr;          /* The expression parse tree */
2020b7916a78Sdrh   const char *zStart;   /* First character of input text */
2021b7916a78Sdrh   const char *zEnd;     /* One character past the end of input text */
2022b7916a78Sdrh };
2023b7916a78Sdrh 
2024b7916a78Sdrh /*
2025ad3cab52Sdrh ** An instance of this structure can hold a simple list of identifiers,
2026ad3cab52Sdrh ** such as the list "a,b,c" in the following statements:
2027ad3cab52Sdrh **
2028ad3cab52Sdrh **      INSERT INTO t(a,b,c) VALUES ...;
2029ad3cab52Sdrh **      CREATE INDEX idx ON t(a,b,c);
2030ad3cab52Sdrh **      CREATE TRIGGER trig BEFORE UPDATE ON t(a,b,c) ...;
2031ad3cab52Sdrh **
2032ad3cab52Sdrh ** The IdList.a.idx field is used when the IdList represents the list of
2033ad3cab52Sdrh ** column names after a table name in an INSERT statement.  In the statement
2034ad3cab52Sdrh **
2035ad3cab52Sdrh **     INSERT INTO t(a,b,c) ...
2036ad3cab52Sdrh **
2037ad3cab52Sdrh ** If "a" is the k-th column of table "t", then IdList.a[0].idx==k.
203875897234Sdrh */
203975897234Sdrh struct IdList {
20406d4abfbeSdrh   struct IdList_item {
2041ad3cab52Sdrh     char *zName;      /* Name of the identifier */
2042967e8b73Sdrh     int idx;          /* Index in some Table.aCol[] of a column named zName */
2043ad3cab52Sdrh   } *a;
204413449892Sdrh   int nId;         /* Number of identifiers on the list */
2045ad3cab52Sdrh };
2046ad3cab52Sdrh 
2047ad3cab52Sdrh /*
204851669863Sdrh ** The bitmask datatype defined below is used for various optimizations.
2049ca83ac51Sdrh **
2050ca83ac51Sdrh ** Changing this from a 64-bit to a 32-bit type limits the number of
2051ca83ac51Sdrh ** tables in a join to 32 instead of 64.  But it also reduces the size
2052ca83ac51Sdrh ** of the library by 738 bytes on ix86.
205351669863Sdrh */
2054ca83ac51Sdrh typedef u64 Bitmask;
205551669863Sdrh 
205651669863Sdrh /*
205700e13613Sdanielk1977 ** The number of bits in a Bitmask.  "BMS" means "BitMask Size".
205800e13613Sdanielk1977 */
205900e13613Sdanielk1977 #define BMS  ((int)(sizeof(Bitmask)*8))
206000e13613Sdanielk1977 
206100e13613Sdanielk1977 /*
20627699d1c4Sdrh ** A bit in a Bitmask
20637699d1c4Sdrh */
20647699d1c4Sdrh #define MASKBIT(n)   (((Bitmask)1)<<(n))
2065693e6719Sdrh #define MASKBIT32(n) (((unsigned int)1)<<(n))
20667699d1c4Sdrh 
20677699d1c4Sdrh /*
2068ad3cab52Sdrh ** The following structure describes the FROM clause of a SELECT statement.
2069ad3cab52Sdrh ** Each table or subquery in the FROM clause is a separate element of
2070ad3cab52Sdrh ** the SrcList.a[] array.
2071d24cc427Sdrh **
2072d24cc427Sdrh ** With the addition of multiple database support, the following structure
2073d24cc427Sdrh ** can also be used to describe a particular table such as the table that
2074d24cc427Sdrh ** is modified by an INSERT, DELETE, or UPDATE statement.  In standard SQL,
2075d24cc427Sdrh ** such a table must be a simple name: ID.  But in SQLite, the table can
2076d24cc427Sdrh ** now be identified by a database name, a dot, then the table name: ID.ID.
2077c49de5d9Sdrh **
2078c49de5d9Sdrh ** The jointype starts out showing the join type between the current table
2079c49de5d9Sdrh ** and the next table on the list.  The parser builds the list this way.
2080c49de5d9Sdrh ** But sqlite3SrcListShiftJoinType() later shifts the jointypes so that each
2081c49de5d9Sdrh ** jointype expresses the join between the table and the previous table.
20822a6a7eebSdrh **
20832a6a7eebSdrh ** In the colUsed field, the high-order bit (bit 63) is set if the table
20842a6a7eebSdrh ** contains more than 63 columns and the 64-th or later column is used.
2085ad3cab52Sdrh */
2086ad3cab52Sdrh struct SrcList {
20876d1626ebSdrh   int nSrc;        /* Number of tables or subqueries in the FROM clause */
20886d1626ebSdrh   u32 nAlloc;      /* Number of entries allocated in a[] below */
2089ad3cab52Sdrh   struct SrcList_item {
209041fb5cd1Sdan     Schema *pSchema;  /* Schema to which this item is fixed */
2091113088ecSdrh     char *zDatabase;  /* Name of database holding this table */
2092ad3cab52Sdrh     char *zName;      /* Name of the table */
2093ad3cab52Sdrh     char *zAlias;     /* The "B" part of a "A AS B" phrase.  zName is the "A" */
2094daffd0e5Sdrh     Table *pTab;      /* An SQL table corresponding to zName */
2095daffd0e5Sdrh     Select *pSelect;  /* A SELECT statement used in place of a table name */
20965b6a9ed4Sdrh     int addrFillSub;  /* Address of subroutine to manifest a subquery */
20975b6a9ed4Sdrh     int regReturn;    /* Register holding return address of addrFillSub */
20985f612295Sdrh     int regResult;    /* Registers holding results of a co-routine */
2099c49de5d9Sdrh     u8 jointype;      /* Type of join between this able and the previous */
210021172c4cSdrh     unsigned notIndexed :1;    /* True if there is a NOT INDEXED clause */
210121172c4cSdrh     unsigned isCorrelated :1;  /* True if sub-query is correlated */
210221172c4cSdrh     unsigned viaCoroutine :1;  /* Implemented as a co-routine */
2103f43fe6e9Sdan     unsigned isRecursive :1;   /* True for recursive reference in WITH */
2104ce7e189dSdan #ifndef SQLITE_OMIT_EXPLAIN
2105ce7e189dSdan     u8 iSelectId;     /* If pSelect!=0, the id of the sub-select in EQP */
2106ce7e189dSdan #endif
2107e68fbe79Sdrh     int iCursor;      /* The VDBE cursor number used to access this table */
2108ad3cab52Sdrh     Expr *pOn;        /* The ON clause of a join */
2109ad3cab52Sdrh     IdList *pUsing;   /* The USING clause of a join */
2110cd38d520Sdanielk1977     Bitmask colUsed;  /* Bit N (1<<N) set if column N of pTab is used */
211185574e31Sdanielk1977     char *zIndex;     /* Identifier from "INDEXED BY <zIndex>" clause */
211285574e31Sdanielk1977     Index *pIndex;    /* Index structure corresponding to zIndex, if any */
2113113088ecSdrh   } a[1];             /* One entry for each identifier on the list */
211475897234Sdrh };
211575897234Sdrh 
211675897234Sdrh /*
211701f3f253Sdrh ** Permitted values of the SrcList.a.jointype field
211801f3f253Sdrh */
211901f3f253Sdrh #define JT_INNER     0x0001    /* Any kind of inner or cross join */
21203dec223cSdrh #define JT_CROSS     0x0002    /* Explicit use of the CROSS keyword */
21213dec223cSdrh #define JT_NATURAL   0x0004    /* True for a "natural" join */
21223dec223cSdrh #define JT_LEFT      0x0008    /* Left outer join */
21233dec223cSdrh #define JT_RIGHT     0x0010    /* Right outer join */
21243dec223cSdrh #define JT_OUTER     0x0020    /* The "OUTER" keyword is present */
21253dec223cSdrh #define JT_ERROR     0x0040    /* unknown or unsupported join type */
212601f3f253Sdrh 
2127111a6a7dSdrh 
2128111a6a7dSdrh /*
2129336a5300Sdrh ** Flags appropriate for the wctrlFlags parameter of sqlite3WhereBegin()
2130336a5300Sdrh ** and the WhereInfo.wctrlFlags member.
213108c88eb0Sdrh */
21326df2acd2Sdrh #define WHERE_ORDERBY_NORMAL   0x0000 /* No-op */
21336df2acd2Sdrh #define WHERE_ORDERBY_MIN      0x0001 /* ORDER BY processing for min() func */
21346df2acd2Sdrh #define WHERE_ORDERBY_MAX      0x0002 /* ORDER BY processing for max() func */
21356df2acd2Sdrh #define WHERE_ONEPASS_DESIRED  0x0004 /* Want to do one-pass UPDATE/DELETE */
2136336a5300Sdrh #define WHERE_DUPLICATES_OK    0x0008 /* Ok to return a row more than once */
21379ef61f4fSdrh #define WHERE_OMIT_OPEN_CLOSE  0x0010 /* Table cursors are already open */
21389ef61f4fSdrh #define WHERE_FORCE_TABLE      0x0020 /* Do not use an index-only search */
21399ef61f4fSdrh #define WHERE_ONETABLE_ONLY    0x0040 /* Only code the 1st table in pTabList */
21409ef61f4fSdrh #define WHERE_AND_ONLY         0x0080 /* Don't use indices for OR terms */
2141319f677dSdrh #define WHERE_GROUPBY          0x0100 /* pOrderBy is really a GROUP BY */
21424f402f26Sdrh #define WHERE_DISTINCTBY       0x0200 /* pOrderby is really a DISTINCT clause */
21436457a353Sdrh #define WHERE_WANT_DISTINCT    0x0400 /* All output needs to be distinct */
2144374cd78cSdan #define WHERE_SORTBYGROUP      0x0800 /* Support sqlite3WhereIsSorted() */
21453526319bSdrh #define WHERE_REOPEN_IDX       0x1000 /* Try to use OP_ReopenIdx */
2146a9d1ccb9Sdanielk1977 
21474f402f26Sdrh /* Allowed return values from sqlite3WhereIsDistinct()
21484f402f26Sdrh */
2149e8e4af76Sdrh #define WHERE_DISTINCT_NOOP      0  /* DISTINCT keyword not used */
2150ae651d61Sdrh #define WHERE_DISTINCT_UNIQUE    1  /* No duplicates */
2151ae651d61Sdrh #define WHERE_DISTINCT_ORDERED   2  /* All duplicates are adjacent */
2152e8e4af76Sdrh #define WHERE_DISTINCT_UNORDERED 3  /* Duplicates are scattered */
215338cc40c2Sdan 
215475897234Sdrh /*
2155b3bce662Sdanielk1977 ** A NameContext defines a context in which to resolve table and column
2156b3bce662Sdanielk1977 ** names.  The context consists of a list of tables (the pSrcList) field and
2157b3bce662Sdanielk1977 ** a list of named expression (pEList).  The named expression list may
2158b3bce662Sdanielk1977 ** be NULL.  The pSrc corresponds to the FROM clause of a SELECT or
2159b3bce662Sdanielk1977 ** to the table being operated on by INSERT, UPDATE, or DELETE.  The
2160b3bce662Sdanielk1977 ** pEList corresponds to the result set of a SELECT and is NULL for
2161b3bce662Sdanielk1977 ** other statements.
2162b3bce662Sdanielk1977 **
2163b3bce662Sdanielk1977 ** NameContexts can be nested.  When resolving names, the inner-most
2164b3bce662Sdanielk1977 ** context is searched first.  If no match is found, the next outer
2165b3bce662Sdanielk1977 ** context is checked.  If there is still no match, the next context
2166b3bce662Sdanielk1977 ** is checked.  This process continues until either a match is found
2167b3bce662Sdanielk1977 ** or all contexts are check.  When a match is found, the nRef member of
2168b3bce662Sdanielk1977 ** the context containing the match is incremented.
2169b3bce662Sdanielk1977 **
2170b3bce662Sdanielk1977 ** Each subquery gets a new NameContext.  The pNext field points to the
2171b3bce662Sdanielk1977 ** NameContext in the parent query.  Thus the process of scanning the
2172b3bce662Sdanielk1977 ** NameContext list corresponds to searching through successively outer
2173b3bce662Sdanielk1977 ** subqueries looking for a match.
2174b3bce662Sdanielk1977 */
2175b3bce662Sdanielk1977 struct NameContext {
2176b3bce662Sdanielk1977   Parse *pParse;       /* The parser */
2177b3bce662Sdanielk1977   SrcList *pSrcList;   /* One or more tables used to resolve names */
217826080d92Sdrh   ExprList *pEList;    /* Optional list of result-set columns */
217913449892Sdrh   AggInfo *pAggInfo;   /* Information about aggregates at this level */
2180b3bce662Sdanielk1977   NameContext *pNext;  /* Next outer name context.  NULL for outermost */
2181a51009b2Sdrh   int nRef;            /* Number of names resolved by this context */
2182a51009b2Sdrh   int nErr;            /* Number of errors encountered while resolving names */
2183a51009b2Sdrh   u8 ncFlags;          /* Zero or more NC_* flags defined below */
2184b3bce662Sdanielk1977 };
2185b3bce662Sdanielk1977 
2186b3bce662Sdanielk1977 /*
2187a51009b2Sdrh ** Allowed values for the NameContext, ncFlags field.
2188a51009b2Sdrh */
2189a51009b2Sdrh #define NC_AllowAgg  0x01    /* Aggregate functions are allowed here */
2190a51009b2Sdrh #define NC_HasAgg    0x02    /* One or more aggregate functions seen */
2191a51009b2Sdrh #define NC_IsCheck   0x04    /* True if resolving names in a CHECK constraint */
21923a8c4be7Sdrh #define NC_InAggFunc 0x08    /* True if analyzing arguments to an agg func */
2193e35463b3Sdrh #define NC_PartIdx   0x10    /* True if resolving a partial index WHERE */
2194a51009b2Sdrh 
2195a51009b2Sdrh /*
21969bb61fe7Sdrh ** An instance of the following structure contains all information
21979bb61fe7Sdrh ** needed to generate code for a single SELECT statement.
2198a76b5dfcSdrh **
2199d11d382cSdrh ** nLimit is set to -1 if there is no LIMIT clause.  nOffset is set to 0.
2200d11d382cSdrh ** If there is a LIMIT clause, the parser sets nLimit to the value of the
2201d11d382cSdrh ** limit and nOffset to the value of the offset (or 0 if there is not
2202d11d382cSdrh ** offset).  But later on, nLimit and nOffset become the memory locations
2203d11d382cSdrh ** in the VDBE that record the limit and offset counters.
22040342b1f5Sdrh **
2205b9bb7c18Sdrh ** addrOpenEphm[] entries contain the address of OP_OpenEphemeral opcodes.
22060342b1f5Sdrh ** These addresses must be stored so that we can go back and fill in
220766a5167bSdrh ** the P4_KEYINFO and P2 parameters later.  Neither the KeyInfo nor
22080342b1f5Sdrh ** the number of columns in P2 can be computed at the same time
2209b9bb7c18Sdrh ** as the OP_OpenEphm instruction is coded because not
22100342b1f5Sdrh ** enough information about the compound query is known at that point.
2211b9bb7c18Sdrh ** The KeyInfo for addrOpenTran[0] and [1] contains collating sequences
22122c79733fSdrh ** for the result set.  The KeyInfo for addrOpenEphm[2] contains collating
22130342b1f5Sdrh ** sequences for the ORDER BY clause.
22149bb61fe7Sdrh */
22159bb61fe7Sdrh struct Select {
22169bb61fe7Sdrh   ExprList *pEList;      /* The fields of the result */
22177b58daeaSdrh   u8 op;                 /* One of: TK_UNION TK_ALL TK_INTERSECT TK_EXCEPT */
22187d10d5a6Sdrh   u16 selFlags;          /* Various SF_* values */
2219a451017dSdrh   int iLimit, iOffset;   /* Memory registers holding LIMIT & OFFSET counters */
2220079a3072Sdrh   int addrOpenEphm[2];   /* OP_OpenEphem opcodes related to this select */
2221c63367efSdrh   u64 nSelectRow;        /* Estimated number of result rows */
2222ad3cab52Sdrh   SrcList *pSrc;         /* The FROM clause */
22239bb61fe7Sdrh   Expr *pWhere;          /* The WHERE clause */
22249bb61fe7Sdrh   ExprList *pGroupBy;    /* The GROUP BY clause */
22259bb61fe7Sdrh   Expr *pHaving;         /* The HAVING clause */
22269bb61fe7Sdrh   ExprList *pOrderBy;    /* The ORDER BY clause */
2227967e8b73Sdrh   Select *pPrior;        /* Prior select in a compound select statement */
22281e281291Sdrh   Select *pNext;         /* Next select to the left in a compound */
2229a2dc3b1aSdanielk1977   Expr *pLimit;          /* LIMIT expression. NULL means not used. */
2230a2dc3b1aSdanielk1977   Expr *pOffset;         /* OFFSET expression. NULL means not used. */
22314e9119d9Sdan   With *pWith;           /* WITH clause attached to this select. Or NULL. */
22329bb61fe7Sdrh };
22339bb61fe7Sdrh 
22349bb61fe7Sdrh /*
22357d10d5a6Sdrh ** Allowed values for Select.selFlags.  The "SF" prefix stands for
22367d10d5a6Sdrh ** "Select Flag".
22377d10d5a6Sdrh */
223821172c4cSdrh #define SF_Distinct        0x0001  /* Output should be DISTINCT */
223921172c4cSdrh #define SF_Resolved        0x0002  /* Identifiers have been resolved */
224021172c4cSdrh #define SF_Aggregate       0x0004  /* Contains aggregate functions */
224121172c4cSdrh #define SF_UsesEphemeral   0x0008  /* Uses the OpenEphemeral opcode */
224221172c4cSdrh #define SF_Expanded        0x0010  /* sqlite3SelectExpand() called on this */
224321172c4cSdrh #define SF_HasTypeInfo     0x0020  /* FROM subqueries have Table metadata */
2244079a3072Sdrh                     /*     0x0040  NOT USED */
224521172c4cSdrh #define SF_Values          0x0080  /* Synthesized from VALUES clause */
2246079a3072Sdrh                     /*     0x0100  NOT USED */
2247832ee3d4Sdrh #define SF_NestedFrom      0x0200  /* Part of a parenthesized FROM clause */
2248d58d3278Sdrh #define SF_MaybeConvert    0x0400  /* Need convertCompoundSelectToSubquery() */
2249eae73fbfSdan #define SF_Recursive       0x0800  /* The recursive part of a recursive CTE */
2250d227a291Sdrh #define SF_Compound        0x1000  /* Part of a compound query */
22517d10d5a6Sdrh 
22527d10d5a6Sdrh 
22537d10d5a6Sdrh /*
2254340309fdSdrh ** The results of a SELECT can be distributed in several ways, as defined
2255340309fdSdrh ** by one of the following macros.  The "SRT" prefix means "SELECT Result
2256340309fdSdrh ** Type".
2257340309fdSdrh **
2258340309fdSdrh **     SRT_Union       Store results as a key in a temporary index
2259340309fdSdrh **                     identified by pDest->iSDParm.
2260340309fdSdrh **
2261340309fdSdrh **     SRT_Except      Remove results from the temporary index pDest->iSDParm.
2262340309fdSdrh **
2263340309fdSdrh **     SRT_Exists      Store a 1 in memory cell pDest->iSDParm if the result
2264340309fdSdrh **                     set is not empty.
2265340309fdSdrh **
2266340309fdSdrh **     SRT_Discard     Throw the results away.  This is used by SELECT
2267340309fdSdrh **                     statements within triggers whose only purpose is
2268340309fdSdrh **                     the side-effects of functions.
2269340309fdSdrh **
2270340309fdSdrh ** All of the above are free to ignore their ORDER BY clause. Those that
2271340309fdSdrh ** follow must honor the ORDER BY clause.
2272340309fdSdrh **
2273340309fdSdrh **     SRT_Output      Generate a row of output (using the OP_ResultRow
2274340309fdSdrh **                     opcode) for each row in the result set.
2275340309fdSdrh **
2276340309fdSdrh **     SRT_Mem         Only valid if the result is a single column.
2277340309fdSdrh **                     Store the first column of the first result row
2278340309fdSdrh **                     in register pDest->iSDParm then abandon the rest
2279340309fdSdrh **                     of the query.  This destination implies "LIMIT 1".
2280340309fdSdrh **
2281340309fdSdrh **     SRT_Set         The result must be a single column.  Store each
2282340309fdSdrh **                     row of result as the key in table pDest->iSDParm.
2283340309fdSdrh **                     Apply the affinity pDest->affSdst before storing
2284340309fdSdrh **                     results.  Used to implement "IN (SELECT ...)".
2285340309fdSdrh **
2286340309fdSdrh **     SRT_EphemTab    Create an temporary table pDest->iSDParm and store
2287340309fdSdrh **                     the result there. The cursor is left open after
2288340309fdSdrh **                     returning.  This is like SRT_Table except that
2289340309fdSdrh **                     this destination uses OP_OpenEphemeral to create
2290340309fdSdrh **                     the table first.
2291340309fdSdrh **
2292340309fdSdrh **     SRT_Coroutine   Generate a co-routine that returns a new row of
2293340309fdSdrh **                     results each time it is invoked.  The entry point
2294340309fdSdrh **                     of the co-routine is stored in register pDest->iSDParm
2295340309fdSdrh **                     and the result row is stored in pDest->nDest registers
2296340309fdSdrh **                     starting with pDest->iSdst.
2297340309fdSdrh **
2298781def29Sdrh **     SRT_Table       Store results in temporary table pDest->iSDParm.
22998e1ee88cSdrh **     SRT_Fifo        This is like SRT_EphemTab except that the table
23008e1ee88cSdrh **                     is assumed to already be open.  SRT_Fifo has
23018e1ee88cSdrh **                     the additional property of being able to ignore
23028e1ee88cSdrh **                     the ORDER BY clause.
2303781def29Sdrh **
23048e1ee88cSdrh **     SRT_DistFifo    Store results in a temporary table pDest->iSDParm.
2305340309fdSdrh **                     But also use temporary table pDest->iSDParm+1 as
2306340309fdSdrh **                     a record of all prior results and ignore any duplicate
23078e1ee88cSdrh **                     rows.  Name means:  "Distinct Fifo".
2308781def29Sdrh **
2309781def29Sdrh **     SRT_Queue       Store results in priority queue pDest->iSDParm (really
2310781def29Sdrh **                     an index).  Append a sequence number so that all entries
2311781def29Sdrh **                     are distinct.
2312781def29Sdrh **
2313781def29Sdrh **     SRT_DistQueue   Store results in priority queue pDest->iSDParm only if
2314781def29Sdrh **                     the same record has never been stored before.  The
2315781def29Sdrh **                     index at pDest->iSDParm+1 hold all prior stores.
2316fef5208cSdrh */
231713449892Sdrh #define SRT_Union        1  /* Store result as keys in an index */
231813449892Sdrh #define SRT_Except       2  /* Remove result from a UNION index */
23199ed1dfa8Sdanielk1977 #define SRT_Exists       3  /* Store 1 if the result is not empty */
23209ed1dfa8Sdanielk1977 #define SRT_Discard      4  /* Do not save the results anywhere */
23218e1ee88cSdrh #define SRT_Fifo         5  /* Store result as data with an automatic rowid */
23228e1ee88cSdrh #define SRT_DistFifo     6  /* Like SRT_Fifo, but unique results only */
23238e1ee88cSdrh #define SRT_Queue        7  /* Store result in an queue */
23248e1ee88cSdrh #define SRT_DistQueue    8  /* Like SRT_Queue, but unique results only */
2325fef5208cSdrh 
232613449892Sdrh /* The ORDER BY clause is ignored for all of the above */
23278e1ee88cSdrh #define IgnorableOrderby(X) ((X->eDest)<=SRT_DistQueue)
232813449892Sdrh 
23298e1ee88cSdrh #define SRT_Output       9  /* Output each row of result */
23308e1ee88cSdrh #define SRT_Mem         10  /* Store result in a memory cell */
23318e1ee88cSdrh #define SRT_Set         11  /* Store results as keys in an index */
23328e1ee88cSdrh #define SRT_EphemTab    12  /* Create transient tab and store like SRT_Table */
23338e1ee88cSdrh #define SRT_Coroutine   13  /* Generate a single row of result */
23348e1ee88cSdrh #define SRT_Table       14  /* Store result as data with an automatic rowid */
23352282792aSdrh 
23362282792aSdrh /*
2337634d81deSdrh ** An instance of this object describes where to put of the results of
2338634d81deSdrh ** a SELECT statement.
23396c8c8ce0Sdanielk1977 */
23406c8c8ce0Sdanielk1977 struct SelectDest {
2341634d81deSdrh   u8 eDest;            /* How to dispose of the results.  On of SRT_* above. */
2342634d81deSdrh   char affSdst;        /* Affinity used when eDest==SRT_Set */
23432b596da8Sdrh   int iSDParm;         /* A parameter used by the eDest disposal method */
23442b596da8Sdrh   int iSdst;           /* Base register where results are written */
23452b596da8Sdrh   int nSdst;           /* Number of registers allocated */
2346fe1c6bb9Sdrh   ExprList *pOrderBy;  /* Key columns for SRT_Queue and SRT_DistQueue */
23476c8c8ce0Sdanielk1977 };
23486c8c8ce0Sdanielk1977 
23496c8c8ce0Sdanielk1977 /*
23500b9f50d8Sdrh ** During code generation of statements that do inserts into AUTOINCREMENT
23510b9f50d8Sdrh ** tables, the following information is attached to the Table.u.autoInc.p
23520b9f50d8Sdrh ** pointer of each autoincrement table to record some side information that
23530b9f50d8Sdrh ** the code generator needs.  We have to keep per-table autoincrement
23540b9f50d8Sdrh ** information in case inserts are down within triggers.  Triggers do not
23550b9f50d8Sdrh ** normally coordinate their activities, but we do need to coordinate the
23560b9f50d8Sdrh ** loading and saving of autoincrement information.
23570b9f50d8Sdrh */
23580b9f50d8Sdrh struct AutoincInfo {
23590b9f50d8Sdrh   AutoincInfo *pNext;   /* Next info block in a list of them all */
23600b9f50d8Sdrh   Table *pTab;          /* Table this info block refers to */
23610b9f50d8Sdrh   int iDb;              /* Index in sqlite3.aDb[] of database holding pTab */
23620b9f50d8Sdrh   int regCtr;           /* Memory register holding the rowid counter */
23630b9f50d8Sdrh };
23640b9f50d8Sdrh 
23650b9f50d8Sdrh /*
2366ceea3321Sdrh ** Size of the column cache
2367ceea3321Sdrh */
2368ceea3321Sdrh #ifndef SQLITE_N_COLCACHE
2369ceea3321Sdrh # define SQLITE_N_COLCACHE 10
2370ceea3321Sdrh #endif
2371ceea3321Sdrh 
23722832ad42Sdan /*
23732832ad42Sdan ** At least one instance of the following structure is created for each
23742832ad42Sdan ** trigger that may be fired while parsing an INSERT, UPDATE or DELETE
23752832ad42Sdan ** statement. All such objects are stored in the linked list headed at
23762832ad42Sdan ** Parse.pTriggerPrg and deleted once statement compilation has been
23772832ad42Sdan ** completed.
23782832ad42Sdan **
23792832ad42Sdan ** A Vdbe sub-program that implements the body and WHEN clause of trigger
23802832ad42Sdan ** TriggerPrg.pTrigger, assuming a default ON CONFLICT clause of
23812832ad42Sdan ** TriggerPrg.orconf, is stored in the TriggerPrg.pProgram variable.
23822832ad42Sdan ** The Parse.pTriggerPrg list never contains two entries with the same
23832832ad42Sdan ** values for both pTrigger and orconf.
238465a7cd16Sdan **
2385bb5f168fSdan ** The TriggerPrg.aColmask[0] variable is set to a mask of old.* columns
238665a7cd16Sdan ** accessed (or set to 0 for triggers fired as a result of INSERT
2387bb5f168fSdan ** statements). Similarly, the TriggerPrg.aColmask[1] variable is set to
2388bb5f168fSdan ** a mask of new.* columns used by the program.
23892832ad42Sdan */
23902832ad42Sdan struct TriggerPrg {
23912832ad42Sdan   Trigger *pTrigger;      /* Trigger this program was coded from */
23922832ad42Sdan   TriggerPrg *pNext;      /* Next entry in Parse.pTriggerPrg list */
2393a451017dSdrh   SubProgram *pProgram;   /* Program implementing pTrigger/orconf */
2394a451017dSdrh   int orconf;             /* Default ON CONFLICT policy */
2395a451017dSdrh   u32 aColmask[2];        /* Masks of old.*, new.* columns accessed */
2396165921a7Sdan };
2397165921a7Sdan 
239864123585Sdrh /*
239964123585Sdrh ** The yDbMask datatype for the bitmask of all attached databases.
240064123585Sdrh */
240101c7dc88Sdrh #if SQLITE_MAX_ATTACHED>30
2402a7ab6d81Sdrh   typedef unsigned char yDbMask[(SQLITE_MAX_ATTACHED+9)/8];
2403a7ab6d81Sdrh # define DbMaskTest(M,I)    (((M)[(I)/8]&(1<<((I)&7)))!=0)
2404a7ab6d81Sdrh # define DbMaskZero(M)      memset((M),0,sizeof(M))
2405a7ab6d81Sdrh # define DbMaskSet(M,I)     (M)[(I)/8]|=(1<<((I)&7))
2406a7ab6d81Sdrh # define DbMaskAllZero(M)   sqlite3DbMaskAllZero(M)
2407a7ab6d81Sdrh # define DbMaskNonZero(M)   (sqlite3DbMaskAllZero(M)==0)
240801c7dc88Sdrh #else
240964123585Sdrh   typedef unsigned int yDbMask;
2410a7ab6d81Sdrh # define DbMaskTest(M,I)    (((M)&(((yDbMask)1)<<(I)))!=0)
2411a7ab6d81Sdrh # define DbMaskZero(M)      (M)=0
2412a7ab6d81Sdrh # define DbMaskSet(M,I)     (M)|=(((yDbMask)1)<<(I))
2413a7ab6d81Sdrh # define DbMaskAllZero(M)   (M)==0
2414a7ab6d81Sdrh # define DbMaskNonZero(M)   (M)!=0
241501c7dc88Sdrh #endif
241601c7dc88Sdrh 
2417ceea3321Sdrh /*
2418f57b3399Sdrh ** An SQL parser context.  A copy of this structure is passed through
2419f57b3399Sdrh ** the parser and down into all the parser action routine in order to
2420f57b3399Sdrh ** carry around information that is global to the entire parse.
2421f1974846Sdrh **
2422f1974846Sdrh ** The structure is divided into two parts.  When the parser and code
2423f1974846Sdrh ** generate call themselves recursively, the first part of the structure
2424f1974846Sdrh ** is constant but the second part is reset at the beginning and end of
2425f1974846Sdrh ** each recursion.
2426c00da105Sdanielk1977 **
2427c00da105Sdanielk1977 ** The nTableLock and aTableLock variables are only used if the shared-cache
2428c00da105Sdanielk1977 ** feature is enabled (if sqlite3Tsd()->useSharedData is true). They are
2429c00da105Sdanielk1977 ** used to store the set of table-locks required by the statement being
2430c00da105Sdanielk1977 ** compiled. Function sqlite3TableLock() is used to add entries to the
2431c00da105Sdanielk1977 ** list.
243275897234Sdrh */
243375897234Sdrh struct Parse {
24349bb575fdSdrh   sqlite3 *db;         /* The main database structure */
243575897234Sdrh   char *zErrMsg;       /* An error message */
243675897234Sdrh   Vdbe *pVdbe;         /* An engine for executing database bytecode */
2437a451017dSdrh   int rc;              /* Return code from execution */
2438836faa48Sdrh   u8 colNamesSet;      /* TRUE after OP_ColumnName has been issued to pVdbe */
2439a6ecd338Sdrh   u8 checkSchema;      /* Causes schema cookie check after an error */
2440205f48e6Sdrh   u8 nested;           /* Number of nested calls to the parser/code generator */
2441892d3179Sdrh   u8 nTempReg;         /* Number of temporary registers in aTempReg[] */
2442a451017dSdrh   u8 isMultiWrite;     /* True if statement may modify/insert multiple rows */
2443a451017dSdrh   u8 mayAbort;         /* True if statement may throw an ABORT exception */
2444d58d3278Sdrh   u8 hasCompound;      /* Need to invoke convertCompoundSelectToSubquery() */
2445aceb31b1Sdrh   u8 okConstFactor;    /* OK to factor out constants */
2446892d3179Sdrh   int aTempReg[8];     /* Holding area for temporary registers */
2447892d3179Sdrh   int nRangeReg;       /* Size of the temporary register block */
2448892d3179Sdrh   int iRangeReg;       /* First register in temporary register block */
244975897234Sdrh   int nErr;            /* Number of errors seen */
2450832508b7Sdrh   int nTab;            /* Number of previously allocated VDBE cursors */
245119a775c2Sdrh   int nMem;            /* Number of memory cells used so far */
2452fef5208cSdrh   int nSet;            /* Number of sets used so far */
24531d8cb21fSdan   int nOnce;           /* Number of OP_Once instructions so far */
245473d5b8f5Sdrh   int nOpAlloc;        /* Number of slots allocated for Vdbe.aOp[] */
245561019c78Sdrh   int iFixedOp;        /* Never back out opcodes iFixedOp-1 or earlier */
2456aa9b8963Sdrh   int ckBase;          /* Base register of data during check constraints */
2457b2b9d3d7Sdrh   int iPartIdxTab;     /* Table corresponding to a partial index */
2458ceea3321Sdrh   int iCacheLevel;     /* ColCache valid when aColCache[].iLevel<=iCacheLevel */
2459ceea3321Sdrh   int iCacheCnt;       /* Counter used to generate aColCache[].lru values */
24607df89c8cSdrh   int nLabel;          /* Number of labels used */
24617df89c8cSdrh   int *aLabel;         /* Space to hold the labels */
24622f7794c1Sdrh   struct yColCache {
2463e55cbd72Sdrh     int iTable;           /* Table cursor number */
24647df89c8cSdrh     i16 iColumn;          /* Table column number */
2465ceea3321Sdrh     u8 tempReg;           /* iReg is a temp register that needs to be freed */
2466ceea3321Sdrh     int iLevel;           /* Nesting level */
2467ceea3321Sdrh     int iReg;             /* Reg with value of this column. 0 means none. */
2468ceea3321Sdrh     int lru;              /* Least recently used entry has the smallest value */
2469ceea3321Sdrh   } aColCache[SQLITE_N_COLCACHE];  /* One for each column cache entry */
2470f30a969bSdrh   ExprList *pConstExpr;/* Constant expressions */
24717df89c8cSdrh   Token constraintName;/* Name of the constraint currently being parsed */
247264123585Sdrh   yDbMask writeMask;   /* Start a write transaction on these databases */
247364123585Sdrh   yDbMask cookieMask;  /* Bitmask of schema verified databases */
2474c797d4dcSdrh   int cookieValue[SQLITE_MAX_ATTACHED+2];  /* Values of cookies to verify */
2475a451017dSdrh   int regRowid;        /* Register holding rowid of CREATE TABLE entry */
2476a451017dSdrh   int regRoot;         /* Register holding root page number for new objects */
2477a451017dSdrh   int nMaxArg;         /* Max args passed to user function by sub-program */
2478c00da105Sdanielk1977 #ifndef SQLITE_OMIT_SHARED_CACHE
2479c00da105Sdanielk1977   int nTableLock;        /* Number of locks in aTableLock */
2480c00da105Sdanielk1977   TableLock *aTableLock; /* Required table locks for shared-cache mode */
2481c00da105Sdanielk1977 #endif
24820b9f50d8Sdrh   AutoincInfo *pAinc;  /* Information about AUTOINCREMENT counters */
2483f1974846Sdrh 
2484165921a7Sdan   /* Information used while coding trigger programs. */
248565a7cd16Sdan   Parse *pToplevel;    /* Parse structure for main program (or NULL) */
2486165921a7Sdan   Table *pTriggerTab;  /* Table triggers are being coded for */
2487c6bd4e4aSdrh   int addrCrTab;       /* Address of OP_CreateTable opcode on CREATE TABLE */
2488c6bd4e4aSdrh   int addrSkipPK;      /* Address of instruction to skip PRIMARY KEY index */
24894f402f26Sdrh   u32 nQueryLoop;      /* Est number of iterations of a query (10*log2(N)) */
249065a7cd16Sdan   u32 oldmask;         /* Mask of old.* columns referenced */
2491bb5f168fSdan   u32 newmask;         /* Mask of new.* columns referenced */
249265a7cd16Sdan   u8 eTriggerOp;       /* TK_UPDATE, TK_INSERT or TK_DELETE */
249365a7cd16Sdan   u8 eOrconf;          /* Default ON CONFLICT policy for trigger steps */
2494d66c8309Sdan   u8 disableTriggers;  /* True to disable triggers */
2495165921a7Sdan 
24967df89c8cSdrh   /************************************************************************
24977df89c8cSdrh   ** Above is constant between recursions.  Below is reset before and after
24987df89c8cSdrh   ** each recursion.  The boundary between these two regions is determined
24997df89c8cSdrh   ** using offsetof(Parse,nVar) so the nVar field must be the first field
25007df89c8cSdrh   ** in the recursive region.
25017df89c8cSdrh   ************************************************************************/
2502f1974846Sdrh 
2503f1974846Sdrh   int nVar;                 /* Number of '?' variables seen in the SQL so far */
2504124c0b49Sdrh   int nzVar;                /* Number of available slots in azVar[] */
25057f9c5dbfSdrh   u8 iPkSortOrder;          /* ASC or DESC for INTEGER PRIMARY KEY */
25067df89c8cSdrh   u8 bFreeWith;             /* True if pWith should be freed with parser */
2507a451017dSdrh   u8 explain;               /* True if the EXPLAIN flag is found on the query */
2508a451017dSdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
2509a451017dSdrh   u8 declareVtab;           /* True if inside sqlite3_declare_vtab() */
2510a451017dSdrh   int nVtabLock;            /* Number of virtual tables to lock */
2511a451017dSdrh #endif
2512a451017dSdrh   int nAlias;               /* Number of aliased result set columns */
2513a451017dSdrh   int nHeight;              /* Expression tree height of current sub-select */
2514a451017dSdrh #ifndef SQLITE_OMIT_EXPLAIN
2515a451017dSdrh   int iSelectId;            /* ID of current select for EXPLAIN output */
2516a451017dSdrh   int iNextSelectId;        /* Next available select ID for EXPLAIN output */
2517a451017dSdrh #endif
2518124c0b49Sdrh   char **azVar;             /* Pointers to names of parameters */
2519937d0deaSdan   Vdbe *pReprepare;         /* VM being reprepared (sqlite3Reprepare()) */
2520f1974846Sdrh   const char *zTail;        /* All SQL text past the last semicolon parsed */
2521f1974846Sdrh   Table *pNewTable;         /* A table being constructed by CREATE TABLE */
2522f1974846Sdrh   Trigger *pNewTrigger;     /* Trigger under construct by a CREATE TRIGGER */
2523f1974846Sdrh   const char *zAuthContext; /* The 6th parameter to db->xAuth callbacks */
2524a451017dSdrh   Token sNameToken;         /* Token with unqualified schema object name */
2525a451017dSdrh   Token sLastToken;         /* The last token parsed */
2526b9bb7c18Sdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
252733b3933cSdanielk1977   Token sArg;               /* Complete text of a module argument */
25284f3dd150Sdrh   Table **apVtabLock;       /* Pointer to virtual tables needing locking */
2529b9bb7c18Sdrh #endif
2530588a9a1aSdrh   Table *pZombieTab;        /* List of Table objects to delete after code gen */
25312832ad42Sdan   TriggerPrg *pTriggerPrg;  /* Linked list of coded triggers */
25324e9119d9Sdan   With *pWith;              /* Current WITH clause, or NULL */
253375897234Sdrh };
253475897234Sdrh 
2535a451017dSdrh /*
2536a451017dSdrh ** Return true if currently inside an sqlite3_declare_vtab() call.
2537a451017dSdrh */
25387e6ebfb2Sdanielk1977 #ifdef SQLITE_OMIT_VIRTUALTABLE
25397e6ebfb2Sdanielk1977   #define IN_DECLARE_VTAB 0
25407e6ebfb2Sdanielk1977 #else
25417e6ebfb2Sdanielk1977   #define IN_DECLARE_VTAB (pParse->declareVtab)
25427e6ebfb2Sdanielk1977 #endif
25437e6ebfb2Sdanielk1977 
2544d99bc930Sdanielk1977 /*
254585e2096fSdrh ** An instance of the following structure can be declared on a stack and used
254685e2096fSdrh ** to save the Parse.zAuthContext value so that it can be restored later.
254785e2096fSdrh */
254885e2096fSdrh struct AuthContext {
254985e2096fSdrh   const char *zAuthContext;   /* Put saved Parse.zAuthContext here */
255085e2096fSdrh   Parse *pParse;              /* The Parse structure */
255185e2096fSdrh };
255285e2096fSdrh 
255385e2096fSdrh /*
2554a748fdccSdrh ** Bitfield flags for P5 value in various opcodes.
2555b0c374ffSrdc */
25563e9ca094Sdrh #define OPFLAG_NCHANGE       0x01    /* Set to update db->nChange */
25573e9ca094Sdrh #define OPFLAG_LASTROWID     0x02    /* Set to update db->lastRowid */
25583e9ca094Sdrh #define OPFLAG_ISUPDATE      0x04    /* This OP_Insert is an sql UPDATE */
25593e9ca094Sdrh #define OPFLAG_APPEND        0x08    /* This is likely to be an append */
25603e9ca094Sdrh #define OPFLAG_USESEEKRESULT 0x10    /* Try to avoid a seek in BtreeInsert() */
25613e9ca094Sdrh #define OPFLAG_CLEARCACHE    0x20    /* Clear pseudo-table cache in OP_Column */
2562a748fdccSdrh #define OPFLAG_LENGTHARG     0x40    /* OP_Column only used for length() */
2563a748fdccSdrh #define OPFLAG_TYPEOFARG     0x80    /* OP_Column only used for typeof() */
2564428c218cSdan #define OPFLAG_BULKCSR       0x01    /* OP_Open** used to open bulk cursor */
2565428c218cSdan #define OPFLAG_P2ISREG       0x02    /* P2 to OP_Open** is a register number */
2566953f7611Sdrh #define OPFLAG_PERMUTE       0x01    /* OP_Compare: use the permutation */
2567b0c374ffSrdc 
2568b0c374ffSrdc /*
2569d99bc930Sdanielk1977  * Each trigger present in the database schema is stored as an instance of
2570d99bc930Sdanielk1977  * struct Trigger.
2571d99bc930Sdanielk1977  *
2572d99bc930Sdanielk1977  * Pointers to instances of struct Trigger are stored in two ways.
25739bb575fdSdrh  * 1. In the "trigHash" hash table (part of the sqlite3* that represents the
2574d99bc930Sdanielk1977  *    database). This allows Trigger structures to be retrieved by name.
2575d99bc930Sdanielk1977  * 2. All triggers associated with a single table form a linked list, using the
2576ad3cab52Sdrh  *    pNext member of struct Trigger. A pointer to the first element of the
2577ad3cab52Sdrh  *    linked list is stored as the "pTrigger" member of the associated
2578ad3cab52Sdrh  *    struct Table.
2579d99bc930Sdanielk1977  *
2580ad3cab52Sdrh  * The "step_list" member points to the first element of a linked list
2581ad3cab52Sdrh  * containing the SQL statements specified as the trigger program.
2582d99bc930Sdanielk1977  */
2583d99bc930Sdanielk1977 struct Trigger {
2584165921a7Sdan   char *zName;            /* The name of the trigger                        */
2585d99bc930Sdanielk1977   char *table;            /* The table or view to which the trigger applies */
2586f0f258b1Sdrh   u8 op;                  /* One of TK_DELETE, TK_UPDATE, TK_INSERT         */
2587dca76841Sdrh   u8 tr_tm;               /* One of TRIGGER_BEFORE, TRIGGER_AFTER */
2588467bcf36Sshane   Expr *pWhen;            /* The WHEN clause of the expression (may be NULL) */
2589d99bc930Sdanielk1977   IdList *pColumns;       /* If this is an UPDATE OF <column-list> trigger,
2590d99bc930Sdanielk1977                              the <column-list> is stored here */
2591e501b89aSdanielk1977   Schema *pSchema;        /* Schema containing the trigger */
2592e501b89aSdanielk1977   Schema *pTabSchema;     /* Schema containing the table */
2593d99bc930Sdanielk1977   TriggerStep *step_list; /* Link list of trigger program steps             */
2594d99bc930Sdanielk1977   Trigger *pNext;         /* Next trigger associated with the table */
2595c3f9bad2Sdanielk1977 };
2596d99bc930Sdanielk1977 
2597d99bc930Sdanielk1977 /*
2598dca76841Sdrh ** A trigger is either a BEFORE or an AFTER trigger.  The following constants
2599dca76841Sdrh ** determine which.
2600dca76841Sdrh **
2601dca76841Sdrh ** If there are multiple triggers, you might of some BEFORE and some AFTER.
2602dca76841Sdrh ** In that cases, the constants below can be ORed together.
2603dca76841Sdrh */
2604dca76841Sdrh #define TRIGGER_BEFORE  1
2605dca76841Sdrh #define TRIGGER_AFTER   2
2606dca76841Sdrh 
2607dca76841Sdrh /*
2608d99bc930Sdanielk1977  * An instance of struct TriggerStep is used to store a single SQL statement
2609d99bc930Sdanielk1977  * that is a part of a trigger-program.
2610d99bc930Sdanielk1977  *
2611d99bc930Sdanielk1977  * Instances of struct TriggerStep are stored in a singly linked list (linked
2612d99bc930Sdanielk1977  * using the "pNext" member) referenced by the "step_list" member of the
2613d99bc930Sdanielk1977  * associated struct Trigger instance. The first element of the linked list is
2614d99bc930Sdanielk1977  * the first step of the trigger-program.
2615d99bc930Sdanielk1977  *
2616d99bc930Sdanielk1977  * The "op" member indicates whether this is a "DELETE", "INSERT", "UPDATE" or
2617d99bc930Sdanielk1977  * "SELECT" statement. The meanings of the other members is determined by the
2618d99bc930Sdanielk1977  * value of "op" as follows:
2619d99bc930Sdanielk1977  *
2620d99bc930Sdanielk1977  * (op == TK_INSERT)
2621d99bc930Sdanielk1977  * orconf    -> stores the ON CONFLICT algorithm
2622d99bc930Sdanielk1977  * pSelect   -> If this is an INSERT INTO ... SELECT ... statement, then
2623d99bc930Sdanielk1977  *              this stores a pointer to the SELECT statement. Otherwise NULL.
2624b7916a78Sdrh  * target    -> A token holding the quoted name of the table to insert into.
2625d99bc930Sdanielk1977  * pExprList -> If this is an INSERT INTO ... VALUES ... statement, then
2626d99bc930Sdanielk1977  *              this stores values to be inserted. Otherwise NULL.
2627d99bc930Sdanielk1977  * pIdList   -> If this is an INSERT INTO ... (<column-names>) VALUES ...
2628ad3cab52Sdrh  *              statement, then this stores the column-names to be
2629ad3cab52Sdrh  *              inserted into.
2630d99bc930Sdanielk1977  *
2631d99bc930Sdanielk1977  * (op == TK_DELETE)
2632b7916a78Sdrh  * target    -> A token holding the quoted name of the table to delete from.
2633d99bc930Sdanielk1977  * pWhere    -> The WHERE clause of the DELETE statement if one is specified.
2634d99bc930Sdanielk1977  *              Otherwise NULL.
2635d99bc930Sdanielk1977  *
2636d99bc930Sdanielk1977  * (op == TK_UPDATE)
2637b7916a78Sdrh  * target    -> A token holding the quoted name of the table to update rows of.
2638d99bc930Sdanielk1977  * pWhere    -> The WHERE clause of the UPDATE statement if one is specified.
2639d99bc930Sdanielk1977  *              Otherwise NULL.
2640d99bc930Sdanielk1977  * pExprList -> A list of the columns to update and the expressions to update
26414adee20fSdanielk1977  *              them to. See sqlite3Update() documentation of "pChanges"
2642ad3cab52Sdrh  *              argument.
2643d99bc930Sdanielk1977  *
2644d99bc930Sdanielk1977  */
2645c3f9bad2Sdanielk1977 struct TriggerStep {
2646b1819a0bSdrh   u8 op;               /* One of TK_DELETE, TK_UPDATE, TK_INSERT, TK_SELECT */
2647b1819a0bSdrh   u8 orconf;           /* OE_Rollback etc. */
2648a69d9168Sdrh   Trigger *pTrig;      /* The trigger that this step is a part of */
2649b1819a0bSdrh   Select *pSelect;     /* SELECT statment or RHS of INSERT INTO .. SELECT ... */
2650b1819a0bSdrh   Token target;        /* Target table for DELETE, UPDATE, INSERT */
2651b1819a0bSdrh   Expr *pWhere;        /* The WHERE clause for DELETE or UPDATE steps */
265275593d96Sdrh   ExprList *pExprList; /* SET clause for UPDATE. */
2653b1819a0bSdrh   IdList *pIdList;     /* Column names for INSERT */
2654c3f9bad2Sdanielk1977   TriggerStep *pNext;  /* Next in the link-list */
2655187e4c6aSdrh   TriggerStep *pLast;  /* Last element in link-list. Valid for 1st elem only */
2656c3f9bad2Sdanielk1977 };
2657c3f9bad2Sdanielk1977 
2658d99bc930Sdanielk1977 /*
2659f26e09c8Sdrh ** The following structure contains information used by the sqliteFix...
2660f26e09c8Sdrh ** routines as they walk the parse tree to make database references
2661f26e09c8Sdrh ** explicit.
2662f26e09c8Sdrh */
2663f26e09c8Sdrh typedef struct DbFixer DbFixer;
2664f26e09c8Sdrh struct DbFixer {
2665f26e09c8Sdrh   Parse *pParse;      /* The parsing context.  Error messages written here */
266641fb5cd1Sdan   Schema *pSchema;    /* Fix items to this schema */
266746539d7cSdan   int bVarOnly;       /* Check for variable references only */
2668f26e09c8Sdrh   const char *zDb;    /* Make sure all objects are contained in this database */
2669f26e09c8Sdrh   const char *zType;  /* Type of the container - used for error messages */
2670f26e09c8Sdrh   const Token *pName; /* Name of the container - used for error messages */
2671f26e09c8Sdrh };
2672f26e09c8Sdrh 
2673f26e09c8Sdrh /*
2674ade86483Sdrh ** An objected used to accumulate the text of a string where we
2675ade86483Sdrh ** do not necessarily know how big the string will be in the end.
2676ade86483Sdrh */
2677ade86483Sdrh struct StrAccum {
2678633e6d57Sdrh   sqlite3 *db;         /* Optional database for lookaside.  Can be NULL */
2679ade86483Sdrh   char *zBase;         /* A base allocation.  Not from malloc. */
2680ade86483Sdrh   char *zText;         /* The string collected so far */
2681ade86483Sdrh   int  nChar;          /* Length of the string so far */
2682ade86483Sdrh   int  nAlloc;         /* Amount of space allocated in zText */
2683bb4957f8Sdrh   int  mxAlloc;        /* Maximum allowed string length */
2684b975598eSdrh   u8   useMalloc;      /* 0: none,  1: sqlite3DbMalloc,  2: sqlite3_malloc */
2685b49bc86aSdrh   u8   accError;       /* STRACCUM_NOMEM or STRACCUM_TOOBIG */
2686ade86483Sdrh };
2687b49bc86aSdrh #define STRACCUM_NOMEM   1
2688b49bc86aSdrh #define STRACCUM_TOOBIG  2
2689ade86483Sdrh 
2690ade86483Sdrh /*
2691234c39dfSdrh ** A pointer to this structure is used to communicate information
2692234c39dfSdrh ** from sqlite3Init and OP_ParseSchema into the sqlite3InitCallback.
2693234c39dfSdrh */
2694234c39dfSdrh typedef struct {
26959bb575fdSdrh   sqlite3 *db;        /* The database being initialized */
2696234c39dfSdrh   char **pzErrMsg;    /* Error message stored here */
2697a451017dSdrh   int iDb;            /* 0 for main database.  1 for TEMP, 2.. for ATTACHed */
269815ca1df1Sdrh   int rc;             /* Result code stored here */
2699234c39dfSdrh } InitData;
2700234c39dfSdrh 
2701b6c29897Sdrh /*
270240257ffdSdrh ** Structure containing global configuration data for the SQLite library.
270333589797Sdrh **
270433589797Sdrh ** This structure also contains some state information.
270540257ffdSdrh */
270640257ffdSdrh struct Sqlite3Config {
2707fec00eabSdrh   int bMemstat;                     /* True to enable memory status */
2708fec00eabSdrh   int bCoreMutex;                   /* True to enable core mutexing */
2709fec00eabSdrh   int bFullMutex;                   /* True to enable full mutexing */
2710cd74b611Sdan   int bOpenUri;                     /* True to interpret filenames as URIs */
2711de9a7b8aSdrh   int bUseCis;                      /* Use covering indices for full-scans */
27120a687d12Sdrh   int mxStrlen;                     /* Maximum string length */
271309fe6143Sdrh   int neverCorrupt;                 /* Database is always well-formed */
2714633e6d57Sdrh   int szLookaside;                  /* Default lookaside buffer size */
2715633e6d57Sdrh   int nLookaside;                   /* Default lookaside buffer count */
2716fec00eabSdrh   sqlite3_mem_methods m;            /* Low-level memory allocation interface */
27176d2ab0e4Sdanielk1977   sqlite3_mutex_methods mutex;      /* Low-level mutex interface */
271822e21ff4Sdan   sqlite3_pcache_methods2 pcache2;  /* Low-level page-cache interface */
271940257ffdSdrh   void *pHeap;                      /* Heap storage space */
272033589797Sdrh   int nHeap;                        /* Size of pHeap[] */
272133589797Sdrh   int mnReq, mxReq;                 /* Min and max heap requests sizes */
27229b4c59faSdrh   sqlite3_int64 szMmap;             /* mmap() space per open file */
27239b4c59faSdrh   sqlite3_int64 mxMmap;             /* Maximum value for szMmap */
272433589797Sdrh   void *pScratch;                   /* Scratch memory */
272533589797Sdrh   int szScratch;                    /* Size of each scratch buffer */
272633589797Sdrh   int nScratch;                     /* Number of scratch buffers */
272733589797Sdrh   void *pPage;                      /* Page cache memory */
272833589797Sdrh   int szPage;                       /* Size of each page in pPage[] */
272933589797Sdrh   int nPage;                        /* Number of pages in pPage[] */
27301875f7a3Sdrh   int mxParserStack;                /* maximum depth of the parser stack */
27311875f7a3Sdrh   int sharedCacheEnabled;           /* true if shared-cache mode enabled */
27321875f7a3Sdrh   /* The above might be initialized to non-zero.  The following need to always
27331875f7a3Sdrh   ** initially be zero, however. */
273471bc31c6Sdanielk1977   int isInit;                       /* True after initialization has finished */
2735502b4e00Sdanielk1977   int inProgress;                   /* True while initialization in progress */
2736e1ab2193Sdan   int isMutexInit;                  /* True after mutexes are initialized */
273771bc31c6Sdanielk1977   int isMallocInit;                 /* True after malloc is initialized */
2738e1ab2193Sdan   int isPCacheInit;                 /* True after malloc is initialized */
273993ed56d9Sdrh   int nRefInitMutex;                /* Number of users of pInitMutex */
2740c007f61bSdrh   sqlite3_mutex *pInitMutex;        /* Mutex used by sqlite3_initialize() */
27413f280701Sdrh   void (*xLog)(void*,int,const char*); /* Function for logging */
27423f280701Sdrh   void *pLogArg;                       /* First argument to xLog() */
2743ac455939Sdan #ifdef SQLITE_ENABLE_SQLLOG
2744ac455939Sdan   void(*xSqllog)(void*,sqlite3*,const char*, int);
2745ac455939Sdan   void *pSqllogArg;
2746ac455939Sdan #endif
2747688852abSdrh #ifdef SQLITE_VDBE_COVERAGE
2748688852abSdrh   /* The following callback (if not NULL) is invoked on every VDBE branch
2749688852abSdrh   ** operation.  Set the callback using SQLITE_TESTCTRL_VDBE_COVERAGE.
2750688852abSdrh   */
2751688852abSdrh   void (*xVdbeBranch)(void*,int iSrcLine,u8 eThis,u8 eMx);  /* Callback */
2752688852abSdrh   void *pVdbeBranchArg;                                     /* 1st argument */
2753688852abSdrh #endif
2754c007f61bSdrh #ifndef SQLITE_OMIT_BUILTIN_TEST
2755c007f61bSdrh   int (*xTestCallback)(int);        /* Invoked by sqlite3FaultSim() */
2756c007f61bSdrh #endif
2757c007f61bSdrh   int bLocaltimeFault;              /* True to fail localtime() calls */
275840257ffdSdrh };
275940257ffdSdrh 
276040257ffdSdrh /*
276109fe6143Sdrh ** This macro is used inside of assert() statements to indicate that
276209fe6143Sdrh ** the assert is only valid on a well-formed database.  Instead of:
276309fe6143Sdrh **
276409fe6143Sdrh **     assert( X );
276509fe6143Sdrh **
276609fe6143Sdrh ** One writes:
276709fe6143Sdrh **
2768b2023665Sdrh **     assert( X || CORRUPT_DB );
276909fe6143Sdrh **
2770b2023665Sdrh ** CORRUPT_DB is true during normal operation.  CORRUPT_DB does not indicate
2771b2023665Sdrh ** that the database is definitely corrupt, only that it might be corrupt.
2772b2023665Sdrh ** For most test cases, CORRUPT_DB is set to false using a special
2773b2023665Sdrh ** sqlite3_test_control().  This enables assert() statements to prove
2774b2023665Sdrh ** things that are always true for well-formed databases.
277509fe6143Sdrh */
2776b2023665Sdrh #define CORRUPT_DB  (sqlite3Config.neverCorrupt==0)
277709fe6143Sdrh 
277809fe6143Sdrh /*
27797d10d5a6Sdrh ** Context pointer passed down through the tree-walk.
27807d10d5a6Sdrh */
27817d10d5a6Sdrh struct Walker {
27827d10d5a6Sdrh   int (*xExprCallback)(Walker*, Expr*);     /* Callback for expressions */
27837d10d5a6Sdrh   int (*xSelectCallback)(Walker*,Select*);  /* Callback for SELECTs */
2784b290f117Sdan   void (*xSelectCallback2)(Walker*,Select*);/* Second callback for SELECTs */
27857d10d5a6Sdrh   Parse *pParse;                            /* Parser context.  */
2786030796dfSdrh   int walkerDepth;                          /* Number of subqueries */
27877d10d5a6Sdrh   union {                                   /* Extra data for callback */
27887d10d5a6Sdrh     NameContext *pNC;                          /* Naming context */
27897d10d5a6Sdrh     int i;                                     /* Integer value */
2790374fdce4Sdrh     SrcList *pSrcList;                         /* FROM clause */
2791030796dfSdrh     struct SrcCount *pSrcCount;                /* Counting column references */
27927d10d5a6Sdrh   } u;
27937d10d5a6Sdrh };
27947d10d5a6Sdrh 
27957d10d5a6Sdrh /* Forward declarations */
27967d10d5a6Sdrh int sqlite3WalkExpr(Walker*, Expr*);
27977d10d5a6Sdrh int sqlite3WalkExprList(Walker*, ExprList*);
27987d10d5a6Sdrh int sqlite3WalkSelect(Walker*, Select*);
27997d10d5a6Sdrh int sqlite3WalkSelectExpr(Walker*, Select*);
28007d10d5a6Sdrh int sqlite3WalkSelectFrom(Walker*, Select*);
28017d10d5a6Sdrh 
28027d10d5a6Sdrh /*
28037d10d5a6Sdrh ** Return code from the parse-tree walking primitives and their
28047d10d5a6Sdrh ** callbacks.
28057d10d5a6Sdrh */
28062bf90f1eSdrh #define WRC_Continue    0   /* Continue down into children */
28072bf90f1eSdrh #define WRC_Prune       1   /* Omit children but continue walking siblings */
28082bf90f1eSdrh #define WRC_Abort       2   /* Abandon the tree walk */
28097d10d5a6Sdrh 
28107d10d5a6Sdrh /*
2811eae73fbfSdan ** An instance of this structure represents a set of one or more CTEs
2812c49832c2Sdrh ** (common table expressions) created by a single WITH clause.
28137d562dbeSdan */
28147d562dbeSdan struct With {
2815c49832c2Sdrh   int nCte;                       /* Number of CTEs in the WITH clause */
28164e9119d9Sdan   With *pOuter;                   /* Containing WITH clause, or NULL */
2817c49832c2Sdrh   struct Cte {                    /* For each CTE in the WITH clause.... */
28184e9119d9Sdan     char *zName;                    /* Name of this CTE */
28194e9119d9Sdan     ExprList *pCols;                /* List of explicit column names, or NULL */
2820c49832c2Sdrh     Select *pSelect;                /* The definition of this CTE */
2821f2655fe8Sdan     const char *zErr;               /* Error message for circular references */
28227d562dbeSdan   } a[1];
28237d562dbeSdan };
28247d562dbeSdan 
28257d562dbeSdan /*
282666150956Sdrh ** Assuming zIn points to the first byte of a UTF-8 character,
282766150956Sdrh ** advance zIn to point to the first byte of the next UTF-8 character.
28284a919118Sdrh */
28294a919118Sdrh #define SQLITE_SKIP_UTF8(zIn) {                        \
28304a919118Sdrh   if( (*(zIn++))>=0xc0 ){                              \
28314a919118Sdrh     while( (*zIn & 0xc0)==0x80 ){ zIn++; }             \
28324a919118Sdrh   }                                                    \
28334a919118Sdrh }
28344a919118Sdrh 
28354a919118Sdrh /*
28369978c97eSdrh ** The SQLITE_*_BKPT macros are substitutes for the error codes with
28379978c97eSdrh ** the same name but without the _BKPT suffix.  These macros invoke
28389978c97eSdrh ** routines that report the line-number on which the error originated
28399978c97eSdrh ** using sqlite3_log().  The routines also provide a convenient place
28409978c97eSdrh ** to set a debugger breakpoint.
284149285708Sdrh */
28429978c97eSdrh int sqlite3CorruptError(int);
28439978c97eSdrh int sqlite3MisuseError(int);
28449978c97eSdrh int sqlite3CantopenError(int);
28459978c97eSdrh #define SQLITE_CORRUPT_BKPT sqlite3CorruptError(__LINE__)
28469978c97eSdrh #define SQLITE_MISUSE_BKPT sqlite3MisuseError(__LINE__)
28479978c97eSdrh #define SQLITE_CANTOPEN_BKPT sqlite3CantopenError(__LINE__)
28489978c97eSdrh 
284949285708Sdrh 
285049285708Sdrh /*
2851b4a1fed2Sdrh ** FTS4 is really an extension for FTS3.  It is enabled using the
2852b4a1fed2Sdrh ** SQLITE_ENABLE_FTS3 macro.  But to avoid confusion we also all
2853b4a1fed2Sdrh ** the SQLITE_ENABLE_FTS4 macro to serve as an alisse for SQLITE_ENABLE_FTS3.
2854b4a1fed2Sdrh */
2855b4a1fed2Sdrh #if defined(SQLITE_ENABLE_FTS4) && !defined(SQLITE_ENABLE_FTS3)
2856b4a1fed2Sdrh # define SQLITE_ENABLE_FTS3
2857b4a1fed2Sdrh #endif
2858b4a1fed2Sdrh 
2859b4a1fed2Sdrh /*
286079f02cefSdrh ** The ctype.h header is needed for non-ASCII systems.  It is also
286179f02cefSdrh ** needed by FTS3 when FTS3 is included in the amalgamation.
286279f02cefSdrh */
286379f02cefSdrh #if !defined(SQLITE_ASCII) || \
286479f02cefSdrh     (defined(SQLITE_ENABLE_FTS3) && defined(SQLITE_AMALGAMATION))
286579f02cefSdrh # include <ctype.h>
286679f02cefSdrh #endif
286779f02cefSdrh 
286879f02cefSdrh /*
286978ca0e7eSdanielk1977 ** The following macros mimic the standard library functions toupper(),
287078ca0e7eSdanielk1977 ** isspace(), isalnum(), isdigit() and isxdigit(), respectively. The
287178ca0e7eSdanielk1977 ** sqlite versions only work for ASCII characters, regardless of locale.
287278ca0e7eSdanielk1977 */
287378ca0e7eSdanielk1977 #ifdef SQLITE_ASCII
287478ca0e7eSdanielk1977 # define sqlite3Toupper(x)  ((x)&~(sqlite3CtypeMap[(unsigned char)(x)]&0x20))
287578ca0e7eSdanielk1977 # define sqlite3Isspace(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x01)
2876dc86e2b2Sdrh # define sqlite3Isalnum(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x06)
2877dc86e2b2Sdrh # define sqlite3Isalpha(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x02)
287878ca0e7eSdanielk1977 # define sqlite3Isdigit(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x04)
287978ca0e7eSdanielk1977 # define sqlite3Isxdigit(x)  (sqlite3CtypeMap[(unsigned char)(x)]&0x08)
288078ca0e7eSdanielk1977 # define sqlite3Tolower(x)   (sqlite3UpperToLower[(unsigned char)(x)])
288178ca0e7eSdanielk1977 #else
288278ca0e7eSdanielk1977 # define sqlite3Toupper(x)   toupper((unsigned char)(x))
288378ca0e7eSdanielk1977 # define sqlite3Isspace(x)   isspace((unsigned char)(x))
288478ca0e7eSdanielk1977 # define sqlite3Isalnum(x)   isalnum((unsigned char)(x))
2885dc86e2b2Sdrh # define sqlite3Isalpha(x)   isalpha((unsigned char)(x))
288678ca0e7eSdanielk1977 # define sqlite3Isdigit(x)   isdigit((unsigned char)(x))
288778ca0e7eSdanielk1977 # define sqlite3Isxdigit(x)  isxdigit((unsigned char)(x))
288878ca0e7eSdanielk1977 # define sqlite3Tolower(x)   tolower((unsigned char)(x))
288978ca0e7eSdanielk1977 #endif
289078ca0e7eSdanielk1977 
289178ca0e7eSdanielk1977 /*
289275897234Sdrh ** Internal function prototypes
289375897234Sdrh */
28943fa97302Sdrh #define sqlite3StrICmp sqlite3_stricmp
2895ea678832Sdrh int sqlite3Strlen30(const char*);
2896ee0484c1Sdanielk1977 #define sqlite3StrNICmp sqlite3_strnicmp
28972e588c75Sdanielk1977 
289840257ffdSdrh int sqlite3MallocInit(void);
2899fec00eabSdrh void sqlite3MallocEnd(void);
2900fec00eabSdrh void *sqlite3Malloc(int);
2901fec00eabSdrh void *sqlite3MallocZero(int);
2902fec00eabSdrh void *sqlite3DbMallocZero(sqlite3*, int);
2903fec00eabSdrh void *sqlite3DbMallocRaw(sqlite3*, int);
290417435752Sdrh char *sqlite3DbStrDup(sqlite3*,const char*);
290517435752Sdrh char *sqlite3DbStrNDup(sqlite3*,const char*, int);
2906fec00eabSdrh void *sqlite3Realloc(void*, int);
290797c8ec32Sdrh void *sqlite3DbReallocOrFree(sqlite3 *, void *, int);
2908a1644fd8Sdanielk1977 void *sqlite3DbRealloc(sqlite3 *, void *, int);
2909633e6d57Sdrh void sqlite3DbFree(sqlite3*, void*);
2910a7a8e14bSdanielk1977 int sqlite3MallocSize(void*);
2911633e6d57Sdrh int sqlite3DbMallocSize(sqlite3*, void*);
2912facf0307Sdrh void *sqlite3ScratchMalloc(int);
2913facf0307Sdrh void sqlite3ScratchFree(void*);
2914facf0307Sdrh void *sqlite3PageMalloc(int);
2915facf0307Sdrh void sqlite3PageFree(void*);
2916fec00eabSdrh void sqlite3MemSetDefault(void);
2917171bfed3Sdanielk1977 void sqlite3BenignMallocHooks(void (*)(void), void (*)(void));
291850d1b5f3Sdrh int sqlite3HeapNearlyFull(void);
29192e588c75Sdanielk1977 
2920e7b34707Sdrh /*
2921e7b34707Sdrh ** On systems with ample stack space and that support alloca(), make
2922e7b34707Sdrh ** use of alloca() to obtain space for large automatic objects.  By default,
2923e7b34707Sdrh ** obtain space from malloc().
2924e7b34707Sdrh **
2925e7b34707Sdrh ** The alloca() routine never returns NULL.  This will cause code paths
2926e7b34707Sdrh ** that deal with sqlite3StackAlloc() failures to be unreachable.
2927e7b34707Sdrh */
2928e7b34707Sdrh #ifdef SQLITE_USE_ALLOCA
2929e7b34707Sdrh # define sqlite3StackAllocRaw(D,N)   alloca(N)
2930e7b34707Sdrh # define sqlite3StackAllocZero(D,N)  memset(alloca(N), 0, N)
2931e7b34707Sdrh # define sqlite3StackFree(D,P)
2932e7b34707Sdrh #else
2933e7b34707Sdrh # define sqlite3StackAllocRaw(D,N)   sqlite3DbMallocRaw(D,N)
2934e7b34707Sdrh # define sqlite3StackAllocZero(D,N)  sqlite3DbMallocZero(D,N)
2935e7b34707Sdrh # define sqlite3StackFree(D,P)       sqlite3DbFree(D,P)
2936e7b34707Sdrh #endif
2937e7b34707Sdrh 
2938f3d3c27aSdanielk1977 #ifdef SQLITE_ENABLE_MEMSYS3
2939f3d3c27aSdanielk1977 const sqlite3_mem_methods *sqlite3MemGetMemsys3(void);
2940f3d3c27aSdanielk1977 #endif
2941f3d3c27aSdanielk1977 #ifdef SQLITE_ENABLE_MEMSYS5
2942f3d3c27aSdanielk1977 const sqlite3_mem_methods *sqlite3MemGetMemsys5(void);
2943f3d3c27aSdanielk1977 #endif
2944f3d3c27aSdanielk1977 
2945f3d3c27aSdanielk1977 
294618472fa7Sdrh #ifndef SQLITE_MUTEX_OMIT
2947558814f8Sdan   sqlite3_mutex_methods const *sqlite3DefaultMutex(void);
2948558814f8Sdan   sqlite3_mutex_methods const *sqlite3NoopMutex(void);
294959f8c08eSdanielk1977   sqlite3_mutex *sqlite3MutexAlloc(int);
2950d025174fSdanielk1977   int sqlite3MutexInit(void);
2951d025174fSdanielk1977   int sqlite3MutexEnd(void);
295265bbf29eSdrh #endif
29536d2ab0e4Sdanielk1977 
2954f7141990Sdrh int sqlite3StatusValue(int);
2955f7141990Sdrh void sqlite3StatusAdd(int, int);
2956f7141990Sdrh void sqlite3StatusSet(int, int);
2957f7141990Sdrh 
295885c8f291Sdrh #ifndef SQLITE_OMIT_FLOATING_POINT
29590de3ae95Sdrh   int sqlite3IsNaN(double);
296085c8f291Sdrh #else
296185c8f291Sdrh # define sqlite3IsNaN(X)  0
296285c8f291Sdrh #endif
29630de3ae95Sdrh 
2964a5c1416dSdrh /*
2965a5c1416dSdrh ** An instance of the following structure holds information about SQL
2966a5c1416dSdrh ** functions arguments that are the parameters to the printf() function.
2967a5c1416dSdrh */
2968a5c1416dSdrh struct PrintfArguments {
2969a5c1416dSdrh   int nArg;                /* Total number of arguments */
2970a5c1416dSdrh   int nUsed;               /* Number of arguments used so far */
2971a5c1416dSdrh   sqlite3_value **apArg;   /* The argument values */
2972a5c1416dSdrh };
2973a5c1416dSdrh 
2974a5c1416dSdrh #define SQLITE_PRINTF_INTERNAL 0x01
2975a5c1416dSdrh #define SQLITE_PRINTF_SQLFUNC  0x02
2976a5c1416dSdrh void sqlite3VXPrintf(StrAccum*, u32, const char*, va_list);
2977a5c1416dSdrh void sqlite3XPrintf(StrAccum*, u32, const char*, ...);
297817435752Sdrh char *sqlite3MPrintf(sqlite3*,const char*, ...);
297917435752Sdrh char *sqlite3VMPrintf(sqlite3*,const char*, va_list);
2980633e6d57Sdrh char *sqlite3MAppendf(sqlite3*,char*,const char*,...);
298187cc3b31Sdrh #if defined(SQLITE_TEST) || defined(SQLITE_DEBUG)
2982e54ca3feSdrh   void sqlite3DebugPrintf(const char*, ...);
2983d919fe17Sdrh #endif
2984d919fe17Sdrh #if defined(SQLITE_TEST)
2985e8f52c50Sdrh   void *sqlite3TestTextToPtr(const char*);
298687cc3b31Sdrh #endif
29877e02e5e6Sdrh 
29887e02e5e6Sdrh /* Output formatting for SQLITE_TESTCTRL_EXPLAIN */
2989678a9aa7Sdrh #if defined(SQLITE_ENABLE_TREE_EXPLAIN)
29907e02e5e6Sdrh   void sqlite3ExplainBegin(Vdbe*);
29917e02e5e6Sdrh   void sqlite3ExplainPrintf(Vdbe*, const char*, ...);
29927e02e5e6Sdrh   void sqlite3ExplainNL(Vdbe*);
29937e02e5e6Sdrh   void sqlite3ExplainPush(Vdbe*);
29947e02e5e6Sdrh   void sqlite3ExplainPop(Vdbe*);
29957e02e5e6Sdrh   void sqlite3ExplainFinish(Vdbe*);
29967e02e5e6Sdrh   void sqlite3ExplainSelect(Vdbe*, Select*);
29977e02e5e6Sdrh   void sqlite3ExplainExpr(Vdbe*, Expr*);
29987e02e5e6Sdrh   void sqlite3ExplainExprList(Vdbe*, ExprList*);
29997e02e5e6Sdrh   const char *sqlite3VdbeExplanation(Vdbe*);
30007e02e5e6Sdrh #else
30017e02e5e6Sdrh # define sqlite3ExplainBegin(X)
30027e02e5e6Sdrh # define sqlite3ExplainSelect(A,B)
30037e02e5e6Sdrh # define sqlite3ExplainExpr(A,B)
30047e02e5e6Sdrh # define sqlite3ExplainExprList(A,B)
30057e02e5e6Sdrh # define sqlite3ExplainFinish(X)
30067e02e5e6Sdrh # define sqlite3VdbeExplanation(X) 0
30077e02e5e6Sdrh #endif
30087e02e5e6Sdrh 
30097e02e5e6Sdrh 
3010f089aa45Sdrh void sqlite3SetString(char **, sqlite3*, const char*, ...);
30114adee20fSdanielk1977 void sqlite3ErrorMsg(Parse*, const char*, ...);
301224fb627aSdrh int sqlite3Dequote(char*);
30132646da7eSdrh int sqlite3KeywordCode(const unsigned char*, int);
30144adee20fSdanielk1977 int sqlite3RunParser(Parse*, const char*, char **);
301580242055Sdrh void sqlite3FinishCoding(Parse*);
3016892d3179Sdrh int sqlite3GetTempReg(Parse*);
3017892d3179Sdrh void sqlite3ReleaseTempReg(Parse*,int);
3018892d3179Sdrh int sqlite3GetTempRange(Parse*,int);
3019892d3179Sdrh void sqlite3ReleaseTempRange(Parse*,int,int);
3020cdc69557Sdrh void sqlite3ClearTempRegCache(Parse*);
3021b7916a78Sdrh Expr *sqlite3ExprAlloc(sqlite3*,int,const Token*,int);
3022b7916a78Sdrh Expr *sqlite3Expr(sqlite3*,int,const char*);
3023b7916a78Sdrh void sqlite3ExprAttachSubtrees(sqlite3*,Expr*,Expr*,Expr*);
302417435752Sdrh Expr *sqlite3PExpr(Parse*, int, Expr*, Expr*, const Token*);
30251e536953Sdanielk1977 Expr *sqlite3ExprAnd(sqlite3*,Expr*, Expr*);
302617435752Sdrh Expr *sqlite3ExprFunction(Parse*,ExprList*, Token*);
3027fa6bc000Sdrh void sqlite3ExprAssignVarNumber(Parse*, Expr*);
3028633e6d57Sdrh void sqlite3ExprDelete(sqlite3*, Expr*);
3029b7916a78Sdrh ExprList *sqlite3ExprListAppend(Parse*,ExprList*,Expr*);
3030b7916a78Sdrh void sqlite3ExprListSetName(Parse*,ExprList*,Token*,int);
3031b7916a78Sdrh void sqlite3ExprListSetSpan(Parse*,ExprList*,ExprSpan*);
3032633e6d57Sdrh void sqlite3ExprListDelete(sqlite3*, ExprList*);
30339bb575fdSdrh int sqlite3Init(sqlite3*, char**);
3034234c39dfSdrh int sqlite3InitCallback(void*, int, char**, char**);
303591cf71b0Sdanielk1977 void sqlite3Pragma(Parse*,Token*,Token*,Token*,int);
303681028a45Sdrh void sqlite3ResetAllSchemasOfConnection(sqlite3*);
303781028a45Sdrh void sqlite3ResetOneSchema(sqlite3*,int);
303881028a45Sdrh void sqlite3CollapseDatabaseArray(sqlite3*);
30394adee20fSdanielk1977 void sqlite3BeginParse(Parse*,int);
30409bb575fdSdrh void sqlite3CommitInternalChanges(sqlite3*);
30417d10d5a6Sdrh Table *sqlite3ResultSetOfSelect(Parse*,Select*);
3042c00da105Sdanielk1977 void sqlite3OpenMasterTable(Parse *, int);
30434415628aSdrh Index *sqlite3PrimaryKeyIndex(Table*);
30444415628aSdrh i16 sqlite3ColumnOfIndex(Index*, i16);
3045f1a381e7Sdanielk1977 void sqlite3StartTable(Parse*,Token*,Token*,int,int,int,int);
30464adee20fSdanielk1977 void sqlite3AddColumn(Parse*,Token*);
30474adee20fSdanielk1977 void sqlite3AddNotNull(Parse*, int);
3048fdd6e85aSdrh void sqlite3AddPrimaryKey(Parse*, ExprList*, int, int, int);
3049ffe07b2dSdrh void sqlite3AddCheckConstraint(Parse*, Expr*);
3050487e262fSdrh void sqlite3AddColumnType(Parse*,Token*);
3051b7916a78Sdrh void sqlite3AddDefaultValue(Parse*,ExprSpan*);
305239002505Sdanielk1977 void sqlite3AddCollateType(Parse*, Token*);
30535969da4aSdrh void sqlite3EndTable(Parse*,Token*,Token*,u8,Select*);
3054522c26fbSdrh int sqlite3ParseUri(const char*,const char*,unsigned int*,
3055522c26fbSdrh                     sqlite3_vfs**,char**,char **);
3056421377e6Sdrh Btree *sqlite3DbNameToBtree(sqlite3*,const char*);
30571d8cb21fSdan int sqlite3CodeOnce(Parse *);
3058b7f9164eSdrh 
3059c007f61bSdrh #ifdef SQLITE_OMIT_BUILTIN_TEST
3060c007f61bSdrh # define sqlite3FaultSim(X) SQLITE_OK
3061c007f61bSdrh #else
3062c007f61bSdrh   int sqlite3FaultSim(int);
3063c007f61bSdrh #endif
3064c007f61bSdrh 
3065f5e7bb51Sdrh Bitvec *sqlite3BitvecCreate(u32);
3066f5e7bb51Sdrh int sqlite3BitvecTest(Bitvec*, u32);
3067f5e7bb51Sdrh int sqlite3BitvecSet(Bitvec*, u32);
3068e98c9049Sdrh void sqlite3BitvecClear(Bitvec*, u32, void*);
3069f5e7bb51Sdrh void sqlite3BitvecDestroy(Bitvec*);
3070bea2a948Sdanielk1977 u32 sqlite3BitvecSize(Bitvec*);
30713088d59eSdrh int sqlite3BitvecBuiltinTest(int,int*);
3072f5e7bb51Sdrh 
30733d4501e5Sdrh RowSet *sqlite3RowSetInit(sqlite3*, void*, unsigned int);
30743d4501e5Sdrh void sqlite3RowSetClear(RowSet*);
30753d4501e5Sdrh void sqlite3RowSetInsert(RowSet*, i64);
3076d83cad23Sdrh int sqlite3RowSetTest(RowSet*, int iBatch, i64);
30773d4501e5Sdrh int sqlite3RowSetNext(RowSet*, i64*);
30783d4501e5Sdrh 
3079fdd48a76Sdrh void sqlite3CreateView(Parse*,Token*,Token*,Token*,Select*,int,int);
3080fe3fcbe2Sdanielk1977 
3081fe3fcbe2Sdanielk1977 #if !defined(SQLITE_OMIT_VIEW) || !defined(SQLITE_OMIT_VIRTUALTABLE)
30824adee20fSdanielk1977   int sqlite3ViewGetColumnNames(Parse*,Table*);
3083b7f9164eSdrh #else
3084b7f9164eSdrh # define sqlite3ViewGetColumnNames(A,B) 0
3085b7f9164eSdrh #endif
3086b7f9164eSdrh 
3087a7ab6d81Sdrh #if SQLITE_MAX_ATTACHED>30
3088a7ab6d81Sdrh   int sqlite3DbMaskAllZero(yDbMask);
3089a7ab6d81Sdrh #endif
3090a073384fSdrh void sqlite3DropTable(Parse*, SrcList*, int, int);
3091faacf17cSdrh void sqlite3CodeDropTable(Parse*, Table*, int, int);
30921feeaed2Sdan void sqlite3DeleteTable(sqlite3*, Table*);
30930b9f50d8Sdrh #ifndef SQLITE_OMIT_AUTOINCREMENT
30940b9f50d8Sdrh   void sqlite3AutoincrementBegin(Parse *pParse);
30950b9f50d8Sdrh   void sqlite3AutoincrementEnd(Parse *pParse);
30960b9f50d8Sdrh #else
30970b9f50d8Sdrh # define sqlite3AutoincrementBegin(X)
30980b9f50d8Sdrh # define sqlite3AutoincrementEnd(X)
30990b9f50d8Sdrh #endif
310075593d96Sdrh void sqlite3Insert(Parse*, SrcList*, Select*, IdList*, int);
31016c535158Sdrh void *sqlite3ArrayAllocate(sqlite3*,void*,int,int*,int*);
310217435752Sdrh IdList *sqlite3IdListAppend(sqlite3*, IdList*, Token*);
31034adee20fSdanielk1977 int sqlite3IdListIndex(IdList*,const char*);
3104a78c22c4Sdrh SrcList *sqlite3SrcListEnlarge(sqlite3*, SrcList*, int, int);
310517435752Sdrh SrcList *sqlite3SrcListAppend(sqlite3*, SrcList*, Token*, Token*);
3106b1c685b0Sdanielk1977 SrcList *sqlite3SrcListAppendFromTerm(Parse*, SrcList*, Token*, Token*,
310785574e31Sdanielk1977                                       Token*, Select*, Expr*, IdList*);
3108b1c685b0Sdanielk1977 void sqlite3SrcListIndexedBy(Parse *, SrcList *, Token *);
3109b1c685b0Sdanielk1977 int sqlite3IndexedByLookup(Parse *, struct SrcList_item *);
311061dfc31dSdrh void sqlite3SrcListShiftJoinType(SrcList*);
31114adee20fSdanielk1977 void sqlite3SrcListAssignCursors(Parse*, SrcList*);
3112633e6d57Sdrh void sqlite3IdListDelete(sqlite3*, IdList*);
3113633e6d57Sdrh void sqlite3SrcListDelete(sqlite3*, SrcList*);
3114bbbdc83bSdrh Index *sqlite3AllocateIndexObject(sqlite3*,i16,int,char**);
31151da40a38Sdan Index *sqlite3CreateIndex(Parse*,Token*,Token*,SrcList*,ExprList*,int,Token*,
31168a9789b6Sdrh                           Expr*, int, int);
31174d91a701Sdrh void sqlite3DropIndex(Parse*, SrcList*, int);
31187d10d5a6Sdrh int sqlite3Select(Parse*, Select*, SelectDest*);
311917435752Sdrh Select *sqlite3SelectNew(Parse*,ExprList*,SrcList*,Expr*,ExprList*,
3120832ee3d4Sdrh                          Expr*,ExprList*,u16,Expr*,Expr*);
3121633e6d57Sdrh void sqlite3SelectDelete(sqlite3*, Select*);
31224adee20fSdanielk1977 Table *sqlite3SrcListLookup(Parse*, SrcList*);
31234adee20fSdanielk1977 int sqlite3IsReadOnly(Parse*, Table*, int);
3124c00da105Sdanielk1977 void sqlite3OpenTable(Parse*, int iCur, int iDb, Table*, int);
3125273f619bSshane #if defined(SQLITE_ENABLE_UPDATE_DELETE_LIMIT) && !defined(SQLITE_OMIT_SUBQUERY)
312649ffdbf4Sshane Expr *sqlite3LimitWhere(Parse*,SrcList*,Expr*,ExprList*,Expr*,Expr*,char*);
31274281bd42Sshane #endif
31284adee20fSdanielk1977 void sqlite3DeleteFrom(Parse*, SrcList*, Expr*);
31294adee20fSdanielk1977 void sqlite3Update(Parse*, SrcList*, ExprList*, Expr*, int);
313046ec5b63Sdrh WhereInfo *sqlite3WhereBegin(Parse*,SrcList*,Expr*,ExprList*,ExprList*,u16,int);
31314adee20fSdanielk1977 void sqlite3WhereEnd(WhereInfo*);
3132c63367efSdrh u64 sqlite3WhereOutputRowCount(WhereInfo*);
31336f32848dSdrh int sqlite3WhereIsDistinct(WhereInfo*);
31346f32848dSdrh int sqlite3WhereIsOrdered(WhereInfo*);
3135374cd78cSdan int sqlite3WhereIsSorted(WhereInfo*);
31366f32848dSdrh int sqlite3WhereContinueLabel(WhereInfo*);
31376f32848dSdrh int sqlite3WhereBreakLabel(WhereInfo*);
3138fc8d4f96Sdrh int sqlite3WhereOkOnePass(WhereInfo*, int*);
3139a748fdccSdrh int sqlite3ExprCodeGetColumn(Parse*, Table*, int, int, int, u8);
31405c092e8aSdrh void sqlite3ExprCodeGetColumnOfTable(Vdbe*, Table*, int, int, int);
3141b21e7c70Sdrh void sqlite3ExprCodeMove(Parse*, int, int, int);
3142ceea3321Sdrh void sqlite3ExprCacheStore(Parse*, int, int, int);
3143ceea3321Sdrh void sqlite3ExprCachePush(Parse*);
3144d2490904Sdrh void sqlite3ExprCachePop(Parse*);
3145f49f3523Sdrh void sqlite3ExprCacheRemove(Parse*, int, int);
3146ceea3321Sdrh void sqlite3ExprCacheClear(Parse*);
3147da250ea5Sdrh void sqlite3ExprCacheAffinityChange(Parse*, int, int);
314805a86c5cSdrh void sqlite3ExprCode(Parse*, Expr*, int);
314905a86c5cSdrh void sqlite3ExprCodeFactorable(Parse*, Expr*, int);
3150d673cddaSdrh void sqlite3ExprCodeAtInit(Parse*, Expr*, int, u8);
31512dcef11bSdrh int sqlite3ExprCodeTemp(Parse*, Expr*, int*);
3152678ccce8Sdrh int sqlite3ExprCodeTarget(Parse*, Expr*, int);
315305a86c5cSdrh void sqlite3ExprCodeAndCache(Parse*, Expr*, int);
3154d1a01edaSdrh int sqlite3ExprCodeExprList(Parse*, ExprList*, int, u8);
3155d1a01edaSdrh #define SQLITE_ECEL_DUP      0x01  /* Deep, not shallow copies */
3156d1a01edaSdrh #define SQLITE_ECEL_FACTOR   0x02  /* Factor out constant terms */
31574adee20fSdanielk1977 void sqlite3ExprIfTrue(Parse*, Expr*, int, int);
31584adee20fSdanielk1977 void sqlite3ExprIfFalse(Parse*, Expr*, int, int);
31599bb575fdSdrh Table *sqlite3FindTable(sqlite3*,const char*, const char*);
3160ca424114Sdrh Table *sqlite3LocateTable(Parse*,int isView,const char*, const char*);
316141fb5cd1Sdan Table *sqlite3LocateTableItem(Parse*,int isView,struct SrcList_item *);
31629bb575fdSdrh Index *sqlite3FindIndex(sqlite3*,const char*, const char*);
31639bb575fdSdrh void sqlite3UnlinkAndDeleteTable(sqlite3*,int,const char*);
31649bb575fdSdrh void sqlite3UnlinkAndDeleteIndex(sqlite3*,int,const char*);
316574161705Sdrh void sqlite3Vacuum(Parse*);
31669bb575fdSdrh int sqlite3RunVacuum(char**, sqlite3*);
316717435752Sdrh char *sqlite3NameFromToken(sqlite3*, Token*);
3168619a1305Sdrh int sqlite3ExprCompare(Expr*, Expr*, int);
3169619a1305Sdrh int sqlite3ExprListCompare(ExprList*, ExprList*, int);
31704bd5f73fSdrh int sqlite3ExprImpliesExpr(Expr*, Expr*, int);
3171d2b3e23bSdrh void sqlite3ExprAnalyzeAggregates(NameContext*, Expr*);
3172d2b3e23bSdrh void sqlite3ExprAnalyzeAggList(NameContext*,ExprList*);
3173030796dfSdrh int sqlite3FunctionUsesThisSrc(Expr*, SrcList*);
31744adee20fSdanielk1977 Vdbe *sqlite3GetVdbe(Parse*);
31752fa1868fSdrh void sqlite3PrngSaveState(void);
31762fa1868fSdrh void sqlite3PrngRestoreState(void);
31770f198a74Sdrh void sqlite3RollbackAll(sqlite3*,int);
31784adee20fSdanielk1977 void sqlite3CodeVerifySchema(Parse*, int);
317957966753Sdan void sqlite3CodeVerifyNamedSchema(Parse*, const char *zDb);
3180684917c2Sdrh void sqlite3BeginTransaction(Parse*, int);
31814adee20fSdanielk1977 void sqlite3CommitTransaction(Parse*);
31824adee20fSdanielk1977 void sqlite3RollbackTransaction(Parse*);
3183fd7f0452Sdanielk1977 void sqlite3Savepoint(Parse*, int, Token*);
3184fd7f0452Sdanielk1977 void sqlite3CloseSavepoints(sqlite3 *);
31854245c405Sdrh void sqlite3LeaveMutexAndCloseZombie(sqlite3*);
31864adee20fSdanielk1977 int sqlite3ExprIsConstant(Expr*);
31870a168377Sdrh int sqlite3ExprIsConstantNotJoin(Expr*);
3188eb55bd2fSdrh int sqlite3ExprIsConstantOrFunction(Expr*);
31894adee20fSdanielk1977 int sqlite3ExprIsInteger(Expr*, int*);
3190039fc32eSdrh int sqlite3ExprCanBeNull(const Expr*);
3191039fc32eSdrh int sqlite3ExprNeedsNoAffinityChange(const Expr*, char);
31924adee20fSdanielk1977 int sqlite3IsRowid(const char*);
3193392ee21dSdrh void sqlite3GenerateRowDelete(Parse*,Table*,Trigger*,int,int,int,i16,u8,u8,u8);
319426198bb4Sdrh void sqlite3GenerateRowIndexDelete(Parse*, Table*, int, int, int*);
31951c2c0b77Sdrh int sqlite3GenerateIndexKey(Parse*, Index*, int, int, int, int*,Index*,int);
319687744513Sdrh void sqlite3ResolvePartIdxLabel(Parse*,int);
3197f8ffb278Sdrh void sqlite3GenerateConstraintChecks(Parse*,Table*,int*,int,int,int,int,
3198f8ffb278Sdrh                                      u8,u8,int,int*);
319926198bb4Sdrh void sqlite3CompleteInsertion(Parse*,Table*,int,int,int,int*,int,int,int);
32006a53499aSdrh int sqlite3OpenTableAndIndices(Parse*, Table*, int, int, u8*, int*, int*);
32014adee20fSdanielk1977 void sqlite3BeginWriteOperation(Parse*, int, int);
3202ff738bceSdrh void sqlite3MultiWrite(Parse*);
3203e0af83acSdan void sqlite3MayAbort(Parse*);
3204f9c8ce3cSdrh void sqlite3HaltConstraint(Parse*, int, int, char*, i8, u8);
3205f9c8ce3cSdrh void sqlite3UniqueConstraint(Parse*, int, Index*);
3206f9c8ce3cSdrh void sqlite3RowidConstraint(Parse*, int, Table*);
32076ab3a2ecSdanielk1977 Expr *sqlite3ExprDup(sqlite3*,Expr*,int);
32086ab3a2ecSdanielk1977 ExprList *sqlite3ExprListDup(sqlite3*,ExprList*,int);
32096ab3a2ecSdanielk1977 SrcList *sqlite3SrcListDup(sqlite3*,SrcList*,int);
321017435752Sdrh IdList *sqlite3IdListDup(sqlite3*,IdList*);
32116ab3a2ecSdanielk1977 Select *sqlite3SelectDup(sqlite3*,Select*,int);
321270a8ca3cSdrh void sqlite3FuncDefInsert(FuncDefHash*, FuncDef*);
321389d5d6a2Sdrh FuncDef *sqlite3FindFunction(sqlite3*,const char*,int,int,u8,u8);
32149bb575fdSdrh void sqlite3RegisterBuiltinFunctions(sqlite3*);
3215777c5386Sdrh void sqlite3RegisterDateTimeFunctions(void);
321670a8ca3cSdrh void sqlite3RegisterGlobalFunctions(void);
32177e8b848aSdrh int sqlite3SafetyCheckOk(sqlite3*);
32187e8b848aSdrh int sqlite3SafetyCheckSickOrOk(sqlite3*);
32199cbf3425Sdrh void sqlite3ChangeCookie(Parse*, int);
3220fa4e62f3Sshane 
3221fa4e62f3Sshane #if !defined(SQLITE_OMIT_VIEW) && !defined(SQLITE_OMIT_TRIGGER)
32222a5d825eSdrh void sqlite3MaterializeView(Parse*, Table*, Expr*, int);
3223fa4e62f3Sshane #endif
3224b7f9164eSdrh 
3225b7f9164eSdrh #ifndef SQLITE_OMIT_TRIGGER
3226ef2cb63eSdanielk1977   void sqlite3BeginTrigger(Parse*, Token*,Token*,int,int,IdList*,SrcList*,
322760218d2aSdrh                            Expr*,int, int);
32284adee20fSdanielk1977   void sqlite3FinishTrigger(Parse*, TriggerStep*, Token*);
3229fdd48a76Sdrh   void sqlite3DropTrigger(Parse*, SrcList*, int);
323074161705Sdrh   void sqlite3DropTriggerPtr(Parse*, Trigger*);
32312f886d1dSdanielk1977   Trigger *sqlite3TriggersExist(Parse *, Table*, int, ExprList*, int *pMask);
32322f886d1dSdanielk1977   Trigger *sqlite3TriggerList(Parse *, Table *);
3233165921a7Sdan   void sqlite3CodeRowTrigger(Parse*, Trigger *, int, ExprList*, int, Table *,
323494d7f50aSdan                             int, int, int);
32351da40a38Sdan   void sqlite3CodeRowTriggerDirect(Parse *, Trigger *, Table *, int, int, int);
3236dc379456Sdrh   void sqliteViewTriggers(Parse*, Table*, Expr*, int, ExprList*);
3237633e6d57Sdrh   void sqlite3DeleteTriggerStep(sqlite3*, TriggerStep*);
323817435752Sdrh   TriggerStep *sqlite3TriggerSelectStep(sqlite3*,Select*);
323917435752Sdrh   TriggerStep *sqlite3TriggerInsertStep(sqlite3*,Token*, IdList*,
324075593d96Sdrh                                         Select*,u8);
32415eff7cf0Sshane   TriggerStep *sqlite3TriggerUpdateStep(sqlite3*,Token*,ExprList*, Expr*, u8);
324217435752Sdrh   TriggerStep *sqlite3TriggerDeleteStep(sqlite3*,Token*, Expr*);
3243633e6d57Sdrh   void sqlite3DeleteTrigger(sqlite3*, Trigger*);
3244b7f9164eSdrh   void sqlite3UnlinkAndDeleteTrigger(sqlite3*,int,const char*);
3245bb5f168fSdan   u32 sqlite3TriggerColmask(Parse*,Trigger*,ExprList*,int,int,Table*,int);
324665a7cd16Sdan # define sqlite3ParseToplevel(p) ((p)->pToplevel ? (p)->pToplevel : (p))
3247b7f9164eSdrh #else
324862c14b34Sdanielk1977 # define sqlite3TriggersExist(B,C,D,E,F) 0
3249633e6d57Sdrh # define sqlite3DeleteTrigger(A,B)
3250cdd536f0Sdrh # define sqlite3DropTriggerPtr(A,B)
3251b7f9164eSdrh # define sqlite3UnlinkAndDeleteTrigger(A,B,C)
325294d7f50aSdan # define sqlite3CodeRowTrigger(A,B,C,D,E,F,G,H,I)
325375cbd984Sdan # define sqlite3CodeRowTriggerDirect(A,B,C,D,E,F)
32542943c372Sdanielk1977 # define sqlite3TriggerList(X, Y) 0
325565a7cd16Sdan # define sqlite3ParseToplevel(p) p
3256bb5f168fSdan # define sqlite3TriggerColmask(A,B,C,D,E,F,G) 0
3257b7f9164eSdrh #endif
3258b7f9164eSdrh 
32594adee20fSdanielk1977 int sqlite3JoinType(Parse*, Token*, Token*, Token*);
32600202b29eSdanielk1977 void sqlite3CreateForeignKey(Parse*, ExprList*, Token*, ExprList*, int);
32614adee20fSdanielk1977 void sqlite3DeferForeignKey(Parse*, int);
3262ed6c8671Sdrh #ifndef SQLITE_OMIT_AUTHORIZATION
3263728b5779Sdrh   void sqlite3AuthRead(Parse*,Expr*,Schema*,SrcList*);
32644adee20fSdanielk1977   int sqlite3AuthCheck(Parse*,int, const char*, const char*, const char*);
32654adee20fSdanielk1977   void sqlite3AuthContextPush(Parse*, AuthContext*, const char*);
32664adee20fSdanielk1977   void sqlite3AuthContextPop(AuthContext*);
326702470b20Sdan   int sqlite3AuthReadCol(Parse*, const char *, const char *, int);
3268ed6c8671Sdrh #else
3269b5258c3dSdanielk1977 # define sqlite3AuthRead(a,b,c,d)
32704adee20fSdanielk1977 # define sqlite3AuthCheck(a,b,c,d,e)    SQLITE_OK
32714adee20fSdanielk1977 # define sqlite3AuthContextPush(a,b,c)
32724adee20fSdanielk1977 # define sqlite3AuthContextPop(a)  ((void)(a))
3273ed6c8671Sdrh #endif
3274f744bb56Sdanielk1977 void sqlite3Attach(Parse*, Expr*, Expr*, Expr*);
3275f744bb56Sdanielk1977 void sqlite3Detach(Parse*, Expr*);
3276d100f691Sdrh void sqlite3FixInit(DbFixer*, Parse*, int, const char*, const Token*);
32774adee20fSdanielk1977 int sqlite3FixSrcList(DbFixer*, SrcList*);
32784adee20fSdanielk1977 int sqlite3FixSelect(DbFixer*, Select*);
32794adee20fSdanielk1977 int sqlite3FixExpr(DbFixer*, Expr*);
32804adee20fSdanielk1977 int sqlite3FixExprList(DbFixer*, ExprList*);
32814adee20fSdanielk1977 int sqlite3FixTriggerStep(DbFixer*, TriggerStep*);
32829339da1fSdrh int sqlite3AtoF(const char *z, double*, int, u8);
3283fec19aadSdrh int sqlite3GetInt32(const char *, int*);
328460ac3f42Sdrh int sqlite3Atoi(const char*);
3285ee85813cSdrh int sqlite3Utf16ByteLen(const void *pData, int nChar);
3286ee85813cSdrh int sqlite3Utf8CharLen(const char *pData, int nByte);
328742610961Sdrh u32 sqlite3Utf8Read(const u8**);
3288bf539c4dSdrh LogEst sqlite3LogEst(u64);
3289bf539c4dSdrh LogEst sqlite3LogEstAdd(LogEst,LogEst);
3290bf539c4dSdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
3291bf539c4dSdrh LogEst sqlite3LogEstFromDouble(double);
3292bf539c4dSdrh #endif
3293bf539c4dSdrh u64 sqlite3LogEstToInt(LogEst);
32943f8d5cfcSshane 
32953f8d5cfcSshane /*
32963f8d5cfcSshane ** Routines to read and write variable-length integers.  These used to
32973f8d5cfcSshane ** be defined locally, but now we use the varint routines in the util.c
3298952856adSshane ** file.  Code should use the MACRO forms below, as the Varint32 versions
3299952856adSshane ** are coded to assume the single byte case is already handled (which
3300952856adSshane ** the MACRO form does).
33013f8d5cfcSshane */
3302192ac1dcSdanielk1977 int sqlite3PutVarint(unsigned char*, u64);
330335b5a33eSdrh int sqlite3PutVarint32(unsigned char*, u32);
33041bd10f8aSdrh u8 sqlite3GetVarint(const unsigned char *, u64 *);
33051bd10f8aSdrh u8 sqlite3GetVarint32(const unsigned char *, u32 *);
3306192ac1dcSdanielk1977 int sqlite3VarintLen(u64 v);
33073f8d5cfcSshane 
33083f8d5cfcSshane /*
33093f8d5cfcSshane ** The header of a record consists of a sequence variable-length integers.
33103f8d5cfcSshane ** These integers are almost always small and are encoded as a single byte.
33113f8d5cfcSshane ** The following macros take advantage this fact to provide a fast encode
33123f8d5cfcSshane ** and decode of the integers in a record header.  It is faster for the common
33133f8d5cfcSshane ** case where the integer is a single byte.  It is a little slower when the
33143f8d5cfcSshane ** integer is two or more bytes.  But overall it is faster.
33153f8d5cfcSshane **
33163f8d5cfcSshane ** The following expressions are equivalent:
33173f8d5cfcSshane **
33183f8d5cfcSshane **     x = sqlite3GetVarint32( A, &B );
33193f8d5cfcSshane **     x = sqlite3PutVarint32( A, B );
33203f8d5cfcSshane **
33213f8d5cfcSshane **     x = getVarint32( A, B );
33223f8d5cfcSshane **     x = putVarint32( A, B );
33233f8d5cfcSshane **
33243f8d5cfcSshane */
33254bde3702Sdrh #define getVarint32(A,B)  \
33264bde3702Sdrh   (u8)((*(A)<(u8)0x80)?((B)=(u32)*(A)),1:sqlite3GetVarint32((A),(u32 *)&(B)))
33274bde3702Sdrh #define putVarint32(A,B)  \
33284bde3702Sdrh   (u8)(((u32)(B)<(u32)0x80)?(*(A)=(unsigned char)(B)),1:\
33294bde3702Sdrh   sqlite3PutVarint32((A),(B)))
33303f8d5cfcSshane #define getVarint    sqlite3GetVarint
33313f8d5cfcSshane #define putVarint    sqlite3PutVarint
33323f8d5cfcSshane 
33333f8d5cfcSshane 
333469f8bb9cSdan const char *sqlite3IndexAffinityStr(Vdbe *, Index *);
333557bf4a8eSdrh void sqlite3TableAffinity(Vdbe*, Table*, int);
3336e014a838Sdanielk1977 char sqlite3CompareAffinity(Expr *pExpr, char aff2);
3337e014a838Sdanielk1977 int sqlite3IndexAffinityOk(Expr *pExpr, char idx_affinity);
3338bf3b721fSdanielk1977 char sqlite3ExprAffinity(Expr *pExpr);
33399339da1fSdrh int sqlite3Atoi64(const char*, i64*, int, u8);
33409296c18aSdrh int sqlite3DecOrHexToI64(const char*, i64*);
33419bb575fdSdrh void sqlite3Error(sqlite3*, int, const char*,...);
3342ca48c90fSdrh void *sqlite3HexToBlob(sqlite3*, const char *z, int n);
3343cd74b611Sdan u8 sqlite3HexToInt(int h);
3344ef2cb63eSdanielk1977 int sqlite3TwoPartName(Parse *, Token *, Token *, Token **);
3345dd08ca0fSmistachkin 
3346685e3c48Sdrh #if defined(SQLITE_TEST)
3347f2c1c99fSmistachkin const char *sqlite3ErrName(int);
3348dd08ca0fSmistachkin #endif
3349dd08ca0fSmistachkin 
3350f20b21c8Sdanielk1977 const char *sqlite3ErrStr(int);
33518a41449eSdanielk1977 int sqlite3ReadSchema(Parse *pParse);
3352c4a64facSdrh CollSeq *sqlite3FindCollSeq(sqlite3*,u8 enc, const char*,int);
3353c4a64facSdrh CollSeq *sqlite3LocateCollSeq(Parse *pParse, const char*zName);
33547cedc8d4Sdanielk1977 CollSeq *sqlite3ExprCollSeq(Parse *pParse, Expr *pExpr);
33554ef7efadSdrh Expr *sqlite3ExprAddCollateToken(Parse *pParse, Expr*, const Token*);
33560a8a406eSdrh Expr *sqlite3ExprAddCollateString(Parse*,Expr*,const char*);
33570a8a406eSdrh Expr *sqlite3ExprSkipCollate(Expr*);
33587cedc8d4Sdanielk1977 int sqlite3CheckCollSeq(Parse *, CollSeq *);
3359d8123366Sdanielk1977 int sqlite3CheckObjectName(Parse *, const char *);
3360b28af71aSdanielk1977 void sqlite3VdbeSetChanges(sqlite3 *, int);
3361158b9cb9Sdrh int sqlite3AddInt64(i64*,i64);
3362158b9cb9Sdrh int sqlite3SubInt64(i64*,i64);
3363158b9cb9Sdrh int sqlite3MulInt64(i64*,i64);
3364d50ffc41Sdrh int sqlite3AbsInt32(int);
336581cc5163Sdrh #ifdef SQLITE_ENABLE_8_3_NAMES
336681cc5163Sdrh void sqlite3FileSuffix3(const char*, char*);
336781cc5163Sdrh #else
336881cc5163Sdrh # define sqlite3FileSuffix3(X,Y)
336981cc5163Sdrh #endif
3370eac5bd78Sdrh u8 sqlite3GetBoolean(const char *z,u8);
33714e6af134Sdanielk1977 
3372b21c8cd4Sdrh const void *sqlite3ValueText(sqlite3_value*, u8);
3373b21c8cd4Sdrh int sqlite3ValueBytes(sqlite3_value*, u8);
3374b21c8cd4Sdrh void sqlite3ValueSetStr(sqlite3_value*, int, const void *,u8,
33751e536953Sdanielk1977                         void(*)(void*));
3376a3cc007dSdrh void sqlite3ValueSetNull(sqlite3_value*);
33774e6af134Sdanielk1977 void sqlite3ValueFree(sqlite3_value*);
33781e536953Sdanielk1977 sqlite3_value *sqlite3ValueNew(sqlite3 *);
3379b7dca7d7Sdan char *sqlite3Utf16to8(sqlite3 *, const void*, int, u8);
33801e536953Sdanielk1977 int sqlite3ValueFromExpr(sqlite3 *, Expr *, u8, u8, sqlite3_value **);
3381b21c8cd4Sdrh void sqlite3ValueApplyAffinity(sqlite3_value *, u8, u8);
338246c99e0fSdrh #ifndef SQLITE_AMALGAMATION
3383a6c2ed91Sdrh extern const unsigned char sqlite3OpcodeProperty[];
33844e5ffc5fSdrh extern const unsigned char sqlite3UpperToLower[];
338578ca0e7eSdanielk1977 extern const unsigned char sqlite3CtypeMap[];
3386094430ebSdrh extern const Token sqlite3IntTokens[];
3387075c23afSdanielk1977 extern SQLITE_WSD struct Sqlite3Config sqlite3Config;
3388075c23afSdanielk1977 extern SQLITE_WSD FuncDefHash sqlite3GlobalFunctions;
3389f83dc1efSdrh #ifndef SQLITE_OMIT_WSD
3390ddb68e17Sdrh extern int sqlite3PendingByte;
339146c99e0fSdrh #endif
3392f83dc1efSdrh #endif
3393cdf011dcSdrh void sqlite3RootPageMoved(sqlite3*, int, int, int);
33944343fea2Sdrh void sqlite3Reindex(Parse*, Token*, Token*);
3395545f587fSdrh void sqlite3AlterFunctions(void);
33969fd2a9a0Sdanielk1977 void sqlite3AlterRenameTable(Parse*, SrcList*, Token*);
33979fd2a9a0Sdanielk1977 int sqlite3GetToken(const unsigned char *, int *);
33982958a4e6Sdrh void sqlite3NestedParse(Parse*, const char*, ...);
3399d89bd007Sdrh void sqlite3ExpirePreparedStatements(sqlite3*);
34001450bc6eSdrh int sqlite3CodeSubselect(Parse *, Expr *, int, int);
34017d10d5a6Sdrh void sqlite3SelectPrep(Parse*, Select*, NameContext*);
34023e3f1a5bSdrh int sqlite3MatchSpanName(const char*, const char*, const char*, const char*);
34037d10d5a6Sdrh int sqlite3ResolveExprNames(NameContext*, Expr*);
34047d10d5a6Sdrh void sqlite3ResolveSelectNames(Parse*, Select*, NameContext*);
34053780be11Sdrh void sqlite3ResolveSelfReference(Parse*,Table*,int,Expr*,ExprList*);
34067d10d5a6Sdrh int sqlite3ResolveOrderGroupBy(Parse*, Select*, ExprList*, const char*);
3407c7538b5fSdanielk1977 void sqlite3ColumnDefault(Vdbe *, Table *, int, int);
340819a8e7e8Sdanielk1977 void sqlite3AlterFinishAddColumn(Parse *, Token *);
340919a8e7e8Sdanielk1977 void sqlite3AlterBeginAddColumn(Parse *, SrcList *);
341079e72a50Sdrh CollSeq *sqlite3GetCollSeq(Parse*, u8, CollSeq *, const char*);
3411fdaac671Sdrh char sqlite3AffinityType(const char*, u8*);
34129f18e8a0Sdrh void sqlite3Analyze(Parse*, Token*, Token*);
3413a4afb65cSdrh int sqlite3InvokeBusyHandler(BusyHandler*);
3414ff2d5ea4Sdrh int sqlite3FindDb(sqlite3*, Token*);
34150410302eSdanielk1977 int sqlite3FindDbName(sqlite3 *, const char *);
3416cf1be45fSdrh int sqlite3AnalysisLoad(sqlite3*,int iDB);
3417d46def77Sdan void sqlite3DeleteIndexSamples(sqlite3*,Index*);
341851147baaSdrh void sqlite3DefaultRowEst(Index*);
341955ef4d97Sdrh void sqlite3RegisterLikeFunctions(sqlite3*, int);
3420d64fe2f3Sdrh int sqlite3IsLikeFunction(sqlite3*,Expr*,int*,char*);
3421fdd6e85aSdrh void sqlite3MinimumFileFormat(Parse*, int, int);
3422b6ee6607Sdrh void sqlite3SchemaClear(void *);
34231e536953Sdanielk1977 Schema *sqlite3SchemaGet(sqlite3 *, Btree *);
3424e501b89aSdanielk1977 int sqlite3SchemaToIndex(sqlite3 *db, Schema *);
3425ad124329Sdrh KeyInfo *sqlite3KeyInfoAlloc(sqlite3*,int,int);
34262ec2fb22Sdrh void sqlite3KeyInfoUnref(KeyInfo*);
34272ec2fb22Sdrh KeyInfo *sqlite3KeyInfoRef(KeyInfo*);
34282ec2fb22Sdrh KeyInfo *sqlite3KeyInfoOfIndex(Parse*, Index*);
34292ec2fb22Sdrh #ifdef SQLITE_DEBUG
34302ec2fb22Sdrh int sqlite3KeyInfoIsWriteable(KeyInfo*);
34312ec2fb22Sdrh #endif
3432771151b6Sdanielk1977 int sqlite3CreateFunc(sqlite3 *, const char *, int, int, void *,
3433771151b6Sdanielk1977   void (*)(sqlite3_context*,int,sqlite3_value **),
3434d2199f0fSdan   void (*)(sqlite3_context*,int,sqlite3_value **), void (*)(sqlite3_context*),
3435d2199f0fSdan   FuncDestructor *pDestructor
3436d2199f0fSdan );
343754f0198eSdanielk1977 int sqlite3ApiExit(sqlite3 *db, int);
3438ddfb2f03Sdanielk1977 int sqlite3OpenTempDatabase(Parse *);
343969dab1d3Sdrh 
3440f089aa45Sdrh void sqlite3StrAccumInit(StrAccum*, char*, int, int);
3441ade86483Sdrh void sqlite3StrAccumAppend(StrAccum*,const char*,int);
3442a6353a3fSdrh void sqlite3StrAccumAppendAll(StrAccum*,const char*);
34437e02e5e6Sdrh void sqlite3AppendSpace(StrAccum*,int);
3444ade86483Sdrh char *sqlite3StrAccumFinish(StrAccum*);
3445ade86483Sdrh void sqlite3StrAccumReset(StrAccum*);
34461013c932Sdrh void sqlite3SelectDestInit(SelectDest*,int,int);
3447f7b0b0adSdan Expr *sqlite3CreateColumnExpr(sqlite3 *, SrcList *, int, int);
34481e536953Sdanielk1977 
34490410302eSdanielk1977 void sqlite3BackupRestart(sqlite3_backup *);
34500410302eSdanielk1977 void sqlite3BackupUpdate(sqlite3_backup *, Pgno, const u8 *);
34510410302eSdanielk1977 
34521435a9a1Sdrh #ifdef SQLITE_ENABLE_STAT3_OR_STAT4
34539fecc546Sdrh void sqlite3AnalyzeFunctions(void);
345487cd9321Sdan int sqlite3Stat4ProbeSetValue(Parse*,Index*,UnpackedRecord**,Expr*,u8,int,int*);
3455b0b8290eSdan int sqlite3Stat4ValueFromExpr(Parse*, Expr*, u8, sqlite3_value**);
34567a419235Sdan void sqlite3Stat4ProbeFree(UnpackedRecord*);
3457b0b8290eSdan int sqlite3Stat4Column(sqlite3*, const void*, int, int, sqlite3_value**);
34589fecc546Sdrh #endif
34597a419235Sdan 
346095bdbbbdSdrh /*
346195bdbbbdSdrh ** The interface to the LEMON-generated parser
346295bdbbbdSdrh */
346395bdbbbdSdrh void *sqlite3ParserAlloc(void*(*)(size_t));
346495bdbbbdSdrh void sqlite3ParserFree(void*, void(*)(void*));
346595bdbbbdSdrh void sqlite3Parser(void*, int, Token, Parse*);
3466ec424a5bSdrh #ifdef YYTRACKMAXSTACKDEPTH
3467ec424a5bSdrh   int sqlite3ParserStackPeak(void*);
3468ec424a5bSdrh #endif
346995bdbbbdSdrh 
34707aaa8786Sdrh void sqlite3AutoLoadExtensions(sqlite3*);
347169dab1d3Sdrh #ifndef SQLITE_OMIT_LOAD_EXTENSION
3472f1952c5dSdrh   void sqlite3CloseExtensions(sqlite3*);
347369dab1d3Sdrh #else
347469dab1d3Sdrh # define sqlite3CloseExtensions(X)
347569dab1d3Sdrh #endif
3476e3026636Sdanielk1977 
3477c00da105Sdanielk1977 #ifndef SQLITE_OMIT_SHARED_CACHE
3478c00da105Sdanielk1977   void sqlite3TableLock(Parse *, int, int, u8, const char *);
3479c00da105Sdanielk1977 #else
3480c00da105Sdanielk1977   #define sqlite3TableLock(v,w,x,y,z)
3481c00da105Sdanielk1977 #endif
3482c00da105Sdanielk1977 
348353c14021Sdrh #ifdef SQLITE_TEST
348453c14021Sdrh   int sqlite3Utf8To8(unsigned char*);
348553c14021Sdrh #endif
348653c14021Sdrh 
3487b9bb7c18Sdrh #ifdef SQLITE_OMIT_VIRTUALTABLE
3488595a523aSdanielk1977 #  define sqlite3VtabClear(Y)
34899dbee7dcSdanielk1977 #  define sqlite3VtabSync(X,Y) SQLITE_OK
3490f9e7dda7Sdanielk1977 #  define sqlite3VtabRollback(X)
3491f9e7dda7Sdanielk1977 #  define sqlite3VtabCommit(X)
3492093e0f6fSdanielk1977 #  define sqlite3VtabInSync(db) 0
3493595a523aSdanielk1977 #  define sqlite3VtabLock(X)
3494595a523aSdanielk1977 #  define sqlite3VtabUnlock(X)
3495595a523aSdanielk1977 #  define sqlite3VtabUnlockList(X)
3496a311b803Sdan #  define sqlite3VtabSavepoint(X, Y, Z) SQLITE_OK
3497c3c8dac7Sdrh #  define sqlite3GetVTable(X,Y)  ((VTable*)0)
3498b9bb7c18Sdrh #else
34991feeaed2Sdan    void sqlite3VtabClear(sqlite3 *db, Table*);
3500bba02a95Sdan    void sqlite3VtabDisconnect(sqlite3 *db, Table *p);
3501016f7811Sdan    int sqlite3VtabSync(sqlite3 *db, Vdbe*);
3502f9e7dda7Sdanielk1977    int sqlite3VtabRollback(sqlite3 *db);
3503f9e7dda7Sdanielk1977    int sqlite3VtabCommit(sqlite3 *db);
3504595a523aSdanielk1977    void sqlite3VtabLock(VTable *);
3505595a523aSdanielk1977    void sqlite3VtabUnlock(VTable *);
3506595a523aSdanielk1977    void sqlite3VtabUnlockList(sqlite3*);
3507a311b803Sdan    int sqlite3VtabSavepoint(sqlite3 *, int, int);
3508016f7811Sdan    void sqlite3VtabImportErrmsg(Vdbe*, sqlite3_vtab*);
3509c3c8dac7Sdrh    VTable *sqlite3GetVTable(sqlite3*, Table*);
3510093e0f6fSdanielk1977 #  define sqlite3VtabInSync(db) ((db)->nVTrans>0 && (db)->aVTrans==0)
3511b9bb7c18Sdrh #endif
35124f3dd150Sdrh void sqlite3VtabMakeWritable(Parse*,Table*);
3513b421b894Sdrh void sqlite3VtabBeginParse(Parse*, Token*, Token*, Token*, int);
3514b9bb7c18Sdrh void sqlite3VtabFinishParse(Parse*, Token*);
3515b9bb7c18Sdrh void sqlite3VtabArgInit(Parse*);
3516b9bb7c18Sdrh void sqlite3VtabArgExtend(Parse*, Token*);
351778efaba1Sdanielk1977 int sqlite3VtabCallCreate(sqlite3*, int, const char *, char **);
35187e6ebfb2Sdanielk1977 int sqlite3VtabCallConnect(Parse*, Table*);
35199e39ce87Sdanielk1977 int sqlite3VtabCallDestroy(sqlite3*, int, const char *);
3520595a523aSdanielk1977 int sqlite3VtabBegin(sqlite3 *, VTable *);
35211e536953Sdanielk1977 FuncDef *sqlite3VtabOverloadFunction(sqlite3 *,FuncDef*, int nArg, Expr*);
3522b7481e70Sdrh void sqlite3InvalidFunction(sqlite3_context*,int,sqlite3_value**);
352395a7b3e3Sdrh sqlite3_int64 sqlite3StmtCurrentTime(sqlite3_context*);
35245f18a221Sdrh int sqlite3VdbeParameterIndex(Vdbe*, const char*, int);
35254a27a286Sshane int sqlite3TransferBindings(sqlite3_stmt *, sqlite3_stmt *);
3526f30a969bSdrh void sqlite3ParserReset(Parse*);
3527b900aaf3Sdrh int sqlite3Reprepare(Vdbe*);
3528b1a6c3c1Sdrh void sqlite3ExprListCheckLength(Parse*, ExprList*, const char*);
3529bcbb04e5Sdanielk1977 CollSeq *sqlite3BinaryCompareCollSeq(Parse *, Expr *, Expr *);
35301c514148Sdrh int sqlite3TempInMemory(const sqlite3*);
353128e5386fSdan const char *sqlite3JournalModename(int);
353206a2d825Sdan #ifndef SQLITE_OMIT_WAL
3533cdc1f049Sdan   int sqlite3Checkpoint(sqlite3*, int, int, int*, int*);
3534b033d8b9Sdrh   int sqlite3WalDefaultHook(void*,sqlite3*,const char*,int);
353506a2d825Sdan #endif
35368b471863Sdrh #ifndef SQLITE_OMIT_CTE
35374e9119d9Sdan   With *sqlite3WithAdd(Parse*,With*,Token*,ExprList*,Select*);
35387d562dbeSdan   void sqlite3WithDelete(sqlite3*,With*);
3539b290f117Sdan   void sqlite3WithPush(Parse*, With*, u8);
35404e9119d9Sdan #else
3541b290f117Sdan #define sqlite3WithPush(x,y,z)
3542eede6a53Sdan #define sqlite3WithDelete(x,y)
35438b471863Sdrh #endif
3544d829335eSdanielk1977 
354575cbd984Sdan /* Declarations for functions in fkey.c. All of these are replaced by
354675cbd984Sdan ** no-op macros if OMIT_FOREIGN_KEY is defined. In this case no foreign
354775cbd984Sdan ** key functionality is available. If OMIT_TRIGGER is defined but
354875cbd984Sdan ** OMIT_FOREIGN_KEY is not, only some of the functions are no-oped. In
354975cbd984Sdan ** this case foreign keys are parsed, but no other functionality is
355075cbd984Sdan ** provided (enforcement of FK constraints requires the triggers sub-system).
355175cbd984Sdan */
355275cbd984Sdan #if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
35538ff2d956Sdan   void sqlite3FkCheck(Parse*, Table*, int, int, int*, int);
3554d66c8309Sdan   void sqlite3FkDropTable(Parse*, SrcList *, Table*);
35558ff2d956Sdan   void sqlite3FkActions(Parse*, Table*, ExprList*, int, int*, int);
3556e7a94d81Sdan   int sqlite3FkRequired(Parse*, Table*, int*, int);
3557e7a94d81Sdan   u32 sqlite3FkOldmask(Parse*, Table*);
3558432cc5b9Sdan   FKey *sqlite3FkReferences(Table *);
35591da40a38Sdan #else
35608ff2d956Sdan   #define sqlite3FkActions(a,b,c,d,e,f)
356167896cefSdan   #define sqlite3FkCheck(a,b,c,d,e,f)
3562d66c8309Sdan   #define sqlite3FkDropTable(a,b,c)
3563e7a94d81Sdan   #define sqlite3FkOldmask(a,b)         0
356467896cefSdan   #define sqlite3FkRequired(a,b,c,d)    0
35651da40a38Sdan #endif
356675cbd984Sdan #ifndef SQLITE_OMIT_FOREIGN_KEY
35671feeaed2Sdan   void sqlite3FkDelete(sqlite3 *, Table*);
35686c5b915fSdrh   int sqlite3FkLocateIndex(Parse*,Table*,FKey*,Index**,int**);
356975cbd984Sdan #else
35701feeaed2Sdan   #define sqlite3FkDelete(a,b)
35716c5b915fSdrh   #define sqlite3FkLocateIndex(a,b,c,d,e)
357275cbd984Sdan #endif
357375cbd984Sdan 
3574643167ffSdrh 
3575643167ffSdrh /*
3576643167ffSdrh ** Available fault injectors.  Should be numbered beginning with 0.
3577643167ffSdrh */
3578643167ffSdrh #define SQLITE_FAULTINJECTOR_MALLOC     0
35797e8b848aSdrh #define SQLITE_FAULTINJECTOR_COUNT      1
3580643167ffSdrh 
3581643167ffSdrh /*
3582ef05f2dfSdanielk1977 ** The interface to the code in fault.c used for identifying "benign"
3583ef05f2dfSdanielk1977 ** malloc failures. This is only present if SQLITE_OMIT_BUILTIN_TEST
3584ef05f2dfSdanielk1977 ** is not defined.
3585643167ffSdrh */
35863088d59eSdrh #ifndef SQLITE_OMIT_BUILTIN_TEST
35872d1d86fbSdanielk1977   void sqlite3BeginBenignMalloc(void);
35882d1d86fbSdanielk1977   void sqlite3EndBenignMalloc(void);
3589643167ffSdrh #else
35902d1d86fbSdanielk1977   #define sqlite3BeginBenignMalloc()
3591867d05a0Sdanielk1977   #define sqlite3EndBenignMalloc()
3592643167ffSdrh #endif
3593643167ffSdrh 
35943a85625dSdrh /*
35953a85625dSdrh ** Allowed return values from sqlite3FindInIndex()
35963a85625dSdrh */
35973a85625dSdrh #define IN_INDEX_ROWID        1   /* Search the rowid of the table */
35983a85625dSdrh #define IN_INDEX_EPH          2   /* Search an ephemeral b-tree */
35993a85625dSdrh #define IN_INDEX_INDEX_ASC    3   /* Existing index ASCENDING */
36003a85625dSdrh #define IN_INDEX_INDEX_DESC   4   /* Existing index DESCENDING */
3601*bb53ecb1Sdrh #define IN_INDEX_NOOP         5   /* No table available. Use comparisons */
36023a85625dSdrh /*
36033a85625dSdrh ** Allowed flags for the 3rd parameter to sqlite3FindInIndex().
36043a85625dSdrh */
3605*bb53ecb1Sdrh #define IN_INDEX_NOOP_OK     0x0001  /* OK to return IN_INDEX_NOOP */
3606*bb53ecb1Sdrh #define IN_INDEX_MEMBERSHIP  0x0002  /* IN operator used for membership test */
3607*bb53ecb1Sdrh #define IN_INDEX_LOOP        0x0004  /* IN operator used as a loop */
36083a85625dSdrh int sqlite3FindInIndex(Parse *, Expr *, u32, int*);
36099a96b668Sdanielk1977 
3610c7b6017cSdanielk1977 #ifdef SQLITE_ENABLE_ATOMIC_WRITE
3611c7b6017cSdanielk1977   int sqlite3JournalOpen(sqlite3_vfs *, const char *, sqlite3_file *, int, int);
3612c7b6017cSdanielk1977   int sqlite3JournalSize(sqlite3_vfs *);
3613f55b8998Sdanielk1977   int sqlite3JournalCreate(sqlite3_file *);
36143de0f184Sdan   int sqlite3JournalExists(sqlite3_file *p);
3615c7b6017cSdanielk1977 #else
3616c7b6017cSdanielk1977   #define sqlite3JournalSize(pVfs) ((pVfs)->szOsFile)
36173de0f184Sdan   #define sqlite3JournalExists(p) 1
3618c7b6017cSdanielk1977 #endif
3619c7b6017cSdanielk1977 
3620b3175389Sdanielk1977 void sqlite3MemJournalOpen(sqlite3_file *);
36213a5990abSdrh int sqlite3MemJournalSize(void);
3622b3175389Sdanielk1977 int sqlite3IsMemJournal(sqlite3_file *);
3623b3175389Sdanielk1977 
36240224d26dSdrh #if SQLITE_MAX_EXPR_DEPTH>0
36254b5255acSdanielk1977   void sqlite3ExprSetHeight(Parse *pParse, Expr *p);
3626fc976065Sdanielk1977   int sqlite3SelectExprHeight(Select *);
36277d10d5a6Sdrh   int sqlite3ExprCheckHeight(Parse*, int);
3628fc976065Sdanielk1977 #else
36294b5255acSdanielk1977   #define sqlite3ExprSetHeight(x,y)
36300224d26dSdrh   #define sqlite3SelectExprHeight(x) 0
36317d10d5a6Sdrh   #define sqlite3ExprCheckHeight(x,y)
3632fc976065Sdanielk1977 #endif
3633fc976065Sdanielk1977 
3634a3152895Sdrh u32 sqlite3Get4byte(const u8*);
3635a3152895Sdrh void sqlite3Put4byte(u8*, u32);
3636a3152895Sdrh 
3637404ca075Sdanielk1977 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
3638404ca075Sdanielk1977   void sqlite3ConnectionBlocked(sqlite3 *, sqlite3 *);
3639404ca075Sdanielk1977   void sqlite3ConnectionUnlocked(sqlite3 *db);
3640404ca075Sdanielk1977   void sqlite3ConnectionClosed(sqlite3 *db);
3641404ca075Sdanielk1977 #else
3642404ca075Sdanielk1977   #define sqlite3ConnectionBlocked(x,y)
3643404ca075Sdanielk1977   #define sqlite3ConnectionUnlocked(x)
3644404ca075Sdanielk1977   #define sqlite3ConnectionClosed(x)
3645404ca075Sdanielk1977 #endif
3646404ca075Sdanielk1977 
36476e736838Sdrh #ifdef SQLITE_DEBUG
36486e736838Sdrh   void sqlite3ParserTrace(FILE*, char *);
36496e736838Sdrh #endif
36506e736838Sdrh 
3651b0603416Sdrh /*
3652b0603416Sdrh ** If the SQLITE_ENABLE IOTRACE exists then the global variable
36533a00f907Smlcreech ** sqlite3IoTrace is a pointer to a printf-like routine used to
3654b0603416Sdrh ** print I/O tracing messages.
3655b0603416Sdrh */
3656b0603416Sdrh #ifdef SQLITE_ENABLE_IOTRACE
36573a00f907Smlcreech # define IOTRACE(A)  if( sqlite3IoTrace ){ sqlite3IoTrace A; }
3658b4622b60Sdanielk1977   void sqlite3VdbeIOTraceSql(Vdbe*);
3659e265b084Sdrh SQLITE_EXTERN void (*sqlite3IoTrace)(const char*,...);
3660b0603416Sdrh #else
3661b0603416Sdrh # define IOTRACE(A)
3662b4622b60Sdanielk1977 # define sqlite3VdbeIOTraceSql(X)
3663b0603416Sdrh #endif
3664b0603416Sdrh 
3665107b56e8Sdrh /*
3666107b56e8Sdrh ** These routines are available for the mem2.c debugging memory allocator
3667107b56e8Sdrh ** only.  They are used to verify that different "types" of memory
3668107b56e8Sdrh ** allocations are properly tracked by the system.
3669107b56e8Sdrh **
3670107b56e8Sdrh ** sqlite3MemdebugSetType() sets the "type" of an allocation to one of
3671107b56e8Sdrh ** the MEMTYPE_* macros defined below.  The type must be a bitmask with
3672107b56e8Sdrh ** a single bit set.
3673107b56e8Sdrh **
3674107b56e8Sdrh ** sqlite3MemdebugHasType() returns true if any of the bits in its second
3675107b56e8Sdrh ** argument match the type set by the previous sqlite3MemdebugSetType().
3676107b56e8Sdrh ** sqlite3MemdebugHasType() is intended for use inside assert() statements.
3677107b56e8Sdrh **
3678174b9a16Sdrh ** sqlite3MemdebugNoType() returns true if none of the bits in its second
3679174b9a16Sdrh ** argument match the type set by the previous sqlite3MemdebugSetType().
3680107b56e8Sdrh **
3681107b56e8Sdrh ** Perhaps the most important point is the difference between MEMTYPE_HEAP
3682174b9a16Sdrh ** and MEMTYPE_LOOKASIDE.  If an allocation is MEMTYPE_LOOKASIDE, that means
3683174b9a16Sdrh ** it might have been allocated by lookaside, except the allocation was
3684174b9a16Sdrh ** too large or lookaside was already full.  It is important to verify
3685174b9a16Sdrh ** that allocations that might have been satisfied by lookaside are not
3686174b9a16Sdrh ** passed back to non-lookaside free() routines.  Asserts such as the
3687174b9a16Sdrh ** example above are placed on the non-lookaside free() routines to verify
3688174b9a16Sdrh ** this constraint.
3689107b56e8Sdrh **
3690107b56e8Sdrh ** All of this is no-op for a production build.  It only comes into
3691107b56e8Sdrh ** play when the SQLITE_MEMDEBUG compile-time option is used.
3692107b56e8Sdrh */
3693107b56e8Sdrh #ifdef SQLITE_MEMDEBUG
3694107b56e8Sdrh   void sqlite3MemdebugSetType(void*,u8);
3695107b56e8Sdrh   int sqlite3MemdebugHasType(void*,u8);
3696174b9a16Sdrh   int sqlite3MemdebugNoType(void*,u8);
3697107b56e8Sdrh #else
3698107b56e8Sdrh # define sqlite3MemdebugSetType(X,Y)  /* no-op */
3699107b56e8Sdrh # define sqlite3MemdebugHasType(X,Y)  1
3700174b9a16Sdrh # define sqlite3MemdebugNoType(X,Y)   1
3701e3026636Sdanielk1977 #endif
3702107b56e8Sdrh #define MEMTYPE_HEAP       0x01  /* General heap allocations */
3703174b9a16Sdrh #define MEMTYPE_LOOKASIDE  0x02  /* Might have been lookaside memory */
3704107b56e8Sdrh #define MEMTYPE_SCRATCH    0x04  /* Scratch allocations */
3705107b56e8Sdrh #define MEMTYPE_PCACHE     0x08  /* Page cache allocations */
3706174b9a16Sdrh #define MEMTYPE_DB         0x10  /* Uses sqlite3DbMalloc, not sqlite_malloc */
3707107b56e8Sdrh 
3708107b56e8Sdrh #endif /* _SQLITEINT_H_ */
3709