OLD | NEW |
1 # 2006 September 9 | 1 # 2006 September 9 |
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 128 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
139 do_test fts3aa-3.1 { | 139 do_test fts3aa-3.1 { |
140 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'} | 140 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'} |
141 } {1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31} | 141 } {1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31} |
142 do_test fts3aa-3.2 { | 142 do_test fts3aa-3.2 { |
143 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one -two'} | 143 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one -two'} |
144 } {1 5 9 13 17 21 25 29} | 144 } {1 5 9 13 17 21 25 29} |
145 do_test fts3aa-3.3 { | 145 do_test fts3aa-3.3 { |
146 execsql {SELECT rowid FROM t1 WHERE content MATCH '-two one'} | 146 execsql {SELECT rowid FROM t1 WHERE content MATCH '-two one'} |
147 } {1 5 9 13 17 21 25 29} | 147 } {1 5 9 13 17 21 25 29} |
148 | 148 |
149 breakpoint | |
150 do_test fts3aa-4.1 { | 149 do_test fts3aa-4.1 { |
151 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one OR two'} | 150 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one OR two'} |
152 } {1 2 3 5 6 7 9 10 11 13 14 15 17 18 19 21 22 23 25 26 27 29 30 31} | 151 } {1 2 3 5 6 7 9 10 11 13 14 15 17 18 19 21 22 23 25 26 27 29 30 31} |
153 do_test fts3aa-4.2 { | 152 do_test fts3aa-4.2 { |
154 execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two" OR three'} | 153 execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two" OR three'} |
155 } {3 4 5 6 7 11 12 13 14 15 19 20 21 22 23 27 28 29 30 31} | 154 } {3 4 5 6 7 11 12 13 14 15 19 20 21 22 23 27 28 29 30 31} |
156 do_test fts3aa-4.3 { | 155 do_test fts3aa-4.3 { |
157 execsql {SELECT rowid FROM t1 WHERE content MATCH 'three OR "one two"'} | 156 execsql {SELECT rowid FROM t1 WHERE content MATCH 'three OR "one two"'} |
158 } {3 4 5 6 7 11 12 13 14 15 19 20 21 22 23 27 28 29 30 31} | 157 } {3 4 5 6 7 11 12 13 14 15 19 20 21 22 23 27 28 29 30 31} |
159 do_test fts3aa-4.4 { | 158 do_test fts3aa-4.4 { |
(...skipping 57 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
217 do_execsql_test fts3aa-7.4 { | 216 do_execsql_test fts3aa-7.4 { |
218 CREATE VIRTUAL TABLE t3 USING fts3(tokenize=simple, tokenize=simple); | 217 CREATE VIRTUAL TABLE t3 USING fts3(tokenize=simple, tokenize=simple); |
219 SELECT tokenize FROM t3; | 218 SELECT tokenize FROM t3; |
220 } {} | 219 } {} |
221 do_catchsql_test fts3aa-7.5 { | 220 do_catchsql_test fts3aa-7.5 { |
222 CREATE VIRTUAL TABLE t4 USING fts4(tokenize=simple, tokenize=simple); | 221 CREATE VIRTUAL TABLE t4 USING fts4(tokenize=simple, tokenize=simple); |
223 } {1 {unrecognized parameter: tokenize=simple}} | 222 } {1 {unrecognized parameter: tokenize=simple}} |
224 | 223 |
225 | 224 |
226 finish_test | 225 finish_test |
227 | |
OLD | NEW |