blob: fd6abb67f27a054b91bafc52e3081d60d6922832 [file] [log] [blame]
drh75897232000-05-29 14:26:00 +00001/*
drhb19a2bc2001-09-16 00:13:26 +00002** 2001 September 15
drh75897232000-05-29 14:26:00 +00003**
drhb19a2bc2001-09-16 00:13:26 +00004** The author disclaims copyright to this source code. In place of
5** a legal notice, here is a blessing:
drh75897232000-05-29 14:26:00 +00006**
drhb19a2bc2001-09-16 00:13:26 +00007** 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.
drh75897232000-05-29 14:26:00 +000010**
11*************************************************************************
12** Main file for the SQLite library. The routines in this file
13** implement the programmer interface to the library. Routines in
14** other files are for internal use by SQLite and should not be
15** accessed by users of the library.
16**
drh3abbd392008-12-10 23:04:13 +000017** $Id: main.c,v 1.519 2008/12/10 23:04:13 drh Exp $
drh75897232000-05-29 14:26:00 +000018*/
19#include "sqliteInt.h"
drhce9079c2002-05-15 14:17:44 +000020#include <ctype.h>
drh58f1c8b2008-05-26 20:19:25 +000021
drh820a9062008-01-31 13:35:48 +000022#ifdef SQLITE_ENABLE_FTS3
23# include "fts3.h"
24#endif
drh58f1c8b2008-05-26 20:19:25 +000025#ifdef SQLITE_ENABLE_RTREE
26# include "rtree.h"
27#endif
danielk19771c826652008-09-08 08:08:09 +000028#ifdef SQLITE_ENABLE_ICU
29# include "sqliteicu.h"
30#endif
drh75897232000-05-29 14:26:00 +000031
32/*
drhb217a572000-08-22 13:40:18 +000033** The version of the library
34*/
drhb3190c12008-12-08 21:37:14 +000035#ifndef SQLITE_AMALGAMATION
danielk197724b03fd2004-05-10 10:34:34 +000036const char sqlite3_version[] = SQLITE_VERSION;
drhb3190c12008-12-08 21:37:14 +000037#endif
drh4aec8b62004-08-28 16:19:00 +000038const char *sqlite3_libversion(void){ return sqlite3_version; }
danielk197799ba19e2005-02-05 07:33:34 +000039int sqlite3_libversion_number(void){ return SQLITE_VERSION_NUMBER; }
drhb67e8bf2007-08-30 20:09:48 +000040int sqlite3_threadsafe(void){ return SQLITE_THREADSAFE; }
drhb217a572000-08-22 13:40:18 +000041
drhe265b082008-05-01 17:03:49 +000042#if !defined(SQLITE_OMIT_TRACE) && defined(SQLITE_ENABLE_IOTRACE)
drhb217a572000-08-22 13:40:18 +000043/*
drhb0603412007-02-28 04:47:26 +000044** If the following function pointer is not NULL and if
45** SQLITE_ENABLE_IOTRACE is enabled, then messages describing
46** I/O active are written using this function. These messages
47** are intended for debugging activity only.
48*/
mlcreech3a00f902008-03-04 17:45:01 +000049void (*sqlite3IoTrace)(const char*, ...) = 0;
drhe265b082008-05-01 17:03:49 +000050#endif
drhb0603412007-02-28 04:47:26 +000051
52/*
drha16313e2007-03-30 11:29:32 +000053** If the following global variable points to a string which is the
54** name of a directory, then that directory will be used to store
55** temporary files.
56**
57** See also the "PRAGMA temp_store_directory" SQL command.
58*/
59char *sqlite3_temp_directory = 0;
60
drhc5499be2008-04-01 15:06:33 +000061/*
drh40257ff2008-06-13 18:24:27 +000062** Initialize SQLite.
63**
64** This routine must be called to initialize the memory allocation,
drh93ed56d2008-08-12 15:21:11 +000065** VFS, and mutex subsystems prior to doing any serious work with
drh40257ff2008-06-13 18:24:27 +000066** SQLite. But as long as you do not compile with SQLITE_OMIT_AUTOINIT
67** this routine will be called automatically by key routines such as
68** sqlite3_open().
69**
70** This routine is a no-op except on its very first call for the process,
71** or for the first call after a call to sqlite3_shutdown.
drh93ed56d2008-08-12 15:21:11 +000072**
73** The first thread to call this routine runs the initialization to
74** completion. If subsequent threads call this routine before the first
75** thread has finished the initialization process, then the subsequent
76** threads must block until the first thread finishes with the initialization.
77**
78** The first thread might call this routine recursively. Recursive
79** calls to this routine should not block, of course. Otherwise the
80** initialization process would never complete.
81**
82** Let X be the first thread to enter this routine. Let Y be some other
83** thread. Then while the initial invocation of this routine by X is
84** incomplete, it is required that:
85**
86** * Calls to this routine from Y must block until the outer-most
87** call by X completes.
88**
89** * Recursive calls to this routine from thread X return immediately
90** without blocking.
drh40257ff2008-06-13 18:24:27 +000091*/
92int sqlite3_initialize(void){
danielk1977075c23a2008-09-01 18:34:20 +000093 sqlite3_mutex *pMaster; /* The main static mutex */
94 int rc; /* Result code */
95
96#ifdef SQLITE_OMIT_WSD
danielk1977a8f83bf2008-09-02 16:22:28 +000097 rc = sqlite3_wsd_init(4096, 24);
danielk1977075c23a2008-09-01 18:34:20 +000098 if( rc!=SQLITE_OK ){
99 return rc;
100 }
101#endif
danielk197771bc31c2008-06-26 08:29:34 +0000102
drh93ed56d2008-08-12 15:21:11 +0000103 /* If SQLite is already completely initialized, then this call
104 ** to sqlite3_initialize() should be a no-op. But the initialization
105 ** must be complete. So isInit must not be set until the very end
106 ** of this routine.
107 */
danielk1977075c23a2008-09-01 18:34:20 +0000108 if( sqlite3GlobalConfig.isInit ) return SQLITE_OK;
danielk197771bc31c2008-06-26 08:29:34 +0000109
drh93ed56d2008-08-12 15:21:11 +0000110 /* Make sure the mutex subsystem is initialized. If unable to
111 ** initialize the mutex subsystem, return early with the error.
112 ** If the system is so sick that we are unable to allocate a mutex,
113 ** there is not much SQLite is going to be able to do.
114 **
115 ** The mutex subsystem must take care of serializing its own
116 ** initialization.
117 */
danielk1977d0251742008-06-18 18:57:42 +0000118 rc = sqlite3MutexInit();
drh93ed56d2008-08-12 15:21:11 +0000119 if( rc ) return rc;
danielk197771bc31c2008-06-26 08:29:34 +0000120
drh93ed56d2008-08-12 15:21:11 +0000121 /* Initialize the malloc() system and the recursive pInitMutex mutex.
122 ** This operation is protected by the STATIC_MASTER mutex. Note that
123 ** MutexAlloc() is called for a static mutex prior to initializing the
124 ** malloc subsystem - this implies that the allocation of a static
125 ** mutex must not require support from the malloc subsystem.
126 */
127 pMaster = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER);
128 sqlite3_mutex_enter(pMaster);
danielk1977075c23a2008-09-01 18:34:20 +0000129 if( !sqlite3GlobalConfig.isMallocInit ){
drh93ed56d2008-08-12 15:21:11 +0000130 rc = sqlite3MallocInit();
131 }
drh40257ff2008-06-13 18:24:27 +0000132 if( rc==SQLITE_OK ){
danielk1977075c23a2008-09-01 18:34:20 +0000133 sqlite3GlobalConfig.isMallocInit = 1;
134 if( !sqlite3GlobalConfig.pInitMutex ){
135 sqlite3GlobalConfig.pInitMutex = sqlite3MutexAlloc(SQLITE_MUTEX_RECURSIVE);
136 if( sqlite3GlobalConfig.bCoreMutex && !sqlite3GlobalConfig.pInitMutex ){
drh93ed56d2008-08-12 15:21:11 +0000137 rc = SQLITE_NOMEM;
drh40257ff2008-06-13 18:24:27 +0000138 }
139 }
danielk197777eb5bb2008-09-22 17:22:19 +0000140 }
141 if( rc==SQLITE_OK ){
danielk1977075c23a2008-09-01 18:34:20 +0000142 sqlite3GlobalConfig.nRefInitMutex++;
drh93ed56d2008-08-12 15:21:11 +0000143 }
144 sqlite3_mutex_leave(pMaster);
danielk197771bc31c2008-06-26 08:29:34 +0000145
drh93ed56d2008-08-12 15:21:11 +0000146 /* If unable to initialize the malloc subsystem, then return early.
147 ** There is little hope of getting SQLite to run if the malloc
148 ** subsystem cannot be initialized.
149 */
150 if( rc!=SQLITE_OK ){
151 return rc;
152 }
153
154 /* Do the rest of the initialization under the recursive mutex so
155 ** that we will be able to handle recursive calls into
156 ** sqlite3_initialize(). The recursive calls normally come through
157 ** sqlite3_os_init() when it invokes sqlite3_vfs_register(), but other
158 ** recursive calls might also be possible.
159 */
danielk1977075c23a2008-09-01 18:34:20 +0000160 sqlite3_mutex_enter(sqlite3GlobalConfig.pInitMutex);
danielk1977502b4e02008-09-02 14:07:24 +0000161 if( sqlite3GlobalConfig.isInit==0 && sqlite3GlobalConfig.inProgress==0 ){
danielk1977075c23a2008-09-01 18:34:20 +0000162 FuncDefHash *pHash = &GLOBAL(FuncDefHash, sqlite3GlobalFunctions);
danielk1977502b4e02008-09-02 14:07:24 +0000163 sqlite3GlobalConfig.inProgress = 1;
danielk1977075c23a2008-09-01 18:34:20 +0000164 memset(pHash, 0, sizeof(sqlite3GlobalFunctions));
drh70a8ca32008-08-21 18:49:27 +0000165 sqlite3RegisterGlobalFunctions();
danielk197771bc31c2008-06-26 08:29:34 +0000166 rc = sqlite3_os_init();
danielk19778c0a7912008-08-20 14:49:23 +0000167 if( rc==SQLITE_OK ){
168 rc = sqlite3PcacheInitialize();
danielk19775b775292008-09-02 09:38:06 +0000169 sqlite3PCacheBufferSetup( sqlite3GlobalConfig.pPage,
170 sqlite3GlobalConfig.szPage, sqlite3GlobalConfig.nPage);
danielk19778c0a7912008-08-20 14:49:23 +0000171 }
danielk1977502b4e02008-09-02 14:07:24 +0000172 sqlite3GlobalConfig.inProgress = 0;
danielk1977075c23a2008-09-01 18:34:20 +0000173 sqlite3GlobalConfig.isInit = (rc==SQLITE_OK ? 1 : 0);
drh40257ff2008-06-13 18:24:27 +0000174 }
danielk1977075c23a2008-09-01 18:34:20 +0000175 sqlite3_mutex_leave(sqlite3GlobalConfig.pInitMutex);
shanedfb7b372008-07-22 05:13:30 +0000176
drh93ed56d2008-08-12 15:21:11 +0000177 /* Go back under the static mutex and clean up the recursive
178 ** mutex to prevent a resource leak.
179 */
180 sqlite3_mutex_enter(pMaster);
danielk1977075c23a2008-09-01 18:34:20 +0000181 sqlite3GlobalConfig.nRefInitMutex--;
182 if( sqlite3GlobalConfig.nRefInitMutex<=0 ){
183 assert( sqlite3GlobalConfig.nRefInitMutex==0 );
184 sqlite3_mutex_free(sqlite3GlobalConfig.pInitMutex);
185 sqlite3GlobalConfig.pInitMutex = 0;
drh93ed56d2008-08-12 15:21:11 +0000186 }
187 sqlite3_mutex_leave(pMaster);
188
189 /* The following is just a sanity check to make sure SQLite has
190 ** been compiled correctly. It is important to run this code, but
191 ** we don't want to run it too often and soak up CPU cycles for no
192 ** reason. So we run it once during initialization.
193 */
shanedfb7b372008-07-22 05:13:30 +0000194#ifndef NDEBUG
195 /* This section of code's only "output" is via assert() statements. */
196 if ( rc==SQLITE_OK ){
197 u64 x = (((u64)1)<<63)-1;
198 double y;
199 assert(sizeof(x)==8);
200 assert(sizeof(x)==sizeof(y));
201 memcpy(&y, &x, 8);
202 assert( sqlite3IsNaN(y) );
203 }
204#endif
205
drh40257ff2008-06-13 18:24:27 +0000206 return rc;
207}
208
209/*
210** Undo the effects of sqlite3_initialize(). Must not be called while
211** there are outstanding database connections or memory allocations or
212** while any part of SQLite is otherwise in use in any thread. This
213** routine is not threadsafe. Not by a long shot.
214*/
215int sqlite3_shutdown(void){
danielk1977075c23a2008-09-01 18:34:20 +0000216 sqlite3GlobalConfig.isMallocInit = 0;
danielk19778c0a7912008-08-20 14:49:23 +0000217 sqlite3PcacheShutdown();
danielk1977075c23a2008-09-01 18:34:20 +0000218 if( sqlite3GlobalConfig.isInit ){
danielk1977fb437272008-07-08 12:02:35 +0000219 sqlite3_os_end();
220 }
drh1b67f3c2008-10-10 17:41:28 +0000221 sqlite3MallocEnd();
drh1b67f3c2008-10-10 17:41:28 +0000222 sqlite3MutexEnd();
danielk1977075c23a2008-09-01 18:34:20 +0000223 sqlite3GlobalConfig.isInit = 0;
drh40257ff2008-06-13 18:24:27 +0000224 return SQLITE_OK;
225}
226
227/*
228** This API allows applications to modify the global configuration of
229** the SQLite library at run-time.
230**
231** This routine should only be called when there are no outstanding
232** database connections or memory allocations. This routine is not
233** threadsafe. Failure to heed these warnings can lead to unpredictable
234** behavior.
235*/
236int sqlite3_config(int op, ...){
237 va_list ap;
238 int rc = SQLITE_OK;
239
240 /* sqlite3_config() shall return SQLITE_MISUSE if it is invoked while
241 ** the SQLite library is in use. */
danielk1977075c23a2008-09-01 18:34:20 +0000242 if( sqlite3GlobalConfig.isInit ) return SQLITE_MISUSE;
drh40257ff2008-06-13 18:24:27 +0000243
244 va_start(ap, op);
245 switch( op ){
drh18472fa2008-10-07 15:25:48 +0000246
247 /* Mutex configuration options are only available in a threadsafe
248 ** compile.
249 */
250#if SQLITE_THREADSAFE
drh40257ff2008-06-13 18:24:27 +0000251 case SQLITE_CONFIG_SINGLETHREAD: {
252 /* Disable all mutexing */
danielk1977075c23a2008-09-01 18:34:20 +0000253 sqlite3GlobalConfig.bCoreMutex = 0;
254 sqlite3GlobalConfig.bFullMutex = 0;
drh40257ff2008-06-13 18:24:27 +0000255 break;
256 }
257 case SQLITE_CONFIG_MULTITHREAD: {
258 /* Disable mutexing of database connections */
259 /* Enable mutexing of core data structures */
danielk1977075c23a2008-09-01 18:34:20 +0000260 sqlite3GlobalConfig.bCoreMutex = 1;
261 sqlite3GlobalConfig.bFullMutex = 0;
drh40257ff2008-06-13 18:24:27 +0000262 break;
263 }
264 case SQLITE_CONFIG_SERIALIZED: {
265 /* Enable all mutexing */
danielk1977075c23a2008-09-01 18:34:20 +0000266 sqlite3GlobalConfig.bCoreMutex = 1;
267 sqlite3GlobalConfig.bFullMutex = 1;
drh40257ff2008-06-13 18:24:27 +0000268 break;
269 }
drh18472fa2008-10-07 15:25:48 +0000270 case SQLITE_CONFIG_MUTEX: {
271 /* Specify an alternative mutex implementation */
272 sqlite3GlobalConfig.mutex = *va_arg(ap, sqlite3_mutex_methods*);
273 break;
274 }
275 case SQLITE_CONFIG_GETMUTEX: {
276 /* Retrieve the current mutex implementation */
277 *va_arg(ap, sqlite3_mutex_methods*) = sqlite3GlobalConfig.mutex;
278 break;
279 }
280#endif
281
282
drh40257ff2008-06-13 18:24:27 +0000283 case SQLITE_CONFIG_MALLOC: {
284 /* Specify an alternative malloc implementation */
danielk1977075c23a2008-09-01 18:34:20 +0000285 sqlite3GlobalConfig.m = *va_arg(ap, sqlite3_mem_methods*);
drh40257ff2008-06-13 18:24:27 +0000286 break;
287 }
drh33589792008-06-18 13:27:46 +0000288 case SQLITE_CONFIG_GETMALLOC: {
danielk197757e5ea92008-06-24 19:02:55 +0000289 /* Retrieve the current malloc() implementation */
danielk1977075c23a2008-09-01 18:34:20 +0000290 if( sqlite3GlobalConfig.m.xMalloc==0 ) sqlite3MemSetDefault();
291 *va_arg(ap, sqlite3_mem_methods*) = sqlite3GlobalConfig.m;
drh33589792008-06-18 13:27:46 +0000292 break;
293 }
drhfec00ea2008-06-14 16:56:21 +0000294 case SQLITE_CONFIG_MEMSTATUS: {
drh40257ff2008-06-13 18:24:27 +0000295 /* Enable or disable the malloc status collection */
danielk1977075c23a2008-09-01 18:34:20 +0000296 sqlite3GlobalConfig.bMemstat = va_arg(ap, int);
drh40257ff2008-06-13 18:24:27 +0000297 break;
298 }
drh33589792008-06-18 13:27:46 +0000299 case SQLITE_CONFIG_SCRATCH: {
300 /* Designate a buffer for scratch memory space */
danielk1977075c23a2008-09-01 18:34:20 +0000301 sqlite3GlobalConfig.pScratch = va_arg(ap, void*);
302 sqlite3GlobalConfig.szScratch = va_arg(ap, int);
303 sqlite3GlobalConfig.nScratch = va_arg(ap, int);
drh33589792008-06-18 13:27:46 +0000304 break;
305 }
306 case SQLITE_CONFIG_PAGECACHE: {
307 /* Designate a buffer for scratch memory space */
danielk1977075c23a2008-09-01 18:34:20 +0000308 sqlite3GlobalConfig.pPage = va_arg(ap, void*);
309 sqlite3GlobalConfig.szPage = va_arg(ap, int);
310 sqlite3GlobalConfig.nPage = va_arg(ap, int);
drh33589792008-06-18 13:27:46 +0000311 break;
312 }
danielk19775099be52008-06-27 13:27:03 +0000313
danielk1977bc2ca9e2008-11-13 14:28:28 +0000314 case SQLITE_CONFIG_PCACHE: {
315 /* Specify an alternative malloc implementation */
316 sqlite3GlobalConfig.pcache = *va_arg(ap, sqlite3_pcache_methods*);
317 break;
318 }
319
drhb232c232008-11-19 01:20:26 +0000320 case SQLITE_CONFIG_GETPCACHE: {
321 if( sqlite3GlobalConfig.pcache.xInit==0 ){
322 sqlite3PCacheSetDefault();
323 }
324 *va_arg(ap, sqlite3_pcache_methods*) = sqlite3GlobalConfig.pcache;
325 break;
326 }
327
drh5d414832008-07-15 14:47:18 +0000328#if defined(SQLITE_ENABLE_MEMSYS3) || defined(SQLITE_ENABLE_MEMSYS5)
drh33589792008-06-18 13:27:46 +0000329 case SQLITE_CONFIG_HEAP: {
danielk19775099be52008-06-27 13:27:03 +0000330 /* Designate a buffer for heap memory space */
danielk1977075c23a2008-09-01 18:34:20 +0000331 sqlite3GlobalConfig.pHeap = va_arg(ap, void*);
332 sqlite3GlobalConfig.nHeap = va_arg(ap, int);
333 sqlite3GlobalConfig.mnReq = va_arg(ap, int);
danielk19775099be52008-06-27 13:27:03 +0000334
danielk1977075c23a2008-09-01 18:34:20 +0000335 if( sqlite3GlobalConfig.pHeap==0 ){
drh8a42cbd2008-07-10 18:13:42 +0000336 /* If the heap pointer is NULL, then restore the malloc implementation
337 ** back to NULL pointers too. This will cause the malloc to go
338 ** back to its default implementation when sqlite3_initialize() is
339 ** run.
340 */
danielk1977075c23a2008-09-01 18:34:20 +0000341 memset(&sqlite3GlobalConfig.m, 0, sizeof(sqlite3GlobalConfig.m));
drh8a42cbd2008-07-10 18:13:42 +0000342 }else{
343 /* The heap pointer is not NULL, then install one of the
344 ** mem5.c/mem3.c methods. If neither ENABLE_MEMSYS3 nor
345 ** ENABLE_MEMSYS5 is defined, return an error.
346 ** the default case and return an error.
347 */
danielk19775099be52008-06-27 13:27:03 +0000348#ifdef SQLITE_ENABLE_MEMSYS3
danielk1977075c23a2008-09-01 18:34:20 +0000349 sqlite3GlobalConfig.m = *sqlite3MemGetMemsys3();
drh8a42cbd2008-07-10 18:13:42 +0000350#endif
351#ifdef SQLITE_ENABLE_MEMSYS5
danielk1977075c23a2008-09-01 18:34:20 +0000352 sqlite3GlobalConfig.m = *sqlite3MemGetMemsys5();
drh8a42cbd2008-07-10 18:13:42 +0000353#endif
drh8a42cbd2008-07-10 18:13:42 +0000354 }
danielk19775099be52008-06-27 13:27:03 +0000355 break;
356 }
drh5d414832008-07-15 14:47:18 +0000357#endif
danielk19775099be52008-06-27 13:27:03 +0000358
drh633e6d52008-07-28 19:34:53 +0000359 case SQLITE_CONFIG_LOOKASIDE: {
danielk1977075c23a2008-09-01 18:34:20 +0000360 sqlite3GlobalConfig.szLookaside = va_arg(ap, int);
361 sqlite3GlobalConfig.nLookaside = va_arg(ap, int);
drh633e6d52008-07-28 19:34:53 +0000362 break;
363 }
364
drh40257ff2008-06-13 18:24:27 +0000365 default: {
366 rc = SQLITE_ERROR;
367 break;
368 }
369 }
370 va_end(ap);
371 return rc;
372}
373
374/*
drh633e6d52008-07-28 19:34:53 +0000375** Set up the lookaside buffers for a database connection.
376** Return SQLITE_OK on success.
377** If lookaside is already active, return SQLITE_BUSY.
drhe9d1c722008-08-04 20:13:26 +0000378**
379** The sz parameter is the number of bytes in each lookaside slot.
380** The cnt parameter is the number of slots. If pStart is NULL the
381** space for the lookaside memory is obtained from sqlite3_malloc().
382** If pStart is not NULL then it is sz*cnt bytes of memory to use for
383** the lookaside memory.
drh633e6d52008-07-28 19:34:53 +0000384*/
drhe9d1c722008-08-04 20:13:26 +0000385static int setupLookaside(sqlite3 *db, void *pBuf, int sz, int cnt){
drh633e6d52008-07-28 19:34:53 +0000386 void *pStart;
387 if( db->lookaside.nOut ){
388 return SQLITE_BUSY;
389 }
390 if( sz<0 ) sz = 0;
391 if( cnt<0 ) cnt = 0;
drhe9d1c722008-08-04 20:13:26 +0000392 if( pBuf==0 ){
drh63820332008-08-08 14:33:12 +0000393 sz = (sz + 7)&~7;
drhe9d1c722008-08-04 20:13:26 +0000394 sqlite3BeginBenignMalloc();
395 pStart = sqlite3Malloc( sz*cnt );
396 sqlite3EndBenignMalloc();
397 }else{
drh63820332008-08-08 14:33:12 +0000398 sz = sz&~7;
drhe9d1c722008-08-04 20:13:26 +0000399 pStart = pBuf;
400 }
401 if( db->lookaside.bMalloced ){
402 sqlite3_free(db->lookaside.pStart);
403 }
drh4cfb22f2008-08-01 18:47:01 +0000404 db->lookaside.pStart = pStart;
405 db->lookaside.pFree = 0;
drh1bd10f82008-12-10 21:19:56 +0000406 db->lookaside.sz = (u16)sz;
407 db->lookaside.bMalloced = pBuf==0 ?1:0;
drh633e6d52008-07-28 19:34:53 +0000408 if( pStart ){
409 int i;
410 LookasideSlot *p;
drh633e6d52008-07-28 19:34:53 +0000411 p = (LookasideSlot*)pStart;
412 for(i=cnt-1; i>=0; i--){
413 p->pNext = db->lookaside.pFree;
414 db->lookaside.pFree = p;
415 p = (LookasideSlot*)&((u8*)p)[sz];
416 }
417 db->lookaside.pEnd = p;
418 db->lookaside.bEnabled = 1;
drh4cfb22f2008-08-01 18:47:01 +0000419 }else{
420 db->lookaside.pEnd = 0;
421 db->lookaside.bEnabled = 0;
drh633e6d52008-07-28 19:34:53 +0000422 }
423 return SQLITE_OK;
424}
425
426/*
drh4413d0e2008-11-04 13:46:27 +0000427** Return the mutex associated with a database connection.
428*/
429sqlite3_mutex *sqlite3_db_mutex(sqlite3 *db){
430 return db->mutex;
431}
432
433/*
drh633e6d52008-07-28 19:34:53 +0000434** Configuration settings for an individual database connection
435*/
436int sqlite3_db_config(sqlite3 *db, int op, ...){
437 va_list ap;
drh6480aad2008-08-01 16:31:14 +0000438 int rc;
drh633e6d52008-07-28 19:34:53 +0000439 va_start(ap, op);
440 switch( op ){
drhe9d1c722008-08-04 20:13:26 +0000441 case SQLITE_DBCONFIG_LOOKASIDE: {
442 void *pBuf = va_arg(ap, void*);
drh633e6d52008-07-28 19:34:53 +0000443 int sz = va_arg(ap, int);
444 int cnt = va_arg(ap, int);
drhe9d1c722008-08-04 20:13:26 +0000445 rc = setupLookaside(db, pBuf, sz, cnt);
drh633e6d52008-07-28 19:34:53 +0000446 break;
447 }
drh6480aad2008-08-01 16:31:14 +0000448 default: {
449 rc = SQLITE_ERROR;
450 break;
451 }
drh633e6d52008-07-28 19:34:53 +0000452 }
453 va_end(ap);
454 return rc;
455}
456
457/*
drhc5499be2008-04-01 15:06:33 +0000458** Routine needed to support the testcase() macro.
459*/
460#ifdef SQLITE_COVERAGE_TEST
461void sqlite3Coverage(int x){
462 static int dummy = 0;
463 dummy += x;
464}
465#endif
466
drha16313e2007-03-30 11:29:32 +0000467
468/*
drh9b5adfa2008-01-20 23:19:56 +0000469** Return true if the buffer z[0..n-1] contains all spaces.
470*/
471static int allSpaces(const char *z, int n){
drh5f3a3672008-04-15 04:02:40 +0000472 while( n>0 && z[n-1]==' ' ){ n--; }
drh9b5adfa2008-01-20 23:19:56 +0000473 return n==0;
474}
475
476/*
drhd3d39e92004-05-20 22:16:29 +0000477** This is the default collating function named "BINARY" which is always
478** available.
drh9b5adfa2008-01-20 23:19:56 +0000479**
480** If the padFlag argument is not NULL then space padding at the end
481** of strings is ignored. This implements the RTRIM collation.
drhd3d39e92004-05-20 22:16:29 +0000482*/
danielk19772c336542005-01-13 02:14:23 +0000483static int binCollFunc(
drh9b5adfa2008-01-20 23:19:56 +0000484 void *padFlag,
drhd3d39e92004-05-20 22:16:29 +0000485 int nKey1, const void *pKey1,
486 int nKey2, const void *pKey2
487){
488 int rc, n;
489 n = nKey1<nKey2 ? nKey1 : nKey2;
490 rc = memcmp(pKey1, pKey2, n);
491 if( rc==0 ){
drh9b5adfa2008-01-20 23:19:56 +0000492 if( padFlag
493 && allSpaces(((char*)pKey1)+n, nKey1-n)
494 && allSpaces(((char*)pKey2)+n, nKey2-n)
495 ){
496 /* Leave rc unchanged at 0 */
497 }else{
498 rc = nKey1 - nKey2;
499 }
drhd3d39e92004-05-20 22:16:29 +0000500 }
501 return rc;
502}
503
504/*
danielk1977dc1bdc42004-06-11 10:51:27 +0000505** Another built-in collating sequence: NOCASE.
506**
507** This collating sequence is intended to be used for "case independant
508** comparison". SQLite's knowledge of upper and lower case equivalents
509** extends only to the 26 characters used in the English language.
510**
511** At the moment there is only a UTF-8 implementation.
danielk19770202b292004-06-09 09:55:16 +0000512*/
513static int nocaseCollatingFunc(
514 void *NotUsed,
515 int nKey1, const void *pKey1,
516 int nKey2, const void *pKey2
517){
518 int r = sqlite3StrNICmp(
drh208f80a2004-08-29 20:08:58 +0000519 (const char *)pKey1, (const char *)pKey2, (nKey1<nKey2)?nKey1:nKey2);
danielk197762c14b32008-11-19 09:05:26 +0000520 UNUSED_PARAMETER(NotUsed);
danielk19770202b292004-06-09 09:55:16 +0000521 if( 0==r ){
522 r = nKey1-nKey2;
523 }
524 return r;
525}
526
527/*
drhaf9ff332002-01-16 21:00:27 +0000528** Return the ROWID of the most recent insert
529*/
drh9bb575f2004-09-06 17:24:11 +0000530sqlite_int64 sqlite3_last_insert_rowid(sqlite3 *db){
drhaf9ff332002-01-16 21:00:27 +0000531 return db->lastRowid;
532}
533
534/*
danielk197724b03fd2004-05-10 10:34:34 +0000535** Return the number of changes in the most recent call to sqlite3_exec().
drhc8d30ac2002-04-12 10:08:59 +0000536*/
drh9bb575f2004-09-06 17:24:11 +0000537int sqlite3_changes(sqlite3 *db){
drhc8d30ac2002-04-12 10:08:59 +0000538 return db->nChange;
539}
540
rdcf146a772004-02-25 22:51:06 +0000541/*
danielk1977b28af712004-06-21 06:50:26 +0000542** Return the number of changes since the database handle was opened.
rdcf146a772004-02-25 22:51:06 +0000543*/
danielk1977b28af712004-06-21 06:50:26 +0000544int sqlite3_total_changes(sqlite3 *db){
545 return db->nTotalChange;
rdcb0c374f2004-02-20 22:53:38 +0000546}
547
drhc8d30ac2002-04-12 10:08:59 +0000548/*
drh50e5dad2001-09-15 00:57:28 +0000549** Close an existing SQLite database
550*/
drh9bb575f2004-09-06 17:24:11 +0000551int sqlite3_close(sqlite3 *db){
drh8e0a2f92002-02-23 23:45:45 +0000552 HashElem *i;
drh001bbcb2003-03-19 03:14:00 +0000553 int j;
danielk19775c4c7782004-06-16 10:39:23 +0000554
555 if( !db ){
danielk197796d81f92004-06-19 03:33:57 +0000556 return SQLITE_OK;
danielk19775c4c7782004-06-16 10:39:23 +0000557 }
drh7e8b8482008-01-23 03:03:05 +0000558 if( !sqlite3SafetyCheckSickOrOk(db) ){
danielk1977e35ee192004-06-26 09:50:11 +0000559 return SQLITE_MISUSE;
560 }
drh605264d2007-08-21 15:13:19 +0000561 sqlite3_mutex_enter(db->mutex);
danielk1977e35ee192004-06-26 09:50:11 +0000562
danielk19771f723bd2005-05-26 12:37:29 +0000563#ifdef SQLITE_SSE
drh37527852006-03-16 16:19:56 +0000564 {
565 extern void sqlite3SseCleanup(sqlite3*);
566 sqlite3SseCleanup(db);
567 }
danielk19771f723bd2005-05-26 12:37:29 +0000568#endif
569
drhffc13f62006-07-30 20:50:44 +0000570 sqlite3ResetInternalSchema(db, 0);
danielk1977a04a34f2007-04-16 15:06:25 +0000571
danielk197701256832007-04-18 14:24:32 +0000572 /* If a transaction is open, the ResetInternalSchema() call above
573 ** will not have called the xDisconnect() method on any virtual
574 ** tables in the db->aVTrans[] array. The following sqlite3VtabRollback()
575 ** call will do so. We need to do this before the check for active
576 ** SQL statements below, as the v-table implementation may be storing
577 ** some prepared statements internally.
578 */
579 sqlite3VtabRollback(db);
580
danielk1977a04a34f2007-04-16 15:06:25 +0000581 /* If there are any outstanding VMs, return SQLITE_BUSY. */
danielk197796d81f92004-06-19 03:33:57 +0000582 if( db->pVdbe ){
583 sqlite3Error(db, SQLITE_BUSY,
584 "Unable to close due to unfinalised statements");
drh27641702007-08-22 02:56:42 +0000585 sqlite3_mutex_leave(db->mutex);
danielk197796d81f92004-06-19 03:33:57 +0000586 return SQLITE_BUSY;
587 }
drh7e8b8482008-01-23 03:03:05 +0000588 assert( sqlite3SafetyCheckSickOrOk(db) );
danielk1977e0048402004-06-15 16:51:01 +0000589
drh001bbcb2003-03-19 03:14:00 +0000590 for(j=0; j<db->nDb; j++){
drh4d189ca2004-02-12 18:46:38 +0000591 struct Db *pDb = &db->aDb[j];
592 if( pDb->pBt ){
danielk19774adee202004-05-08 08:23:19 +0000593 sqlite3BtreeClose(pDb->pBt);
drh4d189ca2004-02-12 18:46:38 +0000594 pDb->pBt = 0;
danielk1977311019b2006-01-10 07:14:23 +0000595 if( j!=1 ){
596 pDb->pSchema = 0;
597 }
drh113088e2003-03-20 01:16:58 +0000598 }
drhf57b3392001-10-08 13:22:32 +0000599 }
danielk19774adee202004-05-08 08:23:19 +0000600 sqlite3ResetInternalSchema(db, 0);
drh1c2d8412003-03-31 00:30:47 +0000601 assert( db->nDb<=2 );
602 assert( db->aDb==db->aDbStatic );
drh70a8ca32008-08-21 18:49:27 +0000603 for(j=0; j<ArraySize(db->aFunc.a); j++){
604 FuncDef *pNext, *pHash, *p;
605 for(p=db->aFunc.a[j]; p; p=pHash){
606 pHash = p->pHash;
607 while( p ){
608 pNext = p->pNext;
609 sqlite3DbFree(db, p);
610 p = pNext;
611 }
drh8e0a2f92002-02-23 23:45:45 +0000612 }
613 }
danielk1977d8123362004-06-12 09:25:12 +0000614 for(i=sqliteHashFirst(&db->aCollSeq); i; i=sqliteHashNext(i)){
danielk1977466be562004-06-10 02:16:01 +0000615 CollSeq *pColl = (CollSeq *)sqliteHashData(i);
danielk1977a9808b32007-05-07 09:32:45 +0000616 /* Invoke any destructors registered for collation sequence user data. */
617 for(j=0; j<3; j++){
618 if( pColl[j].xDel ){
619 pColl[j].xDel(pColl[j].pUser);
620 }
621 }
drh633e6d52008-07-28 19:34:53 +0000622 sqlite3DbFree(db, pColl);
danielk1977466be562004-06-10 02:16:01 +0000623 }
danielk1977d8123362004-06-12 09:25:12 +0000624 sqlite3HashClear(&db->aCollSeq);
drhb9bb7c12006-06-11 23:41:55 +0000625#ifndef SQLITE_OMIT_VIRTUALTABLE
danielk1977d1ab1ba2006-06-15 04:28:13 +0000626 for(i=sqliteHashFirst(&db->aModule); i; i=sqliteHashNext(i)){
627 Module *pMod = (Module *)sqliteHashData(i);
danielk1977832a58a2007-06-22 15:21:15 +0000628 if( pMod->xDestroy ){
629 pMod->xDestroy(pMod->pAux);
630 }
drh633e6d52008-07-28 19:34:53 +0000631 sqlite3DbFree(db, pMod);
danielk1977d1ab1ba2006-06-15 04:28:13 +0000632 }
drhb9bb7c12006-06-11 23:41:55 +0000633 sqlite3HashClear(&db->aModule);
634#endif
danielk1977466be562004-06-10 02:16:01 +0000635
danielk19776622cce2004-05-20 11:00:52 +0000636 sqlite3Error(db, SQLITE_OK, 0); /* Deallocates any cached error strings. */
danielk1977bfd6cce2004-06-18 04:24:54 +0000637 if( db->pErr ){
638 sqlite3ValueFree(db->pErr);
639 }
drhf1952c52006-06-08 15:48:00 +0000640 sqlite3CloseExtensions(db);
danielk197796d81f92004-06-19 03:33:57 +0000641
642 db->magic = SQLITE_MAGIC_ERROR;
danielk1977311019b2006-01-10 07:14:23 +0000643
644 /* The temp-database schema is allocated differently from the other schema
645 ** objects (using sqliteMalloc() directly, instead of sqlite3BtreeSchema()).
646 ** So it needs to be freed here. Todo: Why not roll the temp schema into
647 ** the same sqliteMalloc() as the one that allocates the database
648 ** structure?
649 */
drh633e6d52008-07-28 19:34:53 +0000650 sqlite3DbFree(db, db->aDb[1].pSchema);
drh605264d2007-08-21 15:13:19 +0000651 sqlite3_mutex_leave(db->mutex);
drh7e8b8482008-01-23 03:03:05 +0000652 db->magic = SQLITE_MAGIC_CLOSED;
drh605264d2007-08-21 15:13:19 +0000653 sqlite3_mutex_free(db->mutex);
drh4150ebf2008-10-11 15:38:29 +0000654 assert( db->lookaside.nOut==0 ); /* Fails on a lookaside memory leak */
drhe9d1c722008-08-04 20:13:26 +0000655 if( db->lookaside.bMalloced ){
656 sqlite3_free(db->lookaside.pStart);
657 }
drh17435752007-08-16 04:30:38 +0000658 sqlite3_free(db);
danielk197796d81f92004-06-19 03:33:57 +0000659 return SQLITE_OK;
drh75897232000-05-29 14:26:00 +0000660}
661
662/*
drh001bbcb2003-03-19 03:14:00 +0000663** Rollback all database files.
664*/
drh9bb575f2004-09-06 17:24:11 +0000665void sqlite3RollbackAll(sqlite3 *db){
drh001bbcb2003-03-19 03:14:00 +0000666 int i;
danielk1977f3f06bb2005-12-16 15:24:28 +0000667 int inTrans = 0;
drhe30f4422007-08-21 16:15:55 +0000668 assert( sqlite3_mutex_held(db->mutex) );
danielk19772d1d86f2008-06-20 14:59:51 +0000669 sqlite3BeginBenignMalloc();
drh001bbcb2003-03-19 03:14:00 +0000670 for(i=0; i<db->nDb; i++){
671 if( db->aDb[i].pBt ){
danielk1977f3f06bb2005-12-16 15:24:28 +0000672 if( sqlite3BtreeIsInTrans(db->aDb[i].pBt) ){
673 inTrans = 1;
674 }
danielk19774adee202004-05-08 08:23:19 +0000675 sqlite3BtreeRollback(db->aDb[i].pBt);
drh001bbcb2003-03-19 03:14:00 +0000676 db->aDb[i].inTrans = 0;
677 }
678 }
danielk1977a298e902006-06-22 09:53:48 +0000679 sqlite3VtabRollback(db);
danielk19772d1d86f2008-06-20 14:59:51 +0000680 sqlite3EndBenignMalloc();
danielk1977ae72d982007-10-03 08:46:44 +0000681
danielk197771fd80b2005-12-16 06:54:01 +0000682 if( db->flags&SQLITE_InternChanges ){
danielk1977ea4d9e22007-08-13 15:28:33 +0000683 sqlite3ExpirePreparedStatements(db);
danielk197771fd80b2005-12-16 06:54:01 +0000684 sqlite3ResetInternalSchema(db, 0);
685 }
686
687 /* If one has been configured, invoke the rollback-hook callback */
danielk1977f3f06bb2005-12-16 15:24:28 +0000688 if( db->xRollbackCallback && (inTrans || !db->autoCommit) ){
danielk197771fd80b2005-12-16 06:54:01 +0000689 db->xRollbackCallback(db->pRollbackArg);
690 }
drh001bbcb2003-03-19 03:14:00 +0000691}
692
693/*
drhc22bd472002-05-10 13:14:07 +0000694** Return a static string that describes the kind of error specified in the
695** argument.
drh247be432002-05-10 05:44:55 +0000696*/
danielk1977f20b21c2004-05-31 23:56:42 +0000697const char *sqlite3ErrStr(int rc){
drhc22bd472002-05-10 13:14:07 +0000698 const char *z;
drh4ac285a2006-09-15 07:28:50 +0000699 switch( rc & 0xff ){
drhc60d0442004-09-30 13:43:13 +0000700 case SQLITE_ROW:
701 case SQLITE_DONE:
drhc22bd472002-05-10 13:14:07 +0000702 case SQLITE_OK: z = "not an error"; break;
703 case SQLITE_ERROR: z = "SQL logic error or missing database"; break;
drhc22bd472002-05-10 13:14:07 +0000704 case SQLITE_PERM: z = "access permission denied"; break;
705 case SQLITE_ABORT: z = "callback requested query abort"; break;
706 case SQLITE_BUSY: z = "database is locked"; break;
707 case SQLITE_LOCKED: z = "database table is locked"; break;
708 case SQLITE_NOMEM: z = "out of memory"; break;
709 case SQLITE_READONLY: z = "attempt to write a readonly database"; break;
710 case SQLITE_INTERRUPT: z = "interrupted"; break;
711 case SQLITE_IOERR: z = "disk I/O error"; break;
712 case SQLITE_CORRUPT: z = "database disk image is malformed"; break;
drh2db0bbc2005-08-11 02:10:18 +0000713 case SQLITE_FULL: z = "database or disk is full"; break;
drhc22bd472002-05-10 13:14:07 +0000714 case SQLITE_CANTOPEN: z = "unable to open database file"; break;
drhc22bd472002-05-10 13:14:07 +0000715 case SQLITE_EMPTY: z = "table contains no data"; break;
716 case SQLITE_SCHEMA: z = "database schema has changed"; break;
drh023ae032007-05-08 12:12:16 +0000717 case SQLITE_TOOBIG: z = "String or BLOB exceeded size limit"; break;
drhc22bd472002-05-10 13:14:07 +0000718 case SQLITE_CONSTRAINT: z = "constraint failed"; break;
719 case SQLITE_MISMATCH: z = "datatype mismatch"; break;
720 case SQLITE_MISUSE: z = "library routine called out of sequence";break;
drh65594042008-05-05 16:56:34 +0000721 case SQLITE_NOLFS: z = "large file support is disabled"; break;
drhed6c8672003-01-12 18:02:16 +0000722 case SQLITE_AUTH: z = "authorization denied"; break;
jplyon892f6712003-06-12 08:59:00 +0000723 case SQLITE_FORMAT: z = "auxiliary database format error"; break;
drhb08153d2004-11-20 20:18:55 +0000724 case SQLITE_RANGE: z = "bind or column index out of range"; break;
drhc602f9a2004-02-12 19:01:04 +0000725 case SQLITE_NOTADB: z = "file is encrypted or is not a database";break;
drhc22bd472002-05-10 13:14:07 +0000726 default: z = "unknown error"; break;
drh247be432002-05-10 05:44:55 +0000727 }
drhc22bd472002-05-10 13:14:07 +0000728 return z;
drh247be432002-05-10 05:44:55 +0000729}
730
731/*
drh2dfbbca2000-07-28 14:32:48 +0000732** This routine implements a busy callback that sleeps and tries
733** again until a timeout value is reached. The timeout value is
734** an integer number of milliseconds passed in as the first
735** argument.
736*/
drhdaffd0e2001-04-11 14:28:42 +0000737static int sqliteDefaultBusyCallback(
drh97903fe2005-05-24 20:19:57 +0000738 void *ptr, /* Database connection */
drh2dfbbca2000-07-28 14:32:48 +0000739 int count /* Number of times table has been busy */
740){
danielk197729bafea2008-06-26 10:41:19 +0000741#if SQLITE_OS_WIN || (defined(HAVE_USLEEP) && HAVE_USLEEP)
drhee570fa2005-04-28 12:06:05 +0000742 static const u8 delays[] =
743 { 1, 2, 5, 10, 15, 20, 25, 25, 25, 50, 50, 100 };
744 static const u8 totals[] =
745 { 0, 1, 3, 8, 18, 33, 53, 78, 103, 128, 178, 228 };
drhd1bec472004-01-15 13:29:31 +0000746# define NDELAY (sizeof(delays)/sizeof(delays[0]))
danielk1977b4b47412007-08-17 15:53:36 +0000747 sqlite3 *db = (sqlite3 *)ptr;
748 int timeout = db->busyTimeout;
drh97903fe2005-05-24 20:19:57 +0000749 int delay, prior;
drh2dfbbca2000-07-28 14:32:48 +0000750
drhee570fa2005-04-28 12:06:05 +0000751 assert( count>=0 );
752 if( count < NDELAY ){
753 delay = delays[count];
754 prior = totals[count];
drhd1bec472004-01-15 13:29:31 +0000755 }else{
756 delay = delays[NDELAY-1];
drh68cb6192005-05-06 22:05:56 +0000757 prior = totals[NDELAY-1] + delay*(count-(NDELAY-1));
drh2dfbbca2000-07-28 14:32:48 +0000758 }
drhd1bec472004-01-15 13:29:31 +0000759 if( prior + delay > timeout ){
760 delay = timeout - prior;
drh2dfbbca2000-07-28 14:32:48 +0000761 if( delay<=0 ) return 0;
762 }
danielk19772a6bdf62007-08-20 16:07:00 +0000763 sqlite3OsSleep(db->pVfs, delay*1000);
drh2dfbbca2000-07-28 14:32:48 +0000764 return 1;
765#else
drh482ea182007-08-20 11:12:40 +0000766 sqlite3 *db = (sqlite3 *)ptr;
drh3f737082005-06-14 02:24:31 +0000767 int timeout = ((sqlite3 *)ptr)->busyTimeout;
drh2dfbbca2000-07-28 14:32:48 +0000768 if( (count+1)*1000 > timeout ){
769 return 0;
770 }
drh482ea182007-08-20 11:12:40 +0000771 sqlite3OsSleep(db->pVfs, 1000000);
drh2dfbbca2000-07-28 14:32:48 +0000772 return 1;
773#endif
774}
775
776/*
drha4afb652005-07-09 02:16:02 +0000777** Invoke the given busy handler.
778**
779** This routine is called when an operation failed with a lock.
780** If this routine returns non-zero, the lock is retried. If it
781** returns 0, the operation aborts with an SQLITE_BUSY error.
782*/
783int sqlite3InvokeBusyHandler(BusyHandler *p){
784 int rc;
drh34004ce2008-07-11 16:15:17 +0000785 if( NEVER(p==0) || p->xFunc==0 || p->nBusy<0 ) return 0;
drha4afb652005-07-09 02:16:02 +0000786 rc = p->xFunc(p->pArg, p->nBusy);
787 if( rc==0 ){
788 p->nBusy = -1;
789 }else{
790 p->nBusy++;
791 }
792 return rc;
793}
794
795/*
drh2dfbbca2000-07-28 14:32:48 +0000796** This routine sets the busy callback for an Sqlite database to the
797** given callback function with the given argument.
798*/
danielk1977f9d64d22004-06-19 08:18:07 +0000799int sqlite3_busy_handler(
800 sqlite3 *db,
danielk19772a764eb2004-06-12 01:43:26 +0000801 int (*xBusy)(void*,int),
drh2dfbbca2000-07-28 14:32:48 +0000802 void *pArg
803){
drhe30f4422007-08-21 16:15:55 +0000804 sqlite3_mutex_enter(db->mutex);
danielk197724162fe2004-06-04 06:22:00 +0000805 db->busyHandler.xFunc = xBusy;
806 db->busyHandler.pArg = pArg;
drha4afb652005-07-09 02:16:02 +0000807 db->busyHandler.nBusy = 0;
drhe30f4422007-08-21 16:15:55 +0000808 sqlite3_mutex_leave(db->mutex);
danielk1977f9d64d22004-06-19 08:18:07 +0000809 return SQLITE_OK;
drh2dfbbca2000-07-28 14:32:48 +0000810}
811
danielk1977348bb5d2003-10-18 09:37:26 +0000812#ifndef SQLITE_OMIT_PROGRESS_CALLBACK
813/*
814** This routine sets the progress callback for an Sqlite database to the
815** given callback function with the given argument. The progress callback will
816** be invoked every nOps opcodes.
817*/
danielk197724b03fd2004-05-10 10:34:34 +0000818void sqlite3_progress_handler(
drh9bb575f2004-09-06 17:24:11 +0000819 sqlite3 *db,
danielk1977348bb5d2003-10-18 09:37:26 +0000820 int nOps,
821 int (*xProgress)(void*),
822 void *pArg
823){
drhbd0b1b52008-07-07 19:52:09 +0000824 sqlite3_mutex_enter(db->mutex);
825 if( nOps>0 ){
826 db->xProgress = xProgress;
827 db->nProgressOps = nOps;
828 db->pProgressArg = pArg;
829 }else{
830 db->xProgress = 0;
831 db->nProgressOps = 0;
832 db->pProgressArg = 0;
danielk1977348bb5d2003-10-18 09:37:26 +0000833 }
drhbd0b1b52008-07-07 19:52:09 +0000834 sqlite3_mutex_leave(db->mutex);
danielk1977348bb5d2003-10-18 09:37:26 +0000835}
836#endif
837
838
drh2dfbbca2000-07-28 14:32:48 +0000839/*
840** This routine installs a default busy handler that waits for the
841** specified number of milliseconds before returning 0.
842*/
danielk1977f9d64d22004-06-19 08:18:07 +0000843int sqlite3_busy_timeout(sqlite3 *db, int ms){
drh2dfbbca2000-07-28 14:32:48 +0000844 if( ms>0 ){
drh97903fe2005-05-24 20:19:57 +0000845 db->busyTimeout = ms;
846 sqlite3_busy_handler(db, sqliteDefaultBusyCallback, (void*)db);
drh2dfbbca2000-07-28 14:32:48 +0000847 }else{
danielk197724b03fd2004-05-10 10:34:34 +0000848 sqlite3_busy_handler(db, 0, 0);
drh2dfbbca2000-07-28 14:32:48 +0000849 }
danielk1977f9d64d22004-06-19 08:18:07 +0000850 return SQLITE_OK;
drh2dfbbca2000-07-28 14:32:48 +0000851}
drh4c504392000-10-16 22:06:40 +0000852
853/*
854** Cause any pending operation to stop at its earliest opportunity.
855*/
drh9bb575f2004-09-06 17:24:11 +0000856void sqlite3_interrupt(sqlite3 *db){
drhbd0b1b52008-07-07 19:52:09 +0000857 db->u1.isInterrupted = 1;
drh4c504392000-10-16 22:06:40 +0000858}
drhfa86c412002-02-02 15:01:15 +0000859
drhfa86c412002-02-02 15:01:15 +0000860
861/*
danielk1977771151b2006-01-17 13:21:40 +0000862** This function is exactly the same as sqlite3_create_function(), except
863** that it is designed to be called by internal code. The difference is
864** that if a malloc() fails in sqlite3_create_function(), an error code
865** is returned and the mallocFailed flag cleared.
drhfa86c412002-02-02 15:01:15 +0000866*/
danielk1977771151b2006-01-17 13:21:40 +0000867int sqlite3CreateFunc(
danielk197765904932004-05-26 06:18:37 +0000868 sqlite3 *db,
869 const char *zFunctionName,
870 int nArg,
danielk1977d8123362004-06-12 09:25:12 +0000871 int enc,
danielk197765904932004-05-26 06:18:37 +0000872 void *pUserData,
873 void (*xFunc)(sqlite3_context*,int,sqlite3_value **),
874 void (*xStep)(sqlite3_context*,int,sqlite3_value **),
875 void (*xFinal)(sqlite3_context*)
drh8e0a2f92002-02-23 23:45:45 +0000876){
drh0bce8352002-02-28 00:41:10 +0000877 FuncDef *p;
drh4b59ab52002-08-24 18:24:51 +0000878 int nName;
danielk197765904932004-05-26 06:18:37 +0000879
drhe30f4422007-08-21 16:15:55 +0000880 assert( sqlite3_mutex_held(db->mutex) );
drhc60d0442004-09-30 13:43:13 +0000881 if( zFunctionName==0 ||
danielk1977398eae72004-05-26 06:58:43 +0000882 (xFunc && (xFinal || xStep)) ||
883 (!xFunc && (xFinal && !xStep)) ||
884 (!xFunc && (!xFinal && xStep)) ||
drh24b58dd2008-07-07 14:50:14 +0000885 (nArg<-1 || nArg>SQLITE_MAX_FUNCTION_ARG) ||
drh0a687d12008-07-08 14:52:07 +0000886 (255<(nName = sqlite3Strlen(db, zFunctionName))) ){
drhbadf7a72006-06-14 15:35:36 +0000887 sqlite3Error(db, SQLITE_ERROR, "bad parameters");
danielk197765904932004-05-26 06:18:37 +0000888 return SQLITE_ERROR;
889 }
danielk1977d8123362004-06-12 09:25:12 +0000890
danielk197793758c82005-01-21 08:13:14 +0000891#ifndef SQLITE_OMIT_UTF16
danielk1977d8123362004-06-12 09:25:12 +0000892 /* If SQLITE_UTF16 is specified as the encoding type, transform this
893 ** to one of SQLITE_UTF16LE or SQLITE_UTF16BE using the
894 ** SQLITE_UTF16NATIVE macro. SQLITE_UTF16 is not used internally.
895 **
896 ** If SQLITE_ANY is specified, add three versions of the function
897 ** to the hash table.
898 */
899 if( enc==SQLITE_UTF16 ){
900 enc = SQLITE_UTF16NATIVE;
901 }else if( enc==SQLITE_ANY ){
902 int rc;
danielk1977771151b2006-01-17 13:21:40 +0000903 rc = sqlite3CreateFunc(db, zFunctionName, nArg, SQLITE_UTF8,
danielk1977f9d64d22004-06-19 08:18:07 +0000904 pUserData, xFunc, xStep, xFinal);
drhe30f4422007-08-21 16:15:55 +0000905 if( rc==SQLITE_OK ){
906 rc = sqlite3CreateFunc(db, zFunctionName, nArg, SQLITE_UTF16LE,
907 pUserData, xFunc, xStep, xFinal);
908 }
909 if( rc!=SQLITE_OK ){
910 return rc;
911 }
danielk1977d8123362004-06-12 09:25:12 +0000912 enc = SQLITE_UTF16BE;
913 }
danielk197793758c82005-01-21 08:13:14 +0000914#else
915 enc = SQLITE_UTF8;
916#endif
danielk19779636c4e2005-01-25 04:27:54 +0000917
918 /* Check if an existing function is being overridden or deleted. If so,
919 ** and there are active VMs, then return SQLITE_BUSY. If a function
920 ** is being overridden/deleted but there are no active VMs, allow the
921 ** operation to continue but invalidate all precompiled statements.
922 */
drh3abbd392008-12-10 23:04:13 +0000923 p = sqlite3FindFunction(db, zFunctionName, nName, nArg, (u8)enc, 0);
danielk19779636c4e2005-01-25 04:27:54 +0000924 if( p && p->iPrefEnc==enc && p->nArg==nArg ){
925 if( db->activeVdbeCnt ){
926 sqlite3Error(db, SQLITE_BUSY,
927 "Unable to delete/modify user-function due to active statements");
drh17435752007-08-16 04:30:38 +0000928 assert( !db->mallocFailed );
danielk19779636c4e2005-01-25 04:27:54 +0000929 return SQLITE_BUSY;
930 }else{
931 sqlite3ExpirePreparedStatements(db);
932 }
933 }
danielk197765904932004-05-26 06:18:37 +0000934
drh3abbd392008-12-10 23:04:13 +0000935 p = sqlite3FindFunction(db, zFunctionName, nName, nArg, (u8)enc, 1);
danielk1977fa18bec2007-09-03 11:04:22 +0000936 assert(p || db->mallocFailed);
937 if( !p ){
938 return SQLITE_NOMEM;
danielk1977771151b2006-01-17 13:21:40 +0000939 }
danielk1977fa18bec2007-09-03 11:04:22 +0000940 p->flags = 0;
941 p->xFunc = xFunc;
942 p->xStep = xStep;
943 p->xFinalize = xFinal;
944 p->pUserData = pUserData;
drh1bd10f82008-12-10 21:19:56 +0000945 p->nArg = (u16)nArg;
danielk197765904932004-05-26 06:18:37 +0000946 return SQLITE_OK;
947}
danielk1977771151b2006-01-17 13:21:40 +0000948
949/*
950** Create new user functions.
951*/
952int sqlite3_create_function(
953 sqlite3 *db,
954 const char *zFunctionName,
955 int nArg,
956 int enc,
957 void *p,
958 void (*xFunc)(sqlite3_context*,int,sqlite3_value **),
959 void (*xStep)(sqlite3_context*,int,sqlite3_value **),
960 void (*xFinal)(sqlite3_context*)
961){
962 int rc;
drhe30f4422007-08-21 16:15:55 +0000963 sqlite3_mutex_enter(db->mutex);
danielk1977771151b2006-01-17 13:21:40 +0000964 rc = sqlite3CreateFunc(db, zFunctionName, nArg, enc, p, xFunc, xStep, xFinal);
drhe30f4422007-08-21 16:15:55 +0000965 rc = sqlite3ApiExit(db, rc);
966 sqlite3_mutex_leave(db->mutex);
967 return rc;
danielk1977771151b2006-01-17 13:21:40 +0000968}
969
danielk197793758c82005-01-21 08:13:14 +0000970#ifndef SQLITE_OMIT_UTF16
danielk197765904932004-05-26 06:18:37 +0000971int sqlite3_create_function16(
972 sqlite3 *db,
973 const void *zFunctionName,
974 int nArg,
975 int eTextRep,
danielk1977771151b2006-01-17 13:21:40 +0000976 void *p,
danielk197765904932004-05-26 06:18:37 +0000977 void (*xFunc)(sqlite3_context*,int,sqlite3_value**),
978 void (*xStep)(sqlite3_context*,int,sqlite3_value**),
979 void (*xFinal)(sqlite3_context*)
980){
981 int rc;
drhaf9a7c22005-12-15 03:04:10 +0000982 char *zFunc8;
drhe30f4422007-08-21 16:15:55 +0000983 sqlite3_mutex_enter(db->mutex);
drh17435752007-08-16 04:30:38 +0000984 assert( !db->mallocFailed );
danielk19771e536952007-08-16 10:09:01 +0000985 zFunc8 = sqlite3Utf16to8(db, zFunctionName, -1);
danielk1977771151b2006-01-17 13:21:40 +0000986 rc = sqlite3CreateFunc(db, zFunc8, nArg, eTextRep, p, xFunc, xStep, xFinal);
drh633e6d52008-07-28 19:34:53 +0000987 sqlite3DbFree(db, zFunc8);
drhe30f4422007-08-21 16:15:55 +0000988 rc = sqlite3ApiExit(db, rc);
989 sqlite3_mutex_leave(db->mutex);
990 return rc;
drh8e0a2f92002-02-23 23:45:45 +0000991}
danielk197793758c82005-01-21 08:13:14 +0000992#endif
drhc9b84a12002-06-20 11:36:48 +0000993
drhb7481e72006-09-16 21:45:14 +0000994
995/*
996** Declare that a function has been overloaded by a virtual table.
997**
998** If the function already exists as a regular global function, then
999** this routine is a no-op. If the function does not exist, then create
1000** a new one that always throws a run-time error.
1001**
1002** When virtual tables intend to provide an overloaded function, they
1003** should call this routine to make sure the global function exists.
1004** A global function must exist in order for name resolution to work
1005** properly.
1006*/
1007int sqlite3_overload_function(
1008 sqlite3 *db,
1009 const char *zName,
1010 int nArg
1011){
drh0a687d12008-07-08 14:52:07 +00001012 int nName = sqlite3Strlen(db, zName);
drhe30f4422007-08-21 16:15:55 +00001013 int rc;
1014 sqlite3_mutex_enter(db->mutex);
drhb7481e72006-09-16 21:45:14 +00001015 if( sqlite3FindFunction(db, zName, nName, nArg, SQLITE_UTF8, 0)==0 ){
1016 sqlite3CreateFunc(db, zName, nArg, SQLITE_UTF8,
1017 0, sqlite3InvalidFunction, 0, 0);
1018 }
drhe30f4422007-08-21 16:15:55 +00001019 rc = sqlite3ApiExit(db, SQLITE_OK);
1020 sqlite3_mutex_leave(db->mutex);
1021 return rc;
drhb7481e72006-09-16 21:45:14 +00001022}
1023
drh19e2d372005-08-29 23:00:03 +00001024#ifndef SQLITE_OMIT_TRACE
drhc9b84a12002-06-20 11:36:48 +00001025/*
drh18de4822003-01-16 16:28:53 +00001026** Register a trace function. The pArg from the previously registered trace
1027** is returned.
1028**
1029** A NULL trace function means that no tracing is executes. A non-NULL
1030** trace is a pointer to a function that is invoked at the start of each
drh19e2d372005-08-29 23:00:03 +00001031** SQL statement.
drh18de4822003-01-16 16:28:53 +00001032*/
drh9bb575f2004-09-06 17:24:11 +00001033void *sqlite3_trace(sqlite3 *db, void (*xTrace)(void*,const char*), void *pArg){
drhe30f4422007-08-21 16:15:55 +00001034 void *pOld;
1035 sqlite3_mutex_enter(db->mutex);
1036 pOld = db->pTraceArg;
drh18de4822003-01-16 16:28:53 +00001037 db->xTrace = xTrace;
1038 db->pTraceArg = pArg;
drhe30f4422007-08-21 16:15:55 +00001039 sqlite3_mutex_leave(db->mutex);
drh18de4822003-01-16 16:28:53 +00001040 return pOld;
drh0d1a6432003-04-03 15:46:04 +00001041}
drh19e2d372005-08-29 23:00:03 +00001042/*
1043** Register a profile function. The pArg from the previously registered
1044** profile function is returned.
1045**
1046** A NULL profile function means that no profiling is executes. A non-NULL
1047** profile is a pointer to a function that is invoked at the conclusion of
1048** each SQL statement that is run.
1049*/
1050void *sqlite3_profile(
1051 sqlite3 *db,
1052 void (*xProfile)(void*,const char*,sqlite_uint64),
1053 void *pArg
1054){
drhe30f4422007-08-21 16:15:55 +00001055 void *pOld;
1056 sqlite3_mutex_enter(db->mutex);
1057 pOld = db->pProfileArg;
drh19e2d372005-08-29 23:00:03 +00001058 db->xProfile = xProfile;
1059 db->pProfileArg = pArg;
drhe30f4422007-08-21 16:15:55 +00001060 sqlite3_mutex_leave(db->mutex);
drh19e2d372005-08-29 23:00:03 +00001061 return pOld;
1062}
1063#endif /* SQLITE_OMIT_TRACE */
paulb0208cc2003-04-13 18:26:49 +00001064
drhaa940ea2004-01-15 02:44:03 +00001065/*** EXPERIMENTAL ***
1066**
1067** Register a function to be invoked when a transaction comments.
danielk197771fd80b2005-12-16 06:54:01 +00001068** If the invoked function returns non-zero, then the commit becomes a
drhaa940ea2004-01-15 02:44:03 +00001069** rollback.
1070*/
danielk197724b03fd2004-05-10 10:34:34 +00001071void *sqlite3_commit_hook(
drh9bb575f2004-09-06 17:24:11 +00001072 sqlite3 *db, /* Attach the hook to this database */
drhaa940ea2004-01-15 02:44:03 +00001073 int (*xCallback)(void*), /* Function to invoke on each commit */
1074 void *pArg /* Argument to the function */
1075){
drhe30f4422007-08-21 16:15:55 +00001076 void *pOld;
1077 sqlite3_mutex_enter(db->mutex);
1078 pOld = db->pCommitArg;
drhaa940ea2004-01-15 02:44:03 +00001079 db->xCommitCallback = xCallback;
1080 db->pCommitArg = pArg;
drhe30f4422007-08-21 16:15:55 +00001081 sqlite3_mutex_leave(db->mutex);
drhaa940ea2004-01-15 02:44:03 +00001082 return pOld;
1083}
1084
danielk197794eb6a12005-12-15 15:22:08 +00001085/*
1086** Register a callback to be invoked each time a row is updated,
1087** inserted or deleted using this database connection.
1088*/
danielk197771fd80b2005-12-16 06:54:01 +00001089void *sqlite3_update_hook(
danielk197794eb6a12005-12-15 15:22:08 +00001090 sqlite3 *db, /* Attach the hook to this database */
1091 void (*xCallback)(void*,int,char const *,char const *,sqlite_int64),
1092 void *pArg /* Argument to the function */
1093){
drhe30f4422007-08-21 16:15:55 +00001094 void *pRet;
1095 sqlite3_mutex_enter(db->mutex);
1096 pRet = db->pUpdateArg;
danielk197794eb6a12005-12-15 15:22:08 +00001097 db->xUpdateCallback = xCallback;
1098 db->pUpdateArg = pArg;
drhe30f4422007-08-21 16:15:55 +00001099 sqlite3_mutex_leave(db->mutex);
danielk197771fd80b2005-12-16 06:54:01 +00001100 return pRet;
danielk197794eb6a12005-12-15 15:22:08 +00001101}
1102
danielk197771fd80b2005-12-16 06:54:01 +00001103/*
1104** Register a callback to be invoked each time a transaction is rolled
1105** back by this database connection.
1106*/
1107void *sqlite3_rollback_hook(
1108 sqlite3 *db, /* Attach the hook to this database */
1109 void (*xCallback)(void*), /* Callback function */
1110 void *pArg /* Argument to the function */
1111){
drhe30f4422007-08-21 16:15:55 +00001112 void *pRet;
1113 sqlite3_mutex_enter(db->mutex);
1114 pRet = db->pRollbackArg;
danielk197771fd80b2005-12-16 06:54:01 +00001115 db->xRollbackCallback = xCallback;
1116 db->pRollbackArg = pArg;
drhe30f4422007-08-21 16:15:55 +00001117 sqlite3_mutex_leave(db->mutex);
danielk197771fd80b2005-12-16 06:54:01 +00001118 return pRet;
1119}
drhaa940ea2004-01-15 02:44:03 +00001120
paulb0208cc2003-04-13 18:26:49 +00001121/*
drh13bff812003-04-15 01:19:47 +00001122** This routine is called to create a connection to a database BTree
1123** driver. If zFilename is the name of a file, then that file is
1124** opened and used. If zFilename is the magic name ":memory:" then
1125** the database is stored in memory (and is thus forgotten as soon as
1126** the connection is closed.) If zFilename is NULL then the database
drh84bfda42005-07-15 13:05:21 +00001127** is a "virtual" database for transient use only and is deleted as
1128** soon as the connection is closed.
drh90f5ecb2004-07-22 01:19:35 +00001129**
drh84bfda42005-07-15 13:05:21 +00001130** A virtual database can be either a disk file (that is automatically
1131** deleted when the file is closed) or it an be held entirely in memory,
danielk1977b06a0b62008-06-26 10:54:12 +00001132** depending on the values of the SQLITE_TEMP_STORE compile-time macro and the
drh90f5ecb2004-07-22 01:19:35 +00001133** db->temp_store variable, according to the following chart:
1134**
danielk1977b06a0b62008-06-26 10:54:12 +00001135** SQLITE_TEMP_STORE db->temp_store Location of temporary database
1136** ----------------- -------------- ------------------------------
1137** 0 any file
1138** 1 1 file
1139** 1 2 memory
1140** 1 0 file
1141** 2 1 file
1142** 2 2 memory
1143** 2 0 memory
1144** 3 any memory
paulb0208cc2003-04-13 18:26:49 +00001145*/
danielk19774adee202004-05-08 08:23:19 +00001146int sqlite3BtreeFactory(
drh9bb575f2004-09-06 17:24:11 +00001147 const sqlite3 *db, /* Main database when opening aux otherwise 0 */
paulb0208cc2003-04-13 18:26:49 +00001148 const char *zFilename, /* Name of the file containing the BTree database */
1149 int omitJournal, /* if TRUE then do not journal this file */
1150 int nCache, /* How many pages in the page cache */
drh33f4e022007-09-03 15:19:34 +00001151 int vfsFlags, /* Flags passed through to vfsOpen */
danielk19774adee202004-05-08 08:23:19 +00001152 Btree **ppBtree /* Pointer to new Btree object written here */
1153){
drh33f4e022007-09-03 15:19:34 +00001154 int btFlags = 0;
drh90f5ecb2004-07-22 01:19:35 +00001155 int rc;
danielk19774adee202004-05-08 08:23:19 +00001156
drhe30f4422007-08-21 16:15:55 +00001157 assert( sqlite3_mutex_held(db->mutex) );
drheec983e2004-05-08 10:11:36 +00001158 assert( ppBtree != 0);
danielk19774adee202004-05-08 08:23:19 +00001159 if( omitJournal ){
drh33f4e022007-09-03 15:19:34 +00001160 btFlags |= BTREE_OMIT_JOURNAL;
paulb0208cc2003-04-13 18:26:49 +00001161 }
drh7bec5052005-02-06 02:45:41 +00001162 if( db->flags & SQLITE_NoReadlock ){
drh33f4e022007-09-03 15:19:34 +00001163 btFlags |= BTREE_NO_READLOCK;
drh7bec5052005-02-06 02:45:41 +00001164 }
drh90f5ecb2004-07-22 01:19:35 +00001165 if( zFilename==0 ){
danielk1977b06a0b62008-06-26 10:54:12 +00001166#if SQLITE_TEMP_STORE==0
drh22ac46d2004-08-14 18:34:54 +00001167 /* Do nothing */
drh90f5ecb2004-07-22 01:19:35 +00001168#endif
danielk197703aded42004-11-22 05:26:27 +00001169#ifndef SQLITE_OMIT_MEMORYDB
danielk1977b06a0b62008-06-26 10:54:12 +00001170#if SQLITE_TEMP_STORE==1
drh22ac46d2004-08-14 18:34:54 +00001171 if( db->temp_store==2 ) zFilename = ":memory:";
drh90f5ecb2004-07-22 01:19:35 +00001172#endif
danielk1977b06a0b62008-06-26 10:54:12 +00001173#if SQLITE_TEMP_STORE==2
drh22ac46d2004-08-14 18:34:54 +00001174 if( db->temp_store!=1 ) zFilename = ":memory:";
drh90f5ecb2004-07-22 01:19:35 +00001175#endif
danielk1977b06a0b62008-06-26 10:54:12 +00001176#if SQLITE_TEMP_STORE==3
drh22ac46d2004-08-14 18:34:54 +00001177 zFilename = ":memory:";
drh90f5ecb2004-07-22 01:19:35 +00001178#endif
danielk197703aded42004-11-22 05:26:27 +00001179#endif /* SQLITE_OMIT_MEMORYDB */
drh90f5ecb2004-07-22 01:19:35 +00001180 }
danielk19774adee202004-05-08 08:23:19 +00001181
drh33f4e022007-09-03 15:19:34 +00001182 if( (vfsFlags & SQLITE_OPEN_MAIN_DB)!=0 && (zFilename==0 || *zFilename==0) ){
1183 vfsFlags = (vfsFlags & ~SQLITE_OPEN_MAIN_DB) | SQLITE_OPEN_TEMP_DB;
1184 }
1185 rc = sqlite3BtreeOpen(zFilename, (sqlite3 *)db, ppBtree, btFlags, vfsFlags);
danielk1977171bfed2008-06-23 09:50:50 +00001186
1187 /* If the B-Tree was successfully opened, set the pager-cache size to the
1188 ** default value. Except, if the call to BtreeOpen() returned a handle
1189 ** open on an existing shared pager-cache, do not change the pager-cache
1190 ** size.
1191 */
1192 if( rc==SQLITE_OK && 0==sqlite3BtreeSchema(*ppBtree, 0, 0) ){
drh90f5ecb2004-07-22 01:19:35 +00001193 sqlite3BtreeSetCacheSize(*ppBtree, nCache);
1194 }
1195 return rc;
paulb0208cc2003-04-13 18:26:49 +00001196}
danielk19774adee202004-05-08 08:23:19 +00001197
danielk19774ad17132004-05-21 01:47:26 +00001198/*
1199** Return UTF-8 encoded English language explanation of the most recent
1200** error.
1201*/
danielk19776622cce2004-05-20 11:00:52 +00001202const char *sqlite3_errmsg(sqlite3 *db){
drhc60d0442004-09-30 13:43:13 +00001203 const char *z;
drhf49661a2008-12-10 16:45:50 +00001204 if( !db ){
danielk1977f20b21c2004-05-31 23:56:42 +00001205 return sqlite3ErrStr(SQLITE_NOMEM);
danielk19774ad17132004-05-21 01:47:26 +00001206 }
drhd55d57e2008-07-07 17:53:07 +00001207 if( !sqlite3SafetyCheckSickOrOk(db) ){
danielk1977e35ee192004-06-26 09:50:11 +00001208 return sqlite3ErrStr(SQLITE_MISUSE);
1209 }
drhf49661a2008-12-10 16:45:50 +00001210 if( db->mallocFailed ){
1211 return sqlite3ErrStr(SQLITE_NOMEM);
1212 }
drh27641702007-08-22 02:56:42 +00001213 sqlite3_mutex_enter(db->mutex);
drh86f8c192007-08-22 00:39:19 +00001214 assert( !db->mallocFailed );
drh2646da72005-12-09 20:02:05 +00001215 z = (char*)sqlite3_value_text(db->pErr);
danielk1977131c8bc2008-05-22 13:56:17 +00001216 assert( !db->mallocFailed );
drhc60d0442004-09-30 13:43:13 +00001217 if( z==0 ){
1218 z = sqlite3ErrStr(db->errCode);
danielk19776622cce2004-05-20 11:00:52 +00001219 }
drhe30f4422007-08-21 16:15:55 +00001220 sqlite3_mutex_leave(db->mutex);
drhc60d0442004-09-30 13:43:13 +00001221 return z;
danielk19776622cce2004-05-20 11:00:52 +00001222}
1223
drh6c626082004-11-14 21:56:29 +00001224#ifndef SQLITE_OMIT_UTF16
danielk19774ad17132004-05-21 01:47:26 +00001225/*
1226** Return UTF-16 encoded English language explanation of the most recent
1227** error.
1228*/
danielk19776622cce2004-05-20 11:00:52 +00001229const void *sqlite3_errmsg16(sqlite3 *db){
danielk1977bfd6cce2004-06-18 04:24:54 +00001230 /* Because all the characters in the string are in the unicode
1231 ** range 0x00-0xFF, if we pad the big-endian string with a
1232 ** zero byte, we can obtain the little-endian string with
1233 ** &big_endian[1].
1234 */
drh57196282004-10-06 15:41:16 +00001235 static const char outOfMemBe[] = {
danielk1977bfd6cce2004-06-18 04:24:54 +00001236 0, 'o', 0, 'u', 0, 't', 0, ' ',
1237 0, 'o', 0, 'f', 0, ' ',
1238 0, 'm', 0, 'e', 0, 'm', 0, 'o', 0, 'r', 0, 'y', 0, 0, 0
1239 };
drh57196282004-10-06 15:41:16 +00001240 static const char misuseBe [] = {
danielk1977e35ee192004-06-26 09:50:11 +00001241 0, 'l', 0, 'i', 0, 'b', 0, 'r', 0, 'a', 0, 'r', 0, 'y', 0, ' ',
1242 0, 'r', 0, 'o', 0, 'u', 0, 't', 0, 'i', 0, 'n', 0, 'e', 0, ' ',
1243 0, 'c', 0, 'a', 0, 'l', 0, 'l', 0, 'e', 0, 'd', 0, ' ',
1244 0, 'o', 0, 'u', 0, 't', 0, ' ',
1245 0, 'o', 0, 'f', 0, ' ',
1246 0, 's', 0, 'e', 0, 'q', 0, 'u', 0, 'e', 0, 'n', 0, 'c', 0, 'e', 0, 0, 0
1247 };
danielk19774ad17132004-05-21 01:47:26 +00001248
drhc60d0442004-09-30 13:43:13 +00001249 const void *z;
danielk1977ae7fc492007-03-29 15:00:52 +00001250 if( !db ){
drhc60d0442004-09-30 13:43:13 +00001251 return (void *)(&outOfMemBe[SQLITE_UTF16NATIVE==SQLITE_UTF16LE?1:0]);
1252 }
drhd55d57e2008-07-07 17:53:07 +00001253 if( !sqlite3SafetyCheckSickOrOk(db) ){
drhc60d0442004-09-30 13:43:13 +00001254 return (void *)(&misuseBe[SQLITE_UTF16NATIVE==SQLITE_UTF16LE?1:0]);
1255 }
drhe30f4422007-08-21 16:15:55 +00001256 sqlite3_mutex_enter(db->mutex);
1257 assert( !db->mallocFailed );
drhc60d0442004-09-30 13:43:13 +00001258 z = sqlite3_value_text16(db->pErr);
1259 if( z==0 ){
drhb21c8cd2007-08-21 19:33:56 +00001260 sqlite3ValueSetStr(db->pErr, -1, sqlite3ErrStr(db->errCode),
drhc60d0442004-09-30 13:43:13 +00001261 SQLITE_UTF8, SQLITE_STATIC);
1262 z = sqlite3_value_text16(db->pErr);
1263 }
danielk1977131c8bc2008-05-22 13:56:17 +00001264 /* A malloc() may have failed within the call to sqlite3_value_text16()
1265 ** above. If this is the case, then the db->mallocFailed flag needs to
1266 ** be cleared before returning. Do this directly, instead of via
1267 ** sqlite3ApiExit(), to avoid setting the database handle error message.
1268 */
1269 db->mallocFailed = 0;
drhe30f4422007-08-21 16:15:55 +00001270 sqlite3_mutex_leave(db->mutex);
drhc60d0442004-09-30 13:43:13 +00001271 return z;
danielk19776622cce2004-05-20 11:00:52 +00001272}
drh6c626082004-11-14 21:56:29 +00001273#endif /* SQLITE_OMIT_UTF16 */
danielk19776622cce2004-05-20 11:00:52 +00001274
drhc60d0442004-09-30 13:43:13 +00001275/*
danielk19777ddad962005-12-12 06:53:03 +00001276** Return the most recent error code generated by an SQLite routine. If NULL is
1277** passed to this function, we assume a malloc() failed during sqlite3_open().
drhc60d0442004-09-30 13:43:13 +00001278*/
danielk19776622cce2004-05-20 11:00:52 +00001279int sqlite3_errcode(sqlite3 *db){
danielk19777c36d072008-01-31 15:31:01 +00001280 if( db && !sqlite3SafetyCheckSickOrOk(db) ){
drhc60d0442004-09-30 13:43:13 +00001281 return SQLITE_MISUSE;
1282 }
drh01495b92008-01-23 12:52:40 +00001283 if( !db || db->mallocFailed ){
1284 return SQLITE_NOMEM;
1285 }
drh4ac285a2006-09-15 07:28:50 +00001286 return db->errCode & db->errMask;
danielk19776622cce2004-05-20 11:00:52 +00001287}
drh99dfe5e2008-10-30 15:03:15 +00001288int sqlite3_extended_errcode(sqlite3 *db){
1289 if( db && !sqlite3SafetyCheckSickOrOk(db) ){
1290 return SQLITE_MISUSE;
1291 }
1292 if( !db || db->mallocFailed ){
1293 return SQLITE_NOMEM;
1294 }
1295 return db->errCode;
1296}
danielk19776622cce2004-05-20 11:00:52 +00001297
drh0e819f92006-02-01 13:50:41 +00001298/*
1299** Create a new collating function for database "db". The name is zName
1300** and the encoding is enc.
1301*/
danielk19779a30cf62006-01-18 04:26:07 +00001302static int createCollation(
1303 sqlite3* db,
1304 const char *zName,
1305 int enc,
1306 void* pCtx,
danielk1977a9808b32007-05-07 09:32:45 +00001307 int(*xCompare)(void*,int,const void*,int,const void*),
1308 void(*xDel)(void*)
danielk19779a30cf62006-01-18 04:26:07 +00001309){
1310 CollSeq *pColl;
drh7d9bd4e2006-02-16 18:16:36 +00001311 int enc2;
drh0a687d12008-07-08 14:52:07 +00001312 int nName;
danielk19779a30cf62006-01-18 04:26:07 +00001313
drhe30f4422007-08-21 16:15:55 +00001314 assert( sqlite3_mutex_held(db->mutex) );
danielk19779a30cf62006-01-18 04:26:07 +00001315
1316 /* If SQLITE_UTF16 is specified as the encoding type, transform this
1317 ** to one of SQLITE_UTF16LE or SQLITE_UTF16BE using the
1318 ** SQLITE_UTF16NATIVE macro. SQLITE_UTF16 is not used internally.
1319 */
drh7d9bd4e2006-02-16 18:16:36 +00001320 enc2 = enc & ~SQLITE_UTF16_ALIGNED;
1321 if( enc2==SQLITE_UTF16 ){
1322 enc2 = SQLITE_UTF16NATIVE;
danielk19779a30cf62006-01-18 04:26:07 +00001323 }
drh7d9bd4e2006-02-16 18:16:36 +00001324 if( (enc2&~3)!=0 ){
drhd55d57e2008-07-07 17:53:07 +00001325 return SQLITE_MISUSE;
danielk19779a30cf62006-01-18 04:26:07 +00001326 }
1327
1328 /* Check if this call is removing or replacing an existing collation
1329 ** sequence. If so, and there are active VMs, return busy. If there
1330 ** are no active VMs, invalidate any pre-compiled statements.
1331 */
drh0a687d12008-07-08 14:52:07 +00001332 nName = sqlite3Strlen(db, zName);
1333 pColl = sqlite3FindCollSeq(db, (u8)enc2, zName, nName, 0);
danielk19779a30cf62006-01-18 04:26:07 +00001334 if( pColl && pColl->xCmp ){
1335 if( db->activeVdbeCnt ){
1336 sqlite3Error(db, SQLITE_BUSY,
1337 "Unable to delete/modify collation sequence due to active statements");
1338 return SQLITE_BUSY;
1339 }
1340 sqlite3ExpirePreparedStatements(db);
danielk1977a9808b32007-05-07 09:32:45 +00001341
1342 /* If collation sequence pColl was created directly by a call to
1343 ** sqlite3_create_collation, and not generated by synthCollSeq(),
1344 ** then any copies made by synthCollSeq() need to be invalidated.
1345 ** Also, collation destructor - CollSeq.xDel() - function may need
1346 ** to be called.
1347 */
1348 if( (pColl->enc & ~SQLITE_UTF16_ALIGNED)==enc2 ){
drh0a687d12008-07-08 14:52:07 +00001349 CollSeq *aColl = sqlite3HashFind(&db->aCollSeq, zName, nName);
danielk1977a9808b32007-05-07 09:32:45 +00001350 int j;
1351 for(j=0; j<3; j++){
1352 CollSeq *p = &aColl[j];
1353 if( p->enc==pColl->enc ){
1354 if( p->xDel ){
1355 p->xDel(p->pUser);
1356 }
1357 p->xCmp = 0;
1358 }
1359 }
1360 }
danielk19779a30cf62006-01-18 04:26:07 +00001361 }
1362
drh0a687d12008-07-08 14:52:07 +00001363 pColl = sqlite3FindCollSeq(db, (u8)enc2, zName, nName, 1);
danielk19779a30cf62006-01-18 04:26:07 +00001364 if( pColl ){
1365 pColl->xCmp = xCompare;
1366 pColl->pUser = pCtx;
danielk1977a9808b32007-05-07 09:32:45 +00001367 pColl->xDel = xDel;
drh1bd10f82008-12-10 21:19:56 +00001368 pColl->enc = (u8)(enc2 | (enc & SQLITE_UTF16_ALIGNED));
danielk19779a30cf62006-01-18 04:26:07 +00001369 }
1370 sqlite3Error(db, SQLITE_OK, 0);
1371 return SQLITE_OK;
1372}
1373
1374
danielk19776622cce2004-05-20 11:00:52 +00001375/*
drhbb4957f2008-03-20 14:03:29 +00001376** This array defines hard upper bounds on limit values. The
1377** initializer must be kept in sync with the SQLITE_LIMIT_*
1378** #defines in sqlite3.h.
1379*/
drhb1a6c3c2008-03-20 16:30:17 +00001380static const int aHardLimit[] = {
drhbb4957f2008-03-20 14:03:29 +00001381 SQLITE_MAX_LENGTH,
1382 SQLITE_MAX_SQL_LENGTH,
1383 SQLITE_MAX_COLUMN,
1384 SQLITE_MAX_EXPR_DEPTH,
1385 SQLITE_MAX_COMPOUND_SELECT,
1386 SQLITE_MAX_VDBE_OP,
1387 SQLITE_MAX_FUNCTION_ARG,
1388 SQLITE_MAX_ATTACHED,
drhbb4957f2008-03-20 14:03:29 +00001389 SQLITE_MAX_LIKE_PATTERN_LENGTH,
1390 SQLITE_MAX_VARIABLE_NUMBER,
1391};
1392
1393/*
1394** Make sure the hard limits are set to reasonable values
1395*/
1396#if SQLITE_MAX_LENGTH<100
1397# error SQLITE_MAX_LENGTH must be at least 100
1398#endif
1399#if SQLITE_MAX_SQL_LENGTH<100
1400# error SQLITE_MAX_SQL_LENGTH must be at least 100
1401#endif
1402#if SQLITE_MAX_SQL_LENGTH>SQLITE_MAX_LENGTH
1403# error SQLITE_MAX_SQL_LENGTH must not be greater than SQLITE_MAX_LENGTH
1404#endif
drhbb4957f2008-03-20 14:03:29 +00001405#if SQLITE_MAX_COMPOUND_SELECT<2
1406# error SQLITE_MAX_COMPOUND_SELECT must be at least 2
1407#endif
1408#if SQLITE_MAX_VDBE_OP<40
1409# error SQLITE_MAX_VDBE_OP must be at least 40
1410#endif
drhe82f5d02008-10-07 19:53:14 +00001411#if SQLITE_MAX_FUNCTION_ARG<0 || SQLITE_MAX_FUNCTION_ARG>1000
1412# error SQLITE_MAX_FUNCTION_ARG must be between 0 and 1000
drhbb4957f2008-03-20 14:03:29 +00001413#endif
danielk19777b7e23b2008-08-20 16:21:12 +00001414#if SQLITE_MAX_ATTACHED<0 || SQLITE_MAX_ATTACHED>30
1415# error SQLITE_MAX_ATTACHED must be between 0 and 30
drhbb4957f2008-03-20 14:03:29 +00001416#endif
drhbb4957f2008-03-20 14:03:29 +00001417#if SQLITE_MAX_LIKE_PATTERN_LENGTH<1
1418# error SQLITE_MAX_LIKE_PATTERN_LENGTH must be at least 1
1419#endif
1420#if SQLITE_MAX_VARIABLE_NUMBER<1
1421# error SQLITE_MAX_VARIABLE_NUMBER must be at least 1
1422#endif
drh70a8ca32008-08-21 18:49:27 +00001423#if SQLITE_MAX_COLUMN>32767
1424# error SQLITE_MAX_COLUMN must not exceed 32767
1425#endif
drhbb4957f2008-03-20 14:03:29 +00001426
1427
1428/*
1429** Change the value of a limit. Report the old value.
1430** If an invalid limit index is supplied, report -1.
1431** Make no changes but still report the old value if the
1432** new limit is negative.
1433**
1434** A new lower limit does not shrink existing constructs.
1435** It merely prevents new constructs that exceed the limit
1436** from forming.
1437*/
1438int sqlite3_limit(sqlite3 *db, int limitId, int newLimit){
1439 int oldLimit;
drh521cc842008-04-15 02:36:33 +00001440 if( limitId<0 || limitId>=SQLITE_N_LIMIT ){
drhbb4957f2008-03-20 14:03:29 +00001441 return -1;
1442 }
1443 oldLimit = db->aLimit[limitId];
1444 if( newLimit>=0 ){
drhf47ce562008-03-20 18:00:49 +00001445 if( newLimit>aHardLimit[limitId] ){
drhbb4957f2008-03-20 14:03:29 +00001446 newLimit = aHardLimit[limitId];
1447 }
1448 db->aLimit[limitId] = newLimit;
1449 }
1450 return oldLimit;
1451}
1452
1453/*
danielk19774ad17132004-05-21 01:47:26 +00001454** This routine does the work of opening a database on behalf of
1455** sqlite3_open() and sqlite3_open16(). The database filename "zFilename"
drhee570fa2005-04-28 12:06:05 +00001456** is UTF-8 encoded.
danielk19774ad17132004-05-21 01:47:26 +00001457*/
1458static int openDatabase(
1459 const char *zFilename, /* Database filename UTF-8 encoded */
drh605264d2007-08-21 15:13:19 +00001460 sqlite3 **ppDb, /* OUT: Returned database handle */
1461 unsigned flags, /* Operational flags */
1462 const char *zVfs /* Name of the VFS to use */
danielk19774ad17132004-05-21 01:47:26 +00001463){
1464 sqlite3 *db;
danielk1977da184232006-01-05 11:34:32 +00001465 int rc;
drhd64fe2f2005-08-28 17:00:23 +00001466 CollSeq *pColl;
drh039963a2008-09-03 00:43:15 +00001467 int isThreadsafe;
danielk19774ad17132004-05-21 01:47:26 +00001468
drh40257ff2008-06-13 18:24:27 +00001469#ifndef SQLITE_OMIT_AUTOINIT
1470 rc = sqlite3_initialize();
1471 if( rc ) return rc;
1472#endif
1473
drh039963a2008-09-03 00:43:15 +00001474 if( sqlite3GlobalConfig.bCoreMutex==0 ){
danielk19779a6284c2008-07-10 17:52:49 +00001475 isThreadsafe = 0;
drh039963a2008-09-03 00:43:15 +00001476 }else if( flags & SQLITE_OPEN_NOMUTEX ){
1477 isThreadsafe = 0;
1478 }else if( flags & SQLITE_OPEN_FULLMUTEX ){
1479 isThreadsafe = 1;
1480 }else{
1481 isThreadsafe = sqlite3GlobalConfig.bFullMutex;
danielk19779a6284c2008-07-10 17:52:49 +00001482 }
1483
drha4267dc2008-02-19 15:20:44 +00001484 /* Remove harmful bits from the flags parameter */
1485 flags &= ~( SQLITE_OPEN_DELETEONCLOSE |
1486 SQLITE_OPEN_MAIN_DB |
1487 SQLITE_OPEN_TEMP_DB |
1488 SQLITE_OPEN_TRANSIENT_DB |
1489 SQLITE_OPEN_MAIN_JOURNAL |
1490 SQLITE_OPEN_TEMP_JOURNAL |
1491 SQLITE_OPEN_SUBJOURNAL |
danielk19779a6284c2008-07-10 17:52:49 +00001492 SQLITE_OPEN_MASTER_JOURNAL |
drh039963a2008-09-03 00:43:15 +00001493 SQLITE_OPEN_NOMUTEX |
1494 SQLITE_OPEN_FULLMUTEX
drha4267dc2008-02-19 15:20:44 +00001495 );
1496
danielk19774ad17132004-05-21 01:47:26 +00001497 /* Allocate the sqlite data structure */
drh17435752007-08-16 04:30:38 +00001498 db = sqlite3MallocZero( sizeof(sqlite3) );
danielk19774ad17132004-05-21 01:47:26 +00001499 if( db==0 ) goto opendb_out;
drh039963a2008-09-03 00:43:15 +00001500 if( isThreadsafe ){
danielk197759f8c082008-06-18 17:09:10 +00001501 db->mutex = sqlite3MutexAlloc(SQLITE_MUTEX_RECURSIVE);
1502 if( db->mutex==0 ){
1503 sqlite3_free(db);
1504 db = 0;
1505 goto opendb_out;
1506 }
drh605264d2007-08-21 15:13:19 +00001507 }
drh27641702007-08-22 02:56:42 +00001508 sqlite3_mutex_enter(db->mutex);
drh4ac285a2006-09-15 07:28:50 +00001509 db->errMask = 0xff;
danielk19774ad17132004-05-21 01:47:26 +00001510 db->priorNewRowid = 0;
danielk19774ad17132004-05-21 01:47:26 +00001511 db->nDb = 2;
drh153c62c2007-08-24 03:51:33 +00001512 db->magic = SQLITE_MAGIC_BUSY;
danielk19774ad17132004-05-21 01:47:26 +00001513 db->aDb = db->aDbStatic;
drh633e6d52008-07-28 19:34:53 +00001514
drhbb4957f2008-03-20 14:03:29 +00001515 assert( sizeof(db->aLimit)==sizeof(aHardLimit) );
1516 memcpy(db->aLimit, aHardLimit, sizeof(db->aLimit));
danielk19771d850a72004-05-31 08:26:49 +00001517 db->autoCommit = 1;
drhddac25c2007-12-05 01:38:23 +00001518 db->nextAutovac = -1;
danielk1977f653d782008-03-20 11:04:21 +00001519 db->nextPagesize = 0;
drh76fe8032006-07-11 14:17:51 +00001520 db->flags |= SQLITE_ShortColNames
1521#if SQLITE_DEFAULT_FILE_FORMAT<4
1522 | SQLITE_LegacyFileFmt
1523#endif
drh56424db2007-03-27 22:24:11 +00001524#ifdef SQLITE_ENABLE_LOAD_EXTENSION
1525 | SQLITE_LoadExtension
1526#endif
drh76fe8032006-07-11 14:17:51 +00001527 ;
drh1b67f3c2008-10-10 17:41:28 +00001528 sqlite3HashInit(&db->aCollSeq, 0);
drhb9bb7c12006-06-11 23:41:55 +00001529#ifndef SQLITE_OMIT_VIRTUALTABLE
drh1b67f3c2008-10-10 17:41:28 +00001530 sqlite3HashInit(&db->aModule, 0);
drhb9bb7c12006-06-11 23:41:55 +00001531#endif
danielk1977da184232006-01-05 11:34:32 +00001532
danielk197795c8a542007-09-01 06:51:27 +00001533 db->pVfs = sqlite3_vfs_find(zVfs);
1534 if( !db->pVfs ){
1535 rc = SQLITE_ERROR;
drhafc91042008-02-21 02:09:45 +00001536 sqlite3Error(db, rc, "no such vfs: %s", zVfs);
danielk197795c8a542007-09-01 06:51:27 +00001537 goto opendb_out;
1538 }
1539
danielk19770202b292004-06-09 09:55:16 +00001540 /* Add the default collation sequence BINARY. BINARY works for both UTF-8
1541 ** and UTF-16, so add a version for each to avoid any unnecessary
1542 ** conversions. The only error that can occur here is a malloc() failure.
1543 */
drhafc91042008-02-21 02:09:45 +00001544 createCollation(db, "BINARY", SQLITE_UTF8, 0, binCollFunc, 0);
1545 createCollation(db, "BINARY", SQLITE_UTF16BE, 0, binCollFunc, 0);
1546 createCollation(db, "BINARY", SQLITE_UTF16LE, 0, binCollFunc, 0);
1547 createCollation(db, "RTRIM", SQLITE_UTF8, (void*)1, binCollFunc, 0);
drh77db4c02008-03-18 13:01:38 +00001548 if( db->mallocFailed ){
danielk19770202b292004-06-09 09:55:16 +00001549 goto opendb_out;
1550 }
drh77db4c02008-03-18 13:01:38 +00001551 db->pDfltColl = sqlite3FindCollSeq(db, SQLITE_UTF8, "BINARY", 6, 0);
1552 assert( db->pDfltColl!=0 );
danielk19770202b292004-06-09 09:55:16 +00001553
1554 /* Also add a UTF-8 case-insensitive collation sequence. */
danielk1977a9808b32007-05-07 09:32:45 +00001555 createCollation(db, "NOCASE", SQLITE_UTF8, 0, nocaseCollatingFunc, 0);
danielk19770202b292004-06-09 09:55:16 +00001556
drhd64fe2f2005-08-28 17:00:23 +00001557 /* Set flags on the built-in collating sequences */
1558 db->pDfltColl->type = SQLITE_COLL_BINARY;
1559 pColl = sqlite3FindCollSeq(db, SQLITE_UTF8, "NOCASE", 6, 0);
1560 if( pColl ){
1561 pColl->type = SQLITE_COLL_NOCASE;
1562 }
1563
danielk19774ad17132004-05-21 01:47:26 +00001564 /* Open the backend database driver */
drh33f4e022007-09-03 15:19:34 +00001565 db->openFlags = flags;
1566 rc = sqlite3BtreeFactory(db, zFilename, 0, SQLITE_DEFAULT_CACHE_SIZE,
1567 flags | SQLITE_OPEN_MAIN_DB,
drhc797d4d2007-05-08 01:08:49 +00001568 &db->aDb[0].pBt);
danielk19774ad17132004-05-21 01:47:26 +00001569 if( rc!=SQLITE_OK ){
danielk197745e60aa2008-09-23 17:39:26 +00001570 if( rc==SQLITE_IOERR_NOMEM ){
1571 rc = SQLITE_NOMEM;
1572 }
danielk19774ad17132004-05-21 01:47:26 +00001573 sqlite3Error(db, rc, 0);
danielk19774ad17132004-05-21 01:47:26 +00001574 goto opendb_out;
1575 }
drh17435752007-08-16 04:30:38 +00001576 db->aDb[0].pSchema = sqlite3SchemaGet(db, db->aDb[0].pBt);
1577 db->aDb[1].pSchema = sqlite3SchemaGet(db, 0);
danielk197714db2662006-01-09 16:12:04 +00001578
drh03b808a2006-03-13 15:06:05 +00001579
danielk197753c0f742005-03-29 03:10:59 +00001580 /* The default safety_level for the main database is 'full'; for the temp
1581 ** database it is 'NONE'. This matches the pager layer defaults.
1582 */
1583 db->aDb[0].zName = "main";
danielk197791cf71b2004-06-26 06:37:06 +00001584 db->aDb[0].safety_level = 3;
danielk197753c0f742005-03-29 03:10:59 +00001585#ifndef SQLITE_OMIT_TEMPDB
1586 db->aDb[1].zName = "temp";
danielk197791cf71b2004-06-26 06:37:06 +00001587 db->aDb[1].safety_level = 1;
danielk197753c0f742005-03-29 03:10:59 +00001588#endif
1589
danielk1977832a58a2007-06-22 15:21:15 +00001590 db->magic = SQLITE_MAGIC_OPEN;
drh17435752007-08-16 04:30:38 +00001591 if( db->mallocFailed ){
danielk1977832a58a2007-06-22 15:21:15 +00001592 goto opendb_out;
1593 }
1594
danielk19778e227872004-06-07 07:52:17 +00001595 /* Register all built-in functions, but do not attempt to read the
1596 ** database schema yet. This is delayed until the first time the database
1597 ** is accessed.
1598 */
danielk1977832a58a2007-06-22 15:21:15 +00001599 sqlite3Error(db, SQLITE_OK, 0);
1600 sqlite3RegisterBuiltinFunctions(db);
danielk19774ad17132004-05-21 01:47:26 +00001601
drh1409be62006-08-23 20:07:20 +00001602 /* Load automatic extensions - extensions that have been registered
1603 ** using the sqlite3_automatic_extension() API.
1604 */
drhf533acc2006-12-19 18:57:11 +00001605 (void)sqlite3AutoLoadExtensions(db);
danielk1977832a58a2007-06-22 15:21:15 +00001606 if( sqlite3_errcode(db)!=SQLITE_OK ){
1607 goto opendb_out;
1608 }
drh1409be62006-08-23 20:07:20 +00001609
drhaa29c132006-09-02 13:58:06 +00001610#ifdef SQLITE_ENABLE_FTS1
drh17435752007-08-16 04:30:38 +00001611 if( !db->mallocFailed ){
drhaa29c132006-09-02 13:58:06 +00001612 extern int sqlite3Fts1Init(sqlite3*);
danielk1977832a58a2007-06-22 15:21:15 +00001613 rc = sqlite3Fts1Init(db);
drhaa29c132006-09-02 13:58:06 +00001614 }
1615#endif
1616
shessa26cf572006-10-19 20:27:58 +00001617#ifdef SQLITE_ENABLE_FTS2
drh17435752007-08-16 04:30:38 +00001618 if( !db->mallocFailed && rc==SQLITE_OK ){
shessa26cf572006-10-19 20:27:58 +00001619 extern int sqlite3Fts2Init(sqlite3*);
danielk1977832a58a2007-06-22 15:21:15 +00001620 rc = sqlite3Fts2Init(db);
shessa26cf572006-10-19 20:27:58 +00001621 }
1622#endif
1623
shess69c4ae22007-08-20 17:37:47 +00001624#ifdef SQLITE_ENABLE_FTS3
1625 if( !db->mallocFailed && rc==SQLITE_OK ){
shess69c4ae22007-08-20 17:37:47 +00001626 rc = sqlite3Fts3Init(db);
1627 }
1628#endif
1629
danielk197783852ac2007-05-06 16:04:11 +00001630#ifdef SQLITE_ENABLE_ICU
drh17435752007-08-16 04:30:38 +00001631 if( !db->mallocFailed && rc==SQLITE_OK ){
danielk1977832a58a2007-06-22 15:21:15 +00001632 rc = sqlite3IcuInit(db);
danielk197783852ac2007-05-06 16:04:11 +00001633 }
1634#endif
danielk1977ebaecc12008-05-26 18:41:54 +00001635
1636#ifdef SQLITE_ENABLE_RTREE
1637 if( !db->mallocFailed && rc==SQLITE_OK){
danielk1977ebaecc12008-05-26 18:41:54 +00001638 rc = sqlite3RtreeInit(db);
1639 }
1640#endif
1641
danielk1977832a58a2007-06-22 15:21:15 +00001642 sqlite3Error(db, rc, 0);
danielk197783852ac2007-05-06 16:04:11 +00001643
drh8fd5bd32007-04-02 16:40:37 +00001644 /* -DSQLITE_DEFAULT_LOCKING_MODE=1 makes EXCLUSIVE the default locking
1645 ** mode. -DSQLITE_DEFAULT_LOCKING_MODE=0 make NORMAL the default locking
1646 ** mode. Doing nothing at all also makes NORMAL the default.
1647 */
1648#ifdef SQLITE_DEFAULT_LOCKING_MODE
1649 db->dfltLockMode = SQLITE_DEFAULT_LOCKING_MODE;
1650 sqlite3PagerLockingMode(sqlite3BtreePager(db->aDb[0].pBt),
1651 SQLITE_DEFAULT_LOCKING_MODE);
1652#endif
1653
drh633e6d52008-07-28 19:34:53 +00001654 /* Enable the lookaside-malloc subsystem */
drh1b67f3c2008-10-10 17:41:28 +00001655 setupLookaside(db, 0, sqlite3GlobalConfig.szLookaside,
1656 sqlite3GlobalConfig.nLookaside);
drh633e6d52008-07-28 19:34:53 +00001657
danielk19774ad17132004-05-21 01:47:26 +00001658opendb_out:
drhafc91042008-02-21 02:09:45 +00001659 if( db ){
danielk1977075c23a2008-09-01 18:34:20 +00001660 assert( db->mutex!=0 || isThreadsafe==0 || sqlite3GlobalConfig.bFullMutex==0 );
drhf3a65f72007-08-22 20:18:21 +00001661 sqlite3_mutex_leave(db->mutex);
1662 }
danielk197759633ae2008-08-27 19:01:57 +00001663 rc = sqlite3_errcode(db);
1664 if( rc==SQLITE_NOMEM ){
danielk19777ddad962005-12-12 06:53:03 +00001665 sqlite3_close(db);
1666 db = 0;
danielk197759633ae2008-08-27 19:01:57 +00001667 }else if( rc!=SQLITE_OK ){
1668 db->magic = SQLITE_MAGIC_SICK;
danielk197713073932004-06-30 11:54:06 +00001669 }
danielk19774ad17132004-05-21 01:47:26 +00001670 *ppDb = db;
danielk197754f01982006-01-18 15:25:17 +00001671 return sqlite3ApiExit(0, rc);
danielk19774ad17132004-05-21 01:47:26 +00001672}
1673
1674/*
1675** Open a new database handle.
1676*/
danielk197780290862004-05-22 09:21:21 +00001677int sqlite3_open(
danielk19774ad17132004-05-21 01:47:26 +00001678 const char *zFilename,
danielk19774f057f92004-06-08 00:02:33 +00001679 sqlite3 **ppDb
danielk19774ad17132004-05-21 01:47:26 +00001680){
drh605264d2007-08-21 15:13:19 +00001681 return openDatabase(zFilename, ppDb,
1682 SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, 0);
1683}
1684int sqlite3_open_v2(
drh428e2822007-08-30 16:23:19 +00001685 const char *filename, /* Database filename (UTF-8) */
drh605264d2007-08-21 15:13:19 +00001686 sqlite3 **ppDb, /* OUT: SQLite db handle */
1687 int flags, /* Flags */
1688 const char *zVfs /* Name of VFS module to use */
1689){
1690 return openDatabase(filename, ppDb, flags, zVfs);
danielk197783ab5a82004-05-21 11:39:05 +00001691}
1692
drh6c626082004-11-14 21:56:29 +00001693#ifndef SQLITE_OMIT_UTF16
danielk19774ad17132004-05-21 01:47:26 +00001694/*
1695** Open a new database handle.
1696*/
1697int sqlite3_open16(
1698 const void *zFilename,
danielk19774f057f92004-06-08 00:02:33 +00001699 sqlite3 **ppDb
danielk19774ad17132004-05-21 01:47:26 +00001700){
danielk1977bfd6cce2004-06-18 04:24:54 +00001701 char const *zFilename8; /* zFilename encoded in UTF-8 instead of UTF-16 */
danielk1977bfd6cce2004-06-18 04:24:54 +00001702 sqlite3_value *pVal;
drh40257ff2008-06-13 18:24:27 +00001703 int rc;
danielk19774ad17132004-05-21 01:47:26 +00001704
danielk19777ddad962005-12-12 06:53:03 +00001705 assert( zFilename );
danielk19774ad17132004-05-21 01:47:26 +00001706 assert( ppDb );
danielk1977bfd6cce2004-06-18 04:24:54 +00001707 *ppDb = 0;
drh40257ff2008-06-13 18:24:27 +00001708#ifndef SQLITE_OMIT_AUTOINIT
1709 rc = sqlite3_initialize();
1710 if( rc ) return rc;
1711#endif
danielk19771e536952007-08-16 10:09:01 +00001712 pVal = sqlite3ValueNew(0);
drhb21c8cd2007-08-21 19:33:56 +00001713 sqlite3ValueSetStr(pVal, -1, zFilename, SQLITE_UTF16NATIVE, SQLITE_STATIC);
1714 zFilename8 = sqlite3ValueText(pVal, SQLITE_UTF8);
danielk1977bfd6cce2004-06-18 04:24:54 +00001715 if( zFilename8 ){
drh605264d2007-08-21 15:13:19 +00001716 rc = openDatabase(zFilename8, ppDb,
1717 SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, 0);
drhafc91042008-02-21 02:09:45 +00001718 assert( *ppDb || rc==SQLITE_NOMEM );
danielk1977f51bf482008-04-28 16:19:35 +00001719 if( rc==SQLITE_OK && !DbHasProperty(*ppDb, 0, DB_SchemaLoaded) ){
danielk1977fb103a82008-04-03 16:28:24 +00001720 ENC(*ppDb) = SQLITE_UTF16NATIVE;
danielk1977bfd6cce2004-06-18 04:24:54 +00001721 }
drh40257ff2008-06-13 18:24:27 +00001722 }else{
1723 rc = SQLITE_NOMEM;
danielk19774ad17132004-05-21 01:47:26 +00001724 }
danielk19777ddad962005-12-12 06:53:03 +00001725 sqlite3ValueFree(pVal);
danielk19778e227872004-06-07 07:52:17 +00001726
danielk197754f01982006-01-18 15:25:17 +00001727 return sqlite3ApiExit(0, rc);
danielk19774ad17132004-05-21 01:47:26 +00001728}
drh6c626082004-11-14 21:56:29 +00001729#endif /* SQLITE_OMIT_UTF16 */
danielk19774ad17132004-05-21 01:47:26 +00001730
danielk1977106bb232004-05-21 10:08:53 +00001731/*
danielk1977d8123362004-06-12 09:25:12 +00001732** Register a new collation sequence with the database handle db.
1733*/
danielk19770202b292004-06-09 09:55:16 +00001734int sqlite3_create_collation(
1735 sqlite3* db,
1736 const char *zName,
danielk1977466be562004-06-10 02:16:01 +00001737 int enc,
danielk19770202b292004-06-09 09:55:16 +00001738 void* pCtx,
1739 int(*xCompare)(void*,int,const void*,int,const void*)
1740){
danielk19779a30cf62006-01-18 04:26:07 +00001741 int rc;
drhe30f4422007-08-21 16:15:55 +00001742 sqlite3_mutex_enter(db->mutex);
drh17435752007-08-16 04:30:38 +00001743 assert( !db->mallocFailed );
danielk1977a9808b32007-05-07 09:32:45 +00001744 rc = createCollation(db, zName, enc, pCtx, xCompare, 0);
drhe30f4422007-08-21 16:15:55 +00001745 rc = sqlite3ApiExit(db, rc);
1746 sqlite3_mutex_leave(db->mutex);
1747 return rc;
danielk1977a9808b32007-05-07 09:32:45 +00001748}
1749
1750/*
1751** Register a new collation sequence with the database handle db.
1752*/
danielk1977a393c032007-05-07 14:58:53 +00001753int sqlite3_create_collation_v2(
danielk1977a9808b32007-05-07 09:32:45 +00001754 sqlite3* db,
1755 const char *zName,
1756 int enc,
1757 void* pCtx,
1758 int(*xCompare)(void*,int,const void*,int,const void*),
1759 void(*xDel)(void*)
1760){
1761 int rc;
drhe30f4422007-08-21 16:15:55 +00001762 sqlite3_mutex_enter(db->mutex);
drh17435752007-08-16 04:30:38 +00001763 assert( !db->mallocFailed );
danielk1977a9808b32007-05-07 09:32:45 +00001764 rc = createCollation(db, zName, enc, pCtx, xCompare, xDel);
drhe30f4422007-08-21 16:15:55 +00001765 rc = sqlite3ApiExit(db, rc);
1766 sqlite3_mutex_leave(db->mutex);
1767 return rc;
danielk19770202b292004-06-09 09:55:16 +00001768}
1769
drh6c626082004-11-14 21:56:29 +00001770#ifndef SQLITE_OMIT_UTF16
danielk1977d8123362004-06-12 09:25:12 +00001771/*
1772** Register a new collation sequence with the database handle db.
1773*/
danielk19770202b292004-06-09 09:55:16 +00001774int sqlite3_create_collation16(
1775 sqlite3* db,
mihailimbda2e622008-06-23 11:23:14 +00001776 const void *zName,
danielk1977466be562004-06-10 02:16:01 +00001777 int enc,
danielk19770202b292004-06-09 09:55:16 +00001778 void* pCtx,
1779 int(*xCompare)(void*,int,const void*,int,const void*)
1780){
danielk19779a30cf62006-01-18 04:26:07 +00001781 int rc = SQLITE_OK;
drh01495b92008-01-23 12:52:40 +00001782 char *zName8;
drhe30f4422007-08-21 16:15:55 +00001783 sqlite3_mutex_enter(db->mutex);
drh17435752007-08-16 04:30:38 +00001784 assert( !db->mallocFailed );
danielk19771e536952007-08-16 10:09:01 +00001785 zName8 = sqlite3Utf16to8(db, zName, -1);
danielk19779a30cf62006-01-18 04:26:07 +00001786 if( zName8 ){
danielk1977a9808b32007-05-07 09:32:45 +00001787 rc = createCollation(db, zName8, enc, pCtx, xCompare, 0);
drh633e6d52008-07-28 19:34:53 +00001788 sqlite3DbFree(db, zName8);
danielk19779a30cf62006-01-18 04:26:07 +00001789 }
drhe30f4422007-08-21 16:15:55 +00001790 rc = sqlite3ApiExit(db, rc);
1791 sqlite3_mutex_leave(db->mutex);
1792 return rc;
danielk19770202b292004-06-09 09:55:16 +00001793}
drh6c626082004-11-14 21:56:29 +00001794#endif /* SQLITE_OMIT_UTF16 */
danielk19777cedc8d2004-06-10 10:50:08 +00001795
danielk1977d8123362004-06-12 09:25:12 +00001796/*
1797** Register a collation sequence factory callback with the database handle
1798** db. Replace any previously installed collation sequence factory.
1799*/
danielk19777cedc8d2004-06-10 10:50:08 +00001800int sqlite3_collation_needed(
1801 sqlite3 *db,
1802 void *pCollNeededArg,
1803 void(*xCollNeeded)(void*,sqlite3*,int eTextRep,const char*)
1804){
drhe30f4422007-08-21 16:15:55 +00001805 sqlite3_mutex_enter(db->mutex);
danielk19777cedc8d2004-06-10 10:50:08 +00001806 db->xCollNeeded = xCollNeeded;
1807 db->xCollNeeded16 = 0;
1808 db->pCollNeededArg = pCollNeededArg;
drhe30f4422007-08-21 16:15:55 +00001809 sqlite3_mutex_leave(db->mutex);
danielk19777cedc8d2004-06-10 10:50:08 +00001810 return SQLITE_OK;
1811}
danielk1977d8123362004-06-12 09:25:12 +00001812
drh6c626082004-11-14 21:56:29 +00001813#ifndef SQLITE_OMIT_UTF16
danielk1977d8123362004-06-12 09:25:12 +00001814/*
1815** Register a collation sequence factory callback with the database handle
1816** db. Replace any previously installed collation sequence factory.
1817*/
danielk19777cedc8d2004-06-10 10:50:08 +00001818int sqlite3_collation_needed16(
1819 sqlite3 *db,
1820 void *pCollNeededArg,
1821 void(*xCollNeeded16)(void*,sqlite3*,int eTextRep,const void*)
1822){
drhe30f4422007-08-21 16:15:55 +00001823 sqlite3_mutex_enter(db->mutex);
danielk19777cedc8d2004-06-10 10:50:08 +00001824 db->xCollNeeded = 0;
1825 db->xCollNeeded16 = xCollNeeded16;
1826 db->pCollNeededArg = pCollNeededArg;
drhe30f4422007-08-21 16:15:55 +00001827 sqlite3_mutex_leave(db->mutex);
danielk19777cedc8d2004-06-10 10:50:08 +00001828 return SQLITE_OK;
1829}
drh6c626082004-11-14 21:56:29 +00001830#endif /* SQLITE_OMIT_UTF16 */
danielk19776b456a22005-03-21 04:04:02 +00001831
1832#ifndef SQLITE_OMIT_GLOBALRECOVER
shaneeec556d2008-10-12 00:27:53 +00001833#ifndef SQLITE_OMIT_DEPRECATED
danielk19776b456a22005-03-21 04:04:02 +00001834/*
danielk19777ddad962005-12-12 06:53:03 +00001835** This function is now an anachronism. It used to be used to recover from a
1836** malloc() failure, but SQLite now does this automatically.
danielk19776b456a22005-03-21 04:04:02 +00001837*/
drh7d97efb2007-10-12 19:35:48 +00001838int sqlite3_global_recover(void){
danielk1977261919c2005-12-06 12:52:59 +00001839 return SQLITE_OK;
danielk19776b456a22005-03-21 04:04:02 +00001840}
1841#endif
shaneeec556d2008-10-12 00:27:53 +00001842#endif
drh3e1d8e62005-05-26 16:23:34 +00001843
1844/*
1845** Test to see whether or not the database connection is in autocommit
1846** mode. Return TRUE if it is and FALSE if not. Autocommit mode is on
1847** by default. Autocommit is disabled by a BEGIN statement and reenabled
1848** by the next COMMIT or ROLLBACK.
1849**
1850******* THIS IS AN EXPERIMENTAL API AND IS SUBJECT TO CHANGE ******
1851*/
1852int sqlite3_get_autocommit(sqlite3 *db){
1853 return db->autoCommit;
1854}
drh49285702005-09-17 15:20:26 +00001855
1856#ifdef SQLITE_DEBUG
1857/*
1858** The following routine is subtituted for constant SQLITE_CORRUPT in
1859** debugging builds. This provides a way to set a breakpoint for when
1860** corruption is first detected.
1861*/
1862int sqlite3Corrupt(void){
1863 return SQLITE_CORRUPT;
1864}
1865#endif
drh7c1817e2006-01-10 13:58:48 +00001866
shaneeec556d2008-10-12 00:27:53 +00001867#ifndef SQLITE_OMIT_DEPRECATED
drh6f7adc82006-01-11 21:41:20 +00001868/*
1869** This is a convenience routine that makes sure that all thread-specific
1870** data for this thread has been deallocated.
drhdce8bdb2007-08-16 13:01:44 +00001871**
1872** SQLite no longer uses thread-specific data so this routine is now a
1873** no-op. It is retained for historical compatibility.
drh6f7adc82006-01-11 21:41:20 +00001874*/
1875void sqlite3_thread_cleanup(void){
drh6f7adc82006-01-11 21:41:20 +00001876}
shaneeec556d2008-10-12 00:27:53 +00001877#endif
danielk1977deb802c2006-02-09 13:43:28 +00001878
1879/*
1880** Return meta information about a specific column of a database table.
1881** See comment in sqlite3.h (sqlite.h.in) for details.
1882*/
1883#ifdef SQLITE_ENABLE_COLUMN_METADATA
1884int sqlite3_table_column_metadata(
1885 sqlite3 *db, /* Connection handle */
1886 const char *zDbName, /* Database name or NULL */
1887 const char *zTableName, /* Table name */
1888 const char *zColumnName, /* Column name */
1889 char const **pzDataType, /* OUTPUT: Declared data type */
1890 char const **pzCollSeq, /* OUTPUT: Collation sequence name */
1891 int *pNotNull, /* OUTPUT: True if NOT NULL constraint exists */
1892 int *pPrimaryKey, /* OUTPUT: True if column part of PK */
drh9be07162008-06-16 20:51:15 +00001893 int *pAutoinc /* OUTPUT: True if column is auto-increment */
danielk1977deb802c2006-02-09 13:43:28 +00001894){
1895 int rc;
1896 char *zErrMsg = 0;
1897 Table *pTab = 0;
1898 Column *pCol = 0;
1899 int iCol;
1900
1901 char const *zDataType = 0;
1902 char const *zCollSeq = 0;
1903 int notnull = 0;
1904 int primarykey = 0;
1905 int autoinc = 0;
1906
1907 /* Ensure the database schema has been loaded */
drhe30f4422007-08-21 16:15:55 +00001908 sqlite3_mutex_enter(db->mutex);
drha0af99f2008-04-16 00:49:12 +00001909 (void)sqlite3SafetyOn(db);
drh3cb3edc2008-03-07 21:37:19 +00001910 sqlite3BtreeEnterAll(db);
danielk1977deb802c2006-02-09 13:43:28 +00001911 rc = sqlite3Init(db, &zErrMsg);
drh3cb3edc2008-03-07 21:37:19 +00001912 sqlite3BtreeLeaveAll(db);
danielk1977deb802c2006-02-09 13:43:28 +00001913 if( SQLITE_OK!=rc ){
1914 goto error_out;
1915 }
1916
1917 /* Locate the table in question */
1918 pTab = sqlite3FindTable(db, zTableName, zDbName);
1919 if( !pTab || pTab->pSelect ){
1920 pTab = 0;
1921 goto error_out;
1922 }
1923
1924 /* Find the column for which info is requested */
1925 if( sqlite3IsRowid(zColumnName) ){
1926 iCol = pTab->iPKey;
1927 if( iCol>=0 ){
1928 pCol = &pTab->aCol[iCol];
1929 }
1930 }else{
1931 for(iCol=0; iCol<pTab->nCol; iCol++){
1932 pCol = &pTab->aCol[iCol];
1933 if( 0==sqlite3StrICmp(pCol->zName, zColumnName) ){
1934 break;
1935 }
1936 }
1937 if( iCol==pTab->nCol ){
1938 pTab = 0;
1939 goto error_out;
1940 }
1941 }
1942
1943 /* The following block stores the meta information that will be returned
1944 ** to the caller in local variables zDataType, zCollSeq, notnull, primarykey
1945 ** and autoinc. At this point there are two possibilities:
1946 **
1947 ** 1. The specified column name was rowid", "oid" or "_rowid_"
1948 ** and there is no explicitly declared IPK column.
1949 **
1950 ** 2. The table is not a view and the column name identified an
1951 ** explicitly declared column. Copy meta information from *pCol.
1952 */
1953 if( pCol ){
1954 zDataType = pCol->zType;
1955 zCollSeq = pCol->zColl;
drh9be07162008-06-16 20:51:15 +00001956 notnull = pCol->notNull!=0;
1957 primarykey = pCol->isPrimKey!=0;
drh7d10d5a2008-08-20 16:35:10 +00001958 autoinc = pTab->iPKey==iCol && (pTab->tabFlags & TF_Autoincrement)!=0;
danielk1977deb802c2006-02-09 13:43:28 +00001959 }else{
1960 zDataType = "INTEGER";
1961 primarykey = 1;
1962 }
1963 if( !zCollSeq ){
1964 zCollSeq = "BINARY";
1965 }
1966
1967error_out:
drh01495b92008-01-23 12:52:40 +00001968 (void)sqlite3SafetyOff(db);
danielk1977deb802c2006-02-09 13:43:28 +00001969
1970 /* Whether the function call succeeded or failed, set the output parameters
1971 ** to whatever their local counterparts contain. If an error did occur,
1972 ** this has the effect of zeroing all output parameters.
1973 */
1974 if( pzDataType ) *pzDataType = zDataType;
1975 if( pzCollSeq ) *pzCollSeq = zCollSeq;
1976 if( pNotNull ) *pNotNull = notnull;
1977 if( pPrimaryKey ) *pPrimaryKey = primarykey;
1978 if( pAutoinc ) *pAutoinc = autoinc;
1979
1980 if( SQLITE_OK==rc && !pTab ){
drh633e6d52008-07-28 19:34:53 +00001981 sqlite3DbFree(db, zErrMsg);
drh118640b2008-07-16 14:02:32 +00001982 zErrMsg = sqlite3MPrintf(db, "no such table column: %s.%s", zTableName,
drhf089aa42008-07-08 19:34:06 +00001983 zColumnName);
danielk1977deb802c2006-02-09 13:43:28 +00001984 rc = SQLITE_ERROR;
1985 }
1986 sqlite3Error(db, rc, (zErrMsg?"%s":0), zErrMsg);
drh633e6d52008-07-28 19:34:53 +00001987 sqlite3DbFree(db, zErrMsg);
drhe30f4422007-08-21 16:15:55 +00001988 rc = sqlite3ApiExit(db, rc);
1989 sqlite3_mutex_leave(db->mutex);
drhf9cb7f52006-06-27 20:06:44 +00001990 return rc;
1991}
drhe30f4422007-08-21 16:15:55 +00001992#endif
drhf9cb7f52006-06-27 20:06:44 +00001993
1994/*
1995** Sleep for a little while. Return the amount of time slept.
1996*/
1997int sqlite3_sleep(int ms){
danielk1977b4b47412007-08-17 15:53:36 +00001998 sqlite3_vfs *pVfs;
drhe30f4422007-08-21 16:15:55 +00001999 int rc;
drhd677b3d2007-08-20 22:48:41 +00002000 pVfs = sqlite3_vfs_find(0);
drh40257ff2008-06-13 18:24:27 +00002001 if( pVfs==0 ) return 0;
danielk1977fee2d252007-08-18 10:59:19 +00002002
2003 /* This function works in milliseconds, but the underlying OsSleep()
2004 ** API uses microseconds. Hence the 1000's.
2005 */
drhe30f4422007-08-21 16:15:55 +00002006 rc = (sqlite3OsSleep(pVfs, 1000*ms)/1000);
drhe30f4422007-08-21 16:15:55 +00002007 return rc;
drhf9cb7f52006-06-27 20:06:44 +00002008}
drh4ac285a2006-09-15 07:28:50 +00002009
2010/*
2011** Enable or disable the extended result codes.
2012*/
2013int sqlite3_extended_result_codes(sqlite3 *db, int onoff){
drhe30f4422007-08-21 16:15:55 +00002014 sqlite3_mutex_enter(db->mutex);
drh4ac285a2006-09-15 07:28:50 +00002015 db->errMask = onoff ? 0xffffffff : 0xff;
drhe30f4422007-08-21 16:15:55 +00002016 sqlite3_mutex_leave(db->mutex);
drh4ac285a2006-09-15 07:28:50 +00002017 return SQLITE_OK;
2018}
drhcc6bb3e2007-08-31 16:11:35 +00002019
2020/*
2021** Invoke the xFileControl method on a particular database.
2022*/
2023int sqlite3_file_control(sqlite3 *db, const char *zDbName, int op, void *pArg){
2024 int rc = SQLITE_ERROR;
2025 int iDb;
2026 sqlite3_mutex_enter(db->mutex);
2027 if( zDbName==0 ){
2028 iDb = 0;
2029 }else{
2030 for(iDb=0; iDb<db->nDb; iDb++){
2031 if( strcmp(db->aDb[iDb].zName, zDbName)==0 ) break;
2032 }
2033 }
2034 if( iDb<db->nDb ){
2035 Btree *pBtree = db->aDb[iDb].pBt;
2036 if( pBtree ){
2037 Pager *pPager;
drh55176252008-01-22 14:50:16 +00002038 sqlite3_file *fd;
drhcc6bb3e2007-08-31 16:11:35 +00002039 sqlite3BtreeEnter(pBtree);
2040 pPager = sqlite3BtreePager(pBtree);
drh55176252008-01-22 14:50:16 +00002041 assert( pPager!=0 );
2042 fd = sqlite3PagerFile(pPager);
2043 assert( fd!=0 );
2044 if( fd->pMethods ){
2045 rc = sqlite3OsFileControl(fd, op, pArg);
drhcc6bb3e2007-08-31 16:11:35 +00002046 }
2047 sqlite3BtreeLeave(pBtree);
2048 }
2049 }
2050 sqlite3_mutex_leave(db->mutex);
2051 return rc;
2052}
drhed13d982008-01-31 14:43:24 +00002053
2054/*
2055** Interface to the testing logic.
2056*/
2057int sqlite3_test_control(int op, ...){
drhed13d982008-01-31 14:43:24 +00002058 int rc = 0;
drh3088d592008-03-21 16:45:47 +00002059#ifndef SQLITE_OMIT_BUILTIN_TEST
drh2fa18682008-03-19 14:15:34 +00002060 va_list ap;
drhed13d982008-01-31 14:43:24 +00002061 va_start(ap, op);
2062 switch( op ){
danielk1977d09414c2008-06-19 18:17:49 +00002063
2064 /*
drh984bfaa2008-03-19 16:08:53 +00002065 ** Save the current state of the PRNG.
2066 */
drh2fa18682008-03-19 14:15:34 +00002067 case SQLITE_TESTCTRL_PRNG_SAVE: {
2068 sqlite3PrngSaveState();
2069 break;
2070 }
drh984bfaa2008-03-19 16:08:53 +00002071
2072 /*
2073 ** Restore the state of the PRNG to the last state saved using
2074 ** PRNG_SAVE. If PRNG_SAVE has never before been called, then
2075 ** this verb acts like PRNG_RESET.
2076 */
drh2fa18682008-03-19 14:15:34 +00002077 case SQLITE_TESTCTRL_PRNG_RESTORE: {
2078 sqlite3PrngRestoreState();
2079 break;
2080 }
drh984bfaa2008-03-19 16:08:53 +00002081
2082 /*
2083 ** Reset the PRNG back to its uninitialized state. The next call
2084 ** to sqlite3_randomness() will reseed the PRNG using a single call
2085 ** to the xRandomness method of the default VFS.
2086 */
drh2fa18682008-03-19 14:15:34 +00002087 case SQLITE_TESTCTRL_PRNG_RESET: {
2088 sqlite3PrngResetState();
2089 break;
2090 }
drh3088d592008-03-21 16:45:47 +00002091
2092 /*
2093 ** sqlite3_test_control(BITVEC_TEST, size, program)
2094 **
2095 ** Run a test against a Bitvec object of size. The program argument
2096 ** is an array of integers that defines the test. Return -1 on a
2097 ** memory allocation error, 0 on success, or non-zero for an error.
2098 ** See the sqlite3BitvecBuiltinTest() for additional information.
2099 */
2100 case SQLITE_TESTCTRL_BITVEC_TEST: {
2101 int sz = va_arg(ap, int);
2102 int *aProg = va_arg(ap, int*);
2103 rc = sqlite3BitvecBuiltinTest(sz, aProg);
2104 break;
2105 }
danielk19772d1d86f2008-06-20 14:59:51 +00002106
2107 /*
2108 ** sqlite3_test_control(BENIGN_MALLOC_HOOKS, xBegin, xEnd)
2109 **
2110 ** Register hooks to call to indicate which malloc() failures
2111 ** are benign.
2112 */
2113 case SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS: {
danielk1977ca026792008-06-23 14:15:52 +00002114 typedef void (*void_function)(void);
2115 void_function xBenignBegin;
2116 void_function xBenignEnd;
2117 xBenignBegin = va_arg(ap, void_function);
2118 xBenignEnd = va_arg(ap, void_function);
danielk19772d1d86f2008-06-20 14:59:51 +00002119 sqlite3BenignMallocHooks(xBenignBegin, xBenignEnd);
2120 break;
2121 }
drhed13d982008-01-31 14:43:24 +00002122 }
2123 va_end(ap);
drh3088d592008-03-21 16:45:47 +00002124#endif /* SQLITE_OMIT_BUILTIN_TEST */
danielk19777c36d072008-01-31 15:31:01 +00002125 return rc;
drhed13d982008-01-31 14:43:24 +00002126}