| Index: third_party/sqlite/src/mptest/config02.test
|
| diff --git a/third_party/sqlite/src/mptest/config02.test b/third_party/sqlite/src/mptest/config02.test
|
| new file mode 100644
|
| index 0000000000000000000000000000000000000000..7d4b27898b4a913b33ddebdd99e36acafcd29cf9
|
| --- /dev/null
|
| +++ b/third_party/sqlite/src/mptest/config02.test
|
| @@ -0,0 +1,123 @@
|
| +/*
|
| +** Configure five tasks in different ways, then run tests.
|
| +*/
|
| +PRAGMA page_size=512;
|
| +--task 1
|
| + PRAGMA mmap_size=0;
|
| +--end
|
| +--task 2
|
| + PRAGMA mmap_size=28672;
|
| +--end
|
| +--task 3
|
| + PRAGMA mmap_size=8192;
|
| +--end
|
| +--task 4
|
| + PRAGMA mmap_size=65536;
|
| +--end
|
| +--task 5
|
| + PRAGMA mmap_size=268435456;
|
| +--end
|
| +--source multiwrite01.test
|
| +--source crash02.subtest
|
| +PRAGMA page_size=1024;
|
| +VACUUM;
|
| +CREATE TABLE pgsz(taskid, sz INTEGER);
|
| +--task 1
|
| + INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 2
|
| + INSERT INTO pgsz VALUES(2, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 3
|
| + INSERT INTO pgsz VALUES(3, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 4
|
| + INSERT INTO pgsz VALUES(4, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 5
|
| + INSERT INTO pgsz VALUES(5, eval('PRAGMA page_size'));
|
| +--end
|
| +--source multiwrite01.test
|
| +--source crash02.subtest
|
| +--wait all
|
| +SELECT sz FROM pgsz;
|
| +--match 1024 1024 1024 1024 1024
|
| +PRAGMA page_size=2048;
|
| +VACUUM;
|
| +DELETE FROM pgsz;
|
| +--task 1
|
| + INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 2
|
| + INSERT INTO pgsz VALUES(2, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 3
|
| + INSERT INTO pgsz VALUES(3, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 4
|
| + INSERT INTO pgsz VALUES(4, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 5
|
| + INSERT INTO pgsz VALUES(5, eval('PRAGMA page_size'));
|
| +--end
|
| +--source multiwrite01.test
|
| +--source crash02.subtest
|
| +--wait all
|
| +SELECT sz FROM pgsz;
|
| +--match 2048 2048 2048 2048 2048
|
| +PRAGMA page_size=8192;
|
| +VACUUM;
|
| +DELETE FROM pgsz;
|
| +--task 1
|
| + INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 2
|
| + INSERT INTO pgsz VALUES(2, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 3
|
| + INSERT INTO pgsz VALUES(3, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 4
|
| + INSERT INTO pgsz VALUES(4, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 5
|
| + INSERT INTO pgsz VALUES(5, eval('PRAGMA page_size'));
|
| +--end
|
| +--source multiwrite01.test
|
| +--source crash02.subtest
|
| +--wait all
|
| +SELECT sz FROM pgsz;
|
| +--match 8192 8192 8192 8192 8192
|
| +PRAGMA page_size=16384;
|
| +VACUUM;
|
| +DELETE FROM pgsz;
|
| +--task 1
|
| + INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 2
|
| + INSERT INTO pgsz VALUES(2, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 3
|
| + INSERT INTO pgsz VALUES(3, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 4
|
| + INSERT INTO pgsz VALUES(4, eval('PRAGMA page_size'));
|
| +--end
|
| +--task 5
|
| + INSERT INTO pgsz VALUES(5, eval('PRAGMA page_size'));
|
| +--end
|
| +--source multiwrite01.test
|
| +--source crash02.subtest
|
| +--wait all
|
| +SELECT sz FROM pgsz;
|
| +--match 16384 16384 16384 16384 16384
|
| +PRAGMA auto_vacuum=FULL;
|
| +VACUUM;
|
| +--source multiwrite01.test
|
| +--source crash02.subtest
|
| +--wait all
|
| +PRAGMA auto_vacuum=FULL;
|
| +PRAGMA page_size=512;
|
| +VACUUM;
|
| +--source multiwrite01.test
|
| +--source crash02.subtest
|
|
|