Hello,
After some time, I've gone back to working with precompiled queries
and found out why I was consistently getting SQLITE_SCHEMA errors. In
my code, I was calling two pragmas after I compiled the query and
before I executed it. Removing the pargmas removed the problem.
The pargmas were:
PRAGMA short_column_names = OFF
PRAGMA full_column_names = ON
My question is, do these queries change the schema? Is this the
expected behaviour? It's not a problem either way, I'm just curious.
If these (or other/all?) pragmas will have this effect, it might be
useful to add this to the FAQ (http://www.sqlite.org/faq.html#q17).
Cheers,
Demitri
