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 |