Lines Matching refs:msg
22 set v [catch {execsql {SELECT * FROM test1}} msg]
23 lappend v $msg
30 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
31 lappend v $msg
34 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
35 lappend v $msg
121 set v [catch {execsql {SELECT count(f1,f2) FROM test1}} msg]
122 lappend v $msg
125 set v [catch {execsql {SELECT count(f1) FROM test1}} msg]
126 lappend v $msg
129 set v [catch {execsql {SELECT Count() FROM test1}} msg]
130 lappend v $msg
133 set v [catch {execsql {SELECT COUNT(*) FROM test1}} msg]
134 lappend v $msg
137 set v [catch {execsql {SELECT COUNT(*)+1 FROM test1}} msg]
138 lappend v $msg
150 set v [catch {execsql {SELECT min(*) FROM test1}} msg]
151 lappend v $msg
154 set v [catch {execsql {SELECT Min(f1) FROM test1}} msg]
155 lappend v $msg
158 set v [catch {execsql {SELECT MIN(f1,f2) FROM test1}} msg]
159 lappend v [lsort $msg]
171 set v [catch {execsql {SELECT MAX(*) FROM test1}} msg]
172 lappend v $msg
175 set v [catch {execsql {SELECT Max(f1) FROM test1}} msg]
176 lappend v $msg
179 set v [catch {execsql {SELECT max(f1,f2) FROM test1}} msg]
180 lappend v [lsort $msg]
183 set v [catch {execsql {SELECT MAX(f1,f2)+1 FROM test1}} msg]
184 lappend v [lsort $msg]
187 set v [catch {execsql {SELECT MAX(f1)+1 FROM test1}} msg]
188 lappend v $msg
197 set v [catch {execsql {SELECT SUM(*) FROM test1}} msg]
198 lappend v $msg
201 set v [catch {execsql {SELECT Sum(f1) FROM test1}} msg]
202 lappend v $msg
205 set v [catch {execsql {SELECT sum(f1,f2) FROM test1}} msg]
206 lappend v $msg
209 set v [catch {execsql {SELECT SUM(f1)+1 FROM test1}} msg]
210 lappend v $msg
216 set v [catch {execsql {SELECT XYZZY(f1) FROM test1}} msg]
217 lappend v $msg
220 set v [catch {execsql {SELECT SUM(min(f1,f2)) FROM test1}} msg]
221 lappend v $msg
224 set v [catch {execsql {SELECT SUM(min(f1)) FROM test1}} msg]
225 lappend v $msg
256 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<11}} msg]
257 lappend v $msg
260 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<=11}} msg]
261 lappend v $msg
264 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1=11}} msg]
265 lappend v $msg
268 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>=11}} msg]
269 lappend v [lsort $msg]
272 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>11}} msg]
273 lappend v [lsort $msg]
276 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1!=11}} msg]
277 lappend v [lsort $msg]
280 set v [catch {execsql {SELECT f1 FROM test1 WHERE min(f1,f2)!=11}} msg]
281 lappend v [lsort $msg]
284 set v [catch {execsql {SELECT f1 FROM test1 WHERE max(f1,f2)!=11}} msg]
285 lappend v [lsort $msg]
288 set v [catch {execsql {SELECT f1 FROM test1 WHERE count(f1,f2)!=11}} msg]
289 lappend v $msg
295 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY f1}} msg]
296 lappend v $msg
299 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY -f1}} msg]
300 lappend v $msg
303 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1,f2)}} msg]
304 lappend v $msg
307 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1)}} msg]
308 lappend v $msg
407 set v [catch {execsql {SELECT max(f1) FROM test1 ORDER BY f2}} msg]
408 lappend v $msg
417 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
418 lappend v $msg
422 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
423 lappend v $msg
426 set v [catch {execsql2 {SELECT f1 as 'f1' FROM test1 ORDER BY f2}} msg]
427 lappend v $msg
430 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
431 lappend v $msg
434 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
436 lappend v $msg
439 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
440 lappend v $msg
443 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
444 lappend v $msg
447 set v [catch {execsql2 {SELECT f1 as xyzzy FROM test1 ORDER BY f2}} msg]
448 lappend v $msg
451 set v [catch {execsql2 {SELECT f1 as "xyzzy" FROM test1 ORDER BY f2}} msg]
452 lappend v $msg
455 set v [catch {execsql2 {SELECT f1 as 'xyzzy ' FROM test1 ORDER BY f2}} msg]
456 lappend v $msg
459 set v [catch {execsql2 {SELECT f1+F2 as xyzzy FROM test1 ORDER BY f2}} msg]
460 lappend v $msg
463 set v [catch {execsql2 {SELECT f1+F2 FROM test1 ORDER BY f2}} msg]
464 lappend v $msg
467 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
468 lappend v $msg
472 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
474 lappend v $msg
478 ORDER BY f2}} msg]
479 lappend v $msg
483 ORDER BY f2}} msg]
484 lappend v $msg
488 ORDER BY f2}} msg]
489 lappend v $msg
493 ORDER BY f2}} msg]
494 lappend v $msg
498 ORDER BY f2}} msg]
499 lappend v $msg
503 ORDER BY A.f1, B.f1}} msg]
504 lappend v $msg
508 ORDER BY A.f1, B.f1}} msg]
509 lappend v $msg
622 }} msg]
623 lappend v $msg
629 }} msg]
630 lappend v $msg
677 }} msg]
678 lappend v $msg
684 }} msg]
685 lappend v $msg
689 set v [catch {execsql {SELECT f1 FROM test1 as 'hi', test2 as}} msg]
690 lappend v $msg
695 }} msg]
696 lappend v $msg
701 }} msg]
702 lappend v $msg
707 }} msg]
708 lappend v $msg
713 }} msg]
714 lappend v $msg
719 }} msg]
720 lappend v $msg