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 905 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
916 INSERT INTO t1 VALUES('klmno' || $::big); | 916 INSERT INTO t1 VALUES('klmno' || $::big); |
917 CREATE INDEX i1 ON t1(a); | 917 CREATE INDEX i1 ON t1(a); |
918 } | 918 } |
919 do_faultsim_test 41.2 -faults oom* -body { | 919 do_faultsim_test 41.2 -faults oom* -body { |
920 execsql { SELECT * FROM t1 WHERE a = ('abcde' || $::big)} | 920 execsql { SELECT * FROM t1 WHERE a = ('abcde' || $::big)} |
921 } -test { | 921 } -test { |
922 faultsim_test_result [list 0 "abcde$::big"] | 922 faultsim_test_result [list 0 "abcde$::big"] |
923 faultsim_integrity_check | 923 faultsim_integrity_check |
924 } | 924 } |
925 | 925 |
| 926 reset_db |
| 927 do_execsql_test 42.0 { |
| 928 CREATE TABLE t1(x INTEGER PRIMARY KEY, y, z); |
| 929 CREATE TABLE t2(a, b); |
| 930 CREATE VIEW a002 AS SELECT *, sum(b) AS m FROM t2 GROUP BY a; |
| 931 } |
| 932 faultsim_save_and_close |
| 933 do_faultsim_test 42 -faults oom-tran* -prep { |
| 934 faultsim_restore_and_reopen |
| 935 execsql { SELECT * FROM sqlite_master } |
| 936 } -body { |
| 937 execsql { |
| 938 SELECT t1.z, a002.m |
| 939 FROM t1 JOIN a002 ON t1.y=a002.m |
| 940 WHERE t1.x IN (1,2,3); |
| 941 } |
| 942 } -test { |
| 943 faultsim_test_result {0 {}} |
| 944 } |
| 945 |
| 946 |
926 # Ensure that no file descriptors were leaked. | 947 # Ensure that no file descriptors were leaked. |
927 do_test malloc-99.X { | 948 do_test malloc-99.X { |
928 catch {db close} | 949 catch {db close} |
929 set sqlite_open_file_count | 950 set sqlite_open_file_count |
930 } {0} | 951 } {0} |
931 | 952 |
932 puts open-file-count=$sqlite_open_file_count | 953 puts open-file-count=$sqlite_open_file_count |
933 finish_test | 954 finish_test |
OLD | NEW |