Lines Matching refs:w
22 CREATE TABLE t1(w int, x int, y int);
26 set w $i
29 execsql "INSERT INTO t1 VALUES($w,$x,$y)"
34 INSERT INTO t2 SELECT 101-w, x, (SELECT max(y) FROM t1)+1-y, y FROM t1;
39 INSERT INTO t2 SELECT 101-w, x, $maxy+1-y, y FROM t1;
44 CREATE INDEX i1w ON t1("w"); -- Verify quoted identifier names
65 count {SELECT x, y, w FROM t1 WHERE w=10}
68 count {SELECT x, y, w FROM t1 WHERE w IS 10}
71 SELECT x, y, w FROM t1 WHERE w=10
72 } {*SEARCH t1 USING INDEX i1w (w=?)*}
74 SELECT x, y, w FROM t1 WHERE w IS 10
75 } {*SEARCH t1 USING INDEX i1w (w=?)*}
80 db eval {SELECT x, y, w FROM t1 WHERE +w=10}
86 SELECT x, y, w FROM t1 WHERE +w=10
89 count {SELECT x, y, w AS abc FROM t1 WHERE abc=10}
92 SELECT x, y, w AS abc FROM t1 WHERE abc=10
93 } {*SEARCH t1 USING INDEX i1w (w=?)*}
98 count {SELECT x, y, w FROM t1 WHERE w=11}
101 count {SELECT x, y, w AS abc FROM t1 WHERE abc=11}
104 count {SELECT x, y, w AS abc FROM t1 WHERE 11=w}
107 count {SELECT x, y, w AS abc FROM t1 WHERE 11=abc}
110 count {SELECT x, y, w AS abc FROM t1 WHERE 11 IS abc}
113 count {SELECT w, x, y FROM t1 WHERE 11=w AND x>2}
116 count {SELECT w, x, y FROM t1 WHERE 11 IS w AND x>2}
119 SELECT w, x, y FROM t1 WHERE 11=w AND x>2
120 } {*SEARCH t1 USING INDEX i1w (w=?)*}
122 SELECT w, x, y FROM t1 WHERE 11 IS w AND x>2
123 } {*SEARCH t1 USING INDEX i1w (w=?)*}
125 count {SELECT w AS a, x AS b, y FROM t1 WHERE 11=a AND b>2}
128 SELECT w AS a, x AS b, y FROM t1 WHERE 11=a AND b>2
129 } {*SEARCH t1 USING INDEX i1w (w=?)*}
131 count {SELECT x, y FROM t1 WHERE y<200 AND w=11 AND x>2}
134 SELECT x, y FROM t1 WHERE y<200 AND w=11 AND x>2
135 } {*SEARCH t1 USING INDEX i1w (w=?)*}
137 count {SELECT x, y FROM t1 WHERE y<200 AND x>2 AND w=11}
140 count {SELECT x, y FROM t1 WHERE w=11 AND y<200 AND x>2}
143 count {SELECT x, y FROM t1 WHERE w>10 AND y=144 AND x=3}
146 SELECT x, y FROM t1 WHERE w>10 AND y=144 AND x=3
152 count {SELECT x, y FROM t1 WHERE y=144 AND w>10 AND x=3}
155 count {SELECT x, y FROM t1 WHERE x=3 AND w>=10 AND y=121}
158 count {SELECT x, y FROM t1 WHERE x=3 AND y=100 AND w<10}
161 count {SELECT x, y FROM t1 WHERE x IS 3 AND y IS 100 AND w<10}
168 count {SELECT w FROM t1 WHERE x=3 AND y<100}
171 count {SELECT w FROM t1 WHERE x IS 3 AND y<100}
174 count {SELECT w FROM t1 WHERE x=3 AND 100>y}
177 count {SELECT w FROM t1 WHERE 3=x AND y<100}
180 count {SELECT w FROM t1 WHERE 3 IS x AND y<100}
183 count {SELECT w FROM t1 WHERE 3=x AND 100>y}
186 count {SELECT w FROM t1 WHERE x=3 AND y<=100}
189 count {SELECT w FROM t1 WHERE x=3 AND 100>=y}
192 count {SELECT w FROM t1 WHERE x=3 AND y>225}
195 count {SELECT w FROM t1 WHERE x IS 3 AND y>225}
198 count {SELECT w FROM t1 WHERE x=3 AND 225<y}
201 count {SELECT w FROM t1 WHERE x=3 AND y>=225}
204 count {SELECT w FROM t1 WHERE x=3 AND 225<=y}
207 count {SELECT w FROM t1 WHERE x=3 AND y>121 AND y<196}
210 count {SELECT w FROM t1 WHERE x IS 3 AND y>121 AND y<196}
213 count {SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<=196}
216 count {SELECT w FROM t1 WHERE x=3 AND 121<y AND 196>y}
219 count {SELECT w FROM t1 WHERE x=3 AND 121<=y AND 196>=y}
225 # count {SELECT w FROM t1 WHERE x=3 AND y BETWEEN 121 AND 196}
229 count {SELECT w FROM t1 WHERE x=3 AND y+1==122}
233 count {SELECT w FROM t1 WHERE x+1=4 AND y+1==122}
236 count {SELECT w FROM t1 WHERE y==121}
241 count {SELECT w FROM t1 WHERE w>97}
244 count {SELECT w FROM t1 WHERE w>=97}
247 count {SELECT w FROM t1 WHERE w==97}
250 count {SELECT w FROM t1 WHERE w<=97 AND w==97}
253 count {SELECT w FROM t1 WHERE w<98 AND w==97}
256 count {SELECT w FROM t1 WHERE w>=97 AND w==97}
259 count {SELECT w FROM t1 WHERE w>96 AND w==97}
262 count {SELECT w FROM t1 WHERE w==97 AND w==97}
265 count {SELECT w FROM t1 WHERE w+1==98}
268 count {SELECT w FROM t1 WHERE w<3}
271 count {SELECT w FROM t1 WHERE w<=3}
274 count {SELECT w FROM t1 WHERE w+1<=4 ORDER BY w}
278 count {SELECT (w) FROM t1 WHERE (w)>(97)}
281 count {SELECT (w) FROM t1 WHERE (w)>=(97)}
284 count {SELECT (w) FROM t1 WHERE (w)==(97)}
287 count {SELECT (w) FROM t1 WHERE ((w)+(1))==(98)}
295 SELECT w, p FROM t2, t1
301 SELECT w, p FROM t2, t1
307 SELECT w, p FROM t2, t1
308 WHERE x=q AND s=y AND r=8977 AND w>10
313 SELECT w, p FROM t2, t1
314 WHERE p<80 AND x=q AND s=y AND r=8977 AND w>10
319 SELECT w, p FROM t2, t1
320 WHERE p<80 AND x=q AND 8977=r AND s=y AND w>10
325 SELECT w, p FROM t2, t1
326 WHERE x=q AND p=77 AND s=y AND w>5
331 SELECT w, p FROM t1, t2
332 WHERE x=q AND p>77 AND s=y AND w=5
340 SELECT A.w, B.p, C.w FROM t1 as A, t2 as B, t1 as C
341 WHERE C.w=101-B.p AND B.r=10202-A.y AND A.w=11
346 SELECT A.w, B.p, C.w FROM t1 as A, t2 as B, t1 as C
347 WHERE C.w=101-B.p AND B.r=10202-A.y AND A.w=12
352 SELECT A.w, B.p, C.w FROM t1 as A, t2 as B, t1 as C
353 WHERE A.w=15 AND B.p=C.w AND B.r=10202-A.y
392 SELECT count(*) FROM t1 WHERE t1.w
412 SELECT * FROM t1 WHERE w IN (-1,1,2,3) order by 1;
417 SELECT * FROM t1 WHERE w IN (3,-1,1,2) order by 1;
422 SELECT * FROM t1 WHERE w IN (3,2,-1,1,2) order by 1;
427 SELECT * FROM t1 WHERE w IN (-1,1,2,3) order by 1 DESC;
432 SELECT * FROM t1 WHERE w+0 IN (-1,1,2,3) order by 1;
451 SELECT * FROM t1 WHERE w IN
458 SELECT * FROM t1 WHERE w+0 IN
500 SELECT w, x, y FROM t1 WHERE x IN (1,5) AND y IN (9,8,3025,1000,3969)
506 SELECT w, x, y FROM t1 WHERE x IN (1,5) AND y IN (9,8,3025,1000,3969)
512 SELECT w, x, y FROM t1 WHERE x IN (1,5) AND y IN (9,8,3025,1000,3969)
518 SELECT w, x, y FROM t1 WHERE x IN (1,5) AND y IN (9,8,3025,1000,3969)
546 INSERT INTO t3 SELECT w, 101-w, y FROM t1;
684 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t3.a LIMIT 3
689 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t1.x, t3.a LIMIT 3
694 SELECT y FROM t1 ORDER BY w LIMIT 3;
714 SELECT y FROM t1 WHERE y>4 ORDER BY rowid, w, x LIMIT 3;
719 SELECT y FROM t1 WHERE y>=9 ORDER BY rowid, x DESC, w LIMIT 3;
734 SELECT y FROM t1 WHERE y<=25 ORDER BY _rowid_, w+y;
743 SELECT w FROM t1 WHERE x=3 ORDER BY y;
748 SELECT w FROM t1 WHERE x=3 ORDER BY y DESC;
753 SELECT w FROM t1 WHERE x=3 AND y>100 ORDER BY y LIMIT 3;
758 SELECT w FROM t1 WHERE x=3 AND y>100 ORDER BY y DESC LIMIT 3;
763 SELECT w FROM t1 WHERE x=3 AND y>121 ORDER BY y DESC;
768 SELECT w FROM t1 WHERE x=3 AND y>=121 ORDER BY y DESC;
773 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<196 ORDER BY y DESC;
778 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<=196 ORDER BY y DESC;
783 SELECT w FROM t1 WHERE x=3 AND y>121 AND y<=196 ORDER BY y DESC;
788 SELECT w FROM t1 WHERE x=3 AND y>100 AND y<196 ORDER BY y DESC;
793 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<196 ORDER BY y;
798 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<=196 ORDER BY y;
803 SELECT w FROM t1 WHERE x=3 AND y>121 AND y<=196 ORDER BY y;
808 SELECT w FROM t1 WHERE x=3 AND y>100 AND y<196 ORDER BY y;
813 SELECT w FROM t1 WHERE x=3 AND y<81 ORDER BY y;
818 SELECT w FROM t1 WHERE x=3 AND y<=81 ORDER BY y;
823 SELECT w FROM t1 WHERE x=3 AND y>256 ORDER BY y;
828 SELECT w FROM t1 WHERE x=3 AND y>=256 ORDER BY y;
833 SELECT w FROM t1 WHERE x=3 AND y<81 ORDER BY y DESC;
838 SELECT w FROM t1 WHERE x=3 AND y<=81 ORDER BY y DESC;
843 SELECT w FROM t1 WHERE x=3 AND y>256 ORDER BY y DESC;
848 SELECT w FROM t1 WHERE x=3 AND y>=256 ORDER BY y DESC;
853 SELECT w FROM t1 WHERE x=0 AND y<4 ORDER BY y;
858 SELECT w FROM t1 WHERE x=0 AND y<=4 ORDER BY y;
863 SELECT w FROM t1 WHERE x=6 AND y>10201 ORDER BY y;
868 SELECT w FROM t1 WHERE x=6 AND y>=10201 ORDER BY y;
873 SELECT w FROM t1 WHERE x=0 AND y<4 ORDER BY y DESC;
878 SELECT w FROM t1 WHERE x=0 AND y<=4 ORDER BY y DESC;
883 SELECT w FROM t1 WHERE x=6 AND y>10201 ORDER BY y DESC;
888 SELECT w FROM t1 WHERE x=6 AND y>=10201 ORDER BY y DESC;
923 SELECT w FROM t4 WHERE x=4 and y<1000 ORDER BY y DESC limit 3;
931 SELECT w FROM t4 WHERE x=4 and y<1000 ORDER BY y DESC limit 3;