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