Lines Matching refs:w

25     CREATE TABLE t1(w int, x int, y int, z int);
28     set w $i
34       execsql {INSERT INTO t1 VALUES($::w,$::x,$::y,$::z)}
38       execsql {INSERT INTO t1 VALUES(:w,:x,:y,:z)}
42     CREATE UNIQUE INDEX i1w ON t1(w);
61     if {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+) USING.* INDEX (\w+)\y} \
64     } elseif {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+)\y} $x all ss as tab]} {
73     SELECT * FROM t1 WHERE w BETWEEN 5 AND 6 ORDER BY +w
78     SELECT * FROM t1 WHERE +w BETWEEN 5 AND 6 ORDER BY +w
83     SELECT * FROM t1 WHERE w BETWEEN 5 AND 65-y ORDER BY +w
88     SELECT * FROM t1 WHERE +w BETWEEN 5 AND 65-y ORDER BY +w
93     SELECT * FROM t1 WHERE w BETWEEN 41-y AND 6 ORDER BY +w
98     SELECT * FROM t1 WHERE +w BETWEEN 41-y AND 6 ORDER BY +w
103     SELECT * FROM t1 WHERE w BETWEEN 41-y AND 65-y ORDER BY +w
108     SELECT * FROM t1 WHERE 26 BETWEEN y AND z ORDER BY +w
113     SELECT * FROM t1 WHERE 26 BETWEEN +y AND z ORDER BY +w
118     SELECT * FROM t1 WHERE 26 BETWEEN y AND +z ORDER BY +w