Lines Matching refs:f1
27 execsql {CREATE TABLE test1(f1 int, f2 int)}
38 execsql {INSERT INTO test1(f1,f2) VALUES(11,22)}
44 execsql {SELECT f1 FROM test1}
50 execsql {SELECT f2, f1 FROM test1}
53 execsql {SELECT f1, f2 FROM test1}
62 execsql {SELECT *, min(f1,f2), max(f1,f2) FROM test1}
81 execsql {SELECT test1.f1, test2.r1 FROM test1, test2}
84 execsql {SELECT test1.f1, test2.r1 FROM test2, test1}
93 execsql {SELECT max(test1.f1,test2.r1), min(test1.f2,test2.r2)
97 execsql {SELECT min(test1.f1,test2.r1), max(test1.f2,test2.r2)
121 set v [catch {execsql {SELECT count(f1,f2) FROM test1}} msg]
125 set v [catch {execsql {SELECT count(f1) FROM test1}} msg]
154 set v [catch {execsql {SELECT Min(f1) FROM test1}} msg]
158 set v [catch {execsql {SELECT MIN(f1,f2) FROM test1}} msg]
175 set v [catch {execsql {SELECT Max(f1) FROM test1}} msg]
179 set v [catch {execsql {SELECT max(f1,f2) FROM test1}} msg]
183 set v [catch {execsql {SELECT MAX(f1,f2)+1 FROM test1}} msg]
187 set v [catch {execsql {SELECT MAX(f1)+1 FROM test1}} msg]
201 set v [catch {execsql {SELECT Sum(f1) FROM test1}} msg]
205 set v [catch {execsql {SELECT sum(f1,f2) FROM test1}} msg]
209 set v [catch {execsql {SELECT SUM(f1)+1 FROM test1}} msg]
216 set v [catch {execsql {SELECT XYZZY(f1) FROM test1}} msg]
220 set v [catch {execsql {SELECT SUM(min(f1,f2)) FROM test1}} msg]
224 set v [catch {execsql {SELECT SUM(min(f1)) FROM test1}} msg]
231 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<11}} msg]
235 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1<=11}} msg]
239 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1=11}} msg]
243 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>=11}} msg]
247 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1>11}} msg]
251 set v [catch {execsql {SELECT f1 FROM test1 WHERE f1!=11}} msg]
255 set v [catch {execsql {SELECT f1 FROM test1 WHERE min(f1,f2)!=11}} msg]
259 set v [catch {execsql {SELECT f1 FROM test1 WHERE max(f1,f2)!=11}} msg]
263 set v [catch {execsql {SELECT f1 FROM test1 WHERE count(f1,f2)!=11}} msg]
270 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY f1}} msg]
274 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY -f1}} msg]
278 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1,f2)}} msg]
282 set v [catch {execsql {SELECT f1 FROM test1 ORDER BY min(f1)}} msg]
287 SELECT f1 FROM test1 ORDER BY 8.4;
292 SELECT f1 FROM test1 ORDER BY '8.4';
297 SELECT f1 FROM test1 ORDER BY 'xyz';
339 set v [catch {execsql {SELECT max(f1) FROM test1 ORDER BY f2}} msg]
349 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
351 } {0 {f1 11 f1 33}}
354 set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
356 } {0 {test1.f1 11 test1.f1 33}}
358 set v [catch {execsql2 {SELECT f1 as 'f1' FROM test1 ORDER BY f2}} msg]
360 } {0 {f1 11 f1 33}}
362 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
364 } {0 {test1.f1 11 test1.f2 22}}
366 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
369 } {0 {test1.f1 11 test1.f2 22}}
371 set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
373 } {0 {f1 11 f2 22}}
375 set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
377 } {0 {f1 11 f2 22}}
379 set v [catch {execsql2 {SELECT f1 as xyzzy FROM test1 ORDER BY f2}} msg]
383 set v [catch {execsql2 {SELECT f1 as "xyzzy" FROM test1 ORDER BY f2}} msg]
387 set v [catch {execsql2 {SELECT f1 as 'xyzzy ' FROM test1 ORDER BY f2}} msg]
391 set v [catch {execsql2 {SELECT f1+F2 as xyzzy FROM test1 ORDER BY f2}} msg]
395 set v [catch {execsql2 {SELECT f1+F2 FROM test1 ORDER BY f2}} msg]
397 } {0 {f1+F2 33 f1+F2 77}}
399 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
401 } {0 {test1.f1+F2 33 test1.f1+F2 77}}
404 set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
407 } {0 {test1.f1+F2 33 test1.f1+F2 77}}
409 set v [catch {execsql2 {SELECT test1.f1+F2, t1 FROM test1, test2
412 } {0 {test1.f1+F2 33 t1 abc test1.f1+F2 77 t1 abc}}
414 set v [catch {execsql2 {SELECT A.f1, t1 FROM test1 as A, test2
417 } {0 {A.f1 11 t1 abc A.f1 33 t1 abc}}
419 set v [catch {execsql2 {SELECT A.f1, f1 FROM test1 as A, test1 as B
422 } {1 {ambiguous column name: f1}}
424 set v [catch {execsql2 {SELECT A.f1, B.f1 FROM test1 as A, test1 as B
429 set v [catch {execsql2 {SELECT A.f1, f1 FROM test1 as A, test1 as A
432 } {1 {ambiguous column name: A.f1}}
434 set v [catch {execsql2 {SELECT A.f1, B.f1 FROM test1 as A, test1 as B
435 ORDER BY A.f1, B.f1}} msg]
437 } {0 {A.f1 11 B.f1 11 A.f1 11 B.f1 33 A.f1 33 B.f1 11 A.f1 33 B.f1 33}}
440 SELECT f1 FROM test1 UNION SELECT f2 FROM test1
447 SELECT f1 FROM test1 UNION SELECT f2+100 FROM test1
455 SELECT f1 FROM test1 WHERE f2=;
461 SELECT f1 FROM test1 UNION SELECT WHERE;
466 set v [catch {execsql {SELECT f1 FROM test1 as 'hi', test2 as}} msg]
471 SELECT f1 FROM test1 ORDER BY;
477 SELECT f1 FROM test1 ORDER BY f1 desc, f2 where;
483 SELECT count(f1,f2 FROM test1;
489 SELECT count(f1,f2+) FROM test1;
495 SELECT f1 FROM test1 ORDER BY f2, f1+;
501 execsql {SELECT f1 FROM test1 WHERE 4.3+2.4 OR 1 ORDER BY f1}
505 SELECT f1 FROM test1 WHERE ('x' || f1) BETWEEN 'x10' AND 'x20'
506 ORDER BY f1
511 SELECT f1 FROM test1 WHERE 5-3==2
512 ORDER BY f1
517 SELECT coalesce(f1/(f1-11),'x'),
518 coalesce(min(f1/(f1-11),5),'y'),
519 coalesce(max(f1/(f1-33),6),'z')
520 FROM test1 ORDER BY f1
526 FROM test1 ORDER BY f1
536 db eval {SELECT * FROM test1 WHERE f1<0} r {}
542 db eval {SELECT * FROM test1 WHERE f1<0} r {}
544 } {f1 f2}
547 db eval {SELECT * FROM test1 WHERE f1<(select count(*) from test2)} r {}
549 } {f1 f2}
552 db eval {SELECT * FROM test1 ORDER BY f1} r {}
554 } {f1 f2}
557 db eval {SELECT * FROM test1 WHERE f1<0 ORDER BY f1} r {}
559 } {f1 f2}
566 SELECT f1 AS x FROM test1 ORDER BY x
571 SELECT f1 AS x FROM test1 ORDER BY -x
576 SELECT f1-23 AS x FROM test1 ORDER BY abs(x)
581 SELECT f1-23 AS x FROM test1 ORDER BY -abs(x)
586 SELECT f1-22 AS x, f2-22 as y FROM test1
591 SELECT f1-22 AS x, f2-22 as y FROM test1 WHERE x>0 AND y<50