/ Check-in [8cb39306]
Login

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

Overview
Comment:Fix a couple of test files so that they work with DEFAULT_AUTOVACUUM.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 8cb39306f4bd9104c9d15d5ee98ec1252e798997
User & Date: dan 2010-09-13 14:38:19
Context
2010-09-13
18:58
Add tests for compound SELECT statements to e_select.test. check-in: 8b0b009f user: dan tags: trunk
14:38
Fix a couple of test files so that they work with DEFAULT_AUTOVACUUM. check-in: 8cb39306 user: dan tags: trunk
12:15
Run the multi-threaded tests in test/threadtest3.c as part of releasetest.tcl. Remove the OMIT_BUILTIN_TEST symbol from the "Device-Two" configuration. check-in: 3f5406e3 user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Show Whitespace Changes Patch

Changes to test/memsubsys1.test.

    94     94   sqlite3_config_pagecache [expr 1024+$xtra_size] 20
    95     95   sqlite3_initialize
    96     96   reset_highwater_marks
    97     97   build_test_db memsubsys1-2 {PRAGMA page_size=1024}
    98     98   #show_memstats
    99     99   do_test memsubsys1-2.3 {
   100    100     set pg_ovfl [lindex [sqlite3_status SQLITE_STATUS_PAGECACHE_OVERFLOW 0] 2]
   101         -} 0
          101  +} [expr $AUTOVACUUM*1024]
   102    102   do_test memsubsys1-2.4 {
   103    103     set pg_used [lindex [sqlite3_status SQLITE_STATUS_PAGECACHE_USED 0] 2]
   104    104   } 20
   105    105   do_test memsubsys1-2.5 {
   106    106     set s_used [lindex [sqlite3_status SQLITE_STATUS_SCRATCH_USED 0] 2]
   107    107   } 0
   108    108   

Changes to test/stat.test.

    23     23   
    24     24   set ::asc 1
    25     25   proc a_string {n} { string range [string repeat [incr ::asc]. $n] 1 $n }
    26     26   db func a_string a_string
    27     27   
    28     28   register_dbstat_vtab db
    29     29   do_execsql_test stat-0.0 {
           30  +  PRAGMA auto_vacuum = OFF;
    30     31     CREATE VIRTUAL TABLE temp.stat USING dbstat;
    31     32     SELECT * FROM stat;
    32     33   } {}
    33     34   
    34     35   ifcapable wal {
    35     36     do_execsql_test stat-0.1 {
    36     37       PRAGMA journal_mode = WAL;
................................................................................
   139    140   
   140    141   db close
   141    142   file delete -force test.db
   142    143   sqlite3 db test.db
   143    144   register_dbstat_vtab db
   144    145   breakpoint
   145    146   do_execsql_test stat-5.1 {
          147  +  PRAGMA auto_vacuum = OFF;
   146    148     CREATE VIRTUAL TABLE temp.stat USING dbstat;
   147    149     CREATE TABLE t1(x);
   148    150     INSERT INTO t1 VALUES(zeroblob(1513));
   149    151     INSERT INTO t1 VALUES(zeroblob(1514));
   150    152     SELECT * FROM stat WHERE name = 't1';
   151    153   } [list \
   152    154     t1 / 2 leaf 2 993 5 1517                \
   153    155     t1 /000+000000 3 overflow 0 1020 0 0    \
   154    156     t1 /001+000000 4 overflow 0 1020 0 0    \
   155    157   ]
   156    158   
   157    159   finish_test