Lines Matching refs:t1
24 CREATE TABLE t1(w int, x int, y int);
31 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;
35 CREATE INDEX i1w ON t1(w);
36 CREATE INDEX i1xy ON t1(x,y);
56 count {SELECT x, y FROM t1 WHERE w=10}
59 count {SELECT x, y FROM t1 WHERE w=11}
62 count {SELECT x, y FROM t1 WHERE 11=w}
65 count {SELECT x, y FROM t1 WHERE 11=w AND x>2}
68 count {SELECT x, y FROM t1 WHERE y<200 AND w=11 AND x>2}
71 count {SELECT x, y FROM t1 WHERE y<200 AND x>2 AND w=11}
74 count {SELECT x, y FROM t1 WHERE w=11 AND y<200 AND x>2}
77 count {SELECT x, y FROM t1 WHERE w>10 AND y=144 AND x=3}
80 count {SELECT x, y FROM t1 WHERE y=144 AND w>10 AND x=3}
83 count {SELECT x, y FROM t1 WHERE x=3 AND w>=10 AND y=121}
86 count {SELECT x, y FROM t1 WHERE x=3 AND y=100 AND w<10}
93 count {SELECT w FROM t1 WHERE x=3 AND y<100}
96 count {SELECT w FROM t1 WHERE x=3 AND 100>y}
99 count {SELECT w FROM t1 WHERE 3=x AND y<100}
102 count {SELECT w FROM t1 WHERE 3=x AND 100>y}
105 count {SELECT w FROM t1 WHERE x=3 AND y<=100}
108 count {SELECT w FROM t1 WHERE x=3 AND 100>=y}
111 count {SELECT w FROM t1 WHERE x=3 AND y>225}
114 count {SELECT w FROM t1 WHERE x=3 AND 225<y}
117 count {SELECT w FROM t1 WHERE x=3 AND y>=225}
120 count {SELECT w FROM t1 WHERE x=3 AND 225<=y}
123 count {SELECT w FROM t1 WHERE x=3 AND y>121 AND y<196}
126 count {SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<=196}
129 count {SELECT w FROM t1 WHERE x=3 AND 121<y AND 196>y}
132 count {SELECT w FROM t1 WHERE x=3 AND 121<=y AND 196>=y}
138 # count {SELECT w FROM t1 WHERE x=3 AND y BETWEEN 121 AND 196}
142 count {SELECT w FROM t1 WHERE x=3 AND y+1==122}
145 count {SELECT w FROM t1 WHERE x+1=4 AND y+1==122}
148 count {SELECT w FROM t1 WHERE y==121}
153 count {SELECT w FROM t1 WHERE w>97}
156 count {SELECT w FROM t1 WHERE w>=97}
159 count {SELECT w FROM t1 WHERE w==97}
162 count {SELECT w FROM t1 WHERE w+1==98}
165 count {SELECT w FROM t1 WHERE w<3}
168 count {SELECT w FROM t1 WHERE w<=3}
171 count {SELECT w FROM t1 WHERE w+1<=4 ORDER BY w}
175 count {SELECT (w) FROM t1 WHERE (w)>(97)}
178 count {SELECT (w) FROM t1 WHERE (w)>=(97)}
181 count {SELECT (w) FROM t1 WHERE (w)==(97)}
184 count {SELECT (w) FROM t1 WHERE ((w)+(1))==(98)}
192 SELECT w, p FROM t2, t1
198 SELECT w, p FROM t2, t1
204 SELECT w, p FROM t2, t1
210 SELECT w, p FROM t2, t1
216 SELECT w, p FROM t2, t1
222 SELECT w, p FROM t2, t1
228 SELECT w, p FROM t1, t2
237 SELECT A.w, B.p, C.w FROM t1 as A, t2 as B, t1 as C
243 SELECT A.w, B.p, C.w FROM t1 as A, t2 as B, t1 as C
249 SELECT A.w, B.p, C.w FROM t1 as A, t2 as B, t1 as C
259 SELECT * FROM t1 WHERE 0
264 SELECT * FROM t1 WHERE 1 LIMIT 1
282 SELECT * FROM t1 WHERE rowid IN (1,2,3,1234) order by 1;
287 SELECT * FROM t1 WHERE rowid+0 IN (1,2,3,1234) order by 1;
292 SELECT * FROM t1 WHERE w IN (-1,1,2,3) order by 1;
297 SELECT * FROM t1 WHERE w+0 IN (-1,1,2,3) order by 1;
302 SELECT * FROM t1 WHERE rowid IN
303 (select rowid from t1 where rowid IN (-1,2,4))
309 SELECT * FROM t1 WHERE rowid+0 IN
310 (select rowid from t1 where rowid IN (-1,2,4))
316 SELECT * FROM t1 WHERE w IN
317 (select rowid from t1 where rowid IN (-1,2,4))
323 SELECT * FROM t1 WHERE w+0 IN
324 (select rowid from t1 where rowid IN (-1,2,4))
330 SELECT * FROM t1 WHERE x IN (1,7) ORDER BY 1;
335 SELECT * FROM t1 WHERE x+0 IN (1,7) ORDER BY 1;
340 SELECT * FROM t1 WHERE y IN (6400,8100) ORDER BY 1;
345 SELECT * FROM t1 WHERE x=6 AND y IN (6400,8100) ORDER BY 1;
350 SELECT * FROM t1 WHERE x IN (1,7) AND y NOT IN (6400,8100) ORDER BY 1;
355 SELECT * FROM t1 WHERE x IN (1,7) AND y IN (9,10) ORDER BY 1;
380 INSERT INTO t3 SELECT w, 101-w, y FROM t1;
496 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t3.a LIMIT 3
501 SELECT t3.a, t1.x FROM t3, t1 WHERE t3.a=t1.w ORDER BY t1.x, t3.a LIMIT 3
506 SELECT y FROM t1 ORDER BY w COLLATE text LIMIT 3;
511 SELECT y FROM t1 ORDER BY w COLLATE numeric LIMIT 3;
516 SELECT y FROM t1 ORDER BY w LIMIT 3;
524 SELECT w FROM t1 WHERE x=3 ORDER BY y;
529 SELECT w FROM t1 WHERE x=3 ORDER BY y DESC;
534 SELECT w FROM t1 WHERE x=3 AND y>100 ORDER BY y LIMIT 3;
539 SELECT w FROM t1 WHERE x=3 AND y>100 ORDER BY y DESC LIMIT 3;
544 SELECT w FROM t1 WHERE x=3 AND y>121 ORDER BY y DESC;
549 SELECT w FROM t1 WHERE x=3 AND y>=121 ORDER BY y DESC;
554 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<196 ORDER BY y DESC;
559 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<=196 ORDER BY y DESC;
564 SELECT w FROM t1 WHERE x=3 AND y>121 AND y<=196 ORDER BY y DESC;
569 SELECT w FROM t1 WHERE x=3 AND y>100 AND y<196 ORDER BY y DESC;
574 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<196 ORDER BY y;
579 SELECT w FROM t1 WHERE x=3 AND y>=121 AND y<=196 ORDER BY y;
584 SELECT w FROM t1 WHERE x=3 AND y>121 AND y<=196 ORDER BY y;
589 SELECT w FROM t1 WHERE x=3 AND y>100 AND y<196 ORDER BY y;
594 SELECT w FROM t1 WHERE x=3 AND y<81 ORDER BY y;
599 SELECT w FROM t1 WHERE x=3 AND y<=81 ORDER BY y;
604 SELECT w FROM t1 WHERE x=3 AND y>256 ORDER BY y;
609 SELECT w FROM t1 WHERE x=3 AND y>=256 ORDER BY y;
614 SELECT w FROM t1 WHERE x=3 AND y<81 ORDER BY y DESC;
619 SELECT w FROM t1 WHERE x=3 AND y<=81 ORDER BY y DESC;
624 SELECT w FROM t1 WHERE x=3 AND y>256 ORDER BY y DESC;
629 SELECT w FROM t1 WHERE x=3 AND y>=256 ORDER BY y DESC;
634 SELECT w FROM t1 WHERE x=0 AND y<4 ORDER BY y;
639 SELECT w FROM t1 WHERE x=0 AND y<=4 ORDER BY y;
644 SELECT w FROM t1 WHERE x=6 AND y>10201 ORDER BY y;
649 SELECT w FROM t1 WHERE x=6 AND y>=10201 ORDER BY y;
654 SELECT w FROM t1 WHERE x=0 AND y<4 ORDER BY y DESC;
659 SELECT w FROM t1 WHERE x=0 AND y<=4 ORDER BY y DESC;
664 SELECT w FROM t1 WHERE x=6 AND y>10201 ORDER BY y DESC;
669 SELECT w FROM t1 WHERE x=6 AND y>=10201 ORDER BY y DESC;
675 CREATE TABLE t4 AS SELECT * FROM t1;
720 SELECT count(*) FROM t1 WHERE tclvar('v1');
726 SELECT count(*) FROM t1 WHERE tclvar('v1');
737 SELECT count(*) FROM t1 WHERE tclvar('v1');