xref: /sqlite-3.40.0/src/loadext.c (revision 02267cc2)
1 /*
2 ** 2006 June 7
3 **
4 ** The author disclaims copyright to this source code.  In place of
5 ** a legal notice, here is a blessing:
6 **
7 **    May you do good and not evil.
8 **    May you find forgiveness for yourself and forgive others.
9 **    May you share freely, never taking more than you give.
10 **
11 *************************************************************************
12 ** This file contains code used to dynamically load extensions into
13 ** the SQLite library.
14 */
15 
16 #ifndef SQLITE_CORE
17   #define SQLITE_CORE 1  /* Disable the API redefinition in sqlite3ext.h */
18 #endif
19 #include "sqlite3ext.h"
20 #include "sqliteInt.h"
21 #include <string.h>
22 
23 #ifndef SQLITE_OMIT_LOAD_EXTENSION
24 
25 /*
26 ** Some API routines are omitted when various features are
27 ** excluded from a build of SQLite.  Substitute a NULL pointer
28 ** for any missing APIs.
29 */
30 #ifndef SQLITE_ENABLE_COLUMN_METADATA
31 # define sqlite3_column_database_name   0
32 # define sqlite3_column_database_name16 0
33 # define sqlite3_column_table_name      0
34 # define sqlite3_column_table_name16    0
35 # define sqlite3_column_origin_name     0
36 # define sqlite3_column_origin_name16   0
37 #endif
38 
39 #ifdef SQLITE_OMIT_AUTHORIZATION
40 # define sqlite3_set_authorizer         0
41 #endif
42 
43 #ifdef SQLITE_OMIT_UTF16
44 # define sqlite3_bind_text16            0
45 # define sqlite3_collation_needed16     0
46 # define sqlite3_column_decltype16      0
47 # define sqlite3_column_name16          0
48 # define sqlite3_column_text16          0
49 # define sqlite3_complete16             0
50 # define sqlite3_create_collation16     0
51 # define sqlite3_create_function16      0
52 # define sqlite3_errmsg16               0
53 # define sqlite3_open16                 0
54 # define sqlite3_prepare16              0
55 # define sqlite3_prepare16_v2           0
56 # define sqlite3_result_error16         0
57 # define sqlite3_result_text16          0
58 # define sqlite3_result_text16be        0
59 # define sqlite3_result_text16le        0
60 # define sqlite3_value_text16           0
61 # define sqlite3_value_text16be         0
62 # define sqlite3_value_text16le         0
63 # define sqlite3_column_database_name16 0
64 # define sqlite3_column_table_name16    0
65 # define sqlite3_column_origin_name16   0
66 #endif
67 
68 #ifdef SQLITE_OMIT_COMPLETE
69 # define sqlite3_complete 0
70 # define sqlite3_complete16 0
71 #endif
72 
73 #ifdef SQLITE_OMIT_DECLTYPE
74 # define sqlite3_column_decltype16      0
75 # define sqlite3_column_decltype        0
76 #endif
77 
78 #ifdef SQLITE_OMIT_PROGRESS_CALLBACK
79 # define sqlite3_progress_handler 0
80 #endif
81 
82 #ifdef SQLITE_OMIT_VIRTUALTABLE
83 # define sqlite3_create_module 0
84 # define sqlite3_create_module_v2 0
85 # define sqlite3_declare_vtab 0
86 # define sqlite3_vtab_config 0
87 # define sqlite3_vtab_on_conflict 0
88 #endif
89 
90 #ifdef SQLITE_OMIT_SHARED_CACHE
91 # define sqlite3_enable_shared_cache 0
92 #endif
93 
94 #ifdef SQLITE_OMIT_TRACE
95 # define sqlite3_profile       0
96 # define sqlite3_trace         0
97 #endif
98 
99 #ifdef SQLITE_OMIT_GET_TABLE
100 # define sqlite3_free_table    0
101 # define sqlite3_get_table     0
102 #endif
103 
104 #ifdef SQLITE_OMIT_INCRBLOB
105 #define sqlite3_bind_zeroblob  0
106 #define sqlite3_blob_bytes     0
107 #define sqlite3_blob_close     0
108 #define sqlite3_blob_open      0
109 #define sqlite3_blob_read      0
110 #define sqlite3_blob_write     0
111 #define sqlite3_blob_reopen    0
112 #endif
113 
114 /*
115 ** The following structure contains pointers to all SQLite API routines.
116 ** A pointer to this structure is passed into extensions when they are
117 ** loaded so that the extension can make calls back into the SQLite
118 ** library.
119 **
120 ** When adding new APIs, add them to the bottom of this structure
121 ** in order to preserve backwards compatibility.
122 **
123 ** Extensions that use newer APIs should first call the
124 ** sqlite3_libversion_number() to make sure that the API they
125 ** intend to use is supported by the library.  Extensions should
126 ** also check to make sure that the pointer to the function is
127 ** not NULL before calling it.
128 */
129 static const sqlite3_api_routines sqlite3Apis = {
130   sqlite3_aggregate_context,
131 #ifndef SQLITE_OMIT_DEPRECATED
132   sqlite3_aggregate_count,
133 #else
134   0,
135 #endif
136   sqlite3_bind_blob,
137   sqlite3_bind_double,
138   sqlite3_bind_int,
139   sqlite3_bind_int64,
140   sqlite3_bind_null,
141   sqlite3_bind_parameter_count,
142   sqlite3_bind_parameter_index,
143   sqlite3_bind_parameter_name,
144   sqlite3_bind_text,
145   sqlite3_bind_text16,
146   sqlite3_bind_value,
147   sqlite3_busy_handler,
148   sqlite3_busy_timeout,
149   sqlite3_changes,
150   sqlite3_close,
151   sqlite3_collation_needed,
152   sqlite3_collation_needed16,
153   sqlite3_column_blob,
154   sqlite3_column_bytes,
155   sqlite3_column_bytes16,
156   sqlite3_column_count,
157   sqlite3_column_database_name,
158   sqlite3_column_database_name16,
159   sqlite3_column_decltype,
160   sqlite3_column_decltype16,
161   sqlite3_column_double,
162   sqlite3_column_int,
163   sqlite3_column_int64,
164   sqlite3_column_name,
165   sqlite3_column_name16,
166   sqlite3_column_origin_name,
167   sqlite3_column_origin_name16,
168   sqlite3_column_table_name,
169   sqlite3_column_table_name16,
170   sqlite3_column_text,
171   sqlite3_column_text16,
172   sqlite3_column_type,
173   sqlite3_column_value,
174   sqlite3_commit_hook,
175   sqlite3_complete,
176   sqlite3_complete16,
177   sqlite3_create_collation,
178   sqlite3_create_collation16,
179   sqlite3_create_function,
180   sqlite3_create_function16,
181   sqlite3_create_module,
182   sqlite3_data_count,
183   sqlite3_db_handle,
184   sqlite3_declare_vtab,
185   sqlite3_enable_shared_cache,
186   sqlite3_errcode,
187   sqlite3_errmsg,
188   sqlite3_errmsg16,
189   sqlite3_exec,
190 #ifndef SQLITE_OMIT_DEPRECATED
191   sqlite3_expired,
192 #else
193   0,
194 #endif
195   sqlite3_finalize,
196   sqlite3_free,
197   sqlite3_free_table,
198   sqlite3_get_autocommit,
199   sqlite3_get_auxdata,
200   sqlite3_get_table,
201   0,     /* Was sqlite3_global_recover(), but that function is deprecated */
202   sqlite3_interrupt,
203   sqlite3_last_insert_rowid,
204   sqlite3_libversion,
205   sqlite3_libversion_number,
206   sqlite3_malloc,
207   sqlite3_mprintf,
208   sqlite3_open,
209   sqlite3_open16,
210   sqlite3_prepare,
211   sqlite3_prepare16,
212   sqlite3_profile,
213   sqlite3_progress_handler,
214   sqlite3_realloc,
215   sqlite3_reset,
216   sqlite3_result_blob,
217   sqlite3_result_double,
218   sqlite3_result_error,
219   sqlite3_result_error16,
220   sqlite3_result_int,
221   sqlite3_result_int64,
222   sqlite3_result_null,
223   sqlite3_result_text,
224   sqlite3_result_text16,
225   sqlite3_result_text16be,
226   sqlite3_result_text16le,
227   sqlite3_result_value,
228   sqlite3_rollback_hook,
229   sqlite3_set_authorizer,
230   sqlite3_set_auxdata,
231   sqlite3_snprintf,
232   sqlite3_step,
233   sqlite3_table_column_metadata,
234 #ifndef SQLITE_OMIT_DEPRECATED
235   sqlite3_thread_cleanup,
236 #else
237   0,
238 #endif
239   sqlite3_total_changes,
240   sqlite3_trace,
241 #ifndef SQLITE_OMIT_DEPRECATED
242   sqlite3_transfer_bindings,
243 #else
244   0,
245 #endif
246   sqlite3_update_hook,
247   sqlite3_user_data,
248   sqlite3_value_blob,
249   sqlite3_value_bytes,
250   sqlite3_value_bytes16,
251   sqlite3_value_double,
252   sqlite3_value_int,
253   sqlite3_value_int64,
254   sqlite3_value_numeric_type,
255   sqlite3_value_text,
256   sqlite3_value_text16,
257   sqlite3_value_text16be,
258   sqlite3_value_text16le,
259   sqlite3_value_type,
260   sqlite3_vmprintf,
261   /*
262   ** The original API set ends here.  All extensions can call any
263   ** of the APIs above provided that the pointer is not NULL.  But
264   ** before calling APIs that follow, extension should check the
265   ** sqlite3_libversion_number() to make sure they are dealing with
266   ** a library that is new enough to support that API.
267   *************************************************************************
268   */
269   sqlite3_overload_function,
270 
271   /*
272   ** Added after 3.3.13
273   */
274   sqlite3_prepare_v2,
275   sqlite3_prepare16_v2,
276   sqlite3_clear_bindings,
277 
278   /*
279   ** Added for 3.4.1
280   */
281   sqlite3_create_module_v2,
282 
283   /*
284   ** Added for 3.5.0
285   */
286   sqlite3_bind_zeroblob,
287   sqlite3_blob_bytes,
288   sqlite3_blob_close,
289   sqlite3_blob_open,
290   sqlite3_blob_read,
291   sqlite3_blob_write,
292   sqlite3_create_collation_v2,
293   sqlite3_file_control,
294   sqlite3_memory_highwater,
295   sqlite3_memory_used,
296 #ifdef SQLITE_MUTEX_OMIT
297   0,
298   0,
299   0,
300   0,
301   0,
302 #else
303   sqlite3_mutex_alloc,
304   sqlite3_mutex_enter,
305   sqlite3_mutex_free,
306   sqlite3_mutex_leave,
307   sqlite3_mutex_try,
308 #endif
309   sqlite3_open_v2,
310   sqlite3_release_memory,
311   sqlite3_result_error_nomem,
312   sqlite3_result_error_toobig,
313   sqlite3_sleep,
314   sqlite3_soft_heap_limit,
315   sqlite3_vfs_find,
316   sqlite3_vfs_register,
317   sqlite3_vfs_unregister,
318 
319   /*
320   ** Added for 3.5.8
321   */
322   sqlite3_threadsafe,
323   sqlite3_result_zeroblob,
324   sqlite3_result_error_code,
325   sqlite3_test_control,
326   sqlite3_randomness,
327   sqlite3_context_db_handle,
328 
329   /*
330   ** Added for 3.6.0
331   */
332   sqlite3_extended_result_codes,
333   sqlite3_limit,
334   sqlite3_next_stmt,
335   sqlite3_sql,
336   sqlite3_status,
337 
338   /*
339   ** Added for 3.7.4
340   */
341   sqlite3_backup_finish,
342   sqlite3_backup_init,
343   sqlite3_backup_pagecount,
344   sqlite3_backup_remaining,
345   sqlite3_backup_step,
346 #ifndef SQLITE_OMIT_COMPILEOPTION_DIAGS
347   sqlite3_compileoption_get,
348   sqlite3_compileoption_used,
349 #else
350   0,
351   0,
352 #endif
353   sqlite3_create_function_v2,
354   sqlite3_db_config,
355   sqlite3_db_mutex,
356   sqlite3_db_status,
357   sqlite3_extended_errcode,
358   sqlite3_log,
359   sqlite3_soft_heap_limit64,
360   sqlite3_sourceid,
361   sqlite3_stmt_status,
362   sqlite3_strnicmp,
363 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
364   sqlite3_unlock_notify,
365 #else
366   0,
367 #endif
368 #ifndef SQLITE_OMIT_WAL
369   sqlite3_wal_autocheckpoint,
370   sqlite3_wal_checkpoint,
371   sqlite3_wal_hook,
372 #else
373   0,
374   0,
375   0,
376 #endif
377   sqlite3_blob_reopen,
378   sqlite3_vtab_config,
379   sqlite3_vtab_on_conflict,
380   sqlite3_close_v2,
381   sqlite3_db_filename,
382   sqlite3_db_readonly,
383   sqlite3_db_release_memory,
384   sqlite3_errstr,
385   sqlite3_stmt_busy,
386   sqlite3_stmt_readonly,
387   sqlite3_stricmp,
388   sqlite3_uri_boolean,
389   sqlite3_uri_int64,
390   sqlite3_uri_parameter,
391   sqlite3_vsnprintf,
392   sqlite3_wal_checkpoint_v2,
393   /* Version 3.8.7 and later */
394   sqlite3_auto_extension,
395   sqlite3_bind_blob64,
396   sqlite3_bind_text64,
397   sqlite3_cancel_auto_extension,
398   sqlite3_load_extension,
399   sqlite3_malloc64,
400   sqlite3_msize,
401   sqlite3_realloc64,
402   sqlite3_reset_auto_extension,
403   sqlite3_result_blob64,
404   sqlite3_result_text64,
405   sqlite3_strglob,
406   /* Version 3.8.11 and later */
407   (sqlite3_value*(*)(const sqlite3_value*))sqlite3_value_dup,
408   sqlite3_value_free,
409   sqlite3_result_zeroblob64,
410   sqlite3_bind_zeroblob64,
411   /* Version 3.9.0 and later */
412   sqlite3_value_subtype,
413   sqlite3_result_subtype,
414   /* Version 3.10.0 and later */
415   sqlite3_status64,
416   sqlite3_strlike,
417   sqlite3_db_cacheflush,
418   /* Version 3.12.0 and later */
419   sqlite3_system_errno
420 };
421 
422 /*
423 ** Attempt to load an SQLite extension library contained in the file
424 ** zFile.  The entry point is zProc.  zProc may be 0 in which case a
425 ** default entry point name (sqlite3_extension_init) is used.  Use
426 ** of the default name is recommended.
427 **
428 ** Return SQLITE_OK on success and SQLITE_ERROR if something goes wrong.
429 **
430 ** If an error occurs and pzErrMsg is not 0, then fill *pzErrMsg with
431 ** error message text.  The calling function should free this memory
432 ** by calling sqlite3DbFree(db, ).
433 */
434 static int sqlite3LoadExtension(
435   sqlite3 *db,          /* Load the extension into this database connection */
436   const char *zFile,    /* Name of the shared library containing extension */
437   const char *zProc,    /* Entry point.  Use "sqlite3_extension_init" if 0 */
438   char **pzErrMsg       /* Put error message here if not 0 */
439 ){
440   sqlite3_vfs *pVfs = db->pVfs;
441   void *handle;
442   int (*xInit)(sqlite3*,char**,const sqlite3_api_routines*);
443   char *zErrmsg = 0;
444   const char *zEntry;
445   char *zAltEntry = 0;
446   void **aHandle;
447   u64 nMsg = 300 + sqlite3Strlen30(zFile);
448   int ii;
449 
450   /* Shared library endings to try if zFile cannot be loaded as written */
451   static const char *azEndings[] = {
452 #if SQLITE_OS_WIN
453      "dll"
454 #elif defined(__APPLE__)
455      "dylib"
456 #else
457      "so"
458 #endif
459   };
460 
461 
462   if( pzErrMsg ) *pzErrMsg = 0;
463 
464   /* Ticket #1863.  To avoid a creating security problems for older
465   ** applications that relink against newer versions of SQLite, the
466   ** ability to run load_extension is turned off by default.  One
467   ** must call sqlite3_enable_load_extension() to turn on extension
468   ** loading.  Otherwise you get the following error.
469   */
470   if( (db->flags & SQLITE_LoadExtension)==0 ){
471     if( pzErrMsg ){
472       *pzErrMsg = sqlite3_mprintf("not authorized");
473     }
474     return SQLITE_ERROR;
475   }
476 
477   zEntry = zProc ? zProc : "sqlite3_extension_init";
478 
479   handle = sqlite3OsDlOpen(pVfs, zFile);
480 #if SQLITE_OS_UNIX || SQLITE_OS_WIN
481   for(ii=0; ii<ArraySize(azEndings) && handle==0; ii++){
482     char *zAltFile = sqlite3_mprintf("%s.%s", zFile, azEndings[ii]);
483     if( zAltFile==0 ) return SQLITE_NOMEM_BKPT;
484     handle = sqlite3OsDlOpen(pVfs, zAltFile);
485     sqlite3_free(zAltFile);
486   }
487 #endif
488   if( handle==0 ){
489     if( pzErrMsg ){
490       *pzErrMsg = zErrmsg = sqlite3_malloc64(nMsg);
491       if( zErrmsg ){
492         sqlite3_snprintf(nMsg, zErrmsg,
493             "unable to open shared library [%s]", zFile);
494         sqlite3OsDlError(pVfs, nMsg-1, zErrmsg);
495       }
496     }
497     return SQLITE_ERROR;
498   }
499   xInit = (int(*)(sqlite3*,char**,const sqlite3_api_routines*))
500                    sqlite3OsDlSym(pVfs, handle, zEntry);
501 
502   /* If no entry point was specified and the default legacy
503   ** entry point name "sqlite3_extension_init" was not found, then
504   ** construct an entry point name "sqlite3_X_init" where the X is
505   ** replaced by the lowercase value of every ASCII alphabetic
506   ** character in the filename after the last "/" upto the first ".",
507   ** and eliding the first three characters if they are "lib".
508   ** Examples:
509   **
510   **    /usr/local/lib/libExample5.4.3.so ==>  sqlite3_example_init
511   **    C:/lib/mathfuncs.dll              ==>  sqlite3_mathfuncs_init
512   */
513   if( xInit==0 && zProc==0 ){
514     int iFile, iEntry, c;
515     int ncFile = sqlite3Strlen30(zFile);
516     zAltEntry = sqlite3_malloc64(ncFile+30);
517     if( zAltEntry==0 ){
518       sqlite3OsDlClose(pVfs, handle);
519       return SQLITE_NOMEM_BKPT;
520     }
521     memcpy(zAltEntry, "sqlite3_", 8);
522     for(iFile=ncFile-1; iFile>=0 && zFile[iFile]!='/'; iFile--){}
523     iFile++;
524     if( sqlite3_strnicmp(zFile+iFile, "lib", 3)==0 ) iFile += 3;
525     for(iEntry=8; (c = zFile[iFile])!=0 && c!='.'; iFile++){
526       if( sqlite3Isalpha(c) ){
527         zAltEntry[iEntry++] = (char)sqlite3UpperToLower[(unsigned)c];
528       }
529     }
530     memcpy(zAltEntry+iEntry, "_init", 6);
531     zEntry = zAltEntry;
532     xInit = (int(*)(sqlite3*,char**,const sqlite3_api_routines*))
533                      sqlite3OsDlSym(pVfs, handle, zEntry);
534   }
535   if( xInit==0 ){
536     if( pzErrMsg ){
537       nMsg += sqlite3Strlen30(zEntry);
538       *pzErrMsg = zErrmsg = sqlite3_malloc64(nMsg);
539       if( zErrmsg ){
540         sqlite3_snprintf(nMsg, zErrmsg,
541             "no entry point [%s] in shared library [%s]", zEntry, zFile);
542         sqlite3OsDlError(pVfs, nMsg-1, zErrmsg);
543       }
544     }
545     sqlite3OsDlClose(pVfs, handle);
546     sqlite3_free(zAltEntry);
547     return SQLITE_ERROR;
548   }
549   sqlite3_free(zAltEntry);
550   if( xInit(db, &zErrmsg, &sqlite3Apis) ){
551     if( pzErrMsg ){
552       *pzErrMsg = sqlite3_mprintf("error during initialization: %s", zErrmsg);
553     }
554     sqlite3_free(zErrmsg);
555     sqlite3OsDlClose(pVfs, handle);
556     return SQLITE_ERROR;
557   }
558 
559   /* Append the new shared library handle to the db->aExtension array. */
560   aHandle = sqlite3DbMallocZero(db, sizeof(handle)*(db->nExtension+1));
561   if( aHandle==0 ){
562     return SQLITE_NOMEM_BKPT;
563   }
564   if( db->nExtension>0 ){
565     memcpy(aHandle, db->aExtension, sizeof(handle)*db->nExtension);
566   }
567   sqlite3DbFree(db, db->aExtension);
568   db->aExtension = aHandle;
569 
570   db->aExtension[db->nExtension++] = handle;
571   return SQLITE_OK;
572 }
573 int sqlite3_load_extension(
574   sqlite3 *db,          /* Load the extension into this database connection */
575   const char *zFile,    /* Name of the shared library containing extension */
576   const char *zProc,    /* Entry point.  Use "sqlite3_extension_init" if 0 */
577   char **pzErrMsg       /* Put error message here if not 0 */
578 ){
579   int rc;
580   sqlite3_mutex_enter(db->mutex);
581   rc = sqlite3LoadExtension(db, zFile, zProc, pzErrMsg);
582   rc = sqlite3ApiExit(db, rc);
583   sqlite3_mutex_leave(db->mutex);
584   return rc;
585 }
586 
587 /*
588 ** Call this routine when the database connection is closing in order
589 ** to clean up loaded extensions
590 */
591 void sqlite3CloseExtensions(sqlite3 *db){
592   int i;
593   assert( sqlite3_mutex_held(db->mutex) );
594   for(i=0; i<db->nExtension; i++){
595     sqlite3OsDlClose(db->pVfs, db->aExtension[i]);
596   }
597   sqlite3DbFree(db, db->aExtension);
598 }
599 
600 /*
601 ** Enable or disable extension loading.  Extension loading is disabled by
602 ** default so as not to open security holes in older applications.
603 */
604 int sqlite3_enable_load_extension(sqlite3 *db, int onoff){
605   sqlite3_mutex_enter(db->mutex);
606   if( onoff ){
607     db->flags |= SQLITE_LoadExtension;
608   }else{
609     db->flags &= ~SQLITE_LoadExtension;
610   }
611   sqlite3_mutex_leave(db->mutex);
612   return SQLITE_OK;
613 }
614 
615 #endif /* SQLITE_OMIT_LOAD_EXTENSION */
616 
617 /*
618 ** The auto-extension code added regardless of whether or not extension
619 ** loading is supported.  We need a dummy sqlite3Apis pointer for that
620 ** code if regular extension loading is not available.  This is that
621 ** dummy pointer.
622 */
623 #ifdef SQLITE_OMIT_LOAD_EXTENSION
624 static const sqlite3_api_routines sqlite3Apis = { 0 };
625 #endif
626 
627 
628 /*
629 ** The following object holds the list of automatically loaded
630 ** extensions.
631 **
632 ** This list is shared across threads.  The SQLITE_MUTEX_STATIC_MASTER
633 ** mutex must be held while accessing this list.
634 */
635 typedef struct sqlite3AutoExtList sqlite3AutoExtList;
636 static SQLITE_WSD struct sqlite3AutoExtList {
637   u32 nExt;              /* Number of entries in aExt[] */
638   void (**aExt)(void);   /* Pointers to the extension init functions */
639 } sqlite3Autoext = { 0, 0 };
640 
641 /* The "wsdAutoext" macro will resolve to the autoextension
642 ** state vector.  If writable static data is unsupported on the target,
643 ** we have to locate the state vector at run-time.  In the more common
644 ** case where writable static data is supported, wsdStat can refer directly
645 ** to the "sqlite3Autoext" state vector declared above.
646 */
647 #ifdef SQLITE_OMIT_WSD
648 # define wsdAutoextInit \
649   sqlite3AutoExtList *x = &GLOBAL(sqlite3AutoExtList,sqlite3Autoext)
650 # define wsdAutoext x[0]
651 #else
652 # define wsdAutoextInit
653 # define wsdAutoext sqlite3Autoext
654 #endif
655 
656 
657 /*
658 ** Register a statically linked extension that is automatically
659 ** loaded by every new database connection.
660 */
661 int sqlite3_auto_extension(void (*xInit)(void)){
662   int rc = SQLITE_OK;
663 #ifndef SQLITE_OMIT_AUTOINIT
664   rc = sqlite3_initialize();
665   if( rc ){
666     return rc;
667   }else
668 #endif
669   {
670     u32 i;
671 #if SQLITE_THREADSAFE
672     sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER);
673 #endif
674     wsdAutoextInit;
675     sqlite3_mutex_enter(mutex);
676     for(i=0; i<wsdAutoext.nExt; i++){
677       if( wsdAutoext.aExt[i]==xInit ) break;
678     }
679     if( i==wsdAutoext.nExt ){
680       u64 nByte = (wsdAutoext.nExt+1)*sizeof(wsdAutoext.aExt[0]);
681       void (**aNew)(void);
682       aNew = sqlite3_realloc64(wsdAutoext.aExt, nByte);
683       if( aNew==0 ){
684         rc = SQLITE_NOMEM_BKPT;
685       }else{
686         wsdAutoext.aExt = aNew;
687         wsdAutoext.aExt[wsdAutoext.nExt] = xInit;
688         wsdAutoext.nExt++;
689       }
690     }
691     sqlite3_mutex_leave(mutex);
692     assert( (rc&0xff)==rc );
693     return rc;
694   }
695 }
696 
697 /*
698 ** Cancel a prior call to sqlite3_auto_extension.  Remove xInit from the
699 ** set of routines that is invoked for each new database connection, if it
700 ** is currently on the list.  If xInit is not on the list, then this
701 ** routine is a no-op.
702 **
703 ** Return 1 if xInit was found on the list and removed.  Return 0 if xInit
704 ** was not on the list.
705 */
706 int sqlite3_cancel_auto_extension(void (*xInit)(void)){
707 #if SQLITE_THREADSAFE
708   sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER);
709 #endif
710   int i;
711   int n = 0;
712   wsdAutoextInit;
713   sqlite3_mutex_enter(mutex);
714   for(i=(int)wsdAutoext.nExt-1; i>=0; i--){
715     if( wsdAutoext.aExt[i]==xInit ){
716       wsdAutoext.nExt--;
717       wsdAutoext.aExt[i] = wsdAutoext.aExt[wsdAutoext.nExt];
718       n++;
719       break;
720     }
721   }
722   sqlite3_mutex_leave(mutex);
723   return n;
724 }
725 
726 /*
727 ** Reset the automatic extension loading mechanism.
728 */
729 void sqlite3_reset_auto_extension(void){
730 #ifndef SQLITE_OMIT_AUTOINIT
731   if( sqlite3_initialize()==SQLITE_OK )
732 #endif
733   {
734 #if SQLITE_THREADSAFE
735     sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER);
736 #endif
737     wsdAutoextInit;
738     sqlite3_mutex_enter(mutex);
739     sqlite3_free(wsdAutoext.aExt);
740     wsdAutoext.aExt = 0;
741     wsdAutoext.nExt = 0;
742     sqlite3_mutex_leave(mutex);
743   }
744 }
745 
746 /*
747 ** Load all automatic extensions.
748 **
749 ** If anything goes wrong, set an error in the database connection.
750 */
751 void sqlite3AutoLoadExtensions(sqlite3 *db){
752   u32 i;
753   int go = 1;
754   int rc;
755   int (*xInit)(sqlite3*,char**,const sqlite3_api_routines*);
756 
757   wsdAutoextInit;
758   if( wsdAutoext.nExt==0 ){
759     /* Common case: early out without every having to acquire a mutex */
760     return;
761   }
762   for(i=0; go; i++){
763     char *zErrmsg;
764 #if SQLITE_THREADSAFE
765     sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER);
766 #endif
767     sqlite3_mutex_enter(mutex);
768     if( i>=wsdAutoext.nExt ){
769       xInit = 0;
770       go = 0;
771     }else{
772       xInit = (int(*)(sqlite3*,char**,const sqlite3_api_routines*))
773               wsdAutoext.aExt[i];
774     }
775     sqlite3_mutex_leave(mutex);
776     zErrmsg = 0;
777     if( xInit && (rc = xInit(db, &zErrmsg, &sqlite3Apis))!=0 ){
778       sqlite3ErrorWithMsg(db, rc,
779             "automatic extension loading failed: %s", zErrmsg);
780       go = 0;
781     }
782     sqlite3_free(zErrmsg);
783   }
784 }
785