Lines Matching refs:content

39 #   3.* - Tests with content= tables. Both where there is a real 
40 #         underlying content table and where there is not.
74 do_execsql_test 1.12 { SELECT rowid FROM t2 WHERE content MATCH 'abc' } 1
79   INSERT INTO t1(content)          VALUES('a b c');
80   INSERT INTO t1(content, lang_id) VALUES('a b c', 1);
95   INSERT INTO t1(content, lang_id) VALUES('123', -1);
101   INSERT INTO t1(content, lang_id) VALUES('A', 13);
102   INSERT INTO t1(content, lang_id) VALUES('B', 13);
103   INSERT INTO t1(content, lang_id) VALUES('C', 13);
104   INSERT INTO t1(content, lang_id) VALUES('D', 13);
105   INSERT INTO t1(content, lang_id) VALUES('E', 13);
106   INSERT INTO t1(content, lang_id) VALUES('F', 13);
107   INSERT INTO t1(content, lang_id) VALUES('G', 13);
108   INSERT INTO t1(content, lang_id) VALUES('H', 13);
109   INSERT INTO t1(content, lang_id) VALUES('I', 13);
110   INSERT INTO t1(content, lang_id) VALUES('J', 13);
111   INSERT INTO t1(content, lang_id) VALUES('K', 13);
112   INSERT INTO t1(content, lang_id) VALUES('L', 13);
113   INSERT INTO t1(content, lang_id) VALUES('M', 13);
114   INSERT INTO t1(content, lang_id) VALUES('N', 13);
115   INSERT INTO t1(content, lang_id) VALUES('O', 13);
116   INSERT INTO t1(content, lang_id) VALUES('P', 13);
117   INSERT INTO t1(content, lang_id) VALUES('Q', 13);
118   INSERT INTO t1(content, lang_id) VALUES('R', 13);
119   INSERT INTO t1(content, lang_id) VALUES('S', 13);
308   CREATE VIRTUAL TABLE t2 USING fts4(content=t3_data, languageid=l);
323   CREATE VIRTUAL TABLE t2 USING fts4(x, y, languageid=l, content=nosuchtable);
345   CREATE VIRTUAL TABLE t8 USING fts4(content=t8c, languageid=langid);
362       INSERT INTO t4(docid, content, lid) VALUES($i, 'The Quick Brown Fox', $i) 
389   INSERT INTO t4(content, lid) VALUES('hello world', 101)
406       INSERT INTO t5(docid, content, lid) VALUES(
437       INSERT INTO t6(content, lid) VALUES(
464     INSERT INTO t6(content, lid) VALUES('zero zero zero', $lid);
465     INSERT INTO t6(content, lid) VALUES('zero zero one', $lid);
466     INSERT INTO t6(content, lid) VALUES('zero one zero', $lid);
467     INSERT INTO t6(content, lid) VALUES('zero one one', $lid);
468     INSERT INTO t6(content, lid) VALUES('one zero zero', $lid);
469     INSERT INTO t6(content, lid) VALUES('one zero one', $lid);
470     INSERT INTO t6(content, lid) VALUES('one one zero', $lid);
471     INSERT INTO t6(content, lid) VALUES('one one one', $lid);