Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(393)

Side by Side Diff: third_party/sqlite/src/test/fts3aa.test

Issue 901033002: Import SQLite 3.8.7.4. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: Chromium changes to support SQLite 3.8.7.4. Created 5 years, 10 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
OLDNEW
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
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
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
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698