1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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
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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
|
# 2008 December 15
#
# The author disclaims copyright to this source code. In place of
# a legal notice, here is a blessing:
#
# May you do good and not evil.
# May you find forgiveness for yourself and forgive others.
# May you share freely, never taking more than you give.
#
#***********************************************************************
#
# $Id: savepoint3.test,v 1.5 2009/06/05 17:09:12 drh Exp $
set testdir [file dirname $argv0]
source $testdir/tester.tcl
source $testdir/malloc_common.tcl
do_malloc_test savepoint3-1 -sqlprep {
CREATE TABLE t1(a, b, c);
INSERT INTO t1 VALUES(1, 2, 3);
} -sqlbody {
SAVEPOINT one;
INSERT INTO t1 VALUES(4, 5, 6);
SAVEPOINT two;
DELETE FROM t1;
ROLLBACK TO two;
RELEASE one;
}
do_malloc_test savepoint3-2 -sqlprep {
PRAGMA cache_size = 10;
CREATE TABLE t1(a, b, c);
INSERT INTO t1 VALUES(randstr(400,400), randstr(400,400), randstr(400,400));
INSERT INTO t1 SELECT
randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
INSERT INTO t1
SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
INSERT INTO t1
SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
INSERT INTO t1
SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
INSERT INTO t1
SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
INSERT INTO t1
SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
INSERT INTO t1
SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
INSERT INTO t1
SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
} -sqlbody {
PRAGMA cache_size = 10;
SAVEPOINT one;
DELETE FROM t1 WHERE rowid < 5;
SAVEPOINT two;
DELETE FROM t1 WHERE rowid > 10;
ROLLBACK TO two;
ROLLBACK TO one;
RELEASE one;
}
do_ioerr_test savepoint3.3 -sqlprep {
CREATE TABLE t1(a, b, c);
INSERT INTO t1 VALUES(1, randstr(1000,1000), randstr(1000,1000));
INSERT INTO t1 VALUES(2, randstr(1000,1000), randstr(1000,1000));
} -sqlbody {
BEGIN;
UPDATE t1 SET a = 3 WHERE a = 1;
SAVEPOINT one;
UPDATE t1 SET a = 4 WHERE a = 2;
COMMIT;
} -cleanup {
db eval {
SAVEPOINT one;
RELEASE one;
}
}
# The following test does a really big savepoint rollback. One involving
# more than 4000 pages. The idea is to get a specific sqlite3BitvecSet()
# operation in pagerPlaybackSavepoint() to fail.
#do_malloc_test savepoint3-4 -sqlprep {
# BEGIN;
# CREATE TABLE t1(a, b);
# CREATE INDEX i1 ON t1(a);
# CREATE INDEX i2 ON t1(b);
# INSERT INTO t1 VALUES(randstr(500,500), randstr(500,500)); -- 1
# INSERT INTO t1 VALUES(randstr(500,500), randstr(500,500)); -- 2
# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 4
# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 8
# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 16
# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 32
# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 64
# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 128
# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 256
# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 512
# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 1024
# INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 2048
# COMMIT;
# BEGIN;
# SAVEPOINT abc;
# UPDATE t1 SET a = randstr(500,500);
#} -sqlbody {
# ROLLBACK TO abc;
#}
# Cause a specific malloc in savepoint rollback code to fail.
#
do_malloc_test savepoint3-4 -start 7 -sqlprep {
PRAGMA auto_vacuum = incremental;
PRAGMA cache_size = 1000;
CREATE TABLE t1(a, b);
CREATE TABLE t2(a, b);
CREATE TABLE t3(a, b);
INSERT INTO t1 VALUES(1, randstr(500,500));
INSERT INTO t1 VALUES(2, randstr(500,500));
INSERT INTO t1 VALUES(3, randstr(500,500));
DELETE FROM t1;
BEGIN;
INSERT INTO t1 VALUES(1, randstr(500,500));
INSERT INTO t1 VALUES(2, randstr(500,500));
INSERT INTO t1 VALUES(3, randstr(500,500));
DROP TABLE t3; -- Page 5 of the database file is now free.
DROP TABLE t2; -- Page 4 of the database file is now free.
SAVEPOINT abc;
PRAGMA incremental_vacuum;
} -sqlbody {
ROLLBACK TO abc;
}
finish_test
|
