/ Check-in [b7a26427]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Get ANALYZE working again with -DSQLITE_ENABLE_STAT2 and virtual tables.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b7a26427afc43c9bbdf365b775379eb57187bc97
User & Date: drh 2010-09-28 17:34:46
Context
2010-09-28
17:37
Merge accidental fork. check-in: 33c8b9c7 user: drh tags: trunk
17:34
Get ANALYZE working again with -DSQLITE_ENABLE_STAT2 and virtual tables. check-in: b7a26427 user: drh tags: trunk
15:55
Disallow statements of the form "CREATE TEMP TABLE main.t1 ...". check-in: dd1b34ba user: dan tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to src/analyze.c.

132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
  int regFirst = iMem++;       /* Index of first sample to record */
#endif

  v = sqlite3GetVdbe(pParse);
  if( v==0 || NEVER(pTab==0) ){
    return;
  }
  if( pTab->pSelect ){
    /* Do not gather statistics on views */
    return;
  }
  if( memcmp(pTab->zName, "sqlite_", 7)==0 ){
    /* Do not gather statistics on system tables */
    return;
  }
  assert( sqlite3BtreeHoldsAllMutexes(db) );







|
|







132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
  int regFirst = iMem++;       /* Index of first sample to record */
#endif

  v = sqlite3GetVdbe(pParse);
  if( v==0 || NEVER(pTab==0) ){
    return;
  }
  if( pTab->tnum==0 ){
    /* Do not gather statistics on views or virtual tables */
    return;
  }
  if( memcmp(pTab->zName, "sqlite_", 7)==0 ){
    /* Do not gather statistics on system tables */
    return;
  }
  assert( sqlite3BtreeHoldsAllMutexes(db) );