1 # 2010 June 15 2 # 3 # The author disclaims copyright to this source code. In place of 4 # a legal notice, here is a blessing: 5 # 6 # May you do good and not evil. 7 # May you find forgiveness for yourself and forgive others. 8 # May you share freely, never taking more than you give. 9 # 10 #*********************************************************************** 11 # 12 13 set testdir [file dirname $argv0] 14 source $testdir/tester.tcl 15 16 set ::testprefix fts3fault 17 18 # If SQLITE_ENABLE_FTS3 is not defined, omit this file. 19 ifcapable !fts3 { finish_test ; return } 20 21 if 1 { 22 23 # Test error handling in the sqlite3Fts3Init() function. This is the 24 # function that registers the FTS3 module and various support functions 25 # with SQLite. 26 # 27 do_faultsim_test 1 -body { 28 sqlite3 db test.db 29 expr 0 30 } -test { 31 catch { db close } 32 } 33 34 # Test error handling in an "ALTER TABLE ... RENAME TO" statement on an 35 # FTS3 table. Specifically, test renaming the table within a transaction 36 # after it has been written to. 37 # 38 faultsim_delete_and_reopen 39 do_execsql_test 2.0 { 40 CREATE VIRTUAL TABLE t1 USING fts3; 41 INSERT INTO t1 VALUES('test renaming the table'); 42 INSERT INTO t1 VALUES(' after it has been written'); 43 } 44 do_faultsim_test 2 -prep { 45 sqlite3 db test.db 46 execsql { 47 BEGIN; 48 INSERT INTO t1 VALUES('registers the FTS3 module'); 49 INSERT INTO t1 VALUES('various support functions'); 50 } 51 } -body { 52 execsql { ALTER TABLE t1 RENAME TO t2 } 53 } -test { 54 faultsim_test_result {0 {}} 55 } 56 57 # Test error handling in the special case where a single prefix query 58 # matches terms that reside on a large range of leaf nodes. 59 # 60 do_test fts3fault-3.0 { 61 sqlite3 db test.db 62 execsql { CREATE VIRTUAL TABLE t3 USING fts4; } 63 execsql { INSERT INTO t3(t3) VALUES('nodesize=50') } 64 execsql { BEGIN } 65 for {set i 0} {$i < 1000} {incr i} { 66 execsql { INSERT INTO t3 VALUES('aaa' || $i) } 67 } 68 execsql { COMMIT } 69 } {} 70 71 do_faultsim_test 3 -faults oom-transient -prep { 72 sqlite3 db test.db 73 execsql { SELECT * FROM t3 WHERE t3 MATCH 'x' } 74 } -body { 75 execsql { SELECT count(rowid) FROM t3 WHERE t3 MATCH 'aa*' } 76 } -test { 77 faultsim_test_result {0 1000} 78 } 79 80 do_test fts3fault-4.0 { 81 faultsim_delete_and_reopen 82 execsql { 83 CREATE VIRTUAL TABLE t4 USING fts4; 84 INSERT INTO t4 VALUES('The British Government called on'); 85 INSERT INTO t4 VALUES('as pesetas then became much'); 86 } 87 } {} 88 faultsim_save_and_close 89 do_faultsim_test 4 -prep { 90 faultsim_restore_and_reopen 91 execsql { SELECT content FROM t4 } 92 } -body { 93 execsql { SELECT optimize(t4) FROM t4 LIMIT 1 } 94 } -test { 95 faultsim_test_result {0 {{Index optimized}}} 96 } 97 98 do_test fts3fault-5.0 { 99 faultsim_delete_and_reopen 100 execsql { 101 CREATE VIRTUAL TABLE t5 USING fts4; 102 INSERT INTO t5 VALUES('The British Government called on'); 103 INSERT INTO t5 VALUES('as pesetas then became much'); 104 } 105 } {} 106 faultsim_save_and_close 107 do_faultsim_test 5 -prep { 108 faultsim_restore_and_reopen 109 execsql { 110 BEGIN; 111 INSERT INTO t5 VALUES('influential in shaping his future outlook'); 112 INSERT INTO t5 VALUES('might be acceptable to the British electorate'); 113 } 114 } -body { 115 execsql { SELECT rowid FROM t5 WHERE t5 MATCH 'british' } 116 } -test { 117 faultsim_test_result {0 {1 4}} 118 } 119 120 do_test fts3fault-6.0 { 121 faultsim_delete_and_reopen 122 execsql { CREATE VIRTUAL TABLE t6 USING fts4 } 123 } {} 124 faultsim_save_and_close 125 do_faultsim_test 6 -prep { 126 faultsim_restore_and_reopen 127 execsql { SELECT rowid FROM t6 } 128 } -body { 129 execsql { DROP TABLE t6 } 130 } -test { 131 faultsim_test_result {0 {}} 132 } 133 134 # Test various malloc failures while processing FTS4 parameters. 135 # 136 do_faultsim_test 7.1 -prep { 137 faultsim_delete_and_reopen 138 } -body { 139 execsql { CREATE VIRTUAL TABLE t1 USING fts4(a, b, matchinfo=fts3) } 140 } -test { 141 faultsim_test_result {0 {}} 142 } 143 do_faultsim_test 7.2 -prep { 144 faultsim_delete_and_reopen 145 } -body { 146 execsql { CREATE VIRTUAL TABLE t1 USING fts4(a, b, matchinfo=fs3) } 147 } -test { 148 faultsim_test_result {1 {unrecognized matchinfo: fs3}} \ 149 {1 {vtable constructor failed: t1}} 150 } 151 do_faultsim_test 7.3 -prep { 152 faultsim_delete_and_reopen 153 } -body { 154 execsql { CREATE VIRTUAL TABLE t1 USING fts4(a, b, matchnfo=fts3) } 155 } -test { 156 faultsim_test_result {1 {unrecognized parameter: matchnfo=fts3}} \ 157 {1 {vtable constructor failed: t1}} 158 } 159 160 } 161 162 proc mit {blob} { 163 set scan(littleEndian) i* 164 set scan(bigEndian) I* 165 binary scan $blob $scan($::tcl_platform(byteOrder)) r 166 return $r 167 } 168 169 do_test 8.0 { 170 faultsim_delete_and_reopen 171 execsql { CREATE VIRTUAL TABLE t8 USING fts4 } 172 execsql "INSERT INTO t8 VALUES('a b c')" 173 execsql "INSERT INTO t8 VALUES('b b b')" 174 execsql "INSERT INTO t8 VALUES('[string repeat {c } 50000]')" 175 execsql "INSERT INTO t8 VALUES('d d d')" 176 execsql "INSERT INTO t8 VALUES('e e e')" 177 execsql "INSERT INTO t8(t8) VALUES('optimize')" 178 faultsim_save_and_close 179 } {} 180 181 do_faultsim_test 8.1 -prep { 182 faultsim_restore_and_reopen 183 db func mit mit 184 } -body { 185 execsql { SELECT mit(matchinfo(t8, 'x')) FROM t8 WHERE t8 MATCH 'a b c' } 186 } -test { 187 faultsim_test_result {0 {{1 1 1 1 4 2 1 5 5}}} 188 } 189 do_faultsim_test 8.2 -faults oom-t* -prep { 190 faultsim_restore_and_reopen 191 db func mit mit 192 } -body { 193 execsql { SELECT mit(matchinfo(t8, 's')) FROM t8 WHERE t8 MATCH 'a b c' } 194 } -test { 195 faultsim_test_result {0 3} 196 } 197 do_faultsim_test 8.3 -prep { 198 faultsim_restore_and_reopen 199 db func mit mit 200 } -body { 201 execsql { SELECT mit(matchinfo(t8, 'a')) FROM t8 WHERE t8 MATCH 'a b c' } 202 } -test { 203 faultsim_test_result {0 10002} 204 } 205 do_faultsim_test 8.4 -prep { 206 faultsim_restore_and_reopen 207 db func mit mit 208 } -body { 209 execsql { SELECT mit(matchinfo(t8, 'l')) FROM t8 WHERE t8 MATCH 'a b c' } 210 } -test { 211 faultsim_test_result {0 3} 212 } 213 214 do_test 9.0 { 215 faultsim_delete_and_reopen 216 execsql { 217 CREATE VIRTUAL TABLE t9 USING fts4(tokenize=porter); 218 INSERT INTO t9 VALUES( 219 'this record is used toooooooooooooooooooooooooooooooooooooo try to' 220 ); 221 SELECT offsets(t9) FROM t9 WHERE t9 MATCH 'to*'; 222 } 223 faultsim_save_and_close 224 } {} 225 do_faultsim_test 9.1 -prep { 226 faultsim_restore_and_reopen 227 } -body { 228 execsql { SELECT offsets(t9) FROM t9 WHERE t9 MATCH 'to*' } 229 } -test { 230 faultsim_test_result {0 {{0 0 20 39 0 0 64 2}}} 231 } 232 233 finish_test 234
