| 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 |