OLD | NEW |
1 # 2001 October 12 | 1 # 2001 October 12 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 64 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
75 set ::sqlite_diskfull_pending 0 | 75 set ::sqlite_diskfull_pending 0 |
76 db close | 76 db close |
77 sqlite3 db test.db | 77 sqlite3 db test.db |
78 integrity_check ${prefix}.$::i.2 | 78 integrity_check ${prefix}.$::i.2 |
79 } | 79 } |
80 } | 80 } |
81 | 81 |
82 do_diskfull_test diskfull-2 VACUUM | 82 do_diskfull_test diskfull-2 VACUUM |
83 | 83 |
84 # db close | 84 # db close |
85 # file delete -force test.db | 85 # forcedelete test.db |
86 # file delete -force test.db-journal | 86 # forcedelete test.db-journal |
87 # sqlite3 db test.db | 87 # sqlite3 db test.db |
88 # | 88 # |
89 # do_test diskfull-3.1 { | 89 # do_test diskfull-3.1 { |
90 # execsql { | 90 # execsql { |
91 # PRAGMA default_cache_size = 10; | 91 # PRAGMA default_cache_size = 10; |
92 # CREATE TABLE t3(a, b, UNIQUE(a, b)); | 92 # CREATE TABLE t3(a, b, UNIQUE(a, b)); |
93 # INSERT INTO t3 VALUES( randstr(100, 100), randstr(100, 100) ); | 93 # INSERT INTO t3 VALUES( randstr(100, 100), randstr(100, 100) ); |
94 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; | 94 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; |
95 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; | 95 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; |
96 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; | 96 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; |
97 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; | 97 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; |
98 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; | 98 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; |
99 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; | 99 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; |
100 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; | 100 # INSERT INTO t3 SELECT randstr(100, 100), randstr(100, 100) FROM t3; |
101 # UPDATE t3 | 101 # UPDATE t3 |
102 # SET b = (SELECT a FROM t3 WHERE rowid = (SELECT max(rowid)-1 FROM t3)) | 102 # SET b = (SELECT a FROM t3 WHERE rowid = (SELECT max(rowid)-1 FROM t3)) |
103 # WHERE rowid = (SELECT max(rowid) FROM t3); | 103 # WHERE rowid = (SELECT max(rowid) FROM t3); |
104 # PRAGMA cache_size; | 104 # PRAGMA cache_size; |
105 # } | 105 # } |
106 # } {10} | 106 # } {10} |
107 # | 107 # |
108 # do_diskfull_test diskfull-3.2 { | 108 # do_diskfull_test diskfull-3.2 { |
109 # BEGIN; | 109 # BEGIN; |
110 # INSERT INTO t3 VALUES( randstr(100, 100), randstr(100, 100) ); | 110 # INSERT INTO t3 VALUES( randstr(100, 100), randstr(100, 100) ); |
111 # UPDATE t3 SET a = b; | 111 # UPDATE t3 SET a = b; |
112 # COMMIT; | 112 # COMMIT; |
113 # } | 113 # } |
114 | 114 |
115 finish_test | 115 finish_test |
OLD | NEW |