OLD | NEW |
1 # 2008 June 26 | 1 # 2008 June 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 195 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
206 | 206 |
207 do_test fts3d-4.matches { | 207 do_test fts3d-4.matches { |
208 execsql { | 208 execsql { |
209 SELECT OFFSETS(t1) FROM t1 | 209 SELECT OFFSETS(t1) FROM t1 |
210 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY docid; | 210 WHERE t1 MATCH 'this OR that OR was OR a OR is OR test' ORDER BY docid; |
211 } | 211 } |
212 } [list {0 0 0 4 0 4 5 2 0 3 8 1 0 5 10 4} \ | 212 } [list {0 0 0 4 0 4 5 2 0 3 8 1 0 5 10 4} \ |
213 {0 1 0 4 0 2 5 3 0 3 9 1 0 5 11 4} \ | 213 {0 1 0 4 0 2 5 3 0 3 9 1 0 5 11 4} \ |
214 {0 0 0 4 0 4 5 2 0 3 8 1 0 5 10 4}] | 214 {0 0 0 4 0 4 5 2 0 3 8 1 0 5 10 4}] |
215 | 215 |
216 puts [db eval {SELECT c FROM t1 } ] | 216 db eval {SELECT c FROM t1 } |
217 check_terms_all fts3d-4.1 {a four is test that this was} | 217 check_terms_all fts3d-4.1 {a four is test that this was} |
218 check_doclist_all fts3d-4.1.1 a {[1 0[2]] [2 0[2]] [3 0[2]]} | 218 check_doclist_all fts3d-4.1.1 a {[1 0[2]] [2 0[2]] [3 0[2]]} |
219 check_doclist_all fts3d-4.1.2 four {} | 219 check_doclist_all fts3d-4.1.2 four {} |
220 check_doclist_all fts3d-4.1.3 is {[1 0[1]] [3 0[1]]} | 220 check_doclist_all fts3d-4.1.3 is {[1 0[1]] [3 0[1]]} |
221 #check_doclist_all fts3d-4.1.4 one {} | 221 #check_doclist_all fts3d-4.1.4 one {} |
222 check_doclist_all fts3d-4.1.5 test {[1 0[3]] [2 0[3]] [3 0[3]]} | 222 check_doclist_all fts3d-4.1.5 test {[1 0[3]] [2 0[3]] [3 0[3]]} |
223 check_doclist_all fts3d-4.1.6 that {[2 0[0]]} | 223 check_doclist_all fts3d-4.1.6 that {[2 0[0]]} |
224 check_doclist_all fts3d-4.1.7 this {[1 0[0]] [3 0[0]]} | 224 check_doclist_all fts3d-4.1.7 this {[1 0[0]] [3 0[0]]} |
225 #check_doclist_all fts3d-4.1.8 three {} | 225 #check_doclist_all fts3d-4.1.8 three {} |
226 #check_doclist_all fts3d-4.1.9 two {} | 226 #check_doclist_all fts3d-4.1.9 two {} |
(...skipping 135 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
362 execsql { INSERT INTO xyz(xyz) VALUES('merge=2,2') } | 362 execsql { INSERT INTO xyz(xyz) VALUES('merge=2,2') } |
363 sqlite3 db test.db | 363 sqlite3 db test.db |
364 execsql { | 364 execsql { |
365 ALTER TABLE xyz RENAME TO ott; | 365 ALTER TABLE xyz RENAME TO ott; |
366 SELECT name FROM sqlite_master WHERE name GLOB '???_*' ORDER BY 1; | 366 SELECT name FROM sqlite_master WHERE name GLOB '???_*' ORDER BY 1; |
367 } | 367 } |
368 } {ott_content ott_segdir ott_segments ott_stat} | 368 } {ott_content ott_segdir ott_segments ott_stat} |
369 | 369 |
370 | 370 |
371 finish_test | 371 finish_test |
OLD | NEW |