Lines Matching refs:upr

128   set upr [expr {($i+10)*100}]
129   lappend list $lwr $upr
132   foreach {lwr upr} $::list {
133     db eval  {SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr}
136 explain {SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr}
176   set upr [expr {($i+10)*100}]
177   lappend list $lwr $upr
180   foreach {lwr upr} $::list {
181     db eval {SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr}
184 explain {SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr}
245   set upr [expr {($i+1)*2}]
246   lappend list $lwr $upr
249   foreach {lwr upr} $::list {
250     db eval {UPDATE t1 SET b=b*2 WHERE a>=$lwr AND a<$upr}
253 explain {UPDATE t1 SET b=b*2 WHERE a>=$lwr AND a<$upr}