Lines Matching full:where

60   execsql {SELECT x75 FROM manycol WHERE x50=350}
63   execsql {SELECT x50 FROM manycol WHERE x99=599}
67   execsql {SELECT x50 FROM manycol WHERE x99=899}
73   execsql {DELETE FROM manycol WHERE x98=1234}
77   execsql {DELETE FROM manycol WHERE x98=998}
81   execsql {DELETE FROM manycol WHERE x99=500}
85   execsql {DELETE FROM manycol WHERE x99=599}
148 # before executing a command.  Thus if "WHERE" is misspelled on an UPDATE,
271 # A WHERE clause is not allowed to contain more than 99 terms.  Check to
278   set ::where {WHERE x0>=0}
280     append ::where " AND x$i<>0"
282   catchsql "SELECT count(*) FROM manycol $::where"
285   catchsql "SELECT count(*) FROM manycol $::where AND rowid>0"
286 } {1 {WHERE clause too complex - no more than 100 terms allowed}}
288   regsub "x0>=0" $::where "x0=0" ::where
289   catchsql "DELETE FROM manycol $::where"
295   catchsql "DELETE FROM manycol $::where AND rowid>0"
296 } {1 {WHERE clause too complex - no more than 100 terms allowed}}
298   execsql {SELECT x1 FROM manycol WHERE x0=100}
301   regsub "x0=0" $::where "x0=100" ::where
302   catchsql "UPDATE manycol SET x1=x1+1 $::where"
305   execsql {SELECT x1 FROM manycol WHERE x0=100}
308   catchsql "UPDATE manycol SET x1=x1+1 $::where AND rowid>0"
309 } {1 {WHERE clause too complex - no more than 100 terms allowed}}
311   execsql {SELECT x1 FROM manycol WHERE x0=100}
332 # all comparisions where numeric if either operand looked like a number.
433      WHERE x=(SELECT x FROM t9 WHERE y=1)
434         OR x=(SELECT x FROM t9 WHERE y=2)
435         OR x=(SELECT x FROM t9 WHERE y=3)
436         OR x=(SELECT x FROM t9 WHERE y=4)
437         OR x=(SELECT x FROM t9 WHERE y=5)
438         OR x=(SELECT x FROM t9 WHERE y=6)
439         OR x=(SELECT x FROM t9 WHERE y=7)
440         OR x=(SELECT x FROM t9 WHERE y=8)
441         OR x=(SELECT x FROM t9 WHERE y=9)
442         OR x=(SELECT x FROM t9 WHERE y=10)
443         OR x=(SELECT x FROM t9 WHERE y=11)
444         OR x=(SELECT x FROM t9 WHERE y=12)
445         OR x=(SELECT x FROM t9 WHERE y=13)
446         OR x=(SELECT x FROM t9 WHERE y=14)
537     UPDATE TempTable SET TestString = TestString + 1 WHERE TestID IN (1, 2);