/ Check-in [a92c398f]
Login

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

Overview
Comment:Remove a line of code from VACUUM that is no longer needed, due to the change that allows ATTACH to run within a transaction.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: a92c398fc5df142ff1459c1be4a6832f2219bc7fabe5789535be3bbd41a4269b
User & Date: drh 2018-12-07 20:26:29
Context
2018-12-08
20:30
Do not use a partial index as a table scan in an IN operator. Fix for ticket [1d958d90596593a77420e59]. check-in: 15bc915d user: drh tags: trunk
2018-12-07
20:40
Merge the VACUUM simplification from trunk. check-in: 93d92a0a user: drh tags: vacuum-into
20:26
Remove a line of code from VACUUM that is no longer needed, due to the change that allows ATTACH to run within a transaction. check-in: a92c398f user: drh tags: trunk
16:32
Fix the sqlite3_normalized_sql() interface so that it renders double-quoted string literals as "?". check-in: 0d8e1504 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/vacuum.c.

   191    191     nDb = db->nDb;
   192    192     rc = execSql(db, pzErrMsg, "ATTACH''AS vacuum_db");
   193    193     if( rc!=SQLITE_OK ) goto end_of_vacuum;
   194    194     assert( (db->nDb-1)==nDb );
   195    195     pDb = &db->aDb[nDb];
   196    196     assert( strcmp(pDb->zDbSName,"vacuum_db")==0 );
   197    197     pTemp = pDb->pBt;
   198         -
   199         -  /* The call to execSql() to attach the temp database has left the file
   200         -  ** locked (as there was more than one active statement when the transaction
   201         -  ** to read the schema was concluded. Unlock it here so that this doesn't
   202         -  ** cause problems for the call to BtreeSetPageSize() below.  */
   203         -  sqlite3BtreeCommit(pTemp);
   204         -
   205    198     nRes = sqlite3BtreeGetOptimalReserve(pMain);
   206    199   
   207    200     /* A VACUUM cannot change the pagesize of an encrypted database. */
   208    201   #ifdef SQLITE_HAS_CODEC
   209    202     if( db->nextPagesize ){
   210    203       extern void sqlite3CodecGetKey(sqlite3*, int, void**, int*);
   211    204       int nKey;