Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix sqlite3_analyzer so that it works on databases containing virtual tables. (CVS 3457) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
47c8567fcb6b184ca13fcb67f80d2612 |
User & Date: | drh 2006-10-03 12:04:11.000 |
Context
2006-10-03
| ||
12:08 | Fix sqlite3_analyzer so that it works when compiled against Tcl8.5. (CVS 3458) (check-in: e774adce8e user: drh tags: trunk) | |
12:04 | Fix sqlite3_analyzer so that it works on databases containing virtual tables. (CVS 3457) (check-in: 47c8567fcb user: drh tags: trunk) | |
11:42 | Add the option to omit offset information from posting lists in FTS1. (CVS 3456) (check-in: fdcea7b1ff user: drh tags: trunk) | |
Changes
Changes to tool/spaceanal.tcl.
︙ | ︙ | |||
115 116 117 118 119 120 121 | # Analyze every table in the database, one at a time. # # The following query returns the name and root-page of each table in the # database, including the sqlite_master table. # set sql { | | > | 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 | # Analyze every table in the database, one at a time. # # The following query returns the name and root-page of each table in the # database, including the sqlite_master table. # set sql { SELECT name, rootpage FROM sqlite_master WHERE type='table' AND rootpage>0 UNION ALL SELECT 'sqlite_master', 1 ORDER BY 1 } set wideZero [expr {10000000000 - 10000000000}] foreach {name rootpage} [db eval $sql] { puts stderr "Analyzing table $name..." |
︙ | ︙ |