| OLD | NEW |
| 1 # 2007 July 24 | 1 # 2007 July 24 |
| 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 77 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 88 execsql {SELECT a FROM fts_t1} | 88 execsql {SELECT a FROM fts_t1} |
| 89 } {{one three four} {one two three}} | 89 } {{one three four} {one two three}} |
| 90 do_test fts1o-3.6 { | 90 do_test fts1o-3.6 { |
| 91 execsql { SELECT a, b, c FROM fts_t1 WHERE c MATCH 'four'; } | 91 execsql { SELECT a, b, c FROM fts_t1 WHERE c MATCH 'four'; } |
| 92 } {{one three four} {one four} {one four two}} | 92 } {{one three four} {one four} {one four two}} |
| 93 | 93 |
| 94 #--------------------------------------------------------------------- | 94 #--------------------------------------------------------------------- |
| 95 # Test that it is possible to rename an fts1 table in an attached | 95 # Test that it is possible to rename an fts1 table in an attached |
| 96 # database. | 96 # database. |
| 97 # | 97 # |
| 98 file delete -force test2.db test2.db-journal | 98 forcedelete test2.db test2.db-journal |
| 99 | 99 |
| 100 do_test fts1o-4.1 { | 100 do_test fts1o-4.1 { |
| 101 execsql { | 101 execsql { |
| 102 DROP TABLE t1_term; | 102 DROP TABLE t1_term; |
| 103 ALTER TABLE fts_t1 RENAME to t1; | 103 ALTER TABLE fts_t1 RENAME to t1; |
| 104 SELECT a, b, c FROM t1 WHERE c MATCH 'two'; | 104 SELECT a, b, c FROM t1 WHERE c MATCH 'two'; |
| 105 } | 105 } |
| 106 } {{one three four} {one four} {one four two} {one two three} {one four} {one tw
o}} | 106 } {{one three four} {one four} {one four two} {one two three} {one four} {one tw
o}} |
| 107 | 107 |
| 108 do_test fts1o-4.2 { | 108 do_test fts1o-4.2 { |
| (...skipping 20 matching lines...) Expand all Loading... |
| 129 | 129 |
| 130 do_test fts1o-4.6 { | 130 do_test fts1o-4.6 { |
| 131 execsql { SELECT a, b, c FROM t2 WHERE a MATCH 'song'; } | 131 execsql { SELECT a, b, c FROM t2 WHERE a MATCH 'song'; } |
| 132 } {{neung song sahm} {neung see} {neung see song}} | 132 } {{neung song sahm} {neung see} {neung see song}} |
| 133 | 133 |
| 134 do_test fts1o-4.7 { | 134 do_test fts1o-4.7 { |
| 135 execsql { SELECT a, b, c FROM t1 WHERE c MATCH 'two'; } | 135 execsql { SELECT a, b, c FROM t1 WHERE c MATCH 'two'; } |
| 136 } {{one three four} {one four} {one four two} {one two three} {one four} {one tw
o}} | 136 } {{one three four} {one four} {one four two} {one two three} {one four} {one tw
o}} |
| 137 | 137 |
| 138 finish_test | 138 finish_test |
| OLD | NEW |