Lines Matching refs:y
22 CREATE TABLE t1(w int, x int, y int);
28 set y [expr {$i*$i + 2*$i + 1}]
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;
37 set maxy [execsql {select max(y) from t1}]
39 INSERT INTO t2 SELECT 101-w, x, $maxy+1-y, y FROM t1;
45 CREATE INDEX i1xy ON t1(`x`,'y' ASC); -- Old MySQL compatibility
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
74 SELECT x, y, w FROM t1 WHERE w IS 10
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
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
122 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}
128 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}
134 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}
146 SELECT x, y FROM t1 WHERE w>10 AND y=144 AND x=3
147 } {*SEARCH t1 USING INDEX i1xy (x=? AND y=?)*}
149 SELECT x, y FROM t1 WHERE y=144 AND x=3
150 } {*SEARCH t1 USING COVERING INDEX i1xy (x=? AND y=?)*}
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}
296 WHERE x=q AND y=s AND r=8977
302 WHERE x=q AND s=y AND r=8977
308 WHERE x=q AND s=y AND r=8977 AND w>10
314 WHERE p<80 AND x=q AND s=y AND r=8977 AND w>10
320 WHERE p<80 AND x=q AND 8977=r AND s=y AND w>10
326 WHERE x=q AND p=77 AND s=y AND w>5
332 WHERE x=q AND p>77 AND s=y AND w=5
341 WHERE C.w=101-B.p AND B.r=10202-A.y AND A.w=11
347 WHERE C.w=101-B.p AND B.r=10202-A.y AND A.w=12
353 WHERE A.w=15 AND B.p=C.w AND B.r=10202-A.y
475 SELECT * FROM t1 WHERE y IN (6400,8100) ORDER BY 1;
480 SELECT * FROM t1 WHERE x=6 AND y IN (6400,8100) ORDER BY 1;
485 SELECT * FROM t1 WHERE x IN (1,7) AND y NOT IN (6400,8100) ORDER BY 1;
490 SELECT * FROM t1 WHERE x IN (1,7) AND y IN (9,10) ORDER BY 1;
495 SELECT * FROM t1 WHERE x IN (1,7) AND y IN (9,16) ORDER BY 1;
500 SELECT w, x, y FROM t1 WHERE x IN (1,5) AND y IN (9,8,3025,1000,3969)
501 ORDER BY x, y
506 SELECT w, x, y FROM t1 WHERE x IN (1,5) AND y IN (9,8,3025,1000,3969)
507 ORDER BY x DESC, y DESC
512 SELECT w, x, y FROM t1 WHERE x IN (1,5) AND y IN (9,8,3025,1000,3969)
513 ORDER BY x DESC, y
518 SELECT w, x, y FROM t1 WHERE x IN (1,5) AND y IN (9,8,3025,1000,3969)
519 ORDER BY x, y DESC
546 INSERT INTO t3 SELECT w, 101-w, y FROM t1;
694 SELECT y FROM t1 ORDER BY w LIMIT 3;
699 SELECT y FROM t1 ORDER BY rowid LIMIT 3;
704 SELECT y FROM t1 ORDER BY rowid, y LIMIT 3;
709 SELECT y FROM t1 ORDER BY rowid, y DESC 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;
724 SELECT y FROM t1 WHERE y>4 AND y<25 ORDER BY rowid;
729 SELECT y FROM t1 WHERE y>=4 AND y<=25 ORDER BY oid;
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;
893 SELECT y FROM t1 ORDER BY rowid DESC LIMIT 3
898 SELECT y FROM t1 WHERE y<25 ORDER BY rowid DESC
903 SELECT y FROM t1 WHERE y<=25 ORDER BY rowid DESC
908 SELECT y FROM t1 WHERE y<25 AND y>4 ORDER BY rowid DESC, y DESC
913 SELECT y FROM t1 WHERE y<25 AND y>=4 ORDER BY rowid DESC
920 CREATE INDEX i4xy ON t4(x,y);
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;
1167 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.a, y.b
1172 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.a, y.b DESC
1177 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.a, x.b
1182 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.a, x.b DESC
1188 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a||x.b
1194 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a||x.b DESC
1199 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, y.a||y.b
1204 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a, y.a||y.b
1209 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a, x.a||x.b
1214 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, y.a||y.b DESC
1219 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a||y.b
1224 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a||y.b DESC
1229 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, y.a||x.b
1234 SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, y.a||x.b DESC
1384 CREATE TABLE t192(x INTEGER PRIMARY KEY,y INT, z INT);
1387 SELECT t191.rowid FROM t192, t191 WHERE (a=y OR b=y) AND x=?1;
1395 CREATE TABLE t202(y, z);
1398 CREATE INDEX t202i ON t202(y, ifnull(z, 0));
1399 SELECT count(*) FROM t201 LEFT JOIN t202 ON (x=y) WHERE ifnull(z, 0) >=0;
1444 CREATE TABLE t2(x INTEGER PRIMARY KEY, y INT);
1445 INSERT INTO t2(y) VALUES(2),(3);
1446 SELECT * FROM t1, t2 WHERE a=y AND y=3;