Lines Matching refs:count
52 # Do an SQL statement. Append the search count to the end of the result.
54 proc count sql {
61 # and Next operators in the VDBE. By verifing that the search count is
65 count {SELECT x, y, w FROM t1 WHERE w=10}
68 count {SELECT x, y, w FROM t1 WHERE w IS 10}
89 count {SELECT x, y, w AS abc FROM t1 WHERE abc=10}
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}
125 count {SELECT w AS a, x AS b, y FROM t1 WHERE 11=a AND b>2}
131 count {SELECT x, y FROM t1 WHERE y<200 AND w=11 AND x>2}
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}
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)}
294 count {
300 count {
306 count {
312 count {
318 count {
324 count {
330 count {
339 count {
345 count {
351 count {
361 count {
366 count {
392 SELECT count(*) FROM t1 WHERE t1.w
401 count {
406 count {
411 count {
416 count {
421 count {
426 count {
431 count {
436 count {
443 count {
450 count {
457 count {
464 count {
469 count {
474 count {
479 count {
484 count {
489 count {
494 count {
547 SELECT count(*), sum(a), sum(b), sum(c) FROM t3;
964 SELECT count(*) FROM t1 WHERE tclvar('v1');
970 SELECT count(*) FROM t1 WHERE tclvar('v1');
981 SELECT count(*) FROM t1 WHERE tclvar('v1');
1399 SELECT count(*) FROM t201 LEFT JOIN t202 ON (x=y) WHERE ifnull(z, 0) >=0;
1417 a = (SELECT * FROM (SELECT count(*) FROM t13 LIMIT 5) ORDER BY 1 LIMIT 10)
1433 SELECT count(*) FROM t1 LEFT JOIN t2 ON a IS NOT NULL;