xref: /sqlite-3.40.0/src/sqliteInt.h (revision 0f801707)
1 /*
2 ** 2001 September 15
3 **
4 ** The author disclaims copyright to this source code.  In place of
5 ** a legal notice, here is a blessing:
6 **
7 **    May you do good and not evil.
8 **    May you find forgiveness for yourself and forgive others.
9 **    May you share freely, never taking more than you give.
10 **
11 *************************************************************************
12 ** Internal interface definitions for SQLite.
13 **
14 */
15 #ifndef _SQLITEINT_H_
16 #define _SQLITEINT_H_
17 
18 /*
19 ** These #defines should enable >2GB file support on POSIX if the
20 ** underlying operating system supports it.  If the OS lacks
21 ** large file support, or if the OS is windows, these should be no-ops.
22 **
23 ** Ticket #2739:  The _LARGEFILE_SOURCE macro must appear before any
24 ** system #includes.  Hence, this block of code must be the very first
25 ** code in all source files.
26 **
27 ** Large file support can be disabled using the -DSQLITE_DISABLE_LFS switch
28 ** on the compiler command line.  This is necessary if you are compiling
29 ** on a recent machine (ex: Red Hat 7.2) but you want your code to work
30 ** on an older machine (ex: Red Hat 6.0).  If you compile on Red Hat 7.2
31 ** without this option, LFS is enable.  But LFS does not exist in the kernel
32 ** in Red Hat 6.0, so the code won't work.  Hence, for maximum binary
33 ** portability you should omit LFS.
34 **
35 ** Similar is true for Mac OS X.  LFS is only supported on Mac OS X 9 and later.
36 */
37 #ifndef SQLITE_DISABLE_LFS
38 # define _LARGE_FILE       1
39 # ifndef _FILE_OFFSET_BITS
40 #   define _FILE_OFFSET_BITS 64
41 # endif
42 # define _LARGEFILE_SOURCE 1
43 #endif
44 
45 /*
46 ** Include the configuration header output by 'configure' if we're using the
47 ** autoconf-based build
48 */
49 #ifdef _HAVE_SQLITE_CONFIG_H
50 #include "config.h"
51 #endif
52 
53 #include "sqliteLimit.h"
54 
55 /* Disable nuisance warnings on Borland compilers */
56 #if defined(__BORLANDC__)
57 #pragma warn -rch /* unreachable code */
58 #pragma warn -ccc /* Condition is always true or false */
59 #pragma warn -aus /* Assigned value is never used */
60 #pragma warn -csu /* Comparing signed and unsigned */
61 #pragma warn -spa /* Suspicious pointer arithmetic */
62 #endif
63 
64 /* Needed for various definitions... */
65 #ifndef _GNU_SOURCE
66 # define _GNU_SOURCE
67 #endif
68 
69 /*
70 ** Include standard header files as necessary
71 */
72 #ifdef HAVE_STDINT_H
73 #include <stdint.h>
74 #endif
75 #ifdef HAVE_INTTYPES_H
76 #include <inttypes.h>
77 #endif
78 
79 /*
80 ** The following macros are used to cast pointers to integers and
81 ** integers to pointers.  The way you do this varies from one compiler
82 ** to the next, so we have developed the following set of #if statements
83 ** to generate appropriate macros for a wide range of compilers.
84 **
85 ** The correct "ANSI" way to do this is to use the intptr_t type.
86 ** Unfortunately, that typedef is not available on all compilers, or
87 ** if it is available, it requires an #include of specific headers
88 ** that vary from one machine to the next.
89 **
90 ** Ticket #3860:  The llvm-gcc-4.2 compiler from Apple chokes on
91 ** the ((void*)&((char*)0)[X]) construct.  But MSVC chokes on ((void*)(X)).
92 ** So we have to define the macros in different ways depending on the
93 ** compiler.
94 */
95 #if defined(__PTRDIFF_TYPE__)  /* This case should work for GCC */
96 # define SQLITE_INT_TO_PTR(X)  ((void*)(__PTRDIFF_TYPE__)(X))
97 # define SQLITE_PTR_TO_INT(X)  ((int)(__PTRDIFF_TYPE__)(X))
98 #elif !defined(__GNUC__)       /* Works for compilers other than LLVM */
99 # define SQLITE_INT_TO_PTR(X)  ((void*)&((char*)0)[X])
100 # define SQLITE_PTR_TO_INT(X)  ((int)(((char*)X)-(char*)0))
101 #elif defined(HAVE_STDINT_H)   /* Use this case if we have ANSI headers */
102 # define SQLITE_INT_TO_PTR(X)  ((void*)(intptr_t)(X))
103 # define SQLITE_PTR_TO_INT(X)  ((int)(intptr_t)(X))
104 #else                          /* Generates a warning - but it always works */
105 # define SQLITE_INT_TO_PTR(X)  ((void*)(X))
106 # define SQLITE_PTR_TO_INT(X)  ((int)(X))
107 #endif
108 
109 /*
110 ** The SQLITE_THREADSAFE macro must be defined as 0, 1, or 2.
111 ** 0 means mutexes are permanently disable and the library is never
112 ** threadsafe.  1 means the library is serialized which is the highest
113 ** level of threadsafety.  2 means the libary is multithreaded - multiple
114 ** threads can use SQLite as long as no two threads try to use the same
115 ** database connection at the same time.
116 **
117 ** Older versions of SQLite used an optional THREADSAFE macro.
118 ** We support that for legacy.
119 */
120 #if !defined(SQLITE_THREADSAFE)
121 #if defined(THREADSAFE)
122 # define SQLITE_THREADSAFE THREADSAFE
123 #else
124 # define SQLITE_THREADSAFE 1 /* IMP: R-07272-22309 */
125 #endif
126 #endif
127 
128 /*
129 ** Powersafe overwrite is on by default.  But can be turned off using
130 ** the -DSQLITE_POWERSAFE_OVERWRITE=0 command-line option.
131 */
132 #ifndef SQLITE_POWERSAFE_OVERWRITE
133 # define SQLITE_POWERSAFE_OVERWRITE 1
134 #endif
135 
136 /*
137 ** The SQLITE_DEFAULT_MEMSTATUS macro must be defined as either 0 or 1.
138 ** It determines whether or not the features related to
139 ** SQLITE_CONFIG_MEMSTATUS are available by default or not. This value can
140 ** be overridden at runtime using the sqlite3_config() API.
141 */
142 #if !defined(SQLITE_DEFAULT_MEMSTATUS)
143 # define SQLITE_DEFAULT_MEMSTATUS 1
144 #endif
145 
146 /*
147 ** Exactly one of the following macros must be defined in order to
148 ** specify which memory allocation subsystem to use.
149 **
150 **     SQLITE_SYSTEM_MALLOC          // Use normal system malloc()
151 **     SQLITE_WIN32_MALLOC           // Use Win32 native heap API
152 **     SQLITE_ZERO_MALLOC            // Use a stub allocator that always fails
153 **     SQLITE_MEMDEBUG               // Debugging version of system malloc()
154 **
155 ** On Windows, if the SQLITE_WIN32_MALLOC_VALIDATE macro is defined and the
156 ** assert() macro is enabled, each call into the Win32 native heap subsystem
157 ** will cause HeapValidate to be called.  If heap validation should fail, an
158 ** assertion will be triggered.
159 **
160 ** (Historical note:  There used to be several other options, but we've
161 ** pared it down to just these three.)
162 **
163 ** If none of the above are defined, then set SQLITE_SYSTEM_MALLOC as
164 ** the default.
165 */
166 #if defined(SQLITE_SYSTEM_MALLOC) \
167   + defined(SQLITE_WIN32_MALLOC) \
168   + defined(SQLITE_ZERO_MALLOC) \
169   + defined(SQLITE_MEMDEBUG)>1
170 # error "Two or more of the following compile-time configuration options\
171  are defined but at most one is allowed:\
172  SQLITE_SYSTEM_MALLOC, SQLITE_WIN32_MALLOC, SQLITE_MEMDEBUG,\
173  SQLITE_ZERO_MALLOC"
174 #endif
175 #if defined(SQLITE_SYSTEM_MALLOC) \
176   + defined(SQLITE_WIN32_MALLOC) \
177   + defined(SQLITE_ZERO_MALLOC) \
178   + defined(SQLITE_MEMDEBUG)==0
179 # define SQLITE_SYSTEM_MALLOC 1
180 #endif
181 
182 /*
183 ** If SQLITE_MALLOC_SOFT_LIMIT is not zero, then try to keep the
184 ** sizes of memory allocations below this value where possible.
185 */
186 #if !defined(SQLITE_MALLOC_SOFT_LIMIT)
187 # define SQLITE_MALLOC_SOFT_LIMIT 1024
188 #endif
189 
190 /*
191 ** We need to define _XOPEN_SOURCE as follows in order to enable
192 ** recursive mutexes on most Unix systems.  But Mac OS X is different.
193 ** The _XOPEN_SOURCE define causes problems for Mac OS X we are told,
194 ** so it is omitted there.  See ticket #2673.
195 **
196 ** Later we learn that _XOPEN_SOURCE is poorly or incorrectly
197 ** implemented on some systems.  So we avoid defining it at all
198 ** if it is already defined or if it is unneeded because we are
199 ** not doing a threadsafe build.  Ticket #2681.
200 **
201 ** See also ticket #2741.
202 */
203 #if !defined(_XOPEN_SOURCE) && !defined(__DARWIN__) && !defined(__APPLE__) && SQLITE_THREADSAFE
204 #  define _XOPEN_SOURCE 500  /* Needed to enable pthread recursive mutexes */
205 #endif
206 
207 /*
208 ** The TCL headers are only needed when compiling the TCL bindings.
209 */
210 #if defined(SQLITE_TCL) || defined(TCLSH)
211 # include <tcl.h>
212 #endif
213 
214 /*
215 ** NDEBUG and SQLITE_DEBUG are opposites.  It should always be true that
216 ** defined(NDEBUG)==!defined(SQLITE_DEBUG).  If this is not currently true,
217 ** make it true by defining or undefining NDEBUG.
218 **
219 ** Setting NDEBUG makes the code smaller and run faster by disabling the
220 ** number assert() statements in the code.  So we want the default action
221 ** to be for NDEBUG to be set and NDEBUG to be undefined only if SQLITE_DEBUG
222 ** is set.  Thus NDEBUG becomes an opt-in rather than an opt-out
223 ** feature.
224 */
225 #if !defined(NDEBUG) && !defined(SQLITE_DEBUG)
226 # define NDEBUG 1
227 #endif
228 #if defined(NDEBUG) && defined(SQLITE_DEBUG)
229 # undef NDEBUG
230 #endif
231 
232 /*
233 ** The testcase() macro is used to aid in coverage testing.  When
234 ** doing coverage testing, the condition inside the argument to
235 ** testcase() must be evaluated both true and false in order to
236 ** get full branch coverage.  The testcase() macro is inserted
237 ** to help ensure adequate test coverage in places where simple
238 ** condition/decision coverage is inadequate.  For example, testcase()
239 ** can be used to make sure boundary values are tested.  For
240 ** bitmask tests, testcase() can be used to make sure each bit
241 ** is significant and used at least once.  On switch statements
242 ** where multiple cases go to the same block of code, testcase()
243 ** can insure that all cases are evaluated.
244 **
245 */
246 #ifdef SQLITE_COVERAGE_TEST
247   void sqlite3Coverage(int);
248 # define testcase(X)  if( X ){ sqlite3Coverage(__LINE__); }
249 #else
250 # define testcase(X)
251 #endif
252 
253 /*
254 ** The TESTONLY macro is used to enclose variable declarations or
255 ** other bits of code that are needed to support the arguments
256 ** within testcase() and assert() macros.
257 */
258 #if !defined(NDEBUG) || defined(SQLITE_COVERAGE_TEST)
259 # define TESTONLY(X)  X
260 #else
261 # define TESTONLY(X)
262 #endif
263 
264 /*
265 ** Sometimes we need a small amount of code such as a variable initialization
266 ** to setup for a later assert() statement.  We do not want this code to
267 ** appear when assert() is disabled.  The following macro is therefore
268 ** used to contain that setup code.  The "VVA" acronym stands for
269 ** "Verification, Validation, and Accreditation".  In other words, the
270 ** code within VVA_ONLY() will only run during verification processes.
271 */
272 #ifndef NDEBUG
273 # define VVA_ONLY(X)  X
274 #else
275 # define VVA_ONLY(X)
276 #endif
277 
278 /*
279 ** The ALWAYS and NEVER macros surround boolean expressions which
280 ** are intended to always be true or false, respectively.  Such
281 ** expressions could be omitted from the code completely.  But they
282 ** are included in a few cases in order to enhance the resilience
283 ** of SQLite to unexpected behavior - to make the code "self-healing"
284 ** or "ductile" rather than being "brittle" and crashing at the first
285 ** hint of unplanned behavior.
286 **
287 ** In other words, ALWAYS and NEVER are added for defensive code.
288 **
289 ** When doing coverage testing ALWAYS and NEVER are hard-coded to
290 ** be true and false so that the unreachable code then specify will
291 ** not be counted as untested code.
292 */
293 #if defined(SQLITE_COVERAGE_TEST)
294 # define ALWAYS(X)      (1)
295 # define NEVER(X)       (0)
296 #elif !defined(NDEBUG)
297 # define ALWAYS(X)      ((X)?1:(assert(0),0))
298 # define NEVER(X)       ((X)?(assert(0),1):0)
299 #else
300 # define ALWAYS(X)      (X)
301 # define NEVER(X)       (X)
302 #endif
303 
304 /*
305 ** Return true (non-zero) if the input is a integer that is too large
306 ** to fit in 32-bits.  This macro is used inside of various testcase()
307 ** macros to verify that we have tested SQLite for large-file support.
308 */
309 #define IS_BIG_INT(X)  (((X)&~(i64)0xffffffff)!=0)
310 
311 /*
312 ** The macro unlikely() is a hint that surrounds a boolean
313 ** expression that is usually false.  Macro likely() surrounds
314 ** a boolean expression that is usually true.  GCC is able to
315 ** use these hints to generate better code, sometimes.
316 */
317 #if defined(__GNUC__) && 0
318 # define likely(X)    __builtin_expect((X),1)
319 # define unlikely(X)  __builtin_expect((X),0)
320 #else
321 # define likely(X)    !!(X)
322 # define unlikely(X)  !!(X)
323 #endif
324 
325 #include "sqlite3.h"
326 #include "hash.h"
327 #include "parse.h"
328 #include <stdio.h>
329 #include <stdlib.h>
330 #include <string.h>
331 #include <assert.h>
332 #include <stddef.h>
333 
334 /*
335 ** If compiling for a processor that lacks floating point support,
336 ** substitute integer for floating-point
337 */
338 #ifdef SQLITE_OMIT_FLOATING_POINT
339 # define double sqlite_int64
340 # define float sqlite_int64
341 # define LONGDOUBLE_TYPE sqlite_int64
342 # ifndef SQLITE_BIG_DBL
343 #   define SQLITE_BIG_DBL (((sqlite3_int64)1)<<50)
344 # endif
345 # define SQLITE_OMIT_DATETIME_FUNCS 1
346 # define SQLITE_OMIT_TRACE 1
347 # undef SQLITE_MIXED_ENDIAN_64BIT_FLOAT
348 # undef SQLITE_HAVE_ISNAN
349 #endif
350 #ifndef SQLITE_BIG_DBL
351 # define SQLITE_BIG_DBL (1e99)
352 #endif
353 
354 /*
355 ** OMIT_TEMPDB is set to 1 if SQLITE_OMIT_TEMPDB is defined, or 0
356 ** afterward. Having this macro allows us to cause the C compiler
357 ** to omit code used by TEMP tables without messy #ifndef statements.
358 */
359 #ifdef SQLITE_OMIT_TEMPDB
360 #define OMIT_TEMPDB 1
361 #else
362 #define OMIT_TEMPDB 0
363 #endif
364 
365 /*
366 ** The "file format" number is an integer that is incremented whenever
367 ** the VDBE-level file format changes.  The following macros define the
368 ** the default file format for new databases and the maximum file format
369 ** that the library can read.
370 */
371 #define SQLITE_MAX_FILE_FORMAT 4
372 #ifndef SQLITE_DEFAULT_FILE_FORMAT
373 # define SQLITE_DEFAULT_FILE_FORMAT 4
374 #endif
375 
376 /*
377 ** Determine whether triggers are recursive by default.  This can be
378 ** changed at run-time using a pragma.
379 */
380 #ifndef SQLITE_DEFAULT_RECURSIVE_TRIGGERS
381 # define SQLITE_DEFAULT_RECURSIVE_TRIGGERS 0
382 #endif
383 
384 /*
385 ** Provide a default value for SQLITE_TEMP_STORE in case it is not specified
386 ** on the command-line
387 */
388 #ifndef SQLITE_TEMP_STORE
389 # define SQLITE_TEMP_STORE 1
390 #endif
391 
392 /*
393 ** GCC does not define the offsetof() macro so we'll have to do it
394 ** ourselves.
395 */
396 #ifndef offsetof
397 #define offsetof(STRUCTURE,FIELD) ((int)((char*)&((STRUCTURE*)0)->FIELD))
398 #endif
399 
400 /*
401 ** Check to see if this machine uses EBCDIC.  (Yes, believe it or
402 ** not, there are still machines out there that use EBCDIC.)
403 */
404 #if 'A' == '\301'
405 # define SQLITE_EBCDIC 1
406 #else
407 # define SQLITE_ASCII 1
408 #endif
409 
410 /*
411 ** Integers of known sizes.  These typedefs might change for architectures
412 ** where the sizes very.  Preprocessor macros are available so that the
413 ** types can be conveniently redefined at compile-type.  Like this:
414 **
415 **         cc '-DUINTPTR_TYPE=long long int' ...
416 */
417 #ifndef UINT32_TYPE
418 # ifdef HAVE_UINT32_T
419 #  define UINT32_TYPE uint32_t
420 # else
421 #  define UINT32_TYPE unsigned int
422 # endif
423 #endif
424 #ifndef UINT16_TYPE
425 # ifdef HAVE_UINT16_T
426 #  define UINT16_TYPE uint16_t
427 # else
428 #  define UINT16_TYPE unsigned short int
429 # endif
430 #endif
431 #ifndef INT16_TYPE
432 # ifdef HAVE_INT16_T
433 #  define INT16_TYPE int16_t
434 # else
435 #  define INT16_TYPE short int
436 # endif
437 #endif
438 #ifndef UINT8_TYPE
439 # ifdef HAVE_UINT8_T
440 #  define UINT8_TYPE uint8_t
441 # else
442 #  define UINT8_TYPE unsigned char
443 # endif
444 #endif
445 #ifndef INT8_TYPE
446 # ifdef HAVE_INT8_T
447 #  define INT8_TYPE int8_t
448 # else
449 #  define INT8_TYPE signed char
450 # endif
451 #endif
452 #ifndef LONGDOUBLE_TYPE
453 # define LONGDOUBLE_TYPE long double
454 #endif
455 typedef sqlite_int64 i64;          /* 8-byte signed integer */
456 typedef sqlite_uint64 u64;         /* 8-byte unsigned integer */
457 typedef UINT32_TYPE u32;           /* 4-byte unsigned integer */
458 typedef UINT16_TYPE u16;           /* 2-byte unsigned integer */
459 typedef INT16_TYPE i16;            /* 2-byte signed integer */
460 typedef UINT8_TYPE u8;             /* 1-byte unsigned integer */
461 typedef INT8_TYPE i8;              /* 1-byte signed integer */
462 
463 /*
464 ** SQLITE_MAX_U32 is a u64 constant that is the maximum u64 value
465 ** that can be stored in a u32 without loss of data.  The value
466 ** is 0x00000000ffffffff.  But because of quirks of some compilers, we
467 ** have to specify the value in the less intuitive manner shown:
468 */
469 #define SQLITE_MAX_U32  ((((u64)1)<<32)-1)
470 
471 /*
472 ** The datatype used to store estimates of the number of rows in a
473 ** table or index.  This is an unsigned integer type.  For 99.9% of
474 ** the world, a 32-bit integer is sufficient.  But a 64-bit integer
475 ** can be used at compile-time if desired.
476 */
477 #ifdef SQLITE_64BIT_STATS
478  typedef u64 tRowcnt;    /* 64-bit only if requested at compile-time */
479 #else
480  typedef u32 tRowcnt;    /* 32-bit is the default */
481 #endif
482 
483 /*
484 ** Macros to determine whether the machine is big or little endian,
485 ** evaluated at runtime.
486 */
487 #ifdef SQLITE_AMALGAMATION
488 const int sqlite3one = 1;
489 #else
490 extern const int sqlite3one;
491 #endif
492 #if defined(i386) || defined(__i386__) || defined(_M_IX86)\
493                              || defined(__x86_64) || defined(__x86_64__)
494 # define SQLITE_BIGENDIAN    0
495 # define SQLITE_LITTLEENDIAN 1
496 # define SQLITE_UTF16NATIVE  SQLITE_UTF16LE
497 #else
498 # define SQLITE_BIGENDIAN    (*(char *)(&sqlite3one)==0)
499 # define SQLITE_LITTLEENDIAN (*(char *)(&sqlite3one)==1)
500 # define SQLITE_UTF16NATIVE (SQLITE_BIGENDIAN?SQLITE_UTF16BE:SQLITE_UTF16LE)
501 #endif
502 
503 /*
504 ** Constants for the largest and smallest possible 64-bit signed integers.
505 ** These macros are designed to work correctly on both 32-bit and 64-bit
506 ** compilers.
507 */
508 #define LARGEST_INT64  (0xffffffff|(((i64)0x7fffffff)<<32))
509 #define SMALLEST_INT64 (((i64)-1) - LARGEST_INT64)
510 
511 /*
512 ** Round up a number to the next larger multiple of 8.  This is used
513 ** to force 8-byte alignment on 64-bit architectures.
514 */
515 #define ROUND8(x)     (((x)+7)&~7)
516 
517 /*
518 ** Round down to the nearest multiple of 8
519 */
520 #define ROUNDDOWN8(x) ((x)&~7)
521 
522 /*
523 ** Assert that the pointer X is aligned to an 8-byte boundary.  This
524 ** macro is used only within assert() to verify that the code gets
525 ** all alignment restrictions correct.
526 **
527 ** Except, if SQLITE_4_BYTE_ALIGNED_MALLOC is defined, then the
528 ** underlying malloc() implemention might return us 4-byte aligned
529 ** pointers.  In that case, only verify 4-byte alignment.
530 */
531 #ifdef SQLITE_4_BYTE_ALIGNED_MALLOC
532 # define EIGHT_BYTE_ALIGNMENT(X)   ((((char*)(X) - (char*)0)&3)==0)
533 #else
534 # define EIGHT_BYTE_ALIGNMENT(X)   ((((char*)(X) - (char*)0)&7)==0)
535 #endif
536 
537 
538 /*
539 ** An instance of the following structure is used to store the busy-handler
540 ** callback for a given sqlite handle.
541 **
542 ** The sqlite.busyHandler member of the sqlite struct contains the busy
543 ** callback for the database handle. Each pager opened via the sqlite
544 ** handle is passed a pointer to sqlite.busyHandler. The busy-handler
545 ** callback is currently invoked only from within pager.c.
546 */
547 typedef struct BusyHandler BusyHandler;
548 struct BusyHandler {
549   int (*xFunc)(void *,int);  /* The busy callback */
550   void *pArg;                /* First arg to busy callback */
551   int nBusy;                 /* Incremented with each busy call */
552 };
553 
554 /*
555 ** Name of the master database table.  The master database table
556 ** is a special table that holds the names and attributes of all
557 ** user tables and indices.
558 */
559 #define MASTER_NAME       "sqlite_master"
560 #define TEMP_MASTER_NAME  "sqlite_temp_master"
561 
562 /*
563 ** The root-page of the master database table.
564 */
565 #define MASTER_ROOT       1
566 
567 /*
568 ** The name of the schema table.
569 */
570 #define SCHEMA_TABLE(x)  ((!OMIT_TEMPDB)&&(x==1)?TEMP_MASTER_NAME:MASTER_NAME)
571 
572 /*
573 ** A convenience macro that returns the number of elements in
574 ** an array.
575 */
576 #define ArraySize(X)    ((int)(sizeof(X)/sizeof(X[0])))
577 
578 /*
579 ** The following value as a destructor means to use sqlite3DbFree().
580 ** The sqlite3DbFree() routine requires two parameters instead of the
581 ** one parameter that destructors normally want.  So we have to introduce
582 ** this magic value that the code knows to handle differently.  Any
583 ** pointer will work here as long as it is distinct from SQLITE_STATIC
584 ** and SQLITE_TRANSIENT.
585 */
586 #define SQLITE_DYNAMIC   ((sqlite3_destructor_type)sqlite3MallocSize)
587 
588 /*
589 ** When SQLITE_OMIT_WSD is defined, it means that the target platform does
590 ** not support Writable Static Data (WSD) such as global and static variables.
591 ** All variables must either be on the stack or dynamically allocated from
592 ** the heap.  When WSD is unsupported, the variable declarations scattered
593 ** throughout the SQLite code must become constants instead.  The SQLITE_WSD
594 ** macro is used for this purpose.  And instead of referencing the variable
595 ** directly, we use its constant as a key to lookup the run-time allocated
596 ** buffer that holds real variable.  The constant is also the initializer
597 ** for the run-time allocated buffer.
598 **
599 ** In the usual case where WSD is supported, the SQLITE_WSD and GLOBAL
600 ** macros become no-ops and have zero performance impact.
601 */
602 #ifdef SQLITE_OMIT_WSD
603   #define SQLITE_WSD const
604   #define GLOBAL(t,v) (*(t*)sqlite3_wsd_find((void*)&(v), sizeof(v)))
605   #define sqlite3GlobalConfig GLOBAL(struct Sqlite3Config, sqlite3Config)
606   int sqlite3_wsd_init(int N, int J);
607   void *sqlite3_wsd_find(void *K, int L);
608 #else
609   #define SQLITE_WSD
610   #define GLOBAL(t,v) v
611   #define sqlite3GlobalConfig sqlite3Config
612 #endif
613 
614 /*
615 ** The following macros are used to suppress compiler warnings and to
616 ** make it clear to human readers when a function parameter is deliberately
617 ** left unused within the body of a function. This usually happens when
618 ** a function is called via a function pointer. For example the
619 ** implementation of an SQL aggregate step callback may not use the
620 ** parameter indicating the number of arguments passed to the aggregate,
621 ** if it knows that this is enforced elsewhere.
622 **
623 ** When a function parameter is not used at all within the body of a function,
624 ** it is generally named "NotUsed" or "NotUsed2" to make things even clearer.
625 ** However, these macros may also be used to suppress warnings related to
626 ** parameters that may or may not be used depending on compilation options.
627 ** For example those parameters only used in assert() statements. In these
628 ** cases the parameters are named as per the usual conventions.
629 */
630 #define UNUSED_PARAMETER(x) (void)(x)
631 #define UNUSED_PARAMETER2(x,y) UNUSED_PARAMETER(x),UNUSED_PARAMETER(y)
632 
633 /*
634 ** Forward references to structures
635 */
636 typedef struct AggInfo AggInfo;
637 typedef struct AuthContext AuthContext;
638 typedef struct AutoincInfo AutoincInfo;
639 typedef struct Bitvec Bitvec;
640 typedef struct CollSeq CollSeq;
641 typedef struct Column Column;
642 typedef struct Db Db;
643 typedef struct Schema Schema;
644 typedef struct Expr Expr;
645 typedef struct ExprList ExprList;
646 typedef struct ExprSpan ExprSpan;
647 typedef struct FKey FKey;
648 typedef struct FuncDestructor FuncDestructor;
649 typedef struct FuncDef FuncDef;
650 typedef struct FuncDefHash FuncDefHash;
651 typedef struct IdList IdList;
652 typedef struct Index Index;
653 typedef struct IndexSample IndexSample;
654 typedef struct KeyClass KeyClass;
655 typedef struct KeyInfo KeyInfo;
656 typedef struct Lookaside Lookaside;
657 typedef struct LookasideSlot LookasideSlot;
658 typedef struct Module Module;
659 typedef struct NameContext NameContext;
660 typedef struct Parse Parse;
661 typedef struct RowSet RowSet;
662 typedef struct Savepoint Savepoint;
663 typedef struct Select Select;
664 typedef struct SelectDest SelectDest;
665 typedef struct SrcList SrcList;
666 typedef struct StrAccum StrAccum;
667 typedef struct Table Table;
668 typedef struct TableLock TableLock;
669 typedef struct Token Token;
670 typedef struct Trigger Trigger;
671 typedef struct TriggerPrg TriggerPrg;
672 typedef struct TriggerStep TriggerStep;
673 typedef struct UnpackedRecord UnpackedRecord;
674 typedef struct VTable VTable;
675 typedef struct VtabCtx VtabCtx;
676 typedef struct Walker Walker;
677 typedef struct WherePlan WherePlan;
678 typedef struct WhereInfo WhereInfo;
679 typedef struct WhereLevel WhereLevel;
680 
681 /*
682 ** Defer sourcing vdbe.h and btree.h until after the "u8" and
683 ** "BusyHandler" typedefs. vdbe.h also requires a few of the opaque
684 ** pointer types (i.e. FuncDef) defined above.
685 */
686 #include "btree.h"
687 #include "vdbe.h"
688 #include "pager.h"
689 #include "pcache.h"
690 
691 #include "os.h"
692 #include "mutex.h"
693 
694 
695 /*
696 ** Each database file to be accessed by the system is an instance
697 ** of the following structure.  There are normally two of these structures
698 ** in the sqlite.aDb[] array.  aDb[0] is the main database file and
699 ** aDb[1] is the database file used to hold temporary tables.  Additional
700 ** databases may be attached.
701 */
702 struct Db {
703   char *zName;         /* Name of this database */
704   Btree *pBt;          /* The B*Tree structure for this database file */
705   u8 inTrans;          /* 0: not writable.  1: Transaction.  2: Checkpoint */
706   u8 safety_level;     /* How aggressive at syncing data to disk */
707   Schema *pSchema;     /* Pointer to database schema (possibly shared) */
708 };
709 
710 /*
711 ** An instance of the following structure stores a database schema.
712 **
713 ** Most Schema objects are associated with a Btree.  The exception is
714 ** the Schema for the TEMP databaes (sqlite3.aDb[1]) which is free-standing.
715 ** In shared cache mode, a single Schema object can be shared by multiple
716 ** Btrees that refer to the same underlying BtShared object.
717 **
718 ** Schema objects are automatically deallocated when the last Btree that
719 ** references them is destroyed.   The TEMP Schema is manually freed by
720 ** sqlite3_close().
721 *
722 ** A thread must be holding a mutex on the corresponding Btree in order
723 ** to access Schema content.  This implies that the thread must also be
724 ** holding a mutex on the sqlite3 connection pointer that owns the Btree.
725 ** For a TEMP Schema, only the connection mutex is required.
726 */
727 struct Schema {
728   int schema_cookie;   /* Database schema version number for this file */
729   int iGeneration;     /* Generation counter.  Incremented with each change */
730   Hash tblHash;        /* All tables indexed by name */
731   Hash idxHash;        /* All (named) indices indexed by name */
732   Hash trigHash;       /* All triggers indexed by name */
733   Hash fkeyHash;       /* All foreign keys by referenced table name */
734   Table *pSeqTab;      /* The sqlite_sequence table used by AUTOINCREMENT */
735   u8 file_format;      /* Schema format version for this file */
736   u8 enc;              /* Text encoding used by this database */
737   u16 flags;           /* Flags associated with this schema */
738   int cache_size;      /* Number of pages to use in the cache */
739 };
740 
741 /*
742 ** These macros can be used to test, set, or clear bits in the
743 ** Db.pSchema->flags field.
744 */
745 #define DbHasProperty(D,I,P)     (((D)->aDb[I].pSchema->flags&(P))==(P))
746 #define DbHasAnyProperty(D,I,P)  (((D)->aDb[I].pSchema->flags&(P))!=0)
747 #define DbSetProperty(D,I,P)     (D)->aDb[I].pSchema->flags|=(P)
748 #define DbClearProperty(D,I,P)   (D)->aDb[I].pSchema->flags&=~(P)
749 
750 /*
751 ** Allowed values for the DB.pSchema->flags field.
752 **
753 ** The DB_SchemaLoaded flag is set after the database schema has been
754 ** read into internal hash tables.
755 **
756 ** DB_UnresetViews means that one or more views have column names that
757 ** have been filled out.  If the schema changes, these column names might
758 ** changes and so the view will need to be reset.
759 */
760 #define DB_SchemaLoaded    0x0001  /* The schema has been loaded */
761 #define DB_UnresetViews    0x0002  /* Some views have defined column names */
762 #define DB_Empty           0x0004  /* The file is empty (length 0 bytes) */
763 
764 /*
765 ** The number of different kinds of things that can be limited
766 ** using the sqlite3_limit() interface.
767 */
768 #define SQLITE_N_LIMIT (SQLITE_LIMIT_TRIGGER_DEPTH+1)
769 
770 /*
771 ** Lookaside malloc is a set of fixed-size buffers that can be used
772 ** to satisfy small transient memory allocation requests for objects
773 ** associated with a particular database connection.  The use of
774 ** lookaside malloc provides a significant performance enhancement
775 ** (approx 10%) by avoiding numerous malloc/free requests while parsing
776 ** SQL statements.
777 **
778 ** The Lookaside structure holds configuration information about the
779 ** lookaside malloc subsystem.  Each available memory allocation in
780 ** the lookaside subsystem is stored on a linked list of LookasideSlot
781 ** objects.
782 **
783 ** Lookaside allocations are only allowed for objects that are associated
784 ** with a particular database connection.  Hence, schema information cannot
785 ** be stored in lookaside because in shared cache mode the schema information
786 ** is shared by multiple database connections.  Therefore, while parsing
787 ** schema information, the Lookaside.bEnabled flag is cleared so that
788 ** lookaside allocations are not used to construct the schema objects.
789 */
790 struct Lookaside {
791   u16 sz;                 /* Size of each buffer in bytes */
792   u8 bEnabled;            /* False to disable new lookaside allocations */
793   u8 bMalloced;           /* True if pStart obtained from sqlite3_malloc() */
794   int nOut;               /* Number of buffers currently checked out */
795   int mxOut;              /* Highwater mark for nOut */
796   int anStat[3];          /* 0: hits.  1: size misses.  2: full misses */
797   LookasideSlot *pFree;   /* List of available buffers */
798   void *pStart;           /* First byte of available memory space */
799   void *pEnd;             /* First byte past end of available space */
800 };
801 struct LookasideSlot {
802   LookasideSlot *pNext;    /* Next buffer in the list of free buffers */
803 };
804 
805 /*
806 ** A hash table for function definitions.
807 **
808 ** Hash each FuncDef structure into one of the FuncDefHash.a[] slots.
809 ** Collisions are on the FuncDef.pHash chain.
810 */
811 struct FuncDefHash {
812   FuncDef *a[23];       /* Hash table for functions */
813 };
814 
815 /*
816 ** Each database connection is an instance of the following structure.
817 */
818 struct sqlite3 {
819   sqlite3_vfs *pVfs;            /* OS Interface */
820   struct Vdbe *pVdbe;           /* List of active virtual machines */
821   CollSeq *pDfltColl;           /* The default collating sequence (BINARY) */
822   sqlite3_mutex *mutex;         /* Connection mutex */
823   Db *aDb;                      /* All backends */
824   int nDb;                      /* Number of backends currently in use */
825   int flags;                    /* Miscellaneous flags. See below */
826   i64 lastRowid;                /* ROWID of most recent insert (see above) */
827   unsigned int openFlags;       /* Flags passed to sqlite3_vfs.xOpen() */
828   int errCode;                  /* Most recent error code (SQLITE_*) */
829   int errMask;                  /* & result codes with this before returning */
830   u8 dbOptFlags;                /* Flags to enable/disable optimizations */
831   u8 autoCommit;                /* The auto-commit flag. */
832   u8 temp_store;                /* 1: file 2: memory 0: default */
833   u8 mallocFailed;              /* True if we have seen a malloc failure */
834   u8 dfltLockMode;              /* Default locking-mode for attached dbs */
835   signed char nextAutovac;      /* Autovac setting after VACUUM if >=0 */
836   u8 suppressErr;               /* Do not issue error messages if true */
837   u8 vtabOnConflict;            /* Value to return for s3_vtab_on_conflict() */
838   u8 isTransactionSavepoint;    /* True if the outermost savepoint is a TS */
839   int nextPagesize;             /* Pagesize after VACUUM if >0 */
840   u32 magic;                    /* Magic number for detect library misuse */
841   int nChange;                  /* Value returned by sqlite3_changes() */
842   int nTotalChange;             /* Value returned by sqlite3_total_changes() */
843   int aLimit[SQLITE_N_LIMIT];   /* Limits */
844   struct sqlite3InitInfo {      /* Information used during initialization */
845     int newTnum;                /* Rootpage of table being initialized */
846     u8 iDb;                     /* Which db file is being initialized */
847     u8 busy;                    /* TRUE if currently initializing */
848     u8 orphanTrigger;           /* Last statement is orphaned TEMP trigger */
849   } init;
850   int activeVdbeCnt;            /* Number of VDBEs currently executing */
851   int writeVdbeCnt;             /* Number of active VDBEs that are writing */
852   int vdbeExecCnt;              /* Number of nested calls to VdbeExec() */
853   int nExtension;               /* Number of loaded extensions */
854   void **aExtension;            /* Array of shared library handles */
855   void (*xTrace)(void*,const char*);        /* Trace function */
856   void *pTraceArg;                          /* Argument to the trace function */
857   void (*xProfile)(void*,const char*,u64);  /* Profiling function */
858   void *pProfileArg;                        /* Argument to profile function */
859   void *pCommitArg;                 /* Argument to xCommitCallback() */
860   int (*xCommitCallback)(void*);    /* Invoked at every commit. */
861   void *pRollbackArg;               /* Argument to xRollbackCallback() */
862   void (*xRollbackCallback)(void*); /* Invoked at every commit. */
863   void *pUpdateArg;
864   void (*xUpdateCallback)(void*,int, const char*,const char*,sqlite_int64);
865 #ifndef SQLITE_OMIT_WAL
866   int (*xWalCallback)(void *, sqlite3 *, const char *, int);
867   void *pWalArg;
868 #endif
869   void(*xCollNeeded)(void*,sqlite3*,int eTextRep,const char*);
870   void(*xCollNeeded16)(void*,sqlite3*,int eTextRep,const void*);
871   void *pCollNeededArg;
872   sqlite3_value *pErr;          /* Most recent error message */
873   char *zErrMsg;                /* Most recent error message (UTF-8 encoded) */
874   char *zErrMsg16;              /* Most recent error message (UTF-16 encoded) */
875   union {
876     volatile int isInterrupted; /* True if sqlite3_interrupt has been called */
877     double notUsed1;            /* Spacer */
878   } u1;
879   Lookaside lookaside;          /* Lookaside malloc configuration */
880 #ifndef SQLITE_OMIT_AUTHORIZATION
881   int (*xAuth)(void*,int,const char*,const char*,const char*,const char*);
882                                 /* Access authorization function */
883   void *pAuthArg;               /* 1st argument to the access auth function */
884 #endif
885 #ifndef SQLITE_OMIT_PROGRESS_CALLBACK
886   int (*xProgress)(void *);     /* The progress callback */
887   void *pProgressArg;           /* Argument to the progress callback */
888   int nProgressOps;             /* Number of opcodes for progress callback */
889 #endif
890 #ifndef SQLITE_OMIT_VIRTUALTABLE
891   int nVTrans;                  /* Allocated size of aVTrans */
892   Hash aModule;                 /* populated by sqlite3_create_module() */
893   VtabCtx *pVtabCtx;            /* Context for active vtab connect/create */
894   VTable **aVTrans;             /* Virtual tables with open transactions */
895   VTable *pDisconnect;    /* Disconnect these in next sqlite3_prepare() */
896 #endif
897   FuncDefHash aFunc;            /* Hash table of connection functions */
898   Hash aCollSeq;                /* All collating sequences */
899   BusyHandler busyHandler;      /* Busy callback */
900   Db aDbStatic[2];              /* Static space for the 2 default backends */
901   Savepoint *pSavepoint;        /* List of active savepoints */
902   int busyTimeout;              /* Busy handler timeout, in msec */
903   int nSavepoint;               /* Number of non-transaction savepoints */
904   int nStatement;               /* Number of nested statement-transactions  */
905   i64 nDeferredCons;            /* Net deferred constraints this transaction. */
906   int *pnBytesFreed;            /* If not NULL, increment this in DbFree() */
907 
908 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
909   /* The following variables are all protected by the STATIC_MASTER
910   ** mutex, not by sqlite3.mutex. They are used by code in notify.c.
911   **
912   ** When X.pUnlockConnection==Y, that means that X is waiting for Y to
913   ** unlock so that it can proceed.
914   **
915   ** When X.pBlockingConnection==Y, that means that something that X tried
916   ** tried to do recently failed with an SQLITE_LOCKED error due to locks
917   ** held by Y.
918   */
919   sqlite3 *pBlockingConnection; /* Connection that caused SQLITE_LOCKED */
920   sqlite3 *pUnlockConnection;           /* Connection to watch for unlock */
921   void *pUnlockArg;                     /* Argument to xUnlockNotify */
922   void (*xUnlockNotify)(void **, int);  /* Unlock notify callback */
923   sqlite3 *pNextBlocked;        /* Next in list of all blocked connections */
924 #endif
925 };
926 
927 /*
928 ** A macro to discover the encoding of a database.
929 */
930 #define ENC(db) ((db)->aDb[0].pSchema->enc)
931 
932 /*
933 ** Possible values for the sqlite3.flags.
934 */
935 #define SQLITE_VdbeTrace      0x00000001  /* True to trace VDBE execution */
936 #define SQLITE_InternChanges  0x00000002  /* Uncommitted Hash table changes */
937 #define SQLITE_FullColNames   0x00000004  /* Show full column names on SELECT */
938 #define SQLITE_ShortColNames  0x00000008  /* Show short columns names */
939 #define SQLITE_CountRows      0x00000010  /* Count rows changed by INSERT, */
940                                           /*   DELETE, or UPDATE and return */
941                                           /*   the count using a callback. */
942 #define SQLITE_NullCallback   0x00000020  /* Invoke the callback once if the */
943                                           /*   result set is empty */
944 #define SQLITE_SqlTrace       0x00000040  /* Debug print SQL as it executes */
945 #define SQLITE_VdbeListing    0x00000080  /* Debug listings of VDBE programs */
946 #define SQLITE_WriteSchema    0x00000100  /* OK to update SQLITE_MASTER */
947                          /*   0x00000200  Unused */
948 #define SQLITE_IgnoreChecks   0x00000400  /* Do not enforce check constraints */
949 #define SQLITE_ReadUncommitted 0x0000800  /* For shared-cache mode */
950 #define SQLITE_LegacyFileFmt  0x00001000  /* Create new databases in format 1 */
951 #define SQLITE_FullFSync      0x00002000  /* Use full fsync on the backend */
952 #define SQLITE_CkptFullFSync  0x00004000  /* Use full fsync for checkpoint */
953 #define SQLITE_RecoveryMode   0x00008000  /* Ignore schema errors */
954 #define SQLITE_ReverseOrder   0x00010000  /* Reverse unordered SELECTs */
955 #define SQLITE_RecTriggers    0x00020000  /* Enable recursive triggers */
956 #define SQLITE_ForeignKeys    0x00040000  /* Enforce foreign key constraints  */
957 #define SQLITE_AutoIndex      0x00080000  /* Enable automatic indexes */
958 #define SQLITE_PreferBuiltin  0x00100000  /* Preference to built-in funcs */
959 #define SQLITE_LoadExtension  0x00200000  /* Enable load_extension */
960 #define SQLITE_EnableTrigger  0x00400000  /* True to enable triggers */
961 
962 /*
963 ** Bits of the sqlite3.dbOptFlags field that are used by the
964 ** sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS,...) interface to
965 ** selectively disable various optimizations.
966 */
967 #define SQLITE_QueryFlattener 0x0001   /* Query flattening */
968 #define SQLITE_ColumnCache    0x0002   /* Column cache */
969 #define SQLITE_GroupByOrder   0x0004   /* GROUPBY cover of ORDERBY */
970 #define SQLITE_FactorOutConst 0x0008   /* Constant factoring */
971 #define SQLITE_IdxRealAsInt   0x0010   /* Store REAL as INT in indices */
972 #define SQLITE_DistinctOpt    0x0020   /* DISTINCT using indexes */
973 #define SQLITE_CoverIdxScan   0x0040   /* Covering index scans */
974 #define SQLITE_OrderByIdxJoin 0x0080   /* ORDER BY of joins via index */
975 #define SQLITE_AllOpts        0x00ff   /* All optimizations */
976 
977 /*
978 ** Macros for testing whether or not optimizations are enabled or disabled.
979 */
980 #ifndef SQLITE_OMIT_BUILTIN_TEST
981 #define OptimizationDisabled(db, mask)  (((db)->dbOptFlags&(mask))!=0)
982 #define OptimizationEnabled(db, mask)   (((db)->dbOptFlags&(mask))==0)
983 #else
984 #define OptimizationDisabled(db, mask)  0
985 #define OptimizationEnabled(db, mask)   1
986 #endif
987 
988 /*
989 ** Possible values for the sqlite.magic field.
990 ** The numbers are obtained at random and have no special meaning, other
991 ** than being distinct from one another.
992 */
993 #define SQLITE_MAGIC_OPEN     0xa029a697  /* Database is open */
994 #define SQLITE_MAGIC_CLOSED   0x9f3c2d33  /* Database is closed */
995 #define SQLITE_MAGIC_SICK     0x4b771290  /* Error and awaiting close */
996 #define SQLITE_MAGIC_BUSY     0xf03b7906  /* Database currently in use */
997 #define SQLITE_MAGIC_ERROR    0xb5357930  /* An SQLITE_MISUSE error occurred */
998 #define SQLITE_MAGIC_ZOMBIE   0x64cffc7f  /* Close with last statement close */
999 
1000 /*
1001 ** Each SQL function is defined by an instance of the following
1002 ** structure.  A pointer to this structure is stored in the sqlite.aFunc
1003 ** hash table.  When multiple functions have the same name, the hash table
1004 ** points to a linked list of these structures.
1005 */
1006 struct FuncDef {
1007   i16 nArg;            /* Number of arguments.  -1 means unlimited */
1008   u8 iPrefEnc;         /* Preferred text encoding (SQLITE_UTF8, 16LE, 16BE) */
1009   u8 flags;            /* Some combination of SQLITE_FUNC_* */
1010   void *pUserData;     /* User data parameter */
1011   FuncDef *pNext;      /* Next function with same name */
1012   void (*xFunc)(sqlite3_context*,int,sqlite3_value**); /* Regular function */
1013   void (*xStep)(sqlite3_context*,int,sqlite3_value**); /* Aggregate step */
1014   void (*xFinalize)(sqlite3_context*);                /* Aggregate finalizer */
1015   char *zName;         /* SQL name of the function. */
1016   FuncDef *pHash;      /* Next with a different name but the same hash */
1017   FuncDestructor *pDestructor;   /* Reference counted destructor function */
1018 };
1019 
1020 /*
1021 ** This structure encapsulates a user-function destructor callback (as
1022 ** configured using create_function_v2()) and a reference counter. When
1023 ** create_function_v2() is called to create a function with a destructor,
1024 ** a single object of this type is allocated. FuncDestructor.nRef is set to
1025 ** the number of FuncDef objects created (either 1 or 3, depending on whether
1026 ** or not the specified encoding is SQLITE_ANY). The FuncDef.pDestructor
1027 ** member of each of the new FuncDef objects is set to point to the allocated
1028 ** FuncDestructor.
1029 **
1030 ** Thereafter, when one of the FuncDef objects is deleted, the reference
1031 ** count on this object is decremented. When it reaches 0, the destructor
1032 ** is invoked and the FuncDestructor structure freed.
1033 */
1034 struct FuncDestructor {
1035   int nRef;
1036   void (*xDestroy)(void *);
1037   void *pUserData;
1038 };
1039 
1040 /*
1041 ** Possible values for FuncDef.flags.  Note that the _LENGTH and _TYPEOF
1042 ** values must correspond to OPFLAG_LENGTHARG and OPFLAG_TYPEOFARG.  There
1043 ** are assert() statements in the code to verify this.
1044 */
1045 #define SQLITE_FUNC_LIKE     0x01 /* Candidate for the LIKE optimization */
1046 #define SQLITE_FUNC_CASE     0x02 /* Case-sensitive LIKE-type function */
1047 #define SQLITE_FUNC_EPHEM    0x04 /* Ephemeral.  Delete with VDBE */
1048 #define SQLITE_FUNC_NEEDCOLL 0x08 /* sqlite3GetFuncCollSeq() might be called */
1049 #define SQLITE_FUNC_COUNT    0x10 /* Built-in count(*) aggregate */
1050 #define SQLITE_FUNC_COALESCE 0x20 /* Built-in coalesce() or ifnull() function */
1051 #define SQLITE_FUNC_LENGTH   0x40 /* Built-in length() function */
1052 #define SQLITE_FUNC_TYPEOF   0x80 /* Built-in typeof() function */
1053 
1054 /*
1055 ** The following three macros, FUNCTION(), LIKEFUNC() and AGGREGATE() are
1056 ** used to create the initializers for the FuncDef structures.
1057 **
1058 **   FUNCTION(zName, nArg, iArg, bNC, xFunc)
1059 **     Used to create a scalar function definition of a function zName
1060 **     implemented by C function xFunc that accepts nArg arguments. The
1061 **     value passed as iArg is cast to a (void*) and made available
1062 **     as the user-data (sqlite3_user_data()) for the function. If
1063 **     argument bNC is true, then the SQLITE_FUNC_NEEDCOLL flag is set.
1064 **
1065 **   AGGREGATE(zName, nArg, iArg, bNC, xStep, xFinal)
1066 **     Used to create an aggregate function definition implemented by
1067 **     the C functions xStep and xFinal. The first four parameters
1068 **     are interpreted in the same way as the first 4 parameters to
1069 **     FUNCTION().
1070 **
1071 **   LIKEFUNC(zName, nArg, pArg, flags)
1072 **     Used to create a scalar function definition of a function zName
1073 **     that accepts nArg arguments and is implemented by a call to C
1074 **     function likeFunc. Argument pArg is cast to a (void *) and made
1075 **     available as the function user-data (sqlite3_user_data()). The
1076 **     FuncDef.flags variable is set to the value passed as the flags
1077 **     parameter.
1078 */
1079 #define FUNCTION(zName, nArg, iArg, bNC, xFunc) \
1080   {nArg, SQLITE_UTF8, (bNC*SQLITE_FUNC_NEEDCOLL), \
1081    SQLITE_INT_TO_PTR(iArg), 0, xFunc, 0, 0, #zName, 0, 0}
1082 #define FUNCTION2(zName, nArg, iArg, bNC, xFunc, extraFlags) \
1083   {nArg, SQLITE_UTF8, (bNC*SQLITE_FUNC_NEEDCOLL)|extraFlags, \
1084    SQLITE_INT_TO_PTR(iArg), 0, xFunc, 0, 0, #zName, 0, 0}
1085 #define STR_FUNCTION(zName, nArg, pArg, bNC, xFunc) \
1086   {nArg, SQLITE_UTF8, bNC*SQLITE_FUNC_NEEDCOLL, \
1087    pArg, 0, xFunc, 0, 0, #zName, 0, 0}
1088 #define LIKEFUNC(zName, nArg, arg, flags) \
1089   {nArg, SQLITE_UTF8, flags, (void *)arg, 0, likeFunc, 0, 0, #zName, 0, 0}
1090 #define AGGREGATE(zName, nArg, arg, nc, xStep, xFinal) \
1091   {nArg, SQLITE_UTF8, nc*SQLITE_FUNC_NEEDCOLL, \
1092    SQLITE_INT_TO_PTR(arg), 0, 0, xStep,xFinal,#zName,0,0}
1093 
1094 /*
1095 ** All current savepoints are stored in a linked list starting at
1096 ** sqlite3.pSavepoint. The first element in the list is the most recently
1097 ** opened savepoint. Savepoints are added to the list by the vdbe
1098 ** OP_Savepoint instruction.
1099 */
1100 struct Savepoint {
1101   char *zName;                        /* Savepoint name (nul-terminated) */
1102   i64 nDeferredCons;                  /* Number of deferred fk violations */
1103   Savepoint *pNext;                   /* Parent savepoint (if any) */
1104 };
1105 
1106 /*
1107 ** The following are used as the second parameter to sqlite3Savepoint(),
1108 ** and as the P1 argument to the OP_Savepoint instruction.
1109 */
1110 #define SAVEPOINT_BEGIN      0
1111 #define SAVEPOINT_RELEASE    1
1112 #define SAVEPOINT_ROLLBACK   2
1113 
1114 
1115 /*
1116 ** Each SQLite module (virtual table definition) is defined by an
1117 ** instance of the following structure, stored in the sqlite3.aModule
1118 ** hash table.
1119 */
1120 struct Module {
1121   const sqlite3_module *pModule;       /* Callback pointers */
1122   const char *zName;                   /* Name passed to create_module() */
1123   void *pAux;                          /* pAux passed to create_module() */
1124   void (*xDestroy)(void *);            /* Module destructor function */
1125 };
1126 
1127 /*
1128 ** information about each column of an SQL table is held in an instance
1129 ** of this structure.
1130 */
1131 struct Column {
1132   char *zName;     /* Name of this column */
1133   Expr *pDflt;     /* Default value of this column */
1134   char *zDflt;     /* Original text of the default value */
1135   char *zType;     /* Data type for this column */
1136   char *zColl;     /* Collating sequence.  If NULL, use the default */
1137   u8 notNull;      /* An OE_ code for handling a NOT NULL constraint */
1138   char affinity;   /* One of the SQLITE_AFF_... values */
1139   u16 colFlags;    /* Boolean properties.  See COLFLAG_ defines below */
1140 };
1141 
1142 /* Allowed values for Column.colFlags:
1143 */
1144 #define COLFLAG_PRIMKEY  0x0001    /* Column is part of the primary key */
1145 #define COLFLAG_HIDDEN   0x0002    /* A hidden column in a virtual table */
1146 
1147 /*
1148 ** A "Collating Sequence" is defined by an instance of the following
1149 ** structure. Conceptually, a collating sequence consists of a name and
1150 ** a comparison routine that defines the order of that sequence.
1151 **
1152 ** There may two separate implementations of the collation function, one
1153 ** that processes text in UTF-8 encoding (CollSeq.xCmp) and another that
1154 ** processes text encoded in UTF-16 (CollSeq.xCmp16), using the machine
1155 ** native byte order. When a collation sequence is invoked, SQLite selects
1156 ** the version that will require the least expensive encoding
1157 ** translations, if any.
1158 **
1159 ** The CollSeq.pUser member variable is an extra parameter that passed in
1160 ** as the first argument to the UTF-8 comparison function, xCmp.
1161 ** CollSeq.pUser16 is the equivalent for the UTF-16 comparison function,
1162 ** xCmp16.
1163 **
1164 ** If both CollSeq.xCmp and CollSeq.xCmp16 are NULL, it means that the
1165 ** collating sequence is undefined.  Indices built on an undefined
1166 ** collating sequence may not be read or written.
1167 */
1168 struct CollSeq {
1169   char *zName;          /* Name of the collating sequence, UTF-8 encoded */
1170   u8 enc;               /* Text encoding handled by xCmp() */
1171   void *pUser;          /* First argument to xCmp() */
1172   int (*xCmp)(void*,int, const void*, int, const void*);
1173   void (*xDel)(void*);  /* Destructor for pUser */
1174 };
1175 
1176 /*
1177 ** A sort order can be either ASC or DESC.
1178 */
1179 #define SQLITE_SO_ASC       0  /* Sort in ascending order */
1180 #define SQLITE_SO_DESC      1  /* Sort in ascending order */
1181 
1182 /*
1183 ** Column affinity types.
1184 **
1185 ** These used to have mnemonic name like 'i' for SQLITE_AFF_INTEGER and
1186 ** 't' for SQLITE_AFF_TEXT.  But we can save a little space and improve
1187 ** the speed a little by numbering the values consecutively.
1188 **
1189 ** But rather than start with 0 or 1, we begin with 'a'.  That way,
1190 ** when multiple affinity types are concatenated into a string and
1191 ** used as the P4 operand, they will be more readable.
1192 **
1193 ** Note also that the numeric types are grouped together so that testing
1194 ** for a numeric type is a single comparison.
1195 */
1196 #define SQLITE_AFF_TEXT     'a'
1197 #define SQLITE_AFF_NONE     'b'
1198 #define SQLITE_AFF_NUMERIC  'c'
1199 #define SQLITE_AFF_INTEGER  'd'
1200 #define SQLITE_AFF_REAL     'e'
1201 
1202 #define sqlite3IsNumericAffinity(X)  ((X)>=SQLITE_AFF_NUMERIC)
1203 
1204 /*
1205 ** The SQLITE_AFF_MASK values masks off the significant bits of an
1206 ** affinity value.
1207 */
1208 #define SQLITE_AFF_MASK     0x67
1209 
1210 /*
1211 ** Additional bit values that can be ORed with an affinity without
1212 ** changing the affinity.
1213 */
1214 #define SQLITE_JUMPIFNULL   0x08  /* jumps if either operand is NULL */
1215 #define SQLITE_STOREP2      0x10  /* Store result in reg[P2] rather than jump */
1216 #define SQLITE_NULLEQ       0x80  /* NULL=NULL */
1217 
1218 /*
1219 ** An object of this type is created for each virtual table present in
1220 ** the database schema.
1221 **
1222 ** If the database schema is shared, then there is one instance of this
1223 ** structure for each database connection (sqlite3*) that uses the shared
1224 ** schema. This is because each database connection requires its own unique
1225 ** instance of the sqlite3_vtab* handle used to access the virtual table
1226 ** implementation. sqlite3_vtab* handles can not be shared between
1227 ** database connections, even when the rest of the in-memory database
1228 ** schema is shared, as the implementation often stores the database
1229 ** connection handle passed to it via the xConnect() or xCreate() method
1230 ** during initialization internally. This database connection handle may
1231 ** then be used by the virtual table implementation to access real tables
1232 ** within the database. So that they appear as part of the callers
1233 ** transaction, these accesses need to be made via the same database
1234 ** connection as that used to execute SQL operations on the virtual table.
1235 **
1236 ** All VTable objects that correspond to a single table in a shared
1237 ** database schema are initially stored in a linked-list pointed to by
1238 ** the Table.pVTable member variable of the corresponding Table object.
1239 ** When an sqlite3_prepare() operation is required to access the virtual
1240 ** table, it searches the list for the VTable that corresponds to the
1241 ** database connection doing the preparing so as to use the correct
1242 ** sqlite3_vtab* handle in the compiled query.
1243 **
1244 ** When an in-memory Table object is deleted (for example when the
1245 ** schema is being reloaded for some reason), the VTable objects are not
1246 ** deleted and the sqlite3_vtab* handles are not xDisconnect()ed
1247 ** immediately. Instead, they are moved from the Table.pVTable list to
1248 ** another linked list headed by the sqlite3.pDisconnect member of the
1249 ** corresponding sqlite3 structure. They are then deleted/xDisconnected
1250 ** next time a statement is prepared using said sqlite3*. This is done
1251 ** to avoid deadlock issues involving multiple sqlite3.mutex mutexes.
1252 ** Refer to comments above function sqlite3VtabUnlockList() for an
1253 ** explanation as to why it is safe to add an entry to an sqlite3.pDisconnect
1254 ** list without holding the corresponding sqlite3.mutex mutex.
1255 **
1256 ** The memory for objects of this type is always allocated by
1257 ** sqlite3DbMalloc(), using the connection handle stored in VTable.db as
1258 ** the first argument.
1259 */
1260 struct VTable {
1261   sqlite3 *db;              /* Database connection associated with this table */
1262   Module *pMod;             /* Pointer to module implementation */
1263   sqlite3_vtab *pVtab;      /* Pointer to vtab instance */
1264   int nRef;                 /* Number of pointers to this structure */
1265   u8 bConstraint;           /* True if constraints are supported */
1266   int iSavepoint;           /* Depth of the SAVEPOINT stack */
1267   VTable *pNext;            /* Next in linked list (see above) */
1268 };
1269 
1270 /*
1271 ** Each SQL table is represented in memory by an instance of the
1272 ** following structure.
1273 **
1274 ** Table.zName is the name of the table.  The case of the original
1275 ** CREATE TABLE statement is stored, but case is not significant for
1276 ** comparisons.
1277 **
1278 ** Table.nCol is the number of columns in this table.  Table.aCol is a
1279 ** pointer to an array of Column structures, one for each column.
1280 **
1281 ** If the table has an INTEGER PRIMARY KEY, then Table.iPKey is the index of
1282 ** the column that is that key.   Otherwise Table.iPKey is negative.  Note
1283 ** that the datatype of the PRIMARY KEY must be INTEGER for this field to
1284 ** be set.  An INTEGER PRIMARY KEY is used as the rowid for each row of
1285 ** the table.  If a table has no INTEGER PRIMARY KEY, then a random rowid
1286 ** is generated for each row of the table.  TF_HasPrimaryKey is set if
1287 ** the table has any PRIMARY KEY, INTEGER or otherwise.
1288 **
1289 ** Table.tnum is the page number for the root BTree page of the table in the
1290 ** database file.  If Table.iDb is the index of the database table backend
1291 ** in sqlite.aDb[].  0 is for the main database and 1 is for the file that
1292 ** holds temporary tables and indices.  If TF_Ephemeral is set
1293 ** then the table is stored in a file that is automatically deleted
1294 ** when the VDBE cursor to the table is closed.  In this case Table.tnum
1295 ** refers VDBE cursor number that holds the table open, not to the root
1296 ** page number.  Transient tables are used to hold the results of a
1297 ** sub-query that appears instead of a real table name in the FROM clause
1298 ** of a SELECT statement.
1299 */
1300 struct Table {
1301   char *zName;         /* Name of the table or view */
1302   Column *aCol;        /* Information about each column */
1303   Index *pIndex;       /* List of SQL indexes on this table. */
1304   Select *pSelect;     /* NULL for tables.  Points to definition if a view. */
1305   FKey *pFKey;         /* Linked list of all foreign keys in this table */
1306   char *zColAff;       /* String defining the affinity of each column */
1307 #ifndef SQLITE_OMIT_CHECK
1308   ExprList *pCheck;    /* All CHECK constraints */
1309 #endif
1310   tRowcnt nRowEst;     /* Estimated rows in table - from sqlite_stat1 table */
1311   int tnum;            /* Root BTree node for this table (see note above) */
1312   i16 iPKey;           /* If not negative, use aCol[iPKey] as the primary key */
1313   i16 nCol;            /* Number of columns in this table */
1314   u16 nRef;            /* Number of pointers to this Table */
1315   u8 tabFlags;         /* Mask of TF_* values */
1316   u8 keyConf;          /* What to do in case of uniqueness conflict on iPKey */
1317 #ifndef SQLITE_OMIT_ALTERTABLE
1318   int addColOffset;    /* Offset in CREATE TABLE stmt to add a new column */
1319 #endif
1320 #ifndef SQLITE_OMIT_VIRTUALTABLE
1321   int nModuleArg;      /* Number of arguments to the module */
1322   char **azModuleArg;  /* Text of all module args. [0] is module name */
1323   VTable *pVTable;     /* List of VTable objects. */
1324 #endif
1325   Trigger *pTrigger;   /* List of triggers stored in pSchema */
1326   Schema *pSchema;     /* Schema that contains this table */
1327   Table *pNextZombie;  /* Next on the Parse.pZombieTab list */
1328 };
1329 
1330 /*
1331 ** Allowed values for Tabe.tabFlags.
1332 */
1333 #define TF_Readonly        0x01    /* Read-only system table */
1334 #define TF_Ephemeral       0x02    /* An ephemeral table */
1335 #define TF_HasPrimaryKey   0x04    /* Table has a primary key */
1336 #define TF_Autoincrement   0x08    /* Integer primary key is autoincrement */
1337 #define TF_Virtual         0x10    /* Is a virtual table */
1338 
1339 
1340 /*
1341 ** Test to see whether or not a table is a virtual table.  This is
1342 ** done as a macro so that it will be optimized out when virtual
1343 ** table support is omitted from the build.
1344 */
1345 #ifndef SQLITE_OMIT_VIRTUALTABLE
1346 #  define IsVirtual(X)      (((X)->tabFlags & TF_Virtual)!=0)
1347 #  define IsHiddenColumn(X) (((X)->colFlags & COLFLAG_HIDDEN)!=0)
1348 #else
1349 #  define IsVirtual(X)      0
1350 #  define IsHiddenColumn(X) 0
1351 #endif
1352 
1353 /*
1354 ** Each foreign key constraint is an instance of the following structure.
1355 **
1356 ** A foreign key is associated with two tables.  The "from" table is
1357 ** the table that contains the REFERENCES clause that creates the foreign
1358 ** key.  The "to" table is the table that is named in the REFERENCES clause.
1359 ** Consider this example:
1360 **
1361 **     CREATE TABLE ex1(
1362 **       a INTEGER PRIMARY KEY,
1363 **       b INTEGER CONSTRAINT fk1 REFERENCES ex2(x)
1364 **     );
1365 **
1366 ** For foreign key "fk1", the from-table is "ex1" and the to-table is "ex2".
1367 **
1368 ** Each REFERENCES clause generates an instance of the following structure
1369 ** which is attached to the from-table.  The to-table need not exist when
1370 ** the from-table is created.  The existence of the to-table is not checked.
1371 */
1372 struct FKey {
1373   Table *pFrom;     /* Table containing the REFERENCES clause (aka: Child) */
1374   FKey *pNextFrom;  /* Next foreign key in pFrom */
1375   char *zTo;        /* Name of table that the key points to (aka: Parent) */
1376   FKey *pNextTo;    /* Next foreign key on table named zTo */
1377   FKey *pPrevTo;    /* Previous foreign key on table named zTo */
1378   int nCol;         /* Number of columns in this key */
1379   /* EV: R-30323-21917 */
1380   u8 isDeferred;    /* True if constraint checking is deferred till COMMIT */
1381   u8 aAction[2];          /* ON DELETE and ON UPDATE actions, respectively */
1382   Trigger *apTrigger[2];  /* Triggers for aAction[] actions */
1383   struct sColMap {  /* Mapping of columns in pFrom to columns in zTo */
1384     int iFrom;         /* Index of column in pFrom */
1385     char *zCol;        /* Name of column in zTo.  If 0 use PRIMARY KEY */
1386   } aCol[1];        /* One entry for each of nCol column s */
1387 };
1388 
1389 /*
1390 ** SQLite supports many different ways to resolve a constraint
1391 ** error.  ROLLBACK processing means that a constraint violation
1392 ** causes the operation in process to fail and for the current transaction
1393 ** to be rolled back.  ABORT processing means the operation in process
1394 ** fails and any prior changes from that one operation are backed out,
1395 ** but the transaction is not rolled back.  FAIL processing means that
1396 ** the operation in progress stops and returns an error code.  But prior
1397 ** changes due to the same operation are not backed out and no rollback
1398 ** occurs.  IGNORE means that the particular row that caused the constraint
1399 ** error is not inserted or updated.  Processing continues and no error
1400 ** is returned.  REPLACE means that preexisting database rows that caused
1401 ** a UNIQUE constraint violation are removed so that the new insert or
1402 ** update can proceed.  Processing continues and no error is reported.
1403 **
1404 ** RESTRICT, SETNULL, and CASCADE actions apply only to foreign keys.
1405 ** RESTRICT is the same as ABORT for IMMEDIATE foreign keys and the
1406 ** same as ROLLBACK for DEFERRED keys.  SETNULL means that the foreign
1407 ** key is set to NULL.  CASCADE means that a DELETE or UPDATE of the
1408 ** referenced table row is propagated into the row that holds the
1409 ** foreign key.
1410 **
1411 ** The following symbolic values are used to record which type
1412 ** of action to take.
1413 */
1414 #define OE_None     0   /* There is no constraint to check */
1415 #define OE_Rollback 1   /* Fail the operation and rollback the transaction */
1416 #define OE_Abort    2   /* Back out changes but do no rollback transaction */
1417 #define OE_Fail     3   /* Stop the operation but leave all prior changes */
1418 #define OE_Ignore   4   /* Ignore the error. Do not do the INSERT or UPDATE */
1419 #define OE_Replace  5   /* Delete existing record, then do INSERT or UPDATE */
1420 
1421 #define OE_Restrict 6   /* OE_Abort for IMMEDIATE, OE_Rollback for DEFERRED */
1422 #define OE_SetNull  7   /* Set the foreign key value to NULL */
1423 #define OE_SetDflt  8   /* Set the foreign key value to its default */
1424 #define OE_Cascade  9   /* Cascade the changes */
1425 
1426 #define OE_Default  99  /* Do whatever the default action is */
1427 
1428 
1429 /*
1430 ** An instance of the following structure is passed as the first
1431 ** argument to sqlite3VdbeKeyCompare and is used to control the
1432 ** comparison of the two index keys.
1433 */
1434 struct KeyInfo {
1435   sqlite3 *db;        /* The database connection */
1436   u8 enc;             /* Text encoding - one of the SQLITE_UTF* values */
1437   u16 nField;         /* Number of entries in aColl[] */
1438   u8 *aSortOrder;     /* Sort order for each column.  May be NULL */
1439   CollSeq *aColl[1];  /* Collating sequence for each term of the key */
1440 };
1441 
1442 /*
1443 ** An instance of the following structure holds information about a
1444 ** single index record that has already been parsed out into individual
1445 ** values.
1446 **
1447 ** A record is an object that contains one or more fields of data.
1448 ** Records are used to store the content of a table row and to store
1449 ** the key of an index.  A blob encoding of a record is created by
1450 ** the OP_MakeRecord opcode of the VDBE and is disassembled by the
1451 ** OP_Column opcode.
1452 **
1453 ** This structure holds a record that has already been disassembled
1454 ** into its constituent fields.
1455 */
1456 struct UnpackedRecord {
1457   KeyInfo *pKeyInfo;  /* Collation and sort-order information */
1458   u16 nField;         /* Number of entries in apMem[] */
1459   u8 flags;           /* Boolean settings.  UNPACKED_... below */
1460   i64 rowid;          /* Used by UNPACKED_PREFIX_SEARCH */
1461   Mem *aMem;          /* Values */
1462 };
1463 
1464 /*
1465 ** Allowed values of UnpackedRecord.flags
1466 */
1467 #define UNPACKED_INCRKEY       0x01  /* Make this key an epsilon larger */
1468 #define UNPACKED_PREFIX_MATCH  0x02  /* A prefix match is considered OK */
1469 #define UNPACKED_PREFIX_SEARCH 0x04  /* Ignore final (rowid) field */
1470 
1471 /*
1472 ** Each SQL index is represented in memory by an
1473 ** instance of the following structure.
1474 **
1475 ** The columns of the table that are to be indexed are described
1476 ** by the aiColumn[] field of this structure.  For example, suppose
1477 ** we have the following table and index:
1478 **
1479 **     CREATE TABLE Ex1(c1 int, c2 int, c3 text);
1480 **     CREATE INDEX Ex2 ON Ex1(c3,c1);
1481 **
1482 ** In the Table structure describing Ex1, nCol==3 because there are
1483 ** three columns in the table.  In the Index structure describing
1484 ** Ex2, nColumn==2 since 2 of the 3 columns of Ex1 are indexed.
1485 ** The value of aiColumn is {2, 0}.  aiColumn[0]==2 because the
1486 ** first column to be indexed (c3) has an index of 2 in Ex1.aCol[].
1487 ** The second column to be indexed (c1) has an index of 0 in
1488 ** Ex1.aCol[], hence Ex2.aiColumn[1]==0.
1489 **
1490 ** The Index.onError field determines whether or not the indexed columns
1491 ** must be unique and what to do if they are not.  When Index.onError=OE_None,
1492 ** it means this is not a unique index.  Otherwise it is a unique index
1493 ** and the value of Index.onError indicate the which conflict resolution
1494 ** algorithm to employ whenever an attempt is made to insert a non-unique
1495 ** element.
1496 */
1497 struct Index {
1498   char *zName;     /* Name of this index */
1499   int *aiColumn;   /* Which columns are used by this index.  1st is 0 */
1500   tRowcnt *aiRowEst; /* Result of ANALYZE: Est. rows selected by each column */
1501   Table *pTable;   /* The SQL table being indexed */
1502   char *zColAff;   /* String defining the affinity of each column */
1503   Index *pNext;    /* The next index associated with the same table */
1504   Schema *pSchema; /* Schema containing this index */
1505   u8 *aSortOrder;  /* Array of size Index.nColumn. True==DESC, False==ASC */
1506   char **azColl;   /* Array of collation sequence names for index */
1507   int nColumn;     /* Number of columns in the table used by this index */
1508   int tnum;        /* Page containing root of this index in database file */
1509   u8 onError;      /* OE_Abort, OE_Ignore, OE_Replace, or OE_None */
1510   u8 autoIndex;    /* True if is automatically created (ex: by UNIQUE) */
1511   u8 bUnordered;   /* Use this index for == or IN queries only */
1512 #ifdef SQLITE_ENABLE_STAT3
1513   int nSample;             /* Number of elements in aSample[] */
1514   tRowcnt avgEq;           /* Average nEq value for key values not in aSample */
1515   IndexSample *aSample;    /* Samples of the left-most key */
1516 #endif
1517 };
1518 
1519 /*
1520 ** Each sample stored in the sqlite_stat3 table is represented in memory
1521 ** using a structure of this type.  See documentation at the top of the
1522 ** analyze.c source file for additional information.
1523 */
1524 struct IndexSample {
1525   union {
1526     char *z;        /* Value if eType is SQLITE_TEXT or SQLITE_BLOB */
1527     double r;       /* Value if eType is SQLITE_FLOAT */
1528     i64 i;          /* Value if eType is SQLITE_INTEGER */
1529   } u;
1530   u8 eType;         /* SQLITE_NULL, SQLITE_INTEGER ... etc. */
1531   int nByte;        /* Size in byte of text or blob. */
1532   tRowcnt nEq;      /* Est. number of rows where the key equals this sample */
1533   tRowcnt nLt;      /* Est. number of rows where key is less than this sample */
1534   tRowcnt nDLt;     /* Est. number of distinct keys less than this sample */
1535 };
1536 
1537 /*
1538 ** Each token coming out of the lexer is an instance of
1539 ** this structure.  Tokens are also used as part of an expression.
1540 **
1541 ** Note if Token.z==0 then Token.dyn and Token.n are undefined and
1542 ** may contain random values.  Do not make any assumptions about Token.dyn
1543 ** and Token.n when Token.z==0.
1544 */
1545 struct Token {
1546   const char *z;     /* Text of the token.  Not NULL-terminated! */
1547   unsigned int n;    /* Number of characters in this token */
1548 };
1549 
1550 /*
1551 ** An instance of this structure contains information needed to generate
1552 ** code for a SELECT that contains aggregate functions.
1553 **
1554 ** If Expr.op==TK_AGG_COLUMN or TK_AGG_FUNCTION then Expr.pAggInfo is a
1555 ** pointer to this structure.  The Expr.iColumn field is the index in
1556 ** AggInfo.aCol[] or AggInfo.aFunc[] of information needed to generate
1557 ** code for that node.
1558 **
1559 ** AggInfo.pGroupBy and AggInfo.aFunc.pExpr point to fields within the
1560 ** original Select structure that describes the SELECT statement.  These
1561 ** fields do not need to be freed when deallocating the AggInfo structure.
1562 */
1563 struct AggInfo {
1564   u8 directMode;          /* Direct rendering mode means take data directly
1565                           ** from source tables rather than from accumulators */
1566   u8 useSortingIdx;       /* In direct mode, reference the sorting index rather
1567                           ** than the source table */
1568   int sortingIdx;         /* Cursor number of the sorting index */
1569   int sortingIdxPTab;     /* Cursor number of pseudo-table */
1570   int nSortingColumn;     /* Number of columns in the sorting index */
1571   ExprList *pGroupBy;     /* The group by clause */
1572   struct AggInfo_col {    /* For each column used in source tables */
1573     Table *pTab;             /* Source table */
1574     int iTable;              /* Cursor number of the source table */
1575     int iColumn;             /* Column number within the source table */
1576     int iSorterColumn;       /* Column number in the sorting index */
1577     int iMem;                /* Memory location that acts as accumulator */
1578     Expr *pExpr;             /* The original expression */
1579   } *aCol;
1580   int nColumn;            /* Number of used entries in aCol[] */
1581   int nAccumulator;       /* Number of columns that show through to the output.
1582                           ** Additional columns are used only as parameters to
1583                           ** aggregate functions */
1584   struct AggInfo_func {   /* For each aggregate function */
1585     Expr *pExpr;             /* Expression encoding the function */
1586     FuncDef *pFunc;          /* The aggregate function implementation */
1587     int iMem;                /* Memory location that acts as accumulator */
1588     int iDistinct;           /* Ephemeral table used to enforce DISTINCT */
1589   } *aFunc;
1590   int nFunc;              /* Number of entries in aFunc[] */
1591 };
1592 
1593 /*
1594 ** The datatype ynVar is a signed integer, either 16-bit or 32-bit.
1595 ** Usually it is 16-bits.  But if SQLITE_MAX_VARIABLE_NUMBER is greater
1596 ** than 32767 we have to make it 32-bit.  16-bit is preferred because
1597 ** it uses less memory in the Expr object, which is a big memory user
1598 ** in systems with lots of prepared statements.  And few applications
1599 ** need more than about 10 or 20 variables.  But some extreme users want
1600 ** to have prepared statements with over 32767 variables, and for them
1601 ** the option is available (at compile-time).
1602 */
1603 #if SQLITE_MAX_VARIABLE_NUMBER<=32767
1604 typedef i16 ynVar;
1605 #else
1606 typedef int ynVar;
1607 #endif
1608 
1609 /*
1610 ** Each node of an expression in the parse tree is an instance
1611 ** of this structure.
1612 **
1613 ** Expr.op is the opcode. The integer parser token codes are reused
1614 ** as opcodes here. For example, the parser defines TK_GE to be an integer
1615 ** code representing the ">=" operator. This same integer code is reused
1616 ** to represent the greater-than-or-equal-to operator in the expression
1617 ** tree.
1618 **
1619 ** If the expression is an SQL literal (TK_INTEGER, TK_FLOAT, TK_BLOB,
1620 ** or TK_STRING), then Expr.token contains the text of the SQL literal. If
1621 ** the expression is a variable (TK_VARIABLE), then Expr.token contains the
1622 ** variable name. Finally, if the expression is an SQL function (TK_FUNCTION),
1623 ** then Expr.token contains the name of the function.
1624 **
1625 ** Expr.pRight and Expr.pLeft are the left and right subexpressions of a
1626 ** binary operator. Either or both may be NULL.
1627 **
1628 ** Expr.x.pList is a list of arguments if the expression is an SQL function,
1629 ** a CASE expression or an IN expression of the form "<lhs> IN (<y>, <z>...)".
1630 ** Expr.x.pSelect is used if the expression is a sub-select or an expression of
1631 ** the form "<lhs> IN (SELECT ...)". If the EP_xIsSelect bit is set in the
1632 ** Expr.flags mask, then Expr.x.pSelect is valid. Otherwise, Expr.x.pList is
1633 ** valid.
1634 **
1635 ** An expression of the form ID or ID.ID refers to a column in a table.
1636 ** For such expressions, Expr.op is set to TK_COLUMN and Expr.iTable is
1637 ** the integer cursor number of a VDBE cursor pointing to that table and
1638 ** Expr.iColumn is the column number for the specific column.  If the
1639 ** expression is used as a result in an aggregate SELECT, then the
1640 ** value is also stored in the Expr.iAgg column in the aggregate so that
1641 ** it can be accessed after all aggregates are computed.
1642 **
1643 ** If the expression is an unbound variable marker (a question mark
1644 ** character '?' in the original SQL) then the Expr.iTable holds the index
1645 ** number for that variable.
1646 **
1647 ** If the expression is a subquery then Expr.iColumn holds an integer
1648 ** register number containing the result of the subquery.  If the
1649 ** subquery gives a constant result, then iTable is -1.  If the subquery
1650 ** gives a different answer at different times during statement processing
1651 ** then iTable is the address of a subroutine that computes the subquery.
1652 **
1653 ** If the Expr is of type OP_Column, and the table it is selecting from
1654 ** is a disk table or the "old.*" pseudo-table, then pTab points to the
1655 ** corresponding table definition.
1656 **
1657 ** ALLOCATION NOTES:
1658 **
1659 ** Expr objects can use a lot of memory space in database schema.  To
1660 ** help reduce memory requirements, sometimes an Expr object will be
1661 ** truncated.  And to reduce the number of memory allocations, sometimes
1662 ** two or more Expr objects will be stored in a single memory allocation,
1663 ** together with Expr.zToken strings.
1664 **
1665 ** If the EP_Reduced and EP_TokenOnly flags are set when
1666 ** an Expr object is truncated.  When EP_Reduced is set, then all
1667 ** the child Expr objects in the Expr.pLeft and Expr.pRight subtrees
1668 ** are contained within the same memory allocation.  Note, however, that
1669 ** the subtrees in Expr.x.pList or Expr.x.pSelect are always separately
1670 ** allocated, regardless of whether or not EP_Reduced is set.
1671 */
1672 struct Expr {
1673   u8 op;                 /* Operation performed by this node */
1674   char affinity;         /* The affinity of the column or 0 if not a column */
1675   u16 flags;             /* Various flags.  EP_* See below */
1676   union {
1677     char *zToken;          /* Token value. Zero terminated and dequoted */
1678     int iValue;            /* Non-negative integer value if EP_IntValue */
1679   } u;
1680 
1681   /* If the EP_TokenOnly flag is set in the Expr.flags mask, then no
1682   ** space is allocated for the fields below this point. An attempt to
1683   ** access them will result in a segfault or malfunction.
1684   *********************************************************************/
1685 
1686   Expr *pLeft;           /* Left subnode */
1687   Expr *pRight;          /* Right subnode */
1688   union {
1689     ExprList *pList;     /* Function arguments or in "<expr> IN (<expr-list)" */
1690     Select *pSelect;     /* Used for sub-selects and "<expr> IN (<select>)" */
1691   } x;
1692   CollSeq *pColl;        /* The collation type of the column or 0 */
1693 
1694   /* If the EP_Reduced flag is set in the Expr.flags mask, then no
1695   ** space is allocated for the fields below this point. An attempt to
1696   ** access them will result in a segfault or malfunction.
1697   *********************************************************************/
1698 
1699 #if SQLITE_MAX_EXPR_DEPTH>0
1700   int nHeight;           /* Height of the tree headed by this node */
1701 #endif
1702   int iTable;            /* TK_COLUMN: cursor number of table holding column
1703                          ** TK_REGISTER: register number
1704                          ** TK_TRIGGER: 1 -> new, 0 -> old */
1705   ynVar iColumn;         /* TK_COLUMN: column index.  -1 for rowid.
1706                          ** TK_VARIABLE: variable number (always >= 1). */
1707   i16 iAgg;              /* Which entry in pAggInfo->aCol[] or ->aFunc[] */
1708   i16 iRightJoinTable;   /* If EP_FromJoin, the right table of the join */
1709   u8 flags2;             /* Second set of flags.  EP2_... */
1710   u8 op2;                /* TK_REGISTER: original value of Expr.op
1711                          ** TK_COLUMN: the value of p5 for OP_Column
1712                          ** TK_AGG_FUNCTION: nesting depth */
1713   AggInfo *pAggInfo;     /* Used by TK_AGG_COLUMN and TK_AGG_FUNCTION */
1714   Table *pTab;           /* Table for TK_COLUMN expressions. */
1715 };
1716 
1717 /*
1718 ** The following are the meanings of bits in the Expr.flags field.
1719 */
1720 #define EP_FromJoin   0x0001  /* Originated in ON or USING clause of a join */
1721 #define EP_Agg        0x0002  /* Contains one or more aggregate functions */
1722 #define EP_Resolved   0x0004  /* IDs have been resolved to COLUMNs */
1723 #define EP_Error      0x0008  /* Expression contains one or more errors */
1724 #define EP_Distinct   0x0010  /* Aggregate function with DISTINCT keyword */
1725 #define EP_VarSelect  0x0020  /* pSelect is correlated, not constant */
1726 #define EP_DblQuoted  0x0040  /* token.z was originally in "..." */
1727 #define EP_InfixFunc  0x0080  /* True for an infix function: LIKE, GLOB, etc */
1728 #define EP_ExpCollate 0x0100  /* Collating sequence specified explicitly */
1729 #define EP_FixedDest  0x0200  /* Result needed in a specific register */
1730 #define EP_IntValue   0x0400  /* Integer value contained in u.iValue */
1731 #define EP_xIsSelect  0x0800  /* x.pSelect is valid (otherwise x.pList is) */
1732 #define EP_Hint       0x1000  /* Not used */
1733 #define EP_Reduced    0x2000  /* Expr struct is EXPR_REDUCEDSIZE bytes only */
1734 #define EP_TokenOnly  0x4000  /* Expr struct is EXPR_TOKENONLYSIZE bytes only */
1735 #define EP_Static     0x8000  /* Held in memory not obtained from malloc() */
1736 
1737 /*
1738 ** The following are the meanings of bits in the Expr.flags2 field.
1739 */
1740 #define EP2_MallocedToken  0x0001  /* Need to sqlite3DbFree() Expr.zToken */
1741 #define EP2_Irreducible    0x0002  /* Cannot EXPRDUP_REDUCE this Expr */
1742 
1743 /*
1744 ** The pseudo-routine sqlite3ExprSetIrreducible sets the EP2_Irreducible
1745 ** flag on an expression structure.  This flag is used for VV&A only.  The
1746 ** routine is implemented as a macro that only works when in debugging mode,
1747 ** so as not to burden production code.
1748 */
1749 #ifdef SQLITE_DEBUG
1750 # define ExprSetIrreducible(X)  (X)->flags2 |= EP2_Irreducible
1751 #else
1752 # define ExprSetIrreducible(X)
1753 #endif
1754 
1755 /*
1756 ** These macros can be used to test, set, or clear bits in the
1757 ** Expr.flags field.
1758 */
1759 #define ExprHasProperty(E,P)     (((E)->flags&(P))==(P))
1760 #define ExprHasAnyProperty(E,P)  (((E)->flags&(P))!=0)
1761 #define ExprSetProperty(E,P)     (E)->flags|=(P)
1762 #define ExprClearProperty(E,P)   (E)->flags&=~(P)
1763 
1764 /*
1765 ** Macros to determine the number of bytes required by a normal Expr
1766 ** struct, an Expr struct with the EP_Reduced flag set in Expr.flags
1767 ** and an Expr struct with the EP_TokenOnly flag set.
1768 */
1769 #define EXPR_FULLSIZE           sizeof(Expr)           /* Full size */
1770 #define EXPR_REDUCEDSIZE        offsetof(Expr,iTable)  /* Common features */
1771 #define EXPR_TOKENONLYSIZE      offsetof(Expr,pLeft)   /* Fewer features */
1772 
1773 /*
1774 ** Flags passed to the sqlite3ExprDup() function. See the header comment
1775 ** above sqlite3ExprDup() for details.
1776 */
1777 #define EXPRDUP_REDUCE         0x0001  /* Used reduced-size Expr nodes */
1778 
1779 /*
1780 ** A list of expressions.  Each expression may optionally have a
1781 ** name.  An expr/name combination can be used in several ways, such
1782 ** as the list of "expr AS ID" fields following a "SELECT" or in the
1783 ** list of "ID = expr" items in an UPDATE.  A list of expressions can
1784 ** also be used as the argument to a function, in which case the a.zName
1785 ** field is not used.
1786 */
1787 struct ExprList {
1788   int nExpr;             /* Number of expressions on the list */
1789   int iECursor;          /* VDBE Cursor associated with this ExprList */
1790   struct ExprList_item { /* For each expression in the list */
1791     Expr *pExpr;           /* The list of expressions */
1792     char *zName;           /* Token associated with this expression */
1793     char *zSpan;           /* Original text of the expression */
1794     u8 sortOrder;          /* 1 for DESC or 0 for ASC */
1795     u8 done;               /* A flag to indicate when processing is finished */
1796     u16 iOrderByCol;       /* For ORDER BY, column number in result set */
1797     u16 iAlias;            /* Index into Parse.aAlias[] for zName */
1798   } *a;                  /* Alloc a power of two greater or equal to nExpr */
1799 };
1800 
1801 /*
1802 ** An instance of this structure is used by the parser to record both
1803 ** the parse tree for an expression and the span of input text for an
1804 ** expression.
1805 */
1806 struct ExprSpan {
1807   Expr *pExpr;          /* The expression parse tree */
1808   const char *zStart;   /* First character of input text */
1809   const char *zEnd;     /* One character past the end of input text */
1810 };
1811 
1812 /*
1813 ** An instance of this structure can hold a simple list of identifiers,
1814 ** such as the list "a,b,c" in the following statements:
1815 **
1816 **      INSERT INTO t(a,b,c) VALUES ...;
1817 **      CREATE INDEX idx ON t(a,b,c);
1818 **      CREATE TRIGGER trig BEFORE UPDATE ON t(a,b,c) ...;
1819 **
1820 ** The IdList.a.idx field is used when the IdList represents the list of
1821 ** column names after a table name in an INSERT statement.  In the statement
1822 **
1823 **     INSERT INTO t(a,b,c) ...
1824 **
1825 ** If "a" is the k-th column of table "t", then IdList.a[0].idx==k.
1826 */
1827 struct IdList {
1828   struct IdList_item {
1829     char *zName;      /* Name of the identifier */
1830     int idx;          /* Index in some Table.aCol[] of a column named zName */
1831   } *a;
1832   int nId;         /* Number of identifiers on the list */
1833 };
1834 
1835 /*
1836 ** The bitmask datatype defined below is used for various optimizations.
1837 **
1838 ** Changing this from a 64-bit to a 32-bit type limits the number of
1839 ** tables in a join to 32 instead of 64.  But it also reduces the size
1840 ** of the library by 738 bytes on ix86.
1841 */
1842 typedef u64 Bitmask;
1843 
1844 /*
1845 ** The number of bits in a Bitmask.  "BMS" means "BitMask Size".
1846 */
1847 #define BMS  ((int)(sizeof(Bitmask)*8))
1848 
1849 /*
1850 ** The following structure describes the FROM clause of a SELECT statement.
1851 ** Each table or subquery in the FROM clause is a separate element of
1852 ** the SrcList.a[] array.
1853 **
1854 ** With the addition of multiple database support, the following structure
1855 ** can also be used to describe a particular table such as the table that
1856 ** is modified by an INSERT, DELETE, or UPDATE statement.  In standard SQL,
1857 ** such a table must be a simple name: ID.  But in SQLite, the table can
1858 ** now be identified by a database name, a dot, then the table name: ID.ID.
1859 **
1860 ** The jointype starts out showing the join type between the current table
1861 ** and the next table on the list.  The parser builds the list this way.
1862 ** But sqlite3SrcListShiftJoinType() later shifts the jointypes so that each
1863 ** jointype expresses the join between the table and the previous table.
1864 **
1865 ** In the colUsed field, the high-order bit (bit 63) is set if the table
1866 ** contains more than 63 columns and the 64-th or later column is used.
1867 */
1868 struct SrcList {
1869   i16 nSrc;        /* Number of tables or subqueries in the FROM clause */
1870   i16 nAlloc;      /* Number of entries allocated in a[] below */
1871   struct SrcList_item {
1872     Schema *pSchema;  /* Schema to which this item is fixed */
1873     char *zDatabase;  /* Name of database holding this table */
1874     char *zName;      /* Name of the table */
1875     char *zAlias;     /* The "B" part of a "A AS B" phrase.  zName is the "A" */
1876     Table *pTab;      /* An SQL table corresponding to zName */
1877     Select *pSelect;  /* A SELECT statement used in place of a table name */
1878     int addrFillSub;  /* Address of subroutine to manifest a subquery */
1879     int regReturn;    /* Register holding return address of addrFillSub */
1880     u8 jointype;      /* Type of join between this able and the previous */
1881     u8 notIndexed;    /* True if there is a NOT INDEXED clause */
1882     u8 isCorrelated;  /* True if sub-query is correlated */
1883 #ifndef SQLITE_OMIT_EXPLAIN
1884     u8 iSelectId;     /* If pSelect!=0, the id of the sub-select in EQP */
1885 #endif
1886     int iCursor;      /* The VDBE cursor number used to access this table */
1887     Expr *pOn;        /* The ON clause of a join */
1888     IdList *pUsing;   /* The USING clause of a join */
1889     Bitmask colUsed;  /* Bit N (1<<N) set if column N of pTab is used */
1890     char *zIndex;     /* Identifier from "INDEXED BY <zIndex>" clause */
1891     Index *pIndex;    /* Index structure corresponding to zIndex, if any */
1892   } a[1];             /* One entry for each identifier on the list */
1893 };
1894 
1895 /*
1896 ** Permitted values of the SrcList.a.jointype field
1897 */
1898 #define JT_INNER     0x0001    /* Any kind of inner or cross join */
1899 #define JT_CROSS     0x0002    /* Explicit use of the CROSS keyword */
1900 #define JT_NATURAL   0x0004    /* True for a "natural" join */
1901 #define JT_LEFT      0x0008    /* Left outer join */
1902 #define JT_RIGHT     0x0010    /* Right outer join */
1903 #define JT_OUTER     0x0020    /* The "OUTER" keyword is present */
1904 #define JT_ERROR     0x0040    /* unknown or unsupported join type */
1905 
1906 
1907 /*
1908 ** A WherePlan object holds information that describes a lookup
1909 ** strategy.
1910 **
1911 ** This object is intended to be opaque outside of the where.c module.
1912 ** It is included here only so that that compiler will know how big it
1913 ** is.  None of the fields in this object should be used outside of
1914 ** the where.c module.
1915 **
1916 ** Within the union, pIdx is only used when wsFlags&WHERE_INDEXED is true.
1917 ** pTerm is only used when wsFlags&WHERE_MULTI_OR is true.  And pVtabIdx
1918 ** is only used when wsFlags&WHERE_VIRTUALTABLE is true.  It is never the
1919 ** case that more than one of these conditions is true.
1920 */
1921 struct WherePlan {
1922   u32 wsFlags;                   /* WHERE_* flags that describe the strategy */
1923   u16 nEq;                       /* Number of == constraints */
1924   u16 nOBSat;                    /* Number of ORDER BY terms satisfied */
1925   double nRow;                   /* Estimated number of rows (for EQP) */
1926   union {
1927     Index *pIdx;                   /* Index when WHERE_INDEXED is true */
1928     struct WhereTerm *pTerm;       /* WHERE clause term for OR-search */
1929     sqlite3_index_info *pVtabIdx;  /* Virtual table index to use */
1930   } u;
1931 };
1932 
1933 /*
1934 ** For each nested loop in a WHERE clause implementation, the WhereInfo
1935 ** structure contains a single instance of this structure.  This structure
1936 ** is intended to be private to the where.c module and should not be
1937 ** access or modified by other modules.
1938 **
1939 ** The pIdxInfo field is used to help pick the best index on a
1940 ** virtual table.  The pIdxInfo pointer contains indexing
1941 ** information for the i-th table in the FROM clause before reordering.
1942 ** All the pIdxInfo pointers are freed by whereInfoFree() in where.c.
1943 ** All other information in the i-th WhereLevel object for the i-th table
1944 ** after FROM clause ordering.
1945 */
1946 struct WhereLevel {
1947   WherePlan plan;       /* query plan for this element of the FROM clause */
1948   int iLeftJoin;        /* Memory cell used to implement LEFT OUTER JOIN */
1949   int iTabCur;          /* The VDBE cursor used to access the table */
1950   int iIdxCur;          /* The VDBE cursor used to access pIdx */
1951   int addrBrk;          /* Jump here to break out of the loop */
1952   int addrNxt;          /* Jump here to start the next IN combination */
1953   int addrCont;         /* Jump here to continue with the next loop cycle */
1954   int addrFirst;        /* First instruction of interior of the loop */
1955   u8 iFrom;             /* Which entry in the FROM clause */
1956   u8 op, p5;            /* Opcode and P5 of the opcode that ends the loop */
1957   int p1, p2;           /* Operands of the opcode used to ends the loop */
1958   union {               /* Information that depends on plan.wsFlags */
1959     struct {
1960       int nIn;              /* Number of entries in aInLoop[] */
1961       struct InLoop {
1962         int iCur;              /* The VDBE cursor used by this IN operator */
1963         int addrInTop;         /* Top of the IN loop */
1964       } *aInLoop;           /* Information about each nested IN operator */
1965     } in;                 /* Used when plan.wsFlags&WHERE_IN_ABLE */
1966     Index *pCovidx;       /* Possible covering index for WHERE_MULTI_OR */
1967   } u;
1968 
1969   /* The following field is really not part of the current level.  But
1970   ** we need a place to cache virtual table index information for each
1971   ** virtual table in the FROM clause and the WhereLevel structure is
1972   ** a convenient place since there is one WhereLevel for each FROM clause
1973   ** element.
1974   */
1975   sqlite3_index_info *pIdxInfo;  /* Index info for n-th source table */
1976 };
1977 
1978 /*
1979 ** Flags appropriate for the wctrlFlags parameter of sqlite3WhereBegin()
1980 ** and the WhereInfo.wctrlFlags member.
1981 */
1982 #define WHERE_ORDERBY_NORMAL   0x0000 /* No-op */
1983 #define WHERE_ORDERBY_MIN      0x0001 /* ORDER BY processing for min() func */
1984 #define WHERE_ORDERBY_MAX      0x0002 /* ORDER BY processing for max() func */
1985 #define WHERE_ONEPASS_DESIRED  0x0004 /* Want to do one-pass UPDATE/DELETE */
1986 #define WHERE_DUPLICATES_OK    0x0008 /* Ok to return a row more than once */
1987 #define WHERE_OMIT_OPEN_CLOSE  0x0010 /* Table cursors are already open */
1988 #define WHERE_FORCE_TABLE      0x0020 /* Do not use an index-only search */
1989 #define WHERE_ONETABLE_ONLY    0x0040 /* Only code the 1st table in pTabList */
1990 #define WHERE_AND_ONLY         0x0080 /* Don't use indices for OR terms */
1991 
1992 /*
1993 ** The WHERE clause processing routine has two halves.  The
1994 ** first part does the start of the WHERE loop and the second
1995 ** half does the tail of the WHERE loop.  An instance of
1996 ** this structure is returned by the first half and passed
1997 ** into the second half to give some continuity.
1998 */
1999 struct WhereInfo {
2000   Parse *pParse;            /* Parsing and code generating context */
2001   SrcList *pTabList;        /* List of tables in the join */
2002   u16 nOBSat;               /* Number of ORDER BY terms satisfied by indices */
2003   u16 wctrlFlags;           /* Flags originally passed to sqlite3WhereBegin() */
2004   u8 okOnePass;             /* Ok to use one-pass algorithm for UPDATE/DELETE */
2005   u8 untestedTerms;         /* Not all WHERE terms resolved by outer loop */
2006   u8 eDistinct;             /* One of the WHERE_DISTINCT_* values below */
2007   int iTop;                 /* The very beginning of the WHERE loop */
2008   int iContinue;            /* Jump here to continue with next record */
2009   int iBreak;               /* Jump here to break out of the loop */
2010   int nLevel;               /* Number of nested loop */
2011   struct WhereClause *pWC;  /* Decomposition of the WHERE clause */
2012   double savedNQueryLoop;   /* pParse->nQueryLoop outside the WHERE loop */
2013   double nRowOut;           /* Estimated number of output rows */
2014   WhereLevel a[1];          /* Information about each nest loop in WHERE */
2015 };
2016 
2017 /* Allowed values for WhereInfo.eDistinct and DistinctCtx.eTnctType */
2018 #define WHERE_DISTINCT_NOOP      0  /* DISTINCT keyword not used */
2019 #define WHERE_DISTINCT_UNIQUE    1  /* No duplicates */
2020 #define WHERE_DISTINCT_ORDERED   2  /* All duplicates are adjacent */
2021 #define WHERE_DISTINCT_UNORDERED 3  /* Duplicates are scattered */
2022 
2023 /*
2024 ** A NameContext defines a context in which to resolve table and column
2025 ** names.  The context consists of a list of tables (the pSrcList) field and
2026 ** a list of named expression (pEList).  The named expression list may
2027 ** be NULL.  The pSrc corresponds to the FROM clause of a SELECT or
2028 ** to the table being operated on by INSERT, UPDATE, or DELETE.  The
2029 ** pEList corresponds to the result set of a SELECT and is NULL for
2030 ** other statements.
2031 **
2032 ** NameContexts can be nested.  When resolving names, the inner-most
2033 ** context is searched first.  If no match is found, the next outer
2034 ** context is checked.  If there is still no match, the next context
2035 ** is checked.  This process continues until either a match is found
2036 ** or all contexts are check.  When a match is found, the nRef member of
2037 ** the context containing the match is incremented.
2038 **
2039 ** Each subquery gets a new NameContext.  The pNext field points to the
2040 ** NameContext in the parent query.  Thus the process of scanning the
2041 ** NameContext list corresponds to searching through successively outer
2042 ** subqueries looking for a match.
2043 */
2044 struct NameContext {
2045   Parse *pParse;       /* The parser */
2046   SrcList *pSrcList;   /* One or more tables used to resolve names */
2047   ExprList *pEList;    /* Optional list of named expressions */
2048   AggInfo *pAggInfo;   /* Information about aggregates at this level */
2049   NameContext *pNext;  /* Next outer name context.  NULL for outermost */
2050   int nRef;            /* Number of names resolved by this context */
2051   int nErr;            /* Number of errors encountered while resolving names */
2052   u8 ncFlags;          /* Zero or more NC_* flags defined below */
2053 };
2054 
2055 /*
2056 ** Allowed values for the NameContext, ncFlags field.
2057 */
2058 #define NC_AllowAgg  0x01    /* Aggregate functions are allowed here */
2059 #define NC_HasAgg    0x02    /* One or more aggregate functions seen */
2060 #define NC_IsCheck   0x04    /* True if resolving names in a CHECK constraint */
2061 #define NC_InAggFunc 0x08    /* True if analyzing arguments to an agg func */
2062 
2063 /*
2064 ** An instance of the following structure contains all information
2065 ** needed to generate code for a single SELECT statement.
2066 **
2067 ** nLimit is set to -1 if there is no LIMIT clause.  nOffset is set to 0.
2068 ** If there is a LIMIT clause, the parser sets nLimit to the value of the
2069 ** limit and nOffset to the value of the offset (or 0 if there is not
2070 ** offset).  But later on, nLimit and nOffset become the memory locations
2071 ** in the VDBE that record the limit and offset counters.
2072 **
2073 ** addrOpenEphm[] entries contain the address of OP_OpenEphemeral opcodes.
2074 ** These addresses must be stored so that we can go back and fill in
2075 ** the P4_KEYINFO and P2 parameters later.  Neither the KeyInfo nor
2076 ** the number of columns in P2 can be computed at the same time
2077 ** as the OP_OpenEphm instruction is coded because not
2078 ** enough information about the compound query is known at that point.
2079 ** The KeyInfo for addrOpenTran[0] and [1] contains collating sequences
2080 ** for the result set.  The KeyInfo for addrOpenEphm[2] contains collating
2081 ** sequences for the ORDER BY clause.
2082 */
2083 struct Select {
2084   ExprList *pEList;      /* The fields of the result */
2085   u8 op;                 /* One of: TK_UNION TK_ALL TK_INTERSECT TK_EXCEPT */
2086   u16 selFlags;          /* Various SF_* values */
2087   int iLimit, iOffset;   /* Memory registers holding LIMIT & OFFSET counters */
2088   int addrOpenEphm[3];   /* OP_OpenEphem opcodes related to this select */
2089   double nSelectRow;     /* Estimated number of result rows */
2090   SrcList *pSrc;         /* The FROM clause */
2091   Expr *pWhere;          /* The WHERE clause */
2092   ExprList *pGroupBy;    /* The GROUP BY clause */
2093   Expr *pHaving;         /* The HAVING clause */
2094   ExprList *pOrderBy;    /* The ORDER BY clause */
2095   Select *pPrior;        /* Prior select in a compound select statement */
2096   Select *pNext;         /* Next select to the left in a compound */
2097   Select *pRightmost;    /* Right-most select in a compound select statement */
2098   Expr *pLimit;          /* LIMIT expression. NULL means not used. */
2099   Expr *pOffset;         /* OFFSET expression. NULL means not used. */
2100 };
2101 
2102 /*
2103 ** Allowed values for Select.selFlags.  The "SF" prefix stands for
2104 ** "Select Flag".
2105 */
2106 #define SF_Distinct        0x01  /* Output should be DISTINCT */
2107 #define SF_Resolved        0x02  /* Identifiers have been resolved */
2108 #define SF_Aggregate       0x04  /* Contains aggregate functions */
2109 #define SF_UsesEphemeral   0x08  /* Uses the OpenEphemeral opcode */
2110 #define SF_Expanded        0x10  /* sqlite3SelectExpand() called on this */
2111 #define SF_HasTypeInfo     0x20  /* FROM subqueries have Table metadata */
2112 #define SF_UseSorter       0x40  /* Sort using a sorter */
2113 #define SF_Values          0x80  /* Synthesized from VALUES clause */
2114 
2115 
2116 /*
2117 ** The results of a select can be distributed in several ways.  The
2118 ** "SRT" prefix means "SELECT Result Type".
2119 */
2120 #define SRT_Union        1  /* Store result as keys in an index */
2121 #define SRT_Except       2  /* Remove result from a UNION index */
2122 #define SRT_Exists       3  /* Store 1 if the result is not empty */
2123 #define SRT_Discard      4  /* Do not save the results anywhere */
2124 
2125 /* The ORDER BY clause is ignored for all of the above */
2126 #define IgnorableOrderby(X) ((X->eDest)<=SRT_Discard)
2127 
2128 #define SRT_Output       5  /* Output each row of result */
2129 #define SRT_Mem          6  /* Store result in a memory cell */
2130 #define SRT_Set          7  /* Store results as keys in an index */
2131 #define SRT_Table        8  /* Store result as data with an automatic rowid */
2132 #define SRT_EphemTab     9  /* Create transient tab and store like SRT_Table */
2133 #define SRT_Coroutine   10  /* Generate a single row of result */
2134 
2135 /*
2136 ** An instance of this object describes where to put of the results of
2137 ** a SELECT statement.
2138 */
2139 struct SelectDest {
2140   u8 eDest;         /* How to dispose of the results.  On of SRT_* above. */
2141   char affSdst;     /* Affinity used when eDest==SRT_Set */
2142   int iSDParm;      /* A parameter used by the eDest disposal method */
2143   int iSdst;        /* Base register where results are written */
2144   int nSdst;        /* Number of registers allocated */
2145 };
2146 
2147 /*
2148 ** During code generation of statements that do inserts into AUTOINCREMENT
2149 ** tables, the following information is attached to the Table.u.autoInc.p
2150 ** pointer of each autoincrement table to record some side information that
2151 ** the code generator needs.  We have to keep per-table autoincrement
2152 ** information in case inserts are down within triggers.  Triggers do not
2153 ** normally coordinate their activities, but we do need to coordinate the
2154 ** loading and saving of autoincrement information.
2155 */
2156 struct AutoincInfo {
2157   AutoincInfo *pNext;   /* Next info block in a list of them all */
2158   Table *pTab;          /* Table this info block refers to */
2159   int iDb;              /* Index in sqlite3.aDb[] of database holding pTab */
2160   int regCtr;           /* Memory register holding the rowid counter */
2161 };
2162 
2163 /*
2164 ** Size of the column cache
2165 */
2166 #ifndef SQLITE_N_COLCACHE
2167 # define SQLITE_N_COLCACHE 10
2168 #endif
2169 
2170 /*
2171 ** At least one instance of the following structure is created for each
2172 ** trigger that may be fired while parsing an INSERT, UPDATE or DELETE
2173 ** statement. All such objects are stored in the linked list headed at
2174 ** Parse.pTriggerPrg and deleted once statement compilation has been
2175 ** completed.
2176 **
2177 ** A Vdbe sub-program that implements the body and WHEN clause of trigger
2178 ** TriggerPrg.pTrigger, assuming a default ON CONFLICT clause of
2179 ** TriggerPrg.orconf, is stored in the TriggerPrg.pProgram variable.
2180 ** The Parse.pTriggerPrg list never contains two entries with the same
2181 ** values for both pTrigger and orconf.
2182 **
2183 ** The TriggerPrg.aColmask[0] variable is set to a mask of old.* columns
2184 ** accessed (or set to 0 for triggers fired as a result of INSERT
2185 ** statements). Similarly, the TriggerPrg.aColmask[1] variable is set to
2186 ** a mask of new.* columns used by the program.
2187 */
2188 struct TriggerPrg {
2189   Trigger *pTrigger;      /* Trigger this program was coded from */
2190   TriggerPrg *pNext;      /* Next entry in Parse.pTriggerPrg list */
2191   SubProgram *pProgram;   /* Program implementing pTrigger/orconf */
2192   int orconf;             /* Default ON CONFLICT policy */
2193   u32 aColmask[2];        /* Masks of old.*, new.* columns accessed */
2194 };
2195 
2196 /*
2197 ** The yDbMask datatype for the bitmask of all attached databases.
2198 */
2199 #if SQLITE_MAX_ATTACHED>30
2200   typedef sqlite3_uint64 yDbMask;
2201 #else
2202   typedef unsigned int yDbMask;
2203 #endif
2204 
2205 /*
2206 ** An SQL parser context.  A copy of this structure is passed through
2207 ** the parser and down into all the parser action routine in order to
2208 ** carry around information that is global to the entire parse.
2209 **
2210 ** The structure is divided into two parts.  When the parser and code
2211 ** generate call themselves recursively, the first part of the structure
2212 ** is constant but the second part is reset at the beginning and end of
2213 ** each recursion.
2214 **
2215 ** The nTableLock and aTableLock variables are only used if the shared-cache
2216 ** feature is enabled (if sqlite3Tsd()->useSharedData is true). They are
2217 ** used to store the set of table-locks required by the statement being
2218 ** compiled. Function sqlite3TableLock() is used to add entries to the
2219 ** list.
2220 */
2221 struct Parse {
2222   sqlite3 *db;         /* The main database structure */
2223   char *zErrMsg;       /* An error message */
2224   Vdbe *pVdbe;         /* An engine for executing database bytecode */
2225   int rc;              /* Return code from execution */
2226   u8 colNamesSet;      /* TRUE after OP_ColumnName has been issued to pVdbe */
2227   u8 checkSchema;      /* Causes schema cookie check after an error */
2228   u8 nested;           /* Number of nested calls to the parser/code generator */
2229   u8 nTempReg;         /* Number of temporary registers in aTempReg[] */
2230   u8 nTempInUse;       /* Number of aTempReg[] currently checked out */
2231   u8 nColCache;        /* Number of entries in aColCache[] */
2232   u8 iColCache;        /* Next entry in aColCache[] to replace */
2233   u8 isMultiWrite;     /* True if statement may modify/insert multiple rows */
2234   u8 mayAbort;         /* True if statement may throw an ABORT exception */
2235   int aTempReg[8];     /* Holding area for temporary registers */
2236   int nRangeReg;       /* Size of the temporary register block */
2237   int iRangeReg;       /* First register in temporary register block */
2238   int nErr;            /* Number of errors seen */
2239   int nTab;            /* Number of previously allocated VDBE cursors */
2240   int nMem;            /* Number of memory cells used so far */
2241   int nSet;            /* Number of sets used so far */
2242   int nOnce;           /* Number of OP_Once instructions so far */
2243   int ckBase;          /* Base register of data during check constraints */
2244   int iCacheLevel;     /* ColCache valid when aColCache[].iLevel<=iCacheLevel */
2245   int iCacheCnt;       /* Counter used to generate aColCache[].lru values */
2246   struct yColCache {
2247     int iTable;           /* Table cursor number */
2248     int iColumn;          /* Table column number */
2249     u8 tempReg;           /* iReg is a temp register that needs to be freed */
2250     int iLevel;           /* Nesting level */
2251     int iReg;             /* Reg with value of this column. 0 means none. */
2252     int lru;              /* Least recently used entry has the smallest value */
2253   } aColCache[SQLITE_N_COLCACHE];  /* One for each column cache entry */
2254   yDbMask writeMask;   /* Start a write transaction on these databases */
2255   yDbMask cookieMask;  /* Bitmask of schema verified databases */
2256   int cookieGoto;      /* Address of OP_Goto to cookie verifier subroutine */
2257   int cookieValue[SQLITE_MAX_ATTACHED+2];  /* Values of cookies to verify */
2258   int regRowid;        /* Register holding rowid of CREATE TABLE entry */
2259   int regRoot;         /* Register holding root page number for new objects */
2260   int nMaxArg;         /* Max args passed to user function by sub-program */
2261   Token constraintName;/* Name of the constraint currently being parsed */
2262 #ifndef SQLITE_OMIT_SHARED_CACHE
2263   int nTableLock;        /* Number of locks in aTableLock */
2264   TableLock *aTableLock; /* Required table locks for shared-cache mode */
2265 #endif
2266   AutoincInfo *pAinc;  /* Information about AUTOINCREMENT counters */
2267 
2268   /* Information used while coding trigger programs. */
2269   Parse *pToplevel;    /* Parse structure for main program (or NULL) */
2270   Table *pTriggerTab;  /* Table triggers are being coded for */
2271   double nQueryLoop;   /* Estimated number of iterations of a query */
2272   u32 oldmask;         /* Mask of old.* columns referenced */
2273   u32 newmask;         /* Mask of new.* columns referenced */
2274   u8 eTriggerOp;       /* TK_UPDATE, TK_INSERT or TK_DELETE */
2275   u8 eOrconf;          /* Default ON CONFLICT policy for trigger steps */
2276   u8 disableTriggers;  /* True to disable triggers */
2277 
2278   /* Above is constant between recursions.  Below is reset before and after
2279   ** each recursion */
2280 
2281   int nVar;                 /* Number of '?' variables seen in the SQL so far */
2282   int nzVar;                /* Number of available slots in azVar[] */
2283   u8 explain;               /* True if the EXPLAIN flag is found on the query */
2284 #ifndef SQLITE_OMIT_VIRTUALTABLE
2285   u8 declareVtab;           /* True if inside sqlite3_declare_vtab() */
2286   int nVtabLock;            /* Number of virtual tables to lock */
2287 #endif
2288   int nAlias;               /* Number of aliased result set columns */
2289   int nHeight;              /* Expression tree height of current sub-select */
2290 #ifndef SQLITE_OMIT_EXPLAIN
2291   int iSelectId;            /* ID of current select for EXPLAIN output */
2292   int iNextSelectId;        /* Next available select ID for EXPLAIN output */
2293 #endif
2294   char **azVar;             /* Pointers to names of parameters */
2295   Vdbe *pReprepare;         /* VM being reprepared (sqlite3Reprepare()) */
2296   int *aAlias;              /* Register used to hold aliased result */
2297   const char *zTail;        /* All SQL text past the last semicolon parsed */
2298   Table *pNewTable;         /* A table being constructed by CREATE TABLE */
2299   Trigger *pNewTrigger;     /* Trigger under construct by a CREATE TRIGGER */
2300   const char *zAuthContext; /* The 6th parameter to db->xAuth callbacks */
2301   Token sNameToken;         /* Token with unqualified schema object name */
2302   Token sLastToken;         /* The last token parsed */
2303 #ifndef SQLITE_OMIT_VIRTUALTABLE
2304   Token sArg;               /* Complete text of a module argument */
2305   Table **apVtabLock;       /* Pointer to virtual tables needing locking */
2306 #endif
2307   Table *pZombieTab;        /* List of Table objects to delete after code gen */
2308   TriggerPrg *pTriggerPrg;  /* Linked list of coded triggers */
2309 };
2310 
2311 /*
2312 ** Return true if currently inside an sqlite3_declare_vtab() call.
2313 */
2314 #ifdef SQLITE_OMIT_VIRTUALTABLE
2315   #define IN_DECLARE_VTAB 0
2316 #else
2317   #define IN_DECLARE_VTAB (pParse->declareVtab)
2318 #endif
2319 
2320 /*
2321 ** An instance of the following structure can be declared on a stack and used
2322 ** to save the Parse.zAuthContext value so that it can be restored later.
2323 */
2324 struct AuthContext {
2325   const char *zAuthContext;   /* Put saved Parse.zAuthContext here */
2326   Parse *pParse;              /* The Parse structure */
2327 };
2328 
2329 /*
2330 ** Bitfield flags for P5 value in various opcodes.
2331 */
2332 #define OPFLAG_NCHANGE       0x01    /* Set to update db->nChange */
2333 #define OPFLAG_LASTROWID     0x02    /* Set to update db->lastRowid */
2334 #define OPFLAG_ISUPDATE      0x04    /* This OP_Insert is an sql UPDATE */
2335 #define OPFLAG_APPEND        0x08    /* This is likely to be an append */
2336 #define OPFLAG_USESEEKRESULT 0x10    /* Try to avoid a seek in BtreeInsert() */
2337 #define OPFLAG_CLEARCACHE    0x20    /* Clear pseudo-table cache in OP_Column */
2338 #define OPFLAG_LENGTHARG     0x40    /* OP_Column only used for length() */
2339 #define OPFLAG_TYPEOFARG     0x80    /* OP_Column only used for typeof() */
2340 #define OPFLAG_BULKCSR       0x01    /* OP_Open** used to open bulk cursor */
2341 #define OPFLAG_P2ISREG       0x02    /* P2 to OP_Open** is a register number */
2342 
2343 /*
2344  * Each trigger present in the database schema is stored as an instance of
2345  * struct Trigger.
2346  *
2347  * Pointers to instances of struct Trigger are stored in two ways.
2348  * 1. In the "trigHash" hash table (part of the sqlite3* that represents the
2349  *    database). This allows Trigger structures to be retrieved by name.
2350  * 2. All triggers associated with a single table form a linked list, using the
2351  *    pNext member of struct Trigger. A pointer to the first element of the
2352  *    linked list is stored as the "pTrigger" member of the associated
2353  *    struct Table.
2354  *
2355  * The "step_list" member points to the first element of a linked list
2356  * containing the SQL statements specified as the trigger program.
2357  */
2358 struct Trigger {
2359   char *zName;            /* The name of the trigger                        */
2360   char *table;            /* The table or view to which the trigger applies */
2361   u8 op;                  /* One of TK_DELETE, TK_UPDATE, TK_INSERT         */
2362   u8 tr_tm;               /* One of TRIGGER_BEFORE, TRIGGER_AFTER */
2363   Expr *pWhen;            /* The WHEN clause of the expression (may be NULL) */
2364   IdList *pColumns;       /* If this is an UPDATE OF <column-list> trigger,
2365                              the <column-list> is stored here */
2366   Schema *pSchema;        /* Schema containing the trigger */
2367   Schema *pTabSchema;     /* Schema containing the table */
2368   TriggerStep *step_list; /* Link list of trigger program steps             */
2369   Trigger *pNext;         /* Next trigger associated with the table */
2370 };
2371 
2372 /*
2373 ** A trigger is either a BEFORE or an AFTER trigger.  The following constants
2374 ** determine which.
2375 **
2376 ** If there are multiple triggers, you might of some BEFORE and some AFTER.
2377 ** In that cases, the constants below can be ORed together.
2378 */
2379 #define TRIGGER_BEFORE  1
2380 #define TRIGGER_AFTER   2
2381 
2382 /*
2383  * An instance of struct TriggerStep is used to store a single SQL statement
2384  * that is a part of a trigger-program.
2385  *
2386  * Instances of struct TriggerStep are stored in a singly linked list (linked
2387  * using the "pNext" member) referenced by the "step_list" member of the
2388  * associated struct Trigger instance. The first element of the linked list is
2389  * the first step of the trigger-program.
2390  *
2391  * The "op" member indicates whether this is a "DELETE", "INSERT", "UPDATE" or
2392  * "SELECT" statement. The meanings of the other members is determined by the
2393  * value of "op" as follows:
2394  *
2395  * (op == TK_INSERT)
2396  * orconf    -> stores the ON CONFLICT algorithm
2397  * pSelect   -> If this is an INSERT INTO ... SELECT ... statement, then
2398  *              this stores a pointer to the SELECT statement. Otherwise NULL.
2399  * target    -> A token holding the quoted name of the table to insert into.
2400  * pExprList -> If this is an INSERT INTO ... VALUES ... statement, then
2401  *              this stores values to be inserted. Otherwise NULL.
2402  * pIdList   -> If this is an INSERT INTO ... (<column-names>) VALUES ...
2403  *              statement, then this stores the column-names to be
2404  *              inserted into.
2405  *
2406  * (op == TK_DELETE)
2407  * target    -> A token holding the quoted name of the table to delete from.
2408  * pWhere    -> The WHERE clause of the DELETE statement if one is specified.
2409  *              Otherwise NULL.
2410  *
2411  * (op == TK_UPDATE)
2412  * target    -> A token holding the quoted name of the table to update rows of.
2413  * pWhere    -> The WHERE clause of the UPDATE statement if one is specified.
2414  *              Otherwise NULL.
2415  * pExprList -> A list of the columns to update and the expressions to update
2416  *              them to. See sqlite3Update() documentation of "pChanges"
2417  *              argument.
2418  *
2419  */
2420 struct TriggerStep {
2421   u8 op;               /* One of TK_DELETE, TK_UPDATE, TK_INSERT, TK_SELECT */
2422   u8 orconf;           /* OE_Rollback etc. */
2423   Trigger *pTrig;      /* The trigger that this step is a part of */
2424   Select *pSelect;     /* SELECT statment or RHS of INSERT INTO .. SELECT ... */
2425   Token target;        /* Target table for DELETE, UPDATE, INSERT */
2426   Expr *pWhere;        /* The WHERE clause for DELETE or UPDATE steps */
2427   ExprList *pExprList; /* SET clause for UPDATE.  VALUES clause for INSERT */
2428   IdList *pIdList;     /* Column names for INSERT */
2429   TriggerStep *pNext;  /* Next in the link-list */
2430   TriggerStep *pLast;  /* Last element in link-list. Valid for 1st elem only */
2431 };
2432 
2433 /*
2434 ** The following structure contains information used by the sqliteFix...
2435 ** routines as they walk the parse tree to make database references
2436 ** explicit.
2437 */
2438 typedef struct DbFixer DbFixer;
2439 struct DbFixer {
2440   Parse *pParse;      /* The parsing context.  Error messages written here */
2441   Schema *pSchema;    /* Fix items to this schema */
2442   const char *zDb;    /* Make sure all objects are contained in this database */
2443   const char *zType;  /* Type of the container - used for error messages */
2444   const Token *pName; /* Name of the container - used for error messages */
2445 };
2446 
2447 /*
2448 ** An objected used to accumulate the text of a string where we
2449 ** do not necessarily know how big the string will be in the end.
2450 */
2451 struct StrAccum {
2452   sqlite3 *db;         /* Optional database for lookaside.  Can be NULL */
2453   char *zBase;         /* A base allocation.  Not from malloc. */
2454   char *zText;         /* The string collected so far */
2455   int  nChar;          /* Length of the string so far */
2456   int  nAlloc;         /* Amount of space allocated in zText */
2457   int  mxAlloc;        /* Maximum allowed string length */
2458   u8   mallocFailed;   /* Becomes true if any memory allocation fails */
2459   u8   useMalloc;      /* 0: none,  1: sqlite3DbMalloc,  2: sqlite3_malloc */
2460   u8   tooBig;         /* Becomes true if string size exceeds limits */
2461 };
2462 
2463 /*
2464 ** A pointer to this structure is used to communicate information
2465 ** from sqlite3Init and OP_ParseSchema into the sqlite3InitCallback.
2466 */
2467 typedef struct {
2468   sqlite3 *db;        /* The database being initialized */
2469   char **pzErrMsg;    /* Error message stored here */
2470   int iDb;            /* 0 for main database.  1 for TEMP, 2.. for ATTACHed */
2471   int rc;             /* Result code stored here */
2472 } InitData;
2473 
2474 /*
2475 ** Structure containing global configuration data for the SQLite library.
2476 **
2477 ** This structure also contains some state information.
2478 */
2479 struct Sqlite3Config {
2480   int bMemstat;                     /* True to enable memory status */
2481   int bCoreMutex;                   /* True to enable core mutexing */
2482   int bFullMutex;                   /* True to enable full mutexing */
2483   int bOpenUri;                     /* True to interpret filenames as URIs */
2484   int bUseCis;                      /* Use covering indices for full-scans */
2485   int mxStrlen;                     /* Maximum string length */
2486   int szLookaside;                  /* Default lookaside buffer size */
2487   int nLookaside;                   /* Default lookaside buffer count */
2488   sqlite3_mem_methods m;            /* Low-level memory allocation interface */
2489   sqlite3_mutex_methods mutex;      /* Low-level mutex interface */
2490   sqlite3_pcache_methods2 pcache2;  /* Low-level page-cache interface */
2491   void *pHeap;                      /* Heap storage space */
2492   int nHeap;                        /* Size of pHeap[] */
2493   int mnReq, mxReq;                 /* Min and max heap requests sizes */
2494   void *pScratch;                   /* Scratch memory */
2495   int szScratch;                    /* Size of each scratch buffer */
2496   int nScratch;                     /* Number of scratch buffers */
2497   void *pPage;                      /* Page cache memory */
2498   int szPage;                       /* Size of each page in pPage[] */
2499   int nPage;                        /* Number of pages in pPage[] */
2500   int mxParserStack;                /* maximum depth of the parser stack */
2501   int sharedCacheEnabled;           /* true if shared-cache mode enabled */
2502   /* The above might be initialized to non-zero.  The following need to always
2503   ** initially be zero, however. */
2504   int isInit;                       /* True after initialization has finished */
2505   int inProgress;                   /* True while initialization in progress */
2506   int isMutexInit;                  /* True after mutexes are initialized */
2507   int isMallocInit;                 /* True after malloc is initialized */
2508   int isPCacheInit;                 /* True after malloc is initialized */
2509   sqlite3_mutex *pInitMutex;        /* Mutex used by sqlite3_initialize() */
2510   int nRefInitMutex;                /* Number of users of pInitMutex */
2511   void (*xLog)(void*,int,const char*); /* Function for logging */
2512   void *pLogArg;                       /* First argument to xLog() */
2513   int bLocaltimeFault;              /* True to fail localtime() calls */
2514 };
2515 
2516 /*
2517 ** Context pointer passed down through the tree-walk.
2518 */
2519 struct Walker {
2520   int (*xExprCallback)(Walker*, Expr*);     /* Callback for expressions */
2521   int (*xSelectCallback)(Walker*,Select*);  /* Callback for SELECTs */
2522   Parse *pParse;                            /* Parser context.  */
2523   int walkerDepth;                          /* Number of subqueries */
2524   union {                                   /* Extra data for callback */
2525     NameContext *pNC;                          /* Naming context */
2526     int i;                                     /* Integer value */
2527     SrcList *pSrcList;                         /* FROM clause */
2528     struct SrcCount *pSrcCount;                /* Counting column references */
2529   } u;
2530 };
2531 
2532 /* Forward declarations */
2533 int sqlite3WalkExpr(Walker*, Expr*);
2534 int sqlite3WalkExprList(Walker*, ExprList*);
2535 int sqlite3WalkSelect(Walker*, Select*);
2536 int sqlite3WalkSelectExpr(Walker*, Select*);
2537 int sqlite3WalkSelectFrom(Walker*, Select*);
2538 
2539 /*
2540 ** Return code from the parse-tree walking primitives and their
2541 ** callbacks.
2542 */
2543 #define WRC_Continue    0   /* Continue down into children */
2544 #define WRC_Prune       1   /* Omit children but continue walking siblings */
2545 #define WRC_Abort       2   /* Abandon the tree walk */
2546 
2547 /*
2548 ** Assuming zIn points to the first byte of a UTF-8 character,
2549 ** advance zIn to point to the first byte of the next UTF-8 character.
2550 */
2551 #define SQLITE_SKIP_UTF8(zIn) {                        \
2552   if( (*(zIn++))>=0xc0 ){                              \
2553     while( (*zIn & 0xc0)==0x80 ){ zIn++; }             \
2554   }                                                    \
2555 }
2556 
2557 /*
2558 ** The SQLITE_*_BKPT macros are substitutes for the error codes with
2559 ** the same name but without the _BKPT suffix.  These macros invoke
2560 ** routines that report the line-number on which the error originated
2561 ** using sqlite3_log().  The routines also provide a convenient place
2562 ** to set a debugger breakpoint.
2563 */
2564 int sqlite3CorruptError(int);
2565 int sqlite3MisuseError(int);
2566 int sqlite3CantopenError(int);
2567 #define SQLITE_CORRUPT_BKPT sqlite3CorruptError(__LINE__)
2568 #define SQLITE_MISUSE_BKPT sqlite3MisuseError(__LINE__)
2569 #define SQLITE_CANTOPEN_BKPT sqlite3CantopenError(__LINE__)
2570 
2571 
2572 /*
2573 ** FTS4 is really an extension for FTS3.  It is enabled using the
2574 ** SQLITE_ENABLE_FTS3 macro.  But to avoid confusion we also all
2575 ** the SQLITE_ENABLE_FTS4 macro to serve as an alisse for SQLITE_ENABLE_FTS3.
2576 */
2577 #if defined(SQLITE_ENABLE_FTS4) && !defined(SQLITE_ENABLE_FTS3)
2578 # define SQLITE_ENABLE_FTS3
2579 #endif
2580 
2581 /*
2582 ** The ctype.h header is needed for non-ASCII systems.  It is also
2583 ** needed by FTS3 when FTS3 is included in the amalgamation.
2584 */
2585 #if !defined(SQLITE_ASCII) || \
2586     (defined(SQLITE_ENABLE_FTS3) && defined(SQLITE_AMALGAMATION))
2587 # include <ctype.h>
2588 #endif
2589 
2590 /*
2591 ** The following macros mimic the standard library functions toupper(),
2592 ** isspace(), isalnum(), isdigit() and isxdigit(), respectively. The
2593 ** sqlite versions only work for ASCII characters, regardless of locale.
2594 */
2595 #ifdef SQLITE_ASCII
2596 # define sqlite3Toupper(x)  ((x)&~(sqlite3CtypeMap[(unsigned char)(x)]&0x20))
2597 # define sqlite3Isspace(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x01)
2598 # define sqlite3Isalnum(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x06)
2599 # define sqlite3Isalpha(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x02)
2600 # define sqlite3Isdigit(x)   (sqlite3CtypeMap[(unsigned char)(x)]&0x04)
2601 # define sqlite3Isxdigit(x)  (sqlite3CtypeMap[(unsigned char)(x)]&0x08)
2602 # define sqlite3Tolower(x)   (sqlite3UpperToLower[(unsigned char)(x)])
2603 #else
2604 # define sqlite3Toupper(x)   toupper((unsigned char)(x))
2605 # define sqlite3Isspace(x)   isspace((unsigned char)(x))
2606 # define sqlite3Isalnum(x)   isalnum((unsigned char)(x))
2607 # define sqlite3Isalpha(x)   isalpha((unsigned char)(x))
2608 # define sqlite3Isdigit(x)   isdigit((unsigned char)(x))
2609 # define sqlite3Isxdigit(x)  isxdigit((unsigned char)(x))
2610 # define sqlite3Tolower(x)   tolower((unsigned char)(x))
2611 #endif
2612 
2613 /*
2614 ** Internal function prototypes
2615 */
2616 #define sqlite3StrICmp sqlite3_stricmp
2617 int sqlite3Strlen30(const char*);
2618 #define sqlite3StrNICmp sqlite3_strnicmp
2619 
2620 int sqlite3MallocInit(void);
2621 void sqlite3MallocEnd(void);
2622 void *sqlite3Malloc(int);
2623 void *sqlite3MallocZero(int);
2624 void *sqlite3DbMallocZero(sqlite3*, int);
2625 void *sqlite3DbMallocRaw(sqlite3*, int);
2626 char *sqlite3DbStrDup(sqlite3*,const char*);
2627 char *sqlite3DbStrNDup(sqlite3*,const char*, int);
2628 void *sqlite3Realloc(void*, int);
2629 void *sqlite3DbReallocOrFree(sqlite3 *, void *, int);
2630 void *sqlite3DbRealloc(sqlite3 *, void *, int);
2631 void sqlite3DbFree(sqlite3*, void*);
2632 int sqlite3MallocSize(void*);
2633 int sqlite3DbMallocSize(sqlite3*, void*);
2634 void *sqlite3ScratchMalloc(int);
2635 void sqlite3ScratchFree(void*);
2636 void *sqlite3PageMalloc(int);
2637 void sqlite3PageFree(void*);
2638 void sqlite3MemSetDefault(void);
2639 void sqlite3BenignMallocHooks(void (*)(void), void (*)(void));
2640 int sqlite3HeapNearlyFull(void);
2641 
2642 /*
2643 ** On systems with ample stack space and that support alloca(), make
2644 ** use of alloca() to obtain space for large automatic objects.  By default,
2645 ** obtain space from malloc().
2646 **
2647 ** The alloca() routine never returns NULL.  This will cause code paths
2648 ** that deal with sqlite3StackAlloc() failures to be unreachable.
2649 */
2650 #ifdef SQLITE_USE_ALLOCA
2651 # define sqlite3StackAllocRaw(D,N)   alloca(N)
2652 # define sqlite3StackAllocZero(D,N)  memset(alloca(N), 0, N)
2653 # define sqlite3StackFree(D,P)
2654 #else
2655 # define sqlite3StackAllocRaw(D,N)   sqlite3DbMallocRaw(D,N)
2656 # define sqlite3StackAllocZero(D,N)  sqlite3DbMallocZero(D,N)
2657 # define sqlite3StackFree(D,P)       sqlite3DbFree(D,P)
2658 #endif
2659 
2660 #ifdef SQLITE_ENABLE_MEMSYS3
2661 const sqlite3_mem_methods *sqlite3MemGetMemsys3(void);
2662 #endif
2663 #ifdef SQLITE_ENABLE_MEMSYS5
2664 const sqlite3_mem_methods *sqlite3MemGetMemsys5(void);
2665 #endif
2666 
2667 
2668 #ifndef SQLITE_MUTEX_OMIT
2669   sqlite3_mutex_methods const *sqlite3DefaultMutex(void);
2670   sqlite3_mutex_methods const *sqlite3NoopMutex(void);
2671   sqlite3_mutex *sqlite3MutexAlloc(int);
2672   int sqlite3MutexInit(void);
2673   int sqlite3MutexEnd(void);
2674 #endif
2675 
2676 int sqlite3StatusValue(int);
2677 void sqlite3StatusAdd(int, int);
2678 void sqlite3StatusSet(int, int);
2679 
2680 #ifndef SQLITE_OMIT_FLOATING_POINT
2681   int sqlite3IsNaN(double);
2682 #else
2683 # define sqlite3IsNaN(X)  0
2684 #endif
2685 
2686 void sqlite3VXPrintf(StrAccum*, int, const char*, va_list);
2687 #ifndef SQLITE_OMIT_TRACE
2688 void sqlite3XPrintf(StrAccum*, const char*, ...);
2689 #endif
2690 char *sqlite3MPrintf(sqlite3*,const char*, ...);
2691 char *sqlite3VMPrintf(sqlite3*,const char*, va_list);
2692 char *sqlite3MAppendf(sqlite3*,char*,const char*,...);
2693 #if defined(SQLITE_TEST) || defined(SQLITE_DEBUG)
2694   void sqlite3DebugPrintf(const char*, ...);
2695 #endif
2696 #if defined(SQLITE_TEST)
2697   void *sqlite3TestTextToPtr(const char*);
2698 #endif
2699 
2700 /* Output formatting for SQLITE_TESTCTRL_EXPLAIN */
2701 #if defined(SQLITE_ENABLE_TREE_EXPLAIN)
2702   void sqlite3ExplainBegin(Vdbe*);
2703   void sqlite3ExplainPrintf(Vdbe*, const char*, ...);
2704   void sqlite3ExplainNL(Vdbe*);
2705   void sqlite3ExplainPush(Vdbe*);
2706   void sqlite3ExplainPop(Vdbe*);
2707   void sqlite3ExplainFinish(Vdbe*);
2708   void sqlite3ExplainSelect(Vdbe*, Select*);
2709   void sqlite3ExplainExpr(Vdbe*, Expr*);
2710   void sqlite3ExplainExprList(Vdbe*, ExprList*);
2711   const char *sqlite3VdbeExplanation(Vdbe*);
2712 #else
2713 # define sqlite3ExplainBegin(X)
2714 # define sqlite3ExplainSelect(A,B)
2715 # define sqlite3ExplainExpr(A,B)
2716 # define sqlite3ExplainExprList(A,B)
2717 # define sqlite3ExplainFinish(X)
2718 # define sqlite3VdbeExplanation(X) 0
2719 #endif
2720 
2721 
2722 void sqlite3SetString(char **, sqlite3*, const char*, ...);
2723 void sqlite3ErrorMsg(Parse*, const char*, ...);
2724 int sqlite3Dequote(char*);
2725 int sqlite3KeywordCode(const unsigned char*, int);
2726 int sqlite3RunParser(Parse*, const char*, char **);
2727 void sqlite3FinishCoding(Parse*);
2728 int sqlite3GetTempReg(Parse*);
2729 void sqlite3ReleaseTempReg(Parse*,int);
2730 int sqlite3GetTempRange(Parse*,int);
2731 void sqlite3ReleaseTempRange(Parse*,int,int);
2732 void sqlite3ClearTempRegCache(Parse*);
2733 Expr *sqlite3ExprAlloc(sqlite3*,int,const Token*,int);
2734 Expr *sqlite3Expr(sqlite3*,int,const char*);
2735 void sqlite3ExprAttachSubtrees(sqlite3*,Expr*,Expr*,Expr*);
2736 Expr *sqlite3PExpr(Parse*, int, Expr*, Expr*, const Token*);
2737 Expr *sqlite3ExprAnd(sqlite3*,Expr*, Expr*);
2738 Expr *sqlite3ExprFunction(Parse*,ExprList*, Token*);
2739 void sqlite3ExprAssignVarNumber(Parse*, Expr*);
2740 void sqlite3ExprDelete(sqlite3*, Expr*);
2741 ExprList *sqlite3ExprListAppend(Parse*,ExprList*,Expr*);
2742 void sqlite3ExprListSetName(Parse*,ExprList*,Token*,int);
2743 void sqlite3ExprListSetSpan(Parse*,ExprList*,ExprSpan*);
2744 void sqlite3ExprListDelete(sqlite3*, ExprList*);
2745 int sqlite3Init(sqlite3*, char**);
2746 int sqlite3InitCallback(void*, int, char**, char**);
2747 void sqlite3Pragma(Parse*,Token*,Token*,Token*,int);
2748 void sqlite3ResetAllSchemasOfConnection(sqlite3*);
2749 void sqlite3ResetOneSchema(sqlite3*,int);
2750 void sqlite3CollapseDatabaseArray(sqlite3*);
2751 void sqlite3BeginParse(Parse*,int);
2752 void sqlite3CommitInternalChanges(sqlite3*);
2753 Table *sqlite3ResultSetOfSelect(Parse*,Select*);
2754 void sqlite3OpenMasterTable(Parse *, int);
2755 void sqlite3StartTable(Parse*,Token*,Token*,int,int,int,int);
2756 void sqlite3AddColumn(Parse*,Token*);
2757 void sqlite3AddNotNull(Parse*, int);
2758 void sqlite3AddPrimaryKey(Parse*, ExprList*, int, int, int);
2759 void sqlite3AddCheckConstraint(Parse*, Expr*);
2760 void sqlite3AddColumnType(Parse*,Token*);
2761 void sqlite3AddDefaultValue(Parse*,ExprSpan*);
2762 void sqlite3AddCollateType(Parse*, Token*);
2763 void sqlite3EndTable(Parse*,Token*,Token*,Select*);
2764 int sqlite3ParseUri(const char*,const char*,unsigned int*,
2765                     sqlite3_vfs**,char**,char **);
2766 Btree *sqlite3DbNameToBtree(sqlite3*,const char*);
2767 int sqlite3CodeOnce(Parse *);
2768 
2769 Bitvec *sqlite3BitvecCreate(u32);
2770 int sqlite3BitvecTest(Bitvec*, u32);
2771 int sqlite3BitvecSet(Bitvec*, u32);
2772 void sqlite3BitvecClear(Bitvec*, u32, void*);
2773 void sqlite3BitvecDestroy(Bitvec*);
2774 u32 sqlite3BitvecSize(Bitvec*);
2775 int sqlite3BitvecBuiltinTest(int,int*);
2776 
2777 RowSet *sqlite3RowSetInit(sqlite3*, void*, unsigned int);
2778 void sqlite3RowSetClear(RowSet*);
2779 void sqlite3RowSetInsert(RowSet*, i64);
2780 int sqlite3RowSetTest(RowSet*, u8 iBatch, i64);
2781 int sqlite3RowSetNext(RowSet*, i64*);
2782 
2783 void sqlite3CreateView(Parse*,Token*,Token*,Token*,Select*,int,int);
2784 
2785 #if !defined(SQLITE_OMIT_VIEW) || !defined(SQLITE_OMIT_VIRTUALTABLE)
2786   int sqlite3ViewGetColumnNames(Parse*,Table*);
2787 #else
2788 # define sqlite3ViewGetColumnNames(A,B) 0
2789 #endif
2790 
2791 void sqlite3DropTable(Parse*, SrcList*, int, int);
2792 void sqlite3CodeDropTable(Parse*, Table*, int, int);
2793 void sqlite3DeleteTable(sqlite3*, Table*);
2794 #ifndef SQLITE_OMIT_AUTOINCREMENT
2795   void sqlite3AutoincrementBegin(Parse *pParse);
2796   void sqlite3AutoincrementEnd(Parse *pParse);
2797 #else
2798 # define sqlite3AutoincrementBegin(X)
2799 # define sqlite3AutoincrementEnd(X)
2800 #endif
2801 int sqlite3CodeCoroutine(Parse*, Select*, SelectDest*);
2802 void sqlite3Insert(Parse*, SrcList*, ExprList*, Select*, IdList*, int);
2803 void *sqlite3ArrayAllocate(sqlite3*,void*,int,int*,int*);
2804 IdList *sqlite3IdListAppend(sqlite3*, IdList*, Token*);
2805 int sqlite3IdListIndex(IdList*,const char*);
2806 SrcList *sqlite3SrcListEnlarge(sqlite3*, SrcList*, int, int);
2807 SrcList *sqlite3SrcListAppend(sqlite3*, SrcList*, Token*, Token*);
2808 SrcList *sqlite3SrcListAppendFromTerm(Parse*, SrcList*, Token*, Token*,
2809                                       Token*, Select*, Expr*, IdList*);
2810 void sqlite3SrcListIndexedBy(Parse *, SrcList *, Token *);
2811 int sqlite3IndexedByLookup(Parse *, struct SrcList_item *);
2812 void sqlite3SrcListShiftJoinType(SrcList*);
2813 void sqlite3SrcListAssignCursors(Parse*, SrcList*);
2814 void sqlite3IdListDelete(sqlite3*, IdList*);
2815 void sqlite3SrcListDelete(sqlite3*, SrcList*);
2816 Index *sqlite3CreateIndex(Parse*,Token*,Token*,SrcList*,ExprList*,int,Token*,
2817                         Token*, int, int);
2818 void sqlite3DropIndex(Parse*, SrcList*, int);
2819 int sqlite3Select(Parse*, Select*, SelectDest*);
2820 Select *sqlite3SelectNew(Parse*,ExprList*,SrcList*,Expr*,ExprList*,
2821                          Expr*,ExprList*,int,Expr*,Expr*);
2822 void sqlite3SelectDelete(sqlite3*, Select*);
2823 Table *sqlite3SrcListLookup(Parse*, SrcList*);
2824 int sqlite3IsReadOnly(Parse*, Table*, int);
2825 void sqlite3OpenTable(Parse*, int iCur, int iDb, Table*, int);
2826 #if defined(SQLITE_ENABLE_UPDATE_DELETE_LIMIT) && !defined(SQLITE_OMIT_SUBQUERY)
2827 Expr *sqlite3LimitWhere(Parse *, SrcList *, Expr *, ExprList *, Expr *, Expr *, char *);
2828 #endif
2829 void sqlite3DeleteFrom(Parse*, SrcList*, Expr*);
2830 void sqlite3Update(Parse*, SrcList*, ExprList*, Expr*, int);
2831 WhereInfo *sqlite3WhereBegin(Parse*,SrcList*,Expr*,ExprList*,ExprList*,u16,int);
2832 void sqlite3WhereEnd(WhereInfo*);
2833 int sqlite3ExprCodeGetColumn(Parse*, Table*, int, int, int, u8);
2834 void sqlite3ExprCodeGetColumnOfTable(Vdbe*, Table*, int, int, int);
2835 void sqlite3ExprCodeMove(Parse*, int, int, int);
2836 void sqlite3ExprCacheStore(Parse*, int, int, int);
2837 void sqlite3ExprCachePush(Parse*);
2838 void sqlite3ExprCachePop(Parse*, int);
2839 void sqlite3ExprCacheRemove(Parse*, int, int);
2840 void sqlite3ExprCacheClear(Parse*);
2841 void sqlite3ExprCacheAffinityChange(Parse*, int, int);
2842 int sqlite3ExprCode(Parse*, Expr*, int);
2843 int sqlite3ExprCodeTemp(Parse*, Expr*, int*);
2844 int sqlite3ExprCodeTarget(Parse*, Expr*, int);
2845 int sqlite3ExprCodeAndCache(Parse*, Expr*, int);
2846 void sqlite3ExprCodeConstants(Parse*, Expr*);
2847 int sqlite3ExprCodeExprList(Parse*, ExprList*, int, int);
2848 void sqlite3ExprIfTrue(Parse*, Expr*, int, int);
2849 void sqlite3ExprIfFalse(Parse*, Expr*, int, int);
2850 Table *sqlite3FindTable(sqlite3*,const char*, const char*);
2851 Table *sqlite3LocateTable(Parse*,int isView,const char*, const char*);
2852 Table *sqlite3LocateTableItem(Parse*,int isView,struct SrcList_item *);
2853 Index *sqlite3FindIndex(sqlite3*,const char*, const char*);
2854 void sqlite3UnlinkAndDeleteTable(sqlite3*,int,const char*);
2855 void sqlite3UnlinkAndDeleteIndex(sqlite3*,int,const char*);
2856 void sqlite3Vacuum(Parse*);
2857 int sqlite3RunVacuum(char**, sqlite3*);
2858 char *sqlite3NameFromToken(sqlite3*, Token*);
2859 int sqlite3ExprCompare(Expr*, Expr*);
2860 int sqlite3ExprListCompare(ExprList*, ExprList*);
2861 void sqlite3ExprAnalyzeAggregates(NameContext*, Expr*);
2862 void sqlite3ExprAnalyzeAggList(NameContext*,ExprList*);
2863 int sqlite3FunctionUsesThisSrc(Expr*, SrcList*);
2864 Vdbe *sqlite3GetVdbe(Parse*);
2865 void sqlite3PrngSaveState(void);
2866 void sqlite3PrngRestoreState(void);
2867 void sqlite3PrngResetState(void);
2868 void sqlite3RollbackAll(sqlite3*,int);
2869 void sqlite3CodeVerifySchema(Parse*, int);
2870 void sqlite3CodeVerifyNamedSchema(Parse*, const char *zDb);
2871 void sqlite3BeginTransaction(Parse*, int);
2872 void sqlite3CommitTransaction(Parse*);
2873 void sqlite3RollbackTransaction(Parse*);
2874 void sqlite3Savepoint(Parse*, int, Token*);
2875 void sqlite3CloseSavepoints(sqlite3 *);
2876 void sqlite3LeaveMutexAndCloseZombie(sqlite3*);
2877 int sqlite3ExprIsConstant(Expr*);
2878 int sqlite3ExprIsConstantNotJoin(Expr*);
2879 int sqlite3ExprIsConstantOrFunction(Expr*);
2880 int sqlite3ExprIsInteger(Expr*, int*);
2881 int sqlite3ExprCanBeNull(const Expr*);
2882 void sqlite3ExprCodeIsNullJump(Vdbe*, const Expr*, int, int);
2883 int sqlite3ExprNeedsNoAffinityChange(const Expr*, char);
2884 int sqlite3IsRowid(const char*);
2885 void sqlite3GenerateRowDelete(Parse*, Table*, int, int, int, Trigger *, int);
2886 void sqlite3GenerateRowIndexDelete(Parse*, Table*, int, int*);
2887 int sqlite3GenerateIndexKey(Parse*, Index*, int, int, int);
2888 void sqlite3GenerateConstraintChecks(Parse*,Table*,int,int,
2889                                      int*,int,int,int,int,int*);
2890 void sqlite3CompleteInsertion(Parse*, Table*, int, int, int*, int, int, int);
2891 int sqlite3OpenTableAndIndices(Parse*, Table*, int, int);
2892 void sqlite3BeginWriteOperation(Parse*, int, int);
2893 void sqlite3MultiWrite(Parse*);
2894 void sqlite3MayAbort(Parse*);
2895 void sqlite3HaltConstraint(Parse*, int, char*, int);
2896 Expr *sqlite3ExprDup(sqlite3*,Expr*,int);
2897 ExprList *sqlite3ExprListDup(sqlite3*,ExprList*,int);
2898 SrcList *sqlite3SrcListDup(sqlite3*,SrcList*,int);
2899 IdList *sqlite3IdListDup(sqlite3*,IdList*);
2900 Select *sqlite3SelectDup(sqlite3*,Select*,int);
2901 void sqlite3FuncDefInsert(FuncDefHash*, FuncDef*);
2902 FuncDef *sqlite3FindFunction(sqlite3*,const char*,int,int,u8,u8);
2903 void sqlite3RegisterBuiltinFunctions(sqlite3*);
2904 void sqlite3RegisterDateTimeFunctions(void);
2905 void sqlite3RegisterGlobalFunctions(void);
2906 int sqlite3SafetyCheckOk(sqlite3*);
2907 int sqlite3SafetyCheckSickOrOk(sqlite3*);
2908 void sqlite3ChangeCookie(Parse*, int);
2909 
2910 #if !defined(SQLITE_OMIT_VIEW) && !defined(SQLITE_OMIT_TRIGGER)
2911 void sqlite3MaterializeView(Parse*, Table*, Expr*, int);
2912 #endif
2913 
2914 #ifndef SQLITE_OMIT_TRIGGER
2915   void sqlite3BeginTrigger(Parse*, Token*,Token*,int,int,IdList*,SrcList*,
2916                            Expr*,int, int);
2917   void sqlite3FinishTrigger(Parse*, TriggerStep*, Token*);
2918   void sqlite3DropTrigger(Parse*, SrcList*, int);
2919   void sqlite3DropTriggerPtr(Parse*, Trigger*);
2920   Trigger *sqlite3TriggersExist(Parse *, Table*, int, ExprList*, int *pMask);
2921   Trigger *sqlite3TriggerList(Parse *, Table *);
2922   void sqlite3CodeRowTrigger(Parse*, Trigger *, int, ExprList*, int, Table *,
2923                             int, int, int);
2924   void sqlite3CodeRowTriggerDirect(Parse *, Trigger *, Table *, int, int, int);
2925   void sqliteViewTriggers(Parse*, Table*, Expr*, int, ExprList*);
2926   void sqlite3DeleteTriggerStep(sqlite3*, TriggerStep*);
2927   TriggerStep *sqlite3TriggerSelectStep(sqlite3*,Select*);
2928   TriggerStep *sqlite3TriggerInsertStep(sqlite3*,Token*, IdList*,
2929                                         ExprList*,Select*,u8);
2930   TriggerStep *sqlite3TriggerUpdateStep(sqlite3*,Token*,ExprList*, Expr*, u8);
2931   TriggerStep *sqlite3TriggerDeleteStep(sqlite3*,Token*, Expr*);
2932   void sqlite3DeleteTrigger(sqlite3*, Trigger*);
2933   void sqlite3UnlinkAndDeleteTrigger(sqlite3*,int,const char*);
2934   u32 sqlite3TriggerColmask(Parse*,Trigger*,ExprList*,int,int,Table*,int);
2935 # define sqlite3ParseToplevel(p) ((p)->pToplevel ? (p)->pToplevel : (p))
2936 #else
2937 # define sqlite3TriggersExist(B,C,D,E,F) 0
2938 # define sqlite3DeleteTrigger(A,B)
2939 # define sqlite3DropTriggerPtr(A,B)
2940 # define sqlite3UnlinkAndDeleteTrigger(A,B,C)
2941 # define sqlite3CodeRowTrigger(A,B,C,D,E,F,G,H,I)
2942 # define sqlite3CodeRowTriggerDirect(A,B,C,D,E,F)
2943 # define sqlite3TriggerList(X, Y) 0
2944 # define sqlite3ParseToplevel(p) p
2945 # define sqlite3TriggerColmask(A,B,C,D,E,F,G) 0
2946 #endif
2947 
2948 int sqlite3JoinType(Parse*, Token*, Token*, Token*);
2949 void sqlite3CreateForeignKey(Parse*, ExprList*, Token*, ExprList*, int);
2950 void sqlite3DeferForeignKey(Parse*, int);
2951 #ifndef SQLITE_OMIT_AUTHORIZATION
2952   void sqlite3AuthRead(Parse*,Expr*,Schema*,SrcList*);
2953   int sqlite3AuthCheck(Parse*,int, const char*, const char*, const char*);
2954   void sqlite3AuthContextPush(Parse*, AuthContext*, const char*);
2955   void sqlite3AuthContextPop(AuthContext*);
2956   int sqlite3AuthReadCol(Parse*, const char *, const char *, int);
2957 #else
2958 # define sqlite3AuthRead(a,b,c,d)
2959 # define sqlite3AuthCheck(a,b,c,d,e)    SQLITE_OK
2960 # define sqlite3AuthContextPush(a,b,c)
2961 # define sqlite3AuthContextPop(a)  ((void)(a))
2962 #endif
2963 void sqlite3Attach(Parse*, Expr*, Expr*, Expr*);
2964 void sqlite3Detach(Parse*, Expr*);
2965 int sqlite3FixInit(DbFixer*, Parse*, int, const char*, const Token*);
2966 int sqlite3FixSrcList(DbFixer*, SrcList*);
2967 int sqlite3FixSelect(DbFixer*, Select*);
2968 int sqlite3FixExpr(DbFixer*, Expr*);
2969 int sqlite3FixExprList(DbFixer*, ExprList*);
2970 int sqlite3FixTriggerStep(DbFixer*, TriggerStep*);
2971 int sqlite3AtoF(const char *z, double*, int, u8);
2972 int sqlite3GetInt32(const char *, int*);
2973 int sqlite3Atoi(const char*);
2974 int sqlite3Utf16ByteLen(const void *pData, int nChar);
2975 int sqlite3Utf8CharLen(const char *pData, int nByte);
2976 u32 sqlite3Utf8Read(const u8**);
2977 
2978 /*
2979 ** Routines to read and write variable-length integers.  These used to
2980 ** be defined locally, but now we use the varint routines in the util.c
2981 ** file.  Code should use the MACRO forms below, as the Varint32 versions
2982 ** are coded to assume the single byte case is already handled (which
2983 ** the MACRO form does).
2984 */
2985 int sqlite3PutVarint(unsigned char*, u64);
2986 int sqlite3PutVarint32(unsigned char*, u32);
2987 u8 sqlite3GetVarint(const unsigned char *, u64 *);
2988 u8 sqlite3GetVarint32(const unsigned char *, u32 *);
2989 int sqlite3VarintLen(u64 v);
2990 
2991 /*
2992 ** The header of a record consists of a sequence variable-length integers.
2993 ** These integers are almost always small and are encoded as a single byte.
2994 ** The following macros take advantage this fact to provide a fast encode
2995 ** and decode of the integers in a record header.  It is faster for the common
2996 ** case where the integer is a single byte.  It is a little slower when the
2997 ** integer is two or more bytes.  But overall it is faster.
2998 **
2999 ** The following expressions are equivalent:
3000 **
3001 **     x = sqlite3GetVarint32( A, &B );
3002 **     x = sqlite3PutVarint32( A, B );
3003 **
3004 **     x = getVarint32( A, B );
3005 **     x = putVarint32( A, B );
3006 **
3007 */
3008 #define getVarint32(A,B)  (u8)((*(A)<(u8)0x80) ? ((B) = (u32)*(A)),1 : sqlite3GetVarint32((A), (u32 *)&(B)))
3009 #define putVarint32(A,B)  (u8)(((u32)(B)<(u32)0x80) ? (*(A) = (unsigned char)(B)),1 : sqlite3PutVarint32((A), (B)))
3010 #define getVarint    sqlite3GetVarint
3011 #define putVarint    sqlite3PutVarint
3012 
3013 
3014 const char *sqlite3IndexAffinityStr(Vdbe *, Index *);
3015 void sqlite3TableAffinityStr(Vdbe *, Table *);
3016 char sqlite3CompareAffinity(Expr *pExpr, char aff2);
3017 int sqlite3IndexAffinityOk(Expr *pExpr, char idx_affinity);
3018 char sqlite3ExprAffinity(Expr *pExpr);
3019 int sqlite3Atoi64(const char*, i64*, int, u8);
3020 void sqlite3Error(sqlite3*, int, const char*,...);
3021 void *sqlite3HexToBlob(sqlite3*, const char *z, int n);
3022 u8 sqlite3HexToInt(int h);
3023 int sqlite3TwoPartName(Parse *, Token *, Token *, Token **);
3024 const char *sqlite3ErrStr(int);
3025 int sqlite3ReadSchema(Parse *pParse);
3026 CollSeq *sqlite3FindCollSeq(sqlite3*,u8 enc, const char*,int);
3027 CollSeq *sqlite3LocateCollSeq(Parse *pParse, const char*zName);
3028 CollSeq *sqlite3ExprCollSeq(Parse *pParse, Expr *pExpr);
3029 Expr *sqlite3ExprSetColl(Expr*, CollSeq*);
3030 Expr *sqlite3ExprSetCollByToken(Parse *pParse, Expr*, Token*);
3031 int sqlite3CheckCollSeq(Parse *, CollSeq *);
3032 int sqlite3CheckObjectName(Parse *, const char *);
3033 void sqlite3VdbeSetChanges(sqlite3 *, int);
3034 int sqlite3AddInt64(i64*,i64);
3035 int sqlite3SubInt64(i64*,i64);
3036 int sqlite3MulInt64(i64*,i64);
3037 int sqlite3AbsInt32(int);
3038 #ifdef SQLITE_ENABLE_8_3_NAMES
3039 void sqlite3FileSuffix3(const char*, char*);
3040 #else
3041 # define sqlite3FileSuffix3(X,Y)
3042 #endif
3043 u8 sqlite3GetBoolean(const char *z,int);
3044 
3045 const void *sqlite3ValueText(sqlite3_value*, u8);
3046 int sqlite3ValueBytes(sqlite3_value*, u8);
3047 void sqlite3ValueSetStr(sqlite3_value*, int, const void *,u8,
3048                         void(*)(void*));
3049 void sqlite3ValueFree(sqlite3_value*);
3050 sqlite3_value *sqlite3ValueNew(sqlite3 *);
3051 char *sqlite3Utf16to8(sqlite3 *, const void*, int, u8);
3052 #ifdef SQLITE_ENABLE_STAT3
3053 char *sqlite3Utf8to16(sqlite3 *, u8, char *, int, int *);
3054 #endif
3055 int sqlite3ValueFromExpr(sqlite3 *, Expr *, u8, u8, sqlite3_value **);
3056 void sqlite3ValueApplyAffinity(sqlite3_value *, u8, u8);
3057 #ifndef SQLITE_AMALGAMATION
3058 extern const unsigned char sqlite3OpcodeProperty[];
3059 extern const unsigned char sqlite3UpperToLower[];
3060 extern const unsigned char sqlite3CtypeMap[];
3061 extern const Token sqlite3IntTokens[];
3062 extern SQLITE_WSD struct Sqlite3Config sqlite3Config;
3063 extern SQLITE_WSD FuncDefHash sqlite3GlobalFunctions;
3064 #ifndef SQLITE_OMIT_WSD
3065 extern int sqlite3PendingByte;
3066 #endif
3067 #endif
3068 void sqlite3RootPageMoved(sqlite3*, int, int, int);
3069 void sqlite3Reindex(Parse*, Token*, Token*);
3070 void sqlite3AlterFunctions(void);
3071 void sqlite3AlterRenameTable(Parse*, SrcList*, Token*);
3072 int sqlite3GetToken(const unsigned char *, int *);
3073 void sqlite3NestedParse(Parse*, const char*, ...);
3074 void sqlite3ExpirePreparedStatements(sqlite3*);
3075 int sqlite3CodeSubselect(Parse *, Expr *, int, int);
3076 void sqlite3SelectPrep(Parse*, Select*, NameContext*);
3077 int sqlite3ResolveExprNames(NameContext*, Expr*);
3078 void sqlite3ResolveSelectNames(Parse*, Select*, NameContext*);
3079 int sqlite3ResolveOrderGroupBy(Parse*, Select*, ExprList*, const char*);
3080 void sqlite3ColumnDefault(Vdbe *, Table *, int, int);
3081 void sqlite3AlterFinishAddColumn(Parse *, Token *);
3082 void sqlite3AlterBeginAddColumn(Parse *, SrcList *);
3083 CollSeq *sqlite3GetCollSeq(Parse*, u8, CollSeq *, const char*);
3084 char sqlite3AffinityType(const char*);
3085 void sqlite3Analyze(Parse*, Token*, Token*);
3086 int sqlite3InvokeBusyHandler(BusyHandler*);
3087 int sqlite3FindDb(sqlite3*, Token*);
3088 int sqlite3FindDbName(sqlite3 *, const char *);
3089 int sqlite3AnalysisLoad(sqlite3*,int iDB);
3090 void sqlite3DeleteIndexSamples(sqlite3*,Index*);
3091 void sqlite3DefaultRowEst(Index*);
3092 void sqlite3RegisterLikeFunctions(sqlite3*, int);
3093 int sqlite3IsLikeFunction(sqlite3*,Expr*,int*,char*);
3094 void sqlite3MinimumFileFormat(Parse*, int, int);
3095 void sqlite3SchemaClear(void *);
3096 Schema *sqlite3SchemaGet(sqlite3 *, Btree *);
3097 int sqlite3SchemaToIndex(sqlite3 *db, Schema *);
3098 KeyInfo *sqlite3IndexKeyinfo(Parse *, Index *);
3099 int sqlite3CreateFunc(sqlite3 *, const char *, int, int, void *,
3100   void (*)(sqlite3_context*,int,sqlite3_value **),
3101   void (*)(sqlite3_context*,int,sqlite3_value **), void (*)(sqlite3_context*),
3102   FuncDestructor *pDestructor
3103 );
3104 int sqlite3ApiExit(sqlite3 *db, int);
3105 int sqlite3OpenTempDatabase(Parse *);
3106 
3107 void sqlite3StrAccumInit(StrAccum*, char*, int, int);
3108 void sqlite3StrAccumAppend(StrAccum*,const char*,int);
3109 void sqlite3AppendSpace(StrAccum*,int);
3110 char *sqlite3StrAccumFinish(StrAccum*);
3111 void sqlite3StrAccumReset(StrAccum*);
3112 void sqlite3SelectDestInit(SelectDest*,int,int);
3113 Expr *sqlite3CreateColumnExpr(sqlite3 *, SrcList *, int, int);
3114 
3115 void sqlite3BackupRestart(sqlite3_backup *);
3116 void sqlite3BackupUpdate(sqlite3_backup *, Pgno, const u8 *);
3117 
3118 /*
3119 ** The interface to the LEMON-generated parser
3120 */
3121 void *sqlite3ParserAlloc(void*(*)(size_t));
3122 void sqlite3ParserFree(void*, void(*)(void*));
3123 void sqlite3Parser(void*, int, Token, Parse*);
3124 #ifdef YYTRACKMAXSTACKDEPTH
3125   int sqlite3ParserStackPeak(void*);
3126 #endif
3127 
3128 void sqlite3AutoLoadExtensions(sqlite3*);
3129 #ifndef SQLITE_OMIT_LOAD_EXTENSION
3130   void sqlite3CloseExtensions(sqlite3*);
3131 #else
3132 # define sqlite3CloseExtensions(X)
3133 #endif
3134 
3135 #ifndef SQLITE_OMIT_SHARED_CACHE
3136   void sqlite3TableLock(Parse *, int, int, u8, const char *);
3137 #else
3138   #define sqlite3TableLock(v,w,x,y,z)
3139 #endif
3140 
3141 #ifdef SQLITE_TEST
3142   int sqlite3Utf8To8(unsigned char*);
3143 #endif
3144 
3145 #ifdef SQLITE_OMIT_VIRTUALTABLE
3146 #  define sqlite3VtabClear(Y)
3147 #  define sqlite3VtabSync(X,Y) SQLITE_OK
3148 #  define sqlite3VtabRollback(X)
3149 #  define sqlite3VtabCommit(X)
3150 #  define sqlite3VtabInSync(db) 0
3151 #  define sqlite3VtabLock(X)
3152 #  define sqlite3VtabUnlock(X)
3153 #  define sqlite3VtabUnlockList(X)
3154 #  define sqlite3VtabSavepoint(X, Y, Z) SQLITE_OK
3155 #  define sqlite3GetVTable(X,Y)  ((VTable*)0)
3156 #else
3157    void sqlite3VtabClear(sqlite3 *db, Table*);
3158    void sqlite3VtabDisconnect(sqlite3 *db, Table *p);
3159    int sqlite3VtabSync(sqlite3 *db, char **);
3160    int sqlite3VtabRollback(sqlite3 *db);
3161    int sqlite3VtabCommit(sqlite3 *db);
3162    void sqlite3VtabLock(VTable *);
3163    void sqlite3VtabUnlock(VTable *);
3164    void sqlite3VtabUnlockList(sqlite3*);
3165    int sqlite3VtabSavepoint(sqlite3 *, int, int);
3166    VTable *sqlite3GetVTable(sqlite3*, Table*);
3167 #  define sqlite3VtabInSync(db) ((db)->nVTrans>0 && (db)->aVTrans==0)
3168 #endif
3169 void sqlite3VtabMakeWritable(Parse*,Table*);
3170 void sqlite3VtabBeginParse(Parse*, Token*, Token*, Token*, int);
3171 void sqlite3VtabFinishParse(Parse*, Token*);
3172 void sqlite3VtabArgInit(Parse*);
3173 void sqlite3VtabArgExtend(Parse*, Token*);
3174 int sqlite3VtabCallCreate(sqlite3*, int, const char *, char **);
3175 int sqlite3VtabCallConnect(Parse*, Table*);
3176 int sqlite3VtabCallDestroy(sqlite3*, int, const char *);
3177 int sqlite3VtabBegin(sqlite3 *, VTable *);
3178 FuncDef *sqlite3VtabOverloadFunction(sqlite3 *,FuncDef*, int nArg, Expr*);
3179 void sqlite3InvalidFunction(sqlite3_context*,int,sqlite3_value**);
3180 int sqlite3VdbeParameterIndex(Vdbe*, const char*, int);
3181 int sqlite3TransferBindings(sqlite3_stmt *, sqlite3_stmt *);
3182 int sqlite3Reprepare(Vdbe*);
3183 void sqlite3ExprListCheckLength(Parse*, ExprList*, const char*);
3184 CollSeq *sqlite3BinaryCompareCollSeq(Parse *, Expr *, Expr *);
3185 int sqlite3TempInMemory(const sqlite3*);
3186 const char *sqlite3JournalModename(int);
3187 #ifndef SQLITE_OMIT_WAL
3188   int sqlite3Checkpoint(sqlite3*, int, int, int*, int*);
3189   int sqlite3WalDefaultHook(void*,sqlite3*,const char*,int);
3190 #endif
3191 
3192 /* Declarations for functions in fkey.c. All of these are replaced by
3193 ** no-op macros if OMIT_FOREIGN_KEY is defined. In this case no foreign
3194 ** key functionality is available. If OMIT_TRIGGER is defined but
3195 ** OMIT_FOREIGN_KEY is not, only some of the functions are no-oped. In
3196 ** this case foreign keys are parsed, but no other functionality is
3197 ** provided (enforcement of FK constraints requires the triggers sub-system).
3198 */
3199 #if !defined(SQLITE_OMIT_FOREIGN_KEY) && !defined(SQLITE_OMIT_TRIGGER)
3200   void sqlite3FkCheck(Parse*, Table*, int, int);
3201   void sqlite3FkDropTable(Parse*, SrcList *, Table*);
3202   void sqlite3FkActions(Parse*, Table*, ExprList*, int);
3203   int sqlite3FkRequired(Parse*, Table*, int*, int);
3204   u32 sqlite3FkOldmask(Parse*, Table*);
3205   FKey *sqlite3FkReferences(Table *);
3206 #else
3207   #define sqlite3FkActions(a,b,c,d)
3208   #define sqlite3FkCheck(a,b,c,d)
3209   #define sqlite3FkDropTable(a,b,c)
3210   #define sqlite3FkOldmask(a,b)      0
3211   #define sqlite3FkRequired(a,b,c,d) 0
3212 #endif
3213 #ifndef SQLITE_OMIT_FOREIGN_KEY
3214   void sqlite3FkDelete(sqlite3 *, Table*);
3215 #else
3216   #define sqlite3FkDelete(a,b)
3217 #endif
3218 
3219 
3220 /*
3221 ** Available fault injectors.  Should be numbered beginning with 0.
3222 */
3223 #define SQLITE_FAULTINJECTOR_MALLOC     0
3224 #define SQLITE_FAULTINJECTOR_COUNT      1
3225 
3226 /*
3227 ** The interface to the code in fault.c used for identifying "benign"
3228 ** malloc failures. This is only present if SQLITE_OMIT_BUILTIN_TEST
3229 ** is not defined.
3230 */
3231 #ifndef SQLITE_OMIT_BUILTIN_TEST
3232   void sqlite3BeginBenignMalloc(void);
3233   void sqlite3EndBenignMalloc(void);
3234 #else
3235   #define sqlite3BeginBenignMalloc()
3236   #define sqlite3EndBenignMalloc()
3237 #endif
3238 
3239 #define IN_INDEX_ROWID           1
3240 #define IN_INDEX_EPH             2
3241 #define IN_INDEX_INDEX           3
3242 int sqlite3FindInIndex(Parse *, Expr *, int*);
3243 
3244 #ifdef SQLITE_ENABLE_ATOMIC_WRITE
3245   int sqlite3JournalOpen(sqlite3_vfs *, const char *, sqlite3_file *, int, int);
3246   int sqlite3JournalSize(sqlite3_vfs *);
3247   int sqlite3JournalCreate(sqlite3_file *);
3248 #else
3249   #define sqlite3JournalSize(pVfs) ((pVfs)->szOsFile)
3250 #endif
3251 
3252 void sqlite3MemJournalOpen(sqlite3_file *);
3253 int sqlite3MemJournalSize(void);
3254 int sqlite3IsMemJournal(sqlite3_file *);
3255 
3256 #if SQLITE_MAX_EXPR_DEPTH>0
3257   void sqlite3ExprSetHeight(Parse *pParse, Expr *p);
3258   int sqlite3SelectExprHeight(Select *);
3259   int sqlite3ExprCheckHeight(Parse*, int);
3260 #else
3261   #define sqlite3ExprSetHeight(x,y)
3262   #define sqlite3SelectExprHeight(x) 0
3263   #define sqlite3ExprCheckHeight(x,y)
3264 #endif
3265 
3266 u32 sqlite3Get4byte(const u8*);
3267 void sqlite3Put4byte(u8*, u32);
3268 
3269 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
3270   void sqlite3ConnectionBlocked(sqlite3 *, sqlite3 *);
3271   void sqlite3ConnectionUnlocked(sqlite3 *db);
3272   void sqlite3ConnectionClosed(sqlite3 *db);
3273 #else
3274   #define sqlite3ConnectionBlocked(x,y)
3275   #define sqlite3ConnectionUnlocked(x)
3276   #define sqlite3ConnectionClosed(x)
3277 #endif
3278 
3279 #ifdef SQLITE_DEBUG
3280   void sqlite3ParserTrace(FILE*, char *);
3281 #endif
3282 
3283 /*
3284 ** If the SQLITE_ENABLE IOTRACE exists then the global variable
3285 ** sqlite3IoTrace is a pointer to a printf-like routine used to
3286 ** print I/O tracing messages.
3287 */
3288 #ifdef SQLITE_ENABLE_IOTRACE
3289 # define IOTRACE(A)  if( sqlite3IoTrace ){ sqlite3IoTrace A; }
3290   void sqlite3VdbeIOTraceSql(Vdbe*);
3291 SQLITE_EXTERN void (*sqlite3IoTrace)(const char*,...);
3292 #else
3293 # define IOTRACE(A)
3294 # define sqlite3VdbeIOTraceSql(X)
3295 #endif
3296 
3297 /*
3298 ** These routines are available for the mem2.c debugging memory allocator
3299 ** only.  They are used to verify that different "types" of memory
3300 ** allocations are properly tracked by the system.
3301 **
3302 ** sqlite3MemdebugSetType() sets the "type" of an allocation to one of
3303 ** the MEMTYPE_* macros defined below.  The type must be a bitmask with
3304 ** a single bit set.
3305 **
3306 ** sqlite3MemdebugHasType() returns true if any of the bits in its second
3307 ** argument match the type set by the previous sqlite3MemdebugSetType().
3308 ** sqlite3MemdebugHasType() is intended for use inside assert() statements.
3309 **
3310 ** sqlite3MemdebugNoType() returns true if none of the bits in its second
3311 ** argument match the type set by the previous sqlite3MemdebugSetType().
3312 **
3313 ** Perhaps the most important point is the difference between MEMTYPE_HEAP
3314 ** and MEMTYPE_LOOKASIDE.  If an allocation is MEMTYPE_LOOKASIDE, that means
3315 ** it might have been allocated by lookaside, except the allocation was
3316 ** too large or lookaside was already full.  It is important to verify
3317 ** that allocations that might have been satisfied by lookaside are not
3318 ** passed back to non-lookaside free() routines.  Asserts such as the
3319 ** example above are placed on the non-lookaside free() routines to verify
3320 ** this constraint.
3321 **
3322 ** All of this is no-op for a production build.  It only comes into
3323 ** play when the SQLITE_MEMDEBUG compile-time option is used.
3324 */
3325 #ifdef SQLITE_MEMDEBUG
3326   void sqlite3MemdebugSetType(void*,u8);
3327   int sqlite3MemdebugHasType(void*,u8);
3328   int sqlite3MemdebugNoType(void*,u8);
3329 #else
3330 # define sqlite3MemdebugSetType(X,Y)  /* no-op */
3331 # define sqlite3MemdebugHasType(X,Y)  1
3332 # define sqlite3MemdebugNoType(X,Y)   1
3333 #endif
3334 #define MEMTYPE_HEAP       0x01  /* General heap allocations */
3335 #define MEMTYPE_LOOKASIDE  0x02  /* Might have been lookaside memory */
3336 #define MEMTYPE_SCRATCH    0x04  /* Scratch allocations */
3337 #define MEMTYPE_PCACHE     0x08  /* Page cache allocations */
3338 #define MEMTYPE_DB         0x10  /* Uses sqlite3DbMalloc, not sqlite_malloc */
3339 
3340 #endif /* _SQLITEINT_H_ */
3341