Blame - mptest/config02.test - chromium.googlesource.com/chromium/deps/sqlite

blob: 7d4b27898b4a913b33ddebdd99e36acafcd29cf9 [file] [log] [blame]

drh	554052c	2013-04-08 14:41:34 +0000	[diff] [blame]	1	/*
				2	** Configure five tasks in different ways, then run tests.
				3	*/
				4	PRAGMA page_size=512;
				5	--task 1
drh	9b4c59f	2013-04-15 17:03:42 +0000	[diff] [blame]	6	PRAGMA mmap_size=0;
drh	554052c	2013-04-08 14:41:34 +0000	[diff] [blame]	7	--end
				8	--task 2
drh	9b4c59f	2013-04-15 17:03:42 +0000	[diff] [blame]	9	PRAGMA mmap_size=28672;
drh	554052c	2013-04-08 14:41:34 +0000	[diff] [blame]	10	--end
				11	--task 3
drh	9b4c59f	2013-04-15 17:03:42 +0000	[diff] [blame]	12	PRAGMA mmap_size=8192;
drh	554052c	2013-04-08 14:41:34 +0000	[diff] [blame]	13	--end
				14	--task 4
drh	9b4c59f	2013-04-15 17:03:42 +0000	[diff] [blame]	15	PRAGMA mmap_size=65536;
				16	--end
				17	--task 5
				18	PRAGMA mmap_size=268435456;
drh	554052c	2013-04-08 14:41:34 +0000	[diff] [blame]	19	--end
				20	--source multiwrite01.test
drh	6adab7a	2013-04-08 18:58:00 +0000	[diff] [blame]	21	--source crash02.subtest
drh	554052c	2013-04-08 14:41:34 +0000	[diff] [blame]	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
drh	6adab7a	2013-04-08 18:58:00 +0000	[diff] [blame]	41	--source crash02.subtest
drh	554052c	2013-04-08 14:41:34 +0000	[diff] [blame]	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
drh	6adab7a	2013-04-08 18:58:00 +0000	[diff] [blame]	64	--source crash02.subtest
drh	554052c	2013-04-08 14:41:34 +0000	[diff] [blame]	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
drh	6adab7a	2013-04-08 18:58:00 +0000	[diff] [blame]	87	--source crash02.subtest
drh	554052c	2013-04-08 14:41:34 +0000	[diff] [blame]	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
drh	6adab7a	2013-04-08 18:58:00 +0000	[diff] [blame]	110	--source crash02.subtest
drh	554052c	2013-04-08 14:41:34 +0000	[diff] [blame]	111	--wait all
				112	SELECT sz FROM pgsz;
				113	--match 16384 16384 16384 16384 16384
drh	023dd90	2013-04-08 17:57:26 +0000	[diff] [blame]	114	PRAGMA auto_vacuum=FULL;
				115	VACUUM;
				116	--source multiwrite01.test
drh	6adab7a	2013-04-08 18:58:00 +0000	[diff] [blame]	117	--source crash02.subtest
drh	023dd90	2013-04-08 17:57:26 +0000	[diff] [blame]	118	--wait all
				119	PRAGMA auto_vacuum=FULL;
				120	PRAGMA page_size=512;
				121	VACUUM;
				122	--source multiwrite01.test
drh	6adab7a	2013-04-08 18:58:00 +0000	[diff] [blame]	123	--source crash02.subtest