Lines Matching refs:w
25 CREATE TABLE t1(w int, x int, y int, z int);
28 set w $i
33 execsql {INSERT INTO t1 VALUES($::w,$::x,$::y,$::z)}
35 execsql {INSERT INTO t1 VALUES(:w,:x,:y,:z)}
39 CREATE UNIQUE INDEX i1w ON t1(w);
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
112 SELECT * FROM t1 WHERE w=85 ORDER BY random();
183 ORDER BY w
190 ORDER BY w
197 ORDER BY w
206 ORDER BY w
214 ORDER BY w
257 ORDER BY w
263 ORDER BY w DESC
272 ORDER BY w
283 SELECT * FROM t1 WHERE w=99 ORDER BY w
290 SELECT * FROM t1 WHERE w IN (99) ORDER BY w
295 SELECT * FROM t1 WHERE w IN (99) ORDER BY w DESC
306 SELECT * FROM t1 WHERE w=99 OR w=100 ORDER BY +w
311 SELECT * FROM t1 WHERE 99=w OR 100=w ORDER BY +w
316 SELECT * FROM t1 WHERE w=99 OR w=100 OR 6=w ORDER BY +w
322 SELECT * FROM t1 WHERE w=99 OR w=100 OR 6=+w ORDER BY +w
327 SELECT *, '|' FROM t1 WHERE w=99 OR +w=100 OR 6=w ORDER BY +w
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)
342 ORDER BY +b.w
348 WHERE a.w=1 AND (b.z=10 OR a.y=b.z OR b.z=10)
349 ORDER BY +b.w
544 SELECT w FROM t1
551 SELECT w FROM t1
559 CREATE INDEX tx_xyz ON tx(x, y, z, w);
560 SELECT w FROM tx
561 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 10 AND 20)
562 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
563 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 12 AND 14)
568 SELECT w FROM tx
569 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 10 AND 20)
570 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 12 AND 14)
571 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 10 AND 20)
576 SELECT w FROM tx
577 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 12 AND 14)
578 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
579 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 10 AND 20)
584 SELECT w FROM tx
585 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 10 AND 20)
586 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
587 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 10 AND 20)
592 SELECT w FROM tx
593 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 10 AND 20)
594 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
595 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 2 AND 4)
600 SELECT w FROM tx
601 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 10 AND 20)
602 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 2 AND 4)
603 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 10 AND 20)
608 SELECT w FROM tx
609 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 2 AND 4)
610 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
611 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 10 AND 20)
616 SELECT w FROM tx
617 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 10 AND 20)
618 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
619 AND z IN (SELECT z FROM t1 WHERE w BETWEEN -4 AND -2)
624 SELECT w FROM tx
625 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 10 AND 20)
626 AND y IN (SELECT y FROM t1 WHERE w BETWEEN -4 AND -2)
627 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 10 AND 20)
632 SELECT w FROM tx
633 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN -4 AND -2)
634 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
635 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 10 AND 20)
640 SELECT w FROM tx
641 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 10 AND 20)
642 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
643 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 200 AND 300)
648 SELECT w FROM tx
649 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 10 AND 20)
650 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 200 AND 300)
651 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 10 AND 20)
656 SELECT w FROM tx
657 WHERE x IN (SELECT x FROM t1 WHERE w BETWEEN 200 AND 300)
658 AND y IN (SELECT y FROM t1 WHERE w BETWEEN 10 AND 20)
659 AND z IN (SELECT z FROM t1 WHERE w BETWEEN 10 AND 20)
664 SELECT w FROM tx
665 WHERE x IN (SELECT x FROM t1 WHERE +w BETWEEN 10 AND 20)
666 AND y IN (SELECT y FROM t1 WHERE +w BETWEEN 10 AND 20)
667 AND z IN (SELECT z FROM t1 WHERE +w BETWEEN 200 AND 300)
672 SELECT w FROM tx
673 WHERE x IN (SELECT x FROM t1 WHERE +w BETWEEN 10 AND 20)
674 AND y IN (SELECT y FROM t1 WHERE +w BETWEEN 200 AND 300)
675 AND z IN (SELECT z FROM t1 WHERE +w BETWEEN 10 AND 20)
680 SELECT w FROM tx
681 WHERE x IN (SELECT x FROM t1 WHERE +w BETWEEN 200 AND 300)
682 AND y IN (SELECT y FROM t1 WHERE +w BETWEEN 10 AND 20)
683 AND z IN (SELECT z FROM t1 WHERE +w BETWEEN 10 AND 20)