xref: /sqlite-3.40.0/src/sqliteInt.h (revision c28c4e50)
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 */
924881feaa0Sdrh   union {
92539001e75Sdrh     volatile int isInterrupted; /* True if sqlite3_interrupt has been called */
926881feaa0Sdrh     double notUsed1;            /* Spacer */
927881feaa0Sdrh   } u1;
928633e6d57Sdrh   Lookaside lookaside;          /* Lookaside malloc configuration */
929ed6c8671Sdrh #ifndef SQLITE_OMIT_AUTHORIZATION
930e22a334bSdrh   int (*xAuth)(void*,int,const char*,const char*,const char*,const char*);
931e22a334bSdrh                                 /* Access authorization function */
932ed6c8671Sdrh   void *pAuthArg;               /* 1st argument to the access auth function */
933ed6c8671Sdrh #endif
934348bb5d6Sdanielk1977 #ifndef SQLITE_OMIT_PROGRESS_CALLBACK
935348bb5d6Sdanielk1977   int (*xProgress)(void *);     /* The progress callback */
936348bb5d6Sdanielk1977   void *pProgressArg;           /* Argument to the progress callback */
9378f8c65f7Sdrh   unsigned nProgressOps;        /* Number of opcodes for progress callback */
938348bb5d6Sdanielk1977 #endif
939b9bb7c18Sdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
940a451017dSdrh   int nVTrans;                  /* Allocated size of aVTrans */
941b9bb7c18Sdrh   Hash aModule;                 /* populated by sqlite3_create_module() */
942b061d058Sdan   VtabCtx *pVtabCtx;            /* Context for active vtab connect/create */
943595a523aSdanielk1977   VTable **aVTrans;             /* Virtual tables with open transactions */
944595a523aSdanielk1977   VTable *pDisconnect;    /* Disconnect these in next sqlite3_prepare() */
9456b456a2bSdanielk1977 #endif
94670a8ca3cSdrh   FuncDefHash aFunc;            /* Hash table of connection functions */
947fcd35c7bSdrh   Hash aCollSeq;                /* All collating sequences */
948fcd35c7bSdrh   BusyHandler busyHandler;      /* Busy callback */
949fcd35c7bSdrh   Db aDbStatic[2];              /* Static space for the 2 default backends */
950fd7f0452Sdanielk1977   Savepoint *pSavepoint;        /* List of active savepoints */
951a451017dSdrh   int busyTimeout;              /* Busy handler timeout, in msec */
952fd7f0452Sdanielk1977   int nSavepoint;               /* Number of non-transaction savepoints */
953bd43455cSdanielk1977   int nStatement;               /* Number of nested statement-transactions  */
9541da40a38Sdan   i64 nDeferredCons;            /* Net deferred constraints this transaction. */
955648e2643Sdrh   i64 nDeferredImmCons;         /* Net deferred immediate constraints */
956d46def77Sdan   int *pnBytesFreed;            /* If not NULL, increment this in DbFree() */
957404ca075Sdanielk1977 
958404ca075Sdanielk1977 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
959404ca075Sdanielk1977   /* The following variables are all protected by the STATIC_MASTER
960404ca075Sdanielk1977   ** mutex, not by sqlite3.mutex. They are used by code in notify.c.
96165a73badSdrh   **
96265a73badSdrh   ** When X.pUnlockConnection==Y, that means that X is waiting for Y to
96365a73badSdrh   ** unlock so that it can proceed.
96465a73badSdrh   **
96565a73badSdrh   ** When X.pBlockingConnection==Y, that means that something that X tried
96665a73badSdrh   ** tried to do recently failed with an SQLITE_LOCKED error due to locks
96765a73badSdrh   ** held by Y.
968404ca075Sdanielk1977   */
969404ca075Sdanielk1977   sqlite3 *pBlockingConnection; /* Connection that caused SQLITE_LOCKED */
970404ca075Sdanielk1977   sqlite3 *pUnlockConnection;           /* Connection to watch for unlock */
971404ca075Sdanielk1977   void *pUnlockArg;                     /* Argument to xUnlockNotify */
972404ca075Sdanielk1977   void (*xUnlockNotify)(void **, int);  /* Unlock notify callback */
973404ca075Sdanielk1977   sqlite3 *pNextBlocked;        /* Next in list of all blocked connections */
974404ca075Sdanielk1977 #endif
97575897234Sdrh };
97675897234Sdrh 
97703b808a6Sdrh /*
97803b808a6Sdrh ** A macro to discover the encoding of a database.
97903b808a6Sdrh */
98014db2665Sdanielk1977 #define ENC(db) ((db)->aDb[0].pSchema->enc)
98114db2665Sdanielk1977 
98275897234Sdrh /*
98307096f68Sdrh ** Possible values for the sqlite3.flags.
98475897234Sdrh */
9857e5418e4Sdrh #define SQLITE_VdbeTrace      0x00000001  /* True to trace VDBE execution */
9867e5418e4Sdrh #define SQLITE_InternChanges  0x00000002  /* Uncommitted Hash table changes */
98740c3941cSdrh #define SQLITE_FullFSync      0x00000004  /* Use full fsync on the backend */
98840c3941cSdrh #define SQLITE_CkptFullFSync  0x00000008  /* Use full fsync for checkpoint */
98940c3941cSdrh #define SQLITE_CacheSpill     0x00000010  /* OK to spill pager cache */
99040c3941cSdrh #define SQLITE_FullColNames   0x00000020  /* Show full column names on SELECT */
99140c3941cSdrh #define SQLITE_ShortColNames  0x00000040  /* Show short columns names */
99240c3941cSdrh #define SQLITE_CountRows      0x00000080  /* Count rows changed by INSERT, */
9931bee3d7bSdrh                                           /*   DELETE, or UPDATE and return */
9941bee3d7bSdrh                                           /*   the count using a callback. */
99540c3941cSdrh #define SQLITE_NullCallback   0x00000100  /* Invoke the callback once if the */
9966a535340Sdrh                                           /*   result set is empty */
99740c3941cSdrh #define SQLITE_SqlTrace       0x00000200  /* Debug print SQL as it executes */
99840c3941cSdrh #define SQLITE_VdbeListing    0x00000400  /* Debug listings of VDBE programs */
99940c3941cSdrh #define SQLITE_WriteSchema    0x00000800  /* OK to update SQLITE_MASTER */
100040c3941cSdrh #define SQLITE_VdbeAddopTrace 0x00001000  /* Trace sqlite3VdbeAddOp() calls */
100140c3941cSdrh #define SQLITE_IgnoreChecks   0x00002000  /* Do not enforce check constraints */
100240c3941cSdrh #define SQLITE_ReadUncommitted 0x0004000  /* For shared-cache mode */
100340c3941cSdrh #define SQLITE_LegacyFileFmt  0x00008000  /* Create new databases in format 1 */
100440c3941cSdrh #define SQLITE_RecoveryMode   0x00010000  /* Ignore schema errors */
100540c3941cSdrh #define SQLITE_ReverseOrder   0x00020000  /* Reverse unordered SELECTs */
100640c3941cSdrh #define SQLITE_RecTriggers    0x00040000  /* Enable recursive triggers */
100740c3941cSdrh #define SQLITE_ForeignKeys    0x00080000  /* Enforce foreign key constraints  */
100840c3941cSdrh #define SQLITE_AutoIndex      0x00100000  /* Enable automatic indexes */
100940c3941cSdrh #define SQLITE_PreferBuiltin  0x00200000  /* Preference to built-in funcs */
101040c3941cSdrh #define SQLITE_LoadExtension  0x00400000  /* Enable load_extension */
101140c3941cSdrh #define SQLITE_EnableTrigger  0x00800000  /* True to enable triggers */
101240c3941cSdrh #define SQLITE_DeferFKs       0x01000000  /* Defer all FK constraints */
101340c3941cSdrh #define SQLITE_QueryOnly      0x02000000  /* Disable database changes */
1014b1eaa718Sdrh 
101507096f68Sdrh 
101607096f68Sdrh /*
10177e5418e4Sdrh ** Bits of the sqlite3.dbOptFlags field that are used by the
10187e5418e4Sdrh ** sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS,...) interface to
10197e5418e4Sdrh ** selectively disable various optimizations.
102007096f68Sdrh */
10217e5418e4Sdrh #define SQLITE_QueryFlattener 0x0001   /* Query flattening */
10227e5418e4Sdrh #define SQLITE_ColumnCache    0x0002   /* Column cache */
10237e5418e4Sdrh #define SQLITE_GroupByOrder   0x0004   /* GROUPBY cover of ORDERBY */
10247e5418e4Sdrh #define SQLITE_FactorOutConst 0x0008   /* Constant factoring */
10257e5418e4Sdrh #define SQLITE_IdxRealAsInt   0x0010   /* Store REAL as INT in indices */
10267e5418e4Sdrh #define SQLITE_DistinctOpt    0x0020   /* DISTINCT using indexes */
10277e5418e4Sdrh #define SQLITE_CoverIdxScan   0x0040   /* Covering index scans */
1028a9e3fc05Sdrh #define SQLITE_OrderByIdxJoin 0x0080   /* ORDER BY of joins via index */
1029a5759677Sdrh #define SQLITE_SubqCoroutine  0x0100   /* Evaluate subqueries as coroutines */
1030eb5bc926Sdrh #define SQLITE_Transitive     0x0200   /* Transitive constraints */
10311031bd99Sdrh #define SQLITE_OmitNoopJoin   0x0400   /* Omit unused tables in joins */
103240aa936fSdrh #define SQLITE_Stat3          0x0800   /* Use the SQLITE_STAT3 table */
1033add5ce30Sdrh #define SQLITE_AdjustOutEst   0x1000   /* Adjust output estimates using WHERE */
1034a5759677Sdrh #define SQLITE_AllOpts        0xffff   /* All optimizations */
10357e5418e4Sdrh 
10367e5418e4Sdrh /*
10377e5418e4Sdrh ** Macros for testing whether or not optimizations are enabled or disabled.
10387e5418e4Sdrh */
10397e5418e4Sdrh #ifndef SQLITE_OMIT_BUILTIN_TEST
10407e5418e4Sdrh #define OptimizationDisabled(db, mask)  (((db)->dbOptFlags&(mask))!=0)
10417e5418e4Sdrh #define OptimizationEnabled(db, mask)   (((db)->dbOptFlags&(mask))==0)
10427e5418e4Sdrh #else
10437e5418e4Sdrh #define OptimizationDisabled(db, mask)  0
10447e5418e4Sdrh #define OptimizationEnabled(db, mask)   1
10457e5418e4Sdrh #endif
104634c68fbaSdanielk1977 
104758b9576bSdrh /*
1048247be43dSdrh ** Possible values for the sqlite.magic field.
1049247be43dSdrh ** The numbers are obtained at random and have no special meaning, other
1050247be43dSdrh ** than being distinct from one another.
1051247be43dSdrh */
1052247be43dSdrh #define SQLITE_MAGIC_OPEN     0xa029a697  /* Database is open */
1053247be43dSdrh #define SQLITE_MAGIC_CLOSED   0x9f3c2d33  /* Database is closed */
10547e8b848aSdrh #define SQLITE_MAGIC_SICK     0x4b771290  /* Error and awaiting close */
1055247be43dSdrh #define SQLITE_MAGIC_BUSY     0xf03b7906  /* Database currently in use */
1056247be43dSdrh #define SQLITE_MAGIC_ERROR    0xb5357930  /* An SQLITE_MISUSE error occurred */
10574245c405Sdrh #define SQLITE_MAGIC_ZOMBIE   0x64cffc7f  /* Close with last statement close */
1058247be43dSdrh 
1059247be43dSdrh /*
10600bce8354Sdrh ** Each SQL function is defined by an instance of the following
10610bce8354Sdrh ** structure.  A pointer to this structure is stored in the sqlite.aFunc
10628e0a2f90Sdrh ** hash table.  When multiple functions have the same name, the hash table
10638e0a2f90Sdrh ** points to a linked list of these structures.
10642803757aSdrh */
10650bce8354Sdrh struct FuncDef {
1066e82f5d04Sdrh   i16 nArg;            /* Number of arguments.  -1 means unlimited */
1067d36e1041Sdrh   u16 funcFlags;       /* Some combination of SQLITE_FUNC_* */
10681350b030Sdrh   void *pUserData;     /* User data parameter */
10690bce8354Sdrh   FuncDef *pNext;      /* Next function with same name */
1070f9b596ebSdrh   void (*xFunc)(sqlite3_context*,int,sqlite3_value**); /* Regular function */
1071f9b596ebSdrh   void (*xStep)(sqlite3_context*,int,sqlite3_value**); /* Aggregate step */
1072467bcf36Sshane   void (*xFinalize)(sqlite3_context*);                /* Aggregate finalizer */
10738c0a791aSdanielk1977   char *zName;         /* SQL name of the function. */
107470a8ca3cSdrh   FuncDef *pHash;      /* Next with a different name but the same hash */
1075d2199f0fSdan   FuncDestructor *pDestructor;   /* Reference counted destructor function */
1076d2199f0fSdan };
1077d2199f0fSdan 
1078d2199f0fSdan /*
1079d2199f0fSdan ** This structure encapsulates a user-function destructor callback (as
1080d2199f0fSdan ** configured using create_function_v2()) and a reference counter. When
1081d2199f0fSdan ** create_function_v2() is called to create a function with a destructor,
1082d2199f0fSdan ** a single object of this type is allocated. FuncDestructor.nRef is set to
1083d2199f0fSdan ** the number of FuncDef objects created (either 1 or 3, depending on whether
1084d2199f0fSdan ** or not the specified encoding is SQLITE_ANY). The FuncDef.pDestructor
1085d2199f0fSdan ** member of each of the new FuncDef objects is set to point to the allocated
1086d2199f0fSdan ** FuncDestructor.
1087d2199f0fSdan **
1088d2199f0fSdan ** Thereafter, when one of the FuncDef objects is deleted, the reference
1089d2199f0fSdan ** count on this object is decremented. When it reaches 0, the destructor
1090d2199f0fSdan ** is invoked and the FuncDestructor structure freed.
1091d2199f0fSdan */
1092d2199f0fSdan struct FuncDestructor {
1093d2199f0fSdan   int nRef;
1094d2199f0fSdan   void (*xDestroy)(void *);
1095d2199f0fSdan   void *pUserData;
10968e0a2f90Sdrh };
10972803757aSdrh 
10982803757aSdrh /*
1099a748fdccSdrh ** Possible values for FuncDef.flags.  Note that the _LENGTH and _TYPEOF
1100a748fdccSdrh ** values must correspond to OPFLAG_LENGTHARG and OPFLAG_TYPEOFARG.  There
1101a748fdccSdrh ** are assert() statements in the code to verify this.
11027d10d5a6Sdrh */
1103d36e1041Sdrh #define SQLITE_FUNC_ENCMASK  0x003 /* SQLITE_UTF8, SQLITE_UTF16BE or UTF16LE */
1104d36e1041Sdrh #define SQLITE_FUNC_LIKE     0x004 /* Candidate for the LIKE optimization */
1105d36e1041Sdrh #define SQLITE_FUNC_CASE     0x008 /* Case-sensitive LIKE-type function */
1106d36e1041Sdrh #define SQLITE_FUNC_EPHEM    0x010 /* Ephemeral.  Delete with VDBE */
1107d36e1041Sdrh #define SQLITE_FUNC_NEEDCOLL 0x020 /* sqlite3GetFuncCollSeq() might be called */
1108d36e1041Sdrh #define SQLITE_FUNC_LENGTH   0x040 /* Built-in length() function */
1109d36e1041Sdrh #define SQLITE_FUNC_TYPEOF   0x080 /* Built-in typeof() function */
1110d36e1041Sdrh #define SQLITE_FUNC_COUNT    0x100 /* Built-in count(*) aggregate */
1111d36e1041Sdrh #define SQLITE_FUNC_COALESCE 0x200 /* Built-in coalesce() or ifnull() */
1112d36e1041Sdrh #define SQLITE_FUNC_UNLIKELY 0x400 /* Built-in unlikely() 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) \
1140d36e1041Sdrh   {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) \
1143d36e1041Sdrh   {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) \
1146d36e1041Sdrh   {nArg, SQLITE_UTF8|(bNC*SQLITE_FUNC_NEEDCOLL), \
11476ac78a0dSdrh    pArg, 0, xFunc, 0, 0, #zName, 0, 0}
1148777c5386Sdrh #define LIKEFUNC(zName, nArg, arg, flags) \
1149d36e1041Sdrh   {nArg, SQLITE_UTF8|flags, (void *)arg, 0, likeFunc, 0, 0, #zName, 0, 0}
1150777c5386Sdrh #define AGGREGATE(zName, nArg, arg, nc, xStep, xFinal) \
1151d36e1041Sdrh   {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 
1475*c28c4e50Sdrh #define OE_Default  10  /* 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 */
1563*c28c4e50Sdrh   u8 iScanRatio;           /* Scan rate relative to the main table */
1564*c28c4e50Sdrh   unsigned onError:4;      /* OE_Abort, OE_Ignore, OE_Replace, or OE_None */
1565b376daebSdrh   unsigned autoIndex:2;    /* 1==UNIQUE, 2==PRIMARY KEY, 0==CREATE INDEX */
1566b376daebSdrh   unsigned bUnordered:1;   /* Use this index for == or IN queries only */
15677699d1c4Sdrh   unsigned uniqNotNull:1;  /* True if UNIQUE and NOT NULL for all columns */
15681435a9a1Sdrh #ifdef SQLITE_ENABLE_STAT3_OR_STAT4
15692b9cf669Sdrh   int nSample;             /* Number of elements in aSample[] */
15708ad169abSdan   int nSampleCol;          /* Size of IndexSample.anEq[] and so on */
1571eea568d6Sdan   tRowcnt *aAvgEq;         /* Average nEq values for keys not in aSample */
1572faacf17cSdrh   IndexSample *aSample;    /* Samples of the left-most key */
1573faacf17cSdrh #endif
157402fa4696Sdan };
157502fa4696Sdan 
157602fa4696Sdan /*
157774e7c8f5Sdrh ** Each sample stored in the sqlite_stat3 table is represented in memory
157874e7c8f5Sdrh ** using a structure of this type.  See documentation at the top of the
157974e7c8f5Sdrh ** analyze.c source file for additional information.
158002fa4696Sdan */
158102fa4696Sdan struct IndexSample {
1582f52bb8d3Sdan   void *p;          /* Pointer to sampled record */
1583f52bb8d3Sdan   int n;            /* Size of record in bytes */
1584f52bb8d3Sdan   tRowcnt *anEq;    /* Est. number of rows where the key equals this sample */
1585f52bb8d3Sdan   tRowcnt *anLt;    /* Est. number of rows where key is less than this sample */
1586f52bb8d3Sdan   tRowcnt *anDLt;   /* Est. number of distinct keys less than this sample */
158775897234Sdrh };
158875897234Sdrh 
158975897234Sdrh /*
159075897234Sdrh ** Each token coming out of the lexer is an instance of
15914b59ab5eSdrh ** this structure.  Tokens are also used as part of an expression.
15924efc4754Sdrh **
15934efc4754Sdrh ** Note if Token.z==0 then Token.dyn and Token.n are undefined and
1594467bcf36Sshane ** may contain random values.  Do not make any assumptions about Token.dyn
15954efc4754Sdrh ** and Token.n when Token.z==0.
159675897234Sdrh */
159775897234Sdrh struct Token {
1598b7916a78Sdrh   const char *z;     /* Text of the token.  Not NULL-terminated! */
1599b7916a78Sdrh   unsigned int n;    /* Number of characters in this token */
160075897234Sdrh };
160175897234Sdrh 
160275897234Sdrh /*
160313449892Sdrh ** An instance of this structure contains information needed to generate
160413449892Sdrh ** code for a SELECT that contains aggregate functions.
160513449892Sdrh **
160613449892Sdrh ** If Expr.op==TK_AGG_COLUMN or TK_AGG_FUNCTION then Expr.pAggInfo is a
160713449892Sdrh ** pointer to this structure.  The Expr.iColumn field is the index in
160813449892Sdrh ** AggInfo.aCol[] or AggInfo.aFunc[] of information needed to generate
160913449892Sdrh ** code for that node.
161013449892Sdrh **
161113449892Sdrh ** AggInfo.pGroupBy and AggInfo.aFunc.pExpr point to fields within the
161213449892Sdrh ** original Select structure that describes the SELECT statement.  These
161313449892Sdrh ** fields do not need to be freed when deallocating the AggInfo structure.
161413449892Sdrh */
161513449892Sdrh struct AggInfo {
161613449892Sdrh   u8 directMode;          /* Direct rendering mode means take data directly
161713449892Sdrh                           ** from source tables rather than from accumulators */
161813449892Sdrh   u8 useSortingIdx;       /* In direct mode, reference the sorting index rather
161913449892Sdrh                           ** than the source table */
162013449892Sdrh   int sortingIdx;         /* Cursor number of the sorting index */
16215134d135Sdan   int sortingIdxPTab;     /* Cursor number of pseudo-table */
162213449892Sdrh   int nSortingColumn;     /* Number of columns in the sorting index */
1623a451017dSdrh   ExprList *pGroupBy;     /* The group by clause */
162413449892Sdrh   struct AggInfo_col {    /* For each column used in source tables */
16250817d0dfSdanielk1977     Table *pTab;             /* Source table */
162613449892Sdrh     int iTable;              /* Cursor number of the source table */
162713449892Sdrh     int iColumn;             /* Column number within the source table */
162813449892Sdrh     int iSorterColumn;       /* Column number in the sorting index */
162913449892Sdrh     int iMem;                /* Memory location that acts as accumulator */
16305774b806Sdrh     Expr *pExpr;             /* The original expression */
163113449892Sdrh   } *aCol;
163213449892Sdrh   int nColumn;            /* Number of used entries in aCol[] */
163313449892Sdrh   int nAccumulator;       /* Number of columns that show through to the output.
163413449892Sdrh                           ** Additional columns are used only as parameters to
163513449892Sdrh                           ** aggregate functions */
163613449892Sdrh   struct AggInfo_func {   /* For each aggregate function */
163713449892Sdrh     Expr *pExpr;             /* Expression encoding the function */
163813449892Sdrh     FuncDef *pFunc;          /* The aggregate function implementation */
163913449892Sdrh     int iMem;                /* Memory location that acts as accumulator */
1640467bcf36Sshane     int iDistinct;           /* Ephemeral table used to enforce DISTINCT */
164113449892Sdrh   } *aFunc;
164213449892Sdrh   int nFunc;              /* Number of entries in aFunc[] */
164313449892Sdrh };
164413449892Sdrh 
164513449892Sdrh /*
16468677d308Sdrh ** The datatype ynVar is a signed integer, either 16-bit or 32-bit.
16478677d308Sdrh ** Usually it is 16-bits.  But if SQLITE_MAX_VARIABLE_NUMBER is greater
16488677d308Sdrh ** than 32767 we have to make it 32-bit.  16-bit is preferred because
16498677d308Sdrh ** it uses less memory in the Expr object, which is a big memory user
16508677d308Sdrh ** in systems with lots of prepared statements.  And few applications
16518677d308Sdrh ** need more than about 10 or 20 variables.  But some extreme users want
16528677d308Sdrh ** to have prepared statements with over 32767 variables, and for them
16538677d308Sdrh ** the option is available (at compile-time).
16548677d308Sdrh */
16558677d308Sdrh #if SQLITE_MAX_VARIABLE_NUMBER<=32767
1656481aa74eSdrh typedef i16 ynVar;
16578677d308Sdrh #else
16588677d308Sdrh typedef int ynVar;
16598677d308Sdrh #endif
16608677d308Sdrh 
16618677d308Sdrh /*
166275897234Sdrh ** Each node of an expression in the parse tree is an instance
166322f70c32Sdrh ** of this structure.
166422f70c32Sdrh **
166522f70c32Sdrh ** Expr.op is the opcode. The integer parser token codes are reused
166622f70c32Sdrh ** as opcodes here. For example, the parser defines TK_GE to be an integer
166722f70c32Sdrh ** code representing the ">=" operator. This same integer code is reused
166822f70c32Sdrh ** to represent the greater-than-or-equal-to operator in the expression
166922f70c32Sdrh ** tree.
167022f70c32Sdrh **
16716ab3a2ecSdanielk1977 ** If the expression is an SQL literal (TK_INTEGER, TK_FLOAT, TK_BLOB,
16726ab3a2ecSdanielk1977 ** or TK_STRING), then Expr.token contains the text of the SQL literal. If
16736ab3a2ecSdanielk1977 ** the expression is a variable (TK_VARIABLE), then Expr.token contains the
16746ab3a2ecSdanielk1977 ** variable name. Finally, if the expression is an SQL function (TK_FUNCTION),
16756ab3a2ecSdanielk1977 ** then Expr.token contains the name of the function.
167622f70c32Sdrh **
16776ab3a2ecSdanielk1977 ** Expr.pRight and Expr.pLeft are the left and right subexpressions of a
16786ab3a2ecSdanielk1977 ** binary operator. Either or both may be NULL.
16796ab3a2ecSdanielk1977 **
16806ab3a2ecSdanielk1977 ** Expr.x.pList is a list of arguments if the expression is an SQL function,
16816ab3a2ecSdanielk1977 ** a CASE expression or an IN expression of the form "<lhs> IN (<y>, <z>...)".
16826ab3a2ecSdanielk1977 ** Expr.x.pSelect is used if the expression is a sub-select or an expression of
16836ab3a2ecSdanielk1977 ** the form "<lhs> IN (SELECT ...)". If the EP_xIsSelect bit is set in the
16846ab3a2ecSdanielk1977 ** Expr.flags mask, then Expr.x.pSelect is valid. Otherwise, Expr.x.pList is
16856ab3a2ecSdanielk1977 ** valid.
168622f70c32Sdrh **
168722f70c32Sdrh ** An expression of the form ID or ID.ID refers to a column in a table.
168822f70c32Sdrh ** For such expressions, Expr.op is set to TK_COLUMN and Expr.iTable is
168922f70c32Sdrh ** the integer cursor number of a VDBE cursor pointing to that table and
169022f70c32Sdrh ** Expr.iColumn is the column number for the specific column.  If the
169122f70c32Sdrh ** expression is used as a result in an aggregate SELECT, then the
169222f70c32Sdrh ** value is also stored in the Expr.iAgg column in the aggregate so that
169322f70c32Sdrh ** it can be accessed after all aggregates are computed.
169422f70c32Sdrh **
16956ab3a2ecSdanielk1977 ** If the expression is an unbound variable marker (a question mark
16966ab3a2ecSdanielk1977 ** character '?' in the original SQL) then the Expr.iTable holds the index
16976ab3a2ecSdanielk1977 ** number for that variable.
169822f70c32Sdrh **
16991398ad36Sdrh ** If the expression is a subquery then Expr.iColumn holds an integer
17001398ad36Sdrh ** register number containing the result of the subquery.  If the
17011398ad36Sdrh ** subquery gives a constant result, then iTable is -1.  If the subquery
17021398ad36Sdrh ** gives a different answer at different times during statement processing
17031398ad36Sdrh ** then iTable is the address of a subroutine that computes the subquery.
17041398ad36Sdrh **
1705aee18ef8Sdanielk1977 ** If the Expr is of type OP_Column, and the table it is selecting from
1706aee18ef8Sdanielk1977 ** is a disk table or the "old.*" pseudo-table, then pTab points to the
1707aee18ef8Sdanielk1977 ** corresponding table definition.
17086ab3a2ecSdanielk1977 **
17096ab3a2ecSdanielk1977 ** ALLOCATION NOTES:
17106ab3a2ecSdanielk1977 **
171112ffee8cSdrh ** Expr objects can use a lot of memory space in database schema.  To
171212ffee8cSdrh ** help reduce memory requirements, sometimes an Expr object will be
171312ffee8cSdrh ** truncated.  And to reduce the number of memory allocations, sometimes
171412ffee8cSdrh ** two or more Expr objects will be stored in a single memory allocation,
171533e619fcSdrh ** together with Expr.zToken strings.
17166ab3a2ecSdanielk1977 **
1717b7916a78Sdrh ** If the EP_Reduced and EP_TokenOnly flags are set when
171812ffee8cSdrh ** an Expr object is truncated.  When EP_Reduced is set, then all
171912ffee8cSdrh ** the child Expr objects in the Expr.pLeft and Expr.pRight subtrees
172012ffee8cSdrh ** are contained within the same memory allocation.  Note, however, that
172112ffee8cSdrh ** the subtrees in Expr.x.pList or Expr.x.pSelect are always separately
172212ffee8cSdrh ** allocated, regardless of whether or not EP_Reduced is set.
172375897234Sdrh */
172475897234Sdrh struct Expr {
17251cc093c2Sdrh   u8 op;                 /* Operation performed by this node */
1726a9fd84b0Sdrh   char affinity;         /* The affinity of the column or 0 if not a column */
1727c5cd1249Sdrh   u32 flags;             /* Various flags.  EP_* See below */
172833e619fcSdrh   union {
1729b7916a78Sdrh     char *zToken;          /* Token value. Zero terminated and dequoted */
1730d50ffc41Sdrh     int iValue;            /* Non-negative integer value if EP_IntValue */
173133e619fcSdrh   } u;
17326ab3a2ecSdanielk1977 
17336ab3a2ecSdanielk1977   /* If the EP_TokenOnly flag is set in the Expr.flags mask, then no
17346ab3a2ecSdanielk1977   ** space is allocated for the fields below this point. An attempt to
17356ab3a2ecSdanielk1977   ** access them will result in a segfault or malfunction.
17366ab3a2ecSdanielk1977   *********************************************************************/
17376ab3a2ecSdanielk1977 
17386ab3a2ecSdanielk1977   Expr *pLeft;           /* Left subnode */
17396ab3a2ecSdanielk1977   Expr *pRight;          /* Right subnode */
17406ab3a2ecSdanielk1977   union {
1741c5cd1249Sdrh     ExprList *pList;     /* op = IN, EXISTS, SELECT, CASE, FUNCTION, BETWEEN */
1742c5cd1249Sdrh     Select *pSelect;     /* EP_xIsSelect and op = IN, EXISTS, SELECT */
17436ab3a2ecSdanielk1977   } x;
17446ab3a2ecSdanielk1977 
17456ab3a2ecSdanielk1977   /* If the EP_Reduced flag is set in the Expr.flags mask, then no
17466ab3a2ecSdanielk1977   ** space is allocated for the fields below this point. An attempt to
17476ab3a2ecSdanielk1977   ** access them will result in a segfault or malfunction.
17486ab3a2ecSdanielk1977   *********************************************************************/
17496ab3a2ecSdanielk1977 
17506ec65491Sdrh #if SQLITE_MAX_EXPR_DEPTH>0
17516ec65491Sdrh   int nHeight;           /* Height of the tree headed by this node */
17526ec65491Sdrh #endif
1753b7916a78Sdrh   int iTable;            /* TK_COLUMN: cursor number of table holding column
17542832ad42Sdan                          ** TK_REGISTER: register number
1755cca9f3d2Sdrh                          ** TK_TRIGGER: 1 -> new, 0 -> old
1756a4c3c87eSdrh                          ** EP_Unlikely:  1000 times likelihood */
17578677d308Sdrh   ynVar iColumn;         /* TK_COLUMN: column index.  -1 for rowid.
1758937d0deaSdan                          ** TK_VARIABLE: variable number (always >= 1). */
1759b7916a78Sdrh   i16 iAgg;              /* Which entry in pAggInfo->aCol[] or ->aFunc[] */
1760b7916a78Sdrh   i16 iRightJoinTable;   /* If EP_FromJoin, the right table of the join */
1761030796dfSdrh   u8 op2;                /* TK_REGISTER: original value of Expr.op
1762030796dfSdrh                          ** TK_COLUMN: the value of p5 for OP_Column
1763030796dfSdrh                          ** TK_AGG_FUNCTION: nesting depth */
176413449892Sdrh   AggInfo *pAggInfo;     /* Used by TK_AGG_COLUMN and TK_AGG_FUNCTION */
17657d10d5a6Sdrh   Table *pTab;           /* Table for TK_COLUMN expressions. */
176675897234Sdrh };
176775897234Sdrh 
176875897234Sdrh /*
17691f16230bSdrh ** The following are the meanings of bits in the Expr.flags field.
17701f16230bSdrh */
1771c5cd1249Sdrh #define EP_FromJoin  0x000001 /* Originated in ON or USING clause of a join */
1772c5cd1249Sdrh #define EP_Agg       0x000002 /* Contains one or more aggregate functions */
1773c5cd1249Sdrh #define EP_Resolved  0x000004 /* IDs have been resolved to COLUMNs */
1774c5cd1249Sdrh #define EP_Error     0x000008 /* Expression contains one or more errors */
1775c5cd1249Sdrh #define EP_Distinct  0x000010 /* Aggregate function with DISTINCT keyword */
1776c5cd1249Sdrh #define EP_VarSelect 0x000020 /* pSelect is correlated, not constant */
1777c5cd1249Sdrh #define EP_DblQuoted 0x000040 /* token.z was originally in "..." */
1778c5cd1249Sdrh #define EP_InfixFunc 0x000080 /* True for an infix function: LIKE, GLOB, etc */
1779c5cd1249Sdrh #define EP_Collate   0x000100 /* Tree contains a TK_COLLATE opeartor */
1780c5cd1249Sdrh #define EP_FixedDest 0x000200 /* Result needed in a specific register */
1781c5cd1249Sdrh #define EP_IntValue  0x000400 /* Integer value contained in u.iValue */
1782c5cd1249Sdrh #define EP_xIsSelect 0x000800 /* x.pSelect is valid (otherwise x.pList is) */
1783a4c3c87eSdrh #define EP_Skip      0x001000 /* COLLATE, AS, or UNLIKELY */
1784c5cd1249Sdrh #define EP_Reduced   0x002000 /* Expr struct EXPR_REDUCEDSIZE bytes only */
1785c5cd1249Sdrh #define EP_TokenOnly 0x004000 /* Expr struct EXPR_TOKENONLYSIZE bytes only */
1786c5cd1249Sdrh #define EP_Static    0x008000 /* Held in memory not obtained from malloc() */
1787c5cd1249Sdrh #define EP_MemToken  0x010000 /* Need to sqlite3DbFree() Expr.zToken */
1788ebb6a65dSdrh #define EP_NoReduce  0x020000 /* Cannot EXPRDUP_REDUCE this Expr */
1789a4c3c87eSdrh #define EP_Unlikely  0x040000 /* unlikely() or likelihood() function */
179033e619fcSdrh 
179133e619fcSdrh /*
17921f16230bSdrh ** These macros can be used to test, set, or clear bits in the
17931f16230bSdrh ** Expr.flags field.
17941f16230bSdrh */
1795c5cd1249Sdrh #define ExprHasProperty(E,P)     (((E)->flags&(P))!=0)
1796c5cd1249Sdrh #define ExprHasAllProperty(E,P)  (((E)->flags&(P))==(P))
17971f16230bSdrh #define ExprSetProperty(E,P)     (E)->flags|=(P)
17981f16230bSdrh #define ExprClearProperty(E,P)   (E)->flags&=~(P)
17991f16230bSdrh 
1800ebb6a65dSdrh /* The ExprSetVVAProperty() macro is used for Verification, Validation,
1801ebb6a65dSdrh ** and Accreditation only.  It works like ExprSetProperty() during VVA
1802ebb6a65dSdrh ** processes but is a no-op for delivery.
1803ebb6a65dSdrh */
1804ebb6a65dSdrh #ifdef SQLITE_DEBUG
1805ebb6a65dSdrh # define ExprSetVVAProperty(E,P)  (E)->flags|=(P)
1806ebb6a65dSdrh #else
1807ebb6a65dSdrh # define ExprSetVVAProperty(E,P)
1808ebb6a65dSdrh #endif
1809ebb6a65dSdrh 
18101f16230bSdrh /*
18116ab3a2ecSdanielk1977 ** Macros to determine the number of bytes required by a normal Expr
18126ab3a2ecSdanielk1977 ** struct, an Expr struct with the EP_Reduced flag set in Expr.flags
18136ab3a2ecSdanielk1977 ** and an Expr struct with the EP_TokenOnly flag set.
18146ab3a2ecSdanielk1977 */
181512ffee8cSdrh #define EXPR_FULLSIZE           sizeof(Expr)           /* Full size */
181612ffee8cSdrh #define EXPR_REDUCEDSIZE        offsetof(Expr,iTable)  /* Common features */
1817b7916a78Sdrh #define EXPR_TOKENONLYSIZE      offsetof(Expr,pLeft)   /* Fewer features */
18186ab3a2ecSdanielk1977 
18196ab3a2ecSdanielk1977 /*
18206ab3a2ecSdanielk1977 ** Flags passed to the sqlite3ExprDup() function. See the header comment
18216ab3a2ecSdanielk1977 ** above sqlite3ExprDup() for details.
18226ab3a2ecSdanielk1977 */
182312ffee8cSdrh #define EXPRDUP_REDUCE         0x0001  /* Used reduced-size Expr nodes */
18246ab3a2ecSdanielk1977 
18256ab3a2ecSdanielk1977 /*
182675897234Sdrh ** A list of expressions.  Each expression may optionally have a
182775897234Sdrh ** name.  An expr/name combination can be used in several ways, such
182875897234Sdrh ** as the list of "expr AS ID" fields following a "SELECT" or in the
182975897234Sdrh ** list of "ID = expr" items in an UPDATE.  A list of expressions can
1830ad3cab52Sdrh ** also be used as the argument to a function, in which case the a.zName
183175897234Sdrh ** field is not used.
18320dde4739Sdrh **
18330dde4739Sdrh ** By default the Expr.zSpan field holds a human-readable description of
18340dde4739Sdrh ** the expression that is used in the generation of error messages and
18350dde4739Sdrh ** column labels.  In this case, Expr.zSpan is typically the text of a
18360dde4739Sdrh ** column expression as it exists in a SELECT statement.  However, if
18370dde4739Sdrh ** the bSpanIsTab flag is set, then zSpan is overloaded to mean the name
18383e3f1a5bSdrh ** of the result column in the form: DATABASE.TABLE.COLUMN.  This later
18393e3f1a5bSdrh ** form is used for name resolution with nested FROM clauses.
184075897234Sdrh */
184175897234Sdrh struct ExprList {
184275897234Sdrh   int nExpr;             /* Number of expressions on the list */
18439d2985c7Sdrh   int iECursor;          /* VDBE Cursor associated with this ExprList */
1844d872bb18Sdrh   struct ExprList_item { /* For each expression in the list */
184575897234Sdrh     Expr *pExpr;            /* The list of expressions */
184675897234Sdrh     char *zName;            /* Token associated with this expression */
1847b7916a78Sdrh     char *zSpan;            /* Original text of the expression */
18488e2ca029Sdrh     u8 sortOrder;           /* 1 for DESC or 0 for ASC */
18490dde4739Sdrh     unsigned done :1;       /* A flag to indicate when processing is finished */
18503e3f1a5bSdrh     unsigned bSpanIsTab :1; /* zSpan holds DB.TABLE.COLUMN */
18514b3ac73cSdrh     u16 iOrderByCol;        /* For ORDER BY, column number in result set */
18528b213899Sdrh     u16 iAlias;             /* Index into Parse.aAlias[] for zName */
1853d872bb18Sdrh   } *a;                  /* Alloc a power of two greater or equal to nExpr */
185475897234Sdrh };
185575897234Sdrh 
185675897234Sdrh /*
1857b7916a78Sdrh ** An instance of this structure is used by the parser to record both
1858b7916a78Sdrh ** the parse tree for an expression and the span of input text for an
1859b7916a78Sdrh ** expression.
1860b7916a78Sdrh */
1861b7916a78Sdrh struct ExprSpan {
1862b7916a78Sdrh   Expr *pExpr;          /* The expression parse tree */
1863b7916a78Sdrh   const char *zStart;   /* First character of input text */
1864b7916a78Sdrh   const char *zEnd;     /* One character past the end of input text */
1865b7916a78Sdrh };
1866b7916a78Sdrh 
1867b7916a78Sdrh /*
1868ad3cab52Sdrh ** An instance of this structure can hold a simple list of identifiers,
1869ad3cab52Sdrh ** such as the list "a,b,c" in the following statements:
1870ad3cab52Sdrh **
1871ad3cab52Sdrh **      INSERT INTO t(a,b,c) VALUES ...;
1872ad3cab52Sdrh **      CREATE INDEX idx ON t(a,b,c);
1873ad3cab52Sdrh **      CREATE TRIGGER trig BEFORE UPDATE ON t(a,b,c) ...;
1874ad3cab52Sdrh **
1875ad3cab52Sdrh ** The IdList.a.idx field is used when the IdList represents the list of
1876ad3cab52Sdrh ** column names after a table name in an INSERT statement.  In the statement
1877ad3cab52Sdrh **
1878ad3cab52Sdrh **     INSERT INTO t(a,b,c) ...
1879ad3cab52Sdrh **
1880ad3cab52Sdrh ** If "a" is the k-th column of table "t", then IdList.a[0].idx==k.
188175897234Sdrh */
188275897234Sdrh struct IdList {
18836d4abfbeSdrh   struct IdList_item {
1884ad3cab52Sdrh     char *zName;      /* Name of the identifier */
1885967e8b73Sdrh     int idx;          /* Index in some Table.aCol[] of a column named zName */
1886ad3cab52Sdrh   } *a;
188713449892Sdrh   int nId;         /* Number of identifiers on the list */
1888ad3cab52Sdrh };
1889ad3cab52Sdrh 
1890ad3cab52Sdrh /*
189151669863Sdrh ** The bitmask datatype defined below is used for various optimizations.
1892ca83ac51Sdrh **
1893ca83ac51Sdrh ** Changing this from a 64-bit to a 32-bit type limits the number of
1894ca83ac51Sdrh ** tables in a join to 32 instead of 64.  But it also reduces the size
1895ca83ac51Sdrh ** of the library by 738 bytes on ix86.
189651669863Sdrh */
1897ca83ac51Sdrh typedef u64 Bitmask;
189851669863Sdrh 
189951669863Sdrh /*
190000e13613Sdanielk1977 ** The number of bits in a Bitmask.  "BMS" means "BitMask Size".
190100e13613Sdanielk1977 */
190200e13613Sdanielk1977 #define BMS  ((int)(sizeof(Bitmask)*8))
190300e13613Sdanielk1977 
190400e13613Sdanielk1977 /*
19057699d1c4Sdrh ** A bit in a Bitmask
19067699d1c4Sdrh */
19077699d1c4Sdrh #define MASKBIT(n)   (((Bitmask)1)<<(n))
19087699d1c4Sdrh 
19097699d1c4Sdrh /*
1910ad3cab52Sdrh ** The following structure describes the FROM clause of a SELECT statement.
1911ad3cab52Sdrh ** Each table or subquery in the FROM clause is a separate element of
1912ad3cab52Sdrh ** the SrcList.a[] array.
1913d24cc427Sdrh **
1914d24cc427Sdrh ** With the addition of multiple database support, the following structure
1915d24cc427Sdrh ** can also be used to describe a particular table such as the table that
1916d24cc427Sdrh ** is modified by an INSERT, DELETE, or UPDATE statement.  In standard SQL,
1917d24cc427Sdrh ** such a table must be a simple name: ID.  But in SQLite, the table can
1918d24cc427Sdrh ** now be identified by a database name, a dot, then the table name: ID.ID.
1919c49de5d9Sdrh **
1920c49de5d9Sdrh ** The jointype starts out showing the join type between the current table
1921c49de5d9Sdrh ** and the next table on the list.  The parser builds the list this way.
1922c49de5d9Sdrh ** But sqlite3SrcListShiftJoinType() later shifts the jointypes so that each
1923c49de5d9Sdrh ** jointype expresses the join between the table and the previous table.
19242a6a7eebSdrh **
19252a6a7eebSdrh ** In the colUsed field, the high-order bit (bit 63) is set if the table
19262a6a7eebSdrh ** contains more than 63 columns and the 64-th or later column is used.
1927ad3cab52Sdrh */
1928ad3cab52Sdrh struct SrcList {
192923f98daaSdrh   u8 nSrc;        /* Number of tables or subqueries in the FROM clause */
193023f98daaSdrh   u8 nAlloc;      /* Number of entries allocated in a[] below */
1931ad3cab52Sdrh   struct SrcList_item {
193241fb5cd1Sdan     Schema *pSchema;  /* Schema to which this item is fixed */
1933113088ecSdrh     char *zDatabase;  /* Name of database holding this table */
1934ad3cab52Sdrh     char *zName;      /* Name of the table */
1935ad3cab52Sdrh     char *zAlias;     /* The "B" part of a "A AS B" phrase.  zName is the "A" */
1936daffd0e5Sdrh     Table *pTab;      /* An SQL table corresponding to zName */
1937daffd0e5Sdrh     Select *pSelect;  /* A SELECT statement used in place of a table name */
19385b6a9ed4Sdrh     int addrFillSub;  /* Address of subroutine to manifest a subquery */
19395b6a9ed4Sdrh     int regReturn;    /* Register holding return address of addrFillSub */
1940c49de5d9Sdrh     u8 jointype;      /* Type of join between this able and the previous */
194121172c4cSdrh     unsigned notIndexed :1;    /* True if there is a NOT INDEXED clause */
194221172c4cSdrh     unsigned isCorrelated :1;  /* True if sub-query is correlated */
194321172c4cSdrh     unsigned viaCoroutine :1;  /* Implemented as a co-routine */
1944ce7e189dSdan #ifndef SQLITE_OMIT_EXPLAIN
1945ce7e189dSdan     u8 iSelectId;     /* If pSelect!=0, the id of the sub-select in EQP */
1946ce7e189dSdan #endif
1947e68fbe79Sdrh     int iCursor;      /* The VDBE cursor number used to access this table */
1948ad3cab52Sdrh     Expr *pOn;        /* The ON clause of a join */
1949ad3cab52Sdrh     IdList *pUsing;   /* The USING clause of a join */
1950cd38d520Sdanielk1977     Bitmask colUsed;  /* Bit N (1<<N) set if column N of pTab is used */
195185574e31Sdanielk1977     char *zIndex;     /* Identifier from "INDEXED BY <zIndex>" clause */
195285574e31Sdanielk1977     Index *pIndex;    /* Index structure corresponding to zIndex, if any */
1953113088ecSdrh   } a[1];             /* One entry for each identifier on the list */
195475897234Sdrh };
195575897234Sdrh 
195675897234Sdrh /*
195701f3f253Sdrh ** Permitted values of the SrcList.a.jointype field
195801f3f253Sdrh */
195901f3f253Sdrh #define JT_INNER     0x0001    /* Any kind of inner or cross join */
19603dec223cSdrh #define JT_CROSS     0x0002    /* Explicit use of the CROSS keyword */
19613dec223cSdrh #define JT_NATURAL   0x0004    /* True for a "natural" join */
19623dec223cSdrh #define JT_LEFT      0x0008    /* Left outer join */
19633dec223cSdrh #define JT_RIGHT     0x0010    /* Right outer join */
19643dec223cSdrh #define JT_OUTER     0x0020    /* The "OUTER" keyword is present */
19653dec223cSdrh #define JT_ERROR     0x0040    /* unknown or unsupported join type */
196601f3f253Sdrh 
1967111a6a7dSdrh 
1968111a6a7dSdrh /*
1969336a5300Sdrh ** Flags appropriate for the wctrlFlags parameter of sqlite3WhereBegin()
1970336a5300Sdrh ** and the WhereInfo.wctrlFlags member.
197108c88eb0Sdrh */
19726df2acd2Sdrh #define WHERE_ORDERBY_NORMAL   0x0000 /* No-op */
19736df2acd2Sdrh #define WHERE_ORDERBY_MIN      0x0001 /* ORDER BY processing for min() func */
19746df2acd2Sdrh #define WHERE_ORDERBY_MAX      0x0002 /* ORDER BY processing for max() func */
19756df2acd2Sdrh #define WHERE_ONEPASS_DESIRED  0x0004 /* Want to do one-pass UPDATE/DELETE */
1976336a5300Sdrh #define WHERE_DUPLICATES_OK    0x0008 /* Ok to return a row more than once */
19779ef61f4fSdrh #define WHERE_OMIT_OPEN_CLOSE  0x0010 /* Table cursors are already open */
19789ef61f4fSdrh #define WHERE_FORCE_TABLE      0x0020 /* Do not use an index-only search */
19799ef61f4fSdrh #define WHERE_ONETABLE_ONLY    0x0040 /* Only code the 1st table in pTabList */
19809ef61f4fSdrh #define WHERE_AND_ONLY         0x0080 /* Don't use indices for OR terms */
1981319f677dSdrh #define WHERE_GROUPBY          0x0100 /* pOrderBy is really a GROUP BY */
19824f402f26Sdrh #define WHERE_DISTINCTBY       0x0200 /* pOrderby is really a DISTINCT clause */
19836457a353Sdrh #define WHERE_WANT_DISTINCT    0x0400 /* All output needs to be distinct */
1984a9d1ccb9Sdanielk1977 
19854f402f26Sdrh /* Allowed return values from sqlite3WhereIsDistinct()
19864f402f26Sdrh */
1987e8e4af76Sdrh #define WHERE_DISTINCT_NOOP      0  /* DISTINCT keyword not used */
1988ae651d61Sdrh #define WHERE_DISTINCT_UNIQUE    1  /* No duplicates */
1989ae651d61Sdrh #define WHERE_DISTINCT_ORDERED   2  /* All duplicates are adjacent */
1990e8e4af76Sdrh #define WHERE_DISTINCT_UNORDERED 3  /* Duplicates are scattered */
199138cc40c2Sdan 
199275897234Sdrh /*
1993b3bce662Sdanielk1977 ** A NameContext defines a context in which to resolve table and column
1994b3bce662Sdanielk1977 ** names.  The context consists of a list of tables (the pSrcList) field and
1995b3bce662Sdanielk1977 ** a list of named expression (pEList).  The named expression list may
1996b3bce662Sdanielk1977 ** be NULL.  The pSrc corresponds to the FROM clause of a SELECT or
1997b3bce662Sdanielk1977 ** to the table being operated on by INSERT, UPDATE, or DELETE.  The
1998b3bce662Sdanielk1977 ** pEList corresponds to the result set of a SELECT and is NULL for
1999b3bce662Sdanielk1977 ** other statements.
2000b3bce662Sdanielk1977 **
2001b3bce662Sdanielk1977 ** NameContexts can be nested.  When resolving names, the inner-most
2002b3bce662Sdanielk1977 ** context is searched first.  If no match is found, the next outer
2003b3bce662Sdanielk1977 ** context is checked.  If there is still no match, the next context
2004b3bce662Sdanielk1977 ** is checked.  This process continues until either a match is found
2005b3bce662Sdanielk1977 ** or all contexts are check.  When a match is found, the nRef member of
2006b3bce662Sdanielk1977 ** the context containing the match is incremented.
2007b3bce662Sdanielk1977 **
2008b3bce662Sdanielk1977 ** Each subquery gets a new NameContext.  The pNext field points to the
2009b3bce662Sdanielk1977 ** NameContext in the parent query.  Thus the process of scanning the
2010b3bce662Sdanielk1977 ** NameContext list corresponds to searching through successively outer
2011b3bce662Sdanielk1977 ** subqueries looking for a match.
2012b3bce662Sdanielk1977 */
2013b3bce662Sdanielk1977 struct NameContext {
2014b3bce662Sdanielk1977   Parse *pParse;       /* The parser */
2015b3bce662Sdanielk1977   SrcList *pSrcList;   /* One or more tables used to resolve names */
201626080d92Sdrh   ExprList *pEList;    /* Optional list of result-set columns */
201713449892Sdrh   AggInfo *pAggInfo;   /* Information about aggregates at this level */
2018b3bce662Sdanielk1977   NameContext *pNext;  /* Next outer name context.  NULL for outermost */
2019a51009b2Sdrh   int nRef;            /* Number of names resolved by this context */
2020a51009b2Sdrh   int nErr;            /* Number of errors encountered while resolving names */
2021a51009b2Sdrh   u8 ncFlags;          /* Zero or more NC_* flags defined below */
2022b3bce662Sdanielk1977 };
2023b3bce662Sdanielk1977 
2024b3bce662Sdanielk1977 /*
2025a51009b2Sdrh ** Allowed values for the NameContext, ncFlags field.
2026a51009b2Sdrh */
2027a51009b2Sdrh #define NC_AllowAgg  0x01    /* Aggregate functions are allowed here */
2028a51009b2Sdrh #define NC_HasAgg    0x02    /* One or more aggregate functions seen */
2029a51009b2Sdrh #define NC_IsCheck   0x04    /* True if resolving names in a CHECK constraint */
20303a8c4be7Sdrh #define NC_InAggFunc 0x08    /* True if analyzing arguments to an agg func */
2031e35463b3Sdrh #define NC_PartIdx   0x10    /* True if resolving a partial index WHERE */
2032a51009b2Sdrh 
2033a51009b2Sdrh /*
20349bb61fe7Sdrh ** An instance of the following structure contains all information
20359bb61fe7Sdrh ** needed to generate code for a single SELECT statement.
2036a76b5dfcSdrh **
2037d11d382cSdrh ** nLimit is set to -1 if there is no LIMIT clause.  nOffset is set to 0.
2038d11d382cSdrh ** If there is a LIMIT clause, the parser sets nLimit to the value of the
2039d11d382cSdrh ** limit and nOffset to the value of the offset (or 0 if there is not
2040d11d382cSdrh ** offset).  But later on, nLimit and nOffset become the memory locations
2041d11d382cSdrh ** in the VDBE that record the limit and offset counters.
20420342b1f5Sdrh **
2043b9bb7c18Sdrh ** addrOpenEphm[] entries contain the address of OP_OpenEphemeral opcodes.
20440342b1f5Sdrh ** These addresses must be stored so that we can go back and fill in
204566a5167bSdrh ** the P4_KEYINFO and P2 parameters later.  Neither the KeyInfo nor
20460342b1f5Sdrh ** the number of columns in P2 can be computed at the same time
2047b9bb7c18Sdrh ** as the OP_OpenEphm instruction is coded because not
20480342b1f5Sdrh ** enough information about the compound query is known at that point.
2049b9bb7c18Sdrh ** The KeyInfo for addrOpenTran[0] and [1] contains collating sequences
20502c79733fSdrh ** for the result set.  The KeyInfo for addrOpenEphm[2] contains collating
20510342b1f5Sdrh ** sequences for the ORDER BY clause.
20529bb61fe7Sdrh */
20539bb61fe7Sdrh struct Select {
20549bb61fe7Sdrh   ExprList *pEList;      /* The fields of the result */
20557b58daeaSdrh   u8 op;                 /* One of: TK_UNION TK_ALL TK_INTERSECT TK_EXCEPT */
20567d10d5a6Sdrh   u16 selFlags;          /* Various SF_* values */
2057a451017dSdrh   int iLimit, iOffset;   /* Memory registers holding LIMIT & OFFSET counters */
2058a451017dSdrh   int addrOpenEphm[3];   /* OP_OpenEphem opcodes related to this select */
2059c63367efSdrh   u64 nSelectRow;        /* Estimated number of result rows */
2060ad3cab52Sdrh   SrcList *pSrc;         /* The FROM clause */
20619bb61fe7Sdrh   Expr *pWhere;          /* The WHERE clause */
20629bb61fe7Sdrh   ExprList *pGroupBy;    /* The GROUP BY clause */
20639bb61fe7Sdrh   Expr *pHaving;         /* The HAVING clause */
20649bb61fe7Sdrh   ExprList *pOrderBy;    /* The ORDER BY clause */
2065967e8b73Sdrh   Select *pPrior;        /* Prior select in a compound select statement */
20661e281291Sdrh   Select *pNext;         /* Next select to the left in a compound */
20670342b1f5Sdrh   Select *pRightmost;    /* Right-most select in a compound select statement */
2068a2dc3b1aSdanielk1977   Expr *pLimit;          /* LIMIT expression. NULL means not used. */
2069a2dc3b1aSdanielk1977   Expr *pOffset;         /* OFFSET expression. NULL means not used. */
20709bb61fe7Sdrh };
20719bb61fe7Sdrh 
20729bb61fe7Sdrh /*
20737d10d5a6Sdrh ** Allowed values for Select.selFlags.  The "SF" prefix stands for
20747d10d5a6Sdrh ** "Select Flag".
20757d10d5a6Sdrh */
207621172c4cSdrh #define SF_Distinct        0x0001  /* Output should be DISTINCT */
207721172c4cSdrh #define SF_Resolved        0x0002  /* Identifiers have been resolved */
207821172c4cSdrh #define SF_Aggregate       0x0004  /* Contains aggregate functions */
207921172c4cSdrh #define SF_UsesEphemeral   0x0008  /* Uses the OpenEphemeral opcode */
208021172c4cSdrh #define SF_Expanded        0x0010  /* sqlite3SelectExpand() called on this */
208121172c4cSdrh #define SF_HasTypeInfo     0x0020  /* FROM subqueries have Table metadata */
208221172c4cSdrh #define SF_UseSorter       0x0040  /* Sort using a sorter */
208321172c4cSdrh #define SF_Values          0x0080  /* Synthesized from VALUES clause */
208421172c4cSdrh #define SF_Materialize     0x0100  /* Force materialization of views */
2085832ee3d4Sdrh #define SF_NestedFrom      0x0200  /* Part of a parenthesized FROM clause */
2086d58d3278Sdrh #define SF_MaybeConvert    0x0400  /* Need convertCompoundSelectToSubquery() */
20877d10d5a6Sdrh 
20887d10d5a6Sdrh 
20897d10d5a6Sdrh /*
20907d10d5a6Sdrh ** The results of a select can be distributed in several ways.  The
20917d10d5a6Sdrh ** "SRT" prefix means "SELECT Result Type".
2092fef5208cSdrh */
209313449892Sdrh #define SRT_Union        1  /* Store result as keys in an index */
209413449892Sdrh #define SRT_Except       2  /* Remove result from a UNION index */
20959ed1dfa8Sdanielk1977 #define SRT_Exists       3  /* Store 1 if the result is not empty */
20969ed1dfa8Sdanielk1977 #define SRT_Discard      4  /* Do not save the results anywhere */
2097fef5208cSdrh 
209813449892Sdrh /* The ORDER BY clause is ignored for all of the above */
20996c8c8ce0Sdanielk1977 #define IgnorableOrderby(X) ((X->eDest)<=SRT_Discard)
210013449892Sdrh 
21017d10d5a6Sdrh #define SRT_Output       5  /* Output each row of result */
21029ed1dfa8Sdanielk1977 #define SRT_Mem          6  /* Store result in a memory cell */
21030cdc022eSdanielk1977 #define SRT_Set          7  /* Store results as keys in an index */
21049ed1dfa8Sdanielk1977 #define SRT_Table        8  /* Store result as data with an automatic rowid */
21059ed1dfa8Sdanielk1977 #define SRT_EphemTab     9  /* Create transient tab and store like SRT_Table */
2106e00ee6ebSdrh #define SRT_Coroutine   10  /* Generate a single row of result */
21072282792aSdrh 
21082282792aSdrh /*
2109634d81deSdrh ** An instance of this object describes where to put of the results of
2110634d81deSdrh ** a SELECT statement.
21116c8c8ce0Sdanielk1977 */
21126c8c8ce0Sdanielk1977 struct SelectDest {
2113634d81deSdrh   u8 eDest;         /* How to dispose of the results.  On of SRT_* above. */
2114634d81deSdrh   char affSdst;     /* Affinity used when eDest==SRT_Set */
21152b596da8Sdrh   int iSDParm;      /* A parameter used by the eDest disposal method */
21162b596da8Sdrh   int iSdst;        /* Base register where results are written */
21172b596da8Sdrh   int nSdst;        /* Number of registers allocated */
21186c8c8ce0Sdanielk1977 };
21196c8c8ce0Sdanielk1977 
21206c8c8ce0Sdanielk1977 /*
21210b9f50d8Sdrh ** During code generation of statements that do inserts into AUTOINCREMENT
21220b9f50d8Sdrh ** tables, the following information is attached to the Table.u.autoInc.p
21230b9f50d8Sdrh ** pointer of each autoincrement table to record some side information that
21240b9f50d8Sdrh ** the code generator needs.  We have to keep per-table autoincrement
21250b9f50d8Sdrh ** information in case inserts are down within triggers.  Triggers do not
21260b9f50d8Sdrh ** normally coordinate their activities, but we do need to coordinate the
21270b9f50d8Sdrh ** loading and saving of autoincrement information.
21280b9f50d8Sdrh */
21290b9f50d8Sdrh struct AutoincInfo {
21300b9f50d8Sdrh   AutoincInfo *pNext;   /* Next info block in a list of them all */
21310b9f50d8Sdrh   Table *pTab;          /* Table this info block refers to */
21320b9f50d8Sdrh   int iDb;              /* Index in sqlite3.aDb[] of database holding pTab */
21330b9f50d8Sdrh   int regCtr;           /* Memory register holding the rowid counter */
21340b9f50d8Sdrh };
21350b9f50d8Sdrh 
21360b9f50d8Sdrh /*
2137ceea3321Sdrh ** Size of the column cache
2138ceea3321Sdrh */
2139ceea3321Sdrh #ifndef SQLITE_N_COLCACHE
2140ceea3321Sdrh # define SQLITE_N_COLCACHE 10
2141ceea3321Sdrh #endif
2142ceea3321Sdrh 
21432832ad42Sdan /*
21442832ad42Sdan ** At least one instance of the following structure is created for each
21452832ad42Sdan ** trigger that may be fired while parsing an INSERT, UPDATE or DELETE
21462832ad42Sdan ** statement. All such objects are stored in the linked list headed at
21472832ad42Sdan ** Parse.pTriggerPrg and deleted once statement compilation has been
21482832ad42Sdan ** completed.
21492832ad42Sdan **
21502832ad42Sdan ** A Vdbe sub-program that implements the body and WHEN clause of trigger
21512832ad42Sdan ** TriggerPrg.pTrigger, assuming a default ON CONFLICT clause of
21522832ad42Sdan ** TriggerPrg.orconf, is stored in the TriggerPrg.pProgram variable.
21532832ad42Sdan ** The Parse.pTriggerPrg list never contains two entries with the same
21542832ad42Sdan ** values for both pTrigger and orconf.
215565a7cd16Sdan **
2156bb5f168fSdan ** The TriggerPrg.aColmask[0] variable is set to a mask of old.* columns
215765a7cd16Sdan ** accessed (or set to 0 for triggers fired as a result of INSERT
2158bb5f168fSdan ** statements). Similarly, the TriggerPrg.aColmask[1] variable is set to
2159bb5f168fSdan ** a mask of new.* columns used by the program.
21602832ad42Sdan */
21612832ad42Sdan struct TriggerPrg {
21622832ad42Sdan   Trigger *pTrigger;      /* Trigger this program was coded from */
21632832ad42Sdan   TriggerPrg *pNext;      /* Next entry in Parse.pTriggerPrg list */
2164a451017dSdrh   SubProgram *pProgram;   /* Program implementing pTrigger/orconf */
2165a451017dSdrh   int orconf;             /* Default ON CONFLICT policy */
2166a451017dSdrh   u32 aColmask[2];        /* Masks of old.*, new.* columns accessed */
2167165921a7Sdan };
2168165921a7Sdan 
216964123585Sdrh /*
217064123585Sdrh ** The yDbMask datatype for the bitmask of all attached databases.
217164123585Sdrh */
217201c7dc88Sdrh #if SQLITE_MAX_ATTACHED>30
217364123585Sdrh   typedef sqlite3_uint64 yDbMask;
217401c7dc88Sdrh #else
217564123585Sdrh   typedef unsigned int yDbMask;
217601c7dc88Sdrh #endif
217701c7dc88Sdrh 
2178ceea3321Sdrh /*
2179f57b3399Sdrh ** An SQL parser context.  A copy of this structure is passed through
2180f57b3399Sdrh ** the parser and down into all the parser action routine in order to
2181f57b3399Sdrh ** carry around information that is global to the entire parse.
2182f1974846Sdrh **
2183f1974846Sdrh ** The structure is divided into two parts.  When the parser and code
2184f1974846Sdrh ** generate call themselves recursively, the first part of the structure
2185f1974846Sdrh ** is constant but the second part is reset at the beginning and end of
2186f1974846Sdrh ** each recursion.
2187c00da105Sdanielk1977 **
2188c00da105Sdanielk1977 ** The nTableLock and aTableLock variables are only used if the shared-cache
2189c00da105Sdanielk1977 ** feature is enabled (if sqlite3Tsd()->useSharedData is true). They are
2190c00da105Sdanielk1977 ** used to store the set of table-locks required by the statement being
2191c00da105Sdanielk1977 ** compiled. Function sqlite3TableLock() is used to add entries to the
2192c00da105Sdanielk1977 ** list.
219375897234Sdrh */
219475897234Sdrh struct Parse {
21959bb575fdSdrh   sqlite3 *db;         /* The main database structure */
219675897234Sdrh   char *zErrMsg;       /* An error message */
219775897234Sdrh   Vdbe *pVdbe;         /* An engine for executing database bytecode */
2198a451017dSdrh   int rc;              /* Return code from execution */
2199836faa48Sdrh   u8 colNamesSet;      /* TRUE after OP_ColumnName has been issued to pVdbe */
2200a6ecd338Sdrh   u8 checkSchema;      /* Causes schema cookie check after an error */
2201205f48e6Sdrh   u8 nested;           /* Number of nested calls to the parser/code generator */
2202892d3179Sdrh   u8 nTempReg;         /* Number of temporary registers in aTempReg[] */
22032dcef11bSdrh   u8 nTempInUse;       /* Number of aTempReg[] currently checked out */
2204a451017dSdrh   u8 nColCache;        /* Number of entries in aColCache[] */
2205a451017dSdrh   u8 iColCache;        /* Next entry in aColCache[] to replace */
2206a451017dSdrh   u8 isMultiWrite;     /* True if statement may modify/insert multiple rows */
2207a451017dSdrh   u8 mayAbort;         /* True if statement may throw an ABORT exception */
2208d58d3278Sdrh   u8 hasCompound;      /* Need to invoke convertCompoundSelectToSubquery() */
2209892d3179Sdrh   int aTempReg[8];     /* Holding area for temporary registers */
2210892d3179Sdrh   int nRangeReg;       /* Size of the temporary register block */
2211892d3179Sdrh   int iRangeReg;       /* First register in temporary register block */
221275897234Sdrh   int nErr;            /* Number of errors seen */
2213832508b7Sdrh   int nTab;            /* Number of previously allocated VDBE cursors */
221419a775c2Sdrh   int nMem;            /* Number of memory cells used so far */
2215fef5208cSdrh   int nSet;            /* Number of sets used so far */
22161d8cb21fSdan   int nOnce;           /* Number of OP_Once instructions so far */
2217aa9b8963Sdrh   int ckBase;          /* Base register of data during check constraints */
2218b2b9d3d7Sdrh   int iPartIdxTab;     /* Table corresponding to a partial index */
2219ceea3321Sdrh   int iCacheLevel;     /* ColCache valid when aColCache[].iLevel<=iCacheLevel */
2220ceea3321Sdrh   int iCacheCnt;       /* Counter used to generate aColCache[].lru values */
22212f7794c1Sdrh   struct yColCache {
2222e55cbd72Sdrh     int iTable;           /* Table cursor number */
2223e55cbd72Sdrh     int iColumn;          /* Table column number */
2224ceea3321Sdrh     u8 tempReg;           /* iReg is a temp register that needs to be freed */
2225ceea3321Sdrh     int iLevel;           /* Nesting level */
2226ceea3321Sdrh     int iReg;             /* Reg with value of this column. 0 means none. */
2227ceea3321Sdrh     int lru;              /* Least recently used entry has the smallest value */
2228ceea3321Sdrh   } aColCache[SQLITE_N_COLCACHE];  /* One for each column cache entry */
222964123585Sdrh   yDbMask writeMask;   /* Start a write transaction on these databases */
223064123585Sdrh   yDbMask cookieMask;  /* Bitmask of schema verified databases */
2231fcd35c7bSdrh   int cookieGoto;      /* Address of OP_Goto to cookie verifier subroutine */
2232c797d4dcSdrh   int cookieValue[SQLITE_MAX_ATTACHED+2];  /* Values of cookies to verify */
2233a451017dSdrh   int regRowid;        /* Register holding rowid of CREATE TABLE entry */
2234a451017dSdrh   int regRoot;         /* Register holding root page number for new objects */
2235a451017dSdrh   int nMaxArg;         /* Max args passed to user function by sub-program */
22362938f924Sdrh   Token constraintName;/* Name of the constraint currently being parsed */
2237c00da105Sdanielk1977 #ifndef SQLITE_OMIT_SHARED_CACHE
2238c00da105Sdanielk1977   int nTableLock;        /* Number of locks in aTableLock */
2239c00da105Sdanielk1977   TableLock *aTableLock; /* Required table locks for shared-cache mode */
2240c00da105Sdanielk1977 #endif
22410b9f50d8Sdrh   AutoincInfo *pAinc;  /* Information about AUTOINCREMENT counters */
2242f1974846Sdrh 
2243165921a7Sdan   /* Information used while coding trigger programs. */
224465a7cd16Sdan   Parse *pToplevel;    /* Parse structure for main program (or NULL) */
2245165921a7Sdan   Table *pTriggerTab;  /* Table triggers are being coded for */
22464f402f26Sdrh   u32 nQueryLoop;      /* Est number of iterations of a query (10*log2(N)) */
224765a7cd16Sdan   u32 oldmask;         /* Mask of old.* columns referenced */
2248bb5f168fSdan   u32 newmask;         /* Mask of new.* columns referenced */
224965a7cd16Sdan   u8 eTriggerOp;       /* TK_UPDATE, TK_INSERT or TK_DELETE */
225065a7cd16Sdan   u8 eOrconf;          /* Default ON CONFLICT policy for trigger steps */
2251d66c8309Sdan   u8 disableTriggers;  /* True to disable triggers */
2252165921a7Sdan 
2253f1974846Sdrh   /* Above is constant between recursions.  Below is reset before and after
2254f1974846Sdrh   ** each recursion */
2255f1974846Sdrh 
2256f1974846Sdrh   int nVar;                 /* Number of '?' variables seen in the SQL so far */
2257124c0b49Sdrh   int nzVar;                /* Number of available slots in azVar[] */
2258a451017dSdrh   u8 explain;               /* True if the EXPLAIN flag is found on the query */
2259a451017dSdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
2260a451017dSdrh   u8 declareVtab;           /* True if inside sqlite3_declare_vtab() */
2261a451017dSdrh   int nVtabLock;            /* Number of virtual tables to lock */
2262a451017dSdrh #endif
2263a451017dSdrh   int nAlias;               /* Number of aliased result set columns */
2264a451017dSdrh   int nHeight;              /* Expression tree height of current sub-select */
2265a451017dSdrh #ifndef SQLITE_OMIT_EXPLAIN
2266a451017dSdrh   int iSelectId;            /* ID of current select for EXPLAIN output */
2267a451017dSdrh   int iNextSelectId;        /* Next available select ID for EXPLAIN output */
2268a451017dSdrh #endif
2269124c0b49Sdrh   char **azVar;             /* Pointers to names of parameters */
2270937d0deaSdan   Vdbe *pReprepare;         /* VM being reprepared (sqlite3Reprepare()) */
22718b213899Sdrh   int *aAlias;              /* Register used to hold aliased result */
2272f1974846Sdrh   const char *zTail;        /* All SQL text past the last semicolon parsed */
2273f1974846Sdrh   Table *pNewTable;         /* A table being constructed by CREATE TABLE */
2274f1974846Sdrh   Trigger *pNewTrigger;     /* Trigger under construct by a CREATE TRIGGER */
2275f1974846Sdrh   const char *zAuthContext; /* The 6th parameter to db->xAuth callbacks */
2276a451017dSdrh   Token sNameToken;         /* Token with unqualified schema object name */
2277a451017dSdrh   Token sLastToken;         /* The last token parsed */
2278b9bb7c18Sdrh #ifndef SQLITE_OMIT_VIRTUALTABLE
227933b3933cSdanielk1977   Token sArg;               /* Complete text of a module argument */
22804f3dd150Sdrh   Table **apVtabLock;       /* Pointer to virtual tables needing locking */
2281b9bb7c18Sdrh #endif
2282588a9a1aSdrh   Table *pZombieTab;        /* List of Table objects to delete after code gen */
22832832ad42Sdan   TriggerPrg *pTriggerPrg;  /* Linked list of coded triggers */
228475897234Sdrh };
228575897234Sdrh 
2286a451017dSdrh /*
2287a451017dSdrh ** Return true if currently inside an sqlite3_declare_vtab() call.
2288a451017dSdrh */
22897e6ebfb2Sdanielk1977 #ifdef SQLITE_OMIT_VIRTUALTABLE
22907e6ebfb2Sdanielk1977   #define IN_DECLARE_VTAB 0
22917e6ebfb2Sdanielk1977 #else
22927e6ebfb2Sdanielk1977   #define IN_DECLARE_VTAB (pParse->declareVtab)
22937e6ebfb2Sdanielk1977 #endif
22947e6ebfb2Sdanielk1977 
2295d99bc930Sdanielk1977 /*
229685e2096fSdrh ** An instance of the following structure can be declared on a stack and used
229785e2096fSdrh ** to save the Parse.zAuthContext value so that it can be restored later.
229885e2096fSdrh */
229985e2096fSdrh struct AuthContext {
230085e2096fSdrh   const char *zAuthContext;   /* Put saved Parse.zAuthContext here */
230185e2096fSdrh   Parse *pParse;              /* The Parse structure */
230285e2096fSdrh };
230385e2096fSdrh 
230485e2096fSdrh /*
2305a748fdccSdrh ** Bitfield flags for P5 value in various opcodes.
2306b0c374ffSrdc */
23073e9ca094Sdrh #define OPFLAG_NCHANGE       0x01    /* Set to update db->nChange */
23083e9ca094Sdrh #define OPFLAG_LASTROWID     0x02    /* Set to update db->lastRowid */
23093e9ca094Sdrh #define OPFLAG_ISUPDATE      0x04    /* This OP_Insert is an sql UPDATE */
23103e9ca094Sdrh #define OPFLAG_APPEND        0x08    /* This is likely to be an append */
23113e9ca094Sdrh #define OPFLAG_USESEEKRESULT 0x10    /* Try to avoid a seek in BtreeInsert() */
23123e9ca094Sdrh #define OPFLAG_CLEARCACHE    0x20    /* Clear pseudo-table cache in OP_Column */
2313a748fdccSdrh #define OPFLAG_LENGTHARG     0x40    /* OP_Column only used for length() */
2314a748fdccSdrh #define OPFLAG_TYPEOFARG     0x80    /* OP_Column only used for typeof() */
2315428c218cSdan #define OPFLAG_BULKCSR       0x01    /* OP_Open** used to open bulk cursor */
2316428c218cSdan #define OPFLAG_P2ISREG       0x02    /* P2 to OP_Open** is a register number */
2317953f7611Sdrh #define OPFLAG_PERMUTE       0x01    /* OP_Compare: use the permutation */
2318b0c374ffSrdc 
2319b0c374ffSrdc /*
2320d99bc930Sdanielk1977  * Each trigger present in the database schema is stored as an instance of
2321d99bc930Sdanielk1977  * struct Trigger.
2322d99bc930Sdanielk1977  *
2323d99bc930Sdanielk1977  * Pointers to instances of struct Trigger are stored in two ways.
23249bb575fdSdrh  * 1. In the "trigHash" hash table (part of the sqlite3* that represents the
2325d99bc930Sdanielk1977  *    database). This allows Trigger structures to be retrieved by name.
2326d99bc930Sdanielk1977  * 2. All triggers associated with a single table form a linked list, using the
2327ad3cab52Sdrh  *    pNext member of struct Trigger. A pointer to the first element of the
2328ad3cab52Sdrh  *    linked list is stored as the "pTrigger" member of the associated
2329ad3cab52Sdrh  *    struct Table.
2330d99bc930Sdanielk1977  *
2331ad3cab52Sdrh  * The "step_list" member points to the first element of a linked list
2332ad3cab52Sdrh  * containing the SQL statements specified as the trigger program.
2333d99bc930Sdanielk1977  */
2334d99bc930Sdanielk1977 struct Trigger {
2335165921a7Sdan   char *zName;            /* The name of the trigger                        */
2336d99bc930Sdanielk1977   char *table;            /* The table or view to which the trigger applies */
2337f0f258b1Sdrh   u8 op;                  /* One of TK_DELETE, TK_UPDATE, TK_INSERT         */
2338dca76841Sdrh   u8 tr_tm;               /* One of TRIGGER_BEFORE, TRIGGER_AFTER */
2339467bcf36Sshane   Expr *pWhen;            /* The WHEN clause of the expression (may be NULL) */
2340d99bc930Sdanielk1977   IdList *pColumns;       /* If this is an UPDATE OF <column-list> trigger,
2341d99bc930Sdanielk1977                              the <column-list> is stored here */
2342e501b89aSdanielk1977   Schema *pSchema;        /* Schema containing the trigger */
2343e501b89aSdanielk1977   Schema *pTabSchema;     /* Schema containing the table */
2344d99bc930Sdanielk1977   TriggerStep *step_list; /* Link list of trigger program steps             */
2345d99bc930Sdanielk1977   Trigger *pNext;         /* Next trigger associated with the table */
2346c3f9bad2Sdanielk1977 };
2347d99bc930Sdanielk1977 
2348d99bc930Sdanielk1977 /*
2349dca76841Sdrh ** A trigger is either a BEFORE or an AFTER trigger.  The following constants
2350dca76841Sdrh ** determine which.
2351dca76841Sdrh **
2352dca76841Sdrh ** If there are multiple triggers, you might of some BEFORE and some AFTER.
2353dca76841Sdrh ** In that cases, the constants below can be ORed together.
2354dca76841Sdrh */
2355dca76841Sdrh #define TRIGGER_BEFORE  1
2356dca76841Sdrh #define TRIGGER_AFTER   2
2357dca76841Sdrh 
2358dca76841Sdrh /*
2359d99bc930Sdanielk1977  * An instance of struct TriggerStep is used to store a single SQL statement
2360d99bc930Sdanielk1977  * that is a part of a trigger-program.
2361d99bc930Sdanielk1977  *
2362d99bc930Sdanielk1977  * Instances of struct TriggerStep are stored in a singly linked list (linked
2363d99bc930Sdanielk1977  * using the "pNext" member) referenced by the "step_list" member of the
2364d99bc930Sdanielk1977  * associated struct Trigger instance. The first element of the linked list is
2365d99bc930Sdanielk1977  * the first step of the trigger-program.
2366d99bc930Sdanielk1977  *
2367d99bc930Sdanielk1977  * The "op" member indicates whether this is a "DELETE", "INSERT", "UPDATE" or
2368d99bc930Sdanielk1977  * "SELECT" statement. The meanings of the other members is determined by the
2369d99bc930Sdanielk1977  * value of "op" as follows:
2370d99bc930Sdanielk1977  *
2371d99bc930Sdanielk1977  * (op == TK_INSERT)
2372d99bc930Sdanielk1977  * orconf    -> stores the ON CONFLICT algorithm
2373d99bc930Sdanielk1977  * pSelect   -> If this is an INSERT INTO ... SELECT ... statement, then
2374d99bc930Sdanielk1977  *              this stores a pointer to the SELECT statement. Otherwise NULL.
2375b7916a78Sdrh  * target    -> A token holding the quoted name of the table to insert into.
2376d99bc930Sdanielk1977  * pExprList -> If this is an INSERT INTO ... VALUES ... statement, then
2377d99bc930Sdanielk1977  *              this stores values to be inserted. Otherwise NULL.
2378d99bc930Sdanielk1977  * pIdList   -> If this is an INSERT INTO ... (<column-names>) VALUES ...
2379ad3cab52Sdrh  *              statement, then this stores the column-names to be
2380ad3cab52Sdrh  *              inserted into.
2381d99bc930Sdanielk1977  *
2382d99bc930Sdanielk1977  * (op == TK_DELETE)
2383b7916a78Sdrh  * target    -> A token holding the quoted name of the table to delete from.
2384d99bc930Sdanielk1977  * pWhere    -> The WHERE clause of the DELETE statement if one is specified.
2385d99bc930Sdanielk1977  *              Otherwise NULL.
2386d99bc930Sdanielk1977  *
2387d99bc930Sdanielk1977  * (op == TK_UPDATE)
2388b7916a78Sdrh  * target    -> A token holding the quoted name of the table to update rows of.
2389d99bc930Sdanielk1977  * pWhere    -> The WHERE clause of the UPDATE statement if one is specified.
2390d99bc930Sdanielk1977  *              Otherwise NULL.
2391d99bc930Sdanielk1977  * pExprList -> A list of the columns to update and the expressions to update
23924adee20fSdanielk1977  *              them to. See sqlite3Update() documentation of "pChanges"
2393ad3cab52Sdrh  *              argument.
2394d99bc930Sdanielk1977  *
2395d99bc930Sdanielk1977  */
2396c3f9bad2Sdanielk1977 struct TriggerStep {
2397b1819a0bSdrh   u8 op;               /* One of TK_DELETE, TK_UPDATE, TK_INSERT, TK_SELECT */
2398b1819a0bSdrh   u8 orconf;           /* OE_Rollback etc. */
2399a69d9168Sdrh   Trigger *pTrig;      /* The trigger that this step is a part of */
2400b1819a0bSdrh   Select *pSelect;     /* SELECT statment or RHS of INSERT INTO .. SELECT ... */
2401b1819a0bSdrh   Token target;        /* Target table for DELETE, UPDATE, INSERT */
2402b1819a0bSdrh   Expr *pWhere;        /* The WHERE clause for DELETE or UPDATE steps */
2403b1819a0bSdrh   ExprList *pExprList; /* SET clause for UPDATE.  VALUES clause for INSERT */
2404b1819a0bSdrh   IdList *pIdList;     /* Column names for INSERT */
2405c3f9bad2Sdanielk1977   TriggerStep *pNext;  /* Next in the link-list */
2406187e4c6aSdrh   TriggerStep *pLast;  /* Last element in link-list. Valid for 1st elem only */
2407c3f9bad2Sdanielk1977 };
2408c3f9bad2Sdanielk1977 
2409d99bc930Sdanielk1977 /*
2410f26e09c8Sdrh ** The following structure contains information used by the sqliteFix...
2411f26e09c8Sdrh ** routines as they walk the parse tree to make database references
2412f26e09c8Sdrh ** explicit.
2413f26e09c8Sdrh */
2414f26e09c8Sdrh typedef struct DbFixer DbFixer;
2415f26e09c8Sdrh struct DbFixer {
2416f26e09c8Sdrh   Parse *pParse;      /* The parsing context.  Error messages written here */
241741fb5cd1Sdan   Schema *pSchema;    /* Fix items to this schema */
241846539d7cSdan   int bVarOnly;       /* Check for variable references only */
2419f26e09c8Sdrh   const char *zDb;    /* Make sure all objects are contained in this database */
2420f26e09c8Sdrh   const char *zType;  /* Type of the container - used for error messages */
2421f26e09c8Sdrh   const Token *pName; /* Name of the container - used for error messages */
2422f26e09c8Sdrh };
2423f26e09c8Sdrh 
2424f26e09c8Sdrh /*
2425ade86483Sdrh ** An objected used to accumulate the text of a string where we
2426ade86483Sdrh ** do not necessarily know how big the string will be in the end.
2427ade86483Sdrh */
2428ade86483Sdrh struct StrAccum {
2429633e6d57Sdrh   sqlite3 *db;         /* Optional database for lookaside.  Can be NULL */
2430ade86483Sdrh   char *zBase;         /* A base allocation.  Not from malloc. */
2431ade86483Sdrh   char *zText;         /* The string collected so far */
2432ade86483Sdrh   int  nChar;          /* Length of the string so far */
2433ade86483Sdrh   int  nAlloc;         /* Amount of space allocated in zText */
2434bb4957f8Sdrh   int  mxAlloc;        /* Maximum allowed string length */
2435b975598eSdrh   u8   useMalloc;      /* 0: none,  1: sqlite3DbMalloc,  2: sqlite3_malloc */
2436b49bc86aSdrh   u8   accError;       /* STRACCUM_NOMEM or STRACCUM_TOOBIG */
2437ade86483Sdrh };
2438b49bc86aSdrh #define STRACCUM_NOMEM   1
2439b49bc86aSdrh #define STRACCUM_TOOBIG  2
2440ade86483Sdrh 
2441ade86483Sdrh /*
2442234c39dfSdrh ** A pointer to this structure is used to communicate information
2443234c39dfSdrh ** from sqlite3Init and OP_ParseSchema into the sqlite3InitCallback.
2444234c39dfSdrh */
2445234c39dfSdrh typedef struct {
24469bb575fdSdrh   sqlite3 *db;        /* The database being initialized */
2447234c39dfSdrh   char **pzErrMsg;    /* Error message stored here */
2448a451017dSdrh   int iDb;            /* 0 for main database.  1 for TEMP, 2.. for ATTACHed */
244915ca1df1Sdrh   int rc;             /* Result code stored here */
2450234c39dfSdrh } InitData;
2451234c39dfSdrh 
2452b6c29897Sdrh /*
245340257ffdSdrh ** Structure containing global configuration data for the SQLite library.
245433589797Sdrh **
245533589797Sdrh ** This structure also contains some state information.
245640257ffdSdrh */
245740257ffdSdrh struct Sqlite3Config {
2458fec00eabSdrh   int bMemstat;                     /* True to enable memory status */
2459fec00eabSdrh   int bCoreMutex;                   /* True to enable core mutexing */
2460fec00eabSdrh   int bFullMutex;                   /* True to enable full mutexing */
2461cd74b611Sdan   int bOpenUri;                     /* True to interpret filenames as URIs */
2462de9a7b8aSdrh   int bUseCis;                      /* Use covering indices for full-scans */
24630a687d12Sdrh   int mxStrlen;                     /* Maximum string length */
2464633e6d57Sdrh   int szLookaside;                  /* Default lookaside buffer size */
2465633e6d57Sdrh   int nLookaside;                   /* Default lookaside buffer count */
2466fec00eabSdrh   sqlite3_mem_methods m;            /* Low-level memory allocation interface */
24676d2ab0e4Sdanielk1977   sqlite3_mutex_methods mutex;      /* Low-level mutex interface */
246822e21ff4Sdan   sqlite3_pcache_methods2 pcache2;  /* Low-level page-cache interface */
246940257ffdSdrh   void *pHeap;                      /* Heap storage space */
247033589797Sdrh   int nHeap;                        /* Size of pHeap[] */
247133589797Sdrh   int mnReq, mxReq;                 /* Min and max heap requests sizes */
24729b4c59faSdrh   sqlite3_int64 szMmap;             /* mmap() space per open file */
24739b4c59faSdrh   sqlite3_int64 mxMmap;             /* Maximum value for szMmap */
247433589797Sdrh   void *pScratch;                   /* Scratch memory */
247533589797Sdrh   int szScratch;                    /* Size of each scratch buffer */
247633589797Sdrh   int nScratch;                     /* Number of scratch buffers */
247733589797Sdrh   void *pPage;                      /* Page cache memory */
247833589797Sdrh   int szPage;                       /* Size of each page in pPage[] */
247933589797Sdrh   int nPage;                        /* Number of pages in pPage[] */
24801875f7a3Sdrh   int mxParserStack;                /* maximum depth of the parser stack */
24811875f7a3Sdrh   int sharedCacheEnabled;           /* true if shared-cache mode enabled */
24821875f7a3Sdrh   /* The above might be initialized to non-zero.  The following need to always
24831875f7a3Sdrh   ** initially be zero, however. */
248471bc31c6Sdanielk1977   int isInit;                       /* True after initialization has finished */
2485502b4e00Sdanielk1977   int inProgress;                   /* True while initialization in progress */
2486e1ab2193Sdan   int isMutexInit;                  /* True after mutexes are initialized */
248771bc31c6Sdanielk1977   int isMallocInit;                 /* True after malloc is initialized */
2488e1ab2193Sdan   int isPCacheInit;                 /* True after malloc is initialized */
248971bc31c6Sdanielk1977   sqlite3_mutex *pInitMutex;        /* Mutex used by sqlite3_initialize() */
249093ed56d9Sdrh   int nRefInitMutex;                /* Number of users of pInitMutex */
24913f280701Sdrh   void (*xLog)(void*,int,const char*); /* Function for logging */
24923f280701Sdrh   void *pLogArg;                       /* First argument to xLog() */
2493c17d696cSdan   int bLocaltimeFault;              /* True to fail localtime() calls */
2494ac455939Sdan #ifdef SQLITE_ENABLE_SQLLOG
2495ac455939Sdan   void(*xSqllog)(void*,sqlite3*,const char*, int);
2496ac455939Sdan   void *pSqllogArg;
2497ac455939Sdan #endif
249840257ffdSdrh };
249940257ffdSdrh 
250040257ffdSdrh /*
25017d10d5a6Sdrh ** Context pointer passed down through the tree-walk.
25027d10d5a6Sdrh */
25037d10d5a6Sdrh struct Walker {
25047d10d5a6Sdrh   int (*xExprCallback)(Walker*, Expr*);     /* Callback for expressions */
25057d10d5a6Sdrh   int (*xSelectCallback)(Walker*,Select*);  /* Callback for SELECTs */
25067d10d5a6Sdrh   Parse *pParse;                            /* Parser context.  */
2507030796dfSdrh   int walkerDepth;                          /* Number of subqueries */
2508aa87f9a6Sdrh   u8 bSelectDepthFirst;                     /* Do subqueries first */
25097d10d5a6Sdrh   union {                                   /* Extra data for callback */
25107d10d5a6Sdrh     NameContext *pNC;                          /* Naming context */
25117d10d5a6Sdrh     int i;                                     /* Integer value */
2512374fdce4Sdrh     SrcList *pSrcList;                         /* FROM clause */
2513030796dfSdrh     struct SrcCount *pSrcCount;                /* Counting column references */
25147d10d5a6Sdrh   } u;
25157d10d5a6Sdrh };
25167d10d5a6Sdrh 
25177d10d5a6Sdrh /* Forward declarations */
25187d10d5a6Sdrh int sqlite3WalkExpr(Walker*, Expr*);
25197d10d5a6Sdrh int sqlite3WalkExprList(Walker*, ExprList*);
25207d10d5a6Sdrh int sqlite3WalkSelect(Walker*, Select*);
25217d10d5a6Sdrh int sqlite3WalkSelectExpr(Walker*, Select*);
25227d10d5a6Sdrh int sqlite3WalkSelectFrom(Walker*, Select*);
25237d10d5a6Sdrh 
25247d10d5a6Sdrh /*
25257d10d5a6Sdrh ** Return code from the parse-tree walking primitives and their
25267d10d5a6Sdrh ** callbacks.
25277d10d5a6Sdrh */
25282bf90f1eSdrh #define WRC_Continue    0   /* Continue down into children */
25292bf90f1eSdrh #define WRC_Prune       1   /* Omit children but continue walking siblings */
25302bf90f1eSdrh #define WRC_Abort       2   /* Abandon the tree walk */
25317d10d5a6Sdrh 
25327d10d5a6Sdrh /*
253366150956Sdrh ** Assuming zIn points to the first byte of a UTF-8 character,
253466150956Sdrh ** advance zIn to point to the first byte of the next UTF-8 character.
25354a919118Sdrh */
25364a919118Sdrh #define SQLITE_SKIP_UTF8(zIn) {                        \
25374a919118Sdrh   if( (*(zIn++))>=0xc0 ){                              \
25384a919118Sdrh     while( (*zIn & 0xc0)==0x80 ){ zIn++; }             \
25394a919118Sdrh   }                                                    \
25404a919118Sdrh }
25414a919118Sdrh 
25424a919118Sdrh /*
25439978c97eSdrh ** The SQLITE_*_BKPT macros are substitutes for the error codes with
25449978c97eSdrh ** the same name but without the _BKPT suffix.  These macros invoke
25459978c97eSdrh ** routines that report the line-number on which the error originated
25469978c97eSdrh ** using sqlite3_log().  The routines also provide a convenient place
25479978c97eSdrh ** to set a debugger breakpoint.
254849285708Sdrh */
25499978c97eSdrh int sqlite3CorruptError(int);
25509978c97eSdrh int sqlite3MisuseError(int);
25519978c97eSdrh int sqlite3CantopenError(int);
25529978c97eSdrh #define SQLITE_CORRUPT_BKPT sqlite3CorruptError(__LINE__)
25539978c97eSdrh #define SQLITE_MISUSE_BKPT sqlite3MisuseError(__LINE__)
25549978c97eSdrh #define SQLITE_CANTOPEN_BKPT sqlite3CantopenError(__LINE__)
25559978c97eSdrh 
255649285708Sdrh 
255749285708Sdrh /*
2558b4a1fed2Sdrh ** FTS4 is really an extension for FTS3.  It is enabled using the
2559b4a1fed2Sdrh ** SQLITE_ENABLE_FTS3 macro.  But to avoid confusion we also all
2560b4a1fed2Sdrh ** the SQLITE_ENABLE_FTS4 macro to serve as an alisse for SQLITE_ENABLE_FTS3.
2561b4a1fed2Sdrh */
2562b4a1fed2Sdrh #if defined(SQLITE_ENABLE_FTS4) && !defined(SQLITE_ENABLE_FTS3)
2563b4a1fed2Sdrh # define SQLITE_ENABLE_FTS3
2564b4a1fed2Sdrh #endif
2565b4a1fed2Sdrh 
2566b4a1fed2Sdrh /*
256779f02cefSdrh ** The ctype.h header is needed for non-ASCII systems.  It is also
256879f02cefSdrh ** needed by FTS3 when FTS3 is included in the amalgamation.
256979f02cefSdrh */
257079f02cefSdrh #if !defined(SQLITE_ASCII) || \
257179f02cefSdrh     (defined(SQLITE_ENABLE_FTS3) && defined(SQLITE_AMALGAMATION))
257279f02cefSdrh # include <ctype.h>
257379f02cefSdrh #endif
257479f02cefSdrh 
257579f02cefSdrh /*
257678ca0e7eSdanielk1977 ** The following macros mimic the standard library functions toupper(),
257778ca0e7eSdanielk1977 ** isspace(), isalnum(), isdigit() and isxdigit(), respectively. The
257878ca0e7eSdanielk1977 ** sqlite versions only work for ASCII characters, regardless of locale.
257978ca0e7eSdanielk1977 */
258078ca0e7eSdanielk1977 #ifdef SQLITE_ASCII
258178ca0e7eSdanielk1977 # define sqlite3Toupper(x)  ((x)&~(sqlite3CtypeMap[(unsigned char)(x)]&0x20))
258278ca0e7eSdanielk1977 # define sqlite3Isspace(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x01)
2583dc86e2b2Sdrh # define sqlite3Isalnum(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x06)
2584dc86e2b2Sdrh # define sqlite3Isalpha(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x02)
258578ca0e7eSdanielk1977 # define sqlite3Isdigit(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x04)
258678ca0e7eSdanielk1977 # define sqlite3Isxdigit(x)  (sqlite3CtypeMap[(unsigned char)(x)]&0x08)
258778ca0e7eSdanielk1977 # define sqlite3Tolower(x)   (sqlite3UpperToLower[(unsigned char)(x)])
258878ca0e7eSdanielk1977 #else
258978ca0e7eSdanielk1977 # define sqlite3Toupper(x)   toupper((unsigned char)(x))
259078ca0e7eSdanielk1977 # define sqlite3Isspace(x)   isspace((unsigned char)(x))
259178ca0e7eSdanielk1977 # define sqlite3Isalnum(x)   isalnum((unsigned char)(x))
2592dc86e2b2Sdrh # define sqlite3Isalpha(x)   isalpha((unsigned char)(x))
259378ca0e7eSdanielk1977 # define sqlite3Isdigit(x)   isdigit((unsigned char)(x))
259478ca0e7eSdanielk1977 # define sqlite3Isxdigit(x)  isxdigit((unsigned char)(x))
259578ca0e7eSdanielk1977 # define sqlite3Tolower(x)   tolower((unsigned char)(x))
259678ca0e7eSdanielk1977 #endif
259778ca0e7eSdanielk1977 
259878ca0e7eSdanielk1977 /*
259975897234Sdrh ** Internal function prototypes
260075897234Sdrh */
26013fa97302Sdrh #define sqlite3StrICmp sqlite3_stricmp
2602ea678832Sdrh int sqlite3Strlen30(const char*);
2603ee0484c1Sdanielk1977 #define sqlite3StrNICmp sqlite3_strnicmp
26042e588c75Sdanielk1977 
260540257ffdSdrh int sqlite3MallocInit(void);
2606fec00eabSdrh void sqlite3MallocEnd(void);
2607fec00eabSdrh void *sqlite3Malloc(int);
2608fec00eabSdrh void *sqlite3MallocZero(int);
2609fec00eabSdrh void *sqlite3DbMallocZero(sqlite3*, int);
2610fec00eabSdrh void *sqlite3DbMallocRaw(sqlite3*, int);
261117435752Sdrh char *sqlite3DbStrDup(sqlite3*,const char*);
261217435752Sdrh char *sqlite3DbStrNDup(sqlite3*,const char*, int);
2613fec00eabSdrh void *sqlite3Realloc(void*, int);
261497c8ec32Sdrh void *sqlite3DbReallocOrFree(sqlite3 *, void *, int);
2615a1644fd8Sdanielk1977 void *sqlite3DbRealloc(sqlite3 *, void *, int);
2616633e6d57Sdrh void sqlite3DbFree(sqlite3*, void*);
2617a7a8e14bSdanielk1977 int sqlite3MallocSize(void*);
2618633e6d57Sdrh int sqlite3DbMallocSize(sqlite3*, void*);
2619facf0307Sdrh void *sqlite3ScratchMalloc(int);
2620facf0307Sdrh void sqlite3ScratchFree(void*);
2621facf0307Sdrh void *sqlite3PageMalloc(int);
2622facf0307Sdrh void sqlite3PageFree(void*);
2623fec00eabSdrh void sqlite3MemSetDefault(void);
2624171bfed3Sdanielk1977 void sqlite3BenignMallocHooks(void (*)(void), void (*)(void));
262550d1b5f3Sdrh int sqlite3HeapNearlyFull(void);
26262e588c75Sdanielk1977 
2627e7b34707Sdrh /*
2628e7b34707Sdrh ** On systems with ample stack space and that support alloca(), make
2629e7b34707Sdrh ** use of alloca() to obtain space for large automatic objects.  By default,
2630e7b34707Sdrh ** obtain space from malloc().
2631e7b34707Sdrh **
2632e7b34707Sdrh ** The alloca() routine never returns NULL.  This will cause code paths
2633e7b34707Sdrh ** that deal with sqlite3StackAlloc() failures to be unreachable.
2634e7b34707Sdrh */
2635e7b34707Sdrh #ifdef SQLITE_USE_ALLOCA
2636e7b34707Sdrh # define sqlite3StackAllocRaw(D,N)   alloca(N)
2637e7b34707Sdrh # define sqlite3StackAllocZero(D,N)  memset(alloca(N), 0, N)
2638e7b34707Sdrh # define sqlite3StackFree(D,P)
2639e7b34707Sdrh #else
2640e7b34707Sdrh # define sqlite3StackAllocRaw(D,N)   sqlite3DbMallocRaw(D,N)
2641e7b34707Sdrh # define sqlite3StackAllocZero(D,N)  sqlite3DbMallocZero(D,N)
2642e7b34707Sdrh # define sqlite3StackFree(D,P)       sqlite3DbFree(D,P)
2643e7b34707Sdrh #endif
2644e7b34707Sdrh 
2645f3d3c27aSdanielk1977 #ifdef SQLITE_ENABLE_MEMSYS3
2646f3d3c27aSdanielk1977 const sqlite3_mem_methods *sqlite3MemGetMemsys3(void);
2647f3d3c27aSdanielk1977 #endif
2648f3d3c27aSdanielk1977 #ifdef SQLITE_ENABLE_MEMSYS5
2649f3d3c27aSdanielk1977 const sqlite3_mem_methods *sqlite3MemGetMemsys5(void);
2650f3d3c27aSdanielk1977 #endif
2651f3d3c27aSdanielk1977 
2652f3d3c27aSdanielk1977 
265318472fa7Sdrh #ifndef SQLITE_MUTEX_OMIT
2654558814f8Sdan   sqlite3_mutex_methods const *sqlite3DefaultMutex(void);
2655558814f8Sdan   sqlite3_mutex_methods const *sqlite3NoopMutex(void);
265659f8c08eSdanielk1977   sqlite3_mutex *sqlite3MutexAlloc(int);
2657d025174fSdanielk1977   int sqlite3MutexInit(void);
2658d025174fSdanielk1977   int sqlite3MutexEnd(void);
265965bbf29eSdrh #endif
26606d2ab0e4Sdanielk1977 
2661f7141990Sdrh int sqlite3StatusValue(int);
2662f7141990Sdrh void sqlite3StatusAdd(int, int);
2663f7141990Sdrh void sqlite3StatusSet(int, int);
2664f7141990Sdrh 
266585c8f291Sdrh #ifndef SQLITE_OMIT_FLOATING_POINT
26660de3ae95Sdrh   int sqlite3IsNaN(double);
266785c8f291Sdrh #else
266885c8f291Sdrh # define sqlite3IsNaN(X)  0
266985c8f291Sdrh #endif
26700de3ae95Sdrh 
2671f089aa45Sdrh void sqlite3VXPrintf(StrAccum*, int, const char*, va_list);
2672c7bc4fdeSdrh #ifndef SQLITE_OMIT_TRACE
2673c7bc4fdeSdrh void sqlite3XPrintf(StrAccum*, const char*, ...);
2674c7bc4fdeSdrh #endif
267517435752Sdrh char *sqlite3MPrintf(sqlite3*,const char*, ...);
267617435752Sdrh char *sqlite3VMPrintf(sqlite3*,const char*, va_list);
2677633e6d57Sdrh char *sqlite3MAppendf(sqlite3*,char*,const char*,...);
267887cc3b31Sdrh #if defined(SQLITE_TEST) || defined(SQLITE_DEBUG)
2679e54ca3feSdrh   void sqlite3DebugPrintf(const char*, ...);
2680d919fe17Sdrh #endif
2681d919fe17Sdrh #if defined(SQLITE_TEST)
2682e8f52c50Sdrh   void *sqlite3TestTextToPtr(const char*);
268387cc3b31Sdrh #endif
26847e02e5e6Sdrh 
26857e02e5e6Sdrh /* Output formatting for SQLITE_TESTCTRL_EXPLAIN */
2686678a9aa7Sdrh #if defined(SQLITE_ENABLE_TREE_EXPLAIN)
26877e02e5e6Sdrh   void sqlite3ExplainBegin(Vdbe*);
26887e02e5e6Sdrh   void sqlite3ExplainPrintf(Vdbe*, const char*, ...);
26897e02e5e6Sdrh   void sqlite3ExplainNL(Vdbe*);
26907e02e5e6Sdrh   void sqlite3ExplainPush(Vdbe*);
26917e02e5e6Sdrh   void sqlite3ExplainPop(Vdbe*);
26927e02e5e6Sdrh   void sqlite3ExplainFinish(Vdbe*);
26937e02e5e6Sdrh   void sqlite3ExplainSelect(Vdbe*, Select*);
26947e02e5e6Sdrh   void sqlite3ExplainExpr(Vdbe*, Expr*);
26957e02e5e6Sdrh   void sqlite3ExplainExprList(Vdbe*, ExprList*);
26967e02e5e6Sdrh   const char *sqlite3VdbeExplanation(Vdbe*);
26977e02e5e6Sdrh #else
26987e02e5e6Sdrh # define sqlite3ExplainBegin(X)
26997e02e5e6Sdrh # define sqlite3ExplainSelect(A,B)
27007e02e5e6Sdrh # define sqlite3ExplainExpr(A,B)
27017e02e5e6Sdrh # define sqlite3ExplainExprList(A,B)
27027e02e5e6Sdrh # define sqlite3ExplainFinish(X)
27037e02e5e6Sdrh # define sqlite3VdbeExplanation(X) 0
27047e02e5e6Sdrh #endif
27057e02e5e6Sdrh 
27067e02e5e6Sdrh 
2707f089aa45Sdrh void sqlite3SetString(char **, sqlite3*, const char*, ...);
27084adee20fSdanielk1977 void sqlite3ErrorMsg(Parse*, const char*, ...);
270924fb627aSdrh int sqlite3Dequote(char*);
27102646da7eSdrh int sqlite3KeywordCode(const unsigned char*, int);
27114adee20fSdanielk1977 int sqlite3RunParser(Parse*, const char*, char **);
271280242055Sdrh void sqlite3FinishCoding(Parse*);
2713892d3179Sdrh int sqlite3GetTempReg(Parse*);
2714892d3179Sdrh void sqlite3ReleaseTempReg(Parse*,int);
2715892d3179Sdrh int sqlite3GetTempRange(Parse*,int);
2716892d3179Sdrh void sqlite3ReleaseTempRange(Parse*,int,int);
2717cdc69557Sdrh void sqlite3ClearTempRegCache(Parse*);
2718b7916a78Sdrh Expr *sqlite3ExprAlloc(sqlite3*,int,const Token*,int);
2719b7916a78Sdrh Expr *sqlite3Expr(sqlite3*,int,const char*);
2720b7916a78Sdrh void sqlite3ExprAttachSubtrees(sqlite3*,Expr*,Expr*,Expr*);
272117435752Sdrh Expr *sqlite3PExpr(Parse*, int, Expr*, Expr*, const Token*);
27221e536953Sdanielk1977 Expr *sqlite3ExprAnd(sqlite3*,Expr*, Expr*);
272317435752Sdrh Expr *sqlite3ExprFunction(Parse*,ExprList*, Token*);
2724fa6bc000Sdrh void sqlite3ExprAssignVarNumber(Parse*, Expr*);
2725633e6d57Sdrh void sqlite3ExprDelete(sqlite3*, Expr*);
2726b7916a78Sdrh ExprList *sqlite3ExprListAppend(Parse*,ExprList*,Expr*);
2727b7916a78Sdrh void sqlite3ExprListSetName(Parse*,ExprList*,Token*,int);
2728b7916a78Sdrh void sqlite3ExprListSetSpan(Parse*,ExprList*,ExprSpan*);
2729633e6d57Sdrh void sqlite3ExprListDelete(sqlite3*, ExprList*);
27309bb575fdSdrh int sqlite3Init(sqlite3*, char**);
2731234c39dfSdrh int sqlite3InitCallback(void*, int, char**, char**);
273291cf71b0Sdanielk1977 void sqlite3Pragma(Parse*,Token*,Token*,Token*,int);
273381028a45Sdrh void sqlite3ResetAllSchemasOfConnection(sqlite3*);
273481028a45Sdrh void sqlite3ResetOneSchema(sqlite3*,int);
273581028a45Sdrh void sqlite3CollapseDatabaseArray(sqlite3*);
27364adee20fSdanielk1977 void sqlite3BeginParse(Parse*,int);
27379bb575fdSdrh void sqlite3CommitInternalChanges(sqlite3*);
27387d10d5a6Sdrh Table *sqlite3ResultSetOfSelect(Parse*,Select*);
2739c00da105Sdanielk1977 void sqlite3OpenMasterTable(Parse *, int);
2740f1a381e7Sdanielk1977 void sqlite3StartTable(Parse*,Token*,Token*,int,int,int,int);
27414adee20fSdanielk1977 void sqlite3AddColumn(Parse*,Token*);
27424adee20fSdanielk1977 void sqlite3AddNotNull(Parse*, int);
2743fdd6e85aSdrh void sqlite3AddPrimaryKey(Parse*, ExprList*, int, int, int);
2744ffe07b2dSdrh void sqlite3AddCheckConstraint(Parse*, Expr*);
2745487e262fSdrh void sqlite3AddColumnType(Parse*,Token*);
2746b7916a78Sdrh void sqlite3AddDefaultValue(Parse*,ExprSpan*);
274739002505Sdanielk1977 void sqlite3AddCollateType(Parse*, Token*);
274819a8e7e8Sdanielk1977 void sqlite3EndTable(Parse*,Token*,Token*,Select*);
2749522c26fbSdrh int sqlite3ParseUri(const char*,const char*,unsigned int*,
2750522c26fbSdrh                     sqlite3_vfs**,char**,char **);
2751421377e6Sdrh Btree *sqlite3DbNameToBtree(sqlite3*,const char*);
27521d8cb21fSdan int sqlite3CodeOnce(Parse *);
2753b7f9164eSdrh 
2754f5e7bb51Sdrh Bitvec *sqlite3BitvecCreate(u32);
2755f5e7bb51Sdrh int sqlite3BitvecTest(Bitvec*, u32);
2756f5e7bb51Sdrh int sqlite3BitvecSet(Bitvec*, u32);
2757e98c9049Sdrh void sqlite3BitvecClear(Bitvec*, u32, void*);
2758f5e7bb51Sdrh void sqlite3BitvecDestroy(Bitvec*);
2759bea2a948Sdanielk1977 u32 sqlite3BitvecSize(Bitvec*);
27603088d59eSdrh int sqlite3BitvecBuiltinTest(int,int*);
2761f5e7bb51Sdrh 
27623d4501e5Sdrh RowSet *sqlite3RowSetInit(sqlite3*, void*, unsigned int);
27633d4501e5Sdrh void sqlite3RowSetClear(RowSet*);
27643d4501e5Sdrh void sqlite3RowSetInsert(RowSet*, i64);
2765733bf1b1Sdrh int sqlite3RowSetTest(RowSet*, u8 iBatch, i64);
27663d4501e5Sdrh int sqlite3RowSetNext(RowSet*, i64*);
27673d4501e5Sdrh 
2768fdd48a76Sdrh void sqlite3CreateView(Parse*,Token*,Token*,Token*,Select*,int,int);
2769fe3fcbe2Sdanielk1977 
2770fe3fcbe2Sdanielk1977 #if !defined(SQLITE_OMIT_VIEW) || !defined(SQLITE_OMIT_VIRTUALTABLE)
27714adee20fSdanielk1977   int sqlite3ViewGetColumnNames(Parse*,Table*);
2772b7f9164eSdrh #else
2773b7f9164eSdrh # define sqlite3ViewGetColumnNames(A,B) 0
2774b7f9164eSdrh #endif
2775b7f9164eSdrh 
2776a073384fSdrh void sqlite3DropTable(Parse*, SrcList*, int, int);
2777faacf17cSdrh void sqlite3CodeDropTable(Parse*, Table*, int, int);
27781feeaed2Sdan void sqlite3DeleteTable(sqlite3*, Table*);
27790b9f50d8Sdrh #ifndef SQLITE_OMIT_AUTOINCREMENT
27800b9f50d8Sdrh   void sqlite3AutoincrementBegin(Parse *pParse);
27810b9f50d8Sdrh   void sqlite3AutoincrementEnd(Parse *pParse);
27820b9f50d8Sdrh #else
27830b9f50d8Sdrh # define sqlite3AutoincrementBegin(X)
27840b9f50d8Sdrh # define sqlite3AutoincrementEnd(X)
27850b9f50d8Sdrh #endif
27865f085269Sdrh int sqlite3CodeCoroutine(Parse*, Select*, SelectDest*);
27874adee20fSdanielk1977 void sqlite3Insert(Parse*, SrcList*, ExprList*, Select*, IdList*, int);
27886c535158Sdrh void *sqlite3ArrayAllocate(sqlite3*,void*,int,int*,int*);
278917435752Sdrh IdList *sqlite3IdListAppend(sqlite3*, IdList*, Token*);
27904adee20fSdanielk1977 int sqlite3IdListIndex(IdList*,const char*);
2791a78c22c4Sdrh SrcList *sqlite3SrcListEnlarge(sqlite3*, SrcList*, int, int);
279217435752Sdrh SrcList *sqlite3SrcListAppend(sqlite3*, SrcList*, Token*, Token*);
2793b1c685b0Sdanielk1977 SrcList *sqlite3SrcListAppendFromTerm(Parse*, SrcList*, Token*, Token*,
279485574e31Sdanielk1977                                       Token*, Select*, Expr*, IdList*);
2795b1c685b0Sdanielk1977 void sqlite3SrcListIndexedBy(Parse *, SrcList *, Token *);
2796b1c685b0Sdanielk1977 int sqlite3IndexedByLookup(Parse *, struct SrcList_item *);
279761dfc31dSdrh void sqlite3SrcListShiftJoinType(SrcList*);
27984adee20fSdanielk1977 void sqlite3SrcListAssignCursors(Parse*, SrcList*);
2799633e6d57Sdrh void sqlite3IdListDelete(sqlite3*, IdList*);
2800633e6d57Sdrh void sqlite3SrcListDelete(sqlite3*, SrcList*);
28011da40a38Sdan Index *sqlite3CreateIndex(Parse*,Token*,Token*,SrcList*,ExprList*,int,Token*,
28028a9789b6Sdrh                           Expr*, int, int);
28034d91a701Sdrh void sqlite3DropIndex(Parse*, SrcList*, int);
28047d10d5a6Sdrh int sqlite3Select(Parse*, Select*, SelectDest*);
280517435752Sdrh Select *sqlite3SelectNew(Parse*,ExprList*,SrcList*,Expr*,ExprList*,
2806832ee3d4Sdrh                          Expr*,ExprList*,u16,Expr*,Expr*);
2807633e6d57Sdrh void sqlite3SelectDelete(sqlite3*, Select*);
28084adee20fSdanielk1977 Table *sqlite3SrcListLookup(Parse*, SrcList*);
28094adee20fSdanielk1977 int sqlite3IsReadOnly(Parse*, Table*, int);
2810c00da105Sdanielk1977 void sqlite3OpenTable(Parse*, int iCur, int iDb, Table*, int);
2811273f619bSshane #if defined(SQLITE_ENABLE_UPDATE_DELETE_LIMIT) && !defined(SQLITE_OMIT_SUBQUERY)
281249ffdbf4Sshane Expr *sqlite3LimitWhere(Parse*,SrcList*,Expr*,ExprList*,Expr*,Expr*,char*);
28134281bd42Sshane #endif
28144adee20fSdanielk1977 void sqlite3DeleteFrom(Parse*, SrcList*, Expr*);
28154adee20fSdanielk1977 void sqlite3Update(Parse*, SrcList*, ExprList*, Expr*, int);
281646ec5b63Sdrh WhereInfo *sqlite3WhereBegin(Parse*,SrcList*,Expr*,ExprList*,ExprList*,u16,int);
28174adee20fSdanielk1977 void sqlite3WhereEnd(WhereInfo*);
2818c63367efSdrh u64 sqlite3WhereOutputRowCount(WhereInfo*);
28196f32848dSdrh int sqlite3WhereIsDistinct(WhereInfo*);
28206f32848dSdrh int sqlite3WhereIsOrdered(WhereInfo*);
28216f32848dSdrh int sqlite3WhereContinueLabel(WhereInfo*);
28226f32848dSdrh int sqlite3WhereBreakLabel(WhereInfo*);
28236f32848dSdrh int sqlite3WhereOkOnePass(WhereInfo*);
2824a748fdccSdrh int sqlite3ExprCodeGetColumn(Parse*, Table*, int, int, int, u8);
28255c092e8aSdrh void sqlite3ExprCodeGetColumnOfTable(Vdbe*, Table*, int, int, int);
2826b21e7c70Sdrh void sqlite3ExprCodeMove(Parse*, int, int, int);
2827ceea3321Sdrh void sqlite3ExprCacheStore(Parse*, int, int, int);
2828ceea3321Sdrh void sqlite3ExprCachePush(Parse*);
2829ceea3321Sdrh void sqlite3ExprCachePop(Parse*, int);
2830f49f3523Sdrh void sqlite3ExprCacheRemove(Parse*, int, int);
2831ceea3321Sdrh void sqlite3ExprCacheClear(Parse*);
2832da250ea5Sdrh void sqlite3ExprCacheAffinityChange(Parse*, int, int);
2833389a1adbSdrh int sqlite3ExprCode(Parse*, Expr*, int);
28342dcef11bSdrh int sqlite3ExprCodeTemp(Parse*, Expr*, int*);
2835678ccce8Sdrh int sqlite3ExprCodeTarget(Parse*, Expr*, int);
28362dcef11bSdrh int sqlite3ExprCodeAndCache(Parse*, Expr*, int);
2837678ccce8Sdrh void sqlite3ExprCodeConstants(Parse*, Expr*);
2838191b54cbSdrh int sqlite3ExprCodeExprList(Parse*, ExprList*, int, int);
28394adee20fSdanielk1977 void sqlite3ExprIfTrue(Parse*, Expr*, int, int);
28404adee20fSdanielk1977 void sqlite3ExprIfFalse(Parse*, Expr*, int, int);
28419bb575fdSdrh Table *sqlite3FindTable(sqlite3*,const char*, const char*);
2842ca424114Sdrh Table *sqlite3LocateTable(Parse*,int isView,const char*, const char*);
284341fb5cd1Sdan Table *sqlite3LocateTableItem(Parse*,int isView,struct SrcList_item *);
28449bb575fdSdrh Index *sqlite3FindIndex(sqlite3*,const char*, const char*);
28459bb575fdSdrh void sqlite3UnlinkAndDeleteTable(sqlite3*,int,const char*);
28469bb575fdSdrh void sqlite3UnlinkAndDeleteIndex(sqlite3*,int,const char*);
284774161705Sdrh void sqlite3Vacuum(Parse*);
28489bb575fdSdrh int sqlite3RunVacuum(char**, sqlite3*);
284917435752Sdrh char *sqlite3NameFromToken(sqlite3*, Token*);
2850619a1305Sdrh int sqlite3ExprCompare(Expr*, Expr*, int);
2851619a1305Sdrh int sqlite3ExprListCompare(ExprList*, ExprList*, int);
28524bd5f73fSdrh int sqlite3ExprImpliesExpr(Expr*, Expr*, int);
2853d2b3e23bSdrh void sqlite3ExprAnalyzeAggregates(NameContext*, Expr*);
2854d2b3e23bSdrh void sqlite3ExprAnalyzeAggList(NameContext*,ExprList*);
2855030796dfSdrh int sqlite3FunctionUsesThisSrc(Expr*, SrcList*);
28564adee20fSdanielk1977 Vdbe *sqlite3GetVdbe(Parse*);
28572fa1868fSdrh void sqlite3PrngSaveState(void);
28582fa1868fSdrh void sqlite3PrngRestoreState(void);
28592fa1868fSdrh void sqlite3PrngResetState(void);
28600f198a74Sdrh void sqlite3RollbackAll(sqlite3*,int);
28614adee20fSdanielk1977 void sqlite3CodeVerifySchema(Parse*, int);
286257966753Sdan void sqlite3CodeVerifyNamedSchema(Parse*, const char *zDb);
2863684917c2Sdrh void sqlite3BeginTransaction(Parse*, int);
28644adee20fSdanielk1977 void sqlite3CommitTransaction(Parse*);
28654adee20fSdanielk1977 void sqlite3RollbackTransaction(Parse*);
2866fd7f0452Sdanielk1977 void sqlite3Savepoint(Parse*, int, Token*);
2867fd7f0452Sdanielk1977 void sqlite3CloseSavepoints(sqlite3 *);
28684245c405Sdrh void sqlite3LeaveMutexAndCloseZombie(sqlite3*);
28694adee20fSdanielk1977 int sqlite3ExprIsConstant(Expr*);
28700a168377Sdrh int sqlite3ExprIsConstantNotJoin(Expr*);
2871eb55bd2fSdrh int sqlite3ExprIsConstantOrFunction(Expr*);
28724adee20fSdanielk1977 int sqlite3ExprIsInteger(Expr*, int*);
2873039fc32eSdrh int sqlite3ExprCanBeNull(const Expr*);
28742f2855b6Sdrh void sqlite3ExprCodeIsNullJump(Vdbe*, const Expr*, int, int);
2875039fc32eSdrh int sqlite3ExprNeedsNoAffinityChange(const Expr*, char);
28764adee20fSdanielk1977 int sqlite3IsRowid(const char*);
28772283d46cSdan void sqlite3GenerateRowDelete(Parse*, Table*, int, int, int, Trigger *, int);
28782d401ab8Sdrh void sqlite3GenerateRowIndexDelete(Parse*, Table*, int, int*);
2879b2b9d3d7Sdrh int sqlite3GenerateIndexKey(Parse*, Index*, int, int, int, int*);
288004adf416Sdrh void sqlite3GenerateConstraintChecks(Parse*,Table*,int,int,
2881de630353Sdanielk1977                                      int*,int,int,int,int,int*);
28822832ad42Sdan void sqlite3CompleteInsertion(Parse*, Table*, int, int, int*, int, int, int);
2883aa9b8963Sdrh int sqlite3OpenTableAndIndices(Parse*, Table*, int, int);
28844adee20fSdanielk1977 void sqlite3BeginWriteOperation(Parse*, int, int);
2885ff738bceSdrh void sqlite3MultiWrite(Parse*);
2886e0af83acSdan void sqlite3MayAbort(Parse*);
2887d91c1a17Sdrh void sqlite3HaltConstraint(Parse*, int, int, char*, int);
28886ab3a2ecSdanielk1977 Expr *sqlite3ExprDup(sqlite3*,Expr*,int);
28896ab3a2ecSdanielk1977 ExprList *sqlite3ExprListDup(sqlite3*,ExprList*,int);
28906ab3a2ecSdanielk1977 SrcList *sqlite3SrcListDup(sqlite3*,SrcList*,int);
289117435752Sdrh IdList *sqlite3IdListDup(sqlite3*,IdList*);
28926ab3a2ecSdanielk1977 Select *sqlite3SelectDup(sqlite3*,Select*,int);
289370a8ca3cSdrh void sqlite3FuncDefInsert(FuncDefHash*, FuncDef*);
289489d5d6a2Sdrh FuncDef *sqlite3FindFunction(sqlite3*,const char*,int,int,u8,u8);
28959bb575fdSdrh void sqlite3RegisterBuiltinFunctions(sqlite3*);
2896777c5386Sdrh void sqlite3RegisterDateTimeFunctions(void);
289770a8ca3cSdrh void sqlite3RegisterGlobalFunctions(void);
28987e8b848aSdrh int sqlite3SafetyCheckOk(sqlite3*);
28997e8b848aSdrh int sqlite3SafetyCheckSickOrOk(sqlite3*);
29009cbf3425Sdrh void sqlite3ChangeCookie(Parse*, int);
2901fa4e62f3Sshane 
2902fa4e62f3Sshane #if !defined(SQLITE_OMIT_VIEW) && !defined(SQLITE_OMIT_TRIGGER)
29032a5d825eSdrh void sqlite3MaterializeView(Parse*, Table*, Expr*, int);
2904fa4e62f3Sshane #endif
2905b7f9164eSdrh 
2906b7f9164eSdrh #ifndef SQLITE_OMIT_TRIGGER
2907ef2cb63eSdanielk1977   void sqlite3BeginTrigger(Parse*, Token*,Token*,int,int,IdList*,SrcList*,
290860218d2aSdrh                            Expr*,int, int);
29094adee20fSdanielk1977   void sqlite3FinishTrigger(Parse*, TriggerStep*, Token*);
2910fdd48a76Sdrh   void sqlite3DropTrigger(Parse*, SrcList*, int);
291174161705Sdrh   void sqlite3DropTriggerPtr(Parse*, Trigger*);
29122f886d1dSdanielk1977   Trigger *sqlite3TriggersExist(Parse *, Table*, int, ExprList*, int *pMask);
29132f886d1dSdanielk1977   Trigger *sqlite3TriggerList(Parse *, Table *);
2914165921a7Sdan   void sqlite3CodeRowTrigger(Parse*, Trigger *, int, ExprList*, int, Table *,
291594d7f50aSdan                             int, int, int);
29161da40a38Sdan   void sqlite3CodeRowTriggerDirect(Parse *, Trigger *, Table *, int, int, int);
2917dc379456Sdrh   void sqliteViewTriggers(Parse*, Table*, Expr*, int, ExprList*);
2918633e6d57Sdrh   void sqlite3DeleteTriggerStep(sqlite3*, TriggerStep*);
291917435752Sdrh   TriggerStep *sqlite3TriggerSelectStep(sqlite3*,Select*);
292017435752Sdrh   TriggerStep *sqlite3TriggerInsertStep(sqlite3*,Token*, IdList*,
29215eff7cf0Sshane                                         ExprList*,Select*,u8);
29225eff7cf0Sshane   TriggerStep *sqlite3TriggerUpdateStep(sqlite3*,Token*,ExprList*, Expr*, u8);
292317435752Sdrh   TriggerStep *sqlite3TriggerDeleteStep(sqlite3*,Token*, Expr*);
2924633e6d57Sdrh   void sqlite3DeleteTrigger(sqlite3*, Trigger*);
2925b7f9164eSdrh   void sqlite3UnlinkAndDeleteTrigger(sqlite3*,int,const char*);
2926bb5f168fSdan   u32 sqlite3TriggerColmask(Parse*,Trigger*,ExprList*,int,int,Table*,int);
292765a7cd16Sdan # define sqlite3ParseToplevel(p) ((p)->pToplevel ? (p)->pToplevel : (p))
2928b7f9164eSdrh #else
292962c14b34Sdanielk1977 # define sqlite3TriggersExist(B,C,D,E,F) 0
2930633e6d57Sdrh # define sqlite3DeleteTrigger(A,B)
2931cdd536f0Sdrh # define sqlite3DropTriggerPtr(A,B)
2932b7f9164eSdrh # define sqlite3UnlinkAndDeleteTrigger(A,B,C)
293394d7f50aSdan # define sqlite3CodeRowTrigger(A,B,C,D,E,F,G,H,I)
293475cbd984Sdan # define sqlite3CodeRowTriggerDirect(A,B,C,D,E,F)
29352943c372Sdanielk1977 # define sqlite3TriggerList(X, Y) 0
293665a7cd16Sdan # define sqlite3ParseToplevel(p) p
2937bb5f168fSdan # define sqlite3TriggerColmask(A,B,C,D,E,F,G) 0
2938b7f9164eSdrh #endif
2939b7f9164eSdrh 
29404adee20fSdanielk1977 int sqlite3JoinType(Parse*, Token*, Token*, Token*);
29410202b29eSdanielk1977 void sqlite3CreateForeignKey(Parse*, ExprList*, Token*, ExprList*, int);
29424adee20fSdanielk1977 void sqlite3DeferForeignKey(Parse*, int);
2943ed6c8671Sdrh #ifndef SQLITE_OMIT_AUTHORIZATION
2944728b5779Sdrh   void sqlite3AuthRead(Parse*,Expr*,Schema*,SrcList*);
29454adee20fSdanielk1977   int sqlite3AuthCheck(Parse*,int, const char*, const char*, const char*);
29464adee20fSdanielk1977   void sqlite3AuthContextPush(Parse*, AuthContext*, const char*);
29474adee20fSdanielk1977   void sqlite3AuthContextPop(AuthContext*);
294802470b20Sdan   int sqlite3AuthReadCol(Parse*, const char *, const char *, int);
2949ed6c8671Sdrh #else
2950b5258c3dSdanielk1977 # define sqlite3AuthRead(a,b,c,d)
29514adee20fSdanielk1977 # define sqlite3AuthCheck(a,b,c,d,e)    SQLITE_OK
29524adee20fSdanielk1977 # define sqlite3AuthContextPush(a,b,c)
29534adee20fSdanielk1977 # define sqlite3AuthContextPop(a)  ((void)(a))
2954ed6c8671Sdrh #endif
2955f744bb56Sdanielk1977 void sqlite3Attach(Parse*, Expr*, Expr*, Expr*);
2956f744bb56Sdanielk1977 void sqlite3Detach(Parse*, Expr*);
2957d100f691Sdrh void sqlite3FixInit(DbFixer*, Parse*, int, const char*, const Token*);
29584adee20fSdanielk1977 int sqlite3FixSrcList(DbFixer*, SrcList*);
29594adee20fSdanielk1977 int sqlite3FixSelect(DbFixer*, Select*);
29604adee20fSdanielk1977 int sqlite3FixExpr(DbFixer*, Expr*);
29614adee20fSdanielk1977 int sqlite3FixExprList(DbFixer*, ExprList*);
29624adee20fSdanielk1977 int sqlite3FixTriggerStep(DbFixer*, TriggerStep*);
29639339da1fSdrh int sqlite3AtoF(const char *z, double*, int, u8);
2964fec19aadSdrh int sqlite3GetInt32(const char *, int*);
296560ac3f42Sdrh int sqlite3Atoi(const char*);
2966ee85813cSdrh int sqlite3Utf16ByteLen(const void *pData, int nChar);
2967ee85813cSdrh int sqlite3Utf8CharLen(const char *pData, int nByte);
296842610961Sdrh u32 sqlite3Utf8Read(const u8**);
29693f8d5cfcSshane 
29703f8d5cfcSshane /*
29713f8d5cfcSshane ** Routines to read and write variable-length integers.  These used to
29723f8d5cfcSshane ** be defined locally, but now we use the varint routines in the util.c
2973952856adSshane ** file.  Code should use the MACRO forms below, as the Varint32 versions
2974952856adSshane ** are coded to assume the single byte case is already handled (which
2975952856adSshane ** the MACRO form does).
29763f8d5cfcSshane */
2977192ac1dcSdanielk1977 int sqlite3PutVarint(unsigned char*, u64);
297835b5a33eSdrh int sqlite3PutVarint32(unsigned char*, u32);
29791bd10f8aSdrh u8 sqlite3GetVarint(const unsigned char *, u64 *);
29801bd10f8aSdrh u8 sqlite3GetVarint32(const unsigned char *, u32 *);
2981192ac1dcSdanielk1977 int sqlite3VarintLen(u64 v);
29823f8d5cfcSshane 
29833f8d5cfcSshane /*
29843f8d5cfcSshane ** The header of a record consists of a sequence variable-length integers.
29853f8d5cfcSshane ** These integers are almost always small and are encoded as a single byte.
29863f8d5cfcSshane ** The following macros take advantage this fact to provide a fast encode
29873f8d5cfcSshane ** and decode of the integers in a record header.  It is faster for the common
29883f8d5cfcSshane ** case where the integer is a single byte.  It is a little slower when the
29893f8d5cfcSshane ** integer is two or more bytes.  But overall it is faster.
29903f8d5cfcSshane **
29913f8d5cfcSshane ** The following expressions are equivalent:
29923f8d5cfcSshane **
29933f8d5cfcSshane **     x = sqlite3GetVarint32( A, &B );
29943f8d5cfcSshane **     x = sqlite3PutVarint32( A, B );
29953f8d5cfcSshane **
29963f8d5cfcSshane **     x = getVarint32( A, B );
29973f8d5cfcSshane **     x = putVarint32( A, B );
29983f8d5cfcSshane **
29993f8d5cfcSshane */
30004bde3702Sdrh #define getVarint32(A,B)  \
30014bde3702Sdrh   (u8)((*(A)<(u8)0x80)?((B)=(u32)*(A)),1:sqlite3GetVarint32((A),(u32 *)&(B)))
30024bde3702Sdrh #define putVarint32(A,B)  \
30034bde3702Sdrh   (u8)(((u32)(B)<(u32)0x80)?(*(A)=(unsigned char)(B)),1:\
30044bde3702Sdrh   sqlite3PutVarint32((A),(B)))
30053f8d5cfcSshane #define getVarint    sqlite3GetVarint
30063f8d5cfcSshane #define putVarint    sqlite3PutVarint
30073f8d5cfcSshane 
30083f8d5cfcSshane 
300969f8bb9cSdan const char *sqlite3IndexAffinityStr(Vdbe *, Index *);
3010a37cdde0Sdanielk1977 void sqlite3TableAffinityStr(Vdbe *, Table *);
3011e014a838Sdanielk1977 char sqlite3CompareAffinity(Expr *pExpr, char aff2);
3012e014a838Sdanielk1977 int sqlite3IndexAffinityOk(Expr *pExpr, char idx_affinity);
3013bf3b721fSdanielk1977 char sqlite3ExprAffinity(Expr *pExpr);
30149339da1fSdrh int sqlite3Atoi64(const char*, i64*, int, u8);
30159bb575fdSdrh void sqlite3Error(sqlite3*, int, const char*,...);
3016ca48c90fSdrh void *sqlite3HexToBlob(sqlite3*, const char *z, int n);
3017cd74b611Sdan u8 sqlite3HexToInt(int h);
3018ef2cb63eSdanielk1977 int sqlite3TwoPartName(Parse *, Token *, Token *, Token **);
3019dd08ca0fSmistachkin 
3020dd08ca0fSmistachkin #if defined(SQLITE_DEBUG) || defined(SQLITE_TEST) || \
3021dd08ca0fSmistachkin     defined(SQLITE_DEBUG_OS_TRACE)
3022f2c1c99fSmistachkin const char *sqlite3ErrName(int);
3023dd08ca0fSmistachkin #endif
3024dd08ca0fSmistachkin 
3025f20b21c8Sdanielk1977 const char *sqlite3ErrStr(int);
30268a41449eSdanielk1977 int sqlite3ReadSchema(Parse *pParse);
3027c4a64facSdrh CollSeq *sqlite3FindCollSeq(sqlite3*,u8 enc, const char*,int);
3028c4a64facSdrh CollSeq *sqlite3LocateCollSeq(Parse *pParse, const char*zName);
30297cedc8d4Sdanielk1977 CollSeq *sqlite3ExprCollSeq(Parse *pParse, Expr *pExpr);
30300a8a406eSdrh Expr *sqlite3ExprAddCollateToken(Parse *pParse, Expr*, Token*);
30310a8a406eSdrh Expr *sqlite3ExprAddCollateString(Parse*,Expr*,const char*);
30320a8a406eSdrh Expr *sqlite3ExprSkipCollate(Expr*);
30337cedc8d4Sdanielk1977 int sqlite3CheckCollSeq(Parse *, CollSeq *);
3034d8123366Sdanielk1977 int sqlite3CheckObjectName(Parse *, const char *);
3035b28af71aSdanielk1977 void sqlite3VdbeSetChanges(sqlite3 *, int);
3036158b9cb9Sdrh int sqlite3AddInt64(i64*,i64);
3037158b9cb9Sdrh int sqlite3SubInt64(i64*,i64);
3038158b9cb9Sdrh int sqlite3MulInt64(i64*,i64);
3039d50ffc41Sdrh int sqlite3AbsInt32(int);
304081cc5163Sdrh #ifdef SQLITE_ENABLE_8_3_NAMES
304181cc5163Sdrh void sqlite3FileSuffix3(const char*, char*);
304281cc5163Sdrh #else
304381cc5163Sdrh # define sqlite3FileSuffix3(X,Y)
304481cc5163Sdrh #endif
304538d9c612Sdrh u8 sqlite3GetBoolean(const char *z,int);
30464e6af134Sdanielk1977 
3047b21c8cd4Sdrh const void *sqlite3ValueText(sqlite3_value*, u8);
3048b21c8cd4Sdrh int sqlite3ValueBytes(sqlite3_value*, u8);
3049b21c8cd4Sdrh void sqlite3ValueSetStr(sqlite3_value*, int, const void *,u8,
30501e536953Sdanielk1977                         void(*)(void*));
30514e6af134Sdanielk1977 void sqlite3ValueFree(sqlite3_value*);
30521e536953Sdanielk1977 sqlite3_value *sqlite3ValueNew(sqlite3 *);
3053b7dca7d7Sdan char *sqlite3Utf16to8(sqlite3 *, const void*, int, u8);
30541e536953Sdanielk1977 int sqlite3ValueFromExpr(sqlite3 *, Expr *, u8, u8, sqlite3_value **);
3055b21c8cd4Sdrh void sqlite3ValueApplyAffinity(sqlite3_value *, u8, u8);
305646c99e0fSdrh #ifndef SQLITE_AMALGAMATION
3057a6c2ed91Sdrh extern const unsigned char sqlite3OpcodeProperty[];
30584e5ffc5fSdrh extern const unsigned char sqlite3UpperToLower[];
305978ca0e7eSdanielk1977 extern const unsigned char sqlite3CtypeMap[];
3060094430ebSdrh extern const Token sqlite3IntTokens[];
3061075c23afSdanielk1977 extern SQLITE_WSD struct Sqlite3Config sqlite3Config;
3062075c23afSdanielk1977 extern SQLITE_WSD FuncDefHash sqlite3GlobalFunctions;
3063f83dc1efSdrh #ifndef SQLITE_OMIT_WSD
3064ddb68e17Sdrh extern int sqlite3PendingByte;
306546c99e0fSdrh #endif
3066f83dc1efSdrh #endif
3067cdf011dcSdrh void sqlite3RootPageMoved(sqlite3*, int, int, int);
30684343fea2Sdrh void sqlite3Reindex(Parse*, Token*, Token*);
3069545f587fSdrh void sqlite3AlterFunctions(void);
30709fd2a9a0Sdanielk1977 void sqlite3AlterRenameTable(Parse*, SrcList*, Token*);
30719fd2a9a0Sdanielk1977 int sqlite3GetToken(const unsigned char *, int *);
30722958a4e6Sdrh void sqlite3NestedParse(Parse*, const char*, ...);
3073d89bd007Sdrh void sqlite3ExpirePreparedStatements(sqlite3*);
30741450bc6eSdrh int sqlite3CodeSubselect(Parse *, Expr *, int, int);
30757d10d5a6Sdrh void sqlite3SelectPrep(Parse*, Select*, NameContext*);
30763e3f1a5bSdrh int sqlite3MatchSpanName(const char*, const char*, const char*, const char*);
30777d10d5a6Sdrh int sqlite3ResolveExprNames(NameContext*, Expr*);
30787d10d5a6Sdrh void sqlite3ResolveSelectNames(Parse*, Select*, NameContext*);
30793780be11Sdrh void sqlite3ResolveSelfReference(Parse*,Table*,int,Expr*,ExprList*);
30807d10d5a6Sdrh int sqlite3ResolveOrderGroupBy(Parse*, Select*, ExprList*, const char*);
3081c7538b5fSdanielk1977 void sqlite3ColumnDefault(Vdbe *, Table *, int, int);
308219a8e7e8Sdanielk1977 void sqlite3AlterFinishAddColumn(Parse *, Token *);
308319a8e7e8Sdanielk1977 void sqlite3AlterBeginAddColumn(Parse *, SrcList *);
308479e72a50Sdrh CollSeq *sqlite3GetCollSeq(Parse*, u8, CollSeq *, const char*);
3085b7916a78Sdrh char sqlite3AffinityType(const char*);
30869f18e8a0Sdrh void sqlite3Analyze(Parse*, Token*, Token*);
3087a4afb65cSdrh int sqlite3InvokeBusyHandler(BusyHandler*);
3088ff2d5ea4Sdrh int sqlite3FindDb(sqlite3*, Token*);
30890410302eSdanielk1977 int sqlite3FindDbName(sqlite3 *, const char *);
3090cf1be45fSdrh int sqlite3AnalysisLoad(sqlite3*,int iDB);
3091d46def77Sdan void sqlite3DeleteIndexSamples(sqlite3*,Index*);
309251147baaSdrh void sqlite3DefaultRowEst(Index*);
309355ef4d97Sdrh void sqlite3RegisterLikeFunctions(sqlite3*, int);
3094d64fe2f3Sdrh int sqlite3IsLikeFunction(sqlite3*,Expr*,int*,char*);
3095fdd6e85aSdrh void sqlite3MinimumFileFormat(Parse*, int, int);
3096b6ee6607Sdrh void sqlite3SchemaClear(void *);
30971e536953Sdanielk1977 Schema *sqlite3SchemaGet(sqlite3 *, Btree *);
3098e501b89aSdanielk1977 int sqlite3SchemaToIndex(sqlite3 *db, Schema *);
3099323df790Sdrh KeyInfo *sqlite3KeyInfoAlloc(sqlite3*,int);
3100b3bf556eSdanielk1977 KeyInfo *sqlite3IndexKeyinfo(Parse *, Index *);
3101771151b6Sdanielk1977 int sqlite3CreateFunc(sqlite3 *, const char *, int, int, void *,
3102771151b6Sdanielk1977   void (*)(sqlite3_context*,int,sqlite3_value **),
3103d2199f0fSdan   void (*)(sqlite3_context*,int,sqlite3_value **), void (*)(sqlite3_context*),
3104d2199f0fSdan   FuncDestructor *pDestructor
3105d2199f0fSdan );
310654f0198eSdanielk1977 int sqlite3ApiExit(sqlite3 *db, int);
3107ddfb2f03Sdanielk1977 int sqlite3OpenTempDatabase(Parse *);
310869dab1d3Sdrh 
3109f089aa45Sdrh void sqlite3StrAccumInit(StrAccum*, char*, int, int);
3110ade86483Sdrh void sqlite3StrAccumAppend(StrAccum*,const char*,int);
31117e02e5e6Sdrh void sqlite3AppendSpace(StrAccum*,int);
3112ade86483Sdrh char *sqlite3StrAccumFinish(StrAccum*);
3113ade86483Sdrh void sqlite3StrAccumReset(StrAccum*);
31141013c932Sdrh void sqlite3SelectDestInit(SelectDest*,int,int);
3115f7b0b0adSdan Expr *sqlite3CreateColumnExpr(sqlite3 *, SrcList *, int, int);
31161e536953Sdanielk1977 
31170410302eSdanielk1977 void sqlite3BackupRestart(sqlite3_backup *);
31180410302eSdanielk1977 void sqlite3BackupUpdate(sqlite3_backup *, Pgno, const u8 *);
31190410302eSdanielk1977 
31201435a9a1Sdrh #ifdef SQLITE_ENABLE_STAT3_OR_STAT4
31219fecc546Sdrh void sqlite3AnalyzeFunctions(void);
312287cd9321Sdan int sqlite3Stat4ProbeSetValue(Parse*,Index*,UnpackedRecord**,Expr*,u8,int,int*);
31237a419235Sdan void sqlite3Stat4ProbeFree(UnpackedRecord*);
31249fecc546Sdrh #endif
31257a419235Sdan 
312695bdbbbdSdrh /*
312795bdbbbdSdrh ** The interface to the LEMON-generated parser
312895bdbbbdSdrh */
312995bdbbbdSdrh void *sqlite3ParserAlloc(void*(*)(size_t));
313095bdbbbdSdrh void sqlite3ParserFree(void*, void(*)(void*));
313195bdbbbdSdrh void sqlite3Parser(void*, int, Token, Parse*);
3132ec424a5bSdrh #ifdef YYTRACKMAXSTACKDEPTH
3133ec424a5bSdrh   int sqlite3ParserStackPeak(void*);
3134ec424a5bSdrh #endif
313595bdbbbdSdrh 
31367aaa8786Sdrh void sqlite3AutoLoadExtensions(sqlite3*);
313769dab1d3Sdrh #ifndef SQLITE_OMIT_LOAD_EXTENSION
3138f1952c5dSdrh   void sqlite3CloseExtensions(sqlite3*);
313969dab1d3Sdrh #else
314069dab1d3Sdrh # define sqlite3CloseExtensions(X)
314169dab1d3Sdrh #endif
3142e3026636Sdanielk1977 
3143c00da105Sdanielk1977 #ifndef SQLITE_OMIT_SHARED_CACHE
3144c00da105Sdanielk1977   void sqlite3TableLock(Parse *, int, int, u8, const char *);
3145c00da105Sdanielk1977 #else
3146c00da105Sdanielk1977   #define sqlite3TableLock(v,w,x,y,z)
3147c00da105Sdanielk1977 #endif
3148c00da105Sdanielk1977 
314953c14021Sdrh #ifdef SQLITE_TEST
315053c14021Sdrh   int sqlite3Utf8To8(unsigned char*);
315153c14021Sdrh #endif
315253c14021Sdrh 
3153b9bb7c18Sdrh #ifdef SQLITE_OMIT_VIRTUALTABLE
3154595a523aSdanielk1977 #  define sqlite3VtabClear(Y)
31559dbee7dcSdanielk1977 #  define sqlite3VtabSync(X,Y) SQLITE_OK
3156f9e7dda7Sdanielk1977 #  define sqlite3VtabRollback(X)
3157f9e7dda7Sdanielk1977 #  define sqlite3VtabCommit(X)
3158093e0f6fSdanielk1977 #  define sqlite3VtabInSync(db) 0
3159595a523aSdanielk1977 #  define sqlite3VtabLock(X)
3160595a523aSdanielk1977 #  define sqlite3VtabUnlock(X)
3161595a523aSdanielk1977 #  define sqlite3VtabUnlockList(X)
3162a311b803Sdan #  define sqlite3VtabSavepoint(X, Y, Z) SQLITE_OK
3163c3c8dac7Sdrh #  define sqlite3GetVTable(X,Y)  ((VTable*)0)
3164b9bb7c18Sdrh #else
31651feeaed2Sdan    void sqlite3VtabClear(sqlite3 *db, Table*);
3166bba02a95Sdan    void sqlite3VtabDisconnect(sqlite3 *db, Table *p);
3167016f7811Sdan    int sqlite3VtabSync(sqlite3 *db, Vdbe*);
3168f9e7dda7Sdanielk1977    int sqlite3VtabRollback(sqlite3 *db);
3169f9e7dda7Sdanielk1977    int sqlite3VtabCommit(sqlite3 *db);
3170595a523aSdanielk1977    void sqlite3VtabLock(VTable *);
3171595a523aSdanielk1977    void sqlite3VtabUnlock(VTable *);
3172595a523aSdanielk1977    void sqlite3VtabUnlockList(sqlite3*);
3173a311b803Sdan    int sqlite3VtabSavepoint(sqlite3 *, int, int);
3174016f7811Sdan    void sqlite3VtabImportErrmsg(Vdbe*, sqlite3_vtab*);
3175c3c8dac7Sdrh    VTable *sqlite3GetVTable(sqlite3*, Table*);
3176093e0f6fSdanielk1977 #  define sqlite3VtabInSync(db) ((db)->nVTrans>0 && (db)->aVTrans==0)
3177b9bb7c18Sdrh #endif
31784f3dd150Sdrh void sqlite3VtabMakeWritable(Parse*,Table*);
3179b421b894Sdrh void sqlite3VtabBeginParse(Parse*, Token*, Token*, Token*, int);
3180b9bb7c18Sdrh void sqlite3VtabFinishParse(Parse*, Token*);
3181b9bb7c18Sdrh void sqlite3VtabArgInit(Parse*);
3182b9bb7c18Sdrh void sqlite3VtabArgExtend(Parse*, Token*);
318378efaba1Sdanielk1977 int sqlite3VtabCallCreate(sqlite3*, int, const char *, char **);
31847e6ebfb2Sdanielk1977 int sqlite3VtabCallConnect(Parse*, Table*);
31859e39ce87Sdanielk1977 int sqlite3VtabCallDestroy(sqlite3*, int, const char *);
3186595a523aSdanielk1977 int sqlite3VtabBegin(sqlite3 *, VTable *);
31871e536953Sdanielk1977 FuncDef *sqlite3VtabOverloadFunction(sqlite3 *,FuncDef*, int nArg, Expr*);
3188b7481e70Sdrh void sqlite3InvalidFunction(sqlite3_context*,int,sqlite3_value**);
318995a7b3e3Sdrh sqlite3_int64 sqlite3StmtCurrentTime(sqlite3_context*);
31905f18a221Sdrh int sqlite3VdbeParameterIndex(Vdbe*, const char*, int);
31914a27a286Sshane int sqlite3TransferBindings(sqlite3_stmt *, sqlite3_stmt *);
3192b900aaf3Sdrh int sqlite3Reprepare(Vdbe*);
3193b1a6c3c1Sdrh void sqlite3ExprListCheckLength(Parse*, ExprList*, const char*);
3194bcbb04e5Sdanielk1977 CollSeq *sqlite3BinaryCompareCollSeq(Parse *, Expr *, Expr *);
31951c514148Sdrh int sqlite3TempInMemory(const sqlite3*);
319628e5386fSdan const char *sqlite3JournalModename(int);
319706a2d825Sdan #ifndef SQLITE_OMIT_WAL
3198cdc1f049Sdan   int sqlite3Checkpoint(sqlite3*, int, int, int*, int*);
3199b033d8b9Sdrh   int sqlite3WalDefaultHook(void*,sqlite3*,const char*,int);
320006a2d825Sdan #endif
3201d829335eSdanielk1977 
320275cbd984Sdan /* Declarations for functions in fkey.c. All of these are replaced by
320375cbd984Sdan ** no-op macros if OMIT_FOREIGN_KEY is defined. In this case no foreign
320475cbd984Sdan ** key functionality is available. If OMIT_TRIGGER is defined but
320575cbd984Sdan ** OMIT_FOREIGN_KEY is not, only some of the functions are no-oped. In
320675cbd984Sdan ** this case foreign keys are parsed, but no other functionality is
320775cbd984Sdan ** provided (enforcement of FK constraints requires the triggers sub-system).
320875cbd984Sdan */
320975cbd984Sdan #if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
32108ff2d956Sdan   void sqlite3FkCheck(Parse*, Table*, int, int, int*, int);
3211d66c8309Sdan   void sqlite3FkDropTable(Parse*, SrcList *, Table*);
32128ff2d956Sdan   void sqlite3FkActions(Parse*, Table*, ExprList*, int, int*, int);
3213e7a94d81Sdan   int sqlite3FkRequired(Parse*, Table*, int*, int);
3214e7a94d81Sdan   u32 sqlite3FkOldmask(Parse*, Table*);
3215432cc5b9Sdan   FKey *sqlite3FkReferences(Table *);
32161da40a38Sdan #else
32178ff2d956Sdan   #define sqlite3FkActions(a,b,c,d,e,f)
3218e7a94d81Sdan   #define sqlite3FkCheck(a,b,c,d)
3219d66c8309Sdan   #define sqlite3FkDropTable(a,b,c)
3220e7a94d81Sdan   #define sqlite3FkOldmask(a,b)          0
32218ff2d956Sdan   #define sqlite3FkRequired(a,b,c,d,e,f) 0
32221da40a38Sdan #endif
322375cbd984Sdan #ifndef SQLITE_OMIT_FOREIGN_KEY
32241feeaed2Sdan   void sqlite3FkDelete(sqlite3 *, Table*);
32256c5b915fSdrh   int sqlite3FkLocateIndex(Parse*,Table*,FKey*,Index**,int**);
322675cbd984Sdan #else
32271feeaed2Sdan   #define sqlite3FkDelete(a,b)
32286c5b915fSdrh   #define sqlite3FkLocateIndex(a,b,c,d,e)
322975cbd984Sdan #endif
323075cbd984Sdan 
3231643167ffSdrh 
3232643167ffSdrh /*
3233643167ffSdrh ** Available fault injectors.  Should be numbered beginning with 0.
3234643167ffSdrh */
3235643167ffSdrh #define SQLITE_FAULTINJECTOR_MALLOC     0
32367e8b848aSdrh #define SQLITE_FAULTINJECTOR_COUNT      1
3237643167ffSdrh 
3238643167ffSdrh /*
3239ef05f2dfSdanielk1977 ** The interface to the code in fault.c used for identifying "benign"
3240ef05f2dfSdanielk1977 ** malloc failures. This is only present if SQLITE_OMIT_BUILTIN_TEST
3241ef05f2dfSdanielk1977 ** is not defined.
3242643167ffSdrh */
32433088d59eSdrh #ifndef SQLITE_OMIT_BUILTIN_TEST
32442d1d86fbSdanielk1977   void sqlite3BeginBenignMalloc(void);
32452d1d86fbSdanielk1977   void sqlite3EndBenignMalloc(void);
3246643167ffSdrh #else
32472d1d86fbSdanielk1977   #define sqlite3BeginBenignMalloc()
3248867d05a0Sdanielk1977   #define sqlite3EndBenignMalloc()
3249643167ffSdrh #endif
3250643167ffSdrh 
32519a96b668Sdanielk1977 #define IN_INDEX_ROWID           1
32529a96b668Sdanielk1977 #define IN_INDEX_EPH             2
32531ccce449Sdrh #define IN_INDEX_INDEX_ASC       3
32541ccce449Sdrh #define IN_INDEX_INDEX_DESC      4
32550cdc022eSdanielk1977 int sqlite3FindInIndex(Parse *, Expr *, int*);
32569a96b668Sdanielk1977 
3257c7b6017cSdanielk1977 #ifdef SQLITE_ENABLE_ATOMIC_WRITE
3258c7b6017cSdanielk1977   int sqlite3JournalOpen(sqlite3_vfs *, const char *, sqlite3_file *, int, int);
3259c7b6017cSdanielk1977   int sqlite3JournalSize(sqlite3_vfs *);
3260f55b8998Sdanielk1977   int sqlite3JournalCreate(sqlite3_file *);
32613de0f184Sdan   int sqlite3JournalExists(sqlite3_file *p);
3262c7b6017cSdanielk1977 #else
3263c7b6017cSdanielk1977   #define sqlite3JournalSize(pVfs) ((pVfs)->szOsFile)
32643de0f184Sdan   #define sqlite3JournalExists(p) 1
3265c7b6017cSdanielk1977 #endif
3266c7b6017cSdanielk1977 
3267b3175389Sdanielk1977 void sqlite3MemJournalOpen(sqlite3_file *);
32683a5990abSdrh int sqlite3MemJournalSize(void);
3269b3175389Sdanielk1977 int sqlite3IsMemJournal(sqlite3_file *);
3270b3175389Sdanielk1977 
32710224d26dSdrh #if SQLITE_MAX_EXPR_DEPTH>0
32724b5255acSdanielk1977   void sqlite3ExprSetHeight(Parse *pParse, Expr *p);
3273fc976065Sdanielk1977   int sqlite3SelectExprHeight(Select *);
32747d10d5a6Sdrh   int sqlite3ExprCheckHeight(Parse*, int);
3275fc976065Sdanielk1977 #else
32764b5255acSdanielk1977   #define sqlite3ExprSetHeight(x,y)
32770224d26dSdrh   #define sqlite3SelectExprHeight(x) 0
32787d10d5a6Sdrh   #define sqlite3ExprCheckHeight(x,y)
3279fc976065Sdanielk1977 #endif
3280fc976065Sdanielk1977 
3281a3152895Sdrh u32 sqlite3Get4byte(const u8*);
3282a3152895Sdrh void sqlite3Put4byte(u8*, u32);
3283a3152895Sdrh 
3284404ca075Sdanielk1977 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
3285404ca075Sdanielk1977   void sqlite3ConnectionBlocked(sqlite3 *, sqlite3 *);
3286404ca075Sdanielk1977   void sqlite3ConnectionUnlocked(sqlite3 *db);
3287404ca075Sdanielk1977   void sqlite3ConnectionClosed(sqlite3 *db);
3288404ca075Sdanielk1977 #else
3289404ca075Sdanielk1977   #define sqlite3ConnectionBlocked(x,y)
3290404ca075Sdanielk1977   #define sqlite3ConnectionUnlocked(x)
3291404ca075Sdanielk1977   #define sqlite3ConnectionClosed(x)
3292404ca075Sdanielk1977 #endif
3293404ca075Sdanielk1977 
32946e736838Sdrh #ifdef SQLITE_DEBUG
32956e736838Sdrh   void sqlite3ParserTrace(FILE*, char *);
32966e736838Sdrh #endif
32976e736838Sdrh 
3298b0603416Sdrh /*
3299b0603416Sdrh ** If the SQLITE_ENABLE IOTRACE exists then the global variable
33003a00f907Smlcreech ** sqlite3IoTrace is a pointer to a printf-like routine used to
3301b0603416Sdrh ** print I/O tracing messages.
3302b0603416Sdrh */
3303b0603416Sdrh #ifdef SQLITE_ENABLE_IOTRACE
33043a00f907Smlcreech # define IOTRACE(A)  if( sqlite3IoTrace ){ sqlite3IoTrace A; }
3305b4622b60Sdanielk1977   void sqlite3VdbeIOTraceSql(Vdbe*);
3306e265b084Sdrh SQLITE_EXTERN void (*sqlite3IoTrace)(const char*,...);
3307b0603416Sdrh #else
3308b0603416Sdrh # define IOTRACE(A)
3309b4622b60Sdanielk1977 # define sqlite3VdbeIOTraceSql(X)
3310b0603416Sdrh #endif
3311b0603416Sdrh 
3312107b56e8Sdrh /*
3313107b56e8Sdrh ** These routines are available for the mem2.c debugging memory allocator
3314107b56e8Sdrh ** only.  They are used to verify that different "types" of memory
3315107b56e8Sdrh ** allocations are properly tracked by the system.
3316107b56e8Sdrh **
3317107b56e8Sdrh ** sqlite3MemdebugSetType() sets the "type" of an allocation to one of
3318107b56e8Sdrh ** the MEMTYPE_* macros defined below.  The type must be a bitmask with
3319107b56e8Sdrh ** a single bit set.
3320107b56e8Sdrh **
3321107b56e8Sdrh ** sqlite3MemdebugHasType() returns true if any of the bits in its second
3322107b56e8Sdrh ** argument match the type set by the previous sqlite3MemdebugSetType().
3323107b56e8Sdrh ** sqlite3MemdebugHasType() is intended for use inside assert() statements.
3324107b56e8Sdrh **
3325174b9a16Sdrh ** sqlite3MemdebugNoType() returns true if none of the bits in its second
3326174b9a16Sdrh ** argument match the type set by the previous sqlite3MemdebugSetType().
3327107b56e8Sdrh **
3328107b56e8Sdrh ** Perhaps the most important point is the difference between MEMTYPE_HEAP
3329174b9a16Sdrh ** and MEMTYPE_LOOKASIDE.  If an allocation is MEMTYPE_LOOKASIDE, that means
3330174b9a16Sdrh ** it might have been allocated by lookaside, except the allocation was
3331174b9a16Sdrh ** too large or lookaside was already full.  It is important to verify
3332174b9a16Sdrh ** that allocations that might have been satisfied by lookaside are not
3333174b9a16Sdrh ** passed back to non-lookaside free() routines.  Asserts such as the
3334174b9a16Sdrh ** example above are placed on the non-lookaside free() routines to verify
3335174b9a16Sdrh ** this constraint.
3336107b56e8Sdrh **
3337107b56e8Sdrh ** All of this is no-op for a production build.  It only comes into
3338107b56e8Sdrh ** play when the SQLITE_MEMDEBUG compile-time option is used.
3339107b56e8Sdrh */
3340107b56e8Sdrh #ifdef SQLITE_MEMDEBUG
3341107b56e8Sdrh   void sqlite3MemdebugSetType(void*,u8);
3342107b56e8Sdrh   int sqlite3MemdebugHasType(void*,u8);
3343174b9a16Sdrh   int sqlite3MemdebugNoType(void*,u8);
3344107b56e8Sdrh #else
3345107b56e8Sdrh # define sqlite3MemdebugSetType(X,Y)  /* no-op */
3346107b56e8Sdrh # define sqlite3MemdebugHasType(X,Y)  1
3347174b9a16Sdrh # define sqlite3MemdebugNoType(X,Y)   1
3348e3026636Sdanielk1977 #endif
3349107b56e8Sdrh #define MEMTYPE_HEAP       0x01  /* General heap allocations */
3350174b9a16Sdrh #define MEMTYPE_LOOKASIDE  0x02  /* Might have been lookaside memory */
3351107b56e8Sdrh #define MEMTYPE_SCRATCH    0x04  /* Scratch allocations */
3352107b56e8Sdrh #define MEMTYPE_PCACHE     0x08  /* Page cache allocations */
3353174b9a16Sdrh #define MEMTYPE_DB         0x10  /* Uses sqlite3DbMalloc, not sqlite_malloc */
3354107b56e8Sdrh 
3355107b56e8Sdrh #endif /* _SQLITEINT_H_ */
3356