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 |