As written on http://www.sqlite.org/compile.html#omit_explain when explain is disabled executing it should fail. But I do get back the result of the query instead.
Thanks for the great software by the way. Greetings, Simon H. Examples of unexpected result ========================= sqlite> EXPLAIN SELECT 1.234; 1.234 sqlite> EXPLAIN QUERY PLAN SELECT 98765432; 98765432 Compile options and version ======================= sqlite> SELECT sqlite_compileoption_get(0); CURDIR sqlite> SELECT sqlite_compileoption_get(1); ENABLE_COLUMN_METADATA sqlite> SELECT sqlite_compileoption_get(2); OMIT_EXPLAIN sqlite> SELECT sqlite_compileoption_get(3); OMIT_SHARED_CACHE sqlite> SELECT sqlite_compileoption_get(4); SOUNDEX sqlite> SELECT sqlite_compileoption_get(5); TEMP_STORE=1 sqlite> SELECT sqlite_compileoption_get(6); THREADSAFE=1 sqlite> SELECT sqlite_compileoption_get(7); sqlite> SELECT sqlite_source_id(); 2012-10-04 19:37:12 091570e46d04e84b67228e0bdbcd6e1fb60c6bdb sqlite> SELECT sqlite_version(); 3.7.14.1 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
