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
|
# 2001 October 12
#
# 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.
#
#***********************************************************************
# This file implements regression tests for SQLite library. The
# focus of this file is testing for correct handling of disk full
# errors.
#
# $Id: diskfull.test,v 1.8 2008/07/12 14:52:20 drh Exp $
set testdir [file dirname $argv0]
source $testdir/tester.tcl
set sqlite_io_error_persist 0
set sqlite_io_error_hit 0
set sqlite_io_error_pending 0
do_test diskfull-1.1 {
execsql {
CREATE TABLE t1(x);
INSERT INTO t1 VALUES(randstr(1000,1000));
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
INSERT INTO t1 SELECT * FROM t1;
CREATE INDEX t1i1 ON t1(x);
CREATE TABLE t2 AS SELECT x AS a, x AS b FROM t1;
CREATE INDEX t2i1 ON t2(b);
}
} {}
set sqlite_diskfull_pending 0
integrity_check diskfull-1.2
do_test diskfull-1.3 {
set sqlite_diskfull_pending 1
catchsql {
INSERT INTO t1 SELECT * FROM t1;
}
} {1 {database or disk is full}}
set sqlite_diskfull_pending 0
integrity_check diskfull-1.4
do_test diskfull-1.5 {
set sqlite_diskfull_pending 1
catchsql {
DELETE FROM t1;
}
} {1 {database or disk is full}}
set sqlite_diskfull_pending 0
set sqlite_io_error_hit 0
integrity_check diskfull-1.6
proc do_diskfull_test {prefix sql} {
set ::go 1
set ::sql $sql
set ::i 1
while {$::go} {
incr ::i
do_test ${prefix}.$::i.1 {
set ::sqlite_diskfull_pending $::i
set ::sqlite_diskfull 0
set r [catchsql $::sql]
if {!$::sqlite_diskfull} {
set r {1 {database or disk is full}}
set ::go 0
}
if {$r=="1 {disk I/O error}"} {
set r {1 {database or disk is full}}
}
set r
} {1 {database or disk is full}}
set ::sqlite_diskfull_pending 0
db close
sqlite3 db test.db
integrity_check ${prefix}.$::i.2
}
}
do_diskfull_test diskfull-2 VACUUM
# db close
# forcedelete test.db
# forcedelete test.db-journal
# sqlite3 db test.db
#
# do_test diskfull-3.1 {
# execsql {
# PRAGMA default_cache_size = 10;
# CREATE TABLE t3(a, b, UNIQUE(a, b));
# INSERT INTO t3 VALUES( randstr(100, 100), randstr(100, 100) );
# INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3;
# INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3;
# INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3;
# INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3;
# INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3;
# INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3;
# INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3;
# UPDATE t3
# SET b = (SELECT a FROM t3 WHERE rowid = (SELECT max(rowid)-1 FROM t3))
# WHERE rowid = (SELECT max(rowid) FROM t3);
# PRAGMA cache_size;
# }
# } {10}
#
# do_diskfull_test diskfull-3.2 {
# BEGIN;
# INSERT INTO t3 VALUES( randstr(100, 100), randstr(100, 100) );
# UPDATE t3 SET a = b;
# COMMIT;
# }
finish_test
|
