Ah, OK, overlooked that. It means that sqlite3_prepare can't be used to check the validity of pragma statements, also because the pragma could actually run! Thanks for pointing me to this. Will need to add some parsing code.
RBS On Sat, Jan 9, 2016 at 3:57 PM, Richard Hipp <drh at sqlite.org> wrote: > On 1/9/16, Bart Smissaert <bart.smissaert at gmail.com> wrote: > > If I run sqlite3_prepare16_v2 on this statement: > > > > PRAGMA compile_optionsXXX > > > > I get a return value of 0 and there is a non-zero statement handle. > > I would expect a return value of 1 and a zero statement handle. > > https://www.sqlite.org/mark/pragma.html?No+error*fact. > > > > > But if I run instead sqlite3_prepare16_v2 on this statement: > > > > PRAGMA compile_options XXX > > > > Then I get the expected result, so return value 1 and zero statement > > handle. > > > > This looks like a bug to me. > > > > > > RBS > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > -- > D. Richard Hipp > drh at sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
