Lines Matching refs:ft

28   0 { CREATE VIRTUAL TABLE ft USING fts5(a, b, c) }
29   1 { CREATE VIRTUAL TABLE ft USING fts3(a, b, c) }
30   2 { CREATE TABLE ft(a, b, c) }
34     CREATE VIEW ft AS SELECT rowid, a, b, c FROM real;
35     CREATE TRIGGER tr1 INSTEAD OF INSERT ON ft BEGIN
38     CREATE TRIGGER tr2 INSTEAD OF UPDATE ON ft BEGIN
46   catchsql { DROP TABLE IF EXISTS ft }
47   catchsql { DROP VIEW IF EXISTS ft }
51     INSERT INTO ft(a, b, c) VALUES('a', NULL, 'apple');
52     INSERT INTO ft(a, b, c) VALUES('b', NULL, 'banana');
53     INSERT INTO ft(a, b, c) VALUES('c', NULL, 'cherry');
54     INSERT INTO ft(a, b, c) VALUES('d', NULL, 'damson plum');
58     SELECT a, b, c FROM ft ORDER BY rowid;
67     UPDATE ft SET b=o.c FROM ft AS o WHERE (ft.a == char(unicode(o.a)+1))
71     SELECT a, b, c FROM ft ORDER BY rowid;
80     UPDATE ft SET c=v FROM changes WHERE a=k;
93     UPDATE ft SET c=v FROM changes WHERE a=k;
97     SELECT rowid, a, b, c FROM ft ORDER BY rowid;
112     SELECT ft.rowid, a, b, c, o, n FROM ft, x1 WHERE ft.rowid = o;
129     UPDATE ft SET $ROWID = n FROM x1 WHERE ft.rowid = o;
130     SELECT rowid, a, b, c FROM ft ORDER BY rowid;