[sqlite] does PRAGMA vdbe_trace work?

[Dennis Cote]

Hi,
I'm trying to track down a crash in SQLite 3.1a. I have built a debug 
version using

./sqlite/configure --enable-debug
The Makefile generated does not contain the -DNDEBUG flag. When I use the 
explain command to dump an SQL statement, I get the additional comments in 
the explain output.

My problem is that I don't get any output when I turn on the vdbe tracing 
with

PRAGMA vdbe_trace=on;
Below is a log of a simple session that shows the lack of vdbe tracing.
C:\SQLite\SQLiteV3\build31>.\sqlite3
SQLite version 3.1.0alpha
Enter ".help" for instructions
sqlite> create table t(a, b);
sqlite> .explain on
sqlite> explain select * from t;
addr  opcode        p1          p2          p3
----  ------------  ----------  ----------  -----------------------------------
0     Goto          0           11
1     Integer       0           0
2     OpenRead      0           2           # t
3     SetNumColumn  0           2
4     Rewind        0           9
5     Column        0           0           # a
6     Column        0           1           # b
7     Callback      2           0
8     Next          0           5
9     Close         0           0
10    Halt          0           0
11    Transaction   0           0
12    VerifyCookie  0           1
13    Goto          0           1
14    Noop          0           0
sqlite> pragma vdbe_trace=on;
sqlite> select * from t;
sqlite> insert into t values(1,2);
sqlite> select * from t;
a     b
----  ------------
1     2
sqlite> .quit
Does this feature still work? Is there something else I need to do to get 
the output?

Any help will be greatly appriciated.
Dennis Cote