Hi, I am using Sqlite in a codebase shared between Windows and OS X and specifically I am using FTS4 for searching our DB for free text strings. I have just upgraded to the latest 3.9.1 and thought to give a try to FTS5, but encountered an issue. It works fine on Windows, but on OS X the moment I try to create the FTS5 virtual table...
"CREATE VIRTUAL TABLE IF NOT EXISTS MessageSearch USING fts5(MESSAGE_ID UNINDEXED,CONVERSATION_ID UNINDEXED,MESSAGE_PUBLISHED_TIME UNINDEXED,MESSAGE_DATA, prefix='3,4,5')" ... I get an "error: no module: fts5" error message. This indicates that I didn't compile SQLite with FTS5 support, but I am pretty sure that I am using the right preprocessor flags (I am using the single C file amalgamation). For reference here is the entire build script I am using: clang -c -O2 -DSQLITE_ENABLE_FTS5 -DSQLITE_THREADSAFE=0 -o sqlite3.o sqlite3.c ar rcs darwin/libsqlite3.a sqlite3.o I confirmed that the fts5.c part and the fts5 initialisation functions are all compiled into the .o. Any idea what am I doing wrong? The main thing why I am puzzled is that it works without issues on Windows. Regards, Gergely