I’ve been using this while debugging by inserting the following code just
before the return statement at the bottom of the sqlite3Select procedure.
freopen("c:/SQLiteData/TreeView.txt","w",stdout);
sqlite3TreeViewSelect(0, p, 0);
freopen("CON","w",stdout);
(NB above only works if you define SQLITE_DEBUG).
I’ve been looking at the result for various queries. Let’s suppose I want to
take the output from TreeView.txt and rebuild the query from that so I have a
version of the query where I know which schema, table and column each ID token
refers to. It looks fairly easy given the tables and columns are all numbered
but there’s a couple of things I’m unsure of.
1. When I include a WITH statement in the query it prints the WITH statement
but it also seems to incorporate the associated select(s) into the main SELECT
such that the WITH statement can be effectively ignored. Is that always the
case?
2. In the text below what does the line ‘IF NULL-ROW 8’ mean (the SELECT
below that line is what was contained in the WITH statement)?
|-- SELECT (7/23B3648) selFlags=0xc4 nSelectRow=253
|-- result-set
| |-- {0:-1} flags=0x820000
| |-- {0:7} flags=0x820000
| '-- IF-NULL-ROW 8
| '-- SELECT-expr flags=0x2220800
| '-- SELECT (2/23B3A68) selFlags=0x40c4 nSelectRow=0
| |-- result-set
| | '-- {9:1} flags=0x820000
| |-- FROM
| | |-- {9,*} Course tab='course' nCol=9 ptr=23B18A8
| | '-- {11,*} Dam tab='dam' nCol=3 ptr=23B1908
| |-- WHERE
| | '-- AND
| | |-- EQ
| | | |-- {9:-1} flags=0x820000
| | | '-- 28
| | '-- EQ
| | |-- {9:-1} flags=0x20008
| | | '-- 28
| | '-- {11:-1} flags=0x820000
| '-- LIMIT
| '-- 1
|-- FROM
.....
Also, is there any way I could redirect the stdout to a memory buffer rather
than a file (I’m using clang compiler on windows)? It would be great if there
was a function along the lines of sqlite3_normalized_sql(stmt) that returned
the sqlite3TreeViewSelect text.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
