xref: /sqlite-3.40.0/src/sqliteInt.h (revision 8ff2d956)
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 **
352210dcc6Sdrh ** Similar is true for Mac OS X.  LFS is only supported on Mac OS X 9 and later.
362210dcc6Sdrh */
372210dcc6Sdrh #ifndef SQLITE_DISABLE_LFS
382210dcc6Sdrh # define _LARGE_FILE       1
392210dcc6Sdrh # ifndef _FILE_OFFSET_BITS
402210dcc6Sdrh #   define _FILE_OFFSET_BITS 64
412210dcc6Sdrh # endif
422210dcc6Sdrh # define _LARGEFILE_SOURCE 1
432210dcc6Sdrh #endif
442210dcc6Sdrh 
452210dcc6Sdrh /*
461e12d43bSmlcreech ** Include the configuration header output by 'configure' if we're using the
471e12d43bSmlcreech ** autoconf-based build
48bd0ae111Smlcreech */
491e12d43bSmlcreech #ifdef _HAVE_SQLITE_CONFIG_H
5098dc4b1aSmlcreech #include "config.h"
511e12d43bSmlcreech #endif
521e12d43bSmlcreech 
53bb4957f8Sdrh #include "sqliteLimit.h"
5498dc4b1aSmlcreech 
55e2965827Sdrh /* Disable nuisance warnings on Borland compilers */
56e2965827Sdrh #if defined(__BORLANDC__)
57e2965827Sdrh #pragma warn -rch /* unreachable code */
58e2965827Sdrh #pragma warn -ccc /* Condition is always true or false */
59e2965827Sdrh #pragma warn -aus /* Assigned value is never used */
60e2965827Sdrh #pragma warn -csu /* Comparing signed and unsigned */
61467bcf36Sshane #pragma warn -spa /* Suspicious pointer arithmetic */
62e2965827Sdrh #endif
63e2965827Sdrh 
6498dc4b1aSmlcreech /* Needed for various definitions... */
6560323418Sdrh #ifndef _GNU_SOURCE
6698dc4b1aSmlcreech # define _GNU_SOURCE
6760323418Sdrh #endif
6898dc4b1aSmlcreech 
69881bd792Sdan #if defined(__OpenBSD__) && !defined(_BSD_SOURCE)
70881bd792Sdan # define _BSD_SOURCE
71881bd792Sdan #endif
72881bd792Sdan 
7398dc4b1aSmlcreech /*
7406af763eSdrh ** Include standard header files as necessary
7506af763eSdrh */
7606af763eSdrh #ifdef HAVE_STDINT_H
7706af763eSdrh #include <stdint.h>
7806af763eSdrh #endif
7906af763eSdrh #ifdef HAVE_INTTYPES_H
8006af763eSdrh #include <inttypes.h>
8106af763eSdrh #endif
8206af763eSdrh 
83a2460e07Sdrh /*
84c05a9a8aSdrh ** The following macros are used to cast pointers to integers and
85c05a9a8aSdrh ** integers to pointers.  The way you do this varies from one compiler
86c05a9a8aSdrh ** to the next, so we have developed the following set of #if statements
87c05a9a8aSdrh ** to generate appropriate macros for a wide range of compilers.
88875e9e7dSdrh **
89c05a9a8aSdrh ** The correct "ANSI" way to do this is to use the intptr_t type.
90c05a9a8aSdrh ** Unfortunately, that typedef is not available on all compilers, or
91c05a9a8aSdrh ** if it is available, it requires an #include of specific headers
92c92271c5Sdrh ** that vary from one machine to the next.
93875e9e7dSdrh **
94875e9e7dSdrh ** Ticket #3860:  The llvm-gcc-4.2 compiler from Apple chokes on
95875e9e7dSdrh ** the ((void*)&((char*)0)[X]) construct.  But MSVC chokes on ((void*)(X)).
965e49edcaSdrh ** So we have to define the macros in different ways depending on the
97875e9e7dSdrh ** compiler.
981fc4129dSshane */
99c05a9a8aSdrh #if defined(__PTRDIFF_TYPE__)  /* This case should work for GCC */
100c05a9a8aSdrh # define SQLITE_INT_TO_PTR(X)  ((void*)(__PTRDIFF_TYPE__)(X))
101c05a9a8aSdrh # define SQLITE_PTR_TO_INT(X)  ((int)(__PTRDIFF_TYPE__)(X))
102c05a9a8aSdrh #elif !defined(__GNUC__)       /* Works for compilers other than LLVM */
103c05a9a8aSdrh # define SQLITE_INT_TO_PTR(X)  ((void*)&((char*)0)[X])
104c05a9a8aSdrh # define SQLITE_PTR_TO_INT(X)  ((int)(((char*)X)-(char*)0))
105c05a9a8aSdrh #elif defined(HAVE_STDINT_H)   /* Use this case if we have ANSI headers */
106367882c2Sdrh # define SQLITE_INT_TO_PTR(X)  ((void*)(intptr_t)(X))
107367882c2Sdrh # define SQLITE_PTR_TO_INT(X)  ((int)(intptr_t)(X))
108c05a9a8aSdrh #else                          /* Generates a warning - but it always works */
109875e9e7dSdrh # define SQLITE_INT_TO_PTR(X)  ((void*)(X))
110875e9e7dSdrh # define SQLITE_PTR_TO_INT(X)  ((int)(X))
111367882c2Sdrh #endif
11271674ce9Sdrh 
113e5e7a901Sdrh /*
11438c67c36Sdrh ** The SQLITE_THREADSAFE macro must be defined as 0, 1, or 2.
11538c67c36Sdrh ** 0 means mutexes are permanently disable and the library is never
11638c67c36Sdrh ** threadsafe.  1 means the library is serialized which is the highest
117f7b5496eSdrh ** level of threadsafety.  2 means the library is multithreaded - multiple
11838c67c36Sdrh ** threads can use SQLite as long as no two threads try to use the same
11938c67c36Sdrh ** database connection at the same time.
12038c67c36Sdrh **
121e5e7a901Sdrh ** Older versions of SQLite used an optional THREADSAFE macro.
12238c67c36Sdrh ** We support that for legacy.
123e5e7a901Sdrh */
124e5e7a901Sdrh #if !defined(SQLITE_THREADSAFE)
125e5e7a901Sdrh # if defined(THREADSAFE)
126e5e7a901Sdrh #   define SQLITE_THREADSAFE THREADSAFE
127e5e7a901Sdrh # else
12838c67c36Sdrh #   define SQLITE_THREADSAFE 1 /* IMP: R-07272-22309 */
129e5e7a901Sdrh # endif
130e5e7a901Sdrh #endif
131e5e7a901Sdrh 
13267080617Sdrh /*
133cb15f35fSdrh ** Powersafe overwrite is on by default.  But can be turned off using
134cb15f35fSdrh ** the -DSQLITE_POWERSAFE_OVERWRITE=0 command-line option.
135cb15f35fSdrh */
136cb15f35fSdrh #ifndef SQLITE_POWERSAFE_OVERWRITE
137cb15f35fSdrh # define SQLITE_POWERSAFE_OVERWRITE 1
138cb15f35fSdrh #endif
139cb15f35fSdrh 
140cb15f35fSdrh /*
1410a732f59Sdanielk1977 ** The SQLITE_DEFAULT_MEMSTATUS macro must be defined as either 0 or 1.
1420a732f59Sdanielk1977 ** It determines whether or not the features related to
143467bcf36Sshane ** SQLITE_CONFIG_MEMSTATUS are available by default or not. This value can
1440a732f59Sdanielk1977 ** be overridden at runtime using the sqlite3_config() API.
1450a732f59Sdanielk1977 */
1460a732f59Sdanielk1977 #if !defined(SQLITE_DEFAULT_MEMSTATUS)
1470a732f59Sdanielk1977 # define SQLITE_DEFAULT_MEMSTATUS 1
1480a732f59Sdanielk1977 #endif
1490a732f59Sdanielk1977 
1500a732f59Sdanielk1977 /*
1510d18020bSdrh ** Exactly one of the following macros must be defined in order to
1520d18020bSdrh ** specify which memory allocation subsystem to use.
1530d18020bSdrh **
1540d18020bSdrh **     SQLITE_SYSTEM_MALLOC          // Use normal system malloc()
1551b186a99Smistachkin **     SQLITE_WIN32_MALLOC           // Use Win32 native heap API
156d1b0afc3Sdrh **     SQLITE_ZERO_MALLOC            // Use a stub allocator that always fails
1570d18020bSdrh **     SQLITE_MEMDEBUG               // Debugging version of system malloc()
158a2460e07Sdrh **
159753c5444Smistachkin ** On Windows, if the SQLITE_WIN32_MALLOC_VALIDATE macro is defined and the
160753c5444Smistachkin ** assert() macro is enabled, each call into the Win32 native heap subsystem
161753c5444Smistachkin ** will cause HeapValidate to be called.  If heap validation should fail, an
162753c5444Smistachkin ** assertion will be triggered.
163753c5444Smistachkin **
1640d18020bSdrh ** If none of the above are defined, then set SQLITE_SYSTEM_MALLOC as
1650d18020bSdrh ** the default.
1660d18020bSdrh */
167d1b0afc3Sdrh #if defined(SQLITE_SYSTEM_MALLOC) \
168d1b0afc3Sdrh   + defined(SQLITE_WIN32_MALLOC) \
169d1b0afc3Sdrh   + defined(SQLITE_ZERO_MALLOC) \
170d1b0afc3Sdrh   + defined(SQLITE_MEMDEBUG)>1
171d1b0afc3Sdrh # error "Two or more of the following compile-time configuration options\
17220b1ff07Smistachkin  are defined but at most one is allowed:\
173d1b0afc3Sdrh  SQLITE_SYSTEM_MALLOC, SQLITE_WIN32_MALLOC, SQLITE_MEMDEBUG,\
174d1b0afc3Sdrh  SQLITE_ZERO_MALLOC"
1750d18020bSdrh #endif
176d1b0afc3Sdrh #if defined(SQLITE_SYSTEM_MALLOC) \
177d1b0afc3Sdrh   + defined(SQLITE_WIN32_MALLOC) \
178d1b0afc3Sdrh   + defined(SQLITE_ZERO_MALLOC) \
179d1b0afc3Sdrh   + defined(SQLITE_MEMDEBUG)==0
1800d18020bSdrh # define SQLITE_SYSTEM_MALLOC 1
1810d18020bSdrh #endif
1820d18020bSdrh 
1830d18020bSdrh /*
1848a1e594cSdrh ** If SQLITE_MALLOC_SOFT_LIMIT is not zero, then try to keep the
185eee4c8caSdrh ** sizes of memory allocations below this value where possible.
186eee4c8caSdrh */
1878a1e594cSdrh #if !defined(SQLITE_MALLOC_SOFT_LIMIT)
188eee4c8caSdrh # define SQLITE_MALLOC_SOFT_LIMIT 1024
189eee4c8caSdrh #endif
190eee4c8caSdrh 
191eee4c8caSdrh /*
19267080617Sdrh ** We need to define _XOPEN_SOURCE as follows in order to enable
19340b521f8Sdrh ** recursive mutexes on most Unix systems and fchmod() on OpenBSD.
19440b521f8Sdrh ** But _XOPEN_SOURCE define causes problems for Mac OS X, so omit
19540b521f8Sdrh ** it.
19667080617Sdrh */
19740b521f8Sdrh #if !defined(_XOPEN_SOURCE) && !defined(__DARWIN__) && !defined(__APPLE__)
19840b521f8Sdrh #  define _XOPEN_SOURCE 600
19967080617Sdrh #endif
200e3026636Sdanielk1977 
2017d10d5a6Sdrh /*
2021b28b893Sdrh ** NDEBUG and SQLITE_DEBUG are opposites.  It should always be true that
2031b28b893Sdrh ** defined(NDEBUG)==!defined(SQLITE_DEBUG).  If this is not currently true,
2041b28b893Sdrh ** make it true by defining or undefining NDEBUG.
2051b28b893Sdrh **
206443dbcf5Sdrh ** Setting NDEBUG makes the code smaller and faster by disabling the
207443dbcf5Sdrh ** assert() statements in the code.  So we want the default action
2081b28b893Sdrh ** to be for NDEBUG to be set and NDEBUG to be undefined only if SQLITE_DEBUG
2091b28b893Sdrh ** is set.  Thus NDEBUG becomes an opt-in rather than an opt-out
2104b529d97Sdrh ** feature.
2114b529d97Sdrh */
212289ab076Sdrh #if !defined(NDEBUG) && !defined(SQLITE_DEBUG)
2134b529d97Sdrh # define NDEBUG 1
2144b529d97Sdrh #endif
2151b28b893Sdrh #if defined(NDEBUG) && defined(SQLITE_DEBUG)
2161b28b893Sdrh # undef NDEBUG
2171b28b893Sdrh #endif
2184b529d97Sdrh 
2196402250eSdrh /*
22047c3b3e0Sdrh ** The testcase() macro is used to aid in coverage testing.  When
22147c3b3e0Sdrh ** doing coverage testing, the condition inside the argument to
22247c3b3e0Sdrh ** testcase() must be evaluated both true and false in order to
22347c3b3e0Sdrh ** get full branch coverage.  The testcase() macro is inserted
22447c3b3e0Sdrh ** to help ensure adequate test coverage in places where simple
22547c3b3e0Sdrh ** condition/decision coverage is inadequate.  For example, testcase()
22647c3b3e0Sdrh ** can be used to make sure boundary values are tested.  For
22747c3b3e0Sdrh ** bitmask tests, testcase() can be used to make sure each bit
22847c3b3e0Sdrh ** is significant and used at least once.  On switch statements
22947c3b3e0Sdrh ** where multiple cases go to the same block of code, testcase()
23047c3b3e0Sdrh ** can insure that all cases are evaluated.
23147c3b3e0Sdrh **
23247c3b3e0Sdrh */
23347c3b3e0Sdrh #ifdef SQLITE_COVERAGE_TEST
23447c3b3e0Sdrh   void sqlite3Coverage(int);
23547c3b3e0Sdrh # define testcase(X)  if( X ){ sqlite3Coverage(__LINE__); }
23647c3b3e0Sdrh #else
23747c3b3e0Sdrh # define testcase(X)
2388f941bc7Sdrh #endif
2398f941bc7Sdrh 
2408f941bc7Sdrh /*
2418f941bc7Sdrh ** The TESTONLY macro is used to enclose variable declarations or
2428f941bc7Sdrh ** other bits of code that are needed to support the arguments
2438f941bc7Sdrh ** within testcase() and assert() macros.
2448f941bc7Sdrh */
2458f941bc7Sdrh #if !defined(NDEBUG) || defined(SQLITE_COVERAGE_TEST)
2468f941bc7Sdrh # define TESTONLY(X)  X
2478f941bc7Sdrh #else
24847c3b3e0Sdrh # define TESTONLY(X)
24947c3b3e0Sdrh #endif
25047c3b3e0Sdrh 
25147c3b3e0Sdrh /*
2526149526cSdrh ** Sometimes we need a small amount of code such as a variable initialization
2536149526cSdrh ** to setup for a later assert() statement.  We do not want this code to
2546149526cSdrh ** appear when assert() is disabled.  The following macro is therefore
2556149526cSdrh ** used to contain that setup code.  The "VVA" acronym stands for
2566149526cSdrh ** "Verification, Validation, and Accreditation".  In other words, the
2576149526cSdrh ** code within VVA_ONLY() will only run during verification processes.
2586149526cSdrh */
2596149526cSdrh #ifndef NDEBUG
2606149526cSdrh # define VVA_ONLY(X)  X
2616149526cSdrh #else
2626149526cSdrh # define VVA_ONLY(X)
2636149526cSdrh #endif
2646149526cSdrh 
2656149526cSdrh /*
26647c3b3e0Sdrh ** The ALWAYS and NEVER macros surround boolean expressions which
26747c3b3e0Sdrh ** are intended to always be true or false, respectively.  Such
26847c3b3e0Sdrh ** expressions could be omitted from the code completely.  But they
26947c3b3e0Sdrh ** are included in a few cases in order to enhance the resilience
27047c3b3e0Sdrh ** of SQLite to unexpected behavior - to make the code "self-healing"
27147c3b3e0Sdrh ** or "ductile" rather than being "brittle" and crashing at the first
27247c3b3e0Sdrh ** hint of unplanned behavior.
27347c3b3e0Sdrh **
27447c3b3e0Sdrh ** In other words, ALWAYS and NEVER are added for defensive code.
27547c3b3e0Sdrh **
27647c3b3e0Sdrh ** When doing coverage testing ALWAYS and NEVER are hard-coded to
277443dbcf5Sdrh ** be true and false so that the unreachable code they specify will
27847c3b3e0Sdrh ** not be counted as untested code.
27947c3b3e0Sdrh */
28047c3b3e0Sdrh #if defined(SQLITE_COVERAGE_TEST)
28147c3b3e0Sdrh # define ALWAYS(X)      (1)
28247c3b3e0Sdrh # define NEVER(X)       (0)
28347c3b3e0Sdrh #elif !defined(NDEBUG)
2842de80f4cSdrh # define ALWAYS(X)      ((X)?1:(assert(0),0))
2852de80f4cSdrh # define NEVER(X)       ((X)?(assert(0),1):0)
28647c3b3e0Sdrh #else
28747c3b3e0Sdrh # define ALWAYS(X)      (X)
28847c3b3e0Sdrh # define NEVER(X)       (X)
28947c3b3e0Sdrh #endif
29047c3b3e0Sdrh 
29147c3b3e0Sdrh /*
2923e8e7ecbSdrh ** Return true (non-zero) if the input is a integer that is too large
2933e8e7ecbSdrh ** to fit in 32-bits.  This macro is used inside of various testcase()
2943e8e7ecbSdrh ** macros to verify that we have tested SQLite for large-file support.
2953e8e7ecbSdrh */
296b31a6afaSdan #define IS_BIG_INT(X)  (((X)&~(i64)0xffffffff)!=0)
2973e8e7ecbSdrh 
2983e8e7ecbSdrh /*
29947c3b3e0Sdrh ** The macro unlikely() is a hint that surrounds a boolean
30047c3b3e0Sdrh ** expression that is usually false.  Macro likely() surrounds
301443dbcf5Sdrh ** a boolean expression that is usually true.  These hints could,
302443dbcf5Sdrh ** in theory, be used by the compiler to generate better code, but
303443dbcf5Sdrh ** currently they are just comments for human readers.
30447c3b3e0Sdrh */
305443dbcf5Sdrh #define likely(X)    (X)
306443dbcf5Sdrh #define unlikely(X)  (X)
30747c3b3e0Sdrh 
3081d482dd9Sdrh #include "sqlite3.h"
309beae3194Sdrh #include "hash.h"
31075897234Sdrh #include "parse.h"
31175897234Sdrh #include <stdio.h>
31275897234Sdrh #include <stdlib.h>
31375897234Sdrh #include <string.h>
31475897234Sdrh #include <assert.h>
31552370e2cSdrh #include <stddef.h>
31675897234Sdrh 
317967e8b73Sdrh /*
318b37df7b9Sdrh ** If compiling for a processor that lacks floating point support,
319b37df7b9Sdrh ** substitute integer for floating-point
320b37df7b9Sdrh */
321b37df7b9Sdrh #ifdef SQLITE_OMIT_FLOATING_POINT
322b37df7b9Sdrh # define double sqlite_int64
3238b307fbfSdrh # define float sqlite_int64
324b37df7b9Sdrh # define LONGDOUBLE_TYPE sqlite_int64
325d1167393Sdrh # ifndef SQLITE_BIG_DBL
326cdaca55eSdrh #   define SQLITE_BIG_DBL (((sqlite3_int64)1)<<50)
327d1167393Sdrh # endif
328b37df7b9Sdrh # define SQLITE_OMIT_DATETIME_FUNCS 1
329b37df7b9Sdrh # define SQLITE_OMIT_TRACE 1
330110daac9Sdrh # undef SQLITE_MIXED_ENDIAN_64BIT_FLOAT
3310b3bf924Sdrh # undef SQLITE_HAVE_ISNAN
332b37df7b9Sdrh #endif
333d1167393Sdrh #ifndef SQLITE_BIG_DBL
334d1167393Sdrh # define SQLITE_BIG_DBL (1e99)
335d1167393Sdrh #endif
336b37df7b9Sdrh 
337b37df7b9Sdrh /*
33853c0f748Sdanielk1977 ** OMIT_TEMPDB is set to 1 if SQLITE_OMIT_TEMPDB is defined, or 0
33953c0f748Sdanielk1977 ** afterward. Having this macro allows us to cause the C compiler
34053c0f748Sdanielk1977 ** to omit code used by TEMP tables without messy #ifndef statements.
34153c0f748Sdanielk1977 */
34253c0f748Sdanielk1977 #ifdef SQLITE_OMIT_TEMPDB
34353c0f748Sdanielk1977 #define OMIT_TEMPDB 1
34453c0f748Sdanielk1977 #else
34553c0f748Sdanielk1977 #define OMIT_TEMPDB 0
34653c0f748Sdanielk1977 #endif
34753c0f748Sdanielk1977 
34853c0f748Sdanielk1977 /*
349d946db00Sdrh ** The "file format" number is an integer that is incremented whenever
350d946db00Sdrh ** the VDBE-level file format changes.  The following macros define the
351d946db00Sdrh ** the default file format for new databases and the maximum file format
352d946db00Sdrh ** that the library can read.
353d946db00Sdrh */
354d946db00Sdrh #define SQLITE_MAX_FILE_FORMAT 4
355d946db00Sdrh #ifndef SQLITE_DEFAULT_FILE_FORMAT
356bf3f5f8dSdrh # define SQLITE_DEFAULT_FILE_FORMAT 4
357d946db00Sdrh #endif
358d946db00Sdrh 
359a2460e07Sdrh /*
360a2460e07Sdrh ** Determine whether triggers are recursive by default.  This can be
361a2460e07Sdrh ** changed at run-time using a pragma.
362a2460e07Sdrh */
3635bde73c4Sdan #ifndef SQLITE_DEFAULT_RECURSIVE_TRIGGERS
3645bde73c4Sdan # define SQLITE_DEFAULT_RECURSIVE_TRIGGERS 0
3655bde73c4Sdan #endif
3665bde73c4Sdan 
367d946db00Sdrh /*
368b06a0b67Sdanielk1977 ** Provide a default value for SQLITE_TEMP_STORE in case it is not specified
36949766d6cSdrh ** on the command-line
37049766d6cSdrh */
371b06a0b67Sdanielk1977 #ifndef SQLITE_TEMP_STORE
372b06a0b67Sdanielk1977 # define SQLITE_TEMP_STORE 1
373d16d0bc5Sdrh # define SQLITE_TEMP_STORE_xc 1  /* Exclude from ctime.c */
37449766d6cSdrh #endif
37549766d6cSdrh 
37649766d6cSdrh /*
377f1974846Sdrh ** GCC does not define the offsetof() macro so we'll have to do it
378f1974846Sdrh ** ourselves.
379f1974846Sdrh */
380f1974846Sdrh #ifndef offsetof
381f1974846Sdrh #define offsetof(STRUCTURE,FIELD) ((int)((char*)&((STRUCTURE*)0)->FIELD))
382f1974846Sdrh #endif
383f1974846Sdrh 
384f1974846Sdrh /*
385e1e2e9acSdrh ** Macros to compute minimum and maximum of two numbers.
386e1e2e9acSdrh */
387e1e2e9acSdrh #define MIN(A,B) ((A)<(B)?(A):(B))
388e1e2e9acSdrh #define MAX(A,B) ((A)>(B)?(A):(B))
389e1e2e9acSdrh 
390e1e2e9acSdrh /*
3919b8f447bSdrh ** Check to see if this machine uses EBCDIC.  (Yes, believe it or
3929b8f447bSdrh ** not, there are still machines out there that use EBCDIC.)
3939b8f447bSdrh */
3949b8f447bSdrh #if 'A' == '\301'
3959b8f447bSdrh # define SQLITE_EBCDIC 1
3969b8f447bSdrh #else
3979b8f447bSdrh # define SQLITE_ASCII 1
3989b8f447bSdrh #endif
3999b8f447bSdrh 
4009b8f447bSdrh /*
4015a2c2c20Sdrh ** Integers of known sizes.  These typedefs might change for architectures
4025a2c2c20Sdrh ** where the sizes very.  Preprocessor macros are available so that the
4035a2c2c20Sdrh ** types can be conveniently redefined at compile-type.  Like this:
4045a2c2c20Sdrh **
4055a2c2c20Sdrh **         cc '-DUINTPTR_TYPE=long long int' ...
40641a2b48bSdrh */
4075a2c2c20Sdrh #ifndef UINT32_TYPE
408dda5b68cSmlcreech # ifdef HAVE_UINT32_T
409dda5b68cSmlcreech #  define UINT32_TYPE uint32_t
410dda5b68cSmlcreech # else
4115a2c2c20Sdrh #  define UINT32_TYPE unsigned int
4125a2c2c20Sdrh # endif
413dda5b68cSmlcreech #endif
4145a2c2c20Sdrh #ifndef UINT16_TYPE
415dda5b68cSmlcreech # ifdef HAVE_UINT16_T
416dda5b68cSmlcreech #  define UINT16_TYPE uint16_t
417dda5b68cSmlcreech # else
4185a2c2c20Sdrh #  define UINT16_TYPE unsigned short int
4195a2c2c20Sdrh # endif
420dda5b68cSmlcreech #endif
421939a16d6Sdrh #ifndef INT16_TYPE
422dda5b68cSmlcreech # ifdef HAVE_INT16_T
423dda5b68cSmlcreech #  define INT16_TYPE int16_t
424dda5b68cSmlcreech # else
425939a16d6Sdrh #  define INT16_TYPE short int
426939a16d6Sdrh # endif
427dda5b68cSmlcreech #endif
4285a2c2c20Sdrh #ifndef UINT8_TYPE
429dda5b68cSmlcreech # ifdef HAVE_UINT8_T
430dda5b68cSmlcreech #  define UINT8_TYPE uint8_t
431dda5b68cSmlcreech # else
4325a2c2c20Sdrh #  define UINT8_TYPE unsigned char
4335a2c2c20Sdrh # endif
434dda5b68cSmlcreech #endif
435905793e2Sdrh #ifndef INT8_TYPE
436dda5b68cSmlcreech # ifdef HAVE_INT8_T
437dda5b68cSmlcreech #  define INT8_TYPE int8_t
438dda5b68cSmlcreech # else
439905793e2Sdrh #  define INT8_TYPE signed char
440905793e2Sdrh # endif
441dda5b68cSmlcreech #endif
442efad9995Sdrh #ifndef LONGDOUBLE_TYPE
443efad9995Sdrh # define LONGDOUBLE_TYPE long double
444efad9995Sdrh #endif
445efad9995Sdrh typedef sqlite_int64 i64;          /* 8-byte signed integer */
44627436af7Sdrh typedef sqlite_uint64 u64;         /* 8-byte unsigned integer */
4475a2c2c20Sdrh typedef UINT32_TYPE u32;           /* 4-byte unsigned integer */
4485a2c2c20Sdrh typedef UINT16_TYPE u16;           /* 2-byte unsigned integer */
449939a16d6Sdrh typedef INT16_TYPE i16;            /* 2-byte signed integer */
4505a2c2c20Sdrh typedef UINT8_TYPE u8;             /* 1-byte unsigned integer */
45170a8ca3cSdrh typedef INT8_TYPE i8;              /* 1-byte signed integer */
4525a2c2c20Sdrh 
4535a2c2c20Sdrh /*
45435cd643cSdrh ** SQLITE_MAX_U32 is a u64 constant that is the maximum u64 value
45535cd643cSdrh ** that can be stored in a u32 without loss of data.  The value
45635cd643cSdrh ** is 0x00000000ffffffff.  But because of quirks of some compilers, we
45735cd643cSdrh ** have to specify the value in the less intuitive manner shown:
45835cd643cSdrh */
45935cd643cSdrh #define SQLITE_MAX_U32  ((((u64)1)<<32)-1)
46035cd643cSdrh 
46135cd643cSdrh /*
462faacf17cSdrh ** The datatype used to store estimates of the number of rows in a
463faacf17cSdrh ** table or index.  This is an unsigned integer type.  For 99.9% of
464faacf17cSdrh ** the world, a 32-bit integer is sufficient.  But a 64-bit integer
465faacf17cSdrh ** can be used at compile-time if desired.
466faacf17cSdrh */
467faacf17cSdrh #ifdef SQLITE_64BIT_STATS
468faacf17cSdrh  typedef u64 tRowcnt;    /* 64-bit only if requested at compile-time */
469faacf17cSdrh #else
470faacf17cSdrh  typedef u32 tRowcnt;    /* 32-bit is the default */
471faacf17cSdrh #endif
472faacf17cSdrh 
473faacf17cSdrh /*
474bbd42a6dSdrh ** Macros to determine whether the machine is big or little endian,
475bbd42a6dSdrh ** evaluated at runtime.
476bbd42a6dSdrh */
47746c99e0fSdrh #ifdef SQLITE_AMALGAMATION
478b3190c15Sdrh const int sqlite3one = 1;
47946c99e0fSdrh #else
480bbd42a6dSdrh extern const int sqlite3one;
48146c99e0fSdrh #endif
482189077f3Sdrh #if defined(i386) || defined(__i386__) || defined(_M_IX86)\
483189077f3Sdrh                              || defined(__x86_64) || defined(__x86_64__)
48438def054Sdrh # define SQLITE_BIGENDIAN    0
48538def054Sdrh # define SQLITE_LITTLEENDIAN 1
48638def054Sdrh # define SQLITE_UTF16NATIVE  SQLITE_UTF16LE
48738def054Sdrh #else
4889c054830Sdrh # define SQLITE_BIGENDIAN    (*(char *)(&sqlite3one)==0)
4899c054830Sdrh # define SQLITE_LITTLEENDIAN (*(char *)(&sqlite3one)==1)
49038def054Sdrh # define SQLITE_UTF16NATIVE (SQLITE_BIGENDIAN?SQLITE_UTF16BE:SQLITE_UTF16LE)
49138def054Sdrh #endif
492bbd42a6dSdrh 
493bbd42a6dSdrh /*
4940f050353Sdrh ** Constants for the largest and smallest possible 64-bit signed integers.
4950f050353Sdrh ** These macros are designed to work correctly on both 32-bit and 64-bit
4960f050353Sdrh ** compilers.
4970f050353Sdrh */
4980f050353Sdrh #define LARGEST_INT64  (0xffffffff|(((i64)0x7fffffff)<<32))
4990f050353Sdrh #define SMALLEST_INT64 (((i64)-1) - LARGEST_INT64)
5000f050353Sdrh 
5010f050353Sdrh /*
502be229650Sdanielk1977 ** Round up a number to the next larger multiple of 8.  This is used
503be229650Sdanielk1977 ** to force 8-byte alignment on 64-bit architectures.
504be229650Sdanielk1977 */
505bc73971dSdanielk1977 #define ROUND8(x)     (((x)+7)&~7)
506bc73971dSdanielk1977 
507bc73971dSdanielk1977 /*
508bc73971dSdanielk1977 ** Round down to the nearest multiple of 8
509bc73971dSdanielk1977 */
510bc73971dSdanielk1977 #define ROUNDDOWN8(x) ((x)&~7)
511be229650Sdanielk1977 
512be229650Sdanielk1977 /*
5138e14c596Sdrh ** Assert that the pointer X is aligned to an 8-byte boundary.  This
5148e14c596Sdrh ** macro is used only within assert() to verify that the code gets
5158e14c596Sdrh ** all alignment restrictions correct.
5168e14c596Sdrh **
5178e14c596Sdrh ** Except, if SQLITE_4_BYTE_ALIGNED_MALLOC is defined, then the
5188e14c596Sdrh ** underlying malloc() implemention might return us 4-byte aligned
5198e14c596Sdrh ** pointers.  In that case, only verify 4-byte alignment.
520ea598cbdSdrh */
5218e14c596Sdrh #ifdef SQLITE_4_BYTE_ALIGNED_MALLOC
5228e14c596Sdrh # define EIGHT_BYTE_ALIGNMENT(X)   ((((char*)(X) - (char*)0)&3)==0)
5238e14c596Sdrh #else
524ea598cbdSdrh # define EIGHT_BYTE_ALIGNMENT(X)   ((((char*)(X) - (char*)0)&7)==0)
5258e14c596Sdrh #endif
526ea598cbdSdrh 
527188d4884Sdrh /*
5289b4c59faSdrh ** Disable MMAP on platforms where it is known to not work
529188d4884Sdrh */
530188d4884Sdrh #if defined(__OpenBSD__) || defined(__QNXNTO__)
5319b4c59faSdrh # undef SQLITE_MAX_MMAP_SIZE
5329b4c59faSdrh # define SQLITE_MAX_MMAP_SIZE 0
533188d4884Sdrh #endif
534188d4884Sdrh 
5359b4c59faSdrh /*
5369b4c59faSdrh ** Default maximum size of memory used by memory-mapped I/O in the VFS
5379b4c59faSdrh */
5389b4c59faSdrh #ifdef __APPLE__
5399b4c59faSdrh # include <TargetConditionals.h>
5409b4c59faSdrh # if TARGET_OS_IPHONE
5419b4c59faSdrh #   undef SQLITE_MAX_MMAP_SIZE
5429b4c59faSdrh #   define SQLITE_MAX_MMAP_SIZE 0
5439b4c59faSdrh # endif
5449b4c59faSdrh #endif
5459b4c59faSdrh #ifndef SQLITE_MAX_MMAP_SIZE
5469b4c59faSdrh # if defined(__linux__) \
5479b4c59faSdrh   || defined(_WIN32) \
5489b4c59faSdrh   || (defined(__APPLE__) && defined(__MACH__)) \
5499b4c59faSdrh   || defined(__sun)
5502bba8c24Sdrh #   define SQLITE_MAX_MMAP_SIZE 0x7fff0000  /* 2147418112 */
5519b4c59faSdrh # else
5529b4c59faSdrh #   define SQLITE_MAX_MMAP_SIZE 0
5539b4c59faSdrh # endif
554d16d0bc5Sdrh # define SQLITE_MAX_MMAP_SIZE_xc 1 /* exclude from ctime.c */
5559b4c59faSdrh #endif
5569b4c59faSdrh 
5579b4c59faSdrh /*
5589b4c59faSdrh ** The default MMAP_SIZE is zero on all platforms.  Or, even if a larger
5599b4c59faSdrh ** default MMAP_SIZE is specified at compile-time, make sure that it does
5609b4c59faSdrh ** not exceed the maximum mmap size.
5619b4c59faSdrh */
5629b4c59faSdrh #ifndef SQLITE_DEFAULT_MMAP_SIZE
5639b4c59faSdrh # define SQLITE_DEFAULT_MMAP_SIZE 0
564d16d0bc5Sdrh # define SQLITE_DEFAULT_MMAP_SIZE_xc 1  /* Exclude from ctime.c */
5659b4c59faSdrh #endif
5669b4c59faSdrh #if SQLITE_DEFAULT_MMAP_SIZE>SQLITE_MAX_MMAP_SIZE
5679b4c59faSdrh # undef SQLITE_DEFAULT_MMAP_SIZE
5689b4c59faSdrh # define SQLITE_DEFAULT_MMAP_SIZE SQLITE_MAX_MMAP_SIZE
5699b4c59faSdrh #endif
570e7b34707Sdrh 
571ea598cbdSdrh /*
5721435a9a1Sdrh ** Only one of SQLITE_ENABLE_STAT3 or SQLITE_ENABLE_STAT4 can be defined.
5731435a9a1Sdrh ** Priority is given to SQLITE_ENABLE_STAT4.  If either are defined, also
5741435a9a1Sdrh ** define SQLITE_ENABLE_STAT3_OR_STAT4
5751435a9a1Sdrh */
5761435a9a1Sdrh #ifdef SQLITE_ENABLE_STAT4
5771435a9a1Sdrh # undef SQLITE_ENABLE_STAT3
5781435a9a1Sdrh # define SQLITE_ENABLE_STAT3_OR_STAT4 1
5791435a9a1Sdrh #elif SQLITE_ENABLE_STAT3
5801435a9a1Sdrh # define SQLITE_ENABLE_STAT3_OR_STAT4 1
5811435a9a1Sdrh #elif SQLITE_ENABLE_STAT3_OR_STAT4
5821435a9a1Sdrh # undef SQLITE_ENABLE_STAT3_OR_STAT4
5831435a9a1Sdrh #endif
5841435a9a1Sdrh 
5851435a9a1Sdrh /*
58690f5ecb3Sdrh ** An instance of the following structure is used to store the busy-handler
58790f5ecb3Sdrh ** callback for a given sqlite handle.
58890f5ecb3Sdrh **
58990f5ecb3Sdrh ** The sqlite.busyHandler member of the sqlite struct contains the busy
59090f5ecb3Sdrh ** callback for the database handle. Each pager opened via the sqlite
59190f5ecb3Sdrh ** handle is passed a pointer to sqlite.busyHandler. The busy-handler
59290f5ecb3Sdrh ** callback is currently invoked only from within pager.c.
59390f5ecb3Sdrh */
59490f5ecb3Sdrh typedef struct BusyHandler BusyHandler;
59590f5ecb3Sdrh struct BusyHandler {
59690f5ecb3Sdrh   int (*xFunc)(void *,int);  /* The busy callback */
59790f5ecb3Sdrh   void *pArg;                /* First arg to busy callback */
598a4afb65cSdrh   int nBusy;                 /* Incremented with each busy call */
59990f5ecb3Sdrh };
60090f5ecb3Sdrh 
60190f5ecb3Sdrh /*
60275897234Sdrh ** Name of the master database table.  The master database table
60375897234Sdrh ** is a special table that holds the names and attributes of all
60475897234Sdrh ** user tables and indices.
60575897234Sdrh */
60675897234Sdrh #define MASTER_NAME       "sqlite_master"
607e0bc4048Sdrh #define TEMP_MASTER_NAME  "sqlite_temp_master"
60875897234Sdrh 
60975897234Sdrh /*
6108e150818Sdanielk1977 ** The root-page of the master database table.
6118e150818Sdanielk1977 */
6128e150818Sdanielk1977 #define MASTER_ROOT       1
6138e150818Sdanielk1977 
6148e150818Sdanielk1977 /*
615ed6c8671Sdrh ** The name of the schema table.
616ed6c8671Sdrh */
61753c0f748Sdanielk1977 #define SCHEMA_TABLE(x)  ((!OMIT_TEMPDB)&&(x==1)?TEMP_MASTER_NAME:MASTER_NAME)
618ed6c8671Sdrh 
619ed6c8671Sdrh /*
62075897234Sdrh ** A convenience macro that returns the number of elements in
62175897234Sdrh ** an array.
62275897234Sdrh */
62323432976Sdanielk1977 #define ArraySize(X)    ((int)(sizeof(X)/sizeof(X[0])))
62475897234Sdrh 
62575897234Sdrh /*
6267a5bcc0fSdrh ** Determine if the argument is a power of two
6277a5bcc0fSdrh */
6287a5bcc0fSdrh #define IsPowerOfTwo(X) (((X)&((X)-1))==0)
6297a5bcc0fSdrh 
6307a5bcc0fSdrh /*
631633e6d57Sdrh ** The following value as a destructor means to use sqlite3DbFree().
632aa538a58Sdrh ** The sqlite3DbFree() routine requires two parameters instead of the
633aa538a58Sdrh ** one parameter that destructors normally want.  So we have to introduce
634aa538a58Sdrh ** this magic value that the code knows to handle differently.  Any
635aa538a58Sdrh ** pointer will work here as long as it is distinct from SQLITE_STATIC
636aa538a58Sdrh ** and SQLITE_TRANSIENT.
637633e6d57Sdrh */
638aa538a58Sdrh #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3MallocSize)
639633e6d57Sdrh 
64078f82d1eSdrh /*
64178f82d1eSdrh ** When SQLITE_OMIT_WSD is defined, it means that the target platform does
64278f82d1eSdrh ** not support Writable Static Data (WSD) such as global and static variables.
64378f82d1eSdrh ** All variables must either be on the stack or dynamically allocated from
64478f82d1eSdrh ** the heap.  When WSD is unsupported, the variable declarations scattered
64578f82d1eSdrh ** throughout the SQLite code must become constants instead.  The SQLITE_WSD
64678f82d1eSdrh ** macro is used for this purpose.  And instead of referencing the variable
64778f82d1eSdrh ** directly, we use its constant as a key to lookup the run-time allocated
64878f82d1eSdrh ** buffer that holds real variable.  The constant is also the initializer
64978f82d1eSdrh ** for the run-time allocated buffer.
65078f82d1eSdrh **
6512479de3aSshane ** In the usual case where WSD is supported, the SQLITE_WSD and GLOBAL
65278f82d1eSdrh ** macros become no-ops and have zero performance impact.
65378f82d1eSdrh */
654075c23afSdanielk1977 #ifdef SQLITE_OMIT_WSD
655075c23afSdanielk1977   #define SQLITE_WSD const
656075c23afSdanielk1977   #define GLOBAL(t,v) (*(t*)sqlite3_wsd_find((void*)&(v), sizeof(v)))
657075c23afSdanielk1977   #define sqlite3GlobalConfig GLOBAL(struct Sqlite3Config, sqlite3Config)
658d1d38488Sdrh   int sqlite3_wsd_init(int N, int J);
659d1d38488Sdrh   void *sqlite3_wsd_find(void *K, int L);
660075c23afSdanielk1977 #else
661075c23afSdanielk1977   #define SQLITE_WSD
662075c23afSdanielk1977   #define GLOBAL(t,v) v
663075c23afSdanielk1977   #define sqlite3GlobalConfig sqlite3Config
664075c23afSdanielk1977 #endif
665075c23afSdanielk1977 
666f3d3c27aSdanielk1977 /*
667f3d3c27aSdanielk1977 ** The following macros are used to suppress compiler warnings and to
668f3d3c27aSdanielk1977 ** make it clear to human readers when a function parameter is deliberately
669f3d3c27aSdanielk1977 ** left unused within the body of a function. This usually happens when
670f3d3c27aSdanielk1977 ** a function is called via a function pointer. For example the
671f3d3c27aSdanielk1977 ** implementation of an SQL aggregate step callback may not use the
672f3d3c27aSdanielk1977 ** parameter indicating the number of arguments passed to the aggregate,
673f3d3c27aSdanielk1977 ** if it knows that this is enforced elsewhere.
674f3d3c27aSdanielk1977 **
675f3d3c27aSdanielk1977 ** When a function parameter is not used at all within the body of a function,
676f3d3c27aSdanielk1977 ** it is generally named "NotUsed" or "NotUsed2" to make things even clearer.
677f3d3c27aSdanielk1977 ** However, these macros may also be used to suppress warnings related to
678f3d3c27aSdanielk1977 ** parameters that may or may not be used depending on compilation options.
679f3d3c27aSdanielk1977 ** For example those parameters only used in assert() statements. In these
680f3d3c27aSdanielk1977 ** cases the parameters are named as per the usual conventions.
681f3d3c27aSdanielk1977 */
68262c14b34Sdanielk1977 #define UNUSED_PARAMETER(x) (void)(x)
683f3d3c27aSdanielk1977 #define UNUSED_PARAMETER2(x,y) UNUSED_PARAMETER(x),UNUSED_PARAMETER(y)
68462c14b34Sdanielk1977 
685633e6d57Sdrh /*
68675897234Sdrh ** Forward references to structures
68775897234Sdrh */
68813449892Sdrh typedef struct AggInfo AggInfo;
689fe05af87Sdrh typedef struct AuthContext AuthContext;
6900b9f50d8Sdrh typedef struct AutoincInfo AutoincInfo;
691f5e7bb51Sdrh typedef struct Bitvec Bitvec;
692fe05af87Sdrh typedef struct CollSeq CollSeq;
6937020f651Sdrh typedef struct Column Column;
694fe05af87Sdrh typedef struct Db Db;
695e501b89aSdanielk1977 typedef struct Schema Schema;
69675897234Sdrh typedef struct Expr Expr;
69775897234Sdrh typedef struct ExprList ExprList;
698b7916a78Sdrh typedef struct ExprSpan ExprSpan;
699c2eef3b3Sdrh typedef struct FKey FKey;
700d2199f0fSdan typedef struct FuncDestructor FuncDestructor;
701fe05af87Sdrh typedef struct FuncDef FuncDef;
70270a8ca3cSdrh typedef struct FuncDefHash FuncDefHash;
703fe05af87Sdrh typedef struct IdList IdList;
704fe05af87Sdrh typedef struct Index Index;
70502fa4696Sdan typedef struct IndexSample IndexSample;
7068d059845Sdanielk1977 typedef struct KeyClass KeyClass;
707d3d39e93Sdrh typedef struct KeyInfo KeyInfo;
708633e6d57Sdrh typedef struct Lookaside Lookaside;
709633e6d57Sdrh typedef struct LookasideSlot LookasideSlot;
710d1ab1ba5Sdanielk1977 typedef struct Module Module;
711626a879aSdrh typedef struct NameContext NameContext;
712fe05af87Sdrh typedef struct Parse Parse;
713a2460e07Sdrh typedef struct RowSet RowSet;
714fd7f0452Sdanielk1977 typedef struct Savepoint Savepoint;
715fe05af87Sdrh typedef struct Select Select;
716634d81deSdrh typedef struct SelectDest SelectDest;
717fe05af87Sdrh typedef struct SrcList SrcList;
718ade86483Sdrh typedef struct StrAccum StrAccum;
719fe05af87Sdrh typedef struct Table Table;
720c00da105Sdanielk1977 typedef struct TableLock TableLock;
721fe05af87Sdrh typedef struct Token Token;
722a2460e07Sdrh typedef struct Trigger Trigger;
7232832ad42Sdan typedef struct TriggerPrg TriggerPrg;
724fe05af87Sdrh typedef struct TriggerStep TriggerStep;
725e63d9991Sdrh typedef struct UnpackedRecord UnpackedRecord;
726595a523aSdanielk1977 typedef struct VTable VTable;
727b061d058Sdan typedef struct VtabCtx VtabCtx;
7287d10d5a6Sdrh typedef struct Walker Walker;
729fe05af87Sdrh typedef struct WhereInfo WhereInfo;
730d3d39e93Sdrh 
7312dca4ac1Sdanielk1977 /*
7322dca4ac1Sdanielk1977 ** Defer sourcing vdbe.h and btree.h until after the "u8" and
7332dca4ac1Sdanielk1977 ** "BusyHandler" typedefs. vdbe.h also requires a few of the opaque
7342dca4ac1Sdanielk1977 ** pointer types (i.e. FuncDef) defined above.
7352dca4ac1Sdanielk1977 */
7362dca4ac1Sdanielk1977 #include "btree.h"
7372dca4ac1Sdanielk1977 #include "vdbe.h"
7382dca4ac1Sdanielk1977 #include "pager.h"
7398c0a791aSdanielk1977 #include "pcache.h"
7402dca4ac1Sdanielk1977 
7411cc5ed81Sdanielk1977 #include "os.h"
742c7ce76afSdrh #include "mutex.h"
7431cc5ed81Sdanielk1977 
744eee4c8caSdrh 
745001bbcbbSdrh /*
746001bbcbbSdrh ** Each database file to be accessed by the system is an instance
747001bbcbbSdrh ** of the following structure.  There are normally two of these structures
748001bbcbbSdrh ** in the sqlite.aDb[] array.  aDb[0] is the main database file and
749a69d9168Sdrh ** aDb[1] is the database file used to hold temporary tables.  Additional
750a69d9168Sdrh ** databases may be attached.
751001bbcbbSdrh */
752001bbcbbSdrh struct Db {
753001bbcbbSdrh   char *zName;         /* Name of this database */
754001bbcbbSdrh   Btree *pBt;          /* The B*Tree structure for this database file */
755467bcf36Sshane   u8 safety_level;     /* How aggressive at syncing data to disk */
756e501b89aSdanielk1977   Schema *pSchema;     /* Pointer to database schema (possibly shared) */
757da184236Sdanielk1977 };
758da184236Sdanielk1977 
759da184236Sdanielk1977 /*
760da184236Sdanielk1977 ** An instance of the following structure stores a database schema.
7612120608eSdrh **
7622120608eSdrh ** Most Schema objects are associated with a Btree.  The exception is
7632120608eSdrh ** the Schema for the TEMP databaes (sqlite3.aDb[1]) which is free-standing.
7642120608eSdrh ** In shared cache mode, a single Schema object can be shared by multiple
7652120608eSdrh ** Btrees that refer to the same underlying BtShared object.
7662120608eSdrh **
7672120608eSdrh ** Schema objects are automatically deallocated when the last Btree that
7682120608eSdrh ** references them is destroyed.   The TEMP Schema is manually freed by
7692120608eSdrh ** sqlite3_close().
7702120608eSdrh *
7712120608eSdrh ** A thread must be holding a mutex on the corresponding Btree in order
7722120608eSdrh ** to access Schema content.  This implies that the thread must also be
7732120608eSdrh ** holding a mutex on the sqlite3 connection pointer that owns the Btree.
77455a0959aSdrh ** For a TEMP Schema, only the connection mutex is required.
775da184236Sdanielk1977 */
776e501b89aSdanielk1977 struct Schema {
777001bbcbbSdrh   int schema_cookie;   /* Database schema version number for this file */
778c2a75551Sdrh   int iGeneration;     /* Generation counter.  Incremented with each change */
779d24cc427Sdrh   Hash tblHash;        /* All tables indexed by name */
780d24cc427Sdrh   Hash idxHash;        /* All (named) indices indexed by name */
781d24cc427Sdrh   Hash trigHash;       /* All triggers indexed by name */
7821da40a38Sdan   Hash fkeyHash;       /* All foreign keys by referenced table name */
7834794f735Sdrh   Table *pSeqTab;      /* The sqlite_sequence table used by AUTOINCREMENT */
784da184236Sdanielk1977   u8 file_format;      /* Schema format version for this file */
7858079a0d3Sdrh   u8 enc;              /* Text encoding used by this database */
786da184236Sdanielk1977   u16 flags;           /* Flags associated with this schema */
78714db2665Sdanielk1977   int cache_size;      /* Number of pages to use in the cache */
788001bbcbbSdrh };
78975897234Sdrh 
79075897234Sdrh /*
7918bf8dc92Sdrh ** These macros can be used to test, set, or clear bits in the
792a2460e07Sdrh ** Db.pSchema->flags field.
7938bf8dc92Sdrh */
794da184236Sdanielk1977 #define DbHasProperty(D,I,P)     (((D)->aDb[I].pSchema->flags&(P))==(P))
795da184236Sdanielk1977 #define DbHasAnyProperty(D,I,P)  (((D)->aDb[I].pSchema->flags&(P))!=0)
796da184236Sdanielk1977 #define DbSetProperty(D,I,P)     (D)->aDb[I].pSchema->flags|=(P)
797da184236Sdanielk1977 #define DbClearProperty(D,I,P)   (D)->aDb[I].pSchema->flags&=~(P)
7988bf8dc92Sdrh 
7998bf8dc92Sdrh /*
800a2460e07Sdrh ** Allowed values for the DB.pSchema->flags field.
8018bf8dc92Sdrh **
8028bf8dc92Sdrh ** The DB_SchemaLoaded flag is set after the database schema has been
8038bf8dc92Sdrh ** read into internal hash tables.
8048bf8dc92Sdrh **
8058bf8dc92Sdrh ** DB_UnresetViews means that one or more views have column names that
8068bf8dc92Sdrh ** have been filled out.  If the schema changes, these column names might
8078bf8dc92Sdrh ** changes and so the view will need to be reset.
8088bf8dc92Sdrh */
809124b27e6Sdrh #define DB_SchemaLoaded    0x0001  /* The schema has been loaded */
810124b27e6Sdrh #define DB_UnresetViews    0x0002  /* Some views have defined column names */
811b82e7edaSdanielk1977 #define DB_Empty           0x0004  /* The file is empty (length 0 bytes) */
8128bf8dc92Sdrh 
813caa639f4Sdrh /*
814caa639f4Sdrh ** The number of different kinds of things that can be limited
815caa639f4Sdrh ** using the sqlite3_limit() interface.
816caa639f4Sdrh */
817417168adSdrh #define SQLITE_N_LIMIT (SQLITE_LIMIT_TRIGGER_DEPTH+1)
8188bf8dc92Sdrh 
8198bf8dc92Sdrh /*
820633e6d57Sdrh ** Lookaside malloc is a set of fixed-size buffers that can be used
821467bcf36Sshane ** to satisfy small transient memory allocation requests for objects
822633e6d57Sdrh ** associated with a particular database connection.  The use of
823633e6d57Sdrh ** lookaside malloc provides a significant performance enhancement
824633e6d57Sdrh ** (approx 10%) by avoiding numerous malloc/free requests while parsing
825633e6d57Sdrh ** SQL statements.
826633e6d57Sdrh **
827633e6d57Sdrh ** The Lookaside structure holds configuration information about the
828633e6d57Sdrh ** lookaside malloc subsystem.  Each available memory allocation in
829633e6d57Sdrh ** the lookaside subsystem is stored on a linked list of LookasideSlot
830633e6d57Sdrh ** objects.
831d9da78a2Sdrh **
832d9da78a2Sdrh ** Lookaside allocations are only allowed for objects that are associated
833d9da78a2Sdrh ** with a particular database connection.  Hence, schema information cannot
834d9da78a2Sdrh ** be stored in lookaside because in shared cache mode the schema information
835d9da78a2Sdrh ** is shared by multiple database connections.  Therefore, while parsing
836d9da78a2Sdrh ** schema information, the Lookaside.bEnabled flag is cleared so that
837d9da78a2Sdrh ** lookaside allocations are not used to construct the schema objects.
838633e6d57Sdrh */
839633e6d57Sdrh struct Lookaside {
840633e6d57Sdrh   u16 sz;                 /* Size of each buffer in bytes */
841d9da78a2Sdrh   u8 bEnabled;            /* False to disable new lookaside allocations */
842e9d1c720Sdrh   u8 bMalloced;           /* True if pStart obtained from sqlite3_malloc() */
843633e6d57Sdrh   int nOut;               /* Number of buffers currently checked out */
844633e6d57Sdrh   int mxOut;              /* Highwater mark for nOut */
8450b12e7f8Sdrh   int anStat[3];          /* 0: hits.  1: size misses.  2: full misses */
8467d10d5a6Sdrh   LookasideSlot *pFree;   /* List of available buffers */
847633e6d57Sdrh   void *pStart;           /* First byte of available memory space */
848633e6d57Sdrh   void *pEnd;             /* First byte past end of available space */
849633e6d57Sdrh };
850633e6d57Sdrh struct LookasideSlot {
851633e6d57Sdrh   LookasideSlot *pNext;    /* Next buffer in the list of free buffers */
852633e6d57Sdrh };
853633e6d57Sdrh 
854633e6d57Sdrh /*
85570a8ca3cSdrh ** A hash table for function definitions.
85670a8ca3cSdrh **
85770a8ca3cSdrh ** Hash each FuncDef structure into one of the FuncDefHash.a[] slots.
85870a8ca3cSdrh ** Collisions are on the FuncDef.pHash chain.
85970a8ca3cSdrh */
86070a8ca3cSdrh struct FuncDefHash {
86170a8ca3cSdrh   FuncDef *a[23];       /* Hash table for functions */
86270a8ca3cSdrh };
86370a8ca3cSdrh 
86470a8ca3cSdrh /*
865a2460e07Sdrh ** Each database connection is an instance of the following structure.
86675897234Sdrh */
8679bb575fdSdrh struct sqlite3 {
86890f6a5beSdrh   sqlite3_vfs *pVfs;            /* OS Interface */
869a451017dSdrh   struct Vdbe *pVdbe;           /* List of active virtual machines */
870a451017dSdrh   CollSeq *pDfltColl;           /* The default collating sequence (BINARY) */
871a451017dSdrh   sqlite3_mutex *mutex;         /* Connection mutex */
872001bbcbbSdrh   Db *aDb;                      /* All backends */
873a451017dSdrh   int nDb;                      /* Number of backends currently in use */
874467bcf36Sshane   int flags;                    /* Miscellaneous flags. See below */
875a451017dSdrh   i64 lastRowid;                /* ROWID of most recent insert (see above) */
8769b4c59faSdrh   i64 szMmap;                   /* Default mmap_size setting */
877522c26fbSdrh   unsigned int openFlags;       /* Flags passed to sqlite3_vfs.xOpen() */
878fcd35c7bSdrh   int errCode;                  /* Most recent error code (SQLITE_*) */
8794ac285a1Sdrh   int errMask;                  /* & result codes with this before returning */
880a5759677Sdrh   u16 dbOptFlags;               /* Flags to enable/disable optimizations */
881fcd35c7bSdrh   u8 autoCommit;                /* The auto-commit flag. */
88290f5ecb3Sdrh   u8 temp_store;                /* 1: file 2: memory 0: default */
88317435752Sdrh   u8 mallocFailed;              /* True if we have seen a malloc failure */
8843b02013eSdrh   u8 dfltLockMode;              /* Default locking-mode for attached dbs */
88598757157Sdrh   signed char nextAutovac;      /* Autovac setting after VACUUM if >=0 */
886a7564663Sdrh   u8 suppressErr;               /* Do not issue error messages if true */
887b061d058Sdan   u8 vtabOnConflict;            /* Value to return for s3_vtab_on_conflict() */
888a451017dSdrh   u8 isTransactionSavepoint;    /* True if the outermost savepoint is a TS */
889f653d782Sdanielk1977   int nextPagesize;             /* Pagesize after VACUUM if >0 */
89064202cfeSdanielk1977   u32 magic;                    /* Magic number for detect library misuse */
891b28af71aSdanielk1977   int nChange;                  /* Value returned by sqlite3_changes() */
892b28af71aSdanielk1977   int nTotalChange;             /* Value returned by sqlite3_total_changes() */
893caa639f4Sdrh   int aLimit[SQLITE_N_LIMIT];   /* Limits */
8944adee20fSdanielk1977   struct sqlite3InitInfo {      /* Information used during initialization */
8951d85d931Sdrh     int newTnum;                /* Rootpage of table being initialized */
896a451017dSdrh     u8 iDb;                     /* Which db file is being initialized */
8971d85d931Sdrh     u8 busy;                    /* TRUE if currently initializing */
8983d5f74b2Sdrh     u8 orphanTrigger;           /* Last statement is orphaned TEMP trigger */
8991d85d931Sdrh   } init;
9001713afb0Sdrh   int nVdbeActive;              /* Number of VDBEs currently running */
9014f7d3a5fSdrh   int nVdbeRead;                /* Number of active VDBEs that read or write */
9024f7d3a5fSdrh   int nVdbeWrite;               /* Number of active VDBEs that read and write */
9034f7d3a5fSdrh   int nVdbeExec;                /* Number of nested calls to VdbeExec() */
904a451017dSdrh   int nExtension;               /* Number of loaded extensions */
905a451017dSdrh   void **aExtension;            /* Array of shared library handles */
90618de4824Sdrh   void (*xTrace)(void*,const char*);        /* Trace function */
90718de4824Sdrh   void *pTraceArg;                          /* Argument to the trace function */
90819e2d37fSdrh   void (*xProfile)(void*,const char*,u64);  /* Profiling function */
90919e2d37fSdrh   void *pProfileArg;                        /* Argument to profile function */
910fcd35c7bSdrh   void *pCommitArg;                 /* Argument to xCommitCallback() */
911fcd35c7bSdrh   int (*xCommitCallback)(void*);    /* Invoked at every commit. */
91271fd80bfSdanielk1977   void *pRollbackArg;               /* Argument to xRollbackCallback() */
91371fd80bfSdanielk1977   void (*xRollbackCallback)(void*); /* Invoked at every commit. */
91494eb6a14Sdanielk1977   void *pUpdateArg;
91594eb6a14Sdanielk1977   void (*xUpdateCallback)(void*,int, const char*,const char*,sqlite_int64);
9165cf53537Sdan #ifndef SQLITE_OMIT_WAL
9177ed91f23Sdrh   int (*xWalCallback)(void *, sqlite3 *, const char *, int);
9187ed91f23Sdrh   void *pWalArg;
9195cf53537Sdan #endif
920fcd35c7bSdrh   void(*xCollNeeded)(void*,sqlite3*,int eTextRep,const char*);
921fcd35c7bSdrh   void(*xCollNeeded16)(void*,sqlite3*,int eTextRep,const void*);
922fcd35c7bSdrh   void *pCollNeededArg;
923fcd35c7bSdrh   sqlite3_value *pErr;          /* Most recent error message */
924fcd35c7bSdrh   char *zErrMsg;                /* Most recent error message (UTF-8 encoded) */
925fcd35c7bSdrh   char *zErrMsg16;              /* Most recent error message (UTF-16 encoded) */
926881feaa0Sdrh   union {
92739001e75Sdrh     volatile int isInterrupted; /* True if sqlite3_interrupt has been called */
928881feaa0Sdrh     double notUsed1;            /* Spacer */
929881feaa0Sdrh   } u1;
930633e6d57Sdrh   Lookaside lookaside;          /* Lookaside malloc configuration */
931ed6c8671Sdrh #ifndef SQLITE_OMIT_AUTHORIZATION
932e22a334bSdrh   int (*xAuth)(void*,int,const char*,const char*,const char*,const char*);
933e22a334bSdrh                                 /* Access authorization function */
934ed6c8671Sdrh   void *pAuthArg;               /* 1st argument to the access auth function */
935ed6c8671Sdrh #endif
936348bb5d6Sdanielk1977 #ifndef SQLITE_OMIT_PROGRESS_CALLBACK
937348bb5d6Sdanielk1977   int (*xProgress)(void *);     /* The progress callback */
938348bb5d6Sdanielk1977   void *pProgressArg;           /* Argument to the progress callback */
9398f8c65f7Sdrh   unsigned nProgressOps;        /* Number of opcodes for progress callback */
940348bb5d6Sdanielk1977 #endif
941b9bb7c18Sdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
942a451017dSdrh   int nVTrans;                  /* Allocated size of aVTrans */
943b9bb7c18Sdrh   Hash aModule;                 /* populated by sqlite3_create_module() */
944b061d058Sdan   VtabCtx *pVtabCtx;            /* Context for active vtab connect/create */
945595a523aSdanielk1977   VTable **aVTrans;             /* Virtual tables with open transactions */
946595a523aSdanielk1977   VTable *pDisconnect;    /* Disconnect these in next sqlite3_prepare() */
9476b456a2bSdanielk1977 #endif
94870a8ca3cSdrh   FuncDefHash aFunc;            /* Hash table of connection functions */
949fcd35c7bSdrh   Hash aCollSeq;                /* All collating sequences */
950fcd35c7bSdrh   BusyHandler busyHandler;      /* Busy callback */
951fcd35c7bSdrh   Db aDbStatic[2];              /* Static space for the 2 default backends */
952fd7f0452Sdanielk1977   Savepoint *pSavepoint;        /* List of active savepoints */
953a451017dSdrh   int busyTimeout;              /* Busy handler timeout, in msec */
954fd7f0452Sdanielk1977   int nSavepoint;               /* Number of non-transaction savepoints */
955bd43455cSdanielk1977   int nStatement;               /* Number of nested statement-transactions  */
9561da40a38Sdan   i64 nDeferredCons;            /* Net deferred constraints this transaction. */
957648e2643Sdrh   i64 nDeferredImmCons;         /* Net deferred immediate constraints */
958d46def77Sdan   int *pnBytesFreed;            /* If not NULL, increment this in DbFree() */
959404ca075Sdanielk1977 
960404ca075Sdanielk1977 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
961404ca075Sdanielk1977   /* The following variables are all protected by the STATIC_MASTER
962404ca075Sdanielk1977   ** mutex, not by sqlite3.mutex. They are used by code in notify.c.
96365a73badSdrh   **
96465a73badSdrh   ** When X.pUnlockConnection==Y, that means that X is waiting for Y to
96565a73badSdrh   ** unlock so that it can proceed.
96665a73badSdrh   **
96765a73badSdrh   ** When X.pBlockingConnection==Y, that means that something that X tried
96865a73badSdrh   ** tried to do recently failed with an SQLITE_LOCKED error due to locks
96965a73badSdrh   ** held by Y.
970404ca075Sdanielk1977   */
971404ca075Sdanielk1977   sqlite3 *pBlockingConnection; /* Connection that caused SQLITE_LOCKED */
972404ca075Sdanielk1977   sqlite3 *pUnlockConnection;           /* Connection to watch for unlock */
973404ca075Sdanielk1977   void *pUnlockArg;                     /* Argument to xUnlockNotify */
974404ca075Sdanielk1977   void (*xUnlockNotify)(void **, int);  /* Unlock notify callback */
975404ca075Sdanielk1977   sqlite3 *pNextBlocked;        /* Next in list of all blocked connections */
976404ca075Sdanielk1977 #endif
97775897234Sdrh };
97875897234Sdrh 
97903b808a6Sdrh /*
98003b808a6Sdrh ** A macro to discover the encoding of a database.
98103b808a6Sdrh */
98214db2665Sdanielk1977 #define ENC(db) ((db)->aDb[0].pSchema->enc)
98314db2665Sdanielk1977 
98475897234Sdrh /*
98507096f68Sdrh ** Possible values for the sqlite3.flags.
98675897234Sdrh */
9877e5418e4Sdrh #define SQLITE_VdbeTrace      0x00000001  /* True to trace VDBE execution */
9887e5418e4Sdrh #define SQLITE_InternChanges  0x00000002  /* Uncommitted Hash table changes */
98940c3941cSdrh #define SQLITE_FullFSync      0x00000004  /* Use full fsync on the backend */
99040c3941cSdrh #define SQLITE_CkptFullFSync  0x00000008  /* Use full fsync for checkpoint */
99140c3941cSdrh #define SQLITE_CacheSpill     0x00000010  /* OK to spill pager cache */
99240c3941cSdrh #define SQLITE_FullColNames   0x00000020  /* Show full column names on SELECT */
99340c3941cSdrh #define SQLITE_ShortColNames  0x00000040  /* Show short columns names */
99440c3941cSdrh #define SQLITE_CountRows      0x00000080  /* Count rows changed by INSERT, */
9951bee3d7bSdrh                                           /*   DELETE, or UPDATE and return */
9961bee3d7bSdrh                                           /*   the count using a callback. */
99740c3941cSdrh #define SQLITE_NullCallback   0x00000100  /* Invoke the callback once if the */
9986a535340Sdrh                                           /*   result set is empty */
99940c3941cSdrh #define SQLITE_SqlTrace       0x00000200  /* Debug print SQL as it executes */
100040c3941cSdrh #define SQLITE_VdbeListing    0x00000400  /* Debug listings of VDBE programs */
100140c3941cSdrh #define SQLITE_WriteSchema    0x00000800  /* OK to update SQLITE_MASTER */
100240c3941cSdrh #define SQLITE_VdbeAddopTrace 0x00001000  /* Trace sqlite3VdbeAddOp() calls */
100340c3941cSdrh #define SQLITE_IgnoreChecks   0x00002000  /* Do not enforce check constraints */
100440c3941cSdrh #define SQLITE_ReadUncommitted 0x0004000  /* For shared-cache mode */
100540c3941cSdrh #define SQLITE_LegacyFileFmt  0x00008000  /* Create new databases in format 1 */
100640c3941cSdrh #define SQLITE_RecoveryMode   0x00010000  /* Ignore schema errors */
100740c3941cSdrh #define SQLITE_ReverseOrder   0x00020000  /* Reverse unordered SELECTs */
100840c3941cSdrh #define SQLITE_RecTriggers    0x00040000  /* Enable recursive triggers */
100940c3941cSdrh #define SQLITE_ForeignKeys    0x00080000  /* Enforce foreign key constraints  */
101040c3941cSdrh #define SQLITE_AutoIndex      0x00100000  /* Enable automatic indexes */
101140c3941cSdrh #define SQLITE_PreferBuiltin  0x00200000  /* Preference to built-in funcs */
101240c3941cSdrh #define SQLITE_LoadExtension  0x00400000  /* Enable load_extension */
101340c3941cSdrh #define SQLITE_EnableTrigger  0x00800000  /* True to enable triggers */
101440c3941cSdrh #define SQLITE_DeferFKs       0x01000000  /* Defer all FK constraints */
101540c3941cSdrh #define SQLITE_QueryOnly      0x02000000  /* Disable database changes */
1016b1eaa718Sdrh 
101707096f68Sdrh 
101807096f68Sdrh /*
10197e5418e4Sdrh ** Bits of the sqlite3.dbOptFlags field that are used by the
10207e5418e4Sdrh ** sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS,...) interface to
10217e5418e4Sdrh ** selectively disable various optimizations.
102207096f68Sdrh */
10237e5418e4Sdrh #define SQLITE_QueryFlattener 0x0001   /* Query flattening */
10247e5418e4Sdrh #define SQLITE_ColumnCache    0x0002   /* Column cache */
10257e5418e4Sdrh #define SQLITE_GroupByOrder   0x0004   /* GROUPBY cover of ORDERBY */
10267e5418e4Sdrh #define SQLITE_FactorOutConst 0x0008   /* Constant factoring */
10277e5418e4Sdrh #define SQLITE_IdxRealAsInt   0x0010   /* Store REAL as INT in indices */
10287e5418e4Sdrh #define SQLITE_DistinctOpt    0x0020   /* DISTINCT using indexes */
10297e5418e4Sdrh #define SQLITE_CoverIdxScan   0x0040   /* Covering index scans */
1030a9e3fc05Sdrh #define SQLITE_OrderByIdxJoin 0x0080   /* ORDER BY of joins via index */
1031a5759677Sdrh #define SQLITE_SubqCoroutine  0x0100   /* Evaluate subqueries as coroutines */
1032eb5bc926Sdrh #define SQLITE_Transitive     0x0200   /* Transitive constraints */
10331031bd99Sdrh #define SQLITE_OmitNoopJoin   0x0400   /* Omit unused tables in joins */
103440aa936fSdrh #define SQLITE_Stat3          0x0800   /* Use the SQLITE_STAT3 table */
1035a5759677Sdrh #define SQLITE_AllOpts        0xffff   /* All optimizations */
10367e5418e4Sdrh 
10377e5418e4Sdrh /*
10387e5418e4Sdrh ** Macros for testing whether or not optimizations are enabled or disabled.
10397e5418e4Sdrh */
10407e5418e4Sdrh #ifndef SQLITE_OMIT_BUILTIN_TEST
10417e5418e4Sdrh #define OptimizationDisabled(db, mask)  (((db)->dbOptFlags&(mask))!=0)
10427e5418e4Sdrh #define OptimizationEnabled(db, mask)   (((db)->dbOptFlags&(mask))==0)
10437e5418e4Sdrh #else
10447e5418e4Sdrh #define OptimizationDisabled(db, mask)  0
10457e5418e4Sdrh #define OptimizationEnabled(db, mask)   1
10467e5418e4Sdrh #endif
104734c68fbaSdanielk1977 
104858b9576bSdrh /*
1049247be43dSdrh ** Possible values for the sqlite.magic field.
1050247be43dSdrh ** The numbers are obtained at random and have no special meaning, other
1051247be43dSdrh ** than being distinct from one another.
1052247be43dSdrh */
1053247be43dSdrh #define SQLITE_MAGIC_OPEN     0xa029a697  /* Database is open */
1054247be43dSdrh #define SQLITE_MAGIC_CLOSED   0x9f3c2d33  /* Database is closed */
10557e8b848aSdrh #define SQLITE_MAGIC_SICK     0x4b771290  /* Error and awaiting close */
1056247be43dSdrh #define SQLITE_MAGIC_BUSY     0xf03b7906  /* Database currently in use */
1057247be43dSdrh #define SQLITE_MAGIC_ERROR    0xb5357930  /* An SQLITE_MISUSE error occurred */
10584245c405Sdrh #define SQLITE_MAGIC_ZOMBIE   0x64cffc7f  /* Close with last statement close */
1059247be43dSdrh 
1060247be43dSdrh /*
10610bce8354Sdrh ** Each SQL function is defined by an instance of the following
10620bce8354Sdrh ** structure.  A pointer to this structure is stored in the sqlite.aFunc
10638e0a2f90Sdrh ** hash table.  When multiple functions have the same name, the hash table
10648e0a2f90Sdrh ** points to a linked list of these structures.
10652803757aSdrh */
10660bce8354Sdrh struct FuncDef {
1067e82f5d04Sdrh   i16 nArg;            /* Number of arguments.  -1 means unlimited */
1068d8123366Sdanielk1977   u8 iPrefEnc;         /* Preferred text encoding (SQLITE_UTF8, 16LE, 16BE) */
106955ef4d97Sdrh   u8 flags;            /* Some combination of SQLITE_FUNC_* */
10701350b030Sdrh   void *pUserData;     /* User data parameter */
10710bce8354Sdrh   FuncDef *pNext;      /* Next function with same name */
1072f9b596ebSdrh   void (*xFunc)(sqlite3_context*,int,sqlite3_value**); /* Regular function */
1073f9b596ebSdrh   void (*xStep)(sqlite3_context*,int,sqlite3_value**); /* Aggregate step */
1074467bcf36Sshane   void (*xFinalize)(sqlite3_context*);                /* Aggregate finalizer */
10758c0a791aSdanielk1977   char *zName;         /* SQL name of the function. */
107670a8ca3cSdrh   FuncDef *pHash;      /* Next with a different name but the same hash */
1077d2199f0fSdan   FuncDestructor *pDestructor;   /* Reference counted destructor function */
1078d2199f0fSdan };
1079d2199f0fSdan 
1080d2199f0fSdan /*
1081d2199f0fSdan ** This structure encapsulates a user-function destructor callback (as
1082d2199f0fSdan ** configured using create_function_v2()) and a reference counter. When
1083d2199f0fSdan ** create_function_v2() is called to create a function with a destructor,
1084d2199f0fSdan ** a single object of this type is allocated. FuncDestructor.nRef is set to
1085d2199f0fSdan ** the number of FuncDef objects created (either 1 or 3, depending on whether
1086d2199f0fSdan ** or not the specified encoding is SQLITE_ANY). The FuncDef.pDestructor
1087d2199f0fSdan ** member of each of the new FuncDef objects is set to point to the allocated
1088d2199f0fSdan ** FuncDestructor.
1089d2199f0fSdan **
1090d2199f0fSdan ** Thereafter, when one of the FuncDef objects is deleted, the reference
1091d2199f0fSdan ** count on this object is decremented. When it reaches 0, the destructor
1092d2199f0fSdan ** is invoked and the FuncDestructor structure freed.
1093d2199f0fSdan */
1094d2199f0fSdan struct FuncDestructor {
1095d2199f0fSdan   int nRef;
1096d2199f0fSdan   void (*xDestroy)(void *);
1097d2199f0fSdan   void *pUserData;
10988e0a2f90Sdrh };
10992803757aSdrh 
11002803757aSdrh /*
1101a748fdccSdrh ** Possible values for FuncDef.flags.  Note that the _LENGTH and _TYPEOF
1102a748fdccSdrh ** values must correspond to OPFLAG_LENGTHARG and OPFLAG_TYPEOFARG.  There
1103a748fdccSdrh ** are assert() statements in the code to verify this.
11047d10d5a6Sdrh */
11057d10d5a6Sdrh #define SQLITE_FUNC_LIKE     0x01 /* Candidate for the LIKE optimization */
11067d10d5a6Sdrh #define SQLITE_FUNC_CASE     0x02 /* Case-sensitive LIKE-type function */
1107467bcf36Sshane #define SQLITE_FUNC_EPHEM    0x04 /* Ephemeral.  Delete with VDBE */
1108e82f5d04Sdrh #define SQLITE_FUNC_NEEDCOLL 0x08 /* sqlite3GetFuncCollSeq() might be called */
1109a748fdccSdrh #define SQLITE_FUNC_COUNT    0x10 /* Built-in count(*) aggregate */
1110a748fdccSdrh #define SQLITE_FUNC_COALESCE 0x20 /* Built-in coalesce() or ifnull() function */
1111a748fdccSdrh #define SQLITE_FUNC_LENGTH   0x40 /* Built-in length() function */
1112a748fdccSdrh #define SQLITE_FUNC_TYPEOF   0x80 /* Built-in typeof() function */
11137d10d5a6Sdrh 
11147d10d5a6Sdrh /*
1115777c5386Sdrh ** The following three macros, FUNCTION(), LIKEFUNC() and AGGREGATE() are
1116777c5386Sdrh ** used to create the initializers for the FuncDef structures.
1117777c5386Sdrh **
1118777c5386Sdrh **   FUNCTION(zName, nArg, iArg, bNC, xFunc)
1119777c5386Sdrh **     Used to create a scalar function definition of a function zName
1120777c5386Sdrh **     implemented by C function xFunc that accepts nArg arguments. The
1121777c5386Sdrh **     value passed as iArg is cast to a (void*) and made available
1122777c5386Sdrh **     as the user-data (sqlite3_user_data()) for the function. If
1123f7bca574Sdrh **     argument bNC is true, then the SQLITE_FUNC_NEEDCOLL flag is set.
1124777c5386Sdrh **
1125777c5386Sdrh **   AGGREGATE(zName, nArg, iArg, bNC, xStep, xFinal)
1126777c5386Sdrh **     Used to create an aggregate function definition implemented by
1127777c5386Sdrh **     the C functions xStep and xFinal. The first four parameters
1128777c5386Sdrh **     are interpreted in the same way as the first 4 parameters to
1129777c5386Sdrh **     FUNCTION().
1130777c5386Sdrh **
1131777c5386Sdrh **   LIKEFUNC(zName, nArg, pArg, flags)
1132777c5386Sdrh **     Used to create a scalar function definition of a function zName
1133777c5386Sdrh **     that accepts nArg arguments and is implemented by a call to C
1134777c5386Sdrh **     function likeFunc. Argument pArg is cast to a (void *) and made
1135777c5386Sdrh **     available as the function user-data (sqlite3_user_data()). The
1136777c5386Sdrh **     FuncDef.flags variable is set to the value passed as the flags
1137777c5386Sdrh **     parameter.
1138777c5386Sdrh */
1139777c5386Sdrh #define FUNCTION(zName, nArg, iArg, bNC, xFunc) \
1140a748fdccSdrh   {nArg, SQLITE_UTF8, (bNC*SQLITE_FUNC_NEEDCOLL), \
1141a748fdccSdrh    SQLITE_INT_TO_PTR(iArg), 0, xFunc, 0, 0, #zName, 0, 0}
1142a748fdccSdrh #define FUNCTION2(zName, nArg, iArg, bNC, xFunc, extraFlags) \
1143a748fdccSdrh   {nArg, SQLITE_UTF8, (bNC*SQLITE_FUNC_NEEDCOLL)|extraFlags, \
11446ac78a0dSdrh    SQLITE_INT_TO_PTR(iArg), 0, xFunc, 0, 0, #zName, 0, 0}
114521717ed6Sdrh #define STR_FUNCTION(zName, nArg, pArg, bNC, xFunc) \
1146f7bca574Sdrh   {nArg, SQLITE_UTF8, bNC*SQLITE_FUNC_NEEDCOLL, \
11476ac78a0dSdrh    pArg, 0, xFunc, 0, 0, #zName, 0, 0}
1148777c5386Sdrh #define LIKEFUNC(zName, nArg, arg, flags) \
11496ac78a0dSdrh   {nArg, SQLITE_UTF8, flags, (void *)arg, 0, likeFunc, 0, 0, #zName, 0, 0}
1150777c5386Sdrh #define AGGREGATE(zName, nArg, arg, nc, xStep, xFinal) \
1151f7bca574Sdrh   {nArg, SQLITE_UTF8, nc*SQLITE_FUNC_NEEDCOLL, \
11526ac78a0dSdrh    SQLITE_INT_TO_PTR(arg), 0, 0, xStep,xFinal,#zName,0,0}
1153777c5386Sdrh 
1154fd7f0452Sdanielk1977 /*
1155fd7f0452Sdanielk1977 ** All current savepoints are stored in a linked list starting at
1156fd7f0452Sdanielk1977 ** sqlite3.pSavepoint. The first element in the list is the most recently
1157fd7f0452Sdanielk1977 ** opened savepoint. Savepoints are added to the list by the vdbe
1158fd7f0452Sdanielk1977 ** OP_Savepoint instruction.
1159fd7f0452Sdanielk1977 */
1160fd7f0452Sdanielk1977 struct Savepoint {
1161fd7f0452Sdanielk1977   char *zName;                        /* Savepoint name (nul-terminated) */
1162fcb9f7adSdrh   i64 nDeferredCons;                  /* Number of deferred fk violations */
1163648e2643Sdrh   i64 nDeferredImmCons;               /* Number of deferred imm fk. */
1164fd7f0452Sdanielk1977   Savepoint *pNext;                   /* Parent savepoint (if any) */
1165fd7f0452Sdanielk1977 };
1166fd7f0452Sdanielk1977 
1167fd7f0452Sdanielk1977 /*
1168fd7f0452Sdanielk1977 ** The following are used as the second parameter to sqlite3Savepoint(),
1169fd7f0452Sdanielk1977 ** and as the P1 argument to the OP_Savepoint instruction.
1170fd7f0452Sdanielk1977 */
1171fd7f0452Sdanielk1977 #define SAVEPOINT_BEGIN      0
1172fd7f0452Sdanielk1977 #define SAVEPOINT_RELEASE    1
1173fd7f0452Sdanielk1977 #define SAVEPOINT_ROLLBACK   2
1174fd7f0452Sdanielk1977 
1175777c5386Sdrh 
1176777c5386Sdrh /*
1177d1ab1ba5Sdanielk1977 ** Each SQLite module (virtual table definition) is defined by an
1178d1ab1ba5Sdanielk1977 ** instance of the following structure, stored in the sqlite3.aModule
1179d1ab1ba5Sdanielk1977 ** hash table.
1180d1ab1ba5Sdanielk1977 */
1181d1ab1ba5Sdanielk1977 struct Module {
1182d1ab1ba5Sdanielk1977   const sqlite3_module *pModule;       /* Callback pointers */
1183d1ab1ba5Sdanielk1977   const char *zName;                   /* Name passed to create_module() */
1184d1ab1ba5Sdanielk1977   void *pAux;                          /* pAux passed to create_module() */
1185832a58a6Sdanielk1977   void (*xDestroy)(void *);            /* Module destructor function */
1186d1ab1ba5Sdanielk1977 };
1187d1ab1ba5Sdanielk1977 
1188d1ab1ba5Sdanielk1977 /*
1189967e8b73Sdrh ** information about each column of an SQL table is held in an instance
11907020f651Sdrh ** of this structure.
11917020f651Sdrh */
11927020f651Sdrh struct Column {
11937020f651Sdrh   char *zName;     /* Name of this column */
11947977a17fSdanielk1977   Expr *pDflt;     /* Default value of this column */
1195b7916a78Sdrh   char *zDflt;     /* Original text of the default value */
1196382c0247Sdrh   char *zType;     /* Data type for this column */
1197b3bf556eSdanielk1977   char *zColl;     /* Collating sequence.  If NULL, use the default */
1198a371ace4Sdrh   u8 notNull;      /* An OE_ code for handling a NOT NULL constraint */
1199a37cdde0Sdanielk1977   char affinity;   /* One of the SQLITE_AFF_... values */
1200a371ace4Sdrh   u16 colFlags;    /* Boolean properties.  See COLFLAG_ defines below */
12017020f651Sdrh };
12027020f651Sdrh 
1203a371ace4Sdrh /* Allowed values for Column.colFlags:
1204a371ace4Sdrh */
1205a371ace4Sdrh #define COLFLAG_PRIMKEY  0x0001    /* Column is part of the primary key */
1206a371ace4Sdrh #define COLFLAG_HIDDEN   0x0002    /* A hidden column in a virtual table */
1207a371ace4Sdrh 
12087020f651Sdrh /*
1209a9fd84b0Sdrh ** A "Collating Sequence" is defined by an instance of the following
12100202b29eSdanielk1977 ** structure. Conceptually, a collating sequence consists of a name and
12110202b29eSdanielk1977 ** a comparison routine that defines the order of that sequence.
1212a9fd84b0Sdrh **
1213e6f1e760Sdrh ** If CollSeq.xCmp is NULL, it means that the
12140202b29eSdanielk1977 ** collating sequence is undefined.  Indices built on an undefined
12150202b29eSdanielk1977 ** collating sequence may not be read or written.
1216a9fd84b0Sdrh */
1217a9fd84b0Sdrh struct CollSeq {
12180202b29eSdanielk1977   char *zName;          /* Name of the collating sequence, UTF-8 encoded */
1219466be56bSdanielk1977   u8 enc;               /* Text encoding handled by xCmp() */
1220a9fd84b0Sdrh   void *pUser;          /* First argument to xCmp() */
12210202b29eSdanielk1977   int (*xCmp)(void*,int, const void*, int, const void*);
1222a9808b31Sdanielk1977   void (*xDel)(void*);  /* Destructor for pUser */
1223a9fd84b0Sdrh };
1224a9fd84b0Sdrh 
1225a9fd84b0Sdrh /*
1226d3d39e93Sdrh ** A sort order can be either ASC or DESC.
12278e2ca029Sdrh */
12288e2ca029Sdrh #define SQLITE_SO_ASC       0  /* Sort in ascending order */
1229d3d39e93Sdrh #define SQLITE_SO_DESC      1  /* Sort in ascending order */
12308e2ca029Sdrh 
12318e2ca029Sdrh /*
1232a37cdde0Sdanielk1977 ** Column affinity types.
12338a51256cSdrh **
12348a51256cSdrh ** These used to have mnemonic name like 'i' for SQLITE_AFF_INTEGER and
12358a51256cSdrh ** 't' for SQLITE_AFF_TEXT.  But we can save a little space and improve
12367d10d5a6Sdrh ** the speed a little by numbering the values consecutively.
12378a51256cSdrh **
12388a51256cSdrh ** But rather than start with 0 or 1, we begin with 'a'.  That way,
12398a51256cSdrh ** when multiple affinity types are concatenated into a string and
124066a5167bSdrh ** used as the P4 operand, they will be more readable.
12418a51256cSdrh **
12428a51256cSdrh ** Note also that the numeric types are grouped together so that testing
12438a51256cSdrh ** for a numeric type is a single comparison.
1244a37cdde0Sdanielk1977 */
12458a51256cSdrh #define SQLITE_AFF_TEXT     'a'
12468a51256cSdrh #define SQLITE_AFF_NONE     'b'
12478a51256cSdrh #define SQLITE_AFF_NUMERIC  'c'
12488a51256cSdrh #define SQLITE_AFF_INTEGER  'd'
12498a51256cSdrh #define SQLITE_AFF_REAL     'e'
1250a37cdde0Sdanielk1977 
12518a51256cSdrh #define sqlite3IsNumericAffinity(X)  ((X)>=SQLITE_AFF_NUMERIC)
1252a37cdde0Sdanielk1977 
1253a37cdde0Sdanielk1977 /*
125435573356Sdrh ** The SQLITE_AFF_MASK values masks off the significant bits of an
125535573356Sdrh ** affinity value.
125635573356Sdrh */
125735573356Sdrh #define SQLITE_AFF_MASK     0x67
125835573356Sdrh 
125935573356Sdrh /*
126035573356Sdrh ** Additional bit values that can be ORed with an affinity without
126135573356Sdrh ** changing the affinity.
126235573356Sdrh */
126335573356Sdrh #define SQLITE_JUMPIFNULL   0x08  /* jumps if either operand is NULL */
126493a960a0Sdrh #define SQLITE_STOREP2      0x10  /* Store result in reg[P2] rather than jump */
12656a2fe093Sdrh #define SQLITE_NULLEQ       0x80  /* NULL=NULL */
126635573356Sdrh 
126735573356Sdrh /*
1268595a523aSdanielk1977 ** An object of this type is created for each virtual table present in
1269595a523aSdanielk1977 ** the database schema.
1270595a523aSdanielk1977 **
1271595a523aSdanielk1977 ** If the database schema is shared, then there is one instance of this
1272595a523aSdanielk1977 ** structure for each database connection (sqlite3*) that uses the shared
1273595a523aSdanielk1977 ** schema. This is because each database connection requires its own unique
1274595a523aSdanielk1977 ** instance of the sqlite3_vtab* handle used to access the virtual table
1275595a523aSdanielk1977 ** implementation. sqlite3_vtab* handles can not be shared between
1276595a523aSdanielk1977 ** database connections, even when the rest of the in-memory database
1277595a523aSdanielk1977 ** schema is shared, as the implementation often stores the database
1278595a523aSdanielk1977 ** connection handle passed to it via the xConnect() or xCreate() method
1279595a523aSdanielk1977 ** during initialization internally. This database connection handle may
12809bbc2e28Sdrh ** then be used by the virtual table implementation to access real tables
1281595a523aSdanielk1977 ** within the database. So that they appear as part of the callers
1282595a523aSdanielk1977 ** transaction, these accesses need to be made via the same database
1283595a523aSdanielk1977 ** connection as that used to execute SQL operations on the virtual table.
1284595a523aSdanielk1977 **
1285595a523aSdanielk1977 ** All VTable objects that correspond to a single table in a shared
1286595a523aSdanielk1977 ** database schema are initially stored in a linked-list pointed to by
1287595a523aSdanielk1977 ** the Table.pVTable member variable of the corresponding Table object.
1288595a523aSdanielk1977 ** When an sqlite3_prepare() operation is required to access the virtual
1289595a523aSdanielk1977 ** table, it searches the list for the VTable that corresponds to the
1290595a523aSdanielk1977 ** database connection doing the preparing so as to use the correct
1291595a523aSdanielk1977 ** sqlite3_vtab* handle in the compiled query.
1292595a523aSdanielk1977 **
1293595a523aSdanielk1977 ** When an in-memory Table object is deleted (for example when the
1294595a523aSdanielk1977 ** schema is being reloaded for some reason), the VTable objects are not
1295595a523aSdanielk1977 ** deleted and the sqlite3_vtab* handles are not xDisconnect()ed
1296595a523aSdanielk1977 ** immediately. Instead, they are moved from the Table.pVTable list to
1297595a523aSdanielk1977 ** another linked list headed by the sqlite3.pDisconnect member of the
1298595a523aSdanielk1977 ** corresponding sqlite3 structure. They are then deleted/xDisconnected
1299595a523aSdanielk1977 ** next time a statement is prepared using said sqlite3*. This is done
1300595a523aSdanielk1977 ** to avoid deadlock issues involving multiple sqlite3.mutex mutexes.
1301595a523aSdanielk1977 ** Refer to comments above function sqlite3VtabUnlockList() for an
1302595a523aSdanielk1977 ** explanation as to why it is safe to add an entry to an sqlite3.pDisconnect
1303595a523aSdanielk1977 ** list without holding the corresponding sqlite3.mutex mutex.
1304595a523aSdanielk1977 **
1305595a523aSdanielk1977 ** The memory for objects of this type is always allocated by
1306595a523aSdanielk1977 ** sqlite3DbMalloc(), using the connection handle stored in VTable.db as
1307595a523aSdanielk1977 ** the first argument.
1308595a523aSdanielk1977 */
1309595a523aSdanielk1977 struct VTable {
1310595a523aSdanielk1977   sqlite3 *db;              /* Database connection associated with this table */
1311595a523aSdanielk1977   Module *pMod;             /* Pointer to module implementation */
1312595a523aSdanielk1977   sqlite3_vtab *pVtab;      /* Pointer to vtab instance */
1313595a523aSdanielk1977   int nRef;                 /* Number of pointers to this structure */
1314b061d058Sdan   u8 bConstraint;           /* True if constraints are supported */
1315addd8f87Sdrh   int iSavepoint;           /* Depth of the SAVEPOINT stack */
1316595a523aSdanielk1977   VTable *pNext;            /* Next in linked list (see above) */
1317595a523aSdanielk1977 };
1318595a523aSdanielk1977 
1319595a523aSdanielk1977 /*
132022f70c32Sdrh ** Each SQL table is represented in memory by an instance of the
132122f70c32Sdrh ** following structure.
132222f70c32Sdrh **
1323d24cc427Sdrh ** Table.zName is the name of the table.  The case of the original
132422f70c32Sdrh ** CREATE TABLE statement is stored, but case is not significant for
132522f70c32Sdrh ** comparisons.
132622f70c32Sdrh **
1327d24cc427Sdrh ** Table.nCol is the number of columns in this table.  Table.aCol is a
132822f70c32Sdrh ** pointer to an array of Column structures, one for each column.
132922f70c32Sdrh **
1330d24cc427Sdrh ** If the table has an INTEGER PRIMARY KEY, then Table.iPKey is the index of
1331d24cc427Sdrh ** the column that is that key.   Otherwise Table.iPKey is negative.  Note
133222f70c32Sdrh ** that the datatype of the PRIMARY KEY must be INTEGER for this field to
133322f70c32Sdrh ** be set.  An INTEGER PRIMARY KEY is used as the rowid for each row of
133422f70c32Sdrh ** the table.  If a table has no INTEGER PRIMARY KEY, then a random rowid
13357d10d5a6Sdrh ** is generated for each row of the table.  TF_HasPrimaryKey is set if
133622f70c32Sdrh ** the table has any PRIMARY KEY, INTEGER or otherwise.
133722f70c32Sdrh **
1338d24cc427Sdrh ** Table.tnum is the page number for the root BTree page of the table in the
1339d24cc427Sdrh ** database file.  If Table.iDb is the index of the database table backend
1340d24cc427Sdrh ** in sqlite.aDb[].  0 is for the main database and 1 is for the file that
13417d10d5a6Sdrh ** holds temporary tables and indices.  If TF_Ephemeral is set
13427d10d5a6Sdrh ** then the table is stored in a file that is automatically deleted
1343d24cc427Sdrh ** when the VDBE cursor to the table is closed.  In this case Table.tnum
134422f70c32Sdrh ** refers VDBE cursor number that holds the table open, not to the root
134522f70c32Sdrh ** page number.  Transient tables are used to hold the results of a
134622f70c32Sdrh ** sub-query that appears instead of a real table name in the FROM clause
134722f70c32Sdrh ** of a SELECT statement.
134875897234Sdrh */
134975897234Sdrh struct Table {
13507d10d5a6Sdrh   char *zName;         /* Name of the table or view */
13517020f651Sdrh   Column *aCol;        /* Information about each column */
1352967e8b73Sdrh   Index *pIndex;       /* List of SQL indexes on this table. */
1353a76b5dfcSdrh   Select *pSelect;     /* NULL for tables.  Points to definition if a view. */
1354c2eef3b3Sdrh   FKey *pFKey;         /* Linked list of all foreign keys in this table */
13553d1bfeaaSdanielk1977   char *zColAff;       /* String defining the affinity of each column */
1356ffe07b2dSdrh #ifndef SQLITE_OMIT_CHECK
13572938f924Sdrh   ExprList *pCheck;    /* All CHECK constraints */
1358ffe07b2dSdrh #endif
1359d815f17dSdrh   tRowcnt nRowEst;     /* Estimated rows in table - from sqlite_stat1 table */
1360d815f17dSdrh   int tnum;            /* Root BTree node for this table (see note above) */
1361d815f17dSdrh   i16 iPKey;           /* If not negative, use aCol[iPKey] as the primary key */
1362d815f17dSdrh   i16 nCol;            /* Number of columns in this table */
1363d815f17dSdrh   u16 nRef;            /* Number of pointers to this Table */
1364d815f17dSdrh   u8 tabFlags;         /* Mask of TF_* values */
1365d815f17dSdrh   u8 keyConf;          /* What to do in case of uniqueness conflict on iPKey */
136619a8e7e8Sdanielk1977 #ifndef SQLITE_OMIT_ALTERTABLE
13677d10d5a6Sdrh   int addColOffset;    /* Offset in CREATE TABLE stmt to add a new column */
136819a8e7e8Sdanielk1977 #endif
1369e09daa90Sdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
1370b9bb7c18Sdrh   int nModuleArg;      /* Number of arguments to the module */
1371b9bb7c18Sdrh   char **azModuleArg;  /* Text of all module args. [0] is module name */
1372d815f17dSdrh   VTable *pVTable;     /* List of VTable objects. */
1373e09daa90Sdrh #endif
13742f886d1dSdanielk1977   Trigger *pTrigger;   /* List of triggers stored in pSchema */
1375728b5779Sdrh   Schema *pSchema;     /* Schema that contains this table */
1376588a9a1aSdrh   Table *pNextZombie;  /* Next on the Parse.pZombieTab list */
137775897234Sdrh };
137875897234Sdrh 
137975897234Sdrh /*
13807d10d5a6Sdrh ** Allowed values for Tabe.tabFlags.
13817d10d5a6Sdrh */
13827d10d5a6Sdrh #define TF_Readonly        0x01    /* Read-only system table */
1383467bcf36Sshane #define TF_Ephemeral       0x02    /* An ephemeral table */
13847d10d5a6Sdrh #define TF_HasPrimaryKey   0x04    /* Table has a primary key */
13857d10d5a6Sdrh #define TF_Autoincrement   0x08    /* Integer primary key is autoincrement */
13867d10d5a6Sdrh #define TF_Virtual         0x10    /* Is a virtual table */
13877d10d5a6Sdrh 
13887d10d5a6Sdrh 
13897d10d5a6Sdrh /*
13904cbdda9eSdrh ** Test to see whether or not a table is a virtual table.  This is
13914cbdda9eSdrh ** done as a macro so that it will be optimized out when virtual
13924cbdda9eSdrh ** table support is omitted from the build.
13934cbdda9eSdrh */
13944cbdda9eSdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
13957d10d5a6Sdrh #  define IsVirtual(X)      (((X)->tabFlags & TF_Virtual)!=0)
1396a371ace4Sdrh #  define IsHiddenColumn(X) (((X)->colFlags & COLFLAG_HIDDEN)!=0)
13974cbdda9eSdrh #else
13984cbdda9eSdrh #  define IsVirtual(X)      0
1399034ca14fSdanielk1977 #  define IsHiddenColumn(X) 0
14004cbdda9eSdrh #endif
14014cbdda9eSdrh 
14024cbdda9eSdrh /*
1403c2eef3b3Sdrh ** Each foreign key constraint is an instance of the following structure.
1404c2eef3b3Sdrh **
1405c2eef3b3Sdrh ** A foreign key is associated with two tables.  The "from" table is
1406c2eef3b3Sdrh ** the table that contains the REFERENCES clause that creates the foreign
1407c2eef3b3Sdrh ** key.  The "to" table is the table that is named in the REFERENCES clause.
1408c2eef3b3Sdrh ** Consider this example:
1409c2eef3b3Sdrh **
1410c2eef3b3Sdrh **     CREATE TABLE ex1(
1411c2eef3b3Sdrh **       a INTEGER PRIMARY KEY,
1412c2eef3b3Sdrh **       b INTEGER CONSTRAINT fk1 REFERENCES ex2(x)
1413c2eef3b3Sdrh **     );
1414c2eef3b3Sdrh **
1415c2eef3b3Sdrh ** For foreign key "fk1", the from-table is "ex1" and the to-table is "ex2".
1416c2eef3b3Sdrh **
1417c2eef3b3Sdrh ** Each REFERENCES clause generates an instance of the following structure
1418c2eef3b3Sdrh ** which is attached to the from-table.  The to-table need not exist when
1419e61922a6Sdrh ** the from-table is created.  The existence of the to-table is not checked.
1420c2eef3b3Sdrh */
1421c2eef3b3Sdrh struct FKey {
14221f638cebSdrh   Table *pFrom;     /* Table containing the REFERENCES clause (aka: Child) */
1423c2eef3b3Sdrh   FKey *pNextFrom;  /* Next foreign key in pFrom */
14241f638cebSdrh   char *zTo;        /* Name of table that the key points to (aka: Parent) */
14251da40a38Sdan   FKey *pNextTo;    /* Next foreign key on table named zTo */
14261da40a38Sdan   FKey *pPrevTo;    /* Previous foreign key on table named zTo */
1427c2eef3b3Sdrh   int nCol;         /* Number of columns in this key */
14284c429839Sdrh   /* EV: R-30323-21917 */
1429c2eef3b3Sdrh   u8 isDeferred;    /* True if constraint checking is deferred till COMMIT */
14308099ce6fSdan   u8 aAction[2];          /* ON DELETE and ON UPDATE actions, respectively */
14318099ce6fSdan   Trigger *apTrigger[2];  /* Triggers for aAction[] actions */
1432e61922a6Sdrh   struct sColMap {  /* Mapping of columns in pFrom to columns in zTo */
1433e61922a6Sdrh     int iFrom;         /* Index of column in pFrom */
1434e61922a6Sdrh     char *zCol;        /* Name of column in zTo.  If 0 use PRIMARY KEY */
1435e61922a6Sdrh   } aCol[1];        /* One entry for each of nCol column s */
1436c2eef3b3Sdrh };
1437c2eef3b3Sdrh 
1438c2eef3b3Sdrh /*
1439aaa40c1cSdanielk1977 ** SQLite supports many different ways to resolve a constraint
144022f70c32Sdrh ** error.  ROLLBACK processing means that a constraint violation
14410bd1f4eaSdrh ** causes the operation in process to fail and for the current transaction
14421c92853dSdrh ** to be rolled back.  ABORT processing means the operation in process
14431c92853dSdrh ** fails and any prior changes from that one operation are backed out,
14441c92853dSdrh ** but the transaction is not rolled back.  FAIL processing means that
14451c92853dSdrh ** the operation in progress stops and returns an error code.  But prior
14461c92853dSdrh ** changes due to the same operation are not backed out and no rollback
14471c92853dSdrh ** occurs.  IGNORE means that the particular row that caused the constraint
14481c92853dSdrh ** error is not inserted or updated.  Processing continues and no error
14491c92853dSdrh ** is returned.  REPLACE means that preexisting database rows that caused
14501c92853dSdrh ** a UNIQUE constraint violation are removed so that the new insert or
14511c92853dSdrh ** update can proceed.  Processing continues and no error is reported.
14521c92853dSdrh **
1453c2eef3b3Sdrh ** RESTRICT, SETNULL, and CASCADE actions apply only to foreign keys.
1454c2eef3b3Sdrh ** RESTRICT is the same as ABORT for IMMEDIATE foreign keys and the
1455c2eef3b3Sdrh ** same as ROLLBACK for DEFERRED keys.  SETNULL means that the foreign
1456c2eef3b3Sdrh ** key is set to NULL.  CASCADE means that a DELETE or UPDATE of the
1457c2eef3b3Sdrh ** referenced table row is propagated into the row that holds the
1458c2eef3b3Sdrh ** foreign key.
1459c2eef3b3Sdrh **
1460968af52aSdrh ** The following symbolic values are used to record which type
14611c92853dSdrh ** of action to take.
14629cfcf5d4Sdrh */
14639cfcf5d4Sdrh #define OE_None     0   /* There is no constraint to check */
14641c92853dSdrh #define OE_Rollback 1   /* Fail the operation and rollback the transaction */
14651c92853dSdrh #define OE_Abort    2   /* Back out changes but do no rollback transaction */
14661c92853dSdrh #define OE_Fail     3   /* Stop the operation but leave all prior changes */
14671c92853dSdrh #define OE_Ignore   4   /* Ignore the error. Do not do the INSERT or UPDATE */
14681c92853dSdrh #define OE_Replace  5   /* Delete existing record, then do INSERT or UPDATE */
1469c2eef3b3Sdrh 
1470c2eef3b3Sdrh #define OE_Restrict 6   /* OE_Abort for IMMEDIATE, OE_Rollback for DEFERRED */
1471c2eef3b3Sdrh #define OE_SetNull  7   /* Set the foreign key value to NULL */
1472c2eef3b3Sdrh #define OE_SetDflt  8   /* Set the foreign key value to its default */
1473c2eef3b3Sdrh #define OE_Cascade  9   /* Cascade the changes */
1474c2eef3b3Sdrh 
1475c2eef3b3Sdrh #define OE_Default  99  /* Do whatever the default action is */
14769cfcf5d4Sdrh 
1477d3d39e93Sdrh 
1478d3d39e93Sdrh /*
1479d3d39e93Sdrh ** An instance of the following structure is passed as the first
1480d3d39e93Sdrh ** argument to sqlite3VdbeKeyCompare and is used to control the
1481d3d39e93Sdrh ** comparison of the two index keys.
1482323df790Sdrh **
1483323df790Sdrh ** Note that aSortOrder[] and aColl[] have nField+1 slots.  There
1484323df790Sdrh ** are nField slots for the columns of an index then one extra slot
1485323df790Sdrh ** for the rowid at the end.
1486d3d39e93Sdrh */
1487d3d39e93Sdrh struct KeyInfo {
1488b21c8cd4Sdrh   sqlite3 *db;        /* The database connection */
14899b8d0272Sdrh   u8 enc;             /* Text encoding - one of the SQLITE_UTF* values */
1490323df790Sdrh   u16 nField;         /* Maximum index for aColl[] and aSortOrder[] */
1491323df790Sdrh   u8 *aSortOrder;     /* Sort order for each column. */
1492d3d39e93Sdrh   CollSeq *aColl[1];  /* Collating sequence for each term of the key */
1493d3d39e93Sdrh };
1494d3d39e93Sdrh 
14959cfcf5d4Sdrh /*
1496e63d9991Sdrh ** An instance of the following structure holds information about a
1497e63d9991Sdrh ** single index record that has already been parsed out into individual
1498e63d9991Sdrh ** values.
1499e63d9991Sdrh **
1500e63d9991Sdrh ** A record is an object that contains one or more fields of data.
1501e63d9991Sdrh ** Records are used to store the content of a table row and to store
1502e63d9991Sdrh ** the key of an index.  A blob encoding of a record is created by
1503467bcf36Sshane ** the OP_MakeRecord opcode of the VDBE and is disassembled by the
1504e63d9991Sdrh ** OP_Column opcode.
1505e63d9991Sdrh **
1506e63d9991Sdrh ** This structure holds a record that has already been disassembled
1507467bcf36Sshane ** into its constituent fields.
1508e63d9991Sdrh */
1509e63d9991Sdrh struct UnpackedRecord {
1510e63d9991Sdrh   KeyInfo *pKeyInfo;  /* Collation and sort-order information */
1511e63d9991Sdrh   u16 nField;         /* Number of entries in apMem[] */
151276a3acacSdrh   u8 flags;           /* Boolean settings.  UNPACKED_... below */
1513de630353Sdanielk1977   i64 rowid;          /* Used by UNPACKED_PREFIX_SEARCH */
1514e63d9991Sdrh   Mem *aMem;          /* Values */
1515e63d9991Sdrh };
1516e63d9991Sdrh 
1517e63d9991Sdrh /*
1518e63d9991Sdrh ** Allowed values of UnpackedRecord.flags
1519e63d9991Sdrh */
152076a3acacSdrh #define UNPACKED_INCRKEY       0x01  /* Make this key an epsilon larger */
152176a3acacSdrh #define UNPACKED_PREFIX_MATCH  0x02  /* A prefix match is considered OK */
152276a3acacSdrh #define UNPACKED_PREFIX_SEARCH 0x04  /* Ignore final (rowid) field */
1523e63d9991Sdrh 
1524e63d9991Sdrh /*
152566b89c8fSdrh ** Each SQL index is represented in memory by an
152675897234Sdrh ** instance of the following structure.
1527967e8b73Sdrh **
1528967e8b73Sdrh ** The columns of the table that are to be indexed are described
1529967e8b73Sdrh ** by the aiColumn[] field of this structure.  For example, suppose
1530967e8b73Sdrh ** we have the following table and index:
1531967e8b73Sdrh **
1532967e8b73Sdrh **     CREATE TABLE Ex1(c1 int, c2 int, c3 text);
1533967e8b73Sdrh **     CREATE INDEX Ex2 ON Ex1(c3,c1);
1534967e8b73Sdrh **
1535967e8b73Sdrh ** In the Table structure describing Ex1, nCol==3 because there are
1536967e8b73Sdrh ** three columns in the table.  In the Index structure describing
1537967e8b73Sdrh ** Ex2, nColumn==2 since 2 of the 3 columns of Ex1 are indexed.
1538967e8b73Sdrh ** The value of aiColumn is {2, 0}.  aiColumn[0]==2 because the
1539967e8b73Sdrh ** first column to be indexed (c3) has an index of 2 in Ex1.aCol[].
1540967e8b73Sdrh ** The second column to be indexed (c1) has an index of 0 in
1541967e8b73Sdrh ** Ex1.aCol[], hence Ex2.aiColumn[1]==0.
1542ea1ba17cSdrh **
1543ea1ba17cSdrh ** The Index.onError field determines whether or not the indexed columns
1544ea1ba17cSdrh ** must be unique and what to do if they are not.  When Index.onError=OE_None,
1545ea1ba17cSdrh ** it means this is not a unique index.  Otherwise it is a unique index
1546ea1ba17cSdrh ** and the value of Index.onError indicate the which conflict resolution
1547ea1ba17cSdrh ** algorithm to employ whenever an attempt is made to insert a non-unique
1548ea1ba17cSdrh ** element.
154975897234Sdrh */
155075897234Sdrh struct Index {
155175897234Sdrh   char *zName;             /* Name of this index */
1552967e8b73Sdrh   int *aiColumn;           /* Which columns are used by this index.  1st is 0 */
1553b376daebSdrh   tRowcnt *aiRowEst;       /* From ANALYZE: Est. rows selected by each column */
1554967e8b73Sdrh   Table *pTable;           /* The SQL table being indexed */
1555a37cdde0Sdanielk1977   char *zColAff;           /* String defining the affinity of each column */
155675897234Sdrh   Index *pNext;            /* The next index associated with the same table */
1557b3bf556eSdanielk1977   Schema *pSchema;         /* Schema containing this index */
1558b376daebSdrh   u8 *aSortOrder;          /* for each column: True==DESC, False==ASC */
1559b3bf556eSdanielk1977   char **azColl;           /* Array of collation sequence names for index */
15601fe0537eSdrh   Expr *pPartIdxWhere;     /* WHERE clause for partial indices */
1561b376daebSdrh   int tnum;                /* DB Page containing root of this index */
1562b376daebSdrh   u16 nColumn;             /* Number of columns in table used by this index */
1563a451017dSdrh   u8 onError;              /* OE_Abort, OE_Ignore, OE_Replace, or OE_None */
1564b376daebSdrh   unsigned autoIndex:2;    /* 1==UNIQUE, 2==PRIMARY KEY, 0==CREATE INDEX */
1565b376daebSdrh   unsigned bUnordered:1;   /* Use this index for == or IN queries only */
15667699d1c4Sdrh   unsigned uniqNotNull:1;  /* True if UNIQUE and NOT NULL for all columns */
15671435a9a1Sdrh #ifdef SQLITE_ENABLE_STAT3_OR_STAT4
15682b9cf669Sdrh   int nSample;             /* Number of elements in aSample[] */
15698ad169abSdan   int nSampleCol;          /* Size of IndexSample.anEq[] and so on */
1570eea568d6Sdan   tRowcnt *aAvgEq;         /* Average nEq values for keys not in aSample */
1571faacf17cSdrh   IndexSample *aSample;    /* Samples of the left-most key */
1572faacf17cSdrh #endif
157302fa4696Sdan };
157402fa4696Sdan 
157502fa4696Sdan /*
157674e7c8f5Sdrh ** Each sample stored in the sqlite_stat3 table is represented in memory
157774e7c8f5Sdrh ** using a structure of this type.  See documentation at the top of the
157874e7c8f5Sdrh ** analyze.c source file for additional information.
157902fa4696Sdan */
158002fa4696Sdan struct IndexSample {
1581f52bb8d3Sdan   void *p;          /* Pointer to sampled record */
1582f52bb8d3Sdan   int n;            /* Size of record in bytes */
1583f52bb8d3Sdan   tRowcnt *anEq;    /* Est. number of rows where the key equals this sample */
1584f52bb8d3Sdan   tRowcnt *anLt;    /* Est. number of rows where key is less than this sample */
1585f52bb8d3Sdan   tRowcnt *anDLt;   /* Est. number of distinct keys less than this sample */
158675897234Sdrh };
158775897234Sdrh 
158875897234Sdrh /*
158975897234Sdrh ** Each token coming out of the lexer is an instance of
15904b59ab5eSdrh ** this structure.  Tokens are also used as part of an expression.
15914efc4754Sdrh **
15924efc4754Sdrh ** Note if Token.z==0 then Token.dyn and Token.n are undefined and
1593467bcf36Sshane ** may contain random values.  Do not make any assumptions about Token.dyn
15944efc4754Sdrh ** and Token.n when Token.z==0.
159575897234Sdrh */
159675897234Sdrh struct Token {
1597b7916a78Sdrh   const char *z;     /* Text of the token.  Not NULL-terminated! */
1598b7916a78Sdrh   unsigned int n;    /* Number of characters in this token */
159975897234Sdrh };
160075897234Sdrh 
160175897234Sdrh /*
160213449892Sdrh ** An instance of this structure contains information needed to generate
160313449892Sdrh ** code for a SELECT that contains aggregate functions.
160413449892Sdrh **
160513449892Sdrh ** If Expr.op==TK_AGG_COLUMN or TK_AGG_FUNCTION then Expr.pAggInfo is a
160613449892Sdrh ** pointer to this structure.  The Expr.iColumn field is the index in
160713449892Sdrh ** AggInfo.aCol[] or AggInfo.aFunc[] of information needed to generate
160813449892Sdrh ** code for that node.
160913449892Sdrh **
161013449892Sdrh ** AggInfo.pGroupBy and AggInfo.aFunc.pExpr point to fields within the
161113449892Sdrh ** original Select structure that describes the SELECT statement.  These
161213449892Sdrh ** fields do not need to be freed when deallocating the AggInfo structure.
161313449892Sdrh */
161413449892Sdrh struct AggInfo {
161513449892Sdrh   u8 directMode;          /* Direct rendering mode means take data directly
161613449892Sdrh                           ** from source tables rather than from accumulators */
161713449892Sdrh   u8 useSortingIdx;       /* In direct mode, reference the sorting index rather
161813449892Sdrh                           ** than the source table */
161913449892Sdrh   int sortingIdx;         /* Cursor number of the sorting index */
16205134d135Sdan   int sortingIdxPTab;     /* Cursor number of pseudo-table */
162113449892Sdrh   int nSortingColumn;     /* Number of columns in the sorting index */
1622a451017dSdrh   ExprList *pGroupBy;     /* The group by clause */
162313449892Sdrh   struct AggInfo_col {    /* For each column used in source tables */
16240817d0dfSdanielk1977     Table *pTab;             /* Source table */
162513449892Sdrh     int iTable;              /* Cursor number of the source table */
162613449892Sdrh     int iColumn;             /* Column number within the source table */
162713449892Sdrh     int iSorterColumn;       /* Column number in the sorting index */
162813449892Sdrh     int iMem;                /* Memory location that acts as accumulator */
16295774b806Sdrh     Expr *pExpr;             /* The original expression */
163013449892Sdrh   } *aCol;
163113449892Sdrh   int nColumn;            /* Number of used entries in aCol[] */
163213449892Sdrh   int nAccumulator;       /* Number of columns that show through to the output.
163313449892Sdrh                           ** Additional columns are used only as parameters to
163413449892Sdrh                           ** aggregate functions */
163513449892Sdrh   struct AggInfo_func {   /* For each aggregate function */
163613449892Sdrh     Expr *pExpr;             /* Expression encoding the function */
163713449892Sdrh     FuncDef *pFunc;          /* The aggregate function implementation */
163813449892Sdrh     int iMem;                /* Memory location that acts as accumulator */
1639467bcf36Sshane     int iDistinct;           /* Ephemeral table used to enforce DISTINCT */
164013449892Sdrh   } *aFunc;
164113449892Sdrh   int nFunc;              /* Number of entries in aFunc[] */
164213449892Sdrh };
164313449892Sdrh 
164413449892Sdrh /*
16458677d308Sdrh ** The datatype ynVar is a signed integer, either 16-bit or 32-bit.
16468677d308Sdrh ** Usually it is 16-bits.  But if SQLITE_MAX_VARIABLE_NUMBER is greater
16478677d308Sdrh ** than 32767 we have to make it 32-bit.  16-bit is preferred because
16488677d308Sdrh ** it uses less memory in the Expr object, which is a big memory user
16498677d308Sdrh ** in systems with lots of prepared statements.  And few applications
16508677d308Sdrh ** need more than about 10 or 20 variables.  But some extreme users want
16518677d308Sdrh ** to have prepared statements with over 32767 variables, and for them
16528677d308Sdrh ** the option is available (at compile-time).
16538677d308Sdrh */
16548677d308Sdrh #if SQLITE_MAX_VARIABLE_NUMBER<=32767
1655481aa74eSdrh typedef i16 ynVar;
16568677d308Sdrh #else
16578677d308Sdrh typedef int ynVar;
16588677d308Sdrh #endif
16598677d308Sdrh 
16608677d308Sdrh /*
166175897234Sdrh ** Each node of an expression in the parse tree is an instance
166222f70c32Sdrh ** of this structure.
166322f70c32Sdrh **
166422f70c32Sdrh ** Expr.op is the opcode. The integer parser token codes are reused
166522f70c32Sdrh ** as opcodes here. For example, the parser defines TK_GE to be an integer
166622f70c32Sdrh ** code representing the ">=" operator. This same integer code is reused
166722f70c32Sdrh ** to represent the greater-than-or-equal-to operator in the expression
166822f70c32Sdrh ** tree.
166922f70c32Sdrh **
16706ab3a2ecSdanielk1977 ** If the expression is an SQL literal (TK_INTEGER, TK_FLOAT, TK_BLOB,
16716ab3a2ecSdanielk1977 ** or TK_STRING), then Expr.token contains the text of the SQL literal. If
16726ab3a2ecSdanielk1977 ** the expression is a variable (TK_VARIABLE), then Expr.token contains the
16736ab3a2ecSdanielk1977 ** variable name. Finally, if the expression is an SQL function (TK_FUNCTION),
16746ab3a2ecSdanielk1977 ** then Expr.token contains the name of the function.
167522f70c32Sdrh **
16766ab3a2ecSdanielk1977 ** Expr.pRight and Expr.pLeft are the left and right subexpressions of a
16776ab3a2ecSdanielk1977 ** binary operator. Either or both may be NULL.
16786ab3a2ecSdanielk1977 **
16796ab3a2ecSdanielk1977 ** Expr.x.pList is a list of arguments if the expression is an SQL function,
16806ab3a2ecSdanielk1977 ** a CASE expression or an IN expression of the form "<lhs> IN (<y>, <z>...)".
16816ab3a2ecSdanielk1977 ** Expr.x.pSelect is used if the expression is a sub-select or an expression of
16826ab3a2ecSdanielk1977 ** the form "<lhs> IN (SELECT ...)". If the EP_xIsSelect bit is set in the
16836ab3a2ecSdanielk1977 ** Expr.flags mask, then Expr.x.pSelect is valid. Otherwise, Expr.x.pList is
16846ab3a2ecSdanielk1977 ** valid.
168522f70c32Sdrh **
168622f70c32Sdrh ** An expression of the form ID or ID.ID refers to a column in a table.
168722f70c32Sdrh ** For such expressions, Expr.op is set to TK_COLUMN and Expr.iTable is
168822f70c32Sdrh ** the integer cursor number of a VDBE cursor pointing to that table and
168922f70c32Sdrh ** Expr.iColumn is the column number for the specific column.  If the
169022f70c32Sdrh ** expression is used as a result in an aggregate SELECT, then the
169122f70c32Sdrh ** value is also stored in the Expr.iAgg column in the aggregate so that
169222f70c32Sdrh ** it can be accessed after all aggregates are computed.
169322f70c32Sdrh **
16946ab3a2ecSdanielk1977 ** If the expression is an unbound variable marker (a question mark
16956ab3a2ecSdanielk1977 ** character '?' in the original SQL) then the Expr.iTable holds the index
16966ab3a2ecSdanielk1977 ** number for that variable.
169722f70c32Sdrh **
16981398ad36Sdrh ** If the expression is a subquery then Expr.iColumn holds an integer
16991398ad36Sdrh ** register number containing the result of the subquery.  If the
17001398ad36Sdrh ** subquery gives a constant result, then iTable is -1.  If the subquery
17011398ad36Sdrh ** gives a different answer at different times during statement processing
17021398ad36Sdrh ** then iTable is the address of a subroutine that computes the subquery.
17031398ad36Sdrh **
1704aee18ef8Sdanielk1977 ** If the Expr is of type OP_Column, and the table it is selecting from
1705aee18ef8Sdanielk1977 ** is a disk table or the "old.*" pseudo-table, then pTab points to the
1706aee18ef8Sdanielk1977 ** corresponding table definition.
17076ab3a2ecSdanielk1977 **
17086ab3a2ecSdanielk1977 ** ALLOCATION NOTES:
17096ab3a2ecSdanielk1977 **
171012ffee8cSdrh ** Expr objects can use a lot of memory space in database schema.  To
171112ffee8cSdrh ** help reduce memory requirements, sometimes an Expr object will be
171212ffee8cSdrh ** truncated.  And to reduce the number of memory allocations, sometimes
171312ffee8cSdrh ** two or more Expr objects will be stored in a single memory allocation,
171433e619fcSdrh ** together with Expr.zToken strings.
17156ab3a2ecSdanielk1977 **
1716b7916a78Sdrh ** If the EP_Reduced and EP_TokenOnly flags are set when
171712ffee8cSdrh ** an Expr object is truncated.  When EP_Reduced is set, then all
171812ffee8cSdrh ** the child Expr objects in the Expr.pLeft and Expr.pRight subtrees
171912ffee8cSdrh ** are contained within the same memory allocation.  Note, however, that
172012ffee8cSdrh ** the subtrees in Expr.x.pList or Expr.x.pSelect are always separately
172112ffee8cSdrh ** allocated, regardless of whether or not EP_Reduced is set.
172275897234Sdrh */
172375897234Sdrh struct Expr {
17241cc093c2Sdrh   u8 op;                 /* Operation performed by this node */
1725a9fd84b0Sdrh   char affinity;         /* The affinity of the column or 0 if not a column */
17261af466ebSdrh   u16 flags;             /* Various flags.  EP_* See below */
172733e619fcSdrh   union {
1728b7916a78Sdrh     char *zToken;          /* Token value. Zero terminated and dequoted */
1729d50ffc41Sdrh     int iValue;            /* Non-negative integer value if EP_IntValue */
173033e619fcSdrh   } u;
17316ab3a2ecSdanielk1977 
17326ab3a2ecSdanielk1977   /* If the EP_TokenOnly flag is set in the Expr.flags mask, then no
17336ab3a2ecSdanielk1977   ** space is allocated for the fields below this point. An attempt to
17346ab3a2ecSdanielk1977   ** access them will result in a segfault or malfunction.
17356ab3a2ecSdanielk1977   *********************************************************************/
17366ab3a2ecSdanielk1977 
17376ab3a2ecSdanielk1977   Expr *pLeft;           /* Left subnode */
17386ab3a2ecSdanielk1977   Expr *pRight;          /* Right subnode */
17396ab3a2ecSdanielk1977   union {
17406ab3a2ecSdanielk1977     ExprList *pList;     /* Function arguments or in "<expr> IN (<expr-list)" */
17416ab3a2ecSdanielk1977     Select *pSelect;     /* Used for sub-selects and "<expr> IN (<select>)" */
17426ab3a2ecSdanielk1977   } x;
17436ab3a2ecSdanielk1977 
17446ab3a2ecSdanielk1977   /* If the EP_Reduced flag is set in the Expr.flags mask, then no
17456ab3a2ecSdanielk1977   ** space is allocated for the fields below this point. An attempt to
17466ab3a2ecSdanielk1977   ** access them will result in a segfault or malfunction.
17476ab3a2ecSdanielk1977   *********************************************************************/
17486ab3a2ecSdanielk1977 
17496ec65491Sdrh #if SQLITE_MAX_EXPR_DEPTH>0
17506ec65491Sdrh   int nHeight;           /* Height of the tree headed by this node */
17516ec65491Sdrh #endif
1752b7916a78Sdrh   int iTable;            /* TK_COLUMN: cursor number of table holding column
17532832ad42Sdan                          ** TK_REGISTER: register number
17542832ad42Sdan                          ** TK_TRIGGER: 1 -> new, 0 -> old */
17558677d308Sdrh   ynVar iColumn;         /* TK_COLUMN: column index.  -1 for rowid.
1756937d0deaSdan                          ** TK_VARIABLE: variable number (always >= 1). */
1757b7916a78Sdrh   i16 iAgg;              /* Which entry in pAggInfo->aCol[] or ->aFunc[] */
1758b7916a78Sdrh   i16 iRightJoinTable;   /* If EP_FromJoin, the right table of the join */
1759fcd4a150Sdan   u8 flags2;             /* Second set of flags.  EP2_... */
1760030796dfSdrh   u8 op2;                /* TK_REGISTER: original value of Expr.op
1761030796dfSdrh                          ** TK_COLUMN: the value of p5 for OP_Column
1762030796dfSdrh                          ** TK_AGG_FUNCTION: nesting depth */
176313449892Sdrh   AggInfo *pAggInfo;     /* Used by TK_AGG_COLUMN and TK_AGG_FUNCTION */
17647d10d5a6Sdrh   Table *pTab;           /* Table for TK_COLUMN expressions. */
176575897234Sdrh };
176675897234Sdrh 
176775897234Sdrh /*
17681f16230bSdrh ** The following are the meanings of bits in the Expr.flags field.
17691f16230bSdrh */
1770678ccce8Sdrh #define EP_FromJoin   0x0001  /* Originated in ON or USING clause of a join */
1771678ccce8Sdrh #define EP_Agg        0x0002  /* Contains one or more aggregate functions */
1772678ccce8Sdrh #define EP_Resolved   0x0004  /* IDs have been resolved to COLUMNs */
1773678ccce8Sdrh #define EP_Error      0x0008  /* Expression contains one or more errors */
1774678ccce8Sdrh #define EP_Distinct   0x0010  /* Aggregate function with DISTINCT keyword */
1775678ccce8Sdrh #define EP_VarSelect  0x0020  /* pSelect is correlated, not constant */
177624fb627aSdrh #define EP_DblQuoted  0x0040  /* token.z was originally in "..." */
1777678ccce8Sdrh #define EP_InfixFunc  0x0080  /* True for an infix function: LIKE, GLOB, etc */
1778ae80ddeaSdrh #define EP_Collate    0x0100  /* Tree contains a TK_COLLATE opeartor */
1779b6da74ebSdrh #define EP_FixedDest  0x0200  /* Result needed in a specific register */
1780b6da74ebSdrh #define EP_IntValue   0x0400  /* Integer value contained in u.iValue */
1781b6da74ebSdrh #define EP_xIsSelect  0x0800  /* x.pSelect is valid (otherwise x.pList is) */
1782a748fdccSdrh #define EP_Hint       0x1000  /* Not used */
1783678a9aa7Sdrh #define EP_Reduced    0x2000  /* Expr struct is EXPR_REDUCEDSIZE bytes only */
1784678a9aa7Sdrh #define EP_TokenOnly  0x4000  /* Expr struct is EXPR_TOKENONLYSIZE bytes only */
1785678a9aa7Sdrh #define EP_Static     0x8000  /* Held in memory not obtained from malloc() */
17866ab3a2ecSdanielk1977 
17871f16230bSdrh /*
1788b7916a78Sdrh ** The following are the meanings of bits in the Expr.flags2 field.
17891af466ebSdrh */
179033e619fcSdrh #define EP2_MallocedToken  0x0001  /* Need to sqlite3DbFree() Expr.zToken */
179133e619fcSdrh #define EP2_Irreducible    0x0002  /* Cannot EXPRDUP_REDUCE this Expr */
179233e619fcSdrh 
179333e619fcSdrh /*
179433e619fcSdrh ** The pseudo-routine sqlite3ExprSetIrreducible sets the EP2_Irreducible
179533e619fcSdrh ** flag on an expression structure.  This flag is used for VV&A only.  The
179633e619fcSdrh ** routine is implemented as a macro that only works when in debugging mode,
179733e619fcSdrh ** so as not to burden production code.
179833e619fcSdrh */
179933e619fcSdrh #ifdef SQLITE_DEBUG
180033e619fcSdrh # define ExprSetIrreducible(X)  (X)->flags2 |= EP2_Irreducible
180133e619fcSdrh #else
180233e619fcSdrh # define ExprSetIrreducible(X)
180333e619fcSdrh #endif
18041af466ebSdrh 
18051af466ebSdrh /*
18061f16230bSdrh ** These macros can be used to test, set, or clear bits in the
18071f16230bSdrh ** Expr.flags field.
18081f16230bSdrh */
18091f16230bSdrh #define ExprHasProperty(E,P)     (((E)->flags&(P))==(P))
18101f16230bSdrh #define ExprHasAnyProperty(E,P)  (((E)->flags&(P))!=0)
18111f16230bSdrh #define ExprSetProperty(E,P)     (E)->flags|=(P)
18121f16230bSdrh #define ExprClearProperty(E,P)   (E)->flags&=~(P)
18131f16230bSdrh 
18141f16230bSdrh /*
18156ab3a2ecSdanielk1977 ** Macros to determine the number of bytes required by a normal Expr
18166ab3a2ecSdanielk1977 ** struct, an Expr struct with the EP_Reduced flag set in Expr.flags
18176ab3a2ecSdanielk1977 ** and an Expr struct with the EP_TokenOnly flag set.
18186ab3a2ecSdanielk1977 */
181912ffee8cSdrh #define EXPR_FULLSIZE           sizeof(Expr)           /* Full size */
182012ffee8cSdrh #define EXPR_REDUCEDSIZE        offsetof(Expr,iTable)  /* Common features */
1821b7916a78Sdrh #define EXPR_TOKENONLYSIZE      offsetof(Expr,pLeft)   /* Fewer features */
18226ab3a2ecSdanielk1977 
18236ab3a2ecSdanielk1977 /*
18246ab3a2ecSdanielk1977 ** Flags passed to the sqlite3ExprDup() function. See the header comment
18256ab3a2ecSdanielk1977 ** above sqlite3ExprDup() for details.
18266ab3a2ecSdanielk1977 */
182712ffee8cSdrh #define EXPRDUP_REDUCE         0x0001  /* Used reduced-size Expr nodes */
18286ab3a2ecSdanielk1977 
18296ab3a2ecSdanielk1977 /*
183075897234Sdrh ** A list of expressions.  Each expression may optionally have a
183175897234Sdrh ** name.  An expr/name combination can be used in several ways, such
183275897234Sdrh ** as the list of "expr AS ID" fields following a "SELECT" or in the
183375897234Sdrh ** list of "ID = expr" items in an UPDATE.  A list of expressions can
1834ad3cab52Sdrh ** also be used as the argument to a function, in which case the a.zName
183575897234Sdrh ** field is not used.
18360dde4739Sdrh **
18370dde4739Sdrh ** By default the Expr.zSpan field holds a human-readable description of
18380dde4739Sdrh ** the expression that is used in the generation of error messages and
18390dde4739Sdrh ** column labels.  In this case, Expr.zSpan is typically the text of a
18400dde4739Sdrh ** column expression as it exists in a SELECT statement.  However, if
18410dde4739Sdrh ** the bSpanIsTab flag is set, then zSpan is overloaded to mean the name
18423e3f1a5bSdrh ** of the result column in the form: DATABASE.TABLE.COLUMN.  This later
18433e3f1a5bSdrh ** form is used for name resolution with nested FROM clauses.
184475897234Sdrh */
184575897234Sdrh struct ExprList {
184675897234Sdrh   int nExpr;             /* Number of expressions on the list */
18479d2985c7Sdrh   int iECursor;          /* VDBE Cursor associated with this ExprList */
1848d872bb18Sdrh   struct ExprList_item { /* For each expression in the list */
184975897234Sdrh     Expr *pExpr;            /* The list of expressions */
185075897234Sdrh     char *zName;            /* Token associated with this expression */
1851b7916a78Sdrh     char *zSpan;            /* Original text of the expression */
18528e2ca029Sdrh     u8 sortOrder;           /* 1 for DESC or 0 for ASC */
18530dde4739Sdrh     unsigned done :1;       /* A flag to indicate when processing is finished */
18543e3f1a5bSdrh     unsigned bSpanIsTab :1; /* zSpan holds DB.TABLE.COLUMN */
18554b3ac73cSdrh     u16 iOrderByCol;        /* For ORDER BY, column number in result set */
18568b213899Sdrh     u16 iAlias;             /* Index into Parse.aAlias[] for zName */
1857d872bb18Sdrh   } *a;                  /* Alloc a power of two greater or equal to nExpr */
185875897234Sdrh };
185975897234Sdrh 
186075897234Sdrh /*
1861b7916a78Sdrh ** An instance of this structure is used by the parser to record both
1862b7916a78Sdrh ** the parse tree for an expression and the span of input text for an
1863b7916a78Sdrh ** expression.
1864b7916a78Sdrh */
1865b7916a78Sdrh struct ExprSpan {
1866b7916a78Sdrh   Expr *pExpr;          /* The expression parse tree */
1867b7916a78Sdrh   const char *zStart;   /* First character of input text */
1868b7916a78Sdrh   const char *zEnd;     /* One character past the end of input text */
1869b7916a78Sdrh };
1870b7916a78Sdrh 
1871b7916a78Sdrh /*
1872ad3cab52Sdrh ** An instance of this structure can hold a simple list of identifiers,
1873ad3cab52Sdrh ** such as the list "a,b,c" in the following statements:
1874ad3cab52Sdrh **
1875ad3cab52Sdrh **      INSERT INTO t(a,b,c) VALUES ...;
1876ad3cab52Sdrh **      CREATE INDEX idx ON t(a,b,c);
1877ad3cab52Sdrh **      CREATE TRIGGER trig BEFORE UPDATE ON t(a,b,c) ...;
1878ad3cab52Sdrh **
1879ad3cab52Sdrh ** The IdList.a.idx field is used when the IdList represents the list of
1880ad3cab52Sdrh ** column names after a table name in an INSERT statement.  In the statement
1881ad3cab52Sdrh **
1882ad3cab52Sdrh **     INSERT INTO t(a,b,c) ...
1883ad3cab52Sdrh **
1884ad3cab52Sdrh ** If "a" is the k-th column of table "t", then IdList.a[0].idx==k.
188575897234Sdrh */
188675897234Sdrh struct IdList {
18876d4abfbeSdrh   struct IdList_item {
1888ad3cab52Sdrh     char *zName;      /* Name of the identifier */
1889967e8b73Sdrh     int idx;          /* Index in some Table.aCol[] of a column named zName */
1890ad3cab52Sdrh   } *a;
189113449892Sdrh   int nId;         /* Number of identifiers on the list */
1892ad3cab52Sdrh };
1893ad3cab52Sdrh 
1894ad3cab52Sdrh /*
189551669863Sdrh ** The bitmask datatype defined below is used for various optimizations.
1896ca83ac51Sdrh **
1897ca83ac51Sdrh ** Changing this from a 64-bit to a 32-bit type limits the number of
1898ca83ac51Sdrh ** tables in a join to 32 instead of 64.  But it also reduces the size
1899ca83ac51Sdrh ** of the library by 738 bytes on ix86.
190051669863Sdrh */
1901ca83ac51Sdrh typedef u64 Bitmask;
190251669863Sdrh 
190351669863Sdrh /*
190400e13613Sdanielk1977 ** The number of bits in a Bitmask.  "BMS" means "BitMask Size".
190500e13613Sdanielk1977 */
190600e13613Sdanielk1977 #define BMS  ((int)(sizeof(Bitmask)*8))
190700e13613Sdanielk1977 
190800e13613Sdanielk1977 /*
19097699d1c4Sdrh ** A bit in a Bitmask
19107699d1c4Sdrh */
19117699d1c4Sdrh #define MASKBIT(n)   (((Bitmask)1)<<(n))
19127699d1c4Sdrh 
19137699d1c4Sdrh /*
1914ad3cab52Sdrh ** The following structure describes the FROM clause of a SELECT statement.
1915ad3cab52Sdrh ** Each table or subquery in the FROM clause is a separate element of
1916ad3cab52Sdrh ** the SrcList.a[] array.
1917d24cc427Sdrh **
1918d24cc427Sdrh ** With the addition of multiple database support, the following structure
1919d24cc427Sdrh ** can also be used to describe a particular table such as the table that
1920d24cc427Sdrh ** is modified by an INSERT, DELETE, or UPDATE statement.  In standard SQL,
1921d24cc427Sdrh ** such a table must be a simple name: ID.  But in SQLite, the table can
1922d24cc427Sdrh ** now be identified by a database name, a dot, then the table name: ID.ID.
1923c49de5d9Sdrh **
1924c49de5d9Sdrh ** The jointype starts out showing the join type between the current table
1925c49de5d9Sdrh ** and the next table on the list.  The parser builds the list this way.
1926c49de5d9Sdrh ** But sqlite3SrcListShiftJoinType() later shifts the jointypes so that each
1927c49de5d9Sdrh ** jointype expresses the join between the table and the previous table.
19282a6a7eebSdrh **
19292a6a7eebSdrh ** In the colUsed field, the high-order bit (bit 63) is set if the table
19302a6a7eebSdrh ** contains more than 63 columns and the 64-th or later column is used.
1931ad3cab52Sdrh */
1932ad3cab52Sdrh struct SrcList {
193323f98daaSdrh   u8 nSrc;        /* Number of tables or subqueries in the FROM clause */
193423f98daaSdrh   u8 nAlloc;      /* Number of entries allocated in a[] below */
1935ad3cab52Sdrh   struct SrcList_item {
193641fb5cd1Sdan     Schema *pSchema;  /* Schema to which this item is fixed */
1937113088ecSdrh     char *zDatabase;  /* Name of database holding this table */
1938ad3cab52Sdrh     char *zName;      /* Name of the table */
1939ad3cab52Sdrh     char *zAlias;     /* The "B" part of a "A AS B" phrase.  zName is the "A" */
1940daffd0e5Sdrh     Table *pTab;      /* An SQL table corresponding to zName */
1941daffd0e5Sdrh     Select *pSelect;  /* A SELECT statement used in place of a table name */
19425b6a9ed4Sdrh     int addrFillSub;  /* Address of subroutine to manifest a subquery */
19435b6a9ed4Sdrh     int regReturn;    /* Register holding return address of addrFillSub */
1944c49de5d9Sdrh     u8 jointype;      /* Type of join between this able and the previous */
194521172c4cSdrh     unsigned notIndexed :1;    /* True if there is a NOT INDEXED clause */
194621172c4cSdrh     unsigned isCorrelated :1;  /* True if sub-query is correlated */
194721172c4cSdrh     unsigned viaCoroutine :1;  /* Implemented as a co-routine */
1948ce7e189dSdan #ifndef SQLITE_OMIT_EXPLAIN
1949ce7e189dSdan     u8 iSelectId;     /* If pSelect!=0, the id of the sub-select in EQP */
1950ce7e189dSdan #endif
1951e68fbe79Sdrh     int iCursor;      /* The VDBE cursor number used to access this table */
1952ad3cab52Sdrh     Expr *pOn;        /* The ON clause of a join */
1953ad3cab52Sdrh     IdList *pUsing;   /* The USING clause of a join */
1954cd38d520Sdanielk1977     Bitmask colUsed;  /* Bit N (1<<N) set if column N of pTab is used */
195585574e31Sdanielk1977     char *zIndex;     /* Identifier from "INDEXED BY <zIndex>" clause */
195685574e31Sdanielk1977     Index *pIndex;    /* Index structure corresponding to zIndex, if any */
1957113088ecSdrh   } a[1];             /* One entry for each identifier on the list */
195875897234Sdrh };
195975897234Sdrh 
196075897234Sdrh /*
196101f3f253Sdrh ** Permitted values of the SrcList.a.jointype field
196201f3f253Sdrh */
196301f3f253Sdrh #define JT_INNER     0x0001    /* Any kind of inner or cross join */
19643dec223cSdrh #define JT_CROSS     0x0002    /* Explicit use of the CROSS keyword */
19653dec223cSdrh #define JT_NATURAL   0x0004    /* True for a "natural" join */
19663dec223cSdrh #define JT_LEFT      0x0008    /* Left outer join */
19673dec223cSdrh #define JT_RIGHT     0x0010    /* Right outer join */
19683dec223cSdrh #define JT_OUTER     0x0020    /* The "OUTER" keyword is present */
19693dec223cSdrh #define JT_ERROR     0x0040    /* unknown or unsupported join type */
197001f3f253Sdrh 
1971111a6a7dSdrh 
1972111a6a7dSdrh /*
1973336a5300Sdrh ** Flags appropriate for the wctrlFlags parameter of sqlite3WhereBegin()
1974336a5300Sdrh ** and the WhereInfo.wctrlFlags member.
197508c88eb0Sdrh */
19766df2acd2Sdrh #define WHERE_ORDERBY_NORMAL   0x0000 /* No-op */
19776df2acd2Sdrh #define WHERE_ORDERBY_MIN      0x0001 /* ORDER BY processing for min() func */
19786df2acd2Sdrh #define WHERE_ORDERBY_MAX      0x0002 /* ORDER BY processing for max() func */
19796df2acd2Sdrh #define WHERE_ONEPASS_DESIRED  0x0004 /* Want to do one-pass UPDATE/DELETE */
1980336a5300Sdrh #define WHERE_DUPLICATES_OK    0x0008 /* Ok to return a row more than once */
19819ef61f4fSdrh #define WHERE_OMIT_OPEN_CLOSE  0x0010 /* Table cursors are already open */
19829ef61f4fSdrh #define WHERE_FORCE_TABLE      0x0020 /* Do not use an index-only search */
19839ef61f4fSdrh #define WHERE_ONETABLE_ONLY    0x0040 /* Only code the 1st table in pTabList */
19849ef61f4fSdrh #define WHERE_AND_ONLY         0x0080 /* Don't use indices for OR terms */
1985319f677dSdrh #define WHERE_GROUPBY          0x0100 /* pOrderBy is really a GROUP BY */
19864f402f26Sdrh #define WHERE_DISTINCTBY       0x0200 /* pOrderby is really a DISTINCT clause */
19876457a353Sdrh #define WHERE_WANT_DISTINCT    0x0400 /* All output needs to be distinct */
1988a9d1ccb9Sdanielk1977 
19894f402f26Sdrh /* Allowed return values from sqlite3WhereIsDistinct()
19904f402f26Sdrh */
1991e8e4af76Sdrh #define WHERE_DISTINCT_NOOP      0  /* DISTINCT keyword not used */
1992ae651d61Sdrh #define WHERE_DISTINCT_UNIQUE    1  /* No duplicates */
1993ae651d61Sdrh #define WHERE_DISTINCT_ORDERED   2  /* All duplicates are adjacent */
1994e8e4af76Sdrh #define WHERE_DISTINCT_UNORDERED 3  /* Duplicates are scattered */
199538cc40c2Sdan 
199675897234Sdrh /*
1997b3bce662Sdanielk1977 ** A NameContext defines a context in which to resolve table and column
1998b3bce662Sdanielk1977 ** names.  The context consists of a list of tables (the pSrcList) field and
1999b3bce662Sdanielk1977 ** a list of named expression (pEList).  The named expression list may
2000b3bce662Sdanielk1977 ** be NULL.  The pSrc corresponds to the FROM clause of a SELECT or
2001b3bce662Sdanielk1977 ** to the table being operated on by INSERT, UPDATE, or DELETE.  The
2002b3bce662Sdanielk1977 ** pEList corresponds to the result set of a SELECT and is NULL for
2003b3bce662Sdanielk1977 ** other statements.
2004b3bce662Sdanielk1977 **
2005b3bce662Sdanielk1977 ** NameContexts can be nested.  When resolving names, the inner-most
2006b3bce662Sdanielk1977 ** context is searched first.  If no match is found, the next outer
2007b3bce662Sdanielk1977 ** context is checked.  If there is still no match, the next context
2008b3bce662Sdanielk1977 ** is checked.  This process continues until either a match is found
2009b3bce662Sdanielk1977 ** or all contexts are check.  When a match is found, the nRef member of
2010b3bce662Sdanielk1977 ** the context containing the match is incremented.
2011b3bce662Sdanielk1977 **
2012b3bce662Sdanielk1977 ** Each subquery gets a new NameContext.  The pNext field points to the
2013b3bce662Sdanielk1977 ** NameContext in the parent query.  Thus the process of scanning the
2014b3bce662Sdanielk1977 ** NameContext list corresponds to searching through successively outer
2015b3bce662Sdanielk1977 ** subqueries looking for a match.
2016b3bce662Sdanielk1977 */
2017b3bce662Sdanielk1977 struct NameContext {
2018b3bce662Sdanielk1977   Parse *pParse;       /* The parser */
2019b3bce662Sdanielk1977   SrcList *pSrcList;   /* One or more tables used to resolve names */
202026080d92Sdrh   ExprList *pEList;    /* Optional list of result-set columns */
202113449892Sdrh   AggInfo *pAggInfo;   /* Information about aggregates at this level */
2022b3bce662Sdanielk1977   NameContext *pNext;  /* Next outer name context.  NULL for outermost */
2023a51009b2Sdrh   int nRef;            /* Number of names resolved by this context */
2024a51009b2Sdrh   int nErr;            /* Number of errors encountered while resolving names */
2025a51009b2Sdrh   u8 ncFlags;          /* Zero or more NC_* flags defined below */
2026b3bce662Sdanielk1977 };
2027b3bce662Sdanielk1977 
2028b3bce662Sdanielk1977 /*
2029a51009b2Sdrh ** Allowed values for the NameContext, ncFlags field.
2030a51009b2Sdrh */
2031a51009b2Sdrh #define NC_AllowAgg  0x01    /* Aggregate functions are allowed here */
2032a51009b2Sdrh #define NC_HasAgg    0x02    /* One or more aggregate functions seen */
2033a51009b2Sdrh #define NC_IsCheck   0x04    /* True if resolving names in a CHECK constraint */
20343a8c4be7Sdrh #define NC_InAggFunc 0x08    /* True if analyzing arguments to an agg func */
2035e35463b3Sdrh #define NC_PartIdx   0x10    /* True if resolving a partial index WHERE */
2036a51009b2Sdrh 
2037a51009b2Sdrh /*
20389bb61fe7Sdrh ** An instance of the following structure contains all information
20399bb61fe7Sdrh ** needed to generate code for a single SELECT statement.
2040a76b5dfcSdrh **
2041d11d382cSdrh ** nLimit is set to -1 if there is no LIMIT clause.  nOffset is set to 0.
2042d11d382cSdrh ** If there is a LIMIT clause, the parser sets nLimit to the value of the
2043d11d382cSdrh ** limit and nOffset to the value of the offset (or 0 if there is not
2044d11d382cSdrh ** offset).  But later on, nLimit and nOffset become the memory locations
2045d11d382cSdrh ** in the VDBE that record the limit and offset counters.
20460342b1f5Sdrh **
2047b9bb7c18Sdrh ** addrOpenEphm[] entries contain the address of OP_OpenEphemeral opcodes.
20480342b1f5Sdrh ** These addresses must be stored so that we can go back and fill in
204966a5167bSdrh ** the P4_KEYINFO and P2 parameters later.  Neither the KeyInfo nor
20500342b1f5Sdrh ** the number of columns in P2 can be computed at the same time
2051b9bb7c18Sdrh ** as the OP_OpenEphm instruction is coded because not
20520342b1f5Sdrh ** enough information about the compound query is known at that point.
2053b9bb7c18Sdrh ** The KeyInfo for addrOpenTran[0] and [1] contains collating sequences
20542c79733fSdrh ** for the result set.  The KeyInfo for addrOpenEphm[2] contains collating
20550342b1f5Sdrh ** sequences for the ORDER BY clause.
20569bb61fe7Sdrh */
20579bb61fe7Sdrh struct Select {
20589bb61fe7Sdrh   ExprList *pEList;      /* The fields of the result */
20597b58daeaSdrh   u8 op;                 /* One of: TK_UNION TK_ALL TK_INTERSECT TK_EXCEPT */
20607d10d5a6Sdrh   u16 selFlags;          /* Various SF_* values */
2061a451017dSdrh   int iLimit, iOffset;   /* Memory registers holding LIMIT & OFFSET counters */
2062a451017dSdrh   int addrOpenEphm[3];   /* OP_OpenEphem opcodes related to this select */
2063c63367efSdrh   u64 nSelectRow;        /* Estimated number of result rows */
2064ad3cab52Sdrh   SrcList *pSrc;         /* The FROM clause */
20659bb61fe7Sdrh   Expr *pWhere;          /* The WHERE clause */
20669bb61fe7Sdrh   ExprList *pGroupBy;    /* The GROUP BY clause */
20679bb61fe7Sdrh   Expr *pHaving;         /* The HAVING clause */
20689bb61fe7Sdrh   ExprList *pOrderBy;    /* The ORDER BY clause */
2069967e8b73Sdrh   Select *pPrior;        /* Prior select in a compound select statement */
20701e281291Sdrh   Select *pNext;         /* Next select to the left in a compound */
20710342b1f5Sdrh   Select *pRightmost;    /* Right-most select in a compound select statement */
2072a2dc3b1aSdanielk1977   Expr *pLimit;          /* LIMIT expression. NULL means not used. */
2073a2dc3b1aSdanielk1977   Expr *pOffset;         /* OFFSET expression. NULL means not used. */
20749bb61fe7Sdrh };
20759bb61fe7Sdrh 
20769bb61fe7Sdrh /*
20777d10d5a6Sdrh ** Allowed values for Select.selFlags.  The "SF" prefix stands for
20787d10d5a6Sdrh ** "Select Flag".
20797d10d5a6Sdrh */
208021172c4cSdrh #define SF_Distinct        0x0001  /* Output should be DISTINCT */
208121172c4cSdrh #define SF_Resolved        0x0002  /* Identifiers have been resolved */
208221172c4cSdrh #define SF_Aggregate       0x0004  /* Contains aggregate functions */
208321172c4cSdrh #define SF_UsesEphemeral   0x0008  /* Uses the OpenEphemeral opcode */
208421172c4cSdrh #define SF_Expanded        0x0010  /* sqlite3SelectExpand() called on this */
208521172c4cSdrh #define SF_HasTypeInfo     0x0020  /* FROM subqueries have Table metadata */
208621172c4cSdrh #define SF_UseSorter       0x0040  /* Sort using a sorter */
208721172c4cSdrh #define SF_Values          0x0080  /* Synthesized from VALUES clause */
208821172c4cSdrh #define SF_Materialize     0x0100  /* Force materialization of views */
2089832ee3d4Sdrh #define SF_NestedFrom      0x0200  /* Part of a parenthesized FROM clause */
2090d58d3278Sdrh #define SF_MaybeConvert    0x0400  /* Need convertCompoundSelectToSubquery() */
20917d10d5a6Sdrh 
20927d10d5a6Sdrh 
20937d10d5a6Sdrh /*
20947d10d5a6Sdrh ** The results of a select can be distributed in several ways.  The
20957d10d5a6Sdrh ** "SRT" prefix means "SELECT Result Type".
2096fef5208cSdrh */
209713449892Sdrh #define SRT_Union        1  /* Store result as keys in an index */
209813449892Sdrh #define SRT_Except       2  /* Remove result from a UNION index */
20999ed1dfa8Sdanielk1977 #define SRT_Exists       3  /* Store 1 if the result is not empty */
21009ed1dfa8Sdanielk1977 #define SRT_Discard      4  /* Do not save the results anywhere */
2101fef5208cSdrh 
210213449892Sdrh /* The ORDER BY clause is ignored for all of the above */
21036c8c8ce0Sdanielk1977 #define IgnorableOrderby(X) ((X->eDest)<=SRT_Discard)
210413449892Sdrh 
21057d10d5a6Sdrh #define SRT_Output       5  /* Output each row of result */
21069ed1dfa8Sdanielk1977 #define SRT_Mem          6  /* Store result in a memory cell */
21070cdc022eSdanielk1977 #define SRT_Set          7  /* Store results as keys in an index */
21089ed1dfa8Sdanielk1977 #define SRT_Table        8  /* Store result as data with an automatic rowid */
21099ed1dfa8Sdanielk1977 #define SRT_EphemTab     9  /* Create transient tab and store like SRT_Table */
2110e00ee6ebSdrh #define SRT_Coroutine   10  /* Generate a single row of result */
21112282792aSdrh 
21122282792aSdrh /*
2113634d81deSdrh ** An instance of this object describes where to put of the results of
2114634d81deSdrh ** a SELECT statement.
21156c8c8ce0Sdanielk1977 */
21166c8c8ce0Sdanielk1977 struct SelectDest {
2117634d81deSdrh   u8 eDest;         /* How to dispose of the results.  On of SRT_* above. */
2118634d81deSdrh   char affSdst;     /* Affinity used when eDest==SRT_Set */
21192b596da8Sdrh   int iSDParm;      /* A parameter used by the eDest disposal method */
21202b596da8Sdrh   int iSdst;        /* Base register where results are written */
21212b596da8Sdrh   int nSdst;        /* Number of registers allocated */
21226c8c8ce0Sdanielk1977 };
21236c8c8ce0Sdanielk1977 
21246c8c8ce0Sdanielk1977 /*
21250b9f50d8Sdrh ** During code generation of statements that do inserts into AUTOINCREMENT
21260b9f50d8Sdrh ** tables, the following information is attached to the Table.u.autoInc.p
21270b9f50d8Sdrh ** pointer of each autoincrement table to record some side information that
21280b9f50d8Sdrh ** the code generator needs.  We have to keep per-table autoincrement
21290b9f50d8Sdrh ** information in case inserts are down within triggers.  Triggers do not
21300b9f50d8Sdrh ** normally coordinate their activities, but we do need to coordinate the
21310b9f50d8Sdrh ** loading and saving of autoincrement information.
21320b9f50d8Sdrh */
21330b9f50d8Sdrh struct AutoincInfo {
21340b9f50d8Sdrh   AutoincInfo *pNext;   /* Next info block in a list of them all */
21350b9f50d8Sdrh   Table *pTab;          /* Table this info block refers to */
21360b9f50d8Sdrh   int iDb;              /* Index in sqlite3.aDb[] of database holding pTab */
21370b9f50d8Sdrh   int regCtr;           /* Memory register holding the rowid counter */
21380b9f50d8Sdrh };
21390b9f50d8Sdrh 
21400b9f50d8Sdrh /*
2141ceea3321Sdrh ** Size of the column cache
2142ceea3321Sdrh */
2143ceea3321Sdrh #ifndef SQLITE_N_COLCACHE
2144ceea3321Sdrh # define SQLITE_N_COLCACHE 10
2145ceea3321Sdrh #endif
2146ceea3321Sdrh 
21472832ad42Sdan /*
21482832ad42Sdan ** At least one instance of the following structure is created for each
21492832ad42Sdan ** trigger that may be fired while parsing an INSERT, UPDATE or DELETE
21502832ad42Sdan ** statement. All such objects are stored in the linked list headed at
21512832ad42Sdan ** Parse.pTriggerPrg and deleted once statement compilation has been
21522832ad42Sdan ** completed.
21532832ad42Sdan **
21542832ad42Sdan ** A Vdbe sub-program that implements the body and WHEN clause of trigger
21552832ad42Sdan ** TriggerPrg.pTrigger, assuming a default ON CONFLICT clause of
21562832ad42Sdan ** TriggerPrg.orconf, is stored in the TriggerPrg.pProgram variable.
21572832ad42Sdan ** The Parse.pTriggerPrg list never contains two entries with the same
21582832ad42Sdan ** values for both pTrigger and orconf.
215965a7cd16Sdan **
2160bb5f168fSdan ** The TriggerPrg.aColmask[0] variable is set to a mask of old.* columns
216165a7cd16Sdan ** accessed (or set to 0 for triggers fired as a result of INSERT
2162bb5f168fSdan ** statements). Similarly, the TriggerPrg.aColmask[1] variable is set to
2163bb5f168fSdan ** a mask of new.* columns used by the program.
21642832ad42Sdan */
21652832ad42Sdan struct TriggerPrg {
21662832ad42Sdan   Trigger *pTrigger;      /* Trigger this program was coded from */
21672832ad42Sdan   TriggerPrg *pNext;      /* Next entry in Parse.pTriggerPrg list */
2168a451017dSdrh   SubProgram *pProgram;   /* Program implementing pTrigger/orconf */
2169a451017dSdrh   int orconf;             /* Default ON CONFLICT policy */
2170a451017dSdrh   u32 aColmask[2];        /* Masks of old.*, new.* columns accessed */
2171165921a7Sdan };
2172165921a7Sdan 
217364123585Sdrh /*
217464123585Sdrh ** The yDbMask datatype for the bitmask of all attached databases.
217564123585Sdrh */
217601c7dc88Sdrh #if SQLITE_MAX_ATTACHED>30
217764123585Sdrh   typedef sqlite3_uint64 yDbMask;
217801c7dc88Sdrh #else
217964123585Sdrh   typedef unsigned int yDbMask;
218001c7dc88Sdrh #endif
218101c7dc88Sdrh 
2182ceea3321Sdrh /*
2183f57b3399Sdrh ** An SQL parser context.  A copy of this structure is passed through
2184f57b3399Sdrh ** the parser and down into all the parser action routine in order to
2185f57b3399Sdrh ** carry around information that is global to the entire parse.
2186f1974846Sdrh **
2187f1974846Sdrh ** The structure is divided into two parts.  When the parser and code
2188f1974846Sdrh ** generate call themselves recursively, the first part of the structure
2189f1974846Sdrh ** is constant but the second part is reset at the beginning and end of
2190f1974846Sdrh ** each recursion.
2191c00da105Sdanielk1977 **
2192c00da105Sdanielk1977 ** The nTableLock and aTableLock variables are only used if the shared-cache
2193c00da105Sdanielk1977 ** feature is enabled (if sqlite3Tsd()->useSharedData is true). They are
2194c00da105Sdanielk1977 ** used to store the set of table-locks required by the statement being
2195c00da105Sdanielk1977 ** compiled. Function sqlite3TableLock() is used to add entries to the
2196c00da105Sdanielk1977 ** list.
219775897234Sdrh */
219875897234Sdrh struct Parse {
21999bb575fdSdrh   sqlite3 *db;         /* The main database structure */
220075897234Sdrh   char *zErrMsg;       /* An error message */
220175897234Sdrh   Vdbe *pVdbe;         /* An engine for executing database bytecode */
2202a451017dSdrh   int rc;              /* Return code from execution */
2203836faa48Sdrh   u8 colNamesSet;      /* TRUE after OP_ColumnName has been issued to pVdbe */
2204a6ecd338Sdrh   u8 checkSchema;      /* Causes schema cookie check after an error */
2205205f48e6Sdrh   u8 nested;           /* Number of nested calls to the parser/code generator */
2206892d3179Sdrh   u8 nTempReg;         /* Number of temporary registers in aTempReg[] */
22072dcef11bSdrh   u8 nTempInUse;       /* Number of aTempReg[] currently checked out */
2208a451017dSdrh   u8 nColCache;        /* Number of entries in aColCache[] */
2209a451017dSdrh   u8 iColCache;        /* Next entry in aColCache[] to replace */
2210a451017dSdrh   u8 isMultiWrite;     /* True if statement may modify/insert multiple rows */
2211a451017dSdrh   u8 mayAbort;         /* True if statement may throw an ABORT exception */
2212d58d3278Sdrh   u8 hasCompound;      /* Need to invoke convertCompoundSelectToSubquery() */
2213892d3179Sdrh   int aTempReg[8];     /* Holding area for temporary registers */
2214892d3179Sdrh   int nRangeReg;       /* Size of the temporary register block */
2215892d3179Sdrh   int iRangeReg;       /* First register in temporary register block */
221675897234Sdrh   int nErr;            /* Number of errors seen */
2217832508b7Sdrh   int nTab;            /* Number of previously allocated VDBE cursors */
221819a775c2Sdrh   int nMem;            /* Number of memory cells used so far */
2219fef5208cSdrh   int nSet;            /* Number of sets used so far */
22201d8cb21fSdan   int nOnce;           /* Number of OP_Once instructions so far */
2221aa9b8963Sdrh   int ckBase;          /* Base register of data during check constraints */
2222b2b9d3d7Sdrh   int iPartIdxTab;     /* Table corresponding to a partial index */
2223ceea3321Sdrh   int iCacheLevel;     /* ColCache valid when aColCache[].iLevel<=iCacheLevel */
2224ceea3321Sdrh   int iCacheCnt;       /* Counter used to generate aColCache[].lru values */
22252f7794c1Sdrh   struct yColCache {
2226e55cbd72Sdrh     int iTable;           /* Table cursor number */
2227e55cbd72Sdrh     int iColumn;          /* Table column number */
2228ceea3321Sdrh     u8 tempReg;           /* iReg is a temp register that needs to be freed */
2229ceea3321Sdrh     int iLevel;           /* Nesting level */
2230ceea3321Sdrh     int iReg;             /* Reg with value of this column. 0 means none. */
2231ceea3321Sdrh     int lru;              /* Least recently used entry has the smallest value */
2232ceea3321Sdrh   } aColCache[SQLITE_N_COLCACHE];  /* One for each column cache entry */
223364123585Sdrh   yDbMask writeMask;   /* Start a write transaction on these databases */
223464123585Sdrh   yDbMask cookieMask;  /* Bitmask of schema verified databases */
2235fcd35c7bSdrh   int cookieGoto;      /* Address of OP_Goto to cookie verifier subroutine */
2236c797d4dcSdrh   int cookieValue[SQLITE_MAX_ATTACHED+2];  /* Values of cookies to verify */
2237a451017dSdrh   int regRowid;        /* Register holding rowid of CREATE TABLE entry */
2238a451017dSdrh   int regRoot;         /* Register holding root page number for new objects */
2239a451017dSdrh   int nMaxArg;         /* Max args passed to user function by sub-program */
22402938f924Sdrh   Token constraintName;/* Name of the constraint currently being parsed */
2241c00da105Sdanielk1977 #ifndef SQLITE_OMIT_SHARED_CACHE
2242c00da105Sdanielk1977   int nTableLock;        /* Number of locks in aTableLock */
2243c00da105Sdanielk1977   TableLock *aTableLock; /* Required table locks for shared-cache mode */
2244c00da105Sdanielk1977 #endif
22450b9f50d8Sdrh   AutoincInfo *pAinc;  /* Information about AUTOINCREMENT counters */
2246f1974846Sdrh 
2247165921a7Sdan   /* Information used while coding trigger programs. */
224865a7cd16Sdan   Parse *pToplevel;    /* Parse structure for main program (or NULL) */
2249165921a7Sdan   Table *pTriggerTab;  /* Table triggers are being coded for */
22504f402f26Sdrh   u32 nQueryLoop;      /* Est number of iterations of a query (10*log2(N)) */
225165a7cd16Sdan   u32 oldmask;         /* Mask of old.* columns referenced */
2252bb5f168fSdan   u32 newmask;         /* Mask of new.* columns referenced */
225365a7cd16Sdan   u8 eTriggerOp;       /* TK_UPDATE, TK_INSERT or TK_DELETE */
225465a7cd16Sdan   u8 eOrconf;          /* Default ON CONFLICT policy for trigger steps */
2255d66c8309Sdan   u8 disableTriggers;  /* True to disable triggers */
2256165921a7Sdan 
2257f1974846Sdrh   /* Above is constant between recursions.  Below is reset before and after
2258f1974846Sdrh   ** each recursion */
2259f1974846Sdrh 
2260f1974846Sdrh   int nVar;                 /* Number of '?' variables seen in the SQL so far */
2261124c0b49Sdrh   int nzVar;                /* Number of available slots in azVar[] */
2262a451017dSdrh   u8 explain;               /* True if the EXPLAIN flag is found on the query */
2263a451017dSdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
2264a451017dSdrh   u8 declareVtab;           /* True if inside sqlite3_declare_vtab() */
2265a451017dSdrh   int nVtabLock;            /* Number of virtual tables to lock */
2266a451017dSdrh #endif
2267a451017dSdrh   int nAlias;               /* Number of aliased result set columns */
2268a451017dSdrh   int nHeight;              /* Expression tree height of current sub-select */
2269a451017dSdrh #ifndef SQLITE_OMIT_EXPLAIN
2270a451017dSdrh   int iSelectId;            /* ID of current select for EXPLAIN output */
2271a451017dSdrh   int iNextSelectId;        /* Next available select ID for EXPLAIN output */
2272a451017dSdrh #endif
2273124c0b49Sdrh   char **azVar;             /* Pointers to names of parameters */
2274937d0deaSdan   Vdbe *pReprepare;         /* VM being reprepared (sqlite3Reprepare()) */
22758b213899Sdrh   int *aAlias;              /* Register used to hold aliased result */
2276f1974846Sdrh   const char *zTail;        /* All SQL text past the last semicolon parsed */
2277f1974846Sdrh   Table *pNewTable;         /* A table being constructed by CREATE TABLE */
2278f1974846Sdrh   Trigger *pNewTrigger;     /* Trigger under construct by a CREATE TRIGGER */
2279f1974846Sdrh   const char *zAuthContext; /* The 6th parameter to db->xAuth callbacks */
2280a451017dSdrh   Token sNameToken;         /* Token with unqualified schema object name */
2281a451017dSdrh   Token sLastToken;         /* The last token parsed */
2282b9bb7c18Sdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
228333b3933cSdanielk1977   Token sArg;               /* Complete text of a module argument */
22844f3dd150Sdrh   Table **apVtabLock;       /* Pointer to virtual tables needing locking */
2285b9bb7c18Sdrh #endif
2286588a9a1aSdrh   Table *pZombieTab;        /* List of Table objects to delete after code gen */
22872832ad42Sdan   TriggerPrg *pTriggerPrg;  /* Linked list of coded triggers */
228875897234Sdrh };
228975897234Sdrh 
2290a451017dSdrh /*
2291a451017dSdrh ** Return true if currently inside an sqlite3_declare_vtab() call.
2292a451017dSdrh */
22937e6ebfb2Sdanielk1977 #ifdef SQLITE_OMIT_VIRTUALTABLE
22947e6ebfb2Sdanielk1977   #define IN_DECLARE_VTAB 0
22957e6ebfb2Sdanielk1977 #else
22967e6ebfb2Sdanielk1977   #define IN_DECLARE_VTAB (pParse->declareVtab)
22977e6ebfb2Sdanielk1977 #endif
22987e6ebfb2Sdanielk1977 
2299d99bc930Sdanielk1977 /*
230085e2096fSdrh ** An instance of the following structure can be declared on a stack and used
230185e2096fSdrh ** to save the Parse.zAuthContext value so that it can be restored later.
230285e2096fSdrh */
230385e2096fSdrh struct AuthContext {
230485e2096fSdrh   const char *zAuthContext;   /* Put saved Parse.zAuthContext here */
230585e2096fSdrh   Parse *pParse;              /* The Parse structure */
230685e2096fSdrh };
230785e2096fSdrh 
230885e2096fSdrh /*
2309a748fdccSdrh ** Bitfield flags for P5 value in various opcodes.
2310b0c374ffSrdc */
23113e9ca094Sdrh #define OPFLAG_NCHANGE       0x01    /* Set to update db->nChange */
23123e9ca094Sdrh #define OPFLAG_LASTROWID     0x02    /* Set to update db->lastRowid */
23133e9ca094Sdrh #define OPFLAG_ISUPDATE      0x04    /* This OP_Insert is an sql UPDATE */
23143e9ca094Sdrh #define OPFLAG_APPEND        0x08    /* This is likely to be an append */
23153e9ca094Sdrh #define OPFLAG_USESEEKRESULT 0x10    /* Try to avoid a seek in BtreeInsert() */
23163e9ca094Sdrh #define OPFLAG_CLEARCACHE    0x20    /* Clear pseudo-table cache in OP_Column */
2317a748fdccSdrh #define OPFLAG_LENGTHARG     0x40    /* OP_Column only used for length() */
2318a748fdccSdrh #define OPFLAG_TYPEOFARG     0x80    /* OP_Column only used for typeof() */
2319428c218cSdan #define OPFLAG_BULKCSR       0x01    /* OP_Open** used to open bulk cursor */
2320428c218cSdan #define OPFLAG_P2ISREG       0x02    /* P2 to OP_Open** is a register number */
2321953f7611Sdrh #define OPFLAG_PERMUTE       0x01    /* OP_Compare: use the permutation */
2322b0c374ffSrdc 
2323b0c374ffSrdc /*
2324d99bc930Sdanielk1977  * Each trigger present in the database schema is stored as an instance of
2325d99bc930Sdanielk1977  * struct Trigger.
2326d99bc930Sdanielk1977  *
2327d99bc930Sdanielk1977  * Pointers to instances of struct Trigger are stored in two ways.
23289bb575fdSdrh  * 1. In the "trigHash" hash table (part of the sqlite3* that represents the
2329d99bc930Sdanielk1977  *    database). This allows Trigger structures to be retrieved by name.
2330d99bc930Sdanielk1977  * 2. All triggers associated with a single table form a linked list, using the
2331ad3cab52Sdrh  *    pNext member of struct Trigger. A pointer to the first element of the
2332ad3cab52Sdrh  *    linked list is stored as the "pTrigger" member of the associated
2333ad3cab52Sdrh  *    struct Table.
2334d99bc930Sdanielk1977  *
2335ad3cab52Sdrh  * The "step_list" member points to the first element of a linked list
2336ad3cab52Sdrh  * containing the SQL statements specified as the trigger program.
2337d99bc930Sdanielk1977  */
2338d99bc930Sdanielk1977 struct Trigger {
2339165921a7Sdan   char *zName;            /* The name of the trigger                        */
2340d99bc930Sdanielk1977   char *table;            /* The table or view to which the trigger applies */
2341f0f258b1Sdrh   u8 op;                  /* One of TK_DELETE, TK_UPDATE, TK_INSERT         */
2342dca76841Sdrh   u8 tr_tm;               /* One of TRIGGER_BEFORE, TRIGGER_AFTER */
2343467bcf36Sshane   Expr *pWhen;            /* The WHEN clause of the expression (may be NULL) */
2344d99bc930Sdanielk1977   IdList *pColumns;       /* If this is an UPDATE OF <column-list> trigger,
2345d99bc930Sdanielk1977                              the <column-list> is stored here */
2346e501b89aSdanielk1977   Schema *pSchema;        /* Schema containing the trigger */
2347e501b89aSdanielk1977   Schema *pTabSchema;     /* Schema containing the table */
2348d99bc930Sdanielk1977   TriggerStep *step_list; /* Link list of trigger program steps             */
2349d99bc930Sdanielk1977   Trigger *pNext;         /* Next trigger associated with the table */
2350c3f9bad2Sdanielk1977 };
2351d99bc930Sdanielk1977 
2352d99bc930Sdanielk1977 /*
2353dca76841Sdrh ** A trigger is either a BEFORE or an AFTER trigger.  The following constants
2354dca76841Sdrh ** determine which.
2355dca76841Sdrh **
2356dca76841Sdrh ** If there are multiple triggers, you might of some BEFORE and some AFTER.
2357dca76841Sdrh ** In that cases, the constants below can be ORed together.
2358dca76841Sdrh */
2359dca76841Sdrh #define TRIGGER_BEFORE  1
2360dca76841Sdrh #define TRIGGER_AFTER   2
2361dca76841Sdrh 
2362dca76841Sdrh /*
2363d99bc930Sdanielk1977  * An instance of struct TriggerStep is used to store a single SQL statement
2364d99bc930Sdanielk1977  * that is a part of a trigger-program.
2365d99bc930Sdanielk1977  *
2366d99bc930Sdanielk1977  * Instances of struct TriggerStep are stored in a singly linked list (linked
2367d99bc930Sdanielk1977  * using the "pNext" member) referenced by the "step_list" member of the
2368d99bc930Sdanielk1977  * associated struct Trigger instance. The first element of the linked list is
2369d99bc930Sdanielk1977  * the first step of the trigger-program.
2370d99bc930Sdanielk1977  *
2371d99bc930Sdanielk1977  * The "op" member indicates whether this is a "DELETE", "INSERT", "UPDATE" or
2372d99bc930Sdanielk1977  * "SELECT" statement. The meanings of the other members is determined by the
2373d99bc930Sdanielk1977  * value of "op" as follows:
2374d99bc930Sdanielk1977  *
2375d99bc930Sdanielk1977  * (op == TK_INSERT)
2376d99bc930Sdanielk1977  * orconf    -> stores the ON CONFLICT algorithm
2377d99bc930Sdanielk1977  * pSelect   -> If this is an INSERT INTO ... SELECT ... statement, then
2378d99bc930Sdanielk1977  *              this stores a pointer to the SELECT statement. Otherwise NULL.
2379b7916a78Sdrh  * target    -> A token holding the quoted name of the table to insert into.
2380d99bc930Sdanielk1977  * pExprList -> If this is an INSERT INTO ... VALUES ... statement, then
2381d99bc930Sdanielk1977  *              this stores values to be inserted. Otherwise NULL.
2382d99bc930Sdanielk1977  * pIdList   -> If this is an INSERT INTO ... (<column-names>) VALUES ...
2383ad3cab52Sdrh  *              statement, then this stores the column-names to be
2384ad3cab52Sdrh  *              inserted into.
2385d99bc930Sdanielk1977  *
2386d99bc930Sdanielk1977  * (op == TK_DELETE)
2387b7916a78Sdrh  * target    -> A token holding the quoted name of the table to delete from.
2388d99bc930Sdanielk1977  * pWhere    -> The WHERE clause of the DELETE statement if one is specified.
2389d99bc930Sdanielk1977  *              Otherwise NULL.
2390d99bc930Sdanielk1977  *
2391d99bc930Sdanielk1977  * (op == TK_UPDATE)
2392b7916a78Sdrh  * target    -> A token holding the quoted name of the table to update rows of.
2393d99bc930Sdanielk1977  * pWhere    -> The WHERE clause of the UPDATE statement if one is specified.
2394d99bc930Sdanielk1977  *              Otherwise NULL.
2395d99bc930Sdanielk1977  * pExprList -> A list of the columns to update and the expressions to update
23964adee20fSdanielk1977  *              them to. See sqlite3Update() documentation of "pChanges"
2397ad3cab52Sdrh  *              argument.
2398d99bc930Sdanielk1977  *
2399d99bc930Sdanielk1977  */
2400c3f9bad2Sdanielk1977 struct TriggerStep {
2401b1819a0bSdrh   u8 op;               /* One of TK_DELETE, TK_UPDATE, TK_INSERT, TK_SELECT */
2402b1819a0bSdrh   u8 orconf;           /* OE_Rollback etc. */
2403a69d9168Sdrh   Trigger *pTrig;      /* The trigger that this step is a part of */
2404b1819a0bSdrh   Select *pSelect;     /* SELECT statment or RHS of INSERT INTO .. SELECT ... */
2405b1819a0bSdrh   Token target;        /* Target table for DELETE, UPDATE, INSERT */
2406b1819a0bSdrh   Expr *pWhere;        /* The WHERE clause for DELETE or UPDATE steps */
2407b1819a0bSdrh   ExprList *pExprList; /* SET clause for UPDATE.  VALUES clause for INSERT */
2408b1819a0bSdrh   IdList *pIdList;     /* Column names for INSERT */
2409c3f9bad2Sdanielk1977   TriggerStep *pNext;  /* Next in the link-list */
2410187e4c6aSdrh   TriggerStep *pLast;  /* Last element in link-list. Valid for 1st elem only */
2411c3f9bad2Sdanielk1977 };
2412c3f9bad2Sdanielk1977 
2413d99bc930Sdanielk1977 /*
2414f26e09c8Sdrh ** The following structure contains information used by the sqliteFix...
2415f26e09c8Sdrh ** routines as they walk the parse tree to make database references
2416f26e09c8Sdrh ** explicit.
2417f26e09c8Sdrh */
2418f26e09c8Sdrh typedef struct DbFixer DbFixer;
2419f26e09c8Sdrh struct DbFixer {
2420f26e09c8Sdrh   Parse *pParse;      /* The parsing context.  Error messages written here */
242141fb5cd1Sdan   Schema *pSchema;    /* Fix items to this schema */
2422f26e09c8Sdrh   const char *zDb;    /* Make sure all objects are contained in this database */
2423f26e09c8Sdrh   const char *zType;  /* Type of the container - used for error messages */
2424f26e09c8Sdrh   const Token *pName; /* Name of the container - used for error messages */
2425f26e09c8Sdrh };
2426f26e09c8Sdrh 
2427f26e09c8Sdrh /*
2428ade86483Sdrh ** An objected used to accumulate the text of a string where we
2429ade86483Sdrh ** do not necessarily know how big the string will be in the end.
2430ade86483Sdrh */
2431ade86483Sdrh struct StrAccum {
2432633e6d57Sdrh   sqlite3 *db;         /* Optional database for lookaside.  Can be NULL */
2433ade86483Sdrh   char *zBase;         /* A base allocation.  Not from malloc. */
2434ade86483Sdrh   char *zText;         /* The string collected so far */
2435ade86483Sdrh   int  nChar;          /* Length of the string so far */
2436ade86483Sdrh   int  nAlloc;         /* Amount of space allocated in zText */
2437bb4957f8Sdrh   int  mxAlloc;        /* Maximum allowed string length */
2438b975598eSdrh   u8   useMalloc;      /* 0: none,  1: sqlite3DbMalloc,  2: sqlite3_malloc */
2439b49bc86aSdrh   u8   accError;       /* STRACCUM_NOMEM or STRACCUM_TOOBIG */
2440ade86483Sdrh };
2441b49bc86aSdrh #define STRACCUM_NOMEM   1
2442b49bc86aSdrh #define STRACCUM_TOOBIG  2
2443ade86483Sdrh 
2444ade86483Sdrh /*
2445234c39dfSdrh ** A pointer to this structure is used to communicate information
2446234c39dfSdrh ** from sqlite3Init and OP_ParseSchema into the sqlite3InitCallback.
2447234c39dfSdrh */
2448234c39dfSdrh typedef struct {
24499bb575fdSdrh   sqlite3 *db;        /* The database being initialized */
2450234c39dfSdrh   char **pzErrMsg;    /* Error message stored here */
2451a451017dSdrh   int iDb;            /* 0 for main database.  1 for TEMP, 2.. for ATTACHed */
245215ca1df1Sdrh   int rc;             /* Result code stored here */
2453234c39dfSdrh } InitData;
2454234c39dfSdrh 
2455b6c29897Sdrh /*
245640257ffdSdrh ** Structure containing global configuration data for the SQLite library.
245733589797Sdrh **
245833589797Sdrh ** This structure also contains some state information.
245940257ffdSdrh */
246040257ffdSdrh struct Sqlite3Config {
2461fec00eabSdrh   int bMemstat;                     /* True to enable memory status */
2462fec00eabSdrh   int bCoreMutex;                   /* True to enable core mutexing */
2463fec00eabSdrh   int bFullMutex;                   /* True to enable full mutexing */
2464cd74b611Sdan   int bOpenUri;                     /* True to interpret filenames as URIs */
2465de9a7b8aSdrh   int bUseCis;                      /* Use covering indices for full-scans */
24660a687d12Sdrh   int mxStrlen;                     /* Maximum string length */
2467633e6d57Sdrh   int szLookaside;                  /* Default lookaside buffer size */
2468633e6d57Sdrh   int nLookaside;                   /* Default lookaside buffer count */
2469fec00eabSdrh   sqlite3_mem_methods m;            /* Low-level memory allocation interface */
24706d2ab0e4Sdanielk1977   sqlite3_mutex_methods mutex;      /* Low-level mutex interface */
247122e21ff4Sdan   sqlite3_pcache_methods2 pcache2;  /* Low-level page-cache interface */
247240257ffdSdrh   void *pHeap;                      /* Heap storage space */
247333589797Sdrh   int nHeap;                        /* Size of pHeap[] */
247433589797Sdrh   int mnReq, mxReq;                 /* Min and max heap requests sizes */
24759b4c59faSdrh   sqlite3_int64 szMmap;             /* mmap() space per open file */
24769b4c59faSdrh   sqlite3_int64 mxMmap;             /* Maximum value for szMmap */
247733589797Sdrh   void *pScratch;                   /* Scratch memory */
247833589797Sdrh   int szScratch;                    /* Size of each scratch buffer */
247933589797Sdrh   int nScratch;                     /* Number of scratch buffers */
248033589797Sdrh   void *pPage;                      /* Page cache memory */
248133589797Sdrh   int szPage;                       /* Size of each page in pPage[] */
248233589797Sdrh   int nPage;                        /* Number of pages in pPage[] */
24831875f7a3Sdrh   int mxParserStack;                /* maximum depth of the parser stack */
24841875f7a3Sdrh   int sharedCacheEnabled;           /* true if shared-cache mode enabled */
24851875f7a3Sdrh   /* The above might be initialized to non-zero.  The following need to always
24861875f7a3Sdrh   ** initially be zero, however. */
248771bc31c6Sdanielk1977   int isInit;                       /* True after initialization has finished */
2488502b4e00Sdanielk1977   int inProgress;                   /* True while initialization in progress */
2489e1ab2193Sdan   int isMutexInit;                  /* True after mutexes are initialized */
249071bc31c6Sdanielk1977   int isMallocInit;                 /* True after malloc is initialized */
2491e1ab2193Sdan   int isPCacheInit;                 /* True after malloc is initialized */
249271bc31c6Sdanielk1977   sqlite3_mutex *pInitMutex;        /* Mutex used by sqlite3_initialize() */
249393ed56d9Sdrh   int nRefInitMutex;                /* Number of users of pInitMutex */
24943f280701Sdrh   void (*xLog)(void*,int,const char*); /* Function for logging */
24953f280701Sdrh   void *pLogArg;                       /* First argument to xLog() */
2496c17d696cSdan   int bLocaltimeFault;              /* True to fail localtime() calls */
2497ac455939Sdan #ifdef SQLITE_ENABLE_SQLLOG
2498ac455939Sdan   void(*xSqllog)(void*,sqlite3*,const char*, int);
2499ac455939Sdan   void *pSqllogArg;
2500ac455939Sdan #endif
250140257ffdSdrh };
250240257ffdSdrh 
250340257ffdSdrh /*
25047d10d5a6Sdrh ** Context pointer passed down through the tree-walk.
25057d10d5a6Sdrh */
25067d10d5a6Sdrh struct Walker {
25077d10d5a6Sdrh   int (*xExprCallback)(Walker*, Expr*);     /* Callback for expressions */
25087d10d5a6Sdrh   int (*xSelectCallback)(Walker*,Select*);  /* Callback for SELECTs */
25097d10d5a6Sdrh   Parse *pParse;                            /* Parser context.  */
2510030796dfSdrh   int walkerDepth;                          /* Number of subqueries */
2511aa87f9a6Sdrh   u8 bSelectDepthFirst;                     /* Do subqueries first */
25127d10d5a6Sdrh   union {                                   /* Extra data for callback */
25137d10d5a6Sdrh     NameContext *pNC;                          /* Naming context */
25147d10d5a6Sdrh     int i;                                     /* Integer value */
2515374fdce4Sdrh     SrcList *pSrcList;                         /* FROM clause */
2516030796dfSdrh     struct SrcCount *pSrcCount;                /* Counting column references */
25177d10d5a6Sdrh   } u;
25187d10d5a6Sdrh };
25197d10d5a6Sdrh 
25207d10d5a6Sdrh /* Forward declarations */
25217d10d5a6Sdrh int sqlite3WalkExpr(Walker*, Expr*);
25227d10d5a6Sdrh int sqlite3WalkExprList(Walker*, ExprList*);
25237d10d5a6Sdrh int sqlite3WalkSelect(Walker*, Select*);
25247d10d5a6Sdrh int sqlite3WalkSelectExpr(Walker*, Select*);
25257d10d5a6Sdrh int sqlite3WalkSelectFrom(Walker*, Select*);
25267d10d5a6Sdrh 
25277d10d5a6Sdrh /*
25287d10d5a6Sdrh ** Return code from the parse-tree walking primitives and their
25297d10d5a6Sdrh ** callbacks.
25307d10d5a6Sdrh */
25312bf90f1eSdrh #define WRC_Continue    0   /* Continue down into children */
25322bf90f1eSdrh #define WRC_Prune       1   /* Omit children but continue walking siblings */
25332bf90f1eSdrh #define WRC_Abort       2   /* Abandon the tree walk */
25347d10d5a6Sdrh 
25357d10d5a6Sdrh /*
253666150956Sdrh ** Assuming zIn points to the first byte of a UTF-8 character,
253766150956Sdrh ** advance zIn to point to the first byte of the next UTF-8 character.
25384a919118Sdrh */
25394a919118Sdrh #define SQLITE_SKIP_UTF8(zIn) {                        \
25404a919118Sdrh   if( (*(zIn++))>=0xc0 ){                              \
25414a919118Sdrh     while( (*zIn & 0xc0)==0x80 ){ zIn++; }             \
25424a919118Sdrh   }                                                    \
25434a919118Sdrh }
25444a919118Sdrh 
25454a919118Sdrh /*
25469978c97eSdrh ** The SQLITE_*_BKPT macros are substitutes for the error codes with
25479978c97eSdrh ** the same name but without the _BKPT suffix.  These macros invoke
25489978c97eSdrh ** routines that report the line-number on which the error originated
25499978c97eSdrh ** using sqlite3_log().  The routines also provide a convenient place
25509978c97eSdrh ** to set a debugger breakpoint.
255149285708Sdrh */
25529978c97eSdrh int sqlite3CorruptError(int);
25539978c97eSdrh int sqlite3MisuseError(int);
25549978c97eSdrh int sqlite3CantopenError(int);
25559978c97eSdrh #define SQLITE_CORRUPT_BKPT sqlite3CorruptError(__LINE__)
25569978c97eSdrh #define SQLITE_MISUSE_BKPT sqlite3MisuseError(__LINE__)
25579978c97eSdrh #define SQLITE_CANTOPEN_BKPT sqlite3CantopenError(__LINE__)
25589978c97eSdrh 
255949285708Sdrh 
256049285708Sdrh /*
2561b4a1fed2Sdrh ** FTS4 is really an extension for FTS3.  It is enabled using the
2562b4a1fed2Sdrh ** SQLITE_ENABLE_FTS3 macro.  But to avoid confusion we also all
2563b4a1fed2Sdrh ** the SQLITE_ENABLE_FTS4 macro to serve as an alisse for SQLITE_ENABLE_FTS3.
2564b4a1fed2Sdrh */
2565b4a1fed2Sdrh #if defined(SQLITE_ENABLE_FTS4) && !defined(SQLITE_ENABLE_FTS3)
2566b4a1fed2Sdrh # define SQLITE_ENABLE_FTS3
2567b4a1fed2Sdrh #endif
2568b4a1fed2Sdrh 
2569b4a1fed2Sdrh /*
257079f02cefSdrh ** The ctype.h header is needed for non-ASCII systems.  It is also
257179f02cefSdrh ** needed by FTS3 when FTS3 is included in the amalgamation.
257279f02cefSdrh */
257379f02cefSdrh #if !defined(SQLITE_ASCII) || \
257479f02cefSdrh     (defined(SQLITE_ENABLE_FTS3) && defined(SQLITE_AMALGAMATION))
257579f02cefSdrh # include <ctype.h>
257679f02cefSdrh #endif
257779f02cefSdrh 
257879f02cefSdrh /*
257978ca0e7eSdanielk1977 ** The following macros mimic the standard library functions toupper(),
258078ca0e7eSdanielk1977 ** isspace(), isalnum(), isdigit() and isxdigit(), respectively. The
258178ca0e7eSdanielk1977 ** sqlite versions only work for ASCII characters, regardless of locale.
258278ca0e7eSdanielk1977 */
258378ca0e7eSdanielk1977 #ifdef SQLITE_ASCII
258478ca0e7eSdanielk1977 # define sqlite3Toupper(x)  ((x)&~(sqlite3CtypeMap[(unsigned char)(x)]&0x20))
258578ca0e7eSdanielk1977 # define sqlite3Isspace(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x01)
2586dc86e2b2Sdrh # define sqlite3Isalnum(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x06)
2587dc86e2b2Sdrh # define sqlite3Isalpha(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x02)
258878ca0e7eSdanielk1977 # define sqlite3Isdigit(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x04)
258978ca0e7eSdanielk1977 # define sqlite3Isxdigit(x)  (sqlite3CtypeMap[(unsigned char)(x)]&0x08)
259078ca0e7eSdanielk1977 # define sqlite3Tolower(x)   (sqlite3UpperToLower[(unsigned char)(x)])
259178ca0e7eSdanielk1977 #else
259278ca0e7eSdanielk1977 # define sqlite3Toupper(x)   toupper((unsigned char)(x))
259378ca0e7eSdanielk1977 # define sqlite3Isspace(x)   isspace((unsigned char)(x))
259478ca0e7eSdanielk1977 # define sqlite3Isalnum(x)   isalnum((unsigned char)(x))
2595dc86e2b2Sdrh # define sqlite3Isalpha(x)   isalpha((unsigned char)(x))
259678ca0e7eSdanielk1977 # define sqlite3Isdigit(x)   isdigit((unsigned char)(x))
259778ca0e7eSdanielk1977 # define sqlite3Isxdigit(x)  isxdigit((unsigned char)(x))
259878ca0e7eSdanielk1977 # define sqlite3Tolower(x)   tolower((unsigned char)(x))
259978ca0e7eSdanielk1977 #endif
260078ca0e7eSdanielk1977 
260178ca0e7eSdanielk1977 /*
260275897234Sdrh ** Internal function prototypes
260375897234Sdrh */
26043fa97302Sdrh #define sqlite3StrICmp sqlite3_stricmp
2605ea678832Sdrh int sqlite3Strlen30(const char*);
2606ee0484c1Sdanielk1977 #define sqlite3StrNICmp sqlite3_strnicmp
26072e588c75Sdanielk1977 
260840257ffdSdrh int sqlite3MallocInit(void);
2609fec00eabSdrh void sqlite3MallocEnd(void);
2610fec00eabSdrh void *sqlite3Malloc(int);
2611fec00eabSdrh void *sqlite3MallocZero(int);
2612fec00eabSdrh void *sqlite3DbMallocZero(sqlite3*, int);
2613fec00eabSdrh void *sqlite3DbMallocRaw(sqlite3*, int);
261417435752Sdrh char *sqlite3DbStrDup(sqlite3*,const char*);
261517435752Sdrh char *sqlite3DbStrNDup(sqlite3*,const char*, int);
2616fec00eabSdrh void *sqlite3Realloc(void*, int);
261797c8ec32Sdrh void *sqlite3DbReallocOrFree(sqlite3 *, void *, int);
2618a1644fd8Sdanielk1977 void *sqlite3DbRealloc(sqlite3 *, void *, int);
2619633e6d57Sdrh void sqlite3DbFree(sqlite3*, void*);
2620a7a8e14bSdanielk1977 int sqlite3MallocSize(void*);
2621633e6d57Sdrh int sqlite3DbMallocSize(sqlite3*, void*);
2622facf0307Sdrh void *sqlite3ScratchMalloc(int);
2623facf0307Sdrh void sqlite3ScratchFree(void*);
2624facf0307Sdrh void *sqlite3PageMalloc(int);
2625facf0307Sdrh void sqlite3PageFree(void*);
2626fec00eabSdrh void sqlite3MemSetDefault(void);
2627171bfed3Sdanielk1977 void sqlite3BenignMallocHooks(void (*)(void), void (*)(void));
262850d1b5f3Sdrh int sqlite3HeapNearlyFull(void);
26292e588c75Sdanielk1977 
2630e7b34707Sdrh /*
2631e7b34707Sdrh ** On systems with ample stack space and that support alloca(), make
2632e7b34707Sdrh ** use of alloca() to obtain space for large automatic objects.  By default,
2633e7b34707Sdrh ** obtain space from malloc().
2634e7b34707Sdrh **
2635e7b34707Sdrh ** The alloca() routine never returns NULL.  This will cause code paths
2636e7b34707Sdrh ** that deal with sqlite3StackAlloc() failures to be unreachable.
2637e7b34707Sdrh */
2638e7b34707Sdrh #ifdef SQLITE_USE_ALLOCA
2639e7b34707Sdrh # define sqlite3StackAllocRaw(D,N)   alloca(N)
2640e7b34707Sdrh # define sqlite3StackAllocZero(D,N)  memset(alloca(N), 0, N)
2641e7b34707Sdrh # define sqlite3StackFree(D,P)
2642e7b34707Sdrh #else
2643e7b34707Sdrh # define sqlite3StackAllocRaw(D,N)   sqlite3DbMallocRaw(D,N)
2644e7b34707Sdrh # define sqlite3StackAllocZero(D,N)  sqlite3DbMallocZero(D,N)
2645e7b34707Sdrh # define sqlite3StackFree(D,P)       sqlite3DbFree(D,P)
2646e7b34707Sdrh #endif
2647e7b34707Sdrh 
2648f3d3c27aSdanielk1977 #ifdef SQLITE_ENABLE_MEMSYS3
2649f3d3c27aSdanielk1977 const sqlite3_mem_methods *sqlite3MemGetMemsys3(void);
2650f3d3c27aSdanielk1977 #endif
2651f3d3c27aSdanielk1977 #ifdef SQLITE_ENABLE_MEMSYS5
2652f3d3c27aSdanielk1977 const sqlite3_mem_methods *sqlite3MemGetMemsys5(void);
2653f3d3c27aSdanielk1977 #endif
2654f3d3c27aSdanielk1977 
2655f3d3c27aSdanielk1977 
265618472fa7Sdrh #ifndef SQLITE_MUTEX_OMIT
2657558814f8Sdan   sqlite3_mutex_methods const *sqlite3DefaultMutex(void);
2658558814f8Sdan   sqlite3_mutex_methods const *sqlite3NoopMutex(void);
265959f8c08eSdanielk1977   sqlite3_mutex *sqlite3MutexAlloc(int);
2660d025174fSdanielk1977   int sqlite3MutexInit(void);
2661d025174fSdanielk1977   int sqlite3MutexEnd(void);
266265bbf29eSdrh #endif
26636d2ab0e4Sdanielk1977 
2664f7141990Sdrh int sqlite3StatusValue(int);
2665f7141990Sdrh void sqlite3StatusAdd(int, int);
2666f7141990Sdrh void sqlite3StatusSet(int, int);
2667f7141990Sdrh 
266885c8f291Sdrh #ifndef SQLITE_OMIT_FLOATING_POINT
26690de3ae95Sdrh   int sqlite3IsNaN(double);
267085c8f291Sdrh #else
267185c8f291Sdrh # define sqlite3IsNaN(X)  0
267285c8f291Sdrh #endif
26730de3ae95Sdrh 
2674f089aa45Sdrh void sqlite3VXPrintf(StrAccum*, int, const char*, va_list);
2675c7bc4fdeSdrh #ifndef SQLITE_OMIT_TRACE
2676c7bc4fdeSdrh void sqlite3XPrintf(StrAccum*, const char*, ...);
2677c7bc4fdeSdrh #endif
267817435752Sdrh char *sqlite3MPrintf(sqlite3*,const char*, ...);
267917435752Sdrh char *sqlite3VMPrintf(sqlite3*,const char*, va_list);
2680633e6d57Sdrh char *sqlite3MAppendf(sqlite3*,char*,const char*,...);
268187cc3b31Sdrh #if defined(SQLITE_TEST) || defined(SQLITE_DEBUG)
2682e54ca3feSdrh   void sqlite3DebugPrintf(const char*, ...);
2683d919fe17Sdrh #endif
2684d919fe17Sdrh #if defined(SQLITE_TEST)
2685e8f52c50Sdrh   void *sqlite3TestTextToPtr(const char*);
268687cc3b31Sdrh #endif
26877e02e5e6Sdrh 
26887e02e5e6Sdrh /* Output formatting for SQLITE_TESTCTRL_EXPLAIN */
2689678a9aa7Sdrh #if defined(SQLITE_ENABLE_TREE_EXPLAIN)
26907e02e5e6Sdrh   void sqlite3ExplainBegin(Vdbe*);
26917e02e5e6Sdrh   void sqlite3ExplainPrintf(Vdbe*, const char*, ...);
26927e02e5e6Sdrh   void sqlite3ExplainNL(Vdbe*);
26937e02e5e6Sdrh   void sqlite3ExplainPush(Vdbe*);
26947e02e5e6Sdrh   void sqlite3ExplainPop(Vdbe*);
26957e02e5e6Sdrh   void sqlite3ExplainFinish(Vdbe*);
26967e02e5e6Sdrh   void sqlite3ExplainSelect(Vdbe*, Select*);
26977e02e5e6Sdrh   void sqlite3ExplainExpr(Vdbe*, Expr*);
26987e02e5e6Sdrh   void sqlite3ExplainExprList(Vdbe*, ExprList*);
26997e02e5e6Sdrh   const char *sqlite3VdbeExplanation(Vdbe*);
27007e02e5e6Sdrh #else
27017e02e5e6Sdrh # define sqlite3ExplainBegin(X)
27027e02e5e6Sdrh # define sqlite3ExplainSelect(A,B)
27037e02e5e6Sdrh # define sqlite3ExplainExpr(A,B)
27047e02e5e6Sdrh # define sqlite3ExplainExprList(A,B)
27057e02e5e6Sdrh # define sqlite3ExplainFinish(X)
27067e02e5e6Sdrh # define sqlite3VdbeExplanation(X) 0
27077e02e5e6Sdrh #endif
27087e02e5e6Sdrh 
27097e02e5e6Sdrh 
2710f089aa45Sdrh void sqlite3SetString(char **, sqlite3*, const char*, ...);
27114adee20fSdanielk1977 void sqlite3ErrorMsg(Parse*, const char*, ...);
271224fb627aSdrh int sqlite3Dequote(char*);
27132646da7eSdrh int sqlite3KeywordCode(const unsigned char*, int);
27144adee20fSdanielk1977 int sqlite3RunParser(Parse*, const char*, char **);
271580242055Sdrh void sqlite3FinishCoding(Parse*);
2716892d3179Sdrh int sqlite3GetTempReg(Parse*);
2717892d3179Sdrh void sqlite3ReleaseTempReg(Parse*,int);
2718892d3179Sdrh int sqlite3GetTempRange(Parse*,int);
2719892d3179Sdrh void sqlite3ReleaseTempRange(Parse*,int,int);
2720cdc69557Sdrh void sqlite3ClearTempRegCache(Parse*);
2721b7916a78Sdrh Expr *sqlite3ExprAlloc(sqlite3*,int,const Token*,int);
2722b7916a78Sdrh Expr *sqlite3Expr(sqlite3*,int,const char*);
2723b7916a78Sdrh void sqlite3ExprAttachSubtrees(sqlite3*,Expr*,Expr*,Expr*);
272417435752Sdrh Expr *sqlite3PExpr(Parse*, int, Expr*, Expr*, const Token*);
27251e536953Sdanielk1977 Expr *sqlite3ExprAnd(sqlite3*,Expr*, Expr*);
272617435752Sdrh Expr *sqlite3ExprFunction(Parse*,ExprList*, Token*);
2727fa6bc000Sdrh void sqlite3ExprAssignVarNumber(Parse*, Expr*);
2728633e6d57Sdrh void sqlite3ExprDelete(sqlite3*, Expr*);
2729b7916a78Sdrh ExprList *sqlite3ExprListAppend(Parse*,ExprList*,Expr*);
2730b7916a78Sdrh void sqlite3ExprListSetName(Parse*,ExprList*,Token*,int);
2731b7916a78Sdrh void sqlite3ExprListSetSpan(Parse*,ExprList*,ExprSpan*);
2732633e6d57Sdrh void sqlite3ExprListDelete(sqlite3*, ExprList*);
27339bb575fdSdrh int sqlite3Init(sqlite3*, char**);
2734234c39dfSdrh int sqlite3InitCallback(void*, int, char**, char**);
273591cf71b0Sdanielk1977 void sqlite3Pragma(Parse*,Token*,Token*,Token*,int);
273681028a45Sdrh void sqlite3ResetAllSchemasOfConnection(sqlite3*);
273781028a45Sdrh void sqlite3ResetOneSchema(sqlite3*,int);
273881028a45Sdrh void sqlite3CollapseDatabaseArray(sqlite3*);
27394adee20fSdanielk1977 void sqlite3BeginParse(Parse*,int);
27409bb575fdSdrh void sqlite3CommitInternalChanges(sqlite3*);
27417d10d5a6Sdrh Table *sqlite3ResultSetOfSelect(Parse*,Select*);
2742c00da105Sdanielk1977 void sqlite3OpenMasterTable(Parse *, int);
2743f1a381e7Sdanielk1977 void sqlite3StartTable(Parse*,Token*,Token*,int,int,int,int);
27444adee20fSdanielk1977 void sqlite3AddColumn(Parse*,Token*);
27454adee20fSdanielk1977 void sqlite3AddNotNull(Parse*, int);
2746fdd6e85aSdrh void sqlite3AddPrimaryKey(Parse*, ExprList*, int, int, int);
2747ffe07b2dSdrh void sqlite3AddCheckConstraint(Parse*, Expr*);
2748487e262fSdrh void sqlite3AddColumnType(Parse*,Token*);
2749b7916a78Sdrh void sqlite3AddDefaultValue(Parse*,ExprSpan*);
275039002505Sdanielk1977 void sqlite3AddCollateType(Parse*, Token*);
275119a8e7e8Sdanielk1977 void sqlite3EndTable(Parse*,Token*,Token*,Select*);
2752522c26fbSdrh int sqlite3ParseUri(const char*,const char*,unsigned int*,
2753522c26fbSdrh                     sqlite3_vfs**,char**,char **);
2754421377e6Sdrh Btree *sqlite3DbNameToBtree(sqlite3*,const char*);
27551d8cb21fSdan int sqlite3CodeOnce(Parse *);
2756b7f9164eSdrh 
2757f5e7bb51Sdrh Bitvec *sqlite3BitvecCreate(u32);
2758f5e7bb51Sdrh int sqlite3BitvecTest(Bitvec*, u32);
2759f5e7bb51Sdrh int sqlite3BitvecSet(Bitvec*, u32);
2760e98c9049Sdrh void sqlite3BitvecClear(Bitvec*, u32, void*);
2761f5e7bb51Sdrh void sqlite3BitvecDestroy(Bitvec*);
2762bea2a948Sdanielk1977 u32 sqlite3BitvecSize(Bitvec*);
27633088d59eSdrh int sqlite3BitvecBuiltinTest(int,int*);
2764f5e7bb51Sdrh 
27653d4501e5Sdrh RowSet *sqlite3RowSetInit(sqlite3*, void*, unsigned int);
27663d4501e5Sdrh void sqlite3RowSetClear(RowSet*);
27673d4501e5Sdrh void sqlite3RowSetInsert(RowSet*, i64);
2768733bf1b1Sdrh int sqlite3RowSetTest(RowSet*, u8 iBatch, i64);
27693d4501e5Sdrh int sqlite3RowSetNext(RowSet*, i64*);
27703d4501e5Sdrh 
2771fdd48a76Sdrh void sqlite3CreateView(Parse*,Token*,Token*,Token*,Select*,int,int);
2772fe3fcbe2Sdanielk1977 
2773fe3fcbe2Sdanielk1977 #if !defined(SQLITE_OMIT_VIEW) || !defined(SQLITE_OMIT_VIRTUALTABLE)
27744adee20fSdanielk1977   int sqlite3ViewGetColumnNames(Parse*,Table*);
2775b7f9164eSdrh #else
2776b7f9164eSdrh # define sqlite3ViewGetColumnNames(A,B) 0
2777b7f9164eSdrh #endif
2778b7f9164eSdrh 
2779a073384fSdrh void sqlite3DropTable(Parse*, SrcList*, int, int);
2780faacf17cSdrh void sqlite3CodeDropTable(Parse*, Table*, int, int);
27811feeaed2Sdan void sqlite3DeleteTable(sqlite3*, Table*);
27820b9f50d8Sdrh #ifndef SQLITE_OMIT_AUTOINCREMENT
27830b9f50d8Sdrh   void sqlite3AutoincrementBegin(Parse *pParse);
27840b9f50d8Sdrh   void sqlite3AutoincrementEnd(Parse *pParse);
27850b9f50d8Sdrh #else
27860b9f50d8Sdrh # define sqlite3AutoincrementBegin(X)
27870b9f50d8Sdrh # define sqlite3AutoincrementEnd(X)
27880b9f50d8Sdrh #endif
27895f085269Sdrh int sqlite3CodeCoroutine(Parse*, Select*, SelectDest*);
27904adee20fSdanielk1977 void sqlite3Insert(Parse*, SrcList*, ExprList*, Select*, IdList*, int);
27916c535158Sdrh void *sqlite3ArrayAllocate(sqlite3*,void*,int,int*,int*);
279217435752Sdrh IdList *sqlite3IdListAppend(sqlite3*, IdList*, Token*);
27934adee20fSdanielk1977 int sqlite3IdListIndex(IdList*,const char*);
2794a78c22c4Sdrh SrcList *sqlite3SrcListEnlarge(sqlite3*, SrcList*, int, int);
279517435752Sdrh SrcList *sqlite3SrcListAppend(sqlite3*, SrcList*, Token*, Token*);
2796b1c685b0Sdanielk1977 SrcList *sqlite3SrcListAppendFromTerm(Parse*, SrcList*, Token*, Token*,
279785574e31Sdanielk1977                                       Token*, Select*, Expr*, IdList*);
2798b1c685b0Sdanielk1977 void sqlite3SrcListIndexedBy(Parse *, SrcList *, Token *);
2799b1c685b0Sdanielk1977 int sqlite3IndexedByLookup(Parse *, struct SrcList_item *);
280061dfc31dSdrh void sqlite3SrcListShiftJoinType(SrcList*);
28014adee20fSdanielk1977 void sqlite3SrcListAssignCursors(Parse*, SrcList*);
2802633e6d57Sdrh void sqlite3IdListDelete(sqlite3*, IdList*);
2803633e6d57Sdrh void sqlite3SrcListDelete(sqlite3*, SrcList*);
28041da40a38Sdan Index *sqlite3CreateIndex(Parse*,Token*,Token*,SrcList*,ExprList*,int,Token*,
28058a9789b6Sdrh                           Expr*, int, int);
28064d91a701Sdrh void sqlite3DropIndex(Parse*, SrcList*, int);
28077d10d5a6Sdrh int sqlite3Select(Parse*, Select*, SelectDest*);
280817435752Sdrh Select *sqlite3SelectNew(Parse*,ExprList*,SrcList*,Expr*,ExprList*,
2809832ee3d4Sdrh                          Expr*,ExprList*,u16,Expr*,Expr*);
2810633e6d57Sdrh void sqlite3SelectDelete(sqlite3*, Select*);
28114adee20fSdanielk1977 Table *sqlite3SrcListLookup(Parse*, SrcList*);
28124adee20fSdanielk1977 int sqlite3IsReadOnly(Parse*, Table*, int);
2813c00da105Sdanielk1977 void sqlite3OpenTable(Parse*, int iCur, int iDb, Table*, int);
2814273f619bSshane #if defined(SQLITE_ENABLE_UPDATE_DELETE_LIMIT) && !defined(SQLITE_OMIT_SUBQUERY)
281549ffdbf4Sshane Expr *sqlite3LimitWhere(Parse*,SrcList*,Expr*,ExprList*,Expr*,Expr*,char*);
28164281bd42Sshane #endif
28174adee20fSdanielk1977 void sqlite3DeleteFrom(Parse*, SrcList*, Expr*);
28184adee20fSdanielk1977 void sqlite3Update(Parse*, SrcList*, ExprList*, Expr*, int);
281946ec5b63Sdrh WhereInfo *sqlite3WhereBegin(Parse*,SrcList*,Expr*,ExprList*,ExprList*,u16,int);
28204adee20fSdanielk1977 void sqlite3WhereEnd(WhereInfo*);
2821c63367efSdrh u64 sqlite3WhereOutputRowCount(WhereInfo*);
28226f32848dSdrh int sqlite3WhereIsDistinct(WhereInfo*);
28236f32848dSdrh int sqlite3WhereIsOrdered(WhereInfo*);
28246f32848dSdrh int sqlite3WhereContinueLabel(WhereInfo*);
28256f32848dSdrh int sqlite3WhereBreakLabel(WhereInfo*);
28266f32848dSdrh int sqlite3WhereOkOnePass(WhereInfo*);
2827a748fdccSdrh int sqlite3ExprCodeGetColumn(Parse*, Table*, int, int, int, u8);
28285c092e8aSdrh void sqlite3ExprCodeGetColumnOfTable(Vdbe*, Table*, int, int, int);
2829b21e7c70Sdrh void sqlite3ExprCodeMove(Parse*, int, int, int);
2830ceea3321Sdrh void sqlite3ExprCacheStore(Parse*, int, int, int);
2831ceea3321Sdrh void sqlite3ExprCachePush(Parse*);
2832ceea3321Sdrh void sqlite3ExprCachePop(Parse*, int);
2833f49f3523Sdrh void sqlite3ExprCacheRemove(Parse*, int, int);
2834ceea3321Sdrh void sqlite3ExprCacheClear(Parse*);
2835da250ea5Sdrh void sqlite3ExprCacheAffinityChange(Parse*, int, int);
2836389a1adbSdrh int sqlite3ExprCode(Parse*, Expr*, int);
28372dcef11bSdrh int sqlite3ExprCodeTemp(Parse*, Expr*, int*);
2838678ccce8Sdrh int sqlite3ExprCodeTarget(Parse*, Expr*, int);
28392dcef11bSdrh int sqlite3ExprCodeAndCache(Parse*, Expr*, int);
2840678ccce8Sdrh void sqlite3ExprCodeConstants(Parse*, Expr*);
2841191b54cbSdrh int sqlite3ExprCodeExprList(Parse*, ExprList*, int, int);
28424adee20fSdanielk1977 void sqlite3ExprIfTrue(Parse*, Expr*, int, int);
28434adee20fSdanielk1977 void sqlite3ExprIfFalse(Parse*, Expr*, int, int);
28449bb575fdSdrh Table *sqlite3FindTable(sqlite3*,const char*, const char*);
2845ca424114Sdrh Table *sqlite3LocateTable(Parse*,int isView,const char*, const char*);
284641fb5cd1Sdan Table *sqlite3LocateTableItem(Parse*,int isView,struct SrcList_item *);
28479bb575fdSdrh Index *sqlite3FindIndex(sqlite3*,const char*, const char*);
28489bb575fdSdrh void sqlite3UnlinkAndDeleteTable(sqlite3*,int,const char*);
28499bb575fdSdrh void sqlite3UnlinkAndDeleteIndex(sqlite3*,int,const char*);
285074161705Sdrh void sqlite3Vacuum(Parse*);
28519bb575fdSdrh int sqlite3RunVacuum(char**, sqlite3*);
285217435752Sdrh char *sqlite3NameFromToken(sqlite3*, Token*);
2853619a1305Sdrh int sqlite3ExprCompare(Expr*, Expr*, int);
2854619a1305Sdrh int sqlite3ExprListCompare(ExprList*, ExprList*, int);
28554bd5f73fSdrh int sqlite3ExprImpliesExpr(Expr*, Expr*, int);
2856d2b3e23bSdrh void sqlite3ExprAnalyzeAggregates(NameContext*, Expr*);
2857d2b3e23bSdrh void sqlite3ExprAnalyzeAggList(NameContext*,ExprList*);
2858030796dfSdrh int sqlite3FunctionUsesThisSrc(Expr*, SrcList*);
28594adee20fSdanielk1977 Vdbe *sqlite3GetVdbe(Parse*);
28602fa1868fSdrh void sqlite3PrngSaveState(void);
28612fa1868fSdrh void sqlite3PrngRestoreState(void);
28622fa1868fSdrh void sqlite3PrngResetState(void);
28630f198a74Sdrh void sqlite3RollbackAll(sqlite3*,int);
28644adee20fSdanielk1977 void sqlite3CodeVerifySchema(Parse*, int);
286557966753Sdan void sqlite3CodeVerifyNamedSchema(Parse*, const char *zDb);
2866684917c2Sdrh void sqlite3BeginTransaction(Parse*, int);
28674adee20fSdanielk1977 void sqlite3CommitTransaction(Parse*);
28684adee20fSdanielk1977 void sqlite3RollbackTransaction(Parse*);
2869fd7f0452Sdanielk1977 void sqlite3Savepoint(Parse*, int, Token*);
2870fd7f0452Sdanielk1977 void sqlite3CloseSavepoints(sqlite3 *);
28714245c405Sdrh void sqlite3LeaveMutexAndCloseZombie(sqlite3*);
28724adee20fSdanielk1977 int sqlite3ExprIsConstant(Expr*);
28730a168377Sdrh int sqlite3ExprIsConstantNotJoin(Expr*);
2874eb55bd2fSdrh int sqlite3ExprIsConstantOrFunction(Expr*);
28754adee20fSdanielk1977 int sqlite3ExprIsInteger(Expr*, int*);
2876039fc32eSdrh int sqlite3ExprCanBeNull(const Expr*);
28772f2855b6Sdrh void sqlite3ExprCodeIsNullJump(Vdbe*, const Expr*, int, int);
2878039fc32eSdrh int sqlite3ExprNeedsNoAffinityChange(const Expr*, char);
28794adee20fSdanielk1977 int sqlite3IsRowid(const char*);
28802283d46cSdan void sqlite3GenerateRowDelete(Parse*, Table*, int, int, int, Trigger *, int);
28812d401ab8Sdrh void sqlite3GenerateRowIndexDelete(Parse*, Table*, int, int*);
2882b2b9d3d7Sdrh int sqlite3GenerateIndexKey(Parse*, Index*, int, int, int, int*);
288304adf416Sdrh void sqlite3GenerateConstraintChecks(Parse*,Table*,int,int,
2884de630353Sdanielk1977                                      int*,int,int,int,int,int*);
28852832ad42Sdan void sqlite3CompleteInsertion(Parse*, Table*, int, int, int*, int, int, int);
2886aa9b8963Sdrh int sqlite3OpenTableAndIndices(Parse*, Table*, int, int);
28874adee20fSdanielk1977 void sqlite3BeginWriteOperation(Parse*, int, int);
2888ff738bceSdrh void sqlite3MultiWrite(Parse*);
2889e0af83acSdan void sqlite3MayAbort(Parse*);
2890d91c1a17Sdrh void sqlite3HaltConstraint(Parse*, int, int, char*, int);
28916ab3a2ecSdanielk1977 Expr *sqlite3ExprDup(sqlite3*,Expr*,int);
28926ab3a2ecSdanielk1977 ExprList *sqlite3ExprListDup(sqlite3*,ExprList*,int);
28936ab3a2ecSdanielk1977 SrcList *sqlite3SrcListDup(sqlite3*,SrcList*,int);
289417435752Sdrh IdList *sqlite3IdListDup(sqlite3*,IdList*);
28956ab3a2ecSdanielk1977 Select *sqlite3SelectDup(sqlite3*,Select*,int);
289670a8ca3cSdrh void sqlite3FuncDefInsert(FuncDefHash*, FuncDef*);
289789d5d6a2Sdrh FuncDef *sqlite3FindFunction(sqlite3*,const char*,int,int,u8,u8);
28989bb575fdSdrh void sqlite3RegisterBuiltinFunctions(sqlite3*);
2899777c5386Sdrh void sqlite3RegisterDateTimeFunctions(void);
290070a8ca3cSdrh void sqlite3RegisterGlobalFunctions(void);
29017e8b848aSdrh int sqlite3SafetyCheckOk(sqlite3*);
29027e8b848aSdrh int sqlite3SafetyCheckSickOrOk(sqlite3*);
29039cbf3425Sdrh void sqlite3ChangeCookie(Parse*, int);
2904fa4e62f3Sshane 
2905fa4e62f3Sshane #if !defined(SQLITE_OMIT_VIEW) && !defined(SQLITE_OMIT_TRIGGER)
29062a5d825eSdrh void sqlite3MaterializeView(Parse*, Table*, Expr*, int);
2907fa4e62f3Sshane #endif
2908b7f9164eSdrh 
2909b7f9164eSdrh #ifndef SQLITE_OMIT_TRIGGER
2910ef2cb63eSdanielk1977   void sqlite3BeginTrigger(Parse*, Token*,Token*,int,int,IdList*,SrcList*,
291160218d2aSdrh                            Expr*,int, int);
29124adee20fSdanielk1977   void sqlite3FinishTrigger(Parse*, TriggerStep*, Token*);
2913fdd48a76Sdrh   void sqlite3DropTrigger(Parse*, SrcList*, int);
291474161705Sdrh   void sqlite3DropTriggerPtr(Parse*, Trigger*);
29152f886d1dSdanielk1977   Trigger *sqlite3TriggersExist(Parse *, Table*, int, ExprList*, int *pMask);
29162f886d1dSdanielk1977   Trigger *sqlite3TriggerList(Parse *, Table *);
2917165921a7Sdan   void sqlite3CodeRowTrigger(Parse*, Trigger *, int, ExprList*, int, Table *,
291894d7f50aSdan                             int, int, int);
29191da40a38Sdan   void sqlite3CodeRowTriggerDirect(Parse *, Trigger *, Table *, int, int, int);
2920dc379456Sdrh   void sqliteViewTriggers(Parse*, Table*, Expr*, int, ExprList*);
2921633e6d57Sdrh   void sqlite3DeleteTriggerStep(sqlite3*, TriggerStep*);
292217435752Sdrh   TriggerStep *sqlite3TriggerSelectStep(sqlite3*,Select*);
292317435752Sdrh   TriggerStep *sqlite3TriggerInsertStep(sqlite3*,Token*, IdList*,
29245eff7cf0Sshane                                         ExprList*,Select*,u8);
29255eff7cf0Sshane   TriggerStep *sqlite3TriggerUpdateStep(sqlite3*,Token*,ExprList*, Expr*, u8);
292617435752Sdrh   TriggerStep *sqlite3TriggerDeleteStep(sqlite3*,Token*, Expr*);
2927633e6d57Sdrh   void sqlite3DeleteTrigger(sqlite3*, Trigger*);
2928b7f9164eSdrh   void sqlite3UnlinkAndDeleteTrigger(sqlite3*,int,const char*);
2929bb5f168fSdan   u32 sqlite3TriggerColmask(Parse*,Trigger*,ExprList*,int,int,Table*,int);
293065a7cd16Sdan # define sqlite3ParseToplevel(p) ((p)->pToplevel ? (p)->pToplevel : (p))
2931b7f9164eSdrh #else
293262c14b34Sdanielk1977 # define sqlite3TriggersExist(B,C,D,E,F) 0
2933633e6d57Sdrh # define sqlite3DeleteTrigger(A,B)
2934cdd536f0Sdrh # define sqlite3DropTriggerPtr(A,B)
2935b7f9164eSdrh # define sqlite3UnlinkAndDeleteTrigger(A,B,C)
293694d7f50aSdan # define sqlite3CodeRowTrigger(A,B,C,D,E,F,G,H,I)
293775cbd984Sdan # define sqlite3CodeRowTriggerDirect(A,B,C,D,E,F)
29382943c372Sdanielk1977 # define sqlite3TriggerList(X, Y) 0
293965a7cd16Sdan # define sqlite3ParseToplevel(p) p
2940bb5f168fSdan # define sqlite3TriggerColmask(A,B,C,D,E,F,G) 0
2941b7f9164eSdrh #endif
2942b7f9164eSdrh 
29434adee20fSdanielk1977 int sqlite3JoinType(Parse*, Token*, Token*, Token*);
29440202b29eSdanielk1977 void sqlite3CreateForeignKey(Parse*, ExprList*, Token*, ExprList*, int);
29454adee20fSdanielk1977 void sqlite3DeferForeignKey(Parse*, int);
2946ed6c8671Sdrh #ifndef SQLITE_OMIT_AUTHORIZATION
2947728b5779Sdrh   void sqlite3AuthRead(Parse*,Expr*,Schema*,SrcList*);
29484adee20fSdanielk1977   int sqlite3AuthCheck(Parse*,int, const char*, const char*, const char*);
29494adee20fSdanielk1977   void sqlite3AuthContextPush(Parse*, AuthContext*, const char*);
29504adee20fSdanielk1977   void sqlite3AuthContextPop(AuthContext*);
295102470b20Sdan   int sqlite3AuthReadCol(Parse*, const char *, const char *, int);
2952ed6c8671Sdrh #else
2953b5258c3dSdanielk1977 # define sqlite3AuthRead(a,b,c,d)
29544adee20fSdanielk1977 # define sqlite3AuthCheck(a,b,c,d,e)    SQLITE_OK
29554adee20fSdanielk1977 # define sqlite3AuthContextPush(a,b,c)
29564adee20fSdanielk1977 # define sqlite3AuthContextPop(a)  ((void)(a))
2957ed6c8671Sdrh #endif
2958f744bb56Sdanielk1977 void sqlite3Attach(Parse*, Expr*, Expr*, Expr*);
2959f744bb56Sdanielk1977 void sqlite3Detach(Parse*, Expr*);
29604adee20fSdanielk1977 int sqlite3FixInit(DbFixer*, Parse*, int, const char*, const Token*);
29614adee20fSdanielk1977 int sqlite3FixSrcList(DbFixer*, SrcList*);
29624adee20fSdanielk1977 int sqlite3FixSelect(DbFixer*, Select*);
29634adee20fSdanielk1977 int sqlite3FixExpr(DbFixer*, Expr*);
29644adee20fSdanielk1977 int sqlite3FixExprList(DbFixer*, ExprList*);
29654adee20fSdanielk1977 int sqlite3FixTriggerStep(DbFixer*, TriggerStep*);
29669339da1fSdrh int sqlite3AtoF(const char *z, double*, int, u8);
2967fec19aadSdrh int sqlite3GetInt32(const char *, int*);
296860ac3f42Sdrh int sqlite3Atoi(const char*);
2969ee85813cSdrh int sqlite3Utf16ByteLen(const void *pData, int nChar);
2970ee85813cSdrh int sqlite3Utf8CharLen(const char *pData, int nByte);
297142610961Sdrh u32 sqlite3Utf8Read(const u8**);
29723f8d5cfcSshane 
29733f8d5cfcSshane /*
29743f8d5cfcSshane ** Routines to read and write variable-length integers.  These used to
29753f8d5cfcSshane ** be defined locally, but now we use the varint routines in the util.c
2976952856adSshane ** file.  Code should use the MACRO forms below, as the Varint32 versions
2977952856adSshane ** are coded to assume the single byte case is already handled (which
2978952856adSshane ** the MACRO form does).
29793f8d5cfcSshane */
2980192ac1dcSdanielk1977 int sqlite3PutVarint(unsigned char*, u64);
298135b5a33eSdrh int sqlite3PutVarint32(unsigned char*, u32);
29821bd10f8aSdrh u8 sqlite3GetVarint(const unsigned char *, u64 *);
29831bd10f8aSdrh u8 sqlite3GetVarint32(const unsigned char *, u32 *);
2984192ac1dcSdanielk1977 int sqlite3VarintLen(u64 v);
29853f8d5cfcSshane 
29863f8d5cfcSshane /*
29873f8d5cfcSshane ** The header of a record consists of a sequence variable-length integers.
29883f8d5cfcSshane ** These integers are almost always small and are encoded as a single byte.
29893f8d5cfcSshane ** The following macros take advantage this fact to provide a fast encode
29903f8d5cfcSshane ** and decode of the integers in a record header.  It is faster for the common
29913f8d5cfcSshane ** case where the integer is a single byte.  It is a little slower when the
29923f8d5cfcSshane ** integer is two or more bytes.  But overall it is faster.
29933f8d5cfcSshane **
29943f8d5cfcSshane ** The following expressions are equivalent:
29953f8d5cfcSshane **
29963f8d5cfcSshane **     x = sqlite3GetVarint32( A, &B );
29973f8d5cfcSshane **     x = sqlite3PutVarint32( A, B );
29983f8d5cfcSshane **
29993f8d5cfcSshane **     x = getVarint32( A, B );
30003f8d5cfcSshane **     x = putVarint32( A, B );
30013f8d5cfcSshane **
30023f8d5cfcSshane */
30034bde3702Sdrh #define getVarint32(A,B)  \
30044bde3702Sdrh   (u8)((*(A)<(u8)0x80)?((B)=(u32)*(A)),1:sqlite3GetVarint32((A),(u32 *)&(B)))
30054bde3702Sdrh #define putVarint32(A,B)  \
30064bde3702Sdrh   (u8)(((u32)(B)<(u32)0x80)?(*(A)=(unsigned char)(B)),1:\
30074bde3702Sdrh   sqlite3PutVarint32((A),(B)))
30083f8d5cfcSshane #define getVarint    sqlite3GetVarint
30093f8d5cfcSshane #define putVarint    sqlite3PutVarint
30103f8d5cfcSshane 
30113f8d5cfcSshane 
301269f8bb9cSdan const char *sqlite3IndexAffinityStr(Vdbe *, Index *);
3013a37cdde0Sdanielk1977 void sqlite3TableAffinityStr(Vdbe *, Table *);
3014e014a838Sdanielk1977 char sqlite3CompareAffinity(Expr *pExpr, char aff2);
3015e014a838Sdanielk1977 int sqlite3IndexAffinityOk(Expr *pExpr, char idx_affinity);
3016bf3b721fSdanielk1977 char sqlite3ExprAffinity(Expr *pExpr);
30179339da1fSdrh int sqlite3Atoi64(const char*, i64*, int, u8);
30189bb575fdSdrh void sqlite3Error(sqlite3*, int, const char*,...);
3019ca48c90fSdrh void *sqlite3HexToBlob(sqlite3*, const char *z, int n);
3020cd74b611Sdan u8 sqlite3HexToInt(int h);
3021ef2cb63eSdanielk1977 int sqlite3TwoPartName(Parse *, Token *, Token *, Token **);
3022dd08ca0fSmistachkin 
3023dd08ca0fSmistachkin #if defined(SQLITE_DEBUG) || defined(SQLITE_TEST) || \
3024dd08ca0fSmistachkin     defined(SQLITE_DEBUG_OS_TRACE)
3025f2c1c99fSmistachkin const char *sqlite3ErrName(int);
3026dd08ca0fSmistachkin #endif
3027dd08ca0fSmistachkin 
3028f20b21c8Sdanielk1977 const char *sqlite3ErrStr(int);
30298a41449eSdanielk1977 int sqlite3ReadSchema(Parse *pParse);
3030c4a64facSdrh CollSeq *sqlite3FindCollSeq(sqlite3*,u8 enc, const char*,int);
3031c4a64facSdrh CollSeq *sqlite3LocateCollSeq(Parse *pParse, const char*zName);
30327cedc8d4Sdanielk1977 CollSeq *sqlite3ExprCollSeq(Parse *pParse, Expr *pExpr);
30330a8a406eSdrh Expr *sqlite3ExprAddCollateToken(Parse *pParse, Expr*, Token*);
30340a8a406eSdrh Expr *sqlite3ExprAddCollateString(Parse*,Expr*,const char*);
30350a8a406eSdrh Expr *sqlite3ExprSkipCollate(Expr*);
30367cedc8d4Sdanielk1977 int sqlite3CheckCollSeq(Parse *, CollSeq *);
3037d8123366Sdanielk1977 int sqlite3CheckObjectName(Parse *, const char *);
3038b28af71aSdanielk1977 void sqlite3VdbeSetChanges(sqlite3 *, int);
3039158b9cb9Sdrh int sqlite3AddInt64(i64*,i64);
3040158b9cb9Sdrh int sqlite3SubInt64(i64*,i64);
3041158b9cb9Sdrh int sqlite3MulInt64(i64*,i64);
3042d50ffc41Sdrh int sqlite3AbsInt32(int);
304381cc5163Sdrh #ifdef SQLITE_ENABLE_8_3_NAMES
304481cc5163Sdrh void sqlite3FileSuffix3(const char*, char*);
304581cc5163Sdrh #else
304681cc5163Sdrh # define sqlite3FileSuffix3(X,Y)
304781cc5163Sdrh #endif
304838d9c612Sdrh u8 sqlite3GetBoolean(const char *z,int);
30494e6af134Sdanielk1977 
3050b21c8cd4Sdrh const void *sqlite3ValueText(sqlite3_value*, u8);
3051b21c8cd4Sdrh int sqlite3ValueBytes(sqlite3_value*, u8);
3052b21c8cd4Sdrh void sqlite3ValueSetStr(sqlite3_value*, int, const void *,u8,
30531e536953Sdanielk1977                         void(*)(void*));
30544e6af134Sdanielk1977 void sqlite3ValueFree(sqlite3_value*);
30551e536953Sdanielk1977 sqlite3_value *sqlite3ValueNew(sqlite3 *);
3056b7dca7d7Sdan char *sqlite3Utf16to8(sqlite3 *, const void*, int, u8);
30571e536953Sdanielk1977 int sqlite3ValueFromExpr(sqlite3 *, Expr *, u8, u8, sqlite3_value **);
3058b21c8cd4Sdrh void sqlite3ValueApplyAffinity(sqlite3_value *, u8, u8);
305946c99e0fSdrh #ifndef SQLITE_AMALGAMATION
3060a6c2ed91Sdrh extern const unsigned char sqlite3OpcodeProperty[];
30614e5ffc5fSdrh extern const unsigned char sqlite3UpperToLower[];
306278ca0e7eSdanielk1977 extern const unsigned char sqlite3CtypeMap[];
3063094430ebSdrh extern const Token sqlite3IntTokens[];
3064075c23afSdanielk1977 extern SQLITE_WSD struct Sqlite3Config sqlite3Config;
3065075c23afSdanielk1977 extern SQLITE_WSD FuncDefHash sqlite3GlobalFunctions;
3066f83dc1efSdrh #ifndef SQLITE_OMIT_WSD
3067ddb68e17Sdrh extern int sqlite3PendingByte;
306846c99e0fSdrh #endif
3069f83dc1efSdrh #endif
3070cdf011dcSdrh void sqlite3RootPageMoved(sqlite3*, int, int, int);
30714343fea2Sdrh void sqlite3Reindex(Parse*, Token*, Token*);
3072545f587fSdrh void sqlite3AlterFunctions(void);
30739fd2a9a0Sdanielk1977 void sqlite3AlterRenameTable(Parse*, SrcList*, Token*);
30749fd2a9a0Sdanielk1977 int sqlite3GetToken(const unsigned char *, int *);
30752958a4e6Sdrh void sqlite3NestedParse(Parse*, const char*, ...);
3076d89bd007Sdrh void sqlite3ExpirePreparedStatements(sqlite3*);
30771450bc6eSdrh int sqlite3CodeSubselect(Parse *, Expr *, int, int);
30787d10d5a6Sdrh void sqlite3SelectPrep(Parse*, Select*, NameContext*);
30793e3f1a5bSdrh int sqlite3MatchSpanName(const char*, const char*, const char*, const char*);
30807d10d5a6Sdrh int sqlite3ResolveExprNames(NameContext*, Expr*);
30817d10d5a6Sdrh void sqlite3ResolveSelectNames(Parse*, Select*, NameContext*);
30823780be11Sdrh void sqlite3ResolveSelfReference(Parse*,Table*,int,Expr*,ExprList*);
30837d10d5a6Sdrh int sqlite3ResolveOrderGroupBy(Parse*, Select*, ExprList*, const char*);
3084c7538b5fSdanielk1977 void sqlite3ColumnDefault(Vdbe *, Table *, int, int);
308519a8e7e8Sdanielk1977 void sqlite3AlterFinishAddColumn(Parse *, Token *);
308619a8e7e8Sdanielk1977 void sqlite3AlterBeginAddColumn(Parse *, SrcList *);
308779e72a50Sdrh CollSeq *sqlite3GetCollSeq(Parse*, u8, CollSeq *, const char*);
3088b7916a78Sdrh char sqlite3AffinityType(const char*);
30899f18e8a0Sdrh void sqlite3Analyze(Parse*, Token*, Token*);
3090a4afb65cSdrh int sqlite3InvokeBusyHandler(BusyHandler*);
3091ff2d5ea4Sdrh int sqlite3FindDb(sqlite3*, Token*);
30920410302eSdanielk1977 int sqlite3FindDbName(sqlite3 *, const char *);
3093cf1be45fSdrh int sqlite3AnalysisLoad(sqlite3*,int iDB);
3094d46def77Sdan void sqlite3DeleteIndexSamples(sqlite3*,Index*);
309551147baaSdrh void sqlite3DefaultRowEst(Index*);
309655ef4d97Sdrh void sqlite3RegisterLikeFunctions(sqlite3*, int);
3097d64fe2f3Sdrh int sqlite3IsLikeFunction(sqlite3*,Expr*,int*,char*);
3098fdd6e85aSdrh void sqlite3MinimumFileFormat(Parse*, int, int);
3099b6ee6607Sdrh void sqlite3SchemaClear(void *);
31001e536953Sdanielk1977 Schema *sqlite3SchemaGet(sqlite3 *, Btree *);
3101e501b89aSdanielk1977 int sqlite3SchemaToIndex(sqlite3 *db, Schema *);
3102323df790Sdrh KeyInfo *sqlite3KeyInfoAlloc(sqlite3*,int);
3103b3bf556eSdanielk1977 KeyInfo *sqlite3IndexKeyinfo(Parse *, Index *);
3104771151b6Sdanielk1977 int sqlite3CreateFunc(sqlite3 *, const char *, int, int, void *,
3105771151b6Sdanielk1977   void (*)(sqlite3_context*,int,sqlite3_value **),
3106d2199f0fSdan   void (*)(sqlite3_context*,int,sqlite3_value **), void (*)(sqlite3_context*),
3107d2199f0fSdan   FuncDestructor *pDestructor
3108d2199f0fSdan );
310954f0198eSdanielk1977 int sqlite3ApiExit(sqlite3 *db, int);
3110ddfb2f03Sdanielk1977 int sqlite3OpenTempDatabase(Parse *);
311169dab1d3Sdrh 
3112f089aa45Sdrh void sqlite3StrAccumInit(StrAccum*, char*, int, int);
3113ade86483Sdrh void sqlite3StrAccumAppend(StrAccum*,const char*,int);
31147e02e5e6Sdrh void sqlite3AppendSpace(StrAccum*,int);
3115ade86483Sdrh char *sqlite3StrAccumFinish(StrAccum*);
3116ade86483Sdrh void sqlite3StrAccumReset(StrAccum*);
31171013c932Sdrh void sqlite3SelectDestInit(SelectDest*,int,int);
3118f7b0b0adSdan Expr *sqlite3CreateColumnExpr(sqlite3 *, SrcList *, int, int);
31191e536953Sdanielk1977 
31200410302eSdanielk1977 void sqlite3BackupRestart(sqlite3_backup *);
31210410302eSdanielk1977 void sqlite3BackupUpdate(sqlite3_backup *, Pgno, const u8 *);
31220410302eSdanielk1977 
31231435a9a1Sdrh #ifdef SQLITE_ENABLE_STAT3_OR_STAT4
31249fecc546Sdrh void sqlite3AnalyzeFunctions(void);
312587cd9321Sdan int sqlite3Stat4ProbeSetValue(Parse*,Index*,UnpackedRecord**,Expr*,u8,int,int*);
31267a419235Sdan void sqlite3Stat4ProbeFree(UnpackedRecord*);
31279fecc546Sdrh #endif
31287a419235Sdan 
312995bdbbbdSdrh /*
313095bdbbbdSdrh ** The interface to the LEMON-generated parser
313195bdbbbdSdrh */
313295bdbbbdSdrh void *sqlite3ParserAlloc(void*(*)(size_t));
313395bdbbbdSdrh void sqlite3ParserFree(void*, void(*)(void*));
313495bdbbbdSdrh void sqlite3Parser(void*, int, Token, Parse*);
3135ec424a5bSdrh #ifdef YYTRACKMAXSTACKDEPTH
3136ec424a5bSdrh   int sqlite3ParserStackPeak(void*);
3137ec424a5bSdrh #endif
313895bdbbbdSdrh 
31397aaa8786Sdrh void sqlite3AutoLoadExtensions(sqlite3*);
314069dab1d3Sdrh #ifndef SQLITE_OMIT_LOAD_EXTENSION
3141f1952c5dSdrh   void sqlite3CloseExtensions(sqlite3*);
314269dab1d3Sdrh #else
314369dab1d3Sdrh # define sqlite3CloseExtensions(X)
314469dab1d3Sdrh #endif
3145e3026636Sdanielk1977 
3146c00da105Sdanielk1977 #ifndef SQLITE_OMIT_SHARED_CACHE
3147c00da105Sdanielk1977   void sqlite3TableLock(Parse *, int, int, u8, const char *);
3148c00da105Sdanielk1977 #else
3149c00da105Sdanielk1977   #define sqlite3TableLock(v,w,x,y,z)
3150c00da105Sdanielk1977 #endif
3151c00da105Sdanielk1977 
315253c14021Sdrh #ifdef SQLITE_TEST
315353c14021Sdrh   int sqlite3Utf8To8(unsigned char*);
315453c14021Sdrh #endif
315553c14021Sdrh 
3156b9bb7c18Sdrh #ifdef SQLITE_OMIT_VIRTUALTABLE
3157595a523aSdanielk1977 #  define sqlite3VtabClear(Y)
31589dbee7dcSdanielk1977 #  define sqlite3VtabSync(X,Y) SQLITE_OK
3159f9e7dda7Sdanielk1977 #  define sqlite3VtabRollback(X)
3160f9e7dda7Sdanielk1977 #  define sqlite3VtabCommit(X)
3161093e0f6fSdanielk1977 #  define sqlite3VtabInSync(db) 0
3162595a523aSdanielk1977 #  define sqlite3VtabLock(X)
3163595a523aSdanielk1977 #  define sqlite3VtabUnlock(X)
3164595a523aSdanielk1977 #  define sqlite3VtabUnlockList(X)
3165a311b803Sdan #  define sqlite3VtabSavepoint(X, Y, Z) SQLITE_OK
3166c3c8dac7Sdrh #  define sqlite3GetVTable(X,Y)  ((VTable*)0)
3167b9bb7c18Sdrh #else
31681feeaed2Sdan    void sqlite3VtabClear(sqlite3 *db, Table*);
3169bba02a95Sdan    void sqlite3VtabDisconnect(sqlite3 *db, Table *p);
3170016f7811Sdan    int sqlite3VtabSync(sqlite3 *db, Vdbe*);
3171f9e7dda7Sdanielk1977    int sqlite3VtabRollback(sqlite3 *db);
3172f9e7dda7Sdanielk1977    int sqlite3VtabCommit(sqlite3 *db);
3173595a523aSdanielk1977    void sqlite3VtabLock(VTable *);
3174595a523aSdanielk1977    void sqlite3VtabUnlock(VTable *);
3175595a523aSdanielk1977    void sqlite3VtabUnlockList(sqlite3*);
3176a311b803Sdan    int sqlite3VtabSavepoint(sqlite3 *, int, int);
3177016f7811Sdan    void sqlite3VtabImportErrmsg(Vdbe*, sqlite3_vtab*);
3178c3c8dac7Sdrh    VTable *sqlite3GetVTable(sqlite3*, Table*);
3179093e0f6fSdanielk1977 #  define sqlite3VtabInSync(db) ((db)->nVTrans>0 && (db)->aVTrans==0)
3180b9bb7c18Sdrh #endif
31814f3dd150Sdrh void sqlite3VtabMakeWritable(Parse*,Table*);
3182b421b894Sdrh void sqlite3VtabBeginParse(Parse*, Token*, Token*, Token*, int);
3183b9bb7c18Sdrh void sqlite3VtabFinishParse(Parse*, Token*);
3184b9bb7c18Sdrh void sqlite3VtabArgInit(Parse*);
3185b9bb7c18Sdrh void sqlite3VtabArgExtend(Parse*, Token*);
318678efaba1Sdanielk1977 int sqlite3VtabCallCreate(sqlite3*, int, const char *, char **);
31877e6ebfb2Sdanielk1977 int sqlite3VtabCallConnect(Parse*, Table*);
31889e39ce87Sdanielk1977 int sqlite3VtabCallDestroy(sqlite3*, int, const char *);
3189595a523aSdanielk1977 int sqlite3VtabBegin(sqlite3 *, VTable *);
31901e536953Sdanielk1977 FuncDef *sqlite3VtabOverloadFunction(sqlite3 *,FuncDef*, int nArg, Expr*);
3191b7481e70Sdrh void sqlite3InvalidFunction(sqlite3_context*,int,sqlite3_value**);
31925f18a221Sdrh int sqlite3VdbeParameterIndex(Vdbe*, const char*, int);
31934a27a286Sshane int sqlite3TransferBindings(sqlite3_stmt *, sqlite3_stmt *);
3194b900aaf3Sdrh int sqlite3Reprepare(Vdbe*);
3195b1a6c3c1Sdrh void sqlite3ExprListCheckLength(Parse*, ExprList*, const char*);
3196bcbb04e5Sdanielk1977 CollSeq *sqlite3BinaryCompareCollSeq(Parse *, Expr *, Expr *);
31971c514148Sdrh int sqlite3TempInMemory(const sqlite3*);
319828e5386fSdan const char *sqlite3JournalModename(int);
319906a2d825Sdan #ifndef SQLITE_OMIT_WAL
3200cdc1f049Sdan   int sqlite3Checkpoint(sqlite3*, int, int, int*, int*);
3201b033d8b9Sdrh   int sqlite3WalDefaultHook(void*,sqlite3*,const char*,int);
320206a2d825Sdan #endif
3203d829335eSdanielk1977 
320475cbd984Sdan /* Declarations for functions in fkey.c. All of these are replaced by
320575cbd984Sdan ** no-op macros if OMIT_FOREIGN_KEY is defined. In this case no foreign
320675cbd984Sdan ** key functionality is available. If OMIT_TRIGGER is defined but
320775cbd984Sdan ** OMIT_FOREIGN_KEY is not, only some of the functions are no-oped. In
320875cbd984Sdan ** this case foreign keys are parsed, but no other functionality is
320975cbd984Sdan ** provided (enforcement of FK constraints requires the triggers sub-system).
321075cbd984Sdan */
321175cbd984Sdan #if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
3212*8ff2d956Sdan   void sqlite3FkCheck(Parse*, Table*, int, int, int*, int);
3213d66c8309Sdan   void sqlite3FkDropTable(Parse*, SrcList *, Table*);
3214*8ff2d956Sdan   void sqlite3FkActions(Parse*, Table*, ExprList*, int, int*, int);
3215e7a94d81Sdan   int sqlite3FkRequired(Parse*, Table*, int*, int);
3216e7a94d81Sdan   u32 sqlite3FkOldmask(Parse*, Table*);
3217432cc5b9Sdan   FKey *sqlite3FkReferences(Table *);
32181da40a38Sdan #else
3219*8ff2d956Sdan   #define sqlite3FkActions(a,b,c,d,e,f)
3220e7a94d81Sdan   #define sqlite3FkCheck(a,b,c,d)
3221d66c8309Sdan   #define sqlite3FkDropTable(a,b,c)
3222e7a94d81Sdan   #define sqlite3FkOldmask(a,b)          0
3223*8ff2d956Sdan   #define sqlite3FkRequired(a,b,c,d,e,f) 0
32241da40a38Sdan #endif
322575cbd984Sdan #ifndef SQLITE_OMIT_FOREIGN_KEY
32261feeaed2Sdan   void sqlite3FkDelete(sqlite3 *, Table*);
32276c5b915fSdrh   int sqlite3FkLocateIndex(Parse*,Table*,FKey*,Index**,int**);
322875cbd984Sdan #else
32291feeaed2Sdan   #define sqlite3FkDelete(a,b)
32306c5b915fSdrh   #define sqlite3FkLocateIndex(a,b,c,d,e)
323175cbd984Sdan #endif
323275cbd984Sdan 
3233643167ffSdrh 
3234643167ffSdrh /*
3235643167ffSdrh ** Available fault injectors.  Should be numbered beginning with 0.
3236643167ffSdrh */
3237643167ffSdrh #define SQLITE_FAULTINJECTOR_MALLOC     0
32387e8b848aSdrh #define SQLITE_FAULTINJECTOR_COUNT      1
3239643167ffSdrh 
3240643167ffSdrh /*
3241ef05f2dfSdanielk1977 ** The interface to the code in fault.c used for identifying "benign"
3242ef05f2dfSdanielk1977 ** malloc failures. This is only present if SQLITE_OMIT_BUILTIN_TEST
3243ef05f2dfSdanielk1977 ** is not defined.
3244643167ffSdrh */
32453088d59eSdrh #ifndef SQLITE_OMIT_BUILTIN_TEST
32462d1d86fbSdanielk1977   void sqlite3BeginBenignMalloc(void);
32472d1d86fbSdanielk1977   void sqlite3EndBenignMalloc(void);
3248643167ffSdrh #else
32492d1d86fbSdanielk1977   #define sqlite3BeginBenignMalloc()
3250867d05a0Sdanielk1977   #define sqlite3EndBenignMalloc()
3251643167ffSdrh #endif
3252643167ffSdrh 
32539a96b668Sdanielk1977 #define IN_INDEX_ROWID           1
32549a96b668Sdanielk1977 #define IN_INDEX_EPH             2
32551ccce449Sdrh #define IN_INDEX_INDEX_ASC       3
32561ccce449Sdrh #define IN_INDEX_INDEX_DESC      4
32570cdc022eSdanielk1977 int sqlite3FindInIndex(Parse *, Expr *, int*);
32589a96b668Sdanielk1977 
3259c7b6017cSdanielk1977 #ifdef SQLITE_ENABLE_ATOMIC_WRITE
3260c7b6017cSdanielk1977   int sqlite3JournalOpen(sqlite3_vfs *, const char *, sqlite3_file *, int, int);
3261c7b6017cSdanielk1977   int sqlite3JournalSize(sqlite3_vfs *);
3262f55b8998Sdanielk1977   int sqlite3JournalCreate(sqlite3_file *);
32633de0f184Sdan   int sqlite3JournalExists(sqlite3_file *p);
3264c7b6017cSdanielk1977 #else
3265c7b6017cSdanielk1977   #define sqlite3JournalSize(pVfs) ((pVfs)->szOsFile)
32663de0f184Sdan   #define sqlite3JournalExists(p) 1
3267c7b6017cSdanielk1977 #endif
3268c7b6017cSdanielk1977 
3269b3175389Sdanielk1977 void sqlite3MemJournalOpen(sqlite3_file *);
32703a5990abSdrh int sqlite3MemJournalSize(void);
3271b3175389Sdanielk1977 int sqlite3IsMemJournal(sqlite3_file *);
3272b3175389Sdanielk1977 
32730224d26dSdrh #if SQLITE_MAX_EXPR_DEPTH>0
32744b5255acSdanielk1977   void sqlite3ExprSetHeight(Parse *pParse, Expr *p);
3275fc976065Sdanielk1977   int sqlite3SelectExprHeight(Select *);
32767d10d5a6Sdrh   int sqlite3ExprCheckHeight(Parse*, int);
3277fc976065Sdanielk1977 #else
32784b5255acSdanielk1977   #define sqlite3ExprSetHeight(x,y)
32790224d26dSdrh   #define sqlite3SelectExprHeight(x) 0
32807d10d5a6Sdrh   #define sqlite3ExprCheckHeight(x,y)
3281fc976065Sdanielk1977 #endif
3282fc976065Sdanielk1977 
3283a3152895Sdrh u32 sqlite3Get4byte(const u8*);
3284a3152895Sdrh void sqlite3Put4byte(u8*, u32);
3285a3152895Sdrh 
3286404ca075Sdanielk1977 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
3287404ca075Sdanielk1977   void sqlite3ConnectionBlocked(sqlite3 *, sqlite3 *);
3288404ca075Sdanielk1977   void sqlite3ConnectionUnlocked(sqlite3 *db);
3289404ca075Sdanielk1977   void sqlite3ConnectionClosed(sqlite3 *db);
3290404ca075Sdanielk1977 #else
3291404ca075Sdanielk1977   #define sqlite3ConnectionBlocked(x,y)
3292404ca075Sdanielk1977   #define sqlite3ConnectionUnlocked(x)
3293404ca075Sdanielk1977   #define sqlite3ConnectionClosed(x)
3294404ca075Sdanielk1977 #endif
3295404ca075Sdanielk1977 
32966e736838Sdrh #ifdef SQLITE_DEBUG
32976e736838Sdrh   void sqlite3ParserTrace(FILE*, char *);
32986e736838Sdrh #endif
32996e736838Sdrh 
3300b0603416Sdrh /*
3301b0603416Sdrh ** If the SQLITE_ENABLE IOTRACE exists then the global variable
33023a00f907Smlcreech ** sqlite3IoTrace is a pointer to a printf-like routine used to
3303b0603416Sdrh ** print I/O tracing messages.
3304b0603416Sdrh */
3305b0603416Sdrh #ifdef SQLITE_ENABLE_IOTRACE
33063a00f907Smlcreech # define IOTRACE(A)  if( sqlite3IoTrace ){ sqlite3IoTrace A; }
3307b4622b60Sdanielk1977   void sqlite3VdbeIOTraceSql(Vdbe*);
3308e265b084Sdrh SQLITE_EXTERN void (*sqlite3IoTrace)(const char*,...);
3309b0603416Sdrh #else
3310b0603416Sdrh # define IOTRACE(A)
3311b4622b60Sdanielk1977 # define sqlite3VdbeIOTraceSql(X)
3312b0603416Sdrh #endif
3313b0603416Sdrh 
3314107b56e8Sdrh /*
3315107b56e8Sdrh ** These routines are available for the mem2.c debugging memory allocator
3316107b56e8Sdrh ** only.  They are used to verify that different "types" of memory
3317107b56e8Sdrh ** allocations are properly tracked by the system.
3318107b56e8Sdrh **
3319107b56e8Sdrh ** sqlite3MemdebugSetType() sets the "type" of an allocation to one of
3320107b56e8Sdrh ** the MEMTYPE_* macros defined below.  The type must be a bitmask with
3321107b56e8Sdrh ** a single bit set.
3322107b56e8Sdrh **
3323107b56e8Sdrh ** sqlite3MemdebugHasType() returns true if any of the bits in its second
3324107b56e8Sdrh ** argument match the type set by the previous sqlite3MemdebugSetType().
3325107b56e8Sdrh ** sqlite3MemdebugHasType() is intended for use inside assert() statements.
3326107b56e8Sdrh **
3327174b9a16Sdrh ** sqlite3MemdebugNoType() returns true if none of the bits in its second
3328174b9a16Sdrh ** argument match the type set by the previous sqlite3MemdebugSetType().
3329107b56e8Sdrh **
3330107b56e8Sdrh ** Perhaps the most important point is the difference between MEMTYPE_HEAP
3331174b9a16Sdrh ** and MEMTYPE_LOOKASIDE.  If an allocation is MEMTYPE_LOOKASIDE, that means
3332174b9a16Sdrh ** it might have been allocated by lookaside, except the allocation was
3333174b9a16Sdrh ** too large or lookaside was already full.  It is important to verify
3334174b9a16Sdrh ** that allocations that might have been satisfied by lookaside are not
3335174b9a16Sdrh ** passed back to non-lookaside free() routines.  Asserts such as the
3336174b9a16Sdrh ** example above are placed on the non-lookaside free() routines to verify
3337174b9a16Sdrh ** this constraint.
3338107b56e8Sdrh **
3339107b56e8Sdrh ** All of this is no-op for a production build.  It only comes into
3340107b56e8Sdrh ** play when the SQLITE_MEMDEBUG compile-time option is used.
3341107b56e8Sdrh */
3342107b56e8Sdrh #ifdef SQLITE_MEMDEBUG
3343107b56e8Sdrh   void sqlite3MemdebugSetType(void*,u8);
3344107b56e8Sdrh   int sqlite3MemdebugHasType(void*,u8);
3345174b9a16Sdrh   int sqlite3MemdebugNoType(void*,u8);
3346107b56e8Sdrh #else
3347107b56e8Sdrh # define sqlite3MemdebugSetType(X,Y)  /* no-op */
3348107b56e8Sdrh # define sqlite3MemdebugHasType(X,Y)  1
3349174b9a16Sdrh # define sqlite3MemdebugNoType(X,Y)   1
3350e3026636Sdanielk1977 #endif
3351107b56e8Sdrh #define MEMTYPE_HEAP       0x01  /* General heap allocations */
3352174b9a16Sdrh #define MEMTYPE_LOOKASIDE  0x02  /* Might have been lookaside memory */
3353107b56e8Sdrh #define MEMTYPE_SCRATCH    0x04  /* Scratch allocations */
3354107b56e8Sdrh #define MEMTYPE_PCACHE     0x08  /* Page cache allocations */
3355174b9a16Sdrh #define MEMTYPE_DB         0x10  /* Uses sqlite3DbMalloc, not sqlite_malloc */
3356107b56e8Sdrh 
3357107b56e8Sdrh #endif /* _SQLITEINT_H_ */
3358