Lines Matching full:where
44 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
49 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
54 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
59 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
64 set sql "SELECT x FROM t1 WHERE _rowid_==$x2rowid(1)"
72 execsql "SELECT x FROM t1 WHERE rowid=$norow"
103 UPDATE t1 SET rowid=12345 WHERE x==1;
110 SELECT rowid, * FROM t1 WHERE rowid>1000;
115 UPDATE t1 SET oid=12346 WHERE x==1;
122 SELECT rowid, * FROM t1 WHERE rowid>1000;
127 UPDATE t1 SET _rowid_=12347 WHERE x==1;
128 SELECT rowid, * FROM t1 WHERE rowid>1000;
132 # But we can use ROWID in the WHERE clause of an UPDATE that does not
137 set sql "UPDATE t1 SET x=2 WHERE OID==$x2rowid(3)"
143 set sql "UPDATE t1 SET x=3 WHERE _rowid_==$x2rowid(3)"
209 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
212 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
215 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.oid==t2.rowid}
218 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
221 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t2.rowid==t1.rowid}
224 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND t1.x==4}
227 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
230 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t2.rowid==t1.rowid}
233 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND t1.x==4}
237 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
240 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
243 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND 4==t1.x}
246 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
249 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
252 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND 4==t1.x}
259 WHERE t2.y==256 AND t1.rowid==t2.rowid
266 WHERE t1.OID==t2.rowid AND t2.y==81
272 WHERE t2.y==256 AND t1.rowid==t2.rowid
277 execsql {DELETE FROM t1 WHERE _rowid_ IN (SELECT oid FROM t1 WHERE x>8)}
281 # Make sure a "WHERE rowid=X" clause works when there is no ROWID of X.
290 if {[execsql "SELECT x FROM t1 WHERE rowid=$::norow"]==""} break
293 DELETE FROM t1 WHERE rowid=$::norow
351 SELECT b FROM t2 WHERE a NOT IN(1,2,1000000,1000001,2147483647);
360 SELECT b FROM t2 WHERE a NOT IN(1,2,1000000,1000001,2147483647) ORDER BY b;
365 DELETE FROM t2 WHERE a!=2;
428 SELECT * FROM t3 WHERE a<123.5
433 SELECT * FROM t3 WHERE a<124.5
438 SELECT * FROM t3 WHERE a>123.5
443 SELECT * FROM t3 WHERE a>122.5
448 SELECT * FROM t3 WHERE a==123.5
453 SELECT * FROM t3 WHERE a==123.000
458 SELECT * FROM t3 WHERE a>100.5 AND a<200.5
463 SELECT * FROM t3 WHERE a>'xyz';
468 SELECT * FROM t3 WHERE a<'xyz';
473 SELECT * FROM t3 WHERE a>=122.9 AND a<=123.1
491 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5}
494 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0}
497 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5}
500 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0}
503 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid}
506 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid}
509 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5}
512 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5}
515 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid}
518 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid}
521 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5 ORDER BY rowid DESC}
524 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0 ORDER BY rowid DESC}
527 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5 ORDER BY rowid DESC}
530 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0 ORDER BY rowid DESC}
533 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid ORDER BY rowid DESC}
536 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid ORDER BY rowid DESC}
539 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5 ORDER BY rowid DESC}
542 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5 ORDER BY rowid DESC}
545 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid ORDER BY rowid DESC}
548 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid ORDER BY rowid DESC}
559 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.5}
562 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.0}
565 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.5 ORDER BY rowid DESC}
568 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.0 ORDER BY rowid DESC}
571 execsql {SELECT rowid, a FROM t6 WHERE -5.5<=rowid}
574 execsql {SELECT rowid, a FROM t6 WHERE -5.5<=rowid ORDER BY rowid DESC}
577 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.5}
580 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.0}
583 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.5 ORDER BY rowid DESC}
586 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.0 ORDER BY rowid DESC}
589 execsql {SELECT rowid, a FROM t6 WHERE -5.5<rowid}
592 execsql {SELECT rowid, a FROM t6 WHERE -5.5<rowid ORDER BY rowid DESC}
595 execsql {SELECT rowid, a FROM t6 WHERE rowid<=-5.5}
598 execsql {SELECT rowid, a FROM t6 WHERE rowid<=-5.5 ORDER BY rowid DESC}
601 execsql {SELECT rowid, a FROM t6 WHERE -5.5>=rowid}
604 execsql {SELECT rowid, a FROM t6 WHERE -5.5>=rowid ORDER BY rowid DESC}
607 execsql {SELECT rowid, a FROM t6 WHERE rowid<-5.5}
610 execsql {SELECT rowid, a FROM t6 WHERE rowid<-5.5 ORDER BY rowid DESC}
613 execsql {SELECT rowid, a FROM t6 WHERE -5.5>rowid}
616 execsql {SELECT rowid, a FROM t6 WHERE -5.5>rowid ORDER BY rowid DESC}
622 execsql {SELECT rowid, a FROM t5 WHERE rowid>'abc'}
625 execsql {SELECT rowid, a FROM t5 WHERE rowid>='abc'}
628 execsql {SELECT rowid, a FROM t5 WHERE rowid<'abc'}
631 execsql {SELECT rowid, a FROM t5 WHERE rowid<='abc'}