Well that's embarrassing. There wasn't a binary in the current directory, but I think the linker picked up the 3.8.5 binary from elsewhere (confirmed by checking the sqlite3 version in the test app, which returned 3.8.5).
I retested (linking correctly this time) against both the 3.8.6 amalgamation and the 3.8.7 pre-release amalgamation. The problem occurs in 3.8.6 and not in 3.8.7. So the ticket I mentioned at the top of the thread may have resolve this issue. Thanks for the help. On Sat, Sep 27, 2014 at 5:12 PM, Stephan Beal <sgb...@googlemail.com> wrote: > On Sat, Sep 27, 2014 at 11:08 PM, Hody Crouch <hody.cro...@gmail.com> > wrote: > > > $ gcc -g -I. dbtest.c -l sqlite3 -ldl -lpthread > > $ ./a.out > > TRACE: SELECT val1, val2 from t where val2 = 'A%' > > > > What is -l sqlite3 supposed to do? It's not a valid linker flag (-l and its > argument should have no spaces between them). It looks to me like you are > linking the sqlite3 _binary_ (from the current directory) into your dbtest > app (which is a usage error). > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users