On 8/26/17, Bart Smissaert <bart.smissa...@gmail.com> wrote: > I looked at my application code and that seems OK, but the output is a > single null value. > What kind of output should I get?
The following script shows you what to expect: CREATE TABLE t1(a INTEGER PRIMARY KEY,b,c); CREATE INDEX t1b ON t1(b); CREATE INDEX t1c ON t1(c); SELECT a FROM t1 WHERE b=5 AND c=9; PRAGMA optimize(-1); Looks like the argument to optimize should be -1, not 1, in order to see the debugging output. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
