drh | 3f5bc38 | 2013-04-06 13:09:11 +0000 | [diff] [blame] | 1 | /* |
| 2 | ** Configure five tasks in different ways, then run tests. |
| 3 | */ |
drh | 1bf44c7 | 2013-04-08 13:48:29 +0000 | [diff] [blame] | 4 | --if vfsname() GLOB 'unix' |
drh | 3f5bc38 | 2013-04-06 13:09:11 +0000 | [diff] [blame] | 5 | PRAGMA page_size=8192; |
| 6 | --task 1 |
| 7 | PRAGMA journal_mode=PERSIST; |
drh | 9b4c59f | 2013-04-15 17:03:42 +0000 | [diff] [blame] | 8 | PRAGMA mmap_size=0; |
drh | 3f5bc38 | 2013-04-06 13:09:11 +0000 | [diff] [blame] | 9 | --end |
| 10 | --task 2 |
| 11 | PRAGMA journal_mode=TRUNCATE; |
drh | 9b4c59f | 2013-04-15 17:03:42 +0000 | [diff] [blame] | 12 | PRAGMA mmap_size=28672; |
drh | 3f5bc38 | 2013-04-06 13:09:11 +0000 | [diff] [blame] | 13 | --end |
| 14 | --task 3 |
| 15 | PRAGMA journal_mode=MEMORY; |
| 16 | --end |
| 17 | --task 4 |
| 18 | PRAGMA journal_mode=OFF; |
| 19 | --end |
drh | 9b4c59f | 2013-04-15 17:03:42 +0000 | [diff] [blame] | 20 | --task 4 |
| 21 | PRAGMA mmap_size(268435456); |
| 22 | --end |
drh | 3f5bc38 | 2013-04-06 13:09:11 +0000 | [diff] [blame] | 23 | --source multiwrite01.test |
drh | 1bf44c7 | 2013-04-08 13:48:29 +0000 | [diff] [blame] | 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 |