OLD | NEW |
1 /* Test cases involving incomplete transactions that must be rolled back. | 1 /* Test cases involving incomplete transactions that must be rolled back. |
2 */ | 2 */ |
3 --task 1 | 3 --task 1 |
4 DROP TABLE IF EXISTS t1; | 4 DROP TABLE IF EXISTS t1; |
5 CREATE TABLE t1(a INTEGER PRIMARY KEY, b); | 5 CREATE TABLE t1(a INTEGER PRIMARY KEY, b); |
6 --sleep 1 | 6 --sleep 1 |
7 INSERT INTO t1 VALUES(1, randomblob(2000)); | 7 INSERT INTO t1 VALUES(1, randomblob(2000)); |
8 INSERT INTO t1 VALUES(2, randomblob(1000)); | 8 INSERT INTO t1 VALUES(2, randomblob(1000)); |
9 --sleep 1 | 9 --sleep 1 |
10 INSERT INTO t1 SELECT a+2, randomblob(1500) FROM t1; | 10 INSERT INTO t1 SELECT a+2, randomblob(1500) FROM t1; |
(...skipping 82 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
93 ** multiple times. */ | 93 ** multiple times. */ |
94 --source crash02.subtest | 94 --source crash02.subtest |
95 --source crash02.subtest | 95 --source crash02.subtest |
96 --source crash02.subtest | 96 --source crash02.subtest |
97 --source crash02.subtest | 97 --source crash02.subtest |
98 --source crash02.subtest | 98 --source crash02.subtest |
99 --source crash02.subtest | 99 --source crash02.subtest |
100 --source crash02.subtest | 100 --source crash02.subtest |
101 --source crash02.subtest | 101 --source crash02.subtest |
102 --source crash02.subtest | 102 --source crash02.subtest |
OLD | NEW |