LOAD_EXTENSION: Error: error during initialization:
(1) By 6kEs4Majrd on 2021-07-10 23:08:17 [link] [source]
I downloaded regexp.c from above, and compileded it like this on macOS.
gcc -I /usr/local/opt/sqlite/include -fPIC -dynamiclib /tmp/regexp.c -o /usr/local/opt/sqlite/lib/regexp.dylib
Then I got the following error when I try to load it in an sqlite3 session. Does anybody know how to load it properly?
$ LD_LIBRARY_PATH=/usr/local/opt/sqlite/lib sqlite3 SQLite version 3.36.0 2021-06-18 18:36:39 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> SELECT LOAD_EXTENSION('regexp'); Error: error during initialization: sqlite>
(2) By anonymous on 2021-07-11 16:24:36 in reply to 1 [source]
Do you have the same problem loading the extension using
.load regexp.dylib? It's possible the
load_extension() SQL function is disabled depending on the value of