gitlab.com/cznic/sqlite.git@v1.0.0/testdata/mptest/config01.test (about)

     1  /*
     2  ** Configure five tasks in different ways, then run tests.
     3  */
     4  --if vfsname() GLOB 'unix'
     5  PRAGMA page_size=8192;
     6  --task 1
     7    PRAGMA journal_mode=PERSIST;
     8    PRAGMA mmap_size=0;
     9  --end
    10  --task 2
    11    PRAGMA journal_mode=TRUNCATE;
    12    PRAGMA mmap_size=28672;
    13  --end
    14  --task 3
    15    PRAGMA journal_mode=MEMORY;
    16  --end
    17  --task 4
    18    PRAGMA journal_mode=OFF;
    19  --end
    20  --task 4
    21    PRAGMA mmap_size(268435456);
    22  --end
    23  --source multiwrite01.test
    24  --wait all
    25  PRAGMA page_size=16384;
    26  VACUUM;
    27  CREATE TABLE pgsz(taskid, sz INTEGER);
    28  --task 1
    29    INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size'));
    30  --end
    31  --task 2
    32    INSERT INTO pgsz VALUES(2, eval('PRAGMA page_size'));
    33  --end
    34  --task 3
    35    INSERT INTO pgsz VALUES(3, eval('PRAGMA page_size'));
    36  --end
    37  --task 4
    38    INSERT INTO pgsz VALUES(4, eval('PRAGMA page_size'));
    39  --end
    40  --task 5
    41    INSERT INTO pgsz VALUES(5, eval('PRAGMA page_size'));
    42  --end
    43  --source multiwrite01.test
    44  --wait all
    45  SELECT sz FROM pgsz;
    46  --match 16384 16384 16384 16384 16384