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 117 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
128 } -sqlbody { | 128 } -sqlbody { |
129 BEGIN; | 129 BEGIN; |
130 CREATE TABLE t1(a,b,c); | 130 CREATE TABLE t1(a,b,c); |
131 CREATE TABLE test2.t2(a,b,c); | 131 CREATE TABLE test2.t2(a,b,c); |
132 COMMIT; | 132 COMMIT; |
133 } -exclude $ex | 133 } -exclude $ex |
134 } | 134 } |
135 | 135 |
136 # Test IO errors when replaying two hot journals from a 2-file | 136 # Test IO errors when replaying two hot journals from a 2-file |
137 # transaction. This test only runs on UNIX. | 137 # transaction. This test only runs on UNIX. |
| 138 # |
| 139 # It cannot be run under the "exclusive" permutation. In that case, the |
| 140 # locks held by the connection in the local (this) process prevent a |
| 141 # second connection from attempting the multi-file transaction. |
| 142 # |
138 ifcapable crashtest&&attach { | 143 ifcapable crashtest&&attach { |
139 if {![catch {sqlite3 -has_codec} r] && !$r} { | 144 if {![catch {sqlite3 -has-codec} r] && !$r && [permutation]!="exclusive"} { |
140 do_ioerr_test ioerr-6 -ckrefcount true -tclprep { | 145 do_ioerr_test ioerr-6 -ckrefcount true -tclprep { |
141 execsql { | 146 execsql { |
142 ATTACH 'test2.db' as aux; | 147 ATTACH 'test2.db' as aux; |
143 CREATE TABLE tx(a, b); | 148 CREATE TABLE tx(a, b); |
144 CREATE TABLE aux.ty(a, b); | 149 CREATE TABLE aux.ty(a, b); |
145 } | 150 } |
146 set rc [crashsql -delay 2 -file test2.db-journal { | 151 set rc [crashsql -delay 2 -file test2.db-journal { |
147 ATTACH 'test2.db' as aux; | 152 ATTACH 'test2.db' as aux; |
148 PRAGMA cache_size = 10; | 153 PRAGMA cache_size = 10; |
149 BEGIN; | 154 BEGIN; |
(...skipping 301 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
451 PRAGMA cache_size = 10; | 456 PRAGMA cache_size = 10; |
452 BEGIN; | 457 BEGIN; |
453 DELETE FROM t1 WHERE rowid IN (10,11,12) ; | 458 DELETE FROM t1 WHERE rowid IN (10,11,12) ; |
454 } -sqlbody { | 459 } -sqlbody { |
455 PRAGMA incremental_vacuum(10); | 460 PRAGMA incremental_vacuum(10); |
456 COMMIT; | 461 COMMIT; |
457 } | 462 } |
458 } | 463 } |
459 | 464 |
460 finish_test | 465 finish_test |
OLD | NEW |