| 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 |