Lines Matching refs:rowid

29 # rowid for each will be a bitmask for the elements it contains.
67   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
70   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two'}
73   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two one'}
76   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two three'}
79   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one three two'}
82   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two three one'}
85   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two one three'}
88   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three one two'}
91   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three two one'}
94   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two THREE'}
97   execsql {SELECT rowid FROM t1 WHERE content MATCH '  ONE    Two   three  '}
101   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one"'}
104   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two"'}
107   execsql {SELECT rowid FROM t1 WHERE content MATCH '"two one"'}
110   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two three"'}
113   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three two"'}
116   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two three four"'}
119   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three two four"'}
122   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three five"'}
125   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three" five'}
128   execsql {SELECT rowid FROM t1 WHERE content MATCH 'five "one three"'}
131   execsql {SELECT rowid FROM t1 WHERE content MATCH 'five "one three" four'}
134   execsql {SELECT rowid FROM t1 WHERE content MATCH 'five four "one three"'}
137   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three" four five'}
141   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
144   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one -two'}
147   execsql {SELECT rowid FROM t1 WHERE content MATCH '-two one'}
151   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one OR two'}
154   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two" OR three'}
157   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three OR "one two"'}
160   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two OR three'}
163   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three OR two one'}
166   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two OR three OR four'}
169   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two OR three OR four one'}
178   set rowid [db last_insert_rowid]
179   execsql {SELECT content FROM t1 WHERE rowid=$rowid}
182   execsql {SELECT rowid FROM t1 WHERE content MATCH NULL}
188   execsql {INSERT INTO t1(rowid, content) VALUES(0, 'four five')}
191   execsql {SELECT content FROM t1 WHERE rowid = 0}
194   execsql {INSERT INTO t1(rowid, content) VALUES(-1, 'three four')}
197   execsql {SELECT content FROM t1 WHERE rowid = -1}
200   execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'four'}
228   INSERT INTO t0(rowid, content) VALUES(1, 'abc');
230   INSERT INTO t0(rowid, content) VALUES(6, 'abc');