Lines Matching refs:x

48   CREATE VIRTUAL TABLE xx USING fts3(x);
49   INSERT INTO xx VALUES('A x x x B C x x');
50   INSERT INTO xx VALUES('A B C x B x x C');
51   INSERT INTO xx VALUES('A x x B C x x x');
54   SELECT oid,extract(offsets(xx), x) FROM xx WHERE xx MATCH 'a OR (b NEAR/1 c)';
56   1 {(A) x x x (B) (C) x x} 
57   2 {(A) (B) (C) x (B) x x C} 
58   3 {(A) x x (B) (C) x x x}
63   INSERT INTO xx VALUES('A x x x B C x x');
64   INSERT INTO xx VALUES('A x x C x x x C');
65   INSERT INTO xx VALUES('A x x B C x x x');
68   SELECT oid,extract(offsets(xx), x) FROM xx WHERE xx MATCH 'a OR (b NEAR/1 c)';
70   1 {(A) x x x (B) (C) x x}
71   2 {(A) x x C x x x C} 
72   3 {(A) x x (B) (C) x x x}
77   INSERT INTO xx(rowid, x) VALUES(1, 'A B C');
78   INSERT INTO xx(rowid, x) VALUES(2, 'A x');
79   INSERT INTO xx(rowid, x) VALUES(3, 'A B C');
80   INSERT INTO xx(rowid, x) VALUES(4, 'A B C x x x x x x x B');
81   INSERT INTO xx(rowid, x) VALUES(5, 'A x x x x x x x x x C');
82   INSERT INTO xx(rowid, x) VALUES(6, 'A x x x x x x x x x x x B');
83   INSERT INTO xx(rowid, x) VALUES(7, 'A B C');
86   SELECT oid,extract(offsets(xx), x) FROM xx WHERE xx MATCH 'a OR (b NEAR/1 c)';
89   2 {(A) x}
91   4 {(A) (B) (C) x x x x x x x B}
92   5 {(A) x x x x x x x x x C}
93   6 {(A) x x x x x x x x x x x B} 
100   INSERT INTO xx(rowid, x) VALUES(7, 'A B C');
101   INSERT INTO xx(rowid, x) VALUES(6, 'A x');
102   INSERT INTO xx(rowid, x) VALUES(5, 'A B C');
103   INSERT INTO xx(rowid, x) VALUES(4, 'A B C x x x x x x x B');
104   INSERT INTO xx(rowid, x) VALUES(3, 'A x x x x x x x x x C');
105   INSERT INTO xx(rowid, x) VALUES(2, 'A x x x x x x x x x x x B');
106   INSERT INTO xx(rowid, x) VALUES(1, 'A B C');
109   SELECT oid,extract(offsets(xx), x) FROM xx WHERE xx MATCH 'a OR (b NEAR/1 c)'
113   6 {(A) x}
115   4 {(A) (B) (C) x x x x x x x B}
116   3 {(A) x x x x x x x x x C}
117   2 {(A) x x x x x x x x x x x B} 
122   CREATE VIRTUAL TABLE x1 USING fts3(x);