| OLD | NEW |
| 1 # 2001 September 15. | 1 # 2001 September 15. |
| 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 463 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 474 | 474 |
| 475 # Make sure a database connection still works after changing the | 475 # Make sure a database connection still works after changing the |
| 476 # working directory. | 476 # working directory. |
| 477 # | 477 # |
| 478 do_test misc1-14.1 { | 478 do_test misc1-14.1 { |
| 479 file mkdir tempdir | 479 file mkdir tempdir |
| 480 cd tempdir | 480 cd tempdir |
| 481 execsql {BEGIN} | 481 execsql {BEGIN} |
| 482 file exists ./test.db-journal | 482 file exists ./test.db-journal |
| 483 } {0} | 483 } {0} |
| 484 do_test misc1-14.2 { | 484 do_test misc1-14.2a { |
| 485 execsql {UPDATE t1 SET a=0 WHERE 0} | 485 execsql {UPDATE t1 SET a=a||'x' WHERE 0} |
| 486 file exists ../test.db-journal |
| 487 } {0} |
| 488 do_test misc1-14.2b { |
| 489 execsql {UPDATE t1 SET a=a||'y' WHERE 1} |
| 486 file exists ../test.db-journal | 490 file exists ../test.db-journal |
| 487 } {1} | 491 } {1} |
| 488 do_test misc1-14.3 { | 492 do_test misc1-14.3 { |
| 489 cd .. | 493 cd .. |
| 490 file delete -force tempdir | 494 file delete -force tempdir |
| 491 execsql {COMMIT} | 495 execsql {COMMIT} |
| 492 file exists ./test.db-journal | 496 file exists ./test.db-journal |
| 493 } {0} | 497 } {0} |
| 494 | 498 |
| 495 # A failed create table should not leave the table in the internal | 499 # A failed create table should not leave the table in the internal |
| (...skipping 80 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 576 } | 580 } |
| 577 } {2 3} | 581 } {2 3} |
| 578 } | 582 } |
| 579 | 583 |
| 580 do_test misc1-18.1 { | 584 do_test misc1-18.1 { |
| 581 set n [sqlite3_sleep 100] | 585 set n [sqlite3_sleep 100] |
| 582 expr {$n>=100} | 586 expr {$n>=100} |
| 583 } {1} | 587 } {1} |
| 584 | 588 |
| 585 finish_test | 589 finish_test |
| OLD | NEW |