| OLD | NEW |
| 1 # 2007 April 26 | 1 # 2007 April 26 |
| 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 709 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 720 do_test incrvacuum-13.5 { | 720 do_test incrvacuum-13.5 { |
| 721 execsql { | 721 execsql { |
| 722 PRAGMA auto_vacuum; | 722 PRAGMA auto_vacuum; |
| 723 } | 723 } |
| 724 } {0} | 724 } {0} |
| 725 | 725 |
| 726 | 726 |
| 727 # Verify that the incremental_vacuum pragma fails gracefully if it | 727 # Verify that the incremental_vacuum pragma fails gracefully if it |
| 728 # is used against an invalid database file. | 728 # is used against an invalid database file. |
| 729 # | 729 # |
| 730 do_test incrvacuum-14.1 { | 730 if {[permutation] == ""} { |
| 731 set out [open invalid.db w] | 731 do_test incrvacuum-14.1 { |
| 732 puts $out "This is not an SQLite database file" | 732 set out [open invalid.db w] |
| 733 close $out | 733 puts $out "This is not an SQLite database file" |
| 734 sqlite3 db3 invalid.db | 734 close $out |
| 735 catchsql { | 735 sqlite3 db3 invalid.db |
| 736 PRAGMA incremental_vacuum(10); | 736 catchsql { |
| 737 } db3 | 737 PRAGMA incremental_vacuum(10); |
| 738 } {1 {file is encrypted or is not a database}} | 738 } db3 |
| 739 } {1 {file is encrypted or is not a database}} |
| 740 db3 close |
| 741 } |
| 739 | 742 |
| 740 do_test incrvacuum-15.1 { | 743 do_test incrvacuum-15.1 { |
| 741 db close | 744 db close |
| 742 db2 close | 745 db2 close |
| 743 file delete -force test.db | 746 file delete -force test.db |
| 744 sqlite3 db test.db | 747 sqlite3 db test.db |
| 745 | 748 |
| 746 set str [string repeat "abcdefghij" 500] | 749 set str [string repeat "abcdefghij" 500] |
| 747 | 750 |
| 748 execsql { | 751 execsql { |
| (...skipping 24 matching lines...) Expand all Loading... |
| 773 } | 776 } |
| 774 | 777 |
| 775 catchsql {INSERT INTO t2 SELECT * FROM t1} | 778 catchsql {INSERT INTO t2 SELECT * FROM t1} |
| 776 | 779 |
| 777 execsql { | 780 execsql { |
| 778 COMMIT; | 781 COMMIT; |
| 779 PRAGMA integrity_check; | 782 PRAGMA integrity_check; |
| 780 } | 783 } |
| 781 } {ok} | 784 } {ok} |
| 782 | 785 |
| 783 db3 close | |
| 784 finish_test | 786 finish_test |
| OLD | NEW |