I am new to iPhone development. Although I have searched on this forum, in Apple documentation, etc., I am stumped by what very well may be a simple problem. I am trying my best not to ask a redundant question already covered on the forum, but please forgive me if that ends up being the case.
I wrote a database app that uses SQLITE's FTS3 functions (specifically MATCH and OFFSET). These are essential to my application. I downloaded the amalgamation files, made the necessary changes to the header and created a SQLITE group for them in my project. I removed from the Frameworks group my previous reference to the libsqlite3.dylib library.
The application performs great in the Simulator for both debug and release builds. There are no memory leaks or other issues. The application also performs great on the iPhone, BUT only for the debug build! The release build seems to ignore any SQL calls with MATCH and OFFSET keywords, and those SQL calls simply return no rows in those cases. No exceptions are ever thrown and all other SQL calls work perfectly.
My question is, "When I build the release version with my iPhone connected, is my FTS3 enabled version of SQLITE not being installing along with my app?" I see the sqlite.o object file in the appropriate Release-iphoneos subfolder. It is a bit smaller than the one in the Debug-iphoneos subfolder, but I figured this is due to a lack of debug symbols.
I feel that I am almost ready to upload my app for review and really need to solve this issue. However, I suspect it is due to a gaping hole in my knowledge of this new platform. Hence, my app may be almost ready, but maybe I am not.
Thank you.
SQLITE FTS3 RELEASE CONFIGURATION
Linear Mode
