Home
last modified time | relevance | path

Searched refs:FROM (Results 1 – 25 of 308) sorted by relevance

12345678910>>...13

/titanic_41/usr/src/lib/libsqlite/test/
H A Dlimit.test33 COPY t1 FROM 'data1.txt'
38 execsql {SELECT count(*) FROM t1}
41 execsql {SELECT count(*) FROM t1 LIMIT 5}
44 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
47 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
50 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
53 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
56 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
59 execsql {SELECT x FROM t1 ORDER BY x LIMIT 30, 50}
62 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
[all …]
H A Dselect6.test16 # subqueries in their FROM clause.
48 SELECT DISTINCT y FROM t1 ORDER BY y;
53 execsql2 {SELECT * FROM (SELECT x, y FROM t1 WHERE x<2)}
56 execsql {SELECT count(*) FROM (SELECT y FROM t1)}
59 execsql {SELECT count(*) FROM (SELECT DISTINCT y FROM t1)}
62 execsql {SELECT count(*) FROM (SELECT DISTINCT * FROM (SELECT y FROM t1))}
65 execsql {SELECT count(*) FROM (SELECT * FROM (SELECT DISTINCT y FROM t1))}
71 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
72 (SELECT max(x),y FROM t1 GROUP BY y) as b
79 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
[all …]
H A Dnotnull.test32 SELECT * FROM t1;
37 DELETE FROM t1;
39 SELECT * FROM t1 order by a;
44 DELETE FROM t1;
46 SELECT * FROM t1 order by a;
51 DELETE FROM t1;
53 SELECT * FROM t1 order by a;
58 DELETE FROM t1;
60 SELECT * FROM t1 order by a;
65 DELETE FROM t1;
[all …]
H A Dselect4.test33 COPY t1 FROM 'data1.txt'
38 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
44 lsort [execsql {SELECT DISTINCT log FROM t1}]
47 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
51 SELECT DISTINCT log FROM t1
53 SELECT n FROM t1 WHERE log=3
60 SELECT DISTINCT log FROM t1
62 SELECT n FROM t1 WHERE log=3
64 SELECT * FROM t2;
71 SELECT DISTINCT log FROM t1
[all …]
H A Dminmax.test49 SELECT DISTINCT y FROM t1 ORDER BY y;
55 execsql {SELECT min(x) FROM t1}
62 execsql {SELECT max(x) FROM t1}
70 execsql {SELECT min(x) FROM t1}
77 execsql {SELECT max(x) FROM t1}
84 execsql {SELECT max(y) FROM t1}
93 INSERT INTO t2 SELECT * FROM t1;
96 execsql {SELECT min(a) FROM t2}
103 execsql {SELECT max(a) FROM t2}
110 execsql {INSERT INTO t2 VALUES((SELECT max(a) FROM t2)+1,999)}
[all …]
H A Ddelete.test15 # focus of this file is testing the DELETE FROM statement.
25 set v [catch {execsql {DELETE FROM test1}} msg]
32 set v [catch {execsql {DELETE FROM sqlite_master}} msg]
44 execsql {SELECT * FROM table1 ORDER BY f1}
47 execsql {DELETE FROM table1 WHERE f1=3}
50 execsql {SELECT * FROM table1 ORDER BY f1}
55 execsql {DELETE FROM 'table1' WHERE f1=3}
58 execsql {SELECT * FROM table1 ORDER BY f1}
61 execsql {DELETE FROM table1 WHERE f1=2}
64 execsql {SELECT * FROM table1 ORDER BY f1}
[all …]
H A Dselect1.test25 set v [catch {execsql {SELECT * FROM test1}} msg]
32 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
36 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
46 execsql {SELECT f1 FROM test1}
49 execsql {SELECT f2 FROM test1}
52 execsql {SELECT f2, f1 FROM test1}
55 execsql {SELECT f1, f2 FROM test1}
58 execsql {SELECT * FROM test1}
61 execsql {SELECT *, * FROM test1}
64 execsql {SELECT *, min(f1,f2), max(f1,f2) FROM test1}
[all …]
H A Drowid.test30 SELECT x FROM t1 ORDER BY y;
34 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
44 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
49 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
54 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
59 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
64 set sql "SELECT x FROM t1 WHERE _rowid_==$x2rowid(1)"
72 execsql "SELECT x FROM t1 WHERE rowid=$norow"
76 set v [execsql {SELECT x, oid FROM t1 order by x}]
82 set v [execsql {SELECT x, RowID FROM t1 order by x}]
[all …]
H A Dview.test27 SELECT * FROM t1;
34 CREATE VIEW v1 AS SELECT a,b FROM t1;
35 SELECT * FROM v1 ORDER BY a;
41 SELECT * FROM v1 ORDER BY a;
46 CREATE VIEW v1 AS SELECT a,b FROM t1;
47 SELECT * FROM v1 ORDER BY a;
54 SELECT * FROM v1 ORDER BY a;
60 SELECT * FROM v1 ORDER BY a;
65 CREATE VIEW v1 AS SELECT a,b FROM t1;
66 SELECT * FROM v1 ORDER BY a;
[all …]
H A Dwhere.test36 INSERT INTO t2 SELECT 101-w, x, (SELECT max(y) FROM t1)+1-y, y FROM t1;
58 count {SELECT x, y FROM t1 WHERE w=10}
61 count {SELECT x, y FROM t1 WHERE w=11}
64 count {SELECT x, y FROM t1 WHERE 11=w}
67 count {SELECT x, y FROM t1 WHERE 11=w AND x>2}
70 count {SELECT x, y FROM t1 WHERE y<200 AND w=11 AND x>2}
73 count {SELECT x, y FROM t1 WHERE y<200 AND x>2 AND w=11}
76 count {SELECT x, y FROM t1 WHERE w=11 AND y<200 AND x>2}
79 count {SELECT x, y FROM t1 WHERE w>10 AND y=144 AND x=3}
82 count {SELECT x, y FROM t1 WHERE y=144 AND w>10 AND x=3}
[all …]
H A Dupdate.test45 execsql {SELECT * FROM test1 ORDER BY f1}
69 execsql {SELECT * FROM test1 ORDER BY f1}
76 execsql {SELECT * FROM test1 ORDER BY f1}
82 execsql {SELECT * FROM test1 ORDER BY f1}
91 execsql {SELECT * FROM test1 ORDER BY F1}
98 execsql {SELECT * FROM test1 ORDER BY F1}
106 DELETE FROM test1 WHERE f1<=5;
112 execsql {SELECT * FROM test1 ORDER BY f1,f2}
116 execsql {SELECT * FROM test1 ORDER BY f1,f2}
120 execsql {SELECT * FROM test1 ORDER BY f1,f2}
[all …]
H A Din.test32 COPY t1 FROM 'data1.txt';
35 execsql {SELECT count(*) FROM t1}
41 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
44 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
47 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
50 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
53 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
56 execsql {SELECT a+ 100*(a BETWEEN 1 and 3) FROM t1 ORDER BY b}
63 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
66 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) ORDER BY a}
[all …]
H A Dformat3.test44 COPY t1 FROM 'data.txt'
56 execsql {SELECT count(*) FROM t1}
60 execsql {SELECT n FROM t1 ORDER BY n}
63 execsql {SELECT n FROM t1 ORDER BY n ASC}
66 execsql {SELECT ALL n FROM t1 ORDER BY n ASC}
69 execsql {SELECT n FROM t1 ORDER BY n DESC}
72 execsql {SELECT v FROM t1 ORDER BY v}
75 execsql {SELECT n FROM t1 ORDER BY v}
78 execsql {SELECT n FROM t1 ORDER BY v DESC}
81 execsql {SELECT flt FROM t1 ORDER BY flt}
[all …]
H A Dtemptable.test35 execsql {SELECT * FROM t1}
38 catch {db2 eval {SELECT * FROM sqlite_master}}
39 db2 eval {SELECT * FROM t1}
42 execsql {SELECT name FROM sqlite_master}
45 db2 eval {SELECT name FROM sqlite_master}
56 db2 eval {SELECT * FROM t2}
59 catch {execsql {SELECT * FROM sqlite_master}}
60 catchsql {SELECT * FROM t2}
67 db2 eval {SELECT * FROM t2 ORDER BY x}
70 db2 eval {DELETE FROM t2 WHERE x==8}
[all …]
H A Dsort.test43 COPY t1 FROM 'data.txt'
46 execsql {SELECT count(*) FROM t1}
50 execsql {SELECT n FROM t1 ORDER BY n}
53 execsql {SELECT n FROM t1 ORDER BY n ASC}
56 execsql {SELECT ALL n FROM t1 ORDER BY n ASC}
59 execsql {SELECT n FROM t1 ORDER BY n DESC}
62 execsql {SELECT v FROM t1 ORDER BY v}
65 execsql {SELECT n FROM t1 ORDER BY v}
68 execsql {SELECT n FROM t1 ORDER BY v DESC}
71 execsql {SELECT flt FROM t1 ORDER BY flt}
[all …]
H A Dinsert2.test31 execsql {SELECT * FROM d1 ORDER BY n}
40 INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
47 execsql {SELECT * FROM t1 ORDER BY log}
55 SELECT log, count(*) FROM d1 GROUP BY log
56 EXCEPT SELECT n-1,log FROM d1;
61 SELECT * FROM t1 ORDER BY log;
70 SELECT log, count(*) FROM d1 GROUP BY log
71 INTERSECT SELECT n-1,log FROM d1;
76 SELECT * FROM t1 ORDER BY log;
85 INSERT INTO t1 SELECT log, count() FROM d1 GROUP BY log;
[all …]
H A Dcopy.test58 set v [catch {execsql {COPY test1 FROM 'data1.txt'}} msg]
65 set v [catch {execsql {COPY sqlite_master FROM 'data2.txt'}} msg]
73 execsql {COPY test1 FROM 'data1.txt'}
74 execsql {SELECT * FROM test1 ORDER BY one}
80 execsql {DELETE FROM test1}
81 execsql {COPY test1 FROM 'data2.txt'}
82 execsql {SELECT * FROM test1 ORDER BY one}
88 execsql {DELETE FROM test1}
89 execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS ' | '}
90 execsql {SELECT * FROM test1 ORDER BY one}
[all …]
H A Dmemdb.test38 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
39 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
40 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
41 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
42 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
43 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
44 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
45 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
46 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
48 SELECT count(*) FROM t3;
[all …]
H A Dtrans.test32 SELECT b FROM one ORDER BY a;
41 SELECT b FROM two ORDER BY a;
46 execsql {SELECT b FROM one ORDER BY a} altdb
49 execsql {SELECT b FROM two ORDER BY a} altdb
82 SELECT a FROM one ORDER BY a;
83 SELECT a FROM two ORDER BY a;
94 SELECT a FROM one ORDER BY a;
99 SELECT a FROM two ORDER BY a;
105 SELECT a FROM one ORDER BY a;
117 SELECT a FROM two ORDER BY a;
[all …]
H A Dfunc.test29 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
39 SELECT * FROM t2;
46 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
49 set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
53 set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
57 execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
61 execsql {SELECT coalesce(length(a),-1) FROM t2}
67 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
70 execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
73 execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
[all …]
H A Dintpkey.test37 SELECT name FROM sqlite_master
49 SELECT name FROM sqlite_master
65 SELECT * FROM t1;
70 SELECT rowid, * FROM t1;
85 SELECT rowid, * FROM t1;
99 SELECT rowid, * FROM t1;
109 SELECT b FROM t1 ORDER BY b;
118 SELECT * FROM t1;
127 SELECT * FROM t1 WHERE a==4;
159 execsql {SELECT * FROM t1}
[all …]
H A Dsubselect.test32 execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
38 set v [catch {execsql {SELECT * FROM t1 WHERE a = (SELECT * FROM t1)}} msg]
45 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
48 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
51 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
54 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)}
61 execsql {SELECT b from t1 where a = coalesce((SELECT a FROM t1 WHERE b=5),1)}
76 WHERE x = (SELECT sum(b) FROM t1 where a notnull) - (SELECT sum(a) FROM t1)
84 execsql {DELETE FROM t2 WHERE x < 0.5*(SELECT max(x) FROM t2)}
85 execsql {SELECT x FROM t2 ORDER BY x}
[all …]
H A Djoin.test29 SELECT * FROM t1;
38 SELECT * FROM t2;
44 SELECT * FROM t1 NATURAL JOIN t2;
49 SELECT * FROM t2 NATURAL JOIN t1;
54 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
59 SELECT * FROM t1 INNER JOIN t2 USING(b);
64 SELECT * FROM t1 INNER JOIN t2 USING(c);
69 SELECT * FROM t1 INNER JOIN t2 USING(c,b);
75 SELECT * FROM t1 NATURAL CROSS JOIN t2;
80 SELECT * FROM t1 CROSS JOIN t2 USING(b,c);
[all …]
H A Dselect3.test34 COPY t1 FROM 'data1.txt'
37 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
43 execsql {SELECT count(*) FROM t1}
48 FROM t1
52 execsql {SELECT max(n)/avg(n), max(log)/avg(log) FROM t1}
58 execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
61 execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
64 execsql {SELECT log, avg(n) FROM t1 GROUP BY log ORDER BY log}
67 execsql {SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log}
70 execsql {SELECT log, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
[all …]
/titanic_41/usr/src/uts/common/sys/scsi/adapters/
H A Dscr.ss59 SELECT ATN FROM 0, REL(resel_m)
65 MOVE FROM PASS(NTOFFSET(nt_sendmsg)), WHEN MSG_OUT
108 MOVE FROM PASS(NTOFFSET(nt_errmsg)), WHEN MSG_OUT
125 MOVE FROM PASS(NTOFFSET(nt_errmsg)), WHEN MSG_OUT
143 SELECT ATN FROM 0, REL(resel_m)
148 MOVE FROM PASS(NTOFFSET(nt_sendmsg)), WHEN MSG_OUT
174 MOVE FROM PASS(NTOFFSET(nt_sendmsg)), WHEN MSG_OUT
186 MOVE FROM PASS(NTOFFSET(nt_rcvmsg)), WHEN MSG_IN
206 SELECT FROM 0x00, REL(Next_Inst)
213 MOVE FROM PASS(HBAOFFSET(g_rcvmsg)), WHEN MSG_IN
[all …]

12345678910>>...13