Lines Matching refs:msg
23 set v [catch {execsql {SELECT * FROM test1}} msg]
24 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
231 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<11}} msg]
232 lappend v $msg
235 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<=11}} msg]
236 lappend v $msg
239 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1=11}} msg]
240 lappend v $msg
243 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>=11}} msg]
244 lappend v [lsort $msg]
247 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>11}} msg]
248 lappend v [lsort $msg]
251 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1!=11}} msg]
252 lappend v [lsort $msg]
255 set v [catch {execsql {SELECT f1 FROM test1 WHERE min(f1,f2)!=11}} msg]
256 lappend v [lsort $msg]
259 set v [catch {execsql {SELECT f1 FROM test1 WHERE max(f1,f2)!=11}} msg]
260 lappend v [lsort $msg]
263 set v [catch {execsql {SELECT f1 FROM test1 WHERE count(f1,f2)!=11}} msg]
264 lappend v $msg
270 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY f1}} msg]
271 lappend v $msg
274 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY -f1}} msg]
275 lappend v $msg
278 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1,f2)}} msg]
279 lappend v $msg
282 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1)}} msg]
283 lappend v $msg
339 set v [catch {execsql {SELECT max(f1) FROM test1 ORDER BY f2}} msg]
340 lappend v $msg
349 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
350 lappend v $msg
354 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
355 lappend v $msg
358 set v [catch {execsql2 {SELECT f1 as 'f1' FROM test1 ORDER BY f2}} msg]
359 lappend v $msg
362 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
363 lappend v $msg
366 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
368 lappend v $msg
371 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
372 lappend v $msg
375 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
376 lappend v $msg
379 set v [catch {execsql2 {SELECT f1 as xyzzy FROM test1 ORDER BY f2}} msg]
380 lappend v $msg
383 set v [catch {execsql2 {SELECT f1 as "xyzzy" FROM test1 ORDER BY f2}} msg]
384 lappend v $msg
387 set v [catch {execsql2 {SELECT f1 as 'xyzzy ' FROM test1 ORDER BY f2}} msg]
388 lappend v $msg
391 set v [catch {execsql2 {SELECT f1+F2 as xyzzy FROM test1 ORDER BY f2}} msg]
392 lappend v $msg
395 set v [catch {execsql2 {SELECT f1+F2 FROM test1 ORDER BY f2}} msg]
396 lappend v $msg
399 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
400 lappend v $msg
404 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
406 lappend v $msg
410 ORDER BY f2}} msg]
411 lappend v $msg
415 ORDER BY f2}} msg]
416 lappend v $msg
420 ORDER BY f2}} msg]
421 lappend v $msg
425 ORDER BY f2}} msg]
426 lappend v $msg
430 ORDER BY f2}} msg]
431 lappend v $msg
435 ORDER BY A.f1, B.f1}} msg]
436 lappend v $msg
442 }} msg]
443 lappend v $msg
449 }} msg]
450 lappend v $msg
456 }} msg]
457 lappend v $msg
462 }} msg]
463 lappend v $msg
466 set v [catch {execsql {SELECT f1 FROM test1 as 'hi', test2 as}} msg]
467 lappend v $msg
472 }} msg]
473 lappend v $msg
478 }} msg]
479 lappend v $msg
484 }} msg]
485 lappend v $msg
490 }} msg]
491 lappend v $msg
496 }} msg]
497 lappend v $msg