drh | 7589723 | 2000-05-29 14:26:00 +0000 | [diff] [blame] | 1 | /* |
drh | b19a2bc | 2001-09-16 00:13:26 +0000 | [diff] [blame] | 2 | ** 2001 September 15 |
drh | 7589723 | 2000-05-29 14:26:00 +0000 | [diff] [blame] | 3 | ** |
drh | b19a2bc | 2001-09-16 00:13:26 +0000 | [diff] [blame] | 4 | ** The author disclaims copyright to this source code. In place of |
| 5 | ** a legal notice, here is a blessing: |
drh | 7589723 | 2000-05-29 14:26:00 +0000 | [diff] [blame] | 6 | ** |
drh | b19a2bc | 2001-09-16 00:13:26 +0000 | [diff] [blame] | 7 | ** May you do good and not evil. |
| 8 | ** May you find forgiveness for yourself and forgive others. |
| 9 | ** May you share freely, never taking more than you give. |
drh | 7589723 | 2000-05-29 14:26:00 +0000 | [diff] [blame] | 10 | ** |
| 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 | ** |
shane | 2479de3 | 2008-11-10 18:05:35 +0000 | [diff] [blame] | 17 | ** $Id: main.c,v 1.511 2008/11/10 18:05:36 shane Exp $ |
drh | 7589723 | 2000-05-29 14:26:00 +0000 | [diff] [blame] | 18 | */ |
| 19 | #include "sqliteInt.h" |
drh | ce9079c | 2002-05-15 14:17:44 +0000 | [diff] [blame] | 20 | #include <ctype.h> |
drh | 58f1c8b | 2008-05-26 20:19:25 +0000 | [diff] [blame] | 21 | |
drh | 820a906 | 2008-01-31 13:35:48 +0000 | [diff] [blame] | 22 | #ifdef SQLITE_ENABLE_FTS3 |
| 23 | # include "fts3.h" |
| 24 | #endif |
drh | 58f1c8b | 2008-05-26 20:19:25 +0000 | [diff] [blame] | 25 | #ifdef SQLITE_ENABLE_RTREE |
| 26 | # include "rtree.h" |
| 27 | #endif |
danielk1977 | 1c82665 | 2008-09-08 08:08:09 +0000 | [diff] [blame] | 28 | #ifdef SQLITE_ENABLE_ICU |
| 29 | # include "sqliteicu.h" |
| 30 | #endif |
drh | 7589723 | 2000-05-29 14:26:00 +0000 | [diff] [blame] | 31 | |
| 32 | /* |
drh | b217a57 | 2000-08-22 13:40:18 +0000 | [diff] [blame] | 33 | ** The version of the library |
| 34 | */ |
danielk1977 | 24b03fd | 2004-05-10 10:34:34 +0000 | [diff] [blame] | 35 | const char sqlite3_version[] = SQLITE_VERSION; |
drh | 4aec8b6 | 2004-08-28 16:19:00 +0000 | [diff] [blame] | 36 | const char *sqlite3_libversion(void){ return sqlite3_version; } |
danielk1977 | 99ba19e | 2005-02-05 07:33:34 +0000 | [diff] [blame] | 37 | int sqlite3_libversion_number(void){ return SQLITE_VERSION_NUMBER; } |
drh | b67e8bf | 2007-08-30 20:09:48 +0000 | [diff] [blame] | 38 | int sqlite3_threadsafe(void){ return SQLITE_THREADSAFE; } |
drh | b217a57 | 2000-08-22 13:40:18 +0000 | [diff] [blame] | 39 | |
drh | e265b08 | 2008-05-01 17:03:49 +0000 | [diff] [blame] | 40 | #if !defined(SQLITE_OMIT_TRACE) && defined(SQLITE_ENABLE_IOTRACE) |
drh | b217a57 | 2000-08-22 13:40:18 +0000 | [diff] [blame] | 41 | /* |
drh | b060341 | 2007-02-28 04:47:26 +0000 | [diff] [blame] | 42 | ** If the following function pointer is not NULL and if |
| 43 | ** SQLITE_ENABLE_IOTRACE is enabled, then messages describing |
| 44 | ** I/O active are written using this function. These messages |
| 45 | ** are intended for debugging activity only. |
| 46 | */ |
mlcreech | 3a00f90 | 2008-03-04 17:45:01 +0000 | [diff] [blame] | 47 | void (*sqlite3IoTrace)(const char*, ...) = 0; |
drh | e265b08 | 2008-05-01 17:03:49 +0000 | [diff] [blame] | 48 | #endif |
drh | b060341 | 2007-02-28 04:47:26 +0000 | [diff] [blame] | 49 | |
| 50 | /* |
drh | a16313e | 2007-03-30 11:29:32 +0000 | [diff] [blame] | 51 | ** If the following global variable points to a string which is the |
| 52 | ** name of a directory, then that directory will be used to store |
| 53 | ** temporary files. |
| 54 | ** |
| 55 | ** See also the "PRAGMA temp_store_directory" SQL command. |
| 56 | */ |
| 57 | char *sqlite3_temp_directory = 0; |
| 58 | |
drh | c5499be | 2008-04-01 15:06:33 +0000 | [diff] [blame] | 59 | /* |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 60 | ** Initialize SQLite. |
| 61 | ** |
| 62 | ** This routine must be called to initialize the memory allocation, |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 63 | ** VFS, and mutex subsystems prior to doing any serious work with |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 64 | ** SQLite. But as long as you do not compile with SQLITE_OMIT_AUTOINIT |
| 65 | ** this routine will be called automatically by key routines such as |
| 66 | ** sqlite3_open(). |
| 67 | ** |
| 68 | ** This routine is a no-op except on its very first call for the process, |
| 69 | ** or for the first call after a call to sqlite3_shutdown. |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 70 | ** |
| 71 | ** The first thread to call this routine runs the initialization to |
| 72 | ** completion. If subsequent threads call this routine before the first |
| 73 | ** thread has finished the initialization process, then the subsequent |
| 74 | ** threads must block until the first thread finishes with the initialization. |
| 75 | ** |
| 76 | ** The first thread might call this routine recursively. Recursive |
| 77 | ** calls to this routine should not block, of course. Otherwise the |
| 78 | ** initialization process would never complete. |
| 79 | ** |
| 80 | ** Let X be the first thread to enter this routine. Let Y be some other |
| 81 | ** thread. Then while the initial invocation of this routine by X is |
| 82 | ** incomplete, it is required that: |
| 83 | ** |
| 84 | ** * Calls to this routine from Y must block until the outer-most |
| 85 | ** call by X completes. |
| 86 | ** |
| 87 | ** * Recursive calls to this routine from thread X return immediately |
| 88 | ** without blocking. |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 89 | */ |
| 90 | int sqlite3_initialize(void){ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 91 | sqlite3_mutex *pMaster; /* The main static mutex */ |
| 92 | int rc; /* Result code */ |
| 93 | |
| 94 | #ifdef SQLITE_OMIT_WSD |
danielk1977 | a8f83bf | 2008-09-02 16:22:28 +0000 | [diff] [blame] | 95 | rc = sqlite3_wsd_init(4096, 24); |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 96 | if( rc!=SQLITE_OK ){ |
| 97 | return rc; |
| 98 | } |
| 99 | #endif |
danielk1977 | 71bc31c | 2008-06-26 08:29:34 +0000 | [diff] [blame] | 100 | |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 101 | /* If SQLite is already completely initialized, then this call |
| 102 | ** to sqlite3_initialize() should be a no-op. But the initialization |
| 103 | ** must be complete. So isInit must not be set until the very end |
| 104 | ** of this routine. |
| 105 | */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 106 | if( sqlite3GlobalConfig.isInit ) return SQLITE_OK; |
danielk1977 | 71bc31c | 2008-06-26 08:29:34 +0000 | [diff] [blame] | 107 | |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 108 | /* Make sure the mutex subsystem is initialized. If unable to |
| 109 | ** initialize the mutex subsystem, return early with the error. |
| 110 | ** If the system is so sick that we are unable to allocate a mutex, |
| 111 | ** there is not much SQLite is going to be able to do. |
| 112 | ** |
| 113 | ** The mutex subsystem must take care of serializing its own |
| 114 | ** initialization. |
| 115 | */ |
danielk1977 | d025174 | 2008-06-18 18:57:42 +0000 | [diff] [blame] | 116 | rc = sqlite3MutexInit(); |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 117 | if( rc ) return rc; |
danielk1977 | 71bc31c | 2008-06-26 08:29:34 +0000 | [diff] [blame] | 118 | |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 119 | /* Initialize the malloc() system and the recursive pInitMutex mutex. |
| 120 | ** This operation is protected by the STATIC_MASTER mutex. Note that |
| 121 | ** MutexAlloc() is called for a static mutex prior to initializing the |
| 122 | ** malloc subsystem - this implies that the allocation of a static |
| 123 | ** mutex must not require support from the malloc subsystem. |
| 124 | */ |
| 125 | pMaster = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER); |
| 126 | sqlite3_mutex_enter(pMaster); |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 127 | if( !sqlite3GlobalConfig.isMallocInit ){ |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 128 | rc = sqlite3MallocInit(); |
| 129 | } |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 130 | if( rc==SQLITE_OK ){ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 131 | sqlite3GlobalConfig.isMallocInit = 1; |
| 132 | if( !sqlite3GlobalConfig.pInitMutex ){ |
| 133 | sqlite3GlobalConfig.pInitMutex = sqlite3MutexAlloc(SQLITE_MUTEX_RECURSIVE); |
| 134 | if( sqlite3GlobalConfig.bCoreMutex && !sqlite3GlobalConfig.pInitMutex ){ |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 135 | rc = SQLITE_NOMEM; |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 136 | } |
| 137 | } |
danielk1977 | 77eb5bb | 2008-09-22 17:22:19 +0000 | [diff] [blame] | 138 | } |
| 139 | if( rc==SQLITE_OK ){ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 140 | sqlite3GlobalConfig.nRefInitMutex++; |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 141 | } |
| 142 | sqlite3_mutex_leave(pMaster); |
danielk1977 | 71bc31c | 2008-06-26 08:29:34 +0000 | [diff] [blame] | 143 | |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 144 | /* If unable to initialize the malloc subsystem, then return early. |
| 145 | ** There is little hope of getting SQLite to run if the malloc |
| 146 | ** subsystem cannot be initialized. |
| 147 | */ |
| 148 | if( rc!=SQLITE_OK ){ |
| 149 | return rc; |
| 150 | } |
| 151 | |
| 152 | /* Do the rest of the initialization under the recursive mutex so |
| 153 | ** that we will be able to handle recursive calls into |
| 154 | ** sqlite3_initialize(). The recursive calls normally come through |
| 155 | ** sqlite3_os_init() when it invokes sqlite3_vfs_register(), but other |
| 156 | ** recursive calls might also be possible. |
| 157 | */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 158 | sqlite3_mutex_enter(sqlite3GlobalConfig.pInitMutex); |
danielk1977 | 502b4e0 | 2008-09-02 14:07:24 +0000 | [diff] [blame] | 159 | if( sqlite3GlobalConfig.isInit==0 && sqlite3GlobalConfig.inProgress==0 ){ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 160 | FuncDefHash *pHash = &GLOBAL(FuncDefHash, sqlite3GlobalFunctions); |
danielk1977 | 502b4e0 | 2008-09-02 14:07:24 +0000 | [diff] [blame] | 161 | sqlite3GlobalConfig.inProgress = 1; |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 162 | memset(pHash, 0, sizeof(sqlite3GlobalFunctions)); |
drh | 70a8ca3 | 2008-08-21 18:49:27 +0000 | [diff] [blame] | 163 | sqlite3RegisterGlobalFunctions(); |
danielk1977 | 71bc31c | 2008-06-26 08:29:34 +0000 | [diff] [blame] | 164 | rc = sqlite3_os_init(); |
danielk1977 | 8c0a791 | 2008-08-20 14:49:23 +0000 | [diff] [blame] | 165 | if( rc==SQLITE_OK ){ |
| 166 | rc = sqlite3PcacheInitialize(); |
danielk1977 | 5b77529 | 2008-09-02 09:38:06 +0000 | [diff] [blame] | 167 | sqlite3PCacheBufferSetup( sqlite3GlobalConfig.pPage, |
| 168 | sqlite3GlobalConfig.szPage, sqlite3GlobalConfig.nPage); |
danielk1977 | 8c0a791 | 2008-08-20 14:49:23 +0000 | [diff] [blame] | 169 | } |
danielk1977 | 502b4e0 | 2008-09-02 14:07:24 +0000 | [diff] [blame] | 170 | sqlite3GlobalConfig.inProgress = 0; |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 171 | sqlite3GlobalConfig.isInit = (rc==SQLITE_OK ? 1 : 0); |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 172 | } |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 173 | sqlite3_mutex_leave(sqlite3GlobalConfig.pInitMutex); |
shane | dfb7b37 | 2008-07-22 05:13:30 +0000 | [diff] [blame] | 174 | |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 175 | /* Go back under the static mutex and clean up the recursive |
| 176 | ** mutex to prevent a resource leak. |
| 177 | */ |
| 178 | sqlite3_mutex_enter(pMaster); |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 179 | sqlite3GlobalConfig.nRefInitMutex--; |
| 180 | if( sqlite3GlobalConfig.nRefInitMutex<=0 ){ |
| 181 | assert( sqlite3GlobalConfig.nRefInitMutex==0 ); |
| 182 | sqlite3_mutex_free(sqlite3GlobalConfig.pInitMutex); |
| 183 | sqlite3GlobalConfig.pInitMutex = 0; |
drh | 93ed56d | 2008-08-12 15:21:11 +0000 | [diff] [blame] | 184 | } |
| 185 | sqlite3_mutex_leave(pMaster); |
| 186 | |
| 187 | /* The following is just a sanity check to make sure SQLite has |
| 188 | ** been compiled correctly. It is important to run this code, but |
| 189 | ** we don't want to run it too often and soak up CPU cycles for no |
| 190 | ** reason. So we run it once during initialization. |
| 191 | */ |
shane | dfb7b37 | 2008-07-22 05:13:30 +0000 | [diff] [blame] | 192 | #ifndef NDEBUG |
| 193 | /* This section of code's only "output" is via assert() statements. */ |
| 194 | if ( rc==SQLITE_OK ){ |
| 195 | u64 x = (((u64)1)<<63)-1; |
| 196 | double y; |
| 197 | assert(sizeof(x)==8); |
| 198 | assert(sizeof(x)==sizeof(y)); |
| 199 | memcpy(&y, &x, 8); |
| 200 | assert( sqlite3IsNaN(y) ); |
| 201 | } |
| 202 | #endif |
| 203 | |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 204 | return rc; |
| 205 | } |
| 206 | |
| 207 | /* |
| 208 | ** Undo the effects of sqlite3_initialize(). Must not be called while |
| 209 | ** there are outstanding database connections or memory allocations or |
| 210 | ** while any part of SQLite is otherwise in use in any thread. This |
| 211 | ** routine is not threadsafe. Not by a long shot. |
| 212 | */ |
| 213 | int sqlite3_shutdown(void){ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 214 | sqlite3GlobalConfig.isMallocInit = 0; |
danielk1977 | 8c0a791 | 2008-08-20 14:49:23 +0000 | [diff] [blame] | 215 | sqlite3PcacheShutdown(); |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 216 | if( sqlite3GlobalConfig.isInit ){ |
danielk1977 | fb43727 | 2008-07-08 12:02:35 +0000 | [diff] [blame] | 217 | sqlite3_os_end(); |
| 218 | } |
drh | 1b67f3c | 2008-10-10 17:41:28 +0000 | [diff] [blame] | 219 | sqlite3MallocEnd(); |
drh | 1b67f3c | 2008-10-10 17:41:28 +0000 | [diff] [blame] | 220 | sqlite3MutexEnd(); |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 221 | sqlite3GlobalConfig.isInit = 0; |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 222 | return SQLITE_OK; |
| 223 | } |
| 224 | |
| 225 | /* |
| 226 | ** This API allows applications to modify the global configuration of |
| 227 | ** the SQLite library at run-time. |
| 228 | ** |
| 229 | ** This routine should only be called when there are no outstanding |
| 230 | ** database connections or memory allocations. This routine is not |
| 231 | ** threadsafe. Failure to heed these warnings can lead to unpredictable |
| 232 | ** behavior. |
| 233 | */ |
| 234 | int sqlite3_config(int op, ...){ |
| 235 | va_list ap; |
| 236 | int rc = SQLITE_OK; |
| 237 | |
| 238 | /* sqlite3_config() shall return SQLITE_MISUSE if it is invoked while |
| 239 | ** the SQLite library is in use. */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 240 | if( sqlite3GlobalConfig.isInit ) return SQLITE_MISUSE; |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 241 | |
| 242 | va_start(ap, op); |
| 243 | switch( op ){ |
drh | 18472fa | 2008-10-07 15:25:48 +0000 | [diff] [blame] | 244 | |
| 245 | /* Mutex configuration options are only available in a threadsafe |
| 246 | ** compile. |
| 247 | */ |
| 248 | #if SQLITE_THREADSAFE |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 249 | case SQLITE_CONFIG_SINGLETHREAD: { |
| 250 | /* Disable all mutexing */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 251 | sqlite3GlobalConfig.bCoreMutex = 0; |
| 252 | sqlite3GlobalConfig.bFullMutex = 0; |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 253 | break; |
| 254 | } |
| 255 | case SQLITE_CONFIG_MULTITHREAD: { |
| 256 | /* Disable mutexing of database connections */ |
| 257 | /* Enable mutexing of core data structures */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 258 | sqlite3GlobalConfig.bCoreMutex = 1; |
| 259 | sqlite3GlobalConfig.bFullMutex = 0; |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 260 | break; |
| 261 | } |
| 262 | case SQLITE_CONFIG_SERIALIZED: { |
| 263 | /* Enable all mutexing */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 264 | sqlite3GlobalConfig.bCoreMutex = 1; |
| 265 | sqlite3GlobalConfig.bFullMutex = 1; |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 266 | break; |
| 267 | } |
drh | 18472fa | 2008-10-07 15:25:48 +0000 | [diff] [blame] | 268 | case SQLITE_CONFIG_MUTEX: { |
| 269 | /* Specify an alternative mutex implementation */ |
| 270 | sqlite3GlobalConfig.mutex = *va_arg(ap, sqlite3_mutex_methods*); |
| 271 | break; |
| 272 | } |
| 273 | case SQLITE_CONFIG_GETMUTEX: { |
| 274 | /* Retrieve the current mutex implementation */ |
| 275 | *va_arg(ap, sqlite3_mutex_methods*) = sqlite3GlobalConfig.mutex; |
| 276 | break; |
| 277 | } |
| 278 | #endif |
| 279 | |
| 280 | |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 281 | case SQLITE_CONFIG_MALLOC: { |
| 282 | /* Specify an alternative malloc implementation */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 283 | sqlite3GlobalConfig.m = *va_arg(ap, sqlite3_mem_methods*); |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 284 | break; |
| 285 | } |
drh | 3358979 | 2008-06-18 13:27:46 +0000 | [diff] [blame] | 286 | case SQLITE_CONFIG_GETMALLOC: { |
danielk1977 | 57e5ea9 | 2008-06-24 19:02:55 +0000 | [diff] [blame] | 287 | /* Retrieve the current malloc() implementation */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 288 | if( sqlite3GlobalConfig.m.xMalloc==0 ) sqlite3MemSetDefault(); |
| 289 | *va_arg(ap, sqlite3_mem_methods*) = sqlite3GlobalConfig.m; |
drh | 3358979 | 2008-06-18 13:27:46 +0000 | [diff] [blame] | 290 | break; |
| 291 | } |
drh | fec00ea | 2008-06-14 16:56:21 +0000 | [diff] [blame] | 292 | case SQLITE_CONFIG_MEMSTATUS: { |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 293 | /* Enable or disable the malloc status collection */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 294 | sqlite3GlobalConfig.bMemstat = va_arg(ap, int); |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 295 | break; |
| 296 | } |
drh | 3358979 | 2008-06-18 13:27:46 +0000 | [diff] [blame] | 297 | case SQLITE_CONFIG_SCRATCH: { |
| 298 | /* Designate a buffer for scratch memory space */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 299 | sqlite3GlobalConfig.pScratch = va_arg(ap, void*); |
| 300 | sqlite3GlobalConfig.szScratch = va_arg(ap, int); |
| 301 | sqlite3GlobalConfig.nScratch = va_arg(ap, int); |
drh | 3358979 | 2008-06-18 13:27:46 +0000 | [diff] [blame] | 302 | break; |
| 303 | } |
| 304 | case SQLITE_CONFIG_PAGECACHE: { |
| 305 | /* Designate a buffer for scratch memory space */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 306 | sqlite3GlobalConfig.pPage = va_arg(ap, void*); |
| 307 | sqlite3GlobalConfig.szPage = va_arg(ap, int); |
| 308 | sqlite3GlobalConfig.nPage = va_arg(ap, int); |
drh | 3358979 | 2008-06-18 13:27:46 +0000 | [diff] [blame] | 309 | break; |
| 310 | } |
danielk1977 | 5099be5 | 2008-06-27 13:27:03 +0000 | [diff] [blame] | 311 | |
drh | 5d41483 | 2008-07-15 14:47:18 +0000 | [diff] [blame] | 312 | #if defined(SQLITE_ENABLE_MEMSYS3) || defined(SQLITE_ENABLE_MEMSYS5) |
drh | 3358979 | 2008-06-18 13:27:46 +0000 | [diff] [blame] | 313 | case SQLITE_CONFIG_HEAP: { |
danielk1977 | 5099be5 | 2008-06-27 13:27:03 +0000 | [diff] [blame] | 314 | /* Designate a buffer for heap memory space */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 315 | sqlite3GlobalConfig.pHeap = va_arg(ap, void*); |
| 316 | sqlite3GlobalConfig.nHeap = va_arg(ap, int); |
| 317 | sqlite3GlobalConfig.mnReq = va_arg(ap, int); |
danielk1977 | 5099be5 | 2008-06-27 13:27:03 +0000 | [diff] [blame] | 318 | |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 319 | if( sqlite3GlobalConfig.pHeap==0 ){ |
drh | 8a42cbd | 2008-07-10 18:13:42 +0000 | [diff] [blame] | 320 | /* If the heap pointer is NULL, then restore the malloc implementation |
| 321 | ** back to NULL pointers too. This will cause the malloc to go |
| 322 | ** back to its default implementation when sqlite3_initialize() is |
| 323 | ** run. |
| 324 | */ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 325 | memset(&sqlite3GlobalConfig.m, 0, sizeof(sqlite3GlobalConfig.m)); |
drh | 8a42cbd | 2008-07-10 18:13:42 +0000 | [diff] [blame] | 326 | }else{ |
| 327 | /* The heap pointer is not NULL, then install one of the |
| 328 | ** mem5.c/mem3.c methods. If neither ENABLE_MEMSYS3 nor |
| 329 | ** ENABLE_MEMSYS5 is defined, return an error. |
| 330 | ** the default case and return an error. |
| 331 | */ |
danielk1977 | 5099be5 | 2008-06-27 13:27:03 +0000 | [diff] [blame] | 332 | #ifdef SQLITE_ENABLE_MEMSYS3 |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 333 | sqlite3GlobalConfig.m = *sqlite3MemGetMemsys3(); |
drh | 8a42cbd | 2008-07-10 18:13:42 +0000 | [diff] [blame] | 334 | #endif |
| 335 | #ifdef SQLITE_ENABLE_MEMSYS5 |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 336 | sqlite3GlobalConfig.m = *sqlite3MemGetMemsys5(); |
drh | 8a42cbd | 2008-07-10 18:13:42 +0000 | [diff] [blame] | 337 | #endif |
drh | 8a42cbd | 2008-07-10 18:13:42 +0000 | [diff] [blame] | 338 | } |
danielk1977 | 5099be5 | 2008-06-27 13:27:03 +0000 | [diff] [blame] | 339 | break; |
| 340 | } |
drh | 5d41483 | 2008-07-15 14:47:18 +0000 | [diff] [blame] | 341 | #endif |
danielk1977 | 5099be5 | 2008-06-27 13:27:03 +0000 | [diff] [blame] | 342 | |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 343 | case SQLITE_CONFIG_LOOKASIDE: { |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 344 | sqlite3GlobalConfig.szLookaside = va_arg(ap, int); |
| 345 | sqlite3GlobalConfig.nLookaside = va_arg(ap, int); |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 346 | break; |
| 347 | } |
| 348 | |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 349 | default: { |
| 350 | rc = SQLITE_ERROR; |
| 351 | break; |
| 352 | } |
| 353 | } |
| 354 | va_end(ap); |
| 355 | return rc; |
| 356 | } |
| 357 | |
| 358 | /* |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 359 | ** Set up the lookaside buffers for a database connection. |
| 360 | ** Return SQLITE_OK on success. |
| 361 | ** If lookaside is already active, return SQLITE_BUSY. |
drh | e9d1c72 | 2008-08-04 20:13:26 +0000 | [diff] [blame] | 362 | ** |
| 363 | ** The sz parameter is the number of bytes in each lookaside slot. |
| 364 | ** The cnt parameter is the number of slots. If pStart is NULL the |
| 365 | ** space for the lookaside memory is obtained from sqlite3_malloc(). |
| 366 | ** If pStart is not NULL then it is sz*cnt bytes of memory to use for |
| 367 | ** the lookaside memory. |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 368 | */ |
drh | e9d1c72 | 2008-08-04 20:13:26 +0000 | [diff] [blame] | 369 | static int setupLookaside(sqlite3 *db, void *pBuf, int sz, int cnt){ |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 370 | void *pStart; |
| 371 | if( db->lookaside.nOut ){ |
| 372 | return SQLITE_BUSY; |
| 373 | } |
| 374 | if( sz<0 ) sz = 0; |
| 375 | if( cnt<0 ) cnt = 0; |
drh | e9d1c72 | 2008-08-04 20:13:26 +0000 | [diff] [blame] | 376 | if( pBuf==0 ){ |
drh | 6382033 | 2008-08-08 14:33:12 +0000 | [diff] [blame] | 377 | sz = (sz + 7)&~7; |
drh | e9d1c72 | 2008-08-04 20:13:26 +0000 | [diff] [blame] | 378 | sqlite3BeginBenignMalloc(); |
| 379 | pStart = sqlite3Malloc( sz*cnt ); |
| 380 | sqlite3EndBenignMalloc(); |
| 381 | }else{ |
drh | 6382033 | 2008-08-08 14:33:12 +0000 | [diff] [blame] | 382 | sz = sz&~7; |
drh | e9d1c72 | 2008-08-04 20:13:26 +0000 | [diff] [blame] | 383 | pStart = pBuf; |
| 384 | } |
| 385 | if( db->lookaside.bMalloced ){ |
| 386 | sqlite3_free(db->lookaside.pStart); |
| 387 | } |
drh | 4cfb22f | 2008-08-01 18:47:01 +0000 | [diff] [blame] | 388 | db->lookaside.pStart = pStart; |
| 389 | db->lookaside.pFree = 0; |
| 390 | db->lookaside.sz = sz; |
drh | e9d1c72 | 2008-08-04 20:13:26 +0000 | [diff] [blame] | 391 | db->lookaside.bMalloced = pBuf==0; |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 392 | if( pStart ){ |
| 393 | int i; |
| 394 | LookasideSlot *p; |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 395 | p = (LookasideSlot*)pStart; |
| 396 | for(i=cnt-1; i>=0; i--){ |
| 397 | p->pNext = db->lookaside.pFree; |
| 398 | db->lookaside.pFree = p; |
| 399 | p = (LookasideSlot*)&((u8*)p)[sz]; |
| 400 | } |
| 401 | db->lookaside.pEnd = p; |
| 402 | db->lookaside.bEnabled = 1; |
drh | 4cfb22f | 2008-08-01 18:47:01 +0000 | [diff] [blame] | 403 | }else{ |
| 404 | db->lookaside.pEnd = 0; |
| 405 | db->lookaside.bEnabled = 0; |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 406 | } |
| 407 | return SQLITE_OK; |
| 408 | } |
| 409 | |
| 410 | /* |
drh | 4413d0e | 2008-11-04 13:46:27 +0000 | [diff] [blame] | 411 | ** Return the mutex associated with a database connection. |
| 412 | */ |
| 413 | sqlite3_mutex *sqlite3_db_mutex(sqlite3 *db){ |
| 414 | return db->mutex; |
| 415 | } |
| 416 | |
| 417 | /* |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 418 | ** Configuration settings for an individual database connection |
| 419 | */ |
| 420 | int sqlite3_db_config(sqlite3 *db, int op, ...){ |
| 421 | va_list ap; |
drh | 6480aad | 2008-08-01 16:31:14 +0000 | [diff] [blame] | 422 | int rc; |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 423 | va_start(ap, op); |
| 424 | switch( op ){ |
drh | e9d1c72 | 2008-08-04 20:13:26 +0000 | [diff] [blame] | 425 | case SQLITE_DBCONFIG_LOOKASIDE: { |
| 426 | void *pBuf = va_arg(ap, void*); |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 427 | int sz = va_arg(ap, int); |
| 428 | int cnt = va_arg(ap, int); |
drh | e9d1c72 | 2008-08-04 20:13:26 +0000 | [diff] [blame] | 429 | rc = setupLookaside(db, pBuf, sz, cnt); |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 430 | break; |
| 431 | } |
drh | 6480aad | 2008-08-01 16:31:14 +0000 | [diff] [blame] | 432 | default: { |
| 433 | rc = SQLITE_ERROR; |
| 434 | break; |
| 435 | } |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 436 | } |
| 437 | va_end(ap); |
| 438 | return rc; |
| 439 | } |
| 440 | |
| 441 | /* |
drh | c5499be | 2008-04-01 15:06:33 +0000 | [diff] [blame] | 442 | ** Routine needed to support the testcase() macro. |
| 443 | */ |
| 444 | #ifdef SQLITE_COVERAGE_TEST |
| 445 | void sqlite3Coverage(int x){ |
| 446 | static int dummy = 0; |
| 447 | dummy += x; |
| 448 | } |
| 449 | #endif |
| 450 | |
drh | a16313e | 2007-03-30 11:29:32 +0000 | [diff] [blame] | 451 | |
| 452 | /* |
drh | 9b5adfa | 2008-01-20 23:19:56 +0000 | [diff] [blame] | 453 | ** Return true if the buffer z[0..n-1] contains all spaces. |
| 454 | */ |
| 455 | static int allSpaces(const char *z, int n){ |
drh | 5f3a367 | 2008-04-15 04:02:40 +0000 | [diff] [blame] | 456 | while( n>0 && z[n-1]==' ' ){ n--; } |
drh | 9b5adfa | 2008-01-20 23:19:56 +0000 | [diff] [blame] | 457 | return n==0; |
| 458 | } |
| 459 | |
| 460 | /* |
drh | d3d39e9 | 2004-05-20 22:16:29 +0000 | [diff] [blame] | 461 | ** This is the default collating function named "BINARY" which is always |
| 462 | ** available. |
drh | 9b5adfa | 2008-01-20 23:19:56 +0000 | [diff] [blame] | 463 | ** |
| 464 | ** If the padFlag argument is not NULL then space padding at the end |
| 465 | ** of strings is ignored. This implements the RTRIM collation. |
drh | d3d39e9 | 2004-05-20 22:16:29 +0000 | [diff] [blame] | 466 | */ |
danielk1977 | 2c33654 | 2005-01-13 02:14:23 +0000 | [diff] [blame] | 467 | static int binCollFunc( |
drh | 9b5adfa | 2008-01-20 23:19:56 +0000 | [diff] [blame] | 468 | void *padFlag, |
drh | d3d39e9 | 2004-05-20 22:16:29 +0000 | [diff] [blame] | 469 | int nKey1, const void *pKey1, |
| 470 | int nKey2, const void *pKey2 |
| 471 | ){ |
| 472 | int rc, n; |
| 473 | n = nKey1<nKey2 ? nKey1 : nKey2; |
| 474 | rc = memcmp(pKey1, pKey2, n); |
| 475 | if( rc==0 ){ |
drh | 9b5adfa | 2008-01-20 23:19:56 +0000 | [diff] [blame] | 476 | if( padFlag |
| 477 | && allSpaces(((char*)pKey1)+n, nKey1-n) |
| 478 | && allSpaces(((char*)pKey2)+n, nKey2-n) |
| 479 | ){ |
| 480 | /* Leave rc unchanged at 0 */ |
| 481 | }else{ |
| 482 | rc = nKey1 - nKey2; |
| 483 | } |
drh | d3d39e9 | 2004-05-20 22:16:29 +0000 | [diff] [blame] | 484 | } |
| 485 | return rc; |
| 486 | } |
| 487 | |
| 488 | /* |
danielk1977 | dc1bdc4 | 2004-06-11 10:51:27 +0000 | [diff] [blame] | 489 | ** Another built-in collating sequence: NOCASE. |
| 490 | ** |
| 491 | ** This collating sequence is intended to be used for "case independant |
| 492 | ** comparison". SQLite's knowledge of upper and lower case equivalents |
| 493 | ** extends only to the 26 characters used in the English language. |
| 494 | ** |
| 495 | ** At the moment there is only a UTF-8 implementation. |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 496 | */ |
| 497 | static int nocaseCollatingFunc( |
| 498 | void *NotUsed, |
| 499 | int nKey1, const void *pKey1, |
| 500 | int nKey2, const void *pKey2 |
| 501 | ){ |
| 502 | int r = sqlite3StrNICmp( |
drh | 208f80a | 2004-08-29 20:08:58 +0000 | [diff] [blame] | 503 | (const char *)pKey1, (const char *)pKey2, (nKey1<nKey2)?nKey1:nKey2); |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 504 | if( 0==r ){ |
| 505 | r = nKey1-nKey2; |
| 506 | } |
| 507 | return r; |
| 508 | } |
| 509 | |
| 510 | /* |
drh | af9ff33 | 2002-01-16 21:00:27 +0000 | [diff] [blame] | 511 | ** Return the ROWID of the most recent insert |
| 512 | */ |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 513 | sqlite_int64 sqlite3_last_insert_rowid(sqlite3 *db){ |
drh | af9ff33 | 2002-01-16 21:00:27 +0000 | [diff] [blame] | 514 | return db->lastRowid; |
| 515 | } |
| 516 | |
| 517 | /* |
danielk1977 | 24b03fd | 2004-05-10 10:34:34 +0000 | [diff] [blame] | 518 | ** Return the number of changes in the most recent call to sqlite3_exec(). |
drh | c8d30ac | 2002-04-12 10:08:59 +0000 | [diff] [blame] | 519 | */ |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 520 | int sqlite3_changes(sqlite3 *db){ |
drh | c8d30ac | 2002-04-12 10:08:59 +0000 | [diff] [blame] | 521 | return db->nChange; |
| 522 | } |
| 523 | |
rdc | f146a77 | 2004-02-25 22:51:06 +0000 | [diff] [blame] | 524 | /* |
danielk1977 | b28af71 | 2004-06-21 06:50:26 +0000 | [diff] [blame] | 525 | ** Return the number of changes since the database handle was opened. |
rdc | f146a77 | 2004-02-25 22:51:06 +0000 | [diff] [blame] | 526 | */ |
danielk1977 | b28af71 | 2004-06-21 06:50:26 +0000 | [diff] [blame] | 527 | int sqlite3_total_changes(sqlite3 *db){ |
| 528 | return db->nTotalChange; |
rdc | b0c374f | 2004-02-20 22:53:38 +0000 | [diff] [blame] | 529 | } |
| 530 | |
drh | c8d30ac | 2002-04-12 10:08:59 +0000 | [diff] [blame] | 531 | /* |
drh | 50e5dad | 2001-09-15 00:57:28 +0000 | [diff] [blame] | 532 | ** Close an existing SQLite database |
| 533 | */ |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 534 | int sqlite3_close(sqlite3 *db){ |
drh | 8e0a2f9 | 2002-02-23 23:45:45 +0000 | [diff] [blame] | 535 | HashElem *i; |
drh | 001bbcb | 2003-03-19 03:14:00 +0000 | [diff] [blame] | 536 | int j; |
danielk1977 | 5c4c778 | 2004-06-16 10:39:23 +0000 | [diff] [blame] | 537 | |
| 538 | if( !db ){ |
danielk1977 | 96d81f9 | 2004-06-19 03:33:57 +0000 | [diff] [blame] | 539 | return SQLITE_OK; |
danielk1977 | 5c4c778 | 2004-06-16 10:39:23 +0000 | [diff] [blame] | 540 | } |
drh | 7e8b848 | 2008-01-23 03:03:05 +0000 | [diff] [blame] | 541 | if( !sqlite3SafetyCheckSickOrOk(db) ){ |
danielk1977 | e35ee19 | 2004-06-26 09:50:11 +0000 | [diff] [blame] | 542 | return SQLITE_MISUSE; |
| 543 | } |
drh | 605264d | 2007-08-21 15:13:19 +0000 | [diff] [blame] | 544 | sqlite3_mutex_enter(db->mutex); |
danielk1977 | e35ee19 | 2004-06-26 09:50:11 +0000 | [diff] [blame] | 545 | |
danielk1977 | 1f723bd | 2005-05-26 12:37:29 +0000 | [diff] [blame] | 546 | #ifdef SQLITE_SSE |
drh | 3752785 | 2006-03-16 16:19:56 +0000 | [diff] [blame] | 547 | { |
| 548 | extern void sqlite3SseCleanup(sqlite3*); |
| 549 | sqlite3SseCleanup(db); |
| 550 | } |
danielk1977 | 1f723bd | 2005-05-26 12:37:29 +0000 | [diff] [blame] | 551 | #endif |
| 552 | |
drh | ffc13f6 | 2006-07-30 20:50:44 +0000 | [diff] [blame] | 553 | sqlite3ResetInternalSchema(db, 0); |
danielk1977 | a04a34f | 2007-04-16 15:06:25 +0000 | [diff] [blame] | 554 | |
danielk1977 | 0125683 | 2007-04-18 14:24:32 +0000 | [diff] [blame] | 555 | /* If a transaction is open, the ResetInternalSchema() call above |
| 556 | ** will not have called the xDisconnect() method on any virtual |
| 557 | ** tables in the db->aVTrans[] array. The following sqlite3VtabRollback() |
| 558 | ** call will do so. We need to do this before the check for active |
| 559 | ** SQL statements below, as the v-table implementation may be storing |
| 560 | ** some prepared statements internally. |
| 561 | */ |
| 562 | sqlite3VtabRollback(db); |
| 563 | |
danielk1977 | a04a34f | 2007-04-16 15:06:25 +0000 | [diff] [blame] | 564 | /* If there are any outstanding VMs, return SQLITE_BUSY. */ |
danielk1977 | 96d81f9 | 2004-06-19 03:33:57 +0000 | [diff] [blame] | 565 | if( db->pVdbe ){ |
| 566 | sqlite3Error(db, SQLITE_BUSY, |
| 567 | "Unable to close due to unfinalised statements"); |
drh | 2764170 | 2007-08-22 02:56:42 +0000 | [diff] [blame] | 568 | sqlite3_mutex_leave(db->mutex); |
danielk1977 | 96d81f9 | 2004-06-19 03:33:57 +0000 | [diff] [blame] | 569 | return SQLITE_BUSY; |
| 570 | } |
drh | 7e8b848 | 2008-01-23 03:03:05 +0000 | [diff] [blame] | 571 | assert( sqlite3SafetyCheckSickOrOk(db) ); |
danielk1977 | e004840 | 2004-06-15 16:51:01 +0000 | [diff] [blame] | 572 | |
drh | 001bbcb | 2003-03-19 03:14:00 +0000 | [diff] [blame] | 573 | for(j=0; j<db->nDb; j++){ |
drh | 4d189ca | 2004-02-12 18:46:38 +0000 | [diff] [blame] | 574 | struct Db *pDb = &db->aDb[j]; |
| 575 | if( pDb->pBt ){ |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 576 | sqlite3BtreeClose(pDb->pBt); |
drh | 4d189ca | 2004-02-12 18:46:38 +0000 | [diff] [blame] | 577 | pDb->pBt = 0; |
danielk1977 | 311019b | 2006-01-10 07:14:23 +0000 | [diff] [blame] | 578 | if( j!=1 ){ |
| 579 | pDb->pSchema = 0; |
| 580 | } |
drh | 113088e | 2003-03-20 01:16:58 +0000 | [diff] [blame] | 581 | } |
drh | f57b339 | 2001-10-08 13:22:32 +0000 | [diff] [blame] | 582 | } |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 583 | sqlite3ResetInternalSchema(db, 0); |
drh | 1c2d841 | 2003-03-31 00:30:47 +0000 | [diff] [blame] | 584 | assert( db->nDb<=2 ); |
| 585 | assert( db->aDb==db->aDbStatic ); |
drh | 70a8ca3 | 2008-08-21 18:49:27 +0000 | [diff] [blame] | 586 | for(j=0; j<ArraySize(db->aFunc.a); j++){ |
| 587 | FuncDef *pNext, *pHash, *p; |
| 588 | for(p=db->aFunc.a[j]; p; p=pHash){ |
| 589 | pHash = p->pHash; |
| 590 | while( p ){ |
| 591 | pNext = p->pNext; |
| 592 | sqlite3DbFree(db, p); |
| 593 | p = pNext; |
| 594 | } |
drh | 8e0a2f9 | 2002-02-23 23:45:45 +0000 | [diff] [blame] | 595 | } |
| 596 | } |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 597 | for(i=sqliteHashFirst(&db->aCollSeq); i; i=sqliteHashNext(i)){ |
danielk1977 | 466be56 | 2004-06-10 02:16:01 +0000 | [diff] [blame] | 598 | CollSeq *pColl = (CollSeq *)sqliteHashData(i); |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 599 | /* Invoke any destructors registered for collation sequence user data. */ |
| 600 | for(j=0; j<3; j++){ |
| 601 | if( pColl[j].xDel ){ |
| 602 | pColl[j].xDel(pColl[j].pUser); |
| 603 | } |
| 604 | } |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 605 | sqlite3DbFree(db, pColl); |
danielk1977 | 466be56 | 2004-06-10 02:16:01 +0000 | [diff] [blame] | 606 | } |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 607 | sqlite3HashClear(&db->aCollSeq); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 608 | #ifndef SQLITE_OMIT_VIRTUALTABLE |
danielk1977 | d1ab1ba | 2006-06-15 04:28:13 +0000 | [diff] [blame] | 609 | for(i=sqliteHashFirst(&db->aModule); i; i=sqliteHashNext(i)){ |
| 610 | Module *pMod = (Module *)sqliteHashData(i); |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 611 | if( pMod->xDestroy ){ |
| 612 | pMod->xDestroy(pMod->pAux); |
| 613 | } |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 614 | sqlite3DbFree(db, pMod); |
danielk1977 | d1ab1ba | 2006-06-15 04:28:13 +0000 | [diff] [blame] | 615 | } |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 616 | sqlite3HashClear(&db->aModule); |
| 617 | #endif |
danielk1977 | 466be56 | 2004-06-10 02:16:01 +0000 | [diff] [blame] | 618 | |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 619 | sqlite3Error(db, SQLITE_OK, 0); /* Deallocates any cached error strings. */ |
danielk1977 | bfd6cce | 2004-06-18 04:24:54 +0000 | [diff] [blame] | 620 | if( db->pErr ){ |
| 621 | sqlite3ValueFree(db->pErr); |
| 622 | } |
drh | f1952c5 | 2006-06-08 15:48:00 +0000 | [diff] [blame] | 623 | sqlite3CloseExtensions(db); |
danielk1977 | 96d81f9 | 2004-06-19 03:33:57 +0000 | [diff] [blame] | 624 | |
| 625 | db->magic = SQLITE_MAGIC_ERROR; |
danielk1977 | 311019b | 2006-01-10 07:14:23 +0000 | [diff] [blame] | 626 | |
| 627 | /* The temp-database schema is allocated differently from the other schema |
| 628 | ** objects (using sqliteMalloc() directly, instead of sqlite3BtreeSchema()). |
| 629 | ** So it needs to be freed here. Todo: Why not roll the temp schema into |
| 630 | ** the same sqliteMalloc() as the one that allocates the database |
| 631 | ** structure? |
| 632 | */ |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 633 | sqlite3DbFree(db, db->aDb[1].pSchema); |
drh | 605264d | 2007-08-21 15:13:19 +0000 | [diff] [blame] | 634 | sqlite3_mutex_leave(db->mutex); |
drh | 7e8b848 | 2008-01-23 03:03:05 +0000 | [diff] [blame] | 635 | db->magic = SQLITE_MAGIC_CLOSED; |
drh | 605264d | 2007-08-21 15:13:19 +0000 | [diff] [blame] | 636 | sqlite3_mutex_free(db->mutex); |
drh | 4150ebf | 2008-10-11 15:38:29 +0000 | [diff] [blame] | 637 | assert( db->lookaside.nOut==0 ); /* Fails on a lookaside memory leak */ |
drh | e9d1c72 | 2008-08-04 20:13:26 +0000 | [diff] [blame] | 638 | if( db->lookaside.bMalloced ){ |
| 639 | sqlite3_free(db->lookaside.pStart); |
| 640 | } |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 641 | sqlite3_free(db); |
danielk1977 | 96d81f9 | 2004-06-19 03:33:57 +0000 | [diff] [blame] | 642 | return SQLITE_OK; |
drh | 7589723 | 2000-05-29 14:26:00 +0000 | [diff] [blame] | 643 | } |
| 644 | |
| 645 | /* |
drh | 001bbcb | 2003-03-19 03:14:00 +0000 | [diff] [blame] | 646 | ** Rollback all database files. |
| 647 | */ |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 648 | void sqlite3RollbackAll(sqlite3 *db){ |
drh | 001bbcb | 2003-03-19 03:14:00 +0000 | [diff] [blame] | 649 | int i; |
danielk1977 | f3f06bb | 2005-12-16 15:24:28 +0000 | [diff] [blame] | 650 | int inTrans = 0; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 651 | assert( sqlite3_mutex_held(db->mutex) ); |
danielk1977 | 2d1d86f | 2008-06-20 14:59:51 +0000 | [diff] [blame] | 652 | sqlite3BeginBenignMalloc(); |
drh | 001bbcb | 2003-03-19 03:14:00 +0000 | [diff] [blame] | 653 | for(i=0; i<db->nDb; i++){ |
| 654 | if( db->aDb[i].pBt ){ |
danielk1977 | f3f06bb | 2005-12-16 15:24:28 +0000 | [diff] [blame] | 655 | if( sqlite3BtreeIsInTrans(db->aDb[i].pBt) ){ |
| 656 | inTrans = 1; |
| 657 | } |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 658 | sqlite3BtreeRollback(db->aDb[i].pBt); |
drh | 001bbcb | 2003-03-19 03:14:00 +0000 | [diff] [blame] | 659 | db->aDb[i].inTrans = 0; |
| 660 | } |
| 661 | } |
danielk1977 | a298e90 | 2006-06-22 09:53:48 +0000 | [diff] [blame] | 662 | sqlite3VtabRollback(db); |
danielk1977 | 2d1d86f | 2008-06-20 14:59:51 +0000 | [diff] [blame] | 663 | sqlite3EndBenignMalloc(); |
danielk1977 | ae72d98 | 2007-10-03 08:46:44 +0000 | [diff] [blame] | 664 | |
danielk1977 | 71fd80b | 2005-12-16 06:54:01 +0000 | [diff] [blame] | 665 | if( db->flags&SQLITE_InternChanges ){ |
danielk1977 | ea4d9e2 | 2007-08-13 15:28:33 +0000 | [diff] [blame] | 666 | sqlite3ExpirePreparedStatements(db); |
danielk1977 | 71fd80b | 2005-12-16 06:54:01 +0000 | [diff] [blame] | 667 | sqlite3ResetInternalSchema(db, 0); |
| 668 | } |
| 669 | |
| 670 | /* If one has been configured, invoke the rollback-hook callback */ |
danielk1977 | f3f06bb | 2005-12-16 15:24:28 +0000 | [diff] [blame] | 671 | if( db->xRollbackCallback && (inTrans || !db->autoCommit) ){ |
danielk1977 | 71fd80b | 2005-12-16 06:54:01 +0000 | [diff] [blame] | 672 | db->xRollbackCallback(db->pRollbackArg); |
| 673 | } |
drh | 001bbcb | 2003-03-19 03:14:00 +0000 | [diff] [blame] | 674 | } |
| 675 | |
| 676 | /* |
drh | c22bd47 | 2002-05-10 13:14:07 +0000 | [diff] [blame] | 677 | ** Return a static string that describes the kind of error specified in the |
| 678 | ** argument. |
drh | 247be43 | 2002-05-10 05:44:55 +0000 | [diff] [blame] | 679 | */ |
danielk1977 | f20b21c | 2004-05-31 23:56:42 +0000 | [diff] [blame] | 680 | const char *sqlite3ErrStr(int rc){ |
drh | c22bd47 | 2002-05-10 13:14:07 +0000 | [diff] [blame] | 681 | const char *z; |
drh | 4ac285a | 2006-09-15 07:28:50 +0000 | [diff] [blame] | 682 | switch( rc & 0xff ){ |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 683 | case SQLITE_ROW: |
| 684 | case SQLITE_DONE: |
drh | c22bd47 | 2002-05-10 13:14:07 +0000 | [diff] [blame] | 685 | case SQLITE_OK: z = "not an error"; break; |
| 686 | case SQLITE_ERROR: z = "SQL logic error or missing database"; break; |
drh | c22bd47 | 2002-05-10 13:14:07 +0000 | [diff] [blame] | 687 | case SQLITE_PERM: z = "access permission denied"; break; |
| 688 | case SQLITE_ABORT: z = "callback requested query abort"; break; |
| 689 | case SQLITE_BUSY: z = "database is locked"; break; |
| 690 | case SQLITE_LOCKED: z = "database table is locked"; break; |
| 691 | case SQLITE_NOMEM: z = "out of memory"; break; |
| 692 | case SQLITE_READONLY: z = "attempt to write a readonly database"; break; |
| 693 | case SQLITE_INTERRUPT: z = "interrupted"; break; |
| 694 | case SQLITE_IOERR: z = "disk I/O error"; break; |
| 695 | case SQLITE_CORRUPT: z = "database disk image is malformed"; break; |
drh | 2db0bbc | 2005-08-11 02:10:18 +0000 | [diff] [blame] | 696 | case SQLITE_FULL: z = "database or disk is full"; break; |
drh | c22bd47 | 2002-05-10 13:14:07 +0000 | [diff] [blame] | 697 | case SQLITE_CANTOPEN: z = "unable to open database file"; break; |
drh | c22bd47 | 2002-05-10 13:14:07 +0000 | [diff] [blame] | 698 | case SQLITE_EMPTY: z = "table contains no data"; break; |
| 699 | case SQLITE_SCHEMA: z = "database schema has changed"; break; |
drh | 023ae03 | 2007-05-08 12:12:16 +0000 | [diff] [blame] | 700 | case SQLITE_TOOBIG: z = "String or BLOB exceeded size limit"; break; |
drh | c22bd47 | 2002-05-10 13:14:07 +0000 | [diff] [blame] | 701 | case SQLITE_CONSTRAINT: z = "constraint failed"; break; |
| 702 | case SQLITE_MISMATCH: z = "datatype mismatch"; break; |
| 703 | case SQLITE_MISUSE: z = "library routine called out of sequence";break; |
drh | 6559404 | 2008-05-05 16:56:34 +0000 | [diff] [blame] | 704 | case SQLITE_NOLFS: z = "large file support is disabled"; break; |
drh | ed6c867 | 2003-01-12 18:02:16 +0000 | [diff] [blame] | 705 | case SQLITE_AUTH: z = "authorization denied"; break; |
jplyon | 892f671 | 2003-06-12 08:59:00 +0000 | [diff] [blame] | 706 | case SQLITE_FORMAT: z = "auxiliary database format error"; break; |
drh | b08153d | 2004-11-20 20:18:55 +0000 | [diff] [blame] | 707 | case SQLITE_RANGE: z = "bind or column index out of range"; break; |
drh | c602f9a | 2004-02-12 19:01:04 +0000 | [diff] [blame] | 708 | case SQLITE_NOTADB: z = "file is encrypted or is not a database";break; |
drh | c22bd47 | 2002-05-10 13:14:07 +0000 | [diff] [blame] | 709 | default: z = "unknown error"; break; |
drh | 247be43 | 2002-05-10 05:44:55 +0000 | [diff] [blame] | 710 | } |
drh | c22bd47 | 2002-05-10 13:14:07 +0000 | [diff] [blame] | 711 | return z; |
drh | 247be43 | 2002-05-10 05:44:55 +0000 | [diff] [blame] | 712 | } |
| 713 | |
| 714 | /* |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 715 | ** This routine implements a busy callback that sleeps and tries |
| 716 | ** again until a timeout value is reached. The timeout value is |
| 717 | ** an integer number of milliseconds passed in as the first |
| 718 | ** argument. |
| 719 | */ |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 720 | static int sqliteDefaultBusyCallback( |
drh | 97903fe | 2005-05-24 20:19:57 +0000 | [diff] [blame] | 721 | void *ptr, /* Database connection */ |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 722 | int count /* Number of times table has been busy */ |
| 723 | ){ |
danielk1977 | 29bafea | 2008-06-26 10:41:19 +0000 | [diff] [blame] | 724 | #if SQLITE_OS_WIN || (defined(HAVE_USLEEP) && HAVE_USLEEP) |
drh | ee570fa | 2005-04-28 12:06:05 +0000 | [diff] [blame] | 725 | static const u8 delays[] = |
| 726 | { 1, 2, 5, 10, 15, 20, 25, 25, 25, 50, 50, 100 }; |
| 727 | static const u8 totals[] = |
| 728 | { 0, 1, 3, 8, 18, 33, 53, 78, 103, 128, 178, 228 }; |
drh | d1bec47 | 2004-01-15 13:29:31 +0000 | [diff] [blame] | 729 | # define NDELAY (sizeof(delays)/sizeof(delays[0])) |
danielk1977 | b4b4741 | 2007-08-17 15:53:36 +0000 | [diff] [blame] | 730 | sqlite3 *db = (sqlite3 *)ptr; |
| 731 | int timeout = db->busyTimeout; |
drh | 97903fe | 2005-05-24 20:19:57 +0000 | [diff] [blame] | 732 | int delay, prior; |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 733 | |
drh | ee570fa | 2005-04-28 12:06:05 +0000 | [diff] [blame] | 734 | assert( count>=0 ); |
| 735 | if( count < NDELAY ){ |
| 736 | delay = delays[count]; |
| 737 | prior = totals[count]; |
drh | d1bec47 | 2004-01-15 13:29:31 +0000 | [diff] [blame] | 738 | }else{ |
| 739 | delay = delays[NDELAY-1]; |
drh | 68cb619 | 2005-05-06 22:05:56 +0000 | [diff] [blame] | 740 | prior = totals[NDELAY-1] + delay*(count-(NDELAY-1)); |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 741 | } |
drh | d1bec47 | 2004-01-15 13:29:31 +0000 | [diff] [blame] | 742 | if( prior + delay > timeout ){ |
| 743 | delay = timeout - prior; |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 744 | if( delay<=0 ) return 0; |
| 745 | } |
danielk1977 | 2a6bdf6 | 2007-08-20 16:07:00 +0000 | [diff] [blame] | 746 | sqlite3OsSleep(db->pVfs, delay*1000); |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 747 | return 1; |
| 748 | #else |
drh | 482ea18 | 2007-08-20 11:12:40 +0000 | [diff] [blame] | 749 | sqlite3 *db = (sqlite3 *)ptr; |
drh | 3f73708 | 2005-06-14 02:24:31 +0000 | [diff] [blame] | 750 | int timeout = ((sqlite3 *)ptr)->busyTimeout; |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 751 | if( (count+1)*1000 > timeout ){ |
| 752 | return 0; |
| 753 | } |
drh | 482ea18 | 2007-08-20 11:12:40 +0000 | [diff] [blame] | 754 | sqlite3OsSleep(db->pVfs, 1000000); |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 755 | return 1; |
| 756 | #endif |
| 757 | } |
| 758 | |
| 759 | /* |
drh | a4afb65 | 2005-07-09 02:16:02 +0000 | [diff] [blame] | 760 | ** Invoke the given busy handler. |
| 761 | ** |
| 762 | ** This routine is called when an operation failed with a lock. |
| 763 | ** If this routine returns non-zero, the lock is retried. If it |
| 764 | ** returns 0, the operation aborts with an SQLITE_BUSY error. |
| 765 | */ |
| 766 | int sqlite3InvokeBusyHandler(BusyHandler *p){ |
| 767 | int rc; |
drh | 34004ce | 2008-07-11 16:15:17 +0000 | [diff] [blame] | 768 | if( NEVER(p==0) || p->xFunc==0 || p->nBusy<0 ) return 0; |
drh | a4afb65 | 2005-07-09 02:16:02 +0000 | [diff] [blame] | 769 | rc = p->xFunc(p->pArg, p->nBusy); |
| 770 | if( rc==0 ){ |
| 771 | p->nBusy = -1; |
| 772 | }else{ |
| 773 | p->nBusy++; |
| 774 | } |
| 775 | return rc; |
| 776 | } |
| 777 | |
| 778 | /* |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 779 | ** This routine sets the busy callback for an Sqlite database to the |
| 780 | ** given callback function with the given argument. |
| 781 | */ |
danielk1977 | f9d64d2 | 2004-06-19 08:18:07 +0000 | [diff] [blame] | 782 | int sqlite3_busy_handler( |
| 783 | sqlite3 *db, |
danielk1977 | 2a764eb | 2004-06-12 01:43:26 +0000 | [diff] [blame] | 784 | int (*xBusy)(void*,int), |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 785 | void *pArg |
| 786 | ){ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 787 | sqlite3_mutex_enter(db->mutex); |
danielk1977 | 24162fe | 2004-06-04 06:22:00 +0000 | [diff] [blame] | 788 | db->busyHandler.xFunc = xBusy; |
| 789 | db->busyHandler.pArg = pArg; |
drh | a4afb65 | 2005-07-09 02:16:02 +0000 | [diff] [blame] | 790 | db->busyHandler.nBusy = 0; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 791 | sqlite3_mutex_leave(db->mutex); |
danielk1977 | f9d64d2 | 2004-06-19 08:18:07 +0000 | [diff] [blame] | 792 | return SQLITE_OK; |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 793 | } |
| 794 | |
danielk1977 | 348bb5d | 2003-10-18 09:37:26 +0000 | [diff] [blame] | 795 | #ifndef SQLITE_OMIT_PROGRESS_CALLBACK |
| 796 | /* |
| 797 | ** This routine sets the progress callback for an Sqlite database to the |
| 798 | ** given callback function with the given argument. The progress callback will |
| 799 | ** be invoked every nOps opcodes. |
| 800 | */ |
danielk1977 | 24b03fd | 2004-05-10 10:34:34 +0000 | [diff] [blame] | 801 | void sqlite3_progress_handler( |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 802 | sqlite3 *db, |
danielk1977 | 348bb5d | 2003-10-18 09:37:26 +0000 | [diff] [blame] | 803 | int nOps, |
| 804 | int (*xProgress)(void*), |
| 805 | void *pArg |
| 806 | ){ |
drh | bd0b1b5 | 2008-07-07 19:52:09 +0000 | [diff] [blame] | 807 | sqlite3_mutex_enter(db->mutex); |
| 808 | if( nOps>0 ){ |
| 809 | db->xProgress = xProgress; |
| 810 | db->nProgressOps = nOps; |
| 811 | db->pProgressArg = pArg; |
| 812 | }else{ |
| 813 | db->xProgress = 0; |
| 814 | db->nProgressOps = 0; |
| 815 | db->pProgressArg = 0; |
danielk1977 | 348bb5d | 2003-10-18 09:37:26 +0000 | [diff] [blame] | 816 | } |
drh | bd0b1b5 | 2008-07-07 19:52:09 +0000 | [diff] [blame] | 817 | sqlite3_mutex_leave(db->mutex); |
danielk1977 | 348bb5d | 2003-10-18 09:37:26 +0000 | [diff] [blame] | 818 | } |
| 819 | #endif |
| 820 | |
| 821 | |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 822 | /* |
| 823 | ** This routine installs a default busy handler that waits for the |
| 824 | ** specified number of milliseconds before returning 0. |
| 825 | */ |
danielk1977 | f9d64d2 | 2004-06-19 08:18:07 +0000 | [diff] [blame] | 826 | int sqlite3_busy_timeout(sqlite3 *db, int ms){ |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 827 | if( ms>0 ){ |
drh | 97903fe | 2005-05-24 20:19:57 +0000 | [diff] [blame] | 828 | db->busyTimeout = ms; |
| 829 | sqlite3_busy_handler(db, sqliteDefaultBusyCallback, (void*)db); |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 830 | }else{ |
danielk1977 | 24b03fd | 2004-05-10 10:34:34 +0000 | [diff] [blame] | 831 | sqlite3_busy_handler(db, 0, 0); |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 832 | } |
danielk1977 | f9d64d2 | 2004-06-19 08:18:07 +0000 | [diff] [blame] | 833 | return SQLITE_OK; |
drh | 2dfbbca | 2000-07-28 14:32:48 +0000 | [diff] [blame] | 834 | } |
drh | 4c50439 | 2000-10-16 22:06:40 +0000 | [diff] [blame] | 835 | |
| 836 | /* |
| 837 | ** Cause any pending operation to stop at its earliest opportunity. |
| 838 | */ |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 839 | void sqlite3_interrupt(sqlite3 *db){ |
drh | bd0b1b5 | 2008-07-07 19:52:09 +0000 | [diff] [blame] | 840 | db->u1.isInterrupted = 1; |
drh | 4c50439 | 2000-10-16 22:06:40 +0000 | [diff] [blame] | 841 | } |
drh | fa86c41 | 2002-02-02 15:01:15 +0000 | [diff] [blame] | 842 | |
drh | fa86c41 | 2002-02-02 15:01:15 +0000 | [diff] [blame] | 843 | |
| 844 | /* |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 845 | ** This function is exactly the same as sqlite3_create_function(), except |
| 846 | ** that it is designed to be called by internal code. The difference is |
| 847 | ** that if a malloc() fails in sqlite3_create_function(), an error code |
| 848 | ** is returned and the mallocFailed flag cleared. |
drh | fa86c41 | 2002-02-02 15:01:15 +0000 | [diff] [blame] | 849 | */ |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 850 | int sqlite3CreateFunc( |
danielk1977 | 6590493 | 2004-05-26 06:18:37 +0000 | [diff] [blame] | 851 | sqlite3 *db, |
| 852 | const char *zFunctionName, |
| 853 | int nArg, |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 854 | int enc, |
danielk1977 | 6590493 | 2004-05-26 06:18:37 +0000 | [diff] [blame] | 855 | void *pUserData, |
| 856 | void (*xFunc)(sqlite3_context*,int,sqlite3_value **), |
| 857 | void (*xStep)(sqlite3_context*,int,sqlite3_value **), |
| 858 | void (*xFinal)(sqlite3_context*) |
drh | 8e0a2f9 | 2002-02-23 23:45:45 +0000 | [diff] [blame] | 859 | ){ |
drh | 0bce835 | 2002-02-28 00:41:10 +0000 | [diff] [blame] | 860 | FuncDef *p; |
drh | 4b59ab5 | 2002-08-24 18:24:51 +0000 | [diff] [blame] | 861 | int nName; |
danielk1977 | 6590493 | 2004-05-26 06:18:37 +0000 | [diff] [blame] | 862 | |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 863 | assert( sqlite3_mutex_held(db->mutex) ); |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 864 | if( zFunctionName==0 || |
danielk1977 | 398eae7 | 2004-05-26 06:58:43 +0000 | [diff] [blame] | 865 | (xFunc && (xFinal || xStep)) || |
| 866 | (!xFunc && (xFinal && !xStep)) || |
| 867 | (!xFunc && (!xFinal && xStep)) || |
drh | 24b58dd | 2008-07-07 14:50:14 +0000 | [diff] [blame] | 868 | (nArg<-1 || nArg>SQLITE_MAX_FUNCTION_ARG) || |
drh | 0a687d1 | 2008-07-08 14:52:07 +0000 | [diff] [blame] | 869 | (255<(nName = sqlite3Strlen(db, zFunctionName))) ){ |
drh | badf7a7 | 2006-06-14 15:35:36 +0000 | [diff] [blame] | 870 | sqlite3Error(db, SQLITE_ERROR, "bad parameters"); |
danielk1977 | 6590493 | 2004-05-26 06:18:37 +0000 | [diff] [blame] | 871 | return SQLITE_ERROR; |
| 872 | } |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 873 | |
danielk1977 | 93758c8 | 2005-01-21 08:13:14 +0000 | [diff] [blame] | 874 | #ifndef SQLITE_OMIT_UTF16 |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 875 | /* If SQLITE_UTF16 is specified as the encoding type, transform this |
| 876 | ** to one of SQLITE_UTF16LE or SQLITE_UTF16BE using the |
| 877 | ** SQLITE_UTF16NATIVE macro. SQLITE_UTF16 is not used internally. |
| 878 | ** |
| 879 | ** If SQLITE_ANY is specified, add three versions of the function |
| 880 | ** to the hash table. |
| 881 | */ |
| 882 | if( enc==SQLITE_UTF16 ){ |
| 883 | enc = SQLITE_UTF16NATIVE; |
| 884 | }else if( enc==SQLITE_ANY ){ |
| 885 | int rc; |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 886 | rc = sqlite3CreateFunc(db, zFunctionName, nArg, SQLITE_UTF8, |
danielk1977 | f9d64d2 | 2004-06-19 08:18:07 +0000 | [diff] [blame] | 887 | pUserData, xFunc, xStep, xFinal); |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 888 | if( rc==SQLITE_OK ){ |
| 889 | rc = sqlite3CreateFunc(db, zFunctionName, nArg, SQLITE_UTF16LE, |
| 890 | pUserData, xFunc, xStep, xFinal); |
| 891 | } |
| 892 | if( rc!=SQLITE_OK ){ |
| 893 | return rc; |
| 894 | } |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 895 | enc = SQLITE_UTF16BE; |
| 896 | } |
danielk1977 | 93758c8 | 2005-01-21 08:13:14 +0000 | [diff] [blame] | 897 | #else |
| 898 | enc = SQLITE_UTF8; |
| 899 | #endif |
danielk1977 | 9636c4e | 2005-01-25 04:27:54 +0000 | [diff] [blame] | 900 | |
| 901 | /* Check if an existing function is being overridden or deleted. If so, |
| 902 | ** and there are active VMs, then return SQLITE_BUSY. If a function |
| 903 | ** is being overridden/deleted but there are no active VMs, allow the |
| 904 | ** operation to continue but invalidate all precompiled statements. |
| 905 | */ |
| 906 | p = sqlite3FindFunction(db, zFunctionName, nName, nArg, enc, 0); |
| 907 | if( p && p->iPrefEnc==enc && p->nArg==nArg ){ |
| 908 | if( db->activeVdbeCnt ){ |
| 909 | sqlite3Error(db, SQLITE_BUSY, |
| 910 | "Unable to delete/modify user-function due to active statements"); |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 911 | assert( !db->mallocFailed ); |
danielk1977 | 9636c4e | 2005-01-25 04:27:54 +0000 | [diff] [blame] | 912 | return SQLITE_BUSY; |
| 913 | }else{ |
| 914 | sqlite3ExpirePreparedStatements(db); |
| 915 | } |
| 916 | } |
danielk1977 | 6590493 | 2004-05-26 06:18:37 +0000 | [diff] [blame] | 917 | |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 918 | p = sqlite3FindFunction(db, zFunctionName, nName, nArg, enc, 1); |
danielk1977 | fa18bec | 2007-09-03 11:04:22 +0000 | [diff] [blame] | 919 | assert(p || db->mallocFailed); |
| 920 | if( !p ){ |
| 921 | return SQLITE_NOMEM; |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 922 | } |
danielk1977 | fa18bec | 2007-09-03 11:04:22 +0000 | [diff] [blame] | 923 | p->flags = 0; |
| 924 | p->xFunc = xFunc; |
| 925 | p->xStep = xStep; |
| 926 | p->xFinalize = xFinal; |
| 927 | p->pUserData = pUserData; |
| 928 | p->nArg = nArg; |
danielk1977 | 6590493 | 2004-05-26 06:18:37 +0000 | [diff] [blame] | 929 | return SQLITE_OK; |
| 930 | } |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 931 | |
| 932 | /* |
| 933 | ** Create new user functions. |
| 934 | */ |
| 935 | int sqlite3_create_function( |
| 936 | sqlite3 *db, |
| 937 | const char *zFunctionName, |
| 938 | int nArg, |
| 939 | int enc, |
| 940 | void *p, |
| 941 | void (*xFunc)(sqlite3_context*,int,sqlite3_value **), |
| 942 | void (*xStep)(sqlite3_context*,int,sqlite3_value **), |
| 943 | void (*xFinal)(sqlite3_context*) |
| 944 | ){ |
| 945 | int rc; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 946 | sqlite3_mutex_enter(db->mutex); |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 947 | rc = sqlite3CreateFunc(db, zFunctionName, nArg, enc, p, xFunc, xStep, xFinal); |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 948 | rc = sqlite3ApiExit(db, rc); |
| 949 | sqlite3_mutex_leave(db->mutex); |
| 950 | return rc; |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 951 | } |
| 952 | |
danielk1977 | 93758c8 | 2005-01-21 08:13:14 +0000 | [diff] [blame] | 953 | #ifndef SQLITE_OMIT_UTF16 |
danielk1977 | 6590493 | 2004-05-26 06:18:37 +0000 | [diff] [blame] | 954 | int sqlite3_create_function16( |
| 955 | sqlite3 *db, |
| 956 | const void *zFunctionName, |
| 957 | int nArg, |
| 958 | int eTextRep, |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 959 | void *p, |
danielk1977 | 6590493 | 2004-05-26 06:18:37 +0000 | [diff] [blame] | 960 | void (*xFunc)(sqlite3_context*,int,sqlite3_value**), |
| 961 | void (*xStep)(sqlite3_context*,int,sqlite3_value**), |
| 962 | void (*xFinal)(sqlite3_context*) |
| 963 | ){ |
| 964 | int rc; |
drh | af9a7c2 | 2005-12-15 03:04:10 +0000 | [diff] [blame] | 965 | char *zFunc8; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 966 | sqlite3_mutex_enter(db->mutex); |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 967 | assert( !db->mallocFailed ); |
danielk1977 | 1e53695 | 2007-08-16 10:09:01 +0000 | [diff] [blame] | 968 | zFunc8 = sqlite3Utf16to8(db, zFunctionName, -1); |
danielk1977 | 771151b | 2006-01-17 13:21:40 +0000 | [diff] [blame] | 969 | rc = sqlite3CreateFunc(db, zFunc8, nArg, eTextRep, p, xFunc, xStep, xFinal); |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 970 | sqlite3DbFree(db, zFunc8); |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 971 | rc = sqlite3ApiExit(db, rc); |
| 972 | sqlite3_mutex_leave(db->mutex); |
| 973 | return rc; |
drh | 8e0a2f9 | 2002-02-23 23:45:45 +0000 | [diff] [blame] | 974 | } |
danielk1977 | 93758c8 | 2005-01-21 08:13:14 +0000 | [diff] [blame] | 975 | #endif |
drh | c9b84a1 | 2002-06-20 11:36:48 +0000 | [diff] [blame] | 976 | |
drh | b7481e7 | 2006-09-16 21:45:14 +0000 | [diff] [blame] | 977 | |
| 978 | /* |
| 979 | ** Declare that a function has been overloaded by a virtual table. |
| 980 | ** |
| 981 | ** If the function already exists as a regular global function, then |
| 982 | ** this routine is a no-op. If the function does not exist, then create |
| 983 | ** a new one that always throws a run-time error. |
| 984 | ** |
| 985 | ** When virtual tables intend to provide an overloaded function, they |
| 986 | ** should call this routine to make sure the global function exists. |
| 987 | ** A global function must exist in order for name resolution to work |
| 988 | ** properly. |
| 989 | */ |
| 990 | int sqlite3_overload_function( |
| 991 | sqlite3 *db, |
| 992 | const char *zName, |
| 993 | int nArg |
| 994 | ){ |
drh | 0a687d1 | 2008-07-08 14:52:07 +0000 | [diff] [blame] | 995 | int nName = sqlite3Strlen(db, zName); |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 996 | int rc; |
| 997 | sqlite3_mutex_enter(db->mutex); |
drh | b7481e7 | 2006-09-16 21:45:14 +0000 | [diff] [blame] | 998 | if( sqlite3FindFunction(db, zName, nName, nArg, SQLITE_UTF8, 0)==0 ){ |
| 999 | sqlite3CreateFunc(db, zName, nArg, SQLITE_UTF8, |
| 1000 | 0, sqlite3InvalidFunction, 0, 0); |
| 1001 | } |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1002 | rc = sqlite3ApiExit(db, SQLITE_OK); |
| 1003 | sqlite3_mutex_leave(db->mutex); |
| 1004 | return rc; |
drh | b7481e7 | 2006-09-16 21:45:14 +0000 | [diff] [blame] | 1005 | } |
| 1006 | |
drh | 19e2d37 | 2005-08-29 23:00:03 +0000 | [diff] [blame] | 1007 | #ifndef SQLITE_OMIT_TRACE |
drh | c9b84a1 | 2002-06-20 11:36:48 +0000 | [diff] [blame] | 1008 | /* |
drh | 18de482 | 2003-01-16 16:28:53 +0000 | [diff] [blame] | 1009 | ** Register a trace function. The pArg from the previously registered trace |
| 1010 | ** is returned. |
| 1011 | ** |
| 1012 | ** A NULL trace function means that no tracing is executes. A non-NULL |
| 1013 | ** trace is a pointer to a function that is invoked at the start of each |
drh | 19e2d37 | 2005-08-29 23:00:03 +0000 | [diff] [blame] | 1014 | ** SQL statement. |
drh | 18de482 | 2003-01-16 16:28:53 +0000 | [diff] [blame] | 1015 | */ |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 1016 | void *sqlite3_trace(sqlite3 *db, void (*xTrace)(void*,const char*), void *pArg){ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1017 | void *pOld; |
| 1018 | sqlite3_mutex_enter(db->mutex); |
| 1019 | pOld = db->pTraceArg; |
drh | 18de482 | 2003-01-16 16:28:53 +0000 | [diff] [blame] | 1020 | db->xTrace = xTrace; |
| 1021 | db->pTraceArg = pArg; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1022 | sqlite3_mutex_leave(db->mutex); |
drh | 18de482 | 2003-01-16 16:28:53 +0000 | [diff] [blame] | 1023 | return pOld; |
drh | 0d1a643 | 2003-04-03 15:46:04 +0000 | [diff] [blame] | 1024 | } |
drh | 19e2d37 | 2005-08-29 23:00:03 +0000 | [diff] [blame] | 1025 | /* |
| 1026 | ** Register a profile function. The pArg from the previously registered |
| 1027 | ** profile function is returned. |
| 1028 | ** |
| 1029 | ** A NULL profile function means that no profiling is executes. A non-NULL |
| 1030 | ** profile is a pointer to a function that is invoked at the conclusion of |
| 1031 | ** each SQL statement that is run. |
| 1032 | */ |
| 1033 | void *sqlite3_profile( |
| 1034 | sqlite3 *db, |
| 1035 | void (*xProfile)(void*,const char*,sqlite_uint64), |
| 1036 | void *pArg |
| 1037 | ){ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1038 | void *pOld; |
| 1039 | sqlite3_mutex_enter(db->mutex); |
| 1040 | pOld = db->pProfileArg; |
drh | 19e2d37 | 2005-08-29 23:00:03 +0000 | [diff] [blame] | 1041 | db->xProfile = xProfile; |
| 1042 | db->pProfileArg = pArg; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1043 | sqlite3_mutex_leave(db->mutex); |
drh | 19e2d37 | 2005-08-29 23:00:03 +0000 | [diff] [blame] | 1044 | return pOld; |
| 1045 | } |
| 1046 | #endif /* SQLITE_OMIT_TRACE */ |
paul | b0208cc | 2003-04-13 18:26:49 +0000 | [diff] [blame] | 1047 | |
drh | aa940ea | 2004-01-15 02:44:03 +0000 | [diff] [blame] | 1048 | /*** EXPERIMENTAL *** |
| 1049 | ** |
| 1050 | ** Register a function to be invoked when a transaction comments. |
danielk1977 | 71fd80b | 2005-12-16 06:54:01 +0000 | [diff] [blame] | 1051 | ** If the invoked function returns non-zero, then the commit becomes a |
drh | aa940ea | 2004-01-15 02:44:03 +0000 | [diff] [blame] | 1052 | ** rollback. |
| 1053 | */ |
danielk1977 | 24b03fd | 2004-05-10 10:34:34 +0000 | [diff] [blame] | 1054 | void *sqlite3_commit_hook( |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 1055 | sqlite3 *db, /* Attach the hook to this database */ |
drh | aa940ea | 2004-01-15 02:44:03 +0000 | [diff] [blame] | 1056 | int (*xCallback)(void*), /* Function to invoke on each commit */ |
| 1057 | void *pArg /* Argument to the function */ |
| 1058 | ){ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1059 | void *pOld; |
| 1060 | sqlite3_mutex_enter(db->mutex); |
| 1061 | pOld = db->pCommitArg; |
drh | aa940ea | 2004-01-15 02:44:03 +0000 | [diff] [blame] | 1062 | db->xCommitCallback = xCallback; |
| 1063 | db->pCommitArg = pArg; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1064 | sqlite3_mutex_leave(db->mutex); |
drh | aa940ea | 2004-01-15 02:44:03 +0000 | [diff] [blame] | 1065 | return pOld; |
| 1066 | } |
| 1067 | |
danielk1977 | 94eb6a1 | 2005-12-15 15:22:08 +0000 | [diff] [blame] | 1068 | /* |
| 1069 | ** Register a callback to be invoked each time a row is updated, |
| 1070 | ** inserted or deleted using this database connection. |
| 1071 | */ |
danielk1977 | 71fd80b | 2005-12-16 06:54:01 +0000 | [diff] [blame] | 1072 | void *sqlite3_update_hook( |
danielk1977 | 94eb6a1 | 2005-12-15 15:22:08 +0000 | [diff] [blame] | 1073 | sqlite3 *db, /* Attach the hook to this database */ |
| 1074 | void (*xCallback)(void*,int,char const *,char const *,sqlite_int64), |
| 1075 | void *pArg /* Argument to the function */ |
| 1076 | ){ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1077 | void *pRet; |
| 1078 | sqlite3_mutex_enter(db->mutex); |
| 1079 | pRet = db->pUpdateArg; |
danielk1977 | 94eb6a1 | 2005-12-15 15:22:08 +0000 | [diff] [blame] | 1080 | db->xUpdateCallback = xCallback; |
| 1081 | db->pUpdateArg = pArg; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1082 | sqlite3_mutex_leave(db->mutex); |
danielk1977 | 71fd80b | 2005-12-16 06:54:01 +0000 | [diff] [blame] | 1083 | return pRet; |
danielk1977 | 94eb6a1 | 2005-12-15 15:22:08 +0000 | [diff] [blame] | 1084 | } |
| 1085 | |
danielk1977 | 71fd80b | 2005-12-16 06:54:01 +0000 | [diff] [blame] | 1086 | /* |
| 1087 | ** Register a callback to be invoked each time a transaction is rolled |
| 1088 | ** back by this database connection. |
| 1089 | */ |
| 1090 | void *sqlite3_rollback_hook( |
| 1091 | sqlite3 *db, /* Attach the hook to this database */ |
| 1092 | void (*xCallback)(void*), /* Callback function */ |
| 1093 | void *pArg /* Argument to the function */ |
| 1094 | ){ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1095 | void *pRet; |
| 1096 | sqlite3_mutex_enter(db->mutex); |
| 1097 | pRet = db->pRollbackArg; |
danielk1977 | 71fd80b | 2005-12-16 06:54:01 +0000 | [diff] [blame] | 1098 | db->xRollbackCallback = xCallback; |
| 1099 | db->pRollbackArg = pArg; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1100 | sqlite3_mutex_leave(db->mutex); |
danielk1977 | 71fd80b | 2005-12-16 06:54:01 +0000 | [diff] [blame] | 1101 | return pRet; |
| 1102 | } |
drh | aa940ea | 2004-01-15 02:44:03 +0000 | [diff] [blame] | 1103 | |
paul | b0208cc | 2003-04-13 18:26:49 +0000 | [diff] [blame] | 1104 | /* |
drh | 13bff81 | 2003-04-15 01:19:47 +0000 | [diff] [blame] | 1105 | ** This routine is called to create a connection to a database BTree |
| 1106 | ** driver. If zFilename is the name of a file, then that file is |
| 1107 | ** opened and used. If zFilename is the magic name ":memory:" then |
| 1108 | ** the database is stored in memory (and is thus forgotten as soon as |
| 1109 | ** the connection is closed.) If zFilename is NULL then the database |
drh | 84bfda4 | 2005-07-15 13:05:21 +0000 | [diff] [blame] | 1110 | ** is a "virtual" database for transient use only and is deleted as |
| 1111 | ** soon as the connection is closed. |
drh | 90f5ecb | 2004-07-22 01:19:35 +0000 | [diff] [blame] | 1112 | ** |
drh | 84bfda4 | 2005-07-15 13:05:21 +0000 | [diff] [blame] | 1113 | ** A virtual database can be either a disk file (that is automatically |
| 1114 | ** deleted when the file is closed) or it an be held entirely in memory, |
danielk1977 | b06a0b6 | 2008-06-26 10:54:12 +0000 | [diff] [blame] | 1115 | ** depending on the values of the SQLITE_TEMP_STORE compile-time macro and the |
drh | 90f5ecb | 2004-07-22 01:19:35 +0000 | [diff] [blame] | 1116 | ** db->temp_store variable, according to the following chart: |
| 1117 | ** |
danielk1977 | b06a0b6 | 2008-06-26 10:54:12 +0000 | [diff] [blame] | 1118 | ** SQLITE_TEMP_STORE db->temp_store Location of temporary database |
| 1119 | ** ----------------- -------------- ------------------------------ |
| 1120 | ** 0 any file |
| 1121 | ** 1 1 file |
| 1122 | ** 1 2 memory |
| 1123 | ** 1 0 file |
| 1124 | ** 2 1 file |
| 1125 | ** 2 2 memory |
| 1126 | ** 2 0 memory |
| 1127 | ** 3 any memory |
paul | b0208cc | 2003-04-13 18:26:49 +0000 | [diff] [blame] | 1128 | */ |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 1129 | int sqlite3BtreeFactory( |
drh | 9bb575f | 2004-09-06 17:24:11 +0000 | [diff] [blame] | 1130 | const sqlite3 *db, /* Main database when opening aux otherwise 0 */ |
paul | b0208cc | 2003-04-13 18:26:49 +0000 | [diff] [blame] | 1131 | const char *zFilename, /* Name of the file containing the BTree database */ |
| 1132 | int omitJournal, /* if TRUE then do not journal this file */ |
| 1133 | int nCache, /* How many pages in the page cache */ |
drh | 33f4e02 | 2007-09-03 15:19:34 +0000 | [diff] [blame] | 1134 | int vfsFlags, /* Flags passed through to vfsOpen */ |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 1135 | Btree **ppBtree /* Pointer to new Btree object written here */ |
| 1136 | ){ |
drh | 33f4e02 | 2007-09-03 15:19:34 +0000 | [diff] [blame] | 1137 | int btFlags = 0; |
drh | 90f5ecb | 2004-07-22 01:19:35 +0000 | [diff] [blame] | 1138 | int rc; |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 1139 | |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1140 | assert( sqlite3_mutex_held(db->mutex) ); |
drh | eec983e | 2004-05-08 10:11:36 +0000 | [diff] [blame] | 1141 | assert( ppBtree != 0); |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 1142 | if( omitJournal ){ |
drh | 33f4e02 | 2007-09-03 15:19:34 +0000 | [diff] [blame] | 1143 | btFlags |= BTREE_OMIT_JOURNAL; |
paul | b0208cc | 2003-04-13 18:26:49 +0000 | [diff] [blame] | 1144 | } |
drh | 7bec505 | 2005-02-06 02:45:41 +0000 | [diff] [blame] | 1145 | if( db->flags & SQLITE_NoReadlock ){ |
drh | 33f4e02 | 2007-09-03 15:19:34 +0000 | [diff] [blame] | 1146 | btFlags |= BTREE_NO_READLOCK; |
drh | 7bec505 | 2005-02-06 02:45:41 +0000 | [diff] [blame] | 1147 | } |
drh | 90f5ecb | 2004-07-22 01:19:35 +0000 | [diff] [blame] | 1148 | if( zFilename==0 ){ |
danielk1977 | b06a0b6 | 2008-06-26 10:54:12 +0000 | [diff] [blame] | 1149 | #if SQLITE_TEMP_STORE==0 |
drh | 22ac46d | 2004-08-14 18:34:54 +0000 | [diff] [blame] | 1150 | /* Do nothing */ |
drh | 90f5ecb | 2004-07-22 01:19:35 +0000 | [diff] [blame] | 1151 | #endif |
danielk1977 | 03aded4 | 2004-11-22 05:26:27 +0000 | [diff] [blame] | 1152 | #ifndef SQLITE_OMIT_MEMORYDB |
danielk1977 | b06a0b6 | 2008-06-26 10:54:12 +0000 | [diff] [blame] | 1153 | #if SQLITE_TEMP_STORE==1 |
drh | 22ac46d | 2004-08-14 18:34:54 +0000 | [diff] [blame] | 1154 | if( db->temp_store==2 ) zFilename = ":memory:"; |
drh | 90f5ecb | 2004-07-22 01:19:35 +0000 | [diff] [blame] | 1155 | #endif |
danielk1977 | b06a0b6 | 2008-06-26 10:54:12 +0000 | [diff] [blame] | 1156 | #if SQLITE_TEMP_STORE==2 |
drh | 22ac46d | 2004-08-14 18:34:54 +0000 | [diff] [blame] | 1157 | if( db->temp_store!=1 ) zFilename = ":memory:"; |
drh | 90f5ecb | 2004-07-22 01:19:35 +0000 | [diff] [blame] | 1158 | #endif |
danielk1977 | b06a0b6 | 2008-06-26 10:54:12 +0000 | [diff] [blame] | 1159 | #if SQLITE_TEMP_STORE==3 |
drh | 22ac46d | 2004-08-14 18:34:54 +0000 | [diff] [blame] | 1160 | zFilename = ":memory:"; |
drh | 90f5ecb | 2004-07-22 01:19:35 +0000 | [diff] [blame] | 1161 | #endif |
danielk1977 | 03aded4 | 2004-11-22 05:26:27 +0000 | [diff] [blame] | 1162 | #endif /* SQLITE_OMIT_MEMORYDB */ |
drh | 90f5ecb | 2004-07-22 01:19:35 +0000 | [diff] [blame] | 1163 | } |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 1164 | |
drh | 33f4e02 | 2007-09-03 15:19:34 +0000 | [diff] [blame] | 1165 | if( (vfsFlags & SQLITE_OPEN_MAIN_DB)!=0 && (zFilename==0 || *zFilename==0) ){ |
| 1166 | vfsFlags = (vfsFlags & ~SQLITE_OPEN_MAIN_DB) | SQLITE_OPEN_TEMP_DB; |
| 1167 | } |
| 1168 | rc = sqlite3BtreeOpen(zFilename, (sqlite3 *)db, ppBtree, btFlags, vfsFlags); |
danielk1977 | 171bfed | 2008-06-23 09:50:50 +0000 | [diff] [blame] | 1169 | |
| 1170 | /* If the B-Tree was successfully opened, set the pager-cache size to the |
| 1171 | ** default value. Except, if the call to BtreeOpen() returned a handle |
| 1172 | ** open on an existing shared pager-cache, do not change the pager-cache |
| 1173 | ** size. |
| 1174 | */ |
| 1175 | if( rc==SQLITE_OK && 0==sqlite3BtreeSchema(*ppBtree, 0, 0) ){ |
drh | 90f5ecb | 2004-07-22 01:19:35 +0000 | [diff] [blame] | 1176 | sqlite3BtreeSetCacheSize(*ppBtree, nCache); |
| 1177 | } |
| 1178 | return rc; |
paul | b0208cc | 2003-04-13 18:26:49 +0000 | [diff] [blame] | 1179 | } |
danielk1977 | 4adee20 | 2004-05-08 08:23:19 +0000 | [diff] [blame] | 1180 | |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1181 | /* |
| 1182 | ** Return UTF-8 encoded English language explanation of the most recent |
| 1183 | ** error. |
| 1184 | */ |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 1185 | const char *sqlite3_errmsg(sqlite3 *db){ |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1186 | const char *z; |
danielk1977 | ae7fc49 | 2007-03-29 15:00:52 +0000 | [diff] [blame] | 1187 | if( !db ){ |
danielk1977 | f20b21c | 2004-05-31 23:56:42 +0000 | [diff] [blame] | 1188 | return sqlite3ErrStr(SQLITE_NOMEM); |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1189 | } |
drh | d55d57e | 2008-07-07 17:53:07 +0000 | [diff] [blame] | 1190 | if( !sqlite3SafetyCheckSickOrOk(db) ){ |
danielk1977 | e35ee19 | 2004-06-26 09:50:11 +0000 | [diff] [blame] | 1191 | return sqlite3ErrStr(SQLITE_MISUSE); |
| 1192 | } |
drh | 2764170 | 2007-08-22 02:56:42 +0000 | [diff] [blame] | 1193 | sqlite3_mutex_enter(db->mutex); |
drh | 86f8c19 | 2007-08-22 00:39:19 +0000 | [diff] [blame] | 1194 | assert( !db->mallocFailed ); |
drh | 2646da7 | 2005-12-09 20:02:05 +0000 | [diff] [blame] | 1195 | z = (char*)sqlite3_value_text(db->pErr); |
danielk1977 | 131c8bc | 2008-05-22 13:56:17 +0000 | [diff] [blame] | 1196 | assert( !db->mallocFailed ); |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1197 | if( z==0 ){ |
| 1198 | z = sqlite3ErrStr(db->errCode); |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 1199 | } |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1200 | sqlite3_mutex_leave(db->mutex); |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1201 | return z; |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 1202 | } |
| 1203 | |
drh | 6c62608 | 2004-11-14 21:56:29 +0000 | [diff] [blame] | 1204 | #ifndef SQLITE_OMIT_UTF16 |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1205 | /* |
| 1206 | ** Return UTF-16 encoded English language explanation of the most recent |
| 1207 | ** error. |
| 1208 | */ |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 1209 | const void *sqlite3_errmsg16(sqlite3 *db){ |
danielk1977 | bfd6cce | 2004-06-18 04:24:54 +0000 | [diff] [blame] | 1210 | /* Because all the characters in the string are in the unicode |
| 1211 | ** range 0x00-0xFF, if we pad the big-endian string with a |
| 1212 | ** zero byte, we can obtain the little-endian string with |
| 1213 | ** &big_endian[1]. |
| 1214 | */ |
drh | 5719628 | 2004-10-06 15:41:16 +0000 | [diff] [blame] | 1215 | static const char outOfMemBe[] = { |
danielk1977 | bfd6cce | 2004-06-18 04:24:54 +0000 | [diff] [blame] | 1216 | 0, 'o', 0, 'u', 0, 't', 0, ' ', |
| 1217 | 0, 'o', 0, 'f', 0, ' ', |
| 1218 | 0, 'm', 0, 'e', 0, 'm', 0, 'o', 0, 'r', 0, 'y', 0, 0, 0 |
| 1219 | }; |
drh | 5719628 | 2004-10-06 15:41:16 +0000 | [diff] [blame] | 1220 | static const char misuseBe [] = { |
danielk1977 | e35ee19 | 2004-06-26 09:50:11 +0000 | [diff] [blame] | 1221 | 0, 'l', 0, 'i', 0, 'b', 0, 'r', 0, 'a', 0, 'r', 0, 'y', 0, ' ', |
| 1222 | 0, 'r', 0, 'o', 0, 'u', 0, 't', 0, 'i', 0, 'n', 0, 'e', 0, ' ', |
| 1223 | 0, 'c', 0, 'a', 0, 'l', 0, 'l', 0, 'e', 0, 'd', 0, ' ', |
| 1224 | 0, 'o', 0, 'u', 0, 't', 0, ' ', |
| 1225 | 0, 'o', 0, 'f', 0, ' ', |
| 1226 | 0, 's', 0, 'e', 0, 'q', 0, 'u', 0, 'e', 0, 'n', 0, 'c', 0, 'e', 0, 0, 0 |
| 1227 | }; |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1228 | |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1229 | const void *z; |
danielk1977 | ae7fc49 | 2007-03-29 15:00:52 +0000 | [diff] [blame] | 1230 | if( !db ){ |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1231 | return (void *)(&outOfMemBe[SQLITE_UTF16NATIVE==SQLITE_UTF16LE?1:0]); |
| 1232 | } |
drh | d55d57e | 2008-07-07 17:53:07 +0000 | [diff] [blame] | 1233 | if( !sqlite3SafetyCheckSickOrOk(db) ){ |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1234 | return (void *)(&misuseBe[SQLITE_UTF16NATIVE==SQLITE_UTF16LE?1:0]); |
| 1235 | } |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1236 | sqlite3_mutex_enter(db->mutex); |
| 1237 | assert( !db->mallocFailed ); |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1238 | z = sqlite3_value_text16(db->pErr); |
| 1239 | if( z==0 ){ |
drh | b21c8cd | 2007-08-21 19:33:56 +0000 | [diff] [blame] | 1240 | sqlite3ValueSetStr(db->pErr, -1, sqlite3ErrStr(db->errCode), |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1241 | SQLITE_UTF8, SQLITE_STATIC); |
| 1242 | z = sqlite3_value_text16(db->pErr); |
| 1243 | } |
danielk1977 | 131c8bc | 2008-05-22 13:56:17 +0000 | [diff] [blame] | 1244 | /* A malloc() may have failed within the call to sqlite3_value_text16() |
| 1245 | ** above. If this is the case, then the db->mallocFailed flag needs to |
| 1246 | ** be cleared before returning. Do this directly, instead of via |
| 1247 | ** sqlite3ApiExit(), to avoid setting the database handle error message. |
| 1248 | */ |
| 1249 | db->mallocFailed = 0; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1250 | sqlite3_mutex_leave(db->mutex); |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1251 | return z; |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 1252 | } |
drh | 6c62608 | 2004-11-14 21:56:29 +0000 | [diff] [blame] | 1253 | #endif /* SQLITE_OMIT_UTF16 */ |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 1254 | |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1255 | /* |
danielk1977 | 7ddad96 | 2005-12-12 06:53:03 +0000 | [diff] [blame] | 1256 | ** Return the most recent error code generated by an SQLite routine. If NULL is |
| 1257 | ** passed to this function, we assume a malloc() failed during sqlite3_open(). |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1258 | */ |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 1259 | int sqlite3_errcode(sqlite3 *db){ |
danielk1977 | 7c36d07 | 2008-01-31 15:31:01 +0000 | [diff] [blame] | 1260 | if( db && !sqlite3SafetyCheckSickOrOk(db) ){ |
drh | c60d044 | 2004-09-30 13:43:13 +0000 | [diff] [blame] | 1261 | return SQLITE_MISUSE; |
| 1262 | } |
drh | 01495b9 | 2008-01-23 12:52:40 +0000 | [diff] [blame] | 1263 | if( !db || db->mallocFailed ){ |
| 1264 | return SQLITE_NOMEM; |
| 1265 | } |
drh | 4ac285a | 2006-09-15 07:28:50 +0000 | [diff] [blame] | 1266 | return db->errCode & db->errMask; |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 1267 | } |
drh | 99dfe5e | 2008-10-30 15:03:15 +0000 | [diff] [blame] | 1268 | int sqlite3_extended_errcode(sqlite3 *db){ |
| 1269 | if( db && !sqlite3SafetyCheckSickOrOk(db) ){ |
| 1270 | return SQLITE_MISUSE; |
| 1271 | } |
| 1272 | if( !db || db->mallocFailed ){ |
| 1273 | return SQLITE_NOMEM; |
| 1274 | } |
| 1275 | return db->errCode; |
| 1276 | } |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 1277 | |
drh | 0e819f9 | 2006-02-01 13:50:41 +0000 | [diff] [blame] | 1278 | /* |
| 1279 | ** Create a new collating function for database "db". The name is zName |
| 1280 | ** and the encoding is enc. |
| 1281 | */ |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1282 | static int createCollation( |
| 1283 | sqlite3* db, |
| 1284 | const char *zName, |
| 1285 | int enc, |
| 1286 | void* pCtx, |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 1287 | int(*xCompare)(void*,int,const void*,int,const void*), |
| 1288 | void(*xDel)(void*) |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1289 | ){ |
| 1290 | CollSeq *pColl; |
drh | 7d9bd4e | 2006-02-16 18:16:36 +0000 | [diff] [blame] | 1291 | int enc2; |
drh | 0a687d1 | 2008-07-08 14:52:07 +0000 | [diff] [blame] | 1292 | int nName; |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1293 | |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1294 | assert( sqlite3_mutex_held(db->mutex) ); |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1295 | |
| 1296 | /* If SQLITE_UTF16 is specified as the encoding type, transform this |
| 1297 | ** to one of SQLITE_UTF16LE or SQLITE_UTF16BE using the |
| 1298 | ** SQLITE_UTF16NATIVE macro. SQLITE_UTF16 is not used internally. |
| 1299 | */ |
drh | 7d9bd4e | 2006-02-16 18:16:36 +0000 | [diff] [blame] | 1300 | enc2 = enc & ~SQLITE_UTF16_ALIGNED; |
| 1301 | if( enc2==SQLITE_UTF16 ){ |
| 1302 | enc2 = SQLITE_UTF16NATIVE; |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1303 | } |
drh | 7d9bd4e | 2006-02-16 18:16:36 +0000 | [diff] [blame] | 1304 | if( (enc2&~3)!=0 ){ |
drh | d55d57e | 2008-07-07 17:53:07 +0000 | [diff] [blame] | 1305 | return SQLITE_MISUSE; |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1306 | } |
| 1307 | |
| 1308 | /* Check if this call is removing or replacing an existing collation |
| 1309 | ** sequence. If so, and there are active VMs, return busy. If there |
| 1310 | ** are no active VMs, invalidate any pre-compiled statements. |
| 1311 | */ |
drh | 0a687d1 | 2008-07-08 14:52:07 +0000 | [diff] [blame] | 1312 | nName = sqlite3Strlen(db, zName); |
| 1313 | pColl = sqlite3FindCollSeq(db, (u8)enc2, zName, nName, 0); |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1314 | if( pColl && pColl->xCmp ){ |
| 1315 | if( db->activeVdbeCnt ){ |
| 1316 | sqlite3Error(db, SQLITE_BUSY, |
| 1317 | "Unable to delete/modify collation sequence due to active statements"); |
| 1318 | return SQLITE_BUSY; |
| 1319 | } |
| 1320 | sqlite3ExpirePreparedStatements(db); |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 1321 | |
| 1322 | /* If collation sequence pColl was created directly by a call to |
| 1323 | ** sqlite3_create_collation, and not generated by synthCollSeq(), |
| 1324 | ** then any copies made by synthCollSeq() need to be invalidated. |
| 1325 | ** Also, collation destructor - CollSeq.xDel() - function may need |
| 1326 | ** to be called. |
| 1327 | */ |
| 1328 | if( (pColl->enc & ~SQLITE_UTF16_ALIGNED)==enc2 ){ |
drh | 0a687d1 | 2008-07-08 14:52:07 +0000 | [diff] [blame] | 1329 | CollSeq *aColl = sqlite3HashFind(&db->aCollSeq, zName, nName); |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 1330 | int j; |
| 1331 | for(j=0; j<3; j++){ |
| 1332 | CollSeq *p = &aColl[j]; |
| 1333 | if( p->enc==pColl->enc ){ |
| 1334 | if( p->xDel ){ |
| 1335 | p->xDel(p->pUser); |
| 1336 | } |
| 1337 | p->xCmp = 0; |
| 1338 | } |
| 1339 | } |
| 1340 | } |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1341 | } |
| 1342 | |
drh | 0a687d1 | 2008-07-08 14:52:07 +0000 | [diff] [blame] | 1343 | pColl = sqlite3FindCollSeq(db, (u8)enc2, zName, nName, 1); |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1344 | if( pColl ){ |
| 1345 | pColl->xCmp = xCompare; |
| 1346 | pColl->pUser = pCtx; |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 1347 | pColl->xDel = xDel; |
drh | 7d9bd4e | 2006-02-16 18:16:36 +0000 | [diff] [blame] | 1348 | pColl->enc = enc2 | (enc & SQLITE_UTF16_ALIGNED); |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1349 | } |
| 1350 | sqlite3Error(db, SQLITE_OK, 0); |
| 1351 | return SQLITE_OK; |
| 1352 | } |
| 1353 | |
| 1354 | |
danielk1977 | 6622cce | 2004-05-20 11:00:52 +0000 | [diff] [blame] | 1355 | /* |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1356 | ** This array defines hard upper bounds on limit values. The |
| 1357 | ** initializer must be kept in sync with the SQLITE_LIMIT_* |
| 1358 | ** #defines in sqlite3.h. |
| 1359 | */ |
drh | b1a6c3c | 2008-03-20 16:30:17 +0000 | [diff] [blame] | 1360 | static const int aHardLimit[] = { |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1361 | SQLITE_MAX_LENGTH, |
| 1362 | SQLITE_MAX_SQL_LENGTH, |
| 1363 | SQLITE_MAX_COLUMN, |
| 1364 | SQLITE_MAX_EXPR_DEPTH, |
| 1365 | SQLITE_MAX_COMPOUND_SELECT, |
| 1366 | SQLITE_MAX_VDBE_OP, |
| 1367 | SQLITE_MAX_FUNCTION_ARG, |
| 1368 | SQLITE_MAX_ATTACHED, |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1369 | SQLITE_MAX_LIKE_PATTERN_LENGTH, |
| 1370 | SQLITE_MAX_VARIABLE_NUMBER, |
| 1371 | }; |
| 1372 | |
| 1373 | /* |
| 1374 | ** Make sure the hard limits are set to reasonable values |
| 1375 | */ |
| 1376 | #if SQLITE_MAX_LENGTH<100 |
| 1377 | # error SQLITE_MAX_LENGTH must be at least 100 |
| 1378 | #endif |
| 1379 | #if SQLITE_MAX_SQL_LENGTH<100 |
| 1380 | # error SQLITE_MAX_SQL_LENGTH must be at least 100 |
| 1381 | #endif |
| 1382 | #if SQLITE_MAX_SQL_LENGTH>SQLITE_MAX_LENGTH |
| 1383 | # error SQLITE_MAX_SQL_LENGTH must not be greater than SQLITE_MAX_LENGTH |
| 1384 | #endif |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1385 | #if SQLITE_MAX_COMPOUND_SELECT<2 |
| 1386 | # error SQLITE_MAX_COMPOUND_SELECT must be at least 2 |
| 1387 | #endif |
| 1388 | #if SQLITE_MAX_VDBE_OP<40 |
| 1389 | # error SQLITE_MAX_VDBE_OP must be at least 40 |
| 1390 | #endif |
drh | e82f5d0 | 2008-10-07 19:53:14 +0000 | [diff] [blame] | 1391 | #if SQLITE_MAX_FUNCTION_ARG<0 || SQLITE_MAX_FUNCTION_ARG>1000 |
| 1392 | # error SQLITE_MAX_FUNCTION_ARG must be between 0 and 1000 |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1393 | #endif |
danielk1977 | 7b7e23b | 2008-08-20 16:21:12 +0000 | [diff] [blame] | 1394 | #if SQLITE_MAX_ATTACHED<0 || SQLITE_MAX_ATTACHED>30 |
| 1395 | # error SQLITE_MAX_ATTACHED must be between 0 and 30 |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1396 | #endif |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1397 | #if SQLITE_MAX_LIKE_PATTERN_LENGTH<1 |
| 1398 | # error SQLITE_MAX_LIKE_PATTERN_LENGTH must be at least 1 |
| 1399 | #endif |
| 1400 | #if SQLITE_MAX_VARIABLE_NUMBER<1 |
| 1401 | # error SQLITE_MAX_VARIABLE_NUMBER must be at least 1 |
| 1402 | #endif |
drh | 70a8ca3 | 2008-08-21 18:49:27 +0000 | [diff] [blame] | 1403 | #if SQLITE_MAX_COLUMN>32767 |
| 1404 | # error SQLITE_MAX_COLUMN must not exceed 32767 |
| 1405 | #endif |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1406 | |
| 1407 | |
| 1408 | /* |
| 1409 | ** Change the value of a limit. Report the old value. |
| 1410 | ** If an invalid limit index is supplied, report -1. |
| 1411 | ** Make no changes but still report the old value if the |
| 1412 | ** new limit is negative. |
| 1413 | ** |
| 1414 | ** A new lower limit does not shrink existing constructs. |
| 1415 | ** It merely prevents new constructs that exceed the limit |
| 1416 | ** from forming. |
| 1417 | */ |
| 1418 | int sqlite3_limit(sqlite3 *db, int limitId, int newLimit){ |
| 1419 | int oldLimit; |
drh | 521cc84 | 2008-04-15 02:36:33 +0000 | [diff] [blame] | 1420 | if( limitId<0 || limitId>=SQLITE_N_LIMIT ){ |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1421 | return -1; |
| 1422 | } |
| 1423 | oldLimit = db->aLimit[limitId]; |
| 1424 | if( newLimit>=0 ){ |
drh | f47ce56 | 2008-03-20 18:00:49 +0000 | [diff] [blame] | 1425 | if( newLimit>aHardLimit[limitId] ){ |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1426 | newLimit = aHardLimit[limitId]; |
| 1427 | } |
| 1428 | db->aLimit[limitId] = newLimit; |
| 1429 | } |
| 1430 | return oldLimit; |
| 1431 | } |
| 1432 | |
| 1433 | /* |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1434 | ** This routine does the work of opening a database on behalf of |
| 1435 | ** sqlite3_open() and sqlite3_open16(). The database filename "zFilename" |
drh | ee570fa | 2005-04-28 12:06:05 +0000 | [diff] [blame] | 1436 | ** is UTF-8 encoded. |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1437 | */ |
| 1438 | static int openDatabase( |
| 1439 | const char *zFilename, /* Database filename UTF-8 encoded */ |
drh | 605264d | 2007-08-21 15:13:19 +0000 | [diff] [blame] | 1440 | sqlite3 **ppDb, /* OUT: Returned database handle */ |
| 1441 | unsigned flags, /* Operational flags */ |
| 1442 | const char *zVfs /* Name of the VFS to use */ |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1443 | ){ |
| 1444 | sqlite3 *db; |
danielk1977 | da18423 | 2006-01-05 11:34:32 +0000 | [diff] [blame] | 1445 | int rc; |
drh | d64fe2f | 2005-08-28 17:00:23 +0000 | [diff] [blame] | 1446 | CollSeq *pColl; |
drh | 039963a | 2008-09-03 00:43:15 +0000 | [diff] [blame] | 1447 | int isThreadsafe; |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1448 | |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 1449 | #ifndef SQLITE_OMIT_AUTOINIT |
| 1450 | rc = sqlite3_initialize(); |
| 1451 | if( rc ) return rc; |
| 1452 | #endif |
| 1453 | |
drh | 039963a | 2008-09-03 00:43:15 +0000 | [diff] [blame] | 1454 | if( sqlite3GlobalConfig.bCoreMutex==0 ){ |
danielk1977 | 9a6284c | 2008-07-10 17:52:49 +0000 | [diff] [blame] | 1455 | isThreadsafe = 0; |
drh | 039963a | 2008-09-03 00:43:15 +0000 | [diff] [blame] | 1456 | }else if( flags & SQLITE_OPEN_NOMUTEX ){ |
| 1457 | isThreadsafe = 0; |
| 1458 | }else if( flags & SQLITE_OPEN_FULLMUTEX ){ |
| 1459 | isThreadsafe = 1; |
| 1460 | }else{ |
| 1461 | isThreadsafe = sqlite3GlobalConfig.bFullMutex; |
danielk1977 | 9a6284c | 2008-07-10 17:52:49 +0000 | [diff] [blame] | 1462 | } |
| 1463 | |
drh | a4267dc | 2008-02-19 15:20:44 +0000 | [diff] [blame] | 1464 | /* Remove harmful bits from the flags parameter */ |
| 1465 | flags &= ~( SQLITE_OPEN_DELETEONCLOSE | |
| 1466 | SQLITE_OPEN_MAIN_DB | |
| 1467 | SQLITE_OPEN_TEMP_DB | |
| 1468 | SQLITE_OPEN_TRANSIENT_DB | |
| 1469 | SQLITE_OPEN_MAIN_JOURNAL | |
| 1470 | SQLITE_OPEN_TEMP_JOURNAL | |
| 1471 | SQLITE_OPEN_SUBJOURNAL | |
danielk1977 | 9a6284c | 2008-07-10 17:52:49 +0000 | [diff] [blame] | 1472 | SQLITE_OPEN_MASTER_JOURNAL | |
drh | 039963a | 2008-09-03 00:43:15 +0000 | [diff] [blame] | 1473 | SQLITE_OPEN_NOMUTEX | |
| 1474 | SQLITE_OPEN_FULLMUTEX |
drh | a4267dc | 2008-02-19 15:20:44 +0000 | [diff] [blame] | 1475 | ); |
| 1476 | |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1477 | /* Allocate the sqlite data structure */ |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1478 | db = sqlite3MallocZero( sizeof(sqlite3) ); |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1479 | if( db==0 ) goto opendb_out; |
drh | 039963a | 2008-09-03 00:43:15 +0000 | [diff] [blame] | 1480 | if( isThreadsafe ){ |
danielk1977 | 59f8c08 | 2008-06-18 17:09:10 +0000 | [diff] [blame] | 1481 | db->mutex = sqlite3MutexAlloc(SQLITE_MUTEX_RECURSIVE); |
| 1482 | if( db->mutex==0 ){ |
| 1483 | sqlite3_free(db); |
| 1484 | db = 0; |
| 1485 | goto opendb_out; |
| 1486 | } |
drh | 605264d | 2007-08-21 15:13:19 +0000 | [diff] [blame] | 1487 | } |
drh | 2764170 | 2007-08-22 02:56:42 +0000 | [diff] [blame] | 1488 | sqlite3_mutex_enter(db->mutex); |
drh | 4ac285a | 2006-09-15 07:28:50 +0000 | [diff] [blame] | 1489 | db->errMask = 0xff; |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1490 | db->priorNewRowid = 0; |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1491 | db->nDb = 2; |
drh | 153c62c | 2007-08-24 03:51:33 +0000 | [diff] [blame] | 1492 | db->magic = SQLITE_MAGIC_BUSY; |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1493 | db->aDb = db->aDbStatic; |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 1494 | |
drh | bb4957f | 2008-03-20 14:03:29 +0000 | [diff] [blame] | 1495 | assert( sizeof(db->aLimit)==sizeof(aHardLimit) ); |
| 1496 | memcpy(db->aLimit, aHardLimit, sizeof(db->aLimit)); |
danielk1977 | 1d850a7 | 2004-05-31 08:26:49 +0000 | [diff] [blame] | 1497 | db->autoCommit = 1; |
drh | ddac25c | 2007-12-05 01:38:23 +0000 | [diff] [blame] | 1498 | db->nextAutovac = -1; |
danielk1977 | f653d78 | 2008-03-20 11:04:21 +0000 | [diff] [blame] | 1499 | db->nextPagesize = 0; |
drh | 76fe803 | 2006-07-11 14:17:51 +0000 | [diff] [blame] | 1500 | db->flags |= SQLITE_ShortColNames |
| 1501 | #if SQLITE_DEFAULT_FILE_FORMAT<4 |
| 1502 | | SQLITE_LegacyFileFmt |
| 1503 | #endif |
drh | 56424db | 2007-03-27 22:24:11 +0000 | [diff] [blame] | 1504 | #ifdef SQLITE_ENABLE_LOAD_EXTENSION |
| 1505 | | SQLITE_LoadExtension |
| 1506 | #endif |
drh | 76fe803 | 2006-07-11 14:17:51 +0000 | [diff] [blame] | 1507 | ; |
drh | 1b67f3c | 2008-10-10 17:41:28 +0000 | [diff] [blame] | 1508 | sqlite3HashInit(&db->aCollSeq, 0); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 1509 | #ifndef SQLITE_OMIT_VIRTUALTABLE |
drh | 1b67f3c | 2008-10-10 17:41:28 +0000 | [diff] [blame] | 1510 | sqlite3HashInit(&db->aModule, 0); |
drh | b9bb7c1 | 2006-06-11 23:41:55 +0000 | [diff] [blame] | 1511 | #endif |
danielk1977 | da18423 | 2006-01-05 11:34:32 +0000 | [diff] [blame] | 1512 | |
danielk1977 | 95c8a54 | 2007-09-01 06:51:27 +0000 | [diff] [blame] | 1513 | db->pVfs = sqlite3_vfs_find(zVfs); |
| 1514 | if( !db->pVfs ){ |
| 1515 | rc = SQLITE_ERROR; |
drh | afc9104 | 2008-02-21 02:09:45 +0000 | [diff] [blame] | 1516 | sqlite3Error(db, rc, "no such vfs: %s", zVfs); |
danielk1977 | 95c8a54 | 2007-09-01 06:51:27 +0000 | [diff] [blame] | 1517 | goto opendb_out; |
| 1518 | } |
| 1519 | |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 1520 | /* Add the default collation sequence BINARY. BINARY works for both UTF-8 |
| 1521 | ** and UTF-16, so add a version for each to avoid any unnecessary |
| 1522 | ** conversions. The only error that can occur here is a malloc() failure. |
| 1523 | */ |
drh | afc9104 | 2008-02-21 02:09:45 +0000 | [diff] [blame] | 1524 | createCollation(db, "BINARY", SQLITE_UTF8, 0, binCollFunc, 0); |
| 1525 | createCollation(db, "BINARY", SQLITE_UTF16BE, 0, binCollFunc, 0); |
| 1526 | createCollation(db, "BINARY", SQLITE_UTF16LE, 0, binCollFunc, 0); |
| 1527 | createCollation(db, "RTRIM", SQLITE_UTF8, (void*)1, binCollFunc, 0); |
drh | 77db4c0 | 2008-03-18 13:01:38 +0000 | [diff] [blame] | 1528 | if( db->mallocFailed ){ |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 1529 | goto opendb_out; |
| 1530 | } |
drh | 77db4c0 | 2008-03-18 13:01:38 +0000 | [diff] [blame] | 1531 | db->pDfltColl = sqlite3FindCollSeq(db, SQLITE_UTF8, "BINARY", 6, 0); |
| 1532 | assert( db->pDfltColl!=0 ); |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 1533 | |
| 1534 | /* Also add a UTF-8 case-insensitive collation sequence. */ |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 1535 | createCollation(db, "NOCASE", SQLITE_UTF8, 0, nocaseCollatingFunc, 0); |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 1536 | |
drh | d64fe2f | 2005-08-28 17:00:23 +0000 | [diff] [blame] | 1537 | /* Set flags on the built-in collating sequences */ |
| 1538 | db->pDfltColl->type = SQLITE_COLL_BINARY; |
| 1539 | pColl = sqlite3FindCollSeq(db, SQLITE_UTF8, "NOCASE", 6, 0); |
| 1540 | if( pColl ){ |
| 1541 | pColl->type = SQLITE_COLL_NOCASE; |
| 1542 | } |
| 1543 | |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1544 | /* Open the backend database driver */ |
drh | 33f4e02 | 2007-09-03 15:19:34 +0000 | [diff] [blame] | 1545 | db->openFlags = flags; |
| 1546 | rc = sqlite3BtreeFactory(db, zFilename, 0, SQLITE_DEFAULT_CACHE_SIZE, |
| 1547 | flags | SQLITE_OPEN_MAIN_DB, |
drh | c797d4d | 2007-05-08 01:08:49 +0000 | [diff] [blame] | 1548 | &db->aDb[0].pBt); |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1549 | if( rc!=SQLITE_OK ){ |
danielk1977 | 45e60aa | 2008-09-23 17:39:26 +0000 | [diff] [blame] | 1550 | if( rc==SQLITE_IOERR_NOMEM ){ |
| 1551 | rc = SQLITE_NOMEM; |
| 1552 | } |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1553 | sqlite3Error(db, rc, 0); |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1554 | goto opendb_out; |
| 1555 | } |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1556 | db->aDb[0].pSchema = sqlite3SchemaGet(db, db->aDb[0].pBt); |
| 1557 | db->aDb[1].pSchema = sqlite3SchemaGet(db, 0); |
danielk1977 | 14db266 | 2006-01-09 16:12:04 +0000 | [diff] [blame] | 1558 | |
drh | 03b808a | 2006-03-13 15:06:05 +0000 | [diff] [blame] | 1559 | |
danielk1977 | 53c0f74 | 2005-03-29 03:10:59 +0000 | [diff] [blame] | 1560 | /* The default safety_level for the main database is 'full'; for the temp |
| 1561 | ** database it is 'NONE'. This matches the pager layer defaults. |
| 1562 | */ |
| 1563 | db->aDb[0].zName = "main"; |
danielk1977 | 91cf71b | 2004-06-26 06:37:06 +0000 | [diff] [blame] | 1564 | db->aDb[0].safety_level = 3; |
danielk1977 | 53c0f74 | 2005-03-29 03:10:59 +0000 | [diff] [blame] | 1565 | #ifndef SQLITE_OMIT_TEMPDB |
| 1566 | db->aDb[1].zName = "temp"; |
danielk1977 | 91cf71b | 2004-06-26 06:37:06 +0000 | [diff] [blame] | 1567 | db->aDb[1].safety_level = 1; |
danielk1977 | 53c0f74 | 2005-03-29 03:10:59 +0000 | [diff] [blame] | 1568 | #endif |
| 1569 | |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 1570 | db->magic = SQLITE_MAGIC_OPEN; |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1571 | if( db->mallocFailed ){ |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 1572 | goto opendb_out; |
| 1573 | } |
| 1574 | |
danielk1977 | 8e22787 | 2004-06-07 07:52:17 +0000 | [diff] [blame] | 1575 | /* Register all built-in functions, but do not attempt to read the |
| 1576 | ** database schema yet. This is delayed until the first time the database |
| 1577 | ** is accessed. |
| 1578 | */ |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 1579 | sqlite3Error(db, SQLITE_OK, 0); |
| 1580 | sqlite3RegisterBuiltinFunctions(db); |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1581 | |
drh | 1409be6 | 2006-08-23 20:07:20 +0000 | [diff] [blame] | 1582 | /* Load automatic extensions - extensions that have been registered |
| 1583 | ** using the sqlite3_automatic_extension() API. |
| 1584 | */ |
drh | f533acc | 2006-12-19 18:57:11 +0000 | [diff] [blame] | 1585 | (void)sqlite3AutoLoadExtensions(db); |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 1586 | if( sqlite3_errcode(db)!=SQLITE_OK ){ |
| 1587 | goto opendb_out; |
| 1588 | } |
drh | 1409be6 | 2006-08-23 20:07:20 +0000 | [diff] [blame] | 1589 | |
drh | aa29c13 | 2006-09-02 13:58:06 +0000 | [diff] [blame] | 1590 | #ifdef SQLITE_ENABLE_FTS1 |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1591 | if( !db->mallocFailed ){ |
drh | aa29c13 | 2006-09-02 13:58:06 +0000 | [diff] [blame] | 1592 | extern int sqlite3Fts1Init(sqlite3*); |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 1593 | rc = sqlite3Fts1Init(db); |
drh | aa29c13 | 2006-09-02 13:58:06 +0000 | [diff] [blame] | 1594 | } |
| 1595 | #endif |
| 1596 | |
shess | a26cf57 | 2006-10-19 20:27:58 +0000 | [diff] [blame] | 1597 | #ifdef SQLITE_ENABLE_FTS2 |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1598 | if( !db->mallocFailed && rc==SQLITE_OK ){ |
shess | a26cf57 | 2006-10-19 20:27:58 +0000 | [diff] [blame] | 1599 | extern int sqlite3Fts2Init(sqlite3*); |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 1600 | rc = sqlite3Fts2Init(db); |
shess | a26cf57 | 2006-10-19 20:27:58 +0000 | [diff] [blame] | 1601 | } |
| 1602 | #endif |
| 1603 | |
shess | 69c4ae2 | 2007-08-20 17:37:47 +0000 | [diff] [blame] | 1604 | #ifdef SQLITE_ENABLE_FTS3 |
| 1605 | if( !db->mallocFailed && rc==SQLITE_OK ){ |
shess | 69c4ae2 | 2007-08-20 17:37:47 +0000 | [diff] [blame] | 1606 | rc = sqlite3Fts3Init(db); |
| 1607 | } |
| 1608 | #endif |
| 1609 | |
danielk1977 | 83852ac | 2007-05-06 16:04:11 +0000 | [diff] [blame] | 1610 | #ifdef SQLITE_ENABLE_ICU |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1611 | if( !db->mallocFailed && rc==SQLITE_OK ){ |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 1612 | rc = sqlite3IcuInit(db); |
danielk1977 | 83852ac | 2007-05-06 16:04:11 +0000 | [diff] [blame] | 1613 | } |
| 1614 | #endif |
danielk1977 | ebaecc1 | 2008-05-26 18:41:54 +0000 | [diff] [blame] | 1615 | |
| 1616 | #ifdef SQLITE_ENABLE_RTREE |
| 1617 | if( !db->mallocFailed && rc==SQLITE_OK){ |
danielk1977 | ebaecc1 | 2008-05-26 18:41:54 +0000 | [diff] [blame] | 1618 | rc = sqlite3RtreeInit(db); |
| 1619 | } |
| 1620 | #endif |
| 1621 | |
danielk1977 | 832a58a | 2007-06-22 15:21:15 +0000 | [diff] [blame] | 1622 | sqlite3Error(db, rc, 0); |
danielk1977 | 83852ac | 2007-05-06 16:04:11 +0000 | [diff] [blame] | 1623 | |
drh | 8fd5bd3 | 2007-04-02 16:40:37 +0000 | [diff] [blame] | 1624 | /* -DSQLITE_DEFAULT_LOCKING_MODE=1 makes EXCLUSIVE the default locking |
| 1625 | ** mode. -DSQLITE_DEFAULT_LOCKING_MODE=0 make NORMAL the default locking |
| 1626 | ** mode. Doing nothing at all also makes NORMAL the default. |
| 1627 | */ |
| 1628 | #ifdef SQLITE_DEFAULT_LOCKING_MODE |
| 1629 | db->dfltLockMode = SQLITE_DEFAULT_LOCKING_MODE; |
| 1630 | sqlite3PagerLockingMode(sqlite3BtreePager(db->aDb[0].pBt), |
| 1631 | SQLITE_DEFAULT_LOCKING_MODE); |
| 1632 | #endif |
| 1633 | |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 1634 | /* Enable the lookaside-malloc subsystem */ |
drh | 1b67f3c | 2008-10-10 17:41:28 +0000 | [diff] [blame] | 1635 | setupLookaside(db, 0, sqlite3GlobalConfig.szLookaside, |
| 1636 | sqlite3GlobalConfig.nLookaside); |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 1637 | |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1638 | opendb_out: |
drh | afc9104 | 2008-02-21 02:09:45 +0000 | [diff] [blame] | 1639 | if( db ){ |
danielk1977 | 075c23a | 2008-09-01 18:34:20 +0000 | [diff] [blame] | 1640 | assert( db->mutex!=0 || isThreadsafe==0 || sqlite3GlobalConfig.bFullMutex==0 ); |
drh | f3a65f7 | 2007-08-22 20:18:21 +0000 | [diff] [blame] | 1641 | sqlite3_mutex_leave(db->mutex); |
| 1642 | } |
danielk1977 | 59633ae | 2008-08-27 19:01:57 +0000 | [diff] [blame] | 1643 | rc = sqlite3_errcode(db); |
| 1644 | if( rc==SQLITE_NOMEM ){ |
danielk1977 | 7ddad96 | 2005-12-12 06:53:03 +0000 | [diff] [blame] | 1645 | sqlite3_close(db); |
| 1646 | db = 0; |
danielk1977 | 59633ae | 2008-08-27 19:01:57 +0000 | [diff] [blame] | 1647 | }else if( rc!=SQLITE_OK ){ |
| 1648 | db->magic = SQLITE_MAGIC_SICK; |
danielk1977 | 1307393 | 2004-06-30 11:54:06 +0000 | [diff] [blame] | 1649 | } |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1650 | *ppDb = db; |
danielk1977 | 54f0198 | 2006-01-18 15:25:17 +0000 | [diff] [blame] | 1651 | return sqlite3ApiExit(0, rc); |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1652 | } |
| 1653 | |
| 1654 | /* |
| 1655 | ** Open a new database handle. |
| 1656 | */ |
danielk1977 | 8029086 | 2004-05-22 09:21:21 +0000 | [diff] [blame] | 1657 | int sqlite3_open( |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1658 | const char *zFilename, |
danielk1977 | 4f057f9 | 2004-06-08 00:02:33 +0000 | [diff] [blame] | 1659 | sqlite3 **ppDb |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1660 | ){ |
drh | 605264d | 2007-08-21 15:13:19 +0000 | [diff] [blame] | 1661 | return openDatabase(zFilename, ppDb, |
| 1662 | SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, 0); |
| 1663 | } |
| 1664 | int sqlite3_open_v2( |
drh | 428e282 | 2007-08-30 16:23:19 +0000 | [diff] [blame] | 1665 | const char *filename, /* Database filename (UTF-8) */ |
drh | 605264d | 2007-08-21 15:13:19 +0000 | [diff] [blame] | 1666 | sqlite3 **ppDb, /* OUT: SQLite db handle */ |
| 1667 | int flags, /* Flags */ |
| 1668 | const char *zVfs /* Name of VFS module to use */ |
| 1669 | ){ |
| 1670 | return openDatabase(filename, ppDb, flags, zVfs); |
danielk1977 | 83ab5a8 | 2004-05-21 11:39:05 +0000 | [diff] [blame] | 1671 | } |
| 1672 | |
drh | 6c62608 | 2004-11-14 21:56:29 +0000 | [diff] [blame] | 1673 | #ifndef SQLITE_OMIT_UTF16 |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1674 | /* |
| 1675 | ** Open a new database handle. |
| 1676 | */ |
| 1677 | int sqlite3_open16( |
| 1678 | const void *zFilename, |
danielk1977 | 4f057f9 | 2004-06-08 00:02:33 +0000 | [diff] [blame] | 1679 | sqlite3 **ppDb |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1680 | ){ |
danielk1977 | bfd6cce | 2004-06-18 04:24:54 +0000 | [diff] [blame] | 1681 | char const *zFilename8; /* zFilename encoded in UTF-8 instead of UTF-16 */ |
danielk1977 | bfd6cce | 2004-06-18 04:24:54 +0000 | [diff] [blame] | 1682 | sqlite3_value *pVal; |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 1683 | int rc; |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1684 | |
danielk1977 | 7ddad96 | 2005-12-12 06:53:03 +0000 | [diff] [blame] | 1685 | assert( zFilename ); |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1686 | assert( ppDb ); |
danielk1977 | bfd6cce | 2004-06-18 04:24:54 +0000 | [diff] [blame] | 1687 | *ppDb = 0; |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 1688 | #ifndef SQLITE_OMIT_AUTOINIT |
| 1689 | rc = sqlite3_initialize(); |
| 1690 | if( rc ) return rc; |
| 1691 | #endif |
danielk1977 | 1e53695 | 2007-08-16 10:09:01 +0000 | [diff] [blame] | 1692 | pVal = sqlite3ValueNew(0); |
drh | b21c8cd | 2007-08-21 19:33:56 +0000 | [diff] [blame] | 1693 | sqlite3ValueSetStr(pVal, -1, zFilename, SQLITE_UTF16NATIVE, SQLITE_STATIC); |
| 1694 | zFilename8 = sqlite3ValueText(pVal, SQLITE_UTF8); |
danielk1977 | bfd6cce | 2004-06-18 04:24:54 +0000 | [diff] [blame] | 1695 | if( zFilename8 ){ |
drh | 605264d | 2007-08-21 15:13:19 +0000 | [diff] [blame] | 1696 | rc = openDatabase(zFilename8, ppDb, |
| 1697 | SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, 0); |
drh | afc9104 | 2008-02-21 02:09:45 +0000 | [diff] [blame] | 1698 | assert( *ppDb || rc==SQLITE_NOMEM ); |
danielk1977 | f51bf48 | 2008-04-28 16:19:35 +0000 | [diff] [blame] | 1699 | if( rc==SQLITE_OK && !DbHasProperty(*ppDb, 0, DB_SchemaLoaded) ){ |
danielk1977 | fb103a8 | 2008-04-03 16:28:24 +0000 | [diff] [blame] | 1700 | ENC(*ppDb) = SQLITE_UTF16NATIVE; |
danielk1977 | bfd6cce | 2004-06-18 04:24:54 +0000 | [diff] [blame] | 1701 | } |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 1702 | }else{ |
| 1703 | rc = SQLITE_NOMEM; |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1704 | } |
danielk1977 | 7ddad96 | 2005-12-12 06:53:03 +0000 | [diff] [blame] | 1705 | sqlite3ValueFree(pVal); |
danielk1977 | 8e22787 | 2004-06-07 07:52:17 +0000 | [diff] [blame] | 1706 | |
danielk1977 | 54f0198 | 2006-01-18 15:25:17 +0000 | [diff] [blame] | 1707 | return sqlite3ApiExit(0, rc); |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1708 | } |
drh | 6c62608 | 2004-11-14 21:56:29 +0000 | [diff] [blame] | 1709 | #endif /* SQLITE_OMIT_UTF16 */ |
danielk1977 | 4ad1713 | 2004-05-21 01:47:26 +0000 | [diff] [blame] | 1710 | |
danielk1977 | 106bb23 | 2004-05-21 10:08:53 +0000 | [diff] [blame] | 1711 | /* |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1712 | ** Register a new collation sequence with the database handle db. |
| 1713 | */ |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 1714 | int sqlite3_create_collation( |
| 1715 | sqlite3* db, |
| 1716 | const char *zName, |
danielk1977 | 466be56 | 2004-06-10 02:16:01 +0000 | [diff] [blame] | 1717 | int enc, |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 1718 | void* pCtx, |
| 1719 | int(*xCompare)(void*,int,const void*,int,const void*) |
| 1720 | ){ |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1721 | int rc; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1722 | sqlite3_mutex_enter(db->mutex); |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1723 | assert( !db->mallocFailed ); |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 1724 | rc = createCollation(db, zName, enc, pCtx, xCompare, 0); |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1725 | rc = sqlite3ApiExit(db, rc); |
| 1726 | sqlite3_mutex_leave(db->mutex); |
| 1727 | return rc; |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 1728 | } |
| 1729 | |
| 1730 | /* |
| 1731 | ** Register a new collation sequence with the database handle db. |
| 1732 | */ |
danielk1977 | a393c03 | 2007-05-07 14:58:53 +0000 | [diff] [blame] | 1733 | int sqlite3_create_collation_v2( |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 1734 | sqlite3* db, |
| 1735 | const char *zName, |
| 1736 | int enc, |
| 1737 | void* pCtx, |
| 1738 | int(*xCompare)(void*,int,const void*,int,const void*), |
| 1739 | void(*xDel)(void*) |
| 1740 | ){ |
| 1741 | int rc; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1742 | sqlite3_mutex_enter(db->mutex); |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1743 | assert( !db->mallocFailed ); |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 1744 | rc = createCollation(db, zName, enc, pCtx, xCompare, xDel); |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1745 | rc = sqlite3ApiExit(db, rc); |
| 1746 | sqlite3_mutex_leave(db->mutex); |
| 1747 | return rc; |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 1748 | } |
| 1749 | |
drh | 6c62608 | 2004-11-14 21:56:29 +0000 | [diff] [blame] | 1750 | #ifndef SQLITE_OMIT_UTF16 |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1751 | /* |
| 1752 | ** Register a new collation sequence with the database handle db. |
| 1753 | */ |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 1754 | int sqlite3_create_collation16( |
| 1755 | sqlite3* db, |
mihailim | bda2e62 | 2008-06-23 11:23:14 +0000 | [diff] [blame] | 1756 | const void *zName, |
danielk1977 | 466be56 | 2004-06-10 02:16:01 +0000 | [diff] [blame] | 1757 | int enc, |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 1758 | void* pCtx, |
| 1759 | int(*xCompare)(void*,int,const void*,int,const void*) |
| 1760 | ){ |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1761 | int rc = SQLITE_OK; |
drh | 01495b9 | 2008-01-23 12:52:40 +0000 | [diff] [blame] | 1762 | char *zName8; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1763 | sqlite3_mutex_enter(db->mutex); |
drh | 1743575 | 2007-08-16 04:30:38 +0000 | [diff] [blame] | 1764 | assert( !db->mallocFailed ); |
danielk1977 | 1e53695 | 2007-08-16 10:09:01 +0000 | [diff] [blame] | 1765 | zName8 = sqlite3Utf16to8(db, zName, -1); |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1766 | if( zName8 ){ |
danielk1977 | a9808b3 | 2007-05-07 09:32:45 +0000 | [diff] [blame] | 1767 | rc = createCollation(db, zName8, enc, pCtx, xCompare, 0); |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 1768 | sqlite3DbFree(db, zName8); |
danielk1977 | 9a30cf6 | 2006-01-18 04:26:07 +0000 | [diff] [blame] | 1769 | } |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1770 | rc = sqlite3ApiExit(db, rc); |
| 1771 | sqlite3_mutex_leave(db->mutex); |
| 1772 | return rc; |
danielk1977 | 0202b29 | 2004-06-09 09:55:16 +0000 | [diff] [blame] | 1773 | } |
drh | 6c62608 | 2004-11-14 21:56:29 +0000 | [diff] [blame] | 1774 | #endif /* SQLITE_OMIT_UTF16 */ |
danielk1977 | 7cedc8d | 2004-06-10 10:50:08 +0000 | [diff] [blame] | 1775 | |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1776 | /* |
| 1777 | ** Register a collation sequence factory callback with the database handle |
| 1778 | ** db. Replace any previously installed collation sequence factory. |
| 1779 | */ |
danielk1977 | 7cedc8d | 2004-06-10 10:50:08 +0000 | [diff] [blame] | 1780 | int sqlite3_collation_needed( |
| 1781 | sqlite3 *db, |
| 1782 | void *pCollNeededArg, |
| 1783 | void(*xCollNeeded)(void*,sqlite3*,int eTextRep,const char*) |
| 1784 | ){ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1785 | sqlite3_mutex_enter(db->mutex); |
danielk1977 | 7cedc8d | 2004-06-10 10:50:08 +0000 | [diff] [blame] | 1786 | db->xCollNeeded = xCollNeeded; |
| 1787 | db->xCollNeeded16 = 0; |
| 1788 | db->pCollNeededArg = pCollNeededArg; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1789 | sqlite3_mutex_leave(db->mutex); |
danielk1977 | 7cedc8d | 2004-06-10 10:50:08 +0000 | [diff] [blame] | 1790 | return SQLITE_OK; |
| 1791 | } |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1792 | |
drh | 6c62608 | 2004-11-14 21:56:29 +0000 | [diff] [blame] | 1793 | #ifndef SQLITE_OMIT_UTF16 |
danielk1977 | d812336 | 2004-06-12 09:25:12 +0000 | [diff] [blame] | 1794 | /* |
| 1795 | ** Register a collation sequence factory callback with the database handle |
| 1796 | ** db. Replace any previously installed collation sequence factory. |
| 1797 | */ |
danielk1977 | 7cedc8d | 2004-06-10 10:50:08 +0000 | [diff] [blame] | 1798 | int sqlite3_collation_needed16( |
| 1799 | sqlite3 *db, |
| 1800 | void *pCollNeededArg, |
| 1801 | void(*xCollNeeded16)(void*,sqlite3*,int eTextRep,const void*) |
| 1802 | ){ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1803 | sqlite3_mutex_enter(db->mutex); |
danielk1977 | 7cedc8d | 2004-06-10 10:50:08 +0000 | [diff] [blame] | 1804 | db->xCollNeeded = 0; |
| 1805 | db->xCollNeeded16 = xCollNeeded16; |
| 1806 | db->pCollNeededArg = pCollNeededArg; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1807 | sqlite3_mutex_leave(db->mutex); |
danielk1977 | 7cedc8d | 2004-06-10 10:50:08 +0000 | [diff] [blame] | 1808 | return SQLITE_OK; |
| 1809 | } |
drh | 6c62608 | 2004-11-14 21:56:29 +0000 | [diff] [blame] | 1810 | #endif /* SQLITE_OMIT_UTF16 */ |
danielk1977 | 6b456a2 | 2005-03-21 04:04:02 +0000 | [diff] [blame] | 1811 | |
| 1812 | #ifndef SQLITE_OMIT_GLOBALRECOVER |
shane | eec556d | 2008-10-12 00:27:53 +0000 | [diff] [blame] | 1813 | #ifndef SQLITE_OMIT_DEPRECATED |
danielk1977 | 6b456a2 | 2005-03-21 04:04:02 +0000 | [diff] [blame] | 1814 | /* |
danielk1977 | 7ddad96 | 2005-12-12 06:53:03 +0000 | [diff] [blame] | 1815 | ** This function is now an anachronism. It used to be used to recover from a |
| 1816 | ** malloc() failure, but SQLite now does this automatically. |
danielk1977 | 6b456a2 | 2005-03-21 04:04:02 +0000 | [diff] [blame] | 1817 | */ |
drh | 7d97efb | 2007-10-12 19:35:48 +0000 | [diff] [blame] | 1818 | int sqlite3_global_recover(void){ |
danielk1977 | 261919c | 2005-12-06 12:52:59 +0000 | [diff] [blame] | 1819 | return SQLITE_OK; |
danielk1977 | 6b456a2 | 2005-03-21 04:04:02 +0000 | [diff] [blame] | 1820 | } |
| 1821 | #endif |
shane | eec556d | 2008-10-12 00:27:53 +0000 | [diff] [blame] | 1822 | #endif |
drh | 3e1d8e6 | 2005-05-26 16:23:34 +0000 | [diff] [blame] | 1823 | |
| 1824 | /* |
| 1825 | ** Test to see whether or not the database connection is in autocommit |
| 1826 | ** mode. Return TRUE if it is and FALSE if not. Autocommit mode is on |
| 1827 | ** by default. Autocommit is disabled by a BEGIN statement and reenabled |
| 1828 | ** by the next COMMIT or ROLLBACK. |
| 1829 | ** |
| 1830 | ******* THIS IS AN EXPERIMENTAL API AND IS SUBJECT TO CHANGE ****** |
| 1831 | */ |
| 1832 | int sqlite3_get_autocommit(sqlite3 *db){ |
| 1833 | return db->autoCommit; |
| 1834 | } |
drh | 4928570 | 2005-09-17 15:20:26 +0000 | [diff] [blame] | 1835 | |
| 1836 | #ifdef SQLITE_DEBUG |
| 1837 | /* |
| 1838 | ** The following routine is subtituted for constant SQLITE_CORRUPT in |
| 1839 | ** debugging builds. This provides a way to set a breakpoint for when |
| 1840 | ** corruption is first detected. |
| 1841 | */ |
| 1842 | int sqlite3Corrupt(void){ |
| 1843 | return SQLITE_CORRUPT; |
| 1844 | } |
| 1845 | #endif |
drh | 7c1817e | 2006-01-10 13:58:48 +0000 | [diff] [blame] | 1846 | |
shane | eec556d | 2008-10-12 00:27:53 +0000 | [diff] [blame] | 1847 | #ifndef SQLITE_OMIT_DEPRECATED |
drh | 6f7adc8 | 2006-01-11 21:41:20 +0000 | [diff] [blame] | 1848 | /* |
| 1849 | ** This is a convenience routine that makes sure that all thread-specific |
| 1850 | ** data for this thread has been deallocated. |
drh | dce8bdb | 2007-08-16 13:01:44 +0000 | [diff] [blame] | 1851 | ** |
| 1852 | ** SQLite no longer uses thread-specific data so this routine is now a |
| 1853 | ** no-op. It is retained for historical compatibility. |
drh | 6f7adc8 | 2006-01-11 21:41:20 +0000 | [diff] [blame] | 1854 | */ |
| 1855 | void sqlite3_thread_cleanup(void){ |
drh | 6f7adc8 | 2006-01-11 21:41:20 +0000 | [diff] [blame] | 1856 | } |
shane | eec556d | 2008-10-12 00:27:53 +0000 | [diff] [blame] | 1857 | #endif |
danielk1977 | deb802c | 2006-02-09 13:43:28 +0000 | [diff] [blame] | 1858 | |
| 1859 | /* |
| 1860 | ** Return meta information about a specific column of a database table. |
| 1861 | ** See comment in sqlite3.h (sqlite.h.in) for details. |
| 1862 | */ |
| 1863 | #ifdef SQLITE_ENABLE_COLUMN_METADATA |
| 1864 | int sqlite3_table_column_metadata( |
| 1865 | sqlite3 *db, /* Connection handle */ |
| 1866 | const char *zDbName, /* Database name or NULL */ |
| 1867 | const char *zTableName, /* Table name */ |
| 1868 | const char *zColumnName, /* Column name */ |
| 1869 | char const **pzDataType, /* OUTPUT: Declared data type */ |
| 1870 | char const **pzCollSeq, /* OUTPUT: Collation sequence name */ |
| 1871 | int *pNotNull, /* OUTPUT: True if NOT NULL constraint exists */ |
| 1872 | int *pPrimaryKey, /* OUTPUT: True if column part of PK */ |
drh | 9be0716 | 2008-06-16 20:51:15 +0000 | [diff] [blame] | 1873 | int *pAutoinc /* OUTPUT: True if column is auto-increment */ |
danielk1977 | deb802c | 2006-02-09 13:43:28 +0000 | [diff] [blame] | 1874 | ){ |
| 1875 | int rc; |
| 1876 | char *zErrMsg = 0; |
| 1877 | Table *pTab = 0; |
| 1878 | Column *pCol = 0; |
| 1879 | int iCol; |
| 1880 | |
| 1881 | char const *zDataType = 0; |
| 1882 | char const *zCollSeq = 0; |
| 1883 | int notnull = 0; |
| 1884 | int primarykey = 0; |
| 1885 | int autoinc = 0; |
| 1886 | |
| 1887 | /* Ensure the database schema has been loaded */ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1888 | sqlite3_mutex_enter(db->mutex); |
drh | a0af99f | 2008-04-16 00:49:12 +0000 | [diff] [blame] | 1889 | (void)sqlite3SafetyOn(db); |
drh | 3cb3edc | 2008-03-07 21:37:19 +0000 | [diff] [blame] | 1890 | sqlite3BtreeEnterAll(db); |
danielk1977 | deb802c | 2006-02-09 13:43:28 +0000 | [diff] [blame] | 1891 | rc = sqlite3Init(db, &zErrMsg); |
drh | 3cb3edc | 2008-03-07 21:37:19 +0000 | [diff] [blame] | 1892 | sqlite3BtreeLeaveAll(db); |
danielk1977 | deb802c | 2006-02-09 13:43:28 +0000 | [diff] [blame] | 1893 | if( SQLITE_OK!=rc ){ |
| 1894 | goto error_out; |
| 1895 | } |
| 1896 | |
| 1897 | /* Locate the table in question */ |
| 1898 | pTab = sqlite3FindTable(db, zTableName, zDbName); |
| 1899 | if( !pTab || pTab->pSelect ){ |
| 1900 | pTab = 0; |
| 1901 | goto error_out; |
| 1902 | } |
| 1903 | |
| 1904 | /* Find the column for which info is requested */ |
| 1905 | if( sqlite3IsRowid(zColumnName) ){ |
| 1906 | iCol = pTab->iPKey; |
| 1907 | if( iCol>=0 ){ |
| 1908 | pCol = &pTab->aCol[iCol]; |
| 1909 | } |
| 1910 | }else{ |
| 1911 | for(iCol=0; iCol<pTab->nCol; iCol++){ |
| 1912 | pCol = &pTab->aCol[iCol]; |
| 1913 | if( 0==sqlite3StrICmp(pCol->zName, zColumnName) ){ |
| 1914 | break; |
| 1915 | } |
| 1916 | } |
| 1917 | if( iCol==pTab->nCol ){ |
| 1918 | pTab = 0; |
| 1919 | goto error_out; |
| 1920 | } |
| 1921 | } |
| 1922 | |
| 1923 | /* The following block stores the meta information that will be returned |
| 1924 | ** to the caller in local variables zDataType, zCollSeq, notnull, primarykey |
| 1925 | ** and autoinc. At this point there are two possibilities: |
| 1926 | ** |
| 1927 | ** 1. The specified column name was rowid", "oid" or "_rowid_" |
| 1928 | ** and there is no explicitly declared IPK column. |
| 1929 | ** |
| 1930 | ** 2. The table is not a view and the column name identified an |
| 1931 | ** explicitly declared column. Copy meta information from *pCol. |
| 1932 | */ |
| 1933 | if( pCol ){ |
| 1934 | zDataType = pCol->zType; |
| 1935 | zCollSeq = pCol->zColl; |
drh | 9be0716 | 2008-06-16 20:51:15 +0000 | [diff] [blame] | 1936 | notnull = pCol->notNull!=0; |
| 1937 | primarykey = pCol->isPrimKey!=0; |
drh | 7d10d5a | 2008-08-20 16:35:10 +0000 | [diff] [blame] | 1938 | autoinc = pTab->iPKey==iCol && (pTab->tabFlags & TF_Autoincrement)!=0; |
danielk1977 | deb802c | 2006-02-09 13:43:28 +0000 | [diff] [blame] | 1939 | }else{ |
| 1940 | zDataType = "INTEGER"; |
| 1941 | primarykey = 1; |
| 1942 | } |
| 1943 | if( !zCollSeq ){ |
| 1944 | zCollSeq = "BINARY"; |
| 1945 | } |
| 1946 | |
| 1947 | error_out: |
drh | 01495b9 | 2008-01-23 12:52:40 +0000 | [diff] [blame] | 1948 | (void)sqlite3SafetyOff(db); |
danielk1977 | deb802c | 2006-02-09 13:43:28 +0000 | [diff] [blame] | 1949 | |
| 1950 | /* Whether the function call succeeded or failed, set the output parameters |
| 1951 | ** to whatever their local counterparts contain. If an error did occur, |
| 1952 | ** this has the effect of zeroing all output parameters. |
| 1953 | */ |
| 1954 | if( pzDataType ) *pzDataType = zDataType; |
| 1955 | if( pzCollSeq ) *pzCollSeq = zCollSeq; |
| 1956 | if( pNotNull ) *pNotNull = notnull; |
| 1957 | if( pPrimaryKey ) *pPrimaryKey = primarykey; |
| 1958 | if( pAutoinc ) *pAutoinc = autoinc; |
| 1959 | |
| 1960 | if( SQLITE_OK==rc && !pTab ){ |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 1961 | sqlite3DbFree(db, zErrMsg); |
drh | 118640b | 2008-07-16 14:02:32 +0000 | [diff] [blame] | 1962 | zErrMsg = sqlite3MPrintf(db, "no such table column: %s.%s", zTableName, |
drh | f089aa4 | 2008-07-08 19:34:06 +0000 | [diff] [blame] | 1963 | zColumnName); |
danielk1977 | deb802c | 2006-02-09 13:43:28 +0000 | [diff] [blame] | 1964 | rc = SQLITE_ERROR; |
| 1965 | } |
| 1966 | sqlite3Error(db, rc, (zErrMsg?"%s":0), zErrMsg); |
drh | 633e6d5 | 2008-07-28 19:34:53 +0000 | [diff] [blame] | 1967 | sqlite3DbFree(db, zErrMsg); |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1968 | rc = sqlite3ApiExit(db, rc); |
| 1969 | sqlite3_mutex_leave(db->mutex); |
drh | f9cb7f5 | 2006-06-27 20:06:44 +0000 | [diff] [blame] | 1970 | return rc; |
| 1971 | } |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1972 | #endif |
drh | f9cb7f5 | 2006-06-27 20:06:44 +0000 | [diff] [blame] | 1973 | |
| 1974 | /* |
| 1975 | ** Sleep for a little while. Return the amount of time slept. |
| 1976 | */ |
| 1977 | int sqlite3_sleep(int ms){ |
danielk1977 | b4b4741 | 2007-08-17 15:53:36 +0000 | [diff] [blame] | 1978 | sqlite3_vfs *pVfs; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1979 | int rc; |
drh | d677b3d | 2007-08-20 22:48:41 +0000 | [diff] [blame] | 1980 | pVfs = sqlite3_vfs_find(0); |
drh | 40257ff | 2008-06-13 18:24:27 +0000 | [diff] [blame] | 1981 | if( pVfs==0 ) return 0; |
danielk1977 | fee2d25 | 2007-08-18 10:59:19 +0000 | [diff] [blame] | 1982 | |
| 1983 | /* This function works in milliseconds, but the underlying OsSleep() |
| 1984 | ** API uses microseconds. Hence the 1000's. |
| 1985 | */ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1986 | rc = (sqlite3OsSleep(pVfs, 1000*ms)/1000); |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1987 | return rc; |
drh | f9cb7f5 | 2006-06-27 20:06:44 +0000 | [diff] [blame] | 1988 | } |
drh | 4ac285a | 2006-09-15 07:28:50 +0000 | [diff] [blame] | 1989 | |
| 1990 | /* |
| 1991 | ** Enable or disable the extended result codes. |
| 1992 | */ |
| 1993 | int sqlite3_extended_result_codes(sqlite3 *db, int onoff){ |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1994 | sqlite3_mutex_enter(db->mutex); |
drh | 4ac285a | 2006-09-15 07:28:50 +0000 | [diff] [blame] | 1995 | db->errMask = onoff ? 0xffffffff : 0xff; |
drh | e30f442 | 2007-08-21 16:15:55 +0000 | [diff] [blame] | 1996 | sqlite3_mutex_leave(db->mutex); |
drh | 4ac285a | 2006-09-15 07:28:50 +0000 | [diff] [blame] | 1997 | return SQLITE_OK; |
| 1998 | } |
drh | cc6bb3e | 2007-08-31 16:11:35 +0000 | [diff] [blame] | 1999 | |
| 2000 | /* |
| 2001 | ** Invoke the xFileControl method on a particular database. |
| 2002 | */ |
| 2003 | int sqlite3_file_control(sqlite3 *db, const char *zDbName, int op, void *pArg){ |
| 2004 | int rc = SQLITE_ERROR; |
| 2005 | int iDb; |
| 2006 | sqlite3_mutex_enter(db->mutex); |
| 2007 | if( zDbName==0 ){ |
| 2008 | iDb = 0; |
| 2009 | }else{ |
| 2010 | for(iDb=0; iDb<db->nDb; iDb++){ |
| 2011 | if( strcmp(db->aDb[iDb].zName, zDbName)==0 ) break; |
| 2012 | } |
| 2013 | } |
| 2014 | if( iDb<db->nDb ){ |
| 2015 | Btree *pBtree = db->aDb[iDb].pBt; |
| 2016 | if( pBtree ){ |
| 2017 | Pager *pPager; |
drh | 5517625 | 2008-01-22 14:50:16 +0000 | [diff] [blame] | 2018 | sqlite3_file *fd; |
drh | cc6bb3e | 2007-08-31 16:11:35 +0000 | [diff] [blame] | 2019 | sqlite3BtreeEnter(pBtree); |
| 2020 | pPager = sqlite3BtreePager(pBtree); |
drh | 5517625 | 2008-01-22 14:50:16 +0000 | [diff] [blame] | 2021 | assert( pPager!=0 ); |
| 2022 | fd = sqlite3PagerFile(pPager); |
| 2023 | assert( fd!=0 ); |
| 2024 | if( fd->pMethods ){ |
| 2025 | rc = sqlite3OsFileControl(fd, op, pArg); |
drh | cc6bb3e | 2007-08-31 16:11:35 +0000 | [diff] [blame] | 2026 | } |
| 2027 | sqlite3BtreeLeave(pBtree); |
| 2028 | } |
| 2029 | } |
| 2030 | sqlite3_mutex_leave(db->mutex); |
| 2031 | return rc; |
| 2032 | } |
drh | ed13d98 | 2008-01-31 14:43:24 +0000 | [diff] [blame] | 2033 | |
| 2034 | /* |
| 2035 | ** Interface to the testing logic. |
| 2036 | */ |
| 2037 | int sqlite3_test_control(int op, ...){ |
drh | ed13d98 | 2008-01-31 14:43:24 +0000 | [diff] [blame] | 2038 | int rc = 0; |
drh | 3088d59 | 2008-03-21 16:45:47 +0000 | [diff] [blame] | 2039 | #ifndef SQLITE_OMIT_BUILTIN_TEST |
drh | 2fa1868 | 2008-03-19 14:15:34 +0000 | [diff] [blame] | 2040 | va_list ap; |
drh | ed13d98 | 2008-01-31 14:43:24 +0000 | [diff] [blame] | 2041 | va_start(ap, op); |
| 2042 | switch( op ){ |
danielk1977 | d09414c | 2008-06-19 18:17:49 +0000 | [diff] [blame] | 2043 | |
| 2044 | /* |
drh | 984bfaa | 2008-03-19 16:08:53 +0000 | [diff] [blame] | 2045 | ** Save the current state of the PRNG. |
| 2046 | */ |
drh | 2fa1868 | 2008-03-19 14:15:34 +0000 | [diff] [blame] | 2047 | case SQLITE_TESTCTRL_PRNG_SAVE: { |
| 2048 | sqlite3PrngSaveState(); |
| 2049 | break; |
| 2050 | } |
drh | 984bfaa | 2008-03-19 16:08:53 +0000 | [diff] [blame] | 2051 | |
| 2052 | /* |
| 2053 | ** Restore the state of the PRNG to the last state saved using |
| 2054 | ** PRNG_SAVE. If PRNG_SAVE has never before been called, then |
| 2055 | ** this verb acts like PRNG_RESET. |
| 2056 | */ |
drh | 2fa1868 | 2008-03-19 14:15:34 +0000 | [diff] [blame] | 2057 | case SQLITE_TESTCTRL_PRNG_RESTORE: { |
| 2058 | sqlite3PrngRestoreState(); |
| 2059 | break; |
| 2060 | } |
drh | 984bfaa | 2008-03-19 16:08:53 +0000 | [diff] [blame] | 2061 | |
| 2062 | /* |
| 2063 | ** Reset the PRNG back to its uninitialized state. The next call |
| 2064 | ** to sqlite3_randomness() will reseed the PRNG using a single call |
| 2065 | ** to the xRandomness method of the default VFS. |
| 2066 | */ |
drh | 2fa1868 | 2008-03-19 14:15:34 +0000 | [diff] [blame] | 2067 | case SQLITE_TESTCTRL_PRNG_RESET: { |
| 2068 | sqlite3PrngResetState(); |
| 2069 | break; |
| 2070 | } |
drh | 3088d59 | 2008-03-21 16:45:47 +0000 | [diff] [blame] | 2071 | |
| 2072 | /* |
| 2073 | ** sqlite3_test_control(BITVEC_TEST, size, program) |
| 2074 | ** |
| 2075 | ** Run a test against a Bitvec object of size. The program argument |
| 2076 | ** is an array of integers that defines the test. Return -1 on a |
| 2077 | ** memory allocation error, 0 on success, or non-zero for an error. |
| 2078 | ** See the sqlite3BitvecBuiltinTest() for additional information. |
| 2079 | */ |
| 2080 | case SQLITE_TESTCTRL_BITVEC_TEST: { |
| 2081 | int sz = va_arg(ap, int); |
| 2082 | int *aProg = va_arg(ap, int*); |
| 2083 | rc = sqlite3BitvecBuiltinTest(sz, aProg); |
| 2084 | break; |
| 2085 | } |
danielk1977 | 2d1d86f | 2008-06-20 14:59:51 +0000 | [diff] [blame] | 2086 | |
| 2087 | /* |
| 2088 | ** sqlite3_test_control(BENIGN_MALLOC_HOOKS, xBegin, xEnd) |
| 2089 | ** |
| 2090 | ** Register hooks to call to indicate which malloc() failures |
| 2091 | ** are benign. |
| 2092 | */ |
| 2093 | case SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS: { |
danielk1977 | ca02679 | 2008-06-23 14:15:52 +0000 | [diff] [blame] | 2094 | typedef void (*void_function)(void); |
| 2095 | void_function xBenignBegin; |
| 2096 | void_function xBenignEnd; |
| 2097 | xBenignBegin = va_arg(ap, void_function); |
| 2098 | xBenignEnd = va_arg(ap, void_function); |
danielk1977 | 2d1d86f | 2008-06-20 14:59:51 +0000 | [diff] [blame] | 2099 | sqlite3BenignMallocHooks(xBenignBegin, xBenignEnd); |
| 2100 | break; |
| 2101 | } |
drh | ed13d98 | 2008-01-31 14:43:24 +0000 | [diff] [blame] | 2102 | } |
| 2103 | va_end(ap); |
drh | 3088d59 | 2008-03-21 16:45:47 +0000 | [diff] [blame] | 2104 | #endif /* SQLITE_OMIT_BUILTIN_TEST */ |
danielk1977 | 7c36d07 | 2008-01-31 15:31:01 +0000 | [diff] [blame] | 2105 | return rc; |
drh | ed13d98 | 2008-01-31 14:43:24 +0000 | [diff] [blame] | 2106 | } |