/ Check-in [e790aac0]
Login

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

Overview
Comment:Fix an issue in temptable2.test preventing it from working with SQLITE_DEFAULT_AUTOVACUUM=1 builds.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | tempfiles-25
Files: files | file ages | folders
SHA1: e790aac02e4b427b4891b514a050699d159b03b1
User & Date: dan 2016-04-26 17:10:03
Context
2016-04-27
11:24
Fix a couple of test script problems on this branch. Both related to the fact that temp database page sizes can no longer be changed by VACUUM or the backup API after the temp db is populated. check-in: 6bb5aa2b user: dan tags: tempfiles-25
2016-04-26
17:10
Fix an issue in temptable2.test preventing it from working with SQLITE_DEFAULT_AUTOVACUUM=1 builds. check-in: e790aac0 user: dan tags: tempfiles-25
16:03
Merge the checksymbols fix from trunk into this branch. check-in: 04911cee user: dan tags: tempfiles-25
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/temptable2.test.

   220    220   
   221    221   #-------------------------------------------------------------------------
   222    222   # Try changing the page size using a backup operation when pages are
   223    223   # stored in main-memory only.
   224    224   #
   225    225   reset_db
   226    226   do_execsql_test 8.1 {
          227  +  PRAGMA auto_vacuum = OFF;
   227    228     CREATE TABLE t2(a, b);
   228    229     CREATE INDEX i2 ON t2(a, b);
   229    230     WITH x(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM x WHERE i<20 )
   230    231     INSERT INTO t2 SELECT randomblob(100), randomblob(100) FROM x;
   231    232     PRAGMA page_count;
   232    233   } {13}
   233    234   
   234    235   do_test 8.2 {
   235    236     sqlite3 tmp ""
   236    237     execsql {
          238  +    PRAGMA auto_vacuum = OFF;
   237    239       PRAGMA page_size = 8192;
   238    240       CREATE TABLE t1(a, b);
   239    241       CREATE INDEX i1 ON t1(a, b);
   240    242       WITH x(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM x WHERE i<100 )
   241    243       INSERT INTO t1 SELECT randomblob(100), randomblob(100) FROM x;
   242    244       PRAGMA page_count;
   243    245     } tmp