Re: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

2006-10-04 Thread drh
"Lowder, Brady M." <[EMAIL PROTECTED]> wrote: > Group, > > Compiling with -DSQLITE_DEBUG=1 has performance impacts as it adds = > other > debug capability that we may not need. I noticed that there is also a > define called SQLITE_OMIT_EXPLAIN in the source code. Is it possible to > just set that

RE: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

2006-10-04 Thread Lowder, Brady M.
PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 29, 2006 2:31 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5 "Lowder, Brady M." <[EMAIL PROTECTED]> wrote: > Group, > > > Using sqlite-3.3.5 along with Tcl8.4.

RE: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

2006-09-29 Thread Griggs, Donald
Re: EXPLAIN is omitted by default. Recompile with -DSQLITE_DEBUG=1 to turn it on. That certainly explains it. - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

2006-09-29 Thread drh
"Lowder, Brady M." <[EMAIL PROTECTED]> wrote: > Group, > > > Using sqlite-3.3.5 along with Tcl8.4.11 and Tk8.4.11, the EXPLAIN > command doesn't produce the desired result. EXPLAIN is used for > interpreting SELECT, INSERT, DELETE, UPDATE SQL commands. It appears to > be retrieving

[sqlite] Problem with EXPLAIN in Sqlite-3.3.5

2006-09-29 Thread Lowder, Brady M.
Group, Using sqlite-3.3.5 along with Tcl8.4.11 and Tk8.4.11, the EXPLAIN command doesn't produce the desired result. EXPLAIN is used for interpreting SELECT, INSERT, DELETE, UPDATE SQL commands. It appears to be retrieving insufficent opcodes and erroneous data that don't return a result from