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

Side by Side Diff: third_party/sqlite/src/test/fts1o.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 # 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
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
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
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698