Lines Matching refs:path

231   CREATE TABLE t1(path TEXT COLLATE nocase PRIMARY KEY,a,b,c) WITHOUT ROWID;
234   SELECT * FROM t1 WHERE path LIKE 'a%';
237   `--SEARCH t1 USING PRIMARY KEY (path>? AND path<?)
240   SELECT * FROM t1 WHERE path LIKE 'a%' ESCAPE 'x';
243   `--SEARCH t1 USING PRIMARY KEY (path>? AND path<?)
247   CREATE TABLE t2(path TEXT,x,y,z);
248   CREATE INDEX t2path ON t2(path COLLATE nocase);
249   CREATE INDEX t2path2 ON t2(path);
252   SELECT * FROM t2 WHERE path LIKE 'a%';
255   `--SEARCH t2 USING INDEX t2path (path>? AND path<?)
258   SELECT * FROM t2 WHERE path LIKE 'a%' ESCAPE '\';
261   `--SEARCH t2 USING INDEX t2path (path>? AND path<?)
265   SELECT * FROM t2 WHERE path LIKE 'a%';
268   `--SEARCH t2 USING INDEX t2path2 (path>? AND path<?)
271   SELECT * FROM t2 WHERE path LIKE 'a%' ESCAPE '\';
274   `--SEARCH t2 USING INDEX t2path2 (path>? AND path<?)