Lines Matching +full:3 +full:v
17 # $Id: select1.test,v 1.30.2.3 2004/07/20 01:45:49 drh Exp $
25 set v [catch {execsql {SELECT * FROM test1}} msg]
26 lappend v $msg
32 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
33 lappend v $msg
36 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
37 lappend v $msg
66 do_test select1-1.8.3 {
123 set v [catch {execsql {SELECT count(f1,f2) FROM test1}} msg]
124 lappend v $msg
127 set v [catch {execsql {SELECT count(f1) FROM test1}} msg]
128 lappend v $msg
131 set v [catch {execsql {SELECT Count() FROM test1}} msg]
132 lappend v $msg
135 set v [catch {execsql {SELECT COUNT(*) FROM test1}} msg]
136 lappend v $msg
139 set v [catch {execsql {SELECT COUNT(*)+1 FROM test1}} msg]
140 lappend v $msg
141 } {0 3}
144 } {4 3 3}
148 do_test select1-2.5.3 {
152 set v [catch {execsql {SELECT min(*) FROM test1}} msg]
153 lappend v $msg
156 set v [catch {execsql {SELECT Min(f1) FROM test1}} msg]
157 lappend v $msg
160 set v [catch {execsql {SELECT MIN(f1,f2) FROM test1}} msg]
161 lappend v [lsort $msg]
169 do_test select1-2.8.3 {
173 set v [catch {execsql {SELECT MAX(*) FROM test1}} msg]
174 lappend v $msg
177 set v [catch {execsql {SELECT Max(f1) FROM test1}} msg]
178 lappend v $msg
181 set v [catch {execsql {SELECT max(f1,f2) FROM test1}} msg]
182 lappend v [lsort $msg]
185 set v [catch {execsql {SELECT MAX(f1,f2)+1 FROM test1}} msg]
186 lappend v [lsort $msg]
189 set v [catch {execsql {SELECT MAX(f1)+1 FROM test1}} msg]
190 lappend v $msg
199 set v [catch {execsql {SELECT SUM(*) FROM test1}} msg]
200 lappend v $msg
203 set v [catch {execsql {SELECT Sum(f1) FROM test1}} msg]
204 lappend v $msg
207 set v [catch {execsql {SELECT sum(f1,f2) FROM test1}} msg]
208 lappend v $msg
211 set v [catch {execsql {SELECT SUM(f1)+1 FROM test1}} msg]
212 lappend v $msg
218 set v [catch {execsql {SELECT XYZZY(f1) FROM test1}} msg]
219 lappend v $msg
222 set v [catch {execsql {SELECT SUM(min(f1,f2)) FROM test1}} msg]
223 lappend v $msg
226 set v [catch {execsql {SELECT SUM(min(f1)) FROM test1}} msg]
227 lappend v $msg
233 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<11}} msg]
234 lappend v $msg
237 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<=11}} msg]
238 lappend v $msg
241 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1=11}} msg]
242 lappend v $msg
245 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>=11}} msg]
246 lappend v [lsort $msg]
249 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>11}} msg]
250 lappend v [lsort $msg]
253 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1!=11}} msg]
254 lappend v [lsort $msg]
257 set v [catch {execsql {SELECT f1 FROM test1 WHERE min(f1,f2)!=11}} msg]
258 lappend v [lsort $msg]
261 set v [catch {execsql {SELECT f1 FROM test1 WHERE max(f1,f2)!=11}} msg]
262 lappend v [lsort $msg]
265 set v [catch {execsql {SELECT f1 FROM test1 WHERE count(f1,f2)!=11}} msg]
266 lappend v $msg
272 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY f1}} msg]
273 lappend v $msg
276 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY -f1}} msg]
277 lappend v $msg
280 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1,f2)}} msg]
281 lappend v $msg
284 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1)}} msg]
285 lappend v $msg
317 SELECT * FROM t5 ORDER BY 3;
319 } {1 {ORDER BY column number 3 out of range - should be between 1 and 2}}
322 INSERT INTO t5 VALUES(3,10);
325 } {2 9 3 10 1 10}
330 } {3 10 2 9 1 10}
335 } {1 10 3 10 2 9}
341 set v [catch {execsql {SELECT max(f1) FROM test1 ORDER BY f2}} msg]
342 lappend v $msg
351 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
352 lappend v $msg
356 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
357 lappend v $msg
360 set v [catch {execsql2 {SELECT f1 as 'f1' FROM test1 ORDER BY f2}} msg]
361 lappend v $msg
363 do_test select1-6.1.3 {
364 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
365 lappend v $msg
368 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
370 lappend v $msg
373 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
374 lappend v $msg
377 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
378 lappend v $msg
381 set v [catch {execsql2 {SELECT f1 as xyzzy FROM test1 ORDER BY f2}} msg]
382 lappend v $msg
385 set v [catch {execsql2 {SELECT f1 as "xyzzy" FROM test1 ORDER BY f2}} msg]
386 lappend v $msg
389 set v [catch {execsql2 {SELECT f1 as 'xyzzy ' FROM test1 ORDER BY f2}} msg]
390 lappend v $msg
393 set v [catch {execsql2 {SELECT f1+F2 as xyzzy FROM test1 ORDER BY f2}} msg]
394 lappend v $msg
397 set v [catch {execsql2 {SELECT f1+F2 FROM test1 ORDER BY f2}} msg]
398 lappend v $msg
401 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
402 lappend v $msg
406 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
408 lappend v $msg
411 set v [catch {execsql2 {SELECT test1.f1+F2, t1 FROM test1, test2
413 lappend v $msg
416 set v [catch {execsql2 {SELECT A.f1, t1 FROM test1 as A, test2
418 lappend v $msg
421 set v [catch {execsql2 {SELECT A.f1, f1 FROM test1 as A, test1 as B
423 lappend v $msg
426 set v [catch {execsql2 {SELECT A.f1, B.f1 FROM test1 as A, test1 as B
428 lappend v $msg
431 set v [catch {execsql2 {SELECT A.f1, f1 FROM test1 as A, test1 as A
433 lappend v $msg
436 set v [catch {execsql2 {SELECT A.f1, B.f1 FROM test1 as A, test1 as B
438 lappend v $msg
441 set v [catch {execsql2 {
445 lappend v $msg
448 set v [catch {execsql2 {
452 lappend v $msg
456 set v [catch {execsql {
459 lappend v $msg
462 set v [catch {execsql {
465 lappend v $msg
468 set v [catch {execsql {SELECT f1 FROM test1 as 'hi', test2 as}} msg]
469 lappend v $msg
472 set v [catch {execsql {
475 lappend v $msg
478 set v [catch {execsql {
481 lappend v $msg
484 set v [catch {execsql {
487 lappend v $msg
490 set v [catch {execsql {
493 lappend v $msg
496 set v [catch {execsql {
499 lappend v $msg
513 SELECT f1 FROM test1 WHERE 5-3==2
527 SELECT min(1,2,3), -max(1,2,3)
530 } {1 -3 1 -3}
604 INSERT INTO t4 VALUES(3,4);
607 } {1 2 3 4}
612 } {t3.a 1 t3.b 2 t4.a 3 t4.b 4}
617 } {x.a 1 x.b 2 y.a 3 y.b 4}
642 } {2 3 4}
647 } {t3.b 2 t4.a 3 t4.b 4}
652 } {x.b 2 y.a 3 y.b 4}
677 } {t3.a 1 t3.b 2 tx.max(a) 3 tx.max(b) 4}
682 } {y.max(a) 3 y.max(b) 4 t3.a 1 t3.b 2}
693 SELECT 1+2+3
695 } {1+2+3 6}
710 SELECT * FROM t3 UNION SELECT 3 AS 'a', 4 ORDER BY a;
712 } {1 2 3 4}
715 SELECT 3, 4 UNION SELECT * FROM t3;
717 } {1 2 3 4}
734 } {x 1 x 3}
741 } {z.x 1 z.x 3}