Lines Matching refs:ft

89   execsql { CREATE VIRTUAL TABLE ft USING fts3(a, b) }
98     execsql { INSERT INTO ft VALUES($a, $b) }
104   2 "SELECT * FROM ft WHERE docid = 1"   {one neung}
105   3 "SELECT * FROM ft WHERE docid = 2"   {two song}
106   4 "SELECT * FROM ft WHERE docid = 3"   {{one two} {neung song}}
108   5 "SELECT a FROM ft" {
122   6 "SELECT a FROM ft WHERE a MATCH 'one'" {
130   7 "SELECT a FROM ft WHERE a MATCH 'o*'" {
138   8 "SELECT a FROM ft WHERE a MATCH 'o* t*'" {
145   9 "SELECT a FROM ft WHERE a MATCH '\"o* t*\"'" {
152   10 {SELECT a FROM ft WHERE a MATCH '"o* f*"'} {
156   11 {SELECT a FROM ft WHERE a MATCH '"one two three"'} {
163   12 {SELECT a FROM ft WHERE a MATCH '"two three four"'} {
170   12 {SELECT a FROM ft WHERE a MATCH '"two three" five'} {
175   13 {SELECT a FROM ft WHERE ft MATCH '"song sahm" hah'} {
180   14 {SELECT a FROM ft WHERE b MATCH 'neung'} {
191   15 {SELECT a FROM ft WHERE b MATCH '"neung song sahm"'} {
196   16 {SELECT a FROM ft WHERE b MATCH 'hah "song sahm"'} {
201   17 {SELECT a FROM ft WHERE b MATCH 'song OR sahm'} {
212   18 {SELECT a FROM ft WHERE a MATCH 'three NOT two'} {
218   19 {SELECT a FROM ft WHERE b MATCH 'sahm NOT song'} {
224   20 {SELECT a FROM ft WHERE ft MATCH 'sahm NOT song'} {
230   21 {SELECT a FROM ft WHERE b MATCH 'neung NEAR song NEAR sahm'} {
255     execsql { INSERT INTO ft VALUES($a, $b) }
260   1 "SELECT count(*) FROM ft" {1023}
262   2 "SELECT a FROM ft WHERE a MATCH 'one two three four five six seven eight'" {
269   3 {SELECT count(*), sum(docid) FROM ft WHERE a MATCH 'o*'} {
273   4 {SELECT count(*), sum(docid) FROM ft WHERE a MATCH '"two three four"'} {
282   execsql { DELETE FROM ft WHERE docid>=32 }
285   1 "DELETE FROM ft WHERE ft MATCH 'one'"
286   2 "DELETE FROM ft WHERE ft MATCH 'three'"
287   3 "DELETE FROM ft WHERE ft MATCH 'five'"
292   execsql { SELECT a FROM ft }
296 …INSERT INTO ft VALUES('short alongertoken reallyquitealotlongerimeanit andthistokenisjustsolongtha…