Lines Matching refs:sqlite

206   SELECT * FROM mail WHERE body MATCH 'sqlite';       -- Fast. Full-text query.
243 read_test  1.3.3.2 { SELECT * FROM docs WHERE docs MATCH 'sqlite' } {}
244 read_test  1.3.3.3 { SELECT * FROM docs WHERE docs.docs MATCH 'sqlite' } {}
245 read_test  1.3.3.4 { SELECT * FROM docs WHERE main.docs.docs MATCH 'sqlite' } {}
247   SELECT * FROM docs WHERE main.docs MATCH 'sqlite' 
298 3 {SELECT * FROM docs WHERE docs MATCH 'sqlite NEAR database'} 1
299 4 {SELECT * FROM docs WHERE docs MATCH 'database NEAR/6 sqlite'} 1
300 5 {SELECT * FROM docs WHERE docs MATCH 'database NEAR/5 sqlite'} 0
302 7 {SELECT * FROM docs WHERE docs MATCH '"ACID compliant" NEAR/2 sqlite'} 1
303 8 {SELECT * FROM docs WHERE docs MATCH 'sqlite NEAR/2 acid NEAR/2 relational'} 1
304 9 {SELECT * FROM docs WHERE docs MATCH 'acid NEAR/2 sqlite NEAR/2 relational'} 0
318   3 2 "sqlite is a software system"
319   4 3 "sqlite is a database"
327   SELECT * FROM docs WHERE docs MATCH 'sqlite AND database'
330   SELECT * FROM docs WHERE docs MATCH 'database sqlite'
333   SELECT * FROM docs WHERE docs MATCH 'sqlite OR database'
336   SELECT * FROM docs WHERE docs MATCH 'database NOT sqlite'
339   SELECT * FROM docs WHERE docs MATCH 'database and sqlite'
344     SELECT 'sqlite is also a library' UNION ALL
348   SELECT docid FROM docs WHERE docs MATCH 'sqlite AND database OR library'
351   SELECT docid FROM docs WHERE docs MATCH 'sqlite AND database'
357     SELECT 'the sqlite library runs on linux' UNION ALL
358     SELECT 'as does the sqlite database (on linux)' UNION ALL
359     SELECT 'the sqlite database is accessed by the sqlite library'
363   WHERE docs MATCH '("sqlite database" OR "sqlite library") AND linux';
369     SELECT docid FROM docs WHERE docs MATCH '"sqlite library"'
371     SELECT docid FROM docs WHERE docs MATCH '"sqlite database"'
381   SELECT * FROM docs WHERE docs MATCH 'sqlite -database'
382 } {{sqlite is a software system} {sqlite is also a library} {the sqlite library runs on linux}}
384   SELECT * FROM docs WHERE docs MATCH 'sqlite OR database library'
385 } {{sqlite is also a library} {the sqlite library runs on linux} {the sqlite database is accessed b…
389   SELECT * FROM docs WHERE docs MATCH 'sqlite OR database library'
390 …sqlite is a software system} {sqlite is a database} {sqlite is also a library} {the sqlite library…
392   SELECT * FROM docs WHERE docs MATCH '(sqlite OR database) library'
393 } {{sqlite is also a library} {the sqlite library runs on linux} {the sqlite database is accessed b…