global.c 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232
  1. /*
  2. ** 2008 June 13
  3. **
  4. ** The author disclaims copyright to this source code. In place of
  5. ** a legal notice, here is a blessing:
  6. **
  7. ** May you do good and not evil.
  8. ** May you find forgiveness for yourself and forgive others.
  9. ** May you share freely, never taking more than you give.
  10. **
  11. *************************************************************************
  12. **
  13. ** This file contains definitions of global variables and contants.
  14. */
  15. #include "sqliteInt.h"
  16. /* An array to map all upper-case characters into their corresponding
  17. ** lower-case character.
  18. **
  19. ** SQLite only considers US-ASCII (or EBCDIC) characters. We do not
  20. ** handle case conversions for the UTF character set since the tables
  21. ** involved are nearly as big or bigger than SQLite itself.
  22. */
  23. const unsigned char sqlite3UpperToLower[] = {
  24. #ifdef SQLITE_ASCII
  25. 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17,
  26. 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35,
  27. 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53,
  28. 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 97, 98, 99,100,101,102,103,
  29. 104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,
  30. 122, 91, 92, 93, 94, 95, 96, 97, 98, 99,100,101,102,103,104,105,106,107,
  31. 108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,
  32. 126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,
  33. 144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,
  34. 162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,
  35. 180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,
  36. 198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,
  37. 216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,
  38. 234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,
  39. 252,253,254,255
  40. #endif
  41. #ifdef SQLITE_EBCDIC
  42. 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, /* 0x */
  43. 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, /* 1x */
  44. 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, /* 2x */
  45. 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, /* 3x */
  46. 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, /* 4x */
  47. 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, /* 5x */
  48. 96, 97, 66, 67, 68, 69, 70, 71, 72, 73,106,107,108,109,110,111, /* 6x */
  49. 112, 81, 82, 83, 84, 85, 86, 87, 88, 89,122,123,124,125,126,127, /* 7x */
  50. 128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143, /* 8x */
  51. 144,145,146,147,148,149,150,151,152,153,154,155,156,157,156,159, /* 9x */
  52. 160,161,162,163,164,165,166,167,168,169,170,171,140,141,142,175, /* Ax */
  53. 176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191, /* Bx */
  54. 192,129,130,131,132,133,134,135,136,137,202,203,204,205,206,207, /* Cx */
  55. 208,145,146,147,148,149,150,151,152,153,218,219,220,221,222,223, /* Dx */
  56. 224,225,162,163,164,165,166,167,168,169,232,203,204,205,206,207, /* Ex */
  57. 239,240,241,242,243,244,245,246,247,248,249,219,220,221,222,255, /* Fx */
  58. #endif
  59. };
  60. /*
  61. ** The following 256 byte lookup table is used to support SQLites built-in
  62. ** equivalents to the following standard library functions:
  63. **
  64. ** isspace() 0x01
  65. ** isalpha() 0x02
  66. ** isdigit() 0x04
  67. ** isalnum() 0x06
  68. ** isxdigit() 0x08
  69. ** toupper() 0x20
  70. ** SQLite identifier character 0x40
  71. **
  72. ** Bit 0x20 is set if the mapped character requires translation to upper
  73. ** case. i.e. if the character is a lower-case ASCII character.
  74. ** If x is a lower-case ASCII character, then its upper-case equivalent
  75. ** is (x - 0x20). Therefore toupper() can be implemented as:
  76. **
  77. ** (x & ~(map[x]&0x20))
  78. **
  79. ** Standard function tolower() is implemented using the sqlite3UpperToLower[]
  80. ** array. tolower() is used more often than toupper() by SQLite.
  81. **
  82. ** Bit 0x40 is set if the character non-alphanumeric and can be used in an
  83. ** SQLite identifier. Identifiers are alphanumerics, "_", "$", and any
  84. ** non-ASCII UTF character. Hence the test for whether or not a character is
  85. ** part of an identifier is 0x46.
  86. **
  87. ** SQLite's versions are identical to the standard versions assuming a
  88. ** locale of "C". They are implemented as macros in sqliteInt.h.
  89. */
  90. #ifdef SQLITE_ASCII
  91. const unsigned char sqlite3CtypeMap[256] = {
  92. 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, /* 00..07 ........ */
  93. 0x00, 0x01, 0x01, 0x01, 0x01, 0x01, 0x00, 0x00, /* 08..0f ........ */
  94. 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, /* 10..17 ........ */
  95. 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, /* 18..1f ........ */
  96. 0x01, 0x00, 0x00, 0x00, 0x40, 0x00, 0x00, 0x00, /* 20..27 !"#$%&' */
  97. 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, /* 28..2f ()*+,-./ */
  98. 0x0c, 0x0c, 0x0c, 0x0c, 0x0c, 0x0c, 0x0c, 0x0c, /* 30..37 01234567 */
  99. 0x0c, 0x0c, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, /* 38..3f 89:;<=>? */
  100. 0x00, 0x0a, 0x0a, 0x0a, 0x0a, 0x0a, 0x0a, 0x02, /* 40..47 @ABCDEFG */
  101. 0x02, 0x02, 0x02, 0x02, 0x02, 0x02, 0x02, 0x02, /* 48..4f HIJKLMNO */
  102. 0x02, 0x02, 0x02, 0x02, 0x02, 0x02, 0x02, 0x02, /* 50..57 PQRSTUVW */
  103. 0x02, 0x02, 0x02, 0x00, 0x00, 0x00, 0x00, 0x40, /* 58..5f XYZ[\]^_ */
  104. 0x00, 0x2a, 0x2a, 0x2a, 0x2a, 0x2a, 0x2a, 0x22, /* 60..67 `abcdefg */
  105. 0x22, 0x22, 0x22, 0x22, 0x22, 0x22, 0x22, 0x22, /* 68..6f hijklmno */
  106. 0x22, 0x22, 0x22, 0x22, 0x22, 0x22, 0x22, 0x22, /* 70..77 pqrstuvw */
  107. 0x22, 0x22, 0x22, 0x00, 0x00, 0x00, 0x00, 0x00, /* 78..7f xyz{|}~. */
  108. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* 80..87 ........ */
  109. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* 88..8f ........ */
  110. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* 90..97 ........ */
  111. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* 98..9f ........ */
  112. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* a0..a7 ........ */
  113. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* a8..af ........ */
  114. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* b0..b7 ........ */
  115. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* b8..bf ........ */
  116. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* c0..c7 ........ */
  117. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* c8..cf ........ */
  118. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* d0..d7 ........ */
  119. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* d8..df ........ */
  120. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* e0..e7 ........ */
  121. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* e8..ef ........ */
  122. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, /* f0..f7 ........ */
  123. 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40, 0x40 /* f8..ff ........ */
  124. };
  125. #endif
  126. #ifndef SQLITE_USE_URI
  127. # define SQLITE_USE_URI 0
  128. #endif
  129. #ifndef SQLITE_ALLOW_COVERING_INDEX_SCAN
  130. # define SQLITE_ALLOW_COVERING_INDEX_SCAN 1
  131. #endif
  132. /*
  133. ** The following singleton contains the global configuration for
  134. ** the SQLite library.
  135. */
  136. SQLITE_WSD struct Sqlite3Config sqlite3Config = {
  137. SQLITE_DEFAULT_MEMSTATUS, /* bMemstat */
  138. 1, /* bCoreMutex */
  139. SQLITE_THREADSAFE==1, /* bFullMutex */
  140. SQLITE_USE_URI, /* bOpenUri */
  141. SQLITE_ALLOW_COVERING_INDEX_SCAN, /* bUseCis */
  142. 0x7ffffffe, /* mxStrlen */
  143. 128, /* szLookaside */
  144. 500, /* nLookaside */
  145. {0,0,0,0,0,0,0,0}, /* m */
  146. {0,0,0,0,0,0,0,0,0}, /* mutex */
  147. {0,0,0,0,0,0,0,0,0,0,0,0,0},/* pcache2 */
  148. (void*)0, /* pHeap */
  149. 0, /* nHeap */
  150. 0, 0, /* mnHeap, mxHeap */
  151. SQLITE_DEFAULT_MMAP_SIZE, /* szMmap */
  152. SQLITE_MAX_MMAP_SIZE, /* mxMmap */
  153. (void*)0, /* pScratch */
  154. 0, /* szScratch */
  155. 0, /* nScratch */
  156. (void*)0, /* pPage */
  157. 0, /* szPage */
  158. 0, /* nPage */
  159. 0, /* mxParserStack */
  160. 0, /* sharedCacheEnabled */
  161. /* All the rest should always be initialized to zero */
  162. 0, /* isInit */
  163. 0, /* inProgress */
  164. 0, /* isMutexInit */
  165. 0, /* isMallocInit */
  166. 0, /* isPCacheInit */
  167. 0, /* pInitMutex */
  168. 0, /* nRefInitMutex */
  169. 0, /* xLog */
  170. 0, /* pLogArg */
  171. 0, /* bLocaltimeFault */
  172. #ifdef SQLITE_ENABLE_SQLLOG
  173. 0, /* xSqllog */
  174. 0 /* pSqllogArg */
  175. #endif
  176. };
  177. /*
  178. ** Hash table for global functions - functions common to all
  179. ** database connections. After initialization, this table is
  180. ** read-only.
  181. */
  182. SQLITE_WSD FuncDefHash sqlite3GlobalFunctions;
  183. /*
  184. ** Constant tokens for values 0 and 1.
  185. */
  186. const Token sqlite3IntTokens[] = {
  187. { "0", 1 },
  188. { "1", 1 }
  189. };
  190. /*
  191. ** The value of the "pending" byte must be 0x40000000 (1 byte past the
  192. ** 1-gibabyte boundary) in a compatible database. SQLite never uses
  193. ** the database page that contains the pending byte. It never attempts
  194. ** to read or write that page. The pending byte page is set assign
  195. ** for use by the VFS layers as space for managing file locks.
  196. **
  197. ** During testing, it is often desirable to move the pending byte to
  198. ** a different position in the file. This allows code that has to
  199. ** deal with the pending byte to run on files that are much smaller
  200. ** than 1 GiB. The sqlite3_test_control() interface can be used to
  201. ** move the pending byte.
  202. **
  203. ** IMPORTANT: Changing the pending byte to any value other than
  204. ** 0x40000000 results in an incompatible database file format!
  205. ** Changing the pending byte during operating results in undefined
  206. ** and dileterious behavior.
  207. */
  208. #ifndef SQLITE_OMIT_WSD
  209. int sqlite3PendingByte = 0x40000000;
  210. #endif
  211. #include "opcodes.h"
  212. /*
  213. ** Properties of opcodes. The OPFLG_INITIALIZER macro is
  214. ** created by mkopcodeh.awk during compilation. Data is obtained
  215. ** from the comments following the "case OP_xxxx:" statements in
  216. ** the vdbe.c file.
  217. */
  218. const unsigned char sqlite3OpcodeProperty[] = OPFLG_INITIALIZER;