aboutsummaryrefslogtreecommitdiff
path: root/testdata/mptest/config02.test
diff options
context:
space:
mode:
Diffstat (limited to 'testdata/mptest/config02.test')
-rw-r--r--testdata/mptest/config02.test123
1 files changed, 0 insertions, 123 deletions
diff --git a/testdata/mptest/config02.test b/testdata/mptest/config02.test
deleted file mode 100644
index 7d4b278..0000000
--- a/testdata/mptest/config02.test
+++ /dev/null
@@ -1,123 +0,0 @@
-/*
-** 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