third_party/sqlite/sqlite-src-3080704/mptest/config02.test - Issue 949043002: Add //third_party/sqlite to dirs_to_snapshot, remove net_sql.patch

Side by Side Diff: third_party/sqlite/sqlite-src-3080704/mptest/config02.test

Issue 949043002: Add //third_party/sqlite to dirs_to_snapshot, remove net_sql.patch (Closed) Base URL: git@github.com:domokit/mojo.git@master

Patch Set: Created 5 years, 10 months ago

Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.

Jump to:

View unified diff | Download patch

OLD	NEW
(Empty)
	1 /*

	2 ** Configure five tasks in different ways, then run tests.

	3 */

	4 PRAGMA page_size=512;

	5 --task 1

	6 PRAGMA mmap_size=0;

	7 --end

	8 --task 2

	9 PRAGMA mmap_size=28672;

	10 --end

	11 --task 3

	12 PRAGMA mmap_size=8192;

	13 --end

	14 --task 4

	15 PRAGMA mmap_size=65536;

	16 --end

	17 --task 5

	18 PRAGMA mmap_size=268435456;

	19 --end

	20 --source multiwrite01.test

	21 --source crash02.subtest

	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

	41 --source crash02.subtest

	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

	64 --source crash02.subtest

	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

	87 --source crash02.subtest

	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

	110 --source crash02.subtest

	111 --wait all

	112 SELECT sz FROM pgsz;

	113 --match 16384 16384 16384 16384 16384

	114 PRAGMA auto_vacuum=FULL;

	115 VACUUM;

	116 --source multiwrite01.test

	117 --source crash02.subtest

	118 --wait all

	119 PRAGMA auto_vacuum=FULL;

	120 PRAGMA page_size=512;

	121 VACUUM;

	122 --source multiwrite01.test

	123 --source crash02.subtest

OLD	NEW