Lines Matching refs:y
25 CREATE TABLE t1(w int, x int, y int, z int);
30 set y [expr {$i*$i + 2*$i + 1}]
31 set z [expr {$x+$y}]
33 execsql {INSERT INTO t1 VALUES($::w,$::x,$::y,$::z)}
35 execsql {INSERT INTO t1 VALUES(:w,:x,:y,:z)}
40 CREATE INDEX i1xy ON t1(x,y);
41 CREATE INDEX i1zyx ON t1(z,y,x);
81 } elseif {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+) USING.* INDEX (\w+)\y} \
84 } elseif {[regexp {(SCAN|SEARCH) (\w+ AS )?(\w+)\y} $x all ss as tab]} {
96 SELECT * FROM t1 WHERE w=85 AND x=6 AND y=7396
104 SELECT * FROM t1 WHERE w=85 AND x=6 AND y=7396 AND rowid=85
117 SELECT * FROM t1 WHERE x=6 AND y=7396 ORDER BY random();
122 SELECT * FROM t1 WHERE rowid=85 AND x=6 AND y=7396 ORDER BY random();
181 SELECT * FROM t1 WHERE z IN (10207,10006) AND y IN (10000,10201)
188 SELECT * FROM t1 WHERE z IN (10207,10006) AND y=10000
195 SELECT * FROM t1 WHERE z=10006 AND y IN (10000,10201)
204 AND y IN (10000,10201)
212 AND y IN (SELECT 10000 UNION SELECT 10201)
222 AND y IN (10000,10001,10002,10003,10004,10005)
230 AND y IN (10000,10001,10002,10003,10004,10005)
238 AND y IN (10000,10001,10002,10003,10004,10005)
239 ORDER BY x, y
246 AND y IN (10000,10001,10002,10003,10004,10005)
247 ORDER BY x, y DESC
260 do_test where2-4.6y {
332 SELECT *, '|' FROM t1 WHERE w=99 OR y=10201 OR 6=w ORDER BY +w
341 WHERE a.w=1 AND (a.y=b.z OR b.z=10)
348 WHERE a.w=1 AND (b.z=10 OR a.y=b.z OR b.z=10)
463 SELECT x.a, y.a FROM t2249a x CROSS JOIN t2249a y WHERE x.a=y.a
465 } {0123 0123 nosort x sqlite_autoindex_t2249a_1 y sqlite_autoindex_t2249a_1}
474 SELECT x.a,y.a FROM t2249a x CROSS JOIN t2249a y
475 WHERE x.a=y.a OR y.a='hello'
477 } {0123 0123 nosort x sqlite_autoindex_t2249a_1 y sqlite_autoindex_t2249a_1}
480 SELECT x.a,y.a FROM t2249a x CROSS JOIN t2249a y
481 WHERE y.a=x.a OR y.a='hello'
483 } {0123 0123 nosort x sqlite_autoindex_t2249a_1 y sqlite_autoindex_t2249a_1}
486 SELECT x.a,y.a FROM t2249a x CROSS JOIN t2249a y
487 WHERE y.a='hello' OR x.a=y.a
489 } {0123 0123 nosort x sqlite_autoindex_t2249a_1 y sqlite_autoindex_t2249a_1}
502 create table t9(x,y);
505 select y from t8, t9 where a=1 order by a, y;
515 select * from t8, t9 where a=1 and y=3 order by b, x
520 create unique index i9y on t9(y);
521 select * from t8, t9 where a=1 and y=3 order by b, x
533 SELECT * FROM t1 WHERE x IN (20,21) AND y IN (1,2)
538 SELECT * FROM t1 WHERE x IN (1,2) AND y IN (-5,-6)
546 AND +y IN (SELECT y FROM tx WHERE rowid=1)
553 AND y IN (SELECT y FROM tx WHERE rowid<0)
559 CREATE INDEX tx_xyz ON tx(x, y, z, w);
562 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
570 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 12 AND 14)
578 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
586 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
594 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
602 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 2 AND 4)
610 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
618 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
626 AND y IN (SELECT y FROM t1 WHERE w BETWEEN -4 AND -2)
634 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
642 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
650 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 200 AND 300)
658 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
666 AND y IN (SELECT y FROM t1 WHERE +w BETWEEN 10 AND 20)
674 AND y IN (SELECT y FROM t1 WHERE +w BETWEEN 200 AND 300)
682 AND y IN (SELECT y FROM t1 WHERE +w BETWEEN 10 AND 20)
752 CREATE TABLE t12(x INTEGER PRIMARY KEY, y INT, z CHAR(100));
753 CREATE INDEX t12y ON t12(y);
756 FROM t12 AS a JOIN t12 AS b ON a.y=b.x
757 WHERE (b.x=$abc OR b.y=$abc);
776 CREATE TABLE t14b(y INTEGER PRIMARY KEY);
777 INSERT INTO t14b(y) VALUES(1);