Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Limit integrity_check output to 10 lines in mptester scripts. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
67ee0dc0f4de5dc2ae92fb98932f1fdd |
| User & Date: | drh 2013-04-09 20:04:09 |
Context
|
2013-04-10
| ||
| 02:56 | Correct test numbering on several rtree tests. (check-in: 0adf8a3a user: mistachkin tags: trunk) | |
|
2013-04-09
| ||
| 20:04 | Limit integrity_check output to 10 lines in mptester scripts. (check-in: 67ee0dc0 user: drh tags: trunk) | |
| 18:36 | Change the rollback journal so that it invokes sqlite3_log() make a record of a recovery, just as the WAL journal does. (check-in: 7cd3f6cd user: drh tags: trunk) | |
Changes
Changes to mptest/crash02.subtest.
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 |
--print Task one crashing an incomplete transaction --exit 1 --end --task 2 SELECT count(*) FROM t1; --match 64 --sleep 100 PRAGMA integrity_check; --output --match ok --end --task 3 SELECT count(*) FROM t1; --match 64 --sleep 100 PRAGMA integrity_check; --output --match ok --end --task 4 SELECT count(*) FROM t1; --match 64 --sleep 100 PRAGMA integrity_check; --output --match ok --end --task 5 SELECT count(*) FROM t1; --match 64 --sleep 100 PRAGMA integrity_check; --output --match ok --end --wait all |
| | | | |
22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 |
--print Task one crashing an incomplete transaction --exit 1 --end --task 2 SELECT count(*) FROM t1; --match 64 --sleep 100 PRAGMA integrity_check(10); --output --match ok --end --task 3 SELECT count(*) FROM t1; --match 64 --sleep 100 PRAGMA integrity_check(10); --output --match ok --end --task 4 SELECT count(*) FROM t1; --match 64 --sleep 100 PRAGMA integrity_check(10); --output --match ok --end --task 5 SELECT count(*) FROM t1; --match 64 --sleep 100 PRAGMA integrity_check(10); --output --match ok --end --wait all |
Changes to mptest/multiwrite01.test.
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
...
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
|
--match 45 46 47 48 49 50 51
--end
--wait all
--task 5
DROP INDEX t5b;
--sleep 5
PRAGMA integrity_check;
--match ok
CREATE INDEX t5b ON t5(b DESC);
--end
--task 3
DROP INDEX t3b;
--sleep 5
PRAGMA integrity_check;
--match ok
CREATE INDEX t3b ON t3(b DESC);
--end
--task 1
DROP INDEX t1b;
--sleep 5
PRAGMA integrity_check;
--match ok
CREATE INDEX t1b ON t1(b DESC);
--end
--task 2
DROP INDEX t2b;
--sleep 5
PRAGMA integrity_check;
--match ok
CREATE INDEX t2b ON t2(b DESC);
--end
--task 4
DROP INDEX t4b;
--sleep 5
PRAGMA integrity_check;
--match ok
CREATE INDEX t4b ON t4(b DESC);
--end
--wait all
--task 1
SELECT t1.a FROM t1, t2
................................................................................
WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
ORDER BY t3.a LIMIT 7
--match 45 46 47 48 49 50 51
--end
--wait all
VACUUM;
PRAGMA integrity_check;
--match ok
--task 1
UPDATE t1 SET b=randomblob(20000);
--sleep 5
UPDATE t1 SET b='x'||a||'y';
SELECT a FROM t1 WHERE b='x63y';
|
|
|
|
|
|
|
|
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
...
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
|
--match 45 46 47 48 49 50 51 --end --wait all --task 5 DROP INDEX t5b; --sleep 5 PRAGMA integrity_check(10); --match ok CREATE INDEX t5b ON t5(b DESC); --end --task 3 DROP INDEX t3b; --sleep 5 PRAGMA integrity_check(10); --match ok CREATE INDEX t3b ON t3(b DESC); --end --task 1 DROP INDEX t1b; --sleep 5 PRAGMA integrity_check(10); --match ok CREATE INDEX t1b ON t1(b DESC); --end --task 2 DROP INDEX t2b; --sleep 5 PRAGMA integrity_check(10); --match ok CREATE INDEX t2b ON t2(b DESC); --end --task 4 DROP INDEX t4b; --sleep 5 PRAGMA integrity_check(10); --match ok CREATE INDEX t4b ON t4(b DESC); --end --wait all --task 1 SELECT t1.a FROM t1, t2 ................................................................................ WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y') ORDER BY t3.a LIMIT 7 --match 45 46 47 48 49 50 51 --end --wait all VACUUM; PRAGMA integrity_check(10); --match ok --task 1 UPDATE t1 SET b=randomblob(20000); --sleep 5 UPDATE t1 SET b='x'||a||'y'; SELECT a FROM t1 WHERE b='x63y'; |