Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: |
Downloads: |
Tarball
| ZIP archive
|
---|
Timelines: |
family
| ancestors
| descendants
| both
| two-mappings
|
Files: |
files
| file ages
| folders
|
SHA1: |
23ffa4f9fbad2e39cbe4776c7fdb61f757b6fc78 |
User & Date: |
dan
2013-03-29 19:38:52.044 |
Context
2013-04-01
| | |
14:20 |
|
(Leaf
check-in: 80c63443c4 user: dan tags: two-mappings)
|
2013-03-29
| | |
19:38 |
|
(check-in: 23ffa4f9fb user: dan tags: two-mappings)
|
18:52 |
|
(check-in: e8bcdf938e user: dan tags: two-mappings)
|
| | |
Changes
Changes to test/corruptC.test.
︙ | | |
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
|
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
|
-
+
|
forcecopy test.bu test.db
sqlite3 db test.db
set blob [string repeat abcdefghij 10000]
execsql { INSERT INTO t1 VALUES (1, $blob) }
sqlite3 db test.db
set filesize [file size test.db]
set filesize [expr [file_page_count test.db] * [file_page_size test.db]]
hexio_write test.db [expr $filesize-2048] 00000001
catchsql {DELETE FROM t1 WHERE rowid = (SELECT max(rowid) FROM t1)}
} {1 {database disk image is malformed}}
# At one point this particular corrupt database was causing a buffer
# overread. Which caused a crash in a run of all.test once.
#
|
︙ | | |
Changes to test/crash.test.
︙ | | |
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
|
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
|
-
+
|
INSERT INTO abc VALUES(randstr(1500,1500), 0, 0); -- Overflow page 4
INSERT INTO abc SELECT * FROM abc;
INSERT INTO abc SELECT * FROM abc;
INSERT INTO abc SELECT * FROM abc;
}
} {}
do_test crash-5.2 {
expr [file size test.db] / 1024
file_page_count test.db
} [expr [string match [execsql {pragma auto_vacuum}] 1] ? 11 : 10]
set sig [signature]
do_test crash-5.3 {
# The SQL below is used to expose a bug that existed in
# sqlite3pager_movepage() during development of the auto-vacuum feature. It
# functions as follows:
#
|
︙ | | |
Changes to test/permutations.test.
︙ | | |
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
|
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
|
-
+
|
]
test_suite "full" -prefix "" -description {
Full test suite. Takes a long time.
} -files [
test_set $alltests
] -initialize {
unset -nocomplain ::G(isquick)
# unset -nocomplain ::G(isquick)
}
test_suite "threads" -prefix "" -description {
All multi-threaded tests.
} -files {
notify2.test thread001.test thread002.test thread003.test
thread004.test thread005.test walthread.test
|
︙ | | |
Changes to test/sqllimits1.test.
︙ | | |
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
|
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
|
-
+
-
+
|
INSERT INTO abc SELECT a||b||c, b||c||a, c||a||b FROM abc;
INSERT INTO abc SELECT a||b||c, b||c||a, c||a||b FROM abc;
INSERT INTO abc SELECT a||b||c, b||c||a, c||a||b FROM abc;
INSERT INTO abc SELECT a, b, c FROM abc;
INSERT INTO abc SELECT b, a, c FROM abc;
INSERT INTO abc SELECT c, b, a FROM abc;
}
expr [file size test.db] / 1024
file_page_count test.db
} $fsize
do_test sqllimits1-7.7.2 {
db close
sqlite3 db test.db
execsql {
PRAGMA max_page_count = 1000;
}
execsql {
SELECT count(*) FROM sqlite_master;
}
} {6}
do_test sqllimits1-7.7.3 {
execsql {
PRAGMA max_page_count;
}
} $fsize
} [expr [file size test.db] / 1024]
do_test sqllimits1-7.7.4 {
execsql {
DROP TABLE abc;
}
} {}
#--------------------------------------------------------------------
|
︙ | | |
Changes to test/vacuum3.test.
︙ | | |
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
|
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
-
-
+
+
-
+
+
-
-
+
+
|
INSERT INTO t1 VALUES(1, 2, 3);
}
} {}
do_test vacuum3-1.2 {
execsql { PRAGMA page_size }
} {1024}
do_test vacuum3-1.3 {
file size test.db
} {2048}
file_page_count test.db
} {2}
set I 4
foreach {request actual database} [list \
2048 2048 4096 \
1024 1024 2048 \
1170 1024 2048 \
256 1024 2048 \
512 512 1024 \
4096 4096 8192 \
1024 1024 2048 \
] {
do_test vacuum3-1.$I.1 {
execsql "
PRAGMA page_size = $request;
VACUUM;
"
execsql { PRAGMA page_size }
} $actual
do_test vacuum3-1.$I.2 {
file size test.db
set nPg [file_page_count test.db]
expr {$nPg * $actual}
} $database
do_test vacuum3-1.$I.3 {
execsql { SELECT * FROM t1 }
} {1 2 3}
integrity_check vacuum3-1.$I.4
incr I
}
#-------------------------------------------------------------------
# Test cases vacuum3-2.* convert a simple 3-page database between a
# few different page sizes.
#
do_test vacuum3-2.1 {
execsql {
PRAGMA page_size = 1024;
VACUUM;
ALTER TABLE t1 ADD COLUMN d;
UPDATE t1 SET d = randomblob(1000);
}
file size test.db
} {3072}
file_page_count test.db
} {3}
do_test vacuum3-2.2 {
execsql { PRAGMA page_size }
} {1024}
do_test vacuum3-2.3 {
set blob [db one {select d from t1}]
string length $blob
} {1000}
|
︙ | | |