Index: third_party/sqlite/sqlite-src-3080704/mptest/config02.test |
diff --git a/third_party/sqlite/sqlite-src-3080704/mptest/config02.test b/third_party/sqlite/sqlite-src-3080704/mptest/config02.test |
new file mode 100644 |
index 0000000000000000000000000000000000000000..7d4b27898b4a913b33ddebdd99e36acafcd29cf9 |
--- /dev/null |
+++ b/third_party/sqlite/sqlite-src-3080704/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 |