OLD | NEW |
(Empty) | |
| 1 /* |
| 2 ** Configure five tasks in different ways, then run tests. |
| 3 */ |
| 4 PRAGMA page_size=512; |
| 5 --task 1 |
| 6 PRAGMA mmap_size=0; |
| 7 --end |
| 8 --task 2 |
| 9 PRAGMA mmap_size=28672; |
| 10 --end |
| 11 --task 3 |
| 12 PRAGMA mmap_size=8192; |
| 13 --end |
| 14 --task 4 |
| 15 PRAGMA mmap_size=65536; |
| 16 --end |
| 17 --task 5 |
| 18 PRAGMA mmap_size=268435456; |
| 19 --end |
| 20 --source multiwrite01.test |
| 21 --source crash02.subtest |
| 22 PRAGMA page_size=1024; |
| 23 VACUUM; |
| 24 CREATE TABLE pgsz(taskid, sz INTEGER); |
| 25 --task 1 |
| 26 INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size')); |
| 27 --end |
| 28 --task 2 |
| 29 INSERT INTO pgsz VALUES(2, eval('PRAGMA page_size')); |
| 30 --end |
| 31 --task 3 |
| 32 INSERT INTO pgsz VALUES(3, eval('PRAGMA page_size')); |
| 33 --end |
| 34 --task 4 |
| 35 INSERT INTO pgsz VALUES(4, eval('PRAGMA page_size')); |
| 36 --end |
| 37 --task 5 |
| 38 INSERT INTO pgsz VALUES(5, eval('PRAGMA page_size')); |
| 39 --end |
| 40 --source multiwrite01.test |
| 41 --source crash02.subtest |
| 42 --wait all |
| 43 SELECT sz FROM pgsz; |
| 44 --match 1024 1024 1024 1024 1024 |
| 45 PRAGMA page_size=2048; |
| 46 VACUUM; |
| 47 DELETE FROM pgsz; |
| 48 --task 1 |
| 49 INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size')); |
| 50 --end |
| 51 --task 2 |
| 52 INSERT INTO pgsz VALUES(2, eval('PRAGMA page_size')); |
| 53 --end |
| 54 --task 3 |
| 55 INSERT INTO pgsz VALUES(3, eval('PRAGMA page_size')); |
| 56 --end |
| 57 --task 4 |
| 58 INSERT INTO pgsz VALUES(4, eval('PRAGMA page_size')); |
| 59 --end |
| 60 --task 5 |
| 61 INSERT INTO pgsz VALUES(5, eval('PRAGMA page_size')); |
| 62 --end |
| 63 --source multiwrite01.test |
| 64 --source crash02.subtest |
| 65 --wait all |
| 66 SELECT sz FROM pgsz; |
| 67 --match 2048 2048 2048 2048 2048 |
| 68 PRAGMA page_size=8192; |
| 69 VACUUM; |
| 70 DELETE FROM pgsz; |
| 71 --task 1 |
| 72 INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size')); |
| 73 --end |
| 74 --task 2 |
| 75 INSERT INTO pgsz VALUES(2, eval('PRAGMA page_size')); |
| 76 --end |
| 77 --task 3 |
| 78 INSERT INTO pgsz VALUES(3, eval('PRAGMA page_size')); |
| 79 --end |
| 80 --task 4 |
| 81 INSERT INTO pgsz VALUES(4, eval('PRAGMA page_size')); |
| 82 --end |
| 83 --task 5 |
| 84 INSERT INTO pgsz VALUES(5, eval('PRAGMA page_size')); |
| 85 --end |
| 86 --source multiwrite01.test |
| 87 --source crash02.subtest |
| 88 --wait all |
| 89 SELECT sz FROM pgsz; |
| 90 --match 8192 8192 8192 8192 8192 |
| 91 PRAGMA page_size=16384; |
| 92 VACUUM; |
| 93 DELETE FROM pgsz; |
| 94 --task 1 |
| 95 INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size')); |
| 96 --end |
| 97 --task 2 |
| 98 INSERT INTO pgsz VALUES(2, eval('PRAGMA page_size')); |
| 99 --end |
| 100 --task 3 |
| 101 INSERT INTO pgsz VALUES(3, eval('PRAGMA page_size')); |
| 102 --end |
| 103 --task 4 |
| 104 INSERT INTO pgsz VALUES(4, eval('PRAGMA page_size')); |
| 105 --end |
| 106 --task 5 |
| 107 INSERT INTO pgsz VALUES(5, eval('PRAGMA page_size')); |
| 108 --end |
| 109 --source multiwrite01.test |
| 110 --source crash02.subtest |
| 111 --wait all |
| 112 SELECT sz FROM pgsz; |
| 113 --match 16384 16384 16384 16384 16384 |
| 114 PRAGMA auto_vacuum=FULL; |
| 115 VACUUM; |
| 116 --source multiwrite01.test |
| 117 --source crash02.subtest |
| 118 --wait all |
| 119 PRAGMA auto_vacuum=FULL; |
| 120 PRAGMA page_size=512; |
| 121 VACUUM; |
| 122 --source multiwrite01.test |
| 123 --source crash02.subtest |
OLD | NEW |