/ Check-in [cc6bfdf8]
Login

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

Overview
Comment:Merge the cache_spill VACUUM fix from trunk.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | apple-osx
Files: files | file ages | folders
SHA1:cc6bfdf814d5701591b69ba2d399d4a1f6f6cc98
User & Date: drh 2016-07-26 04:54:54
Context
2016-07-26
15:17
Merge fixes to sqlite3_scrub_backup() from trunk. check-in: 91e811f5 user: drh tags: apple-osx
04:54
Merge the cache_spill VACUUM fix from trunk. check-in: cc6bfdf8 user: drh tags: apple-osx
04:49
Copy the cache_spill setting from the main database over to the vacuum_db transient database when running a VACUUM. check-in: c0e7d98e user: drh tags: trunk
04:23
Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. check-in: 0e9f534f user: drh tags: apple-osx
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/vacuum.c.

   194    194       char *zKey;
   195    195       sqlite3CodecGetKey(db, 0, (void**)&zKey, &nKey);
   196    196       if( nKey ) db->nextPagesize = 0;
   197    197     }
   198    198   #endif
   199    199   
   200    200     sqlite3BtreeSetCacheSize(pTemp, db->aDb[0].pSchema->cache_size);
          201  +  sqlite3BtreeSetSpillSize(pTemp, sqlite3BtreeSetSpillSize(pMain,0));
   201    202     rc = execSql(db, pzErrMsg, "PRAGMA vacuum_db.synchronous=OFF");
   202    203     if( rc!=SQLITE_OK ) goto end_of_vacuum;
   203    204   
   204    205     /* Begin a transaction and take an exclusive lock on the main database
   205    206     ** file. This is done before the sqlite3BtreeGetPageSize(pMain) call below,
   206    207     ** to ensure that we do not try to change the page-size on a WAL database.
   207    208     */