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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
47c8567fcb6b184ca13fcb67f80d2612 |
| User & Date: | drh 2006-10-03 12:04:11 |
Context
|
2006-10-03
| ||
| 12:08 | Fix sqlite3_analyzer so that it works when compiled against Tcl8.5. (CVS 3458) check-in: e774adce user: drh tags: trunk | |
| 12:04 | Fix sqlite3_analyzer so that it works on databases containing virtual tables. (CVS 3457) check-in: 47c8567f user: drh tags: trunk | |
| 11:42 | Add the option to omit offset information from posting lists in FTS1. (CVS 3456) check-in: fdcea7b1 user: drh tags: trunk | |
Changes
Changes to tool/spaceanal.tcl.
115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 |
# 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'
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..."
|
| > |
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..."
|