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