/ Check-in [47c8567f]
Login

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: 47c8567fcb6b184ca13fcb67f80d261205c66fc8
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

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..."