Lines Matching full:where
123 UPDATE t1 SET v='x-2b' where v=='x-0.123';
268 count {SELECT x, y FROM t1 WHERE w=10}
271 count {SELECT x, y FROM t1 WHERE w=11}
274 count {SELECT x, y FROM t1 WHERE 11=w}
277 count {SELECT x, y FROM t1 WHERE 11=w AND x>2}
280 count {SELECT x, y FROM t1 WHERE y<200 AND w=11 AND x>2}
283 count {SELECT x, y FROM t1 WHERE y<200 AND x>2 AND w=11}
286 count {SELECT x, y FROM t1 WHERE w=11 AND y<200 AND x>2}
289 count {SELECT x, y FROM t1 WHERE w>10 AND y=144 AND x=3}
292 count {SELECT x, y FROM t1 WHERE y=144 AND w>10 AND x=3}
295 count {SELECT x, y FROM t1 WHERE x=3 AND w>=10 AND y=121}
298 count {SELECT x, y FROM t1 WHERE x=3 AND y=100 AND w<10}
305 count {SELECT w FROM t1 WHERE x=3 AND y<100}
308 count {SELECT w FROM t1 WHERE x=3 AND 100>y}
311 count {SELECT w FROM t1 WHERE 3=x AND y<100}
314 count {SELECT w FROM t1 WHERE 3=x AND 100>y}
317 count {SELECT w FROM t1 WHERE x=3 AND y<=100}
320 count {SELECT w FROM t1 WHERE x=3 AND 100>=y}
323 count {SELECT w FROM t1 WHERE x=3 AND y>225}
326 count {SELECT w FROM t1 WHERE x=3 AND 225<y}
329 count {SELECT w FROM t1 WHERE x=3 AND y>=225}
332 count {SELECT w FROM t1 WHERE x=3 AND 225<=y}
335 count {SELECT w FROM t1 WHERE x=3 AND y>121 AND y<196}
338 count {SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<=196}
341 count {SELECT w FROM t1 WHERE x=3 AND 121<y AND 196>y}
344 count {SELECT w FROM t1 WHERE x=3 AND 121<=y AND 196>=y}
350 # count {SELECT w FROM t1 WHERE x=3 AND y BETWEEN 121 AND 196}
354 count {SELECT w FROM t1 WHERE x=3 AND y+1==122}
357 count {SELECT w FROM t1 WHERE x+1=4 AND y+1==122}
360 count {SELECT w FROM t1 WHERE y==121}
365 count {SELECT w FROM t1 WHERE w>97}
368 count {SELECT w FROM t1 WHERE w>=97}
371 count {SELECT w FROM t1 WHERE w==97}
374 count {SELECT w FROM t1 WHERE w+1==98}
377 count {SELECT w FROM t1 WHERE w<3}
380 count {SELECT w FROM t1 WHERE w<=3}
383 count {SELECT w FROM t1 WHERE w+1<=4 ORDER BY w}
394 WHERE x=q AND y=s AND r=8977
400 WHERE x=q AND s=y AND r=8977
406 WHERE x=q AND s=y AND r=8977 AND w>10
412 WHERE p<80 AND x=q AND s=y AND r=8977 AND w>10
418 WHERE p<80 AND x=q AND 8977=r AND s=y AND w>10
424 WHERE x=q AND p=77 AND s=y AND w>5
430 WHERE x=q AND p>77 AND s=y AND w=5
439 WHERE C.w=101-B.p AND B.r=10202-A.y AND A.w=11
445 WHERE C.w=101-B.p AND B.r=10202-A.y AND A.w=12
451 WHERE A.w=15 AND B.p=C.w AND B.r=10202-A.y
455 # Test to see that the special case of a constant WHERE clause is
460 SELECT * FROM t1 WHERE 0
465 SELECT * FROM t1 WHERE 1 LIMIT 1
470 SELECT 99 WHERE 0
475 SELECT 99 WHERE 1
479 # Verify that IN operators in a WHERE clause are handled correctly.
483 SELECT * FROM t1 WHERE rowid IN (1,2,3,1234) order by 1;
488 SELECT * FROM t1 WHERE rowid+0 IN (1,2,3,1234) order by 1;
493 SELECT * FROM t1 WHERE w IN (-1,1,2,3) order by 1;
498 SELECT * FROM t1 WHERE w+0 IN (-1,1,2,3) order by 1;
503 SELECT * FROM t1 WHERE rowid IN
504 (select rowid from t1 where rowid IN (-1,2,4))
510 SELECT * FROM t1 WHERE rowid+0 IN
511 (select rowid from t1 where rowid IN (-1,2,4))
517 SELECT * FROM t1 WHERE w IN
518 (select rowid from t1 where rowid IN (-1,2,4))
524 SELECT * FROM t1 WHERE w+0 IN
525 (select rowid from t1 where rowid IN (-1,2,4))
531 SELECT * FROM t1 WHERE x IN (1,7) ORDER BY 1;
536 SELECT * FROM t1 WHERE x+0 IN (1,7) ORDER BY 1;
541 SELECT * FROM t1 WHERE y IN (6400,8100) ORDER BY 1;
546 SELECT * FROM t1 WHERE x=6 AND y IN (6400,8100) ORDER BY 1;
551 SELECT * FROM t1 WHERE x IN (1,7) AND y NOT IN (6400,8100) ORDER BY 1;
556 SELECT * FROM t1 WHERE x IN (1,7) AND y IN (9,10) ORDER BY 1;
597 SELECT * FROM t3 WHERE a<10 ORDER BY a LIMIT 3
602 SELECT * FROM t3 WHERE a>0 AND a<10 ORDER BY a LIMIT 3
607 SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3
612 SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3
617 SELECT * FROM t3 WHERE a IN (3,5,7,1,9,4,2) ORDER BY a LIMIT 3
622 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
627 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a LIMIT 3
632 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c LIMIT 3
637 SELECT * FROM t3 WHERE a=1 AND c>0 ORDER BY a,c,b LIMIT 3
642 SELECT * FROM t3 WHERE a>0 ORDER BY a DESC LIMIT 3
647 SELECT * FROM t3 WHERE a>0 ORDER BY a+1 DESC LIMIT 3
657 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t3.a LIMIT 3
662 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t1.x, t3.a LIMIT 3