Home
last modified time | relevance | path

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

12345678910>>...19

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dlimit.test31 COPY t1 FROM 'data1.txt'
36 execsql {SELECT count(*) FROM t1}
39 execsql {SELECT count(*) FROM t1 LIMIT 5}
42 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
45 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
48 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
51 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
54 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 30}
57 execsql {SELECT x FROM t1 ORDER BY x LIMIT 30, 50}
60 execsql {SELECT x FROM t1 ORDER BY x LIMIT 50 OFFSET 50}
[all …]
H A Dselect6.test14 # subqueries in their FROM clause.
46 SELECT DISTINCT y FROM t1 ORDER BY y;
51 execsql2 {SELECT * FROM (SELECT x, y FROM t1 WHERE x<2)}
54 execsql {SELECT count(*) FROM (SELECT y FROM t1)}
57 execsql {SELECT count(*) FROM (SELECT DISTINCT y FROM t1)}
60 execsql {SELECT count(*) FROM (SELECT DISTINCT * FROM (SELECT y FROM t1))}
63 execsql {SELECT count(*) FROM (SELECT * FROM (SELECT DISTINCT y FROM t1))}
69 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
70 (SELECT max(x),y FROM t1 GROUP BY y) as b
77 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
[all …]
H A Dnotnull.test30 SELECT * FROM t1;
35 DELETE FROM t1;
37 SELECT * FROM t1 order by a;
42 DELETE FROM t1;
44 SELECT * FROM t1 order by a;
49 DELETE FROM t1;
51 SELECT * FROM t1 order by a;
56 DELETE FROM t1;
58 SELECT * FROM t1 order by a;
63 DELETE FROM t1;
[all …]
H A Dselect4.test31 COPY t1 FROM 'data1.txt'
36 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
42 lsort [execsql {SELECT DISTINCT log FROM t1}]
45 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
49 SELECT DISTINCT log FROM t1
51 SELECT n FROM t1 WHERE log=3
58 SELECT DISTINCT log FROM t1
60 SELECT n FROM t1 WHERE log=3
62 SELECT * FROM t2;
69 SELECT DISTINCT log FROM t1
[all …]
H A Ddelete.test13 # focus of this file is testing the DELETE FROM statement.
23 set v [catch {execsql {DELETE FROM test1}} msg]
30 set v [catch {execsql {DELETE FROM sqlite_master}} msg]
42 execsql {SELECT * FROM table1 ORDER BY f1}
45 execsql {DELETE FROM table1 WHERE f1=3}
48 execsql {SELECT * FROM table1 ORDER BY f1}
53 execsql {DELETE FROM 'table1' WHERE f1=3}
56 execsql {SELECT * FROM table1 ORDER BY f1}
59 execsql {DELETE FROM table1 WHERE f1=2}
62 execsql {SELECT * FROM table1 ORDER BY f1}
[all …]
H A Dminmax.test47 SELECT DISTINCT y FROM t1 ORDER BY y;
53 execsql {SELECT min(x) FROM t1}
60 execsql {SELECT max(x) FROM t1}
68 execsql {SELECT min(x) FROM t1}
75 execsql {SELECT max(x) FROM t1}
82 execsql {SELECT max(y) FROM t1}
91 INSERT INTO t2 SELECT * FROM t1;
94 execsql {SELECT min(a) FROM t2}
101 execsql {SELECT max(a) FROM t2}
108 execsql {INSERT INTO t2 VALUES((SELECT max(a) FROM t2)+1,999)}
[all …]
H A Dview.test25 SELECT * FROM t1;
32 CREATE VIEW v1 AS SELECT a,b FROM t1;
33 SELECT * FROM v1 ORDER BY a;
39 SELECT * FROM v1 ORDER BY a;
44 CREATE VIEW v1 AS SELECT a,b FROM t1;
45 SELECT * FROM v1 ORDER BY a;
52 SELECT * FROM v1 ORDER BY a;
58 SELECT * FROM v1 ORDER BY a;
63 CREATE VIEW v1 AS SELECT a,b FROM t1;
64 SELECT * FROM v1 ORDER BY a;
[all …]
H A Dselect1.test23 set v [catch {execsql {SELECT * FROM test1}} msg]
30 set v [catch {execsql {SELECT * FROM test1, test2}} msg]
34 set v [catch {execsql {SELECT * FROM test2, test1}} msg]
44 execsql {SELECT f1 FROM test1}
47 execsql {SELECT f2 FROM test1}
50 execsql {SELECT f2, f1 FROM test1}
53 execsql {SELECT f1, f2 FROM test1}
56 execsql {SELECT * FROM test1}
59 execsql {SELECT *, * FROM test1}
62 execsql {SELECT *, min(f1,f2), max(f1,f2) FROM test1}
[all …]
H A Drowid.test28 SELECT x FROM t1 ORDER BY y;
32 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
42 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
47 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
52 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
57 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
62 set sql "SELECT x FROM t1 WHERE _rowid_==$x2rowid(1)"
70 execsql "SELECT x FROM t1 WHERE rowid=$norow"
74 set v [execsql {SELECT x, oid FROM t1 order by x}]
80 set v [execsql {SELECT x, RowID FROM t1 order by x}]
[all …]
H A Dwhere.test34 INSERT INTO t2 SELECT 101-w, x, (SELECT max(y) FROM t1)+1-y, y FROM t1;
56 count {SELECT x, y FROM t1 WHERE w=10}
59 count {SELECT x, y FROM t1 WHERE w=11}
62 count {SELECT x, y FROM t1 WHERE 11=w}
65 count {SELECT x, y FROM t1 WHERE 11=w AND x>2}
68 count {SELECT x, y FROM t1 WHERE y<200 AND w=11 AND x>2}
71 count {SELECT x, y FROM t1 WHERE y<200 AND x>2 AND w=11}
74 count {SELECT x, y FROM t1 WHERE w=11 AND y<200 AND x>2}
77 count {SELECT x, y FROM t1 WHERE w>10 AND y=144 AND x=3}
80 count {SELECT x, y FROM t1 WHERE y=144 AND w>10 AND x=3}
[all …]
H A Dupdate.test43 execsql {SELECT * FROM test1 ORDER BY f1}
67 execsql {SELECT * FROM test1 ORDER BY f1}
74 execsql {SELECT * FROM test1 ORDER BY f1}
80 execsql {SELECT * FROM test1 ORDER BY f1}
89 execsql {SELECT * FROM test1 ORDER BY F1}
96 execsql {SELECT * FROM test1 ORDER BY F1}
104 DELETE FROM test1 WHERE f1<=5;
110 execsql {SELECT * FROM test1 ORDER BY f1,f2}
114 execsql {SELECT * FROM test1 ORDER BY f1,f2}
118 execsql {SELECT * FROM test1 ORDER BY f1,f2}
[all …]
H A Din.test30 COPY t1 FROM 'data1.txt';
33 execsql {SELECT count(*) FROM t1}
39 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
42 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
45 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
48 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
51 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
54 execsql {SELECT a+ 100*(a BETWEEN 1 and 3) FROM t1 ORDER BY b}
61 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
64 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) ORDER BY a}
[all …]
H A Dformat3.test42 COPY t1 FROM 'data.txt'
54 execsql {SELECT count(*) FROM t1}
58 execsql {SELECT n FROM t1 ORDER BY n}
61 execsql {SELECT n FROM t1 ORDER BY n ASC}
64 execsql {SELECT ALL n FROM t1 ORDER BY n ASC}
67 execsql {SELECT n FROM t1 ORDER BY n DESC}
70 execsql {SELECT v FROM t1 ORDER BY v}
73 execsql {SELECT n FROM t1 ORDER BY v}
76 execsql {SELECT n FROM t1 ORDER BY v DESC}
79 execsql {SELECT flt FROM t1 ORDER BY flt}
[all …]
H A Dtemptable.test33 execsql {SELECT * FROM t1}
36 catch {db2 eval {SELECT * FROM sqlite_master}}
37 db2 eval {SELECT * FROM t1}
40 execsql {SELECT name FROM sqlite_master}
43 db2 eval {SELECT name FROM sqlite_master}
54 db2 eval {SELECT * FROM t2}
57 catch {execsql {SELECT * FROM sqlite_master}}
58 catchsql {SELECT * FROM t2}
65 db2 eval {SELECT * FROM t2 ORDER BY x}
68 db2 eval {DELETE FROM t2 WHERE x==8}
[all …]
H A Dsort.test41 COPY t1 FROM 'data.txt'
44 execsql {SELECT count(*) FROM t1}
48 execsql {SELECT n FROM t1 ORDER BY n}
51 execsql {SELECT n FROM t1 ORDER BY n ASC}
54 execsql {SELECT ALL n FROM t1 ORDER BY n ASC}
57 execsql {SELECT n FROM t1 ORDER BY n DESC}
60 execsql {SELECT v FROM t1 ORDER BY v}
63 execsql {SELECT n FROM t1 ORDER BY v}
66 execsql {SELECT n FROM t1 ORDER BY v DESC}
69 execsql {SELECT flt FROM t1 ORDER BY flt}
[all …]
H A Dinsert2.test29 execsql {SELECT * FROM d1 ORDER BY n}
38 INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
45 execsql {SELECT * FROM t1 ORDER BY log}
53 SELECT log, count(*) FROM d1 GROUP BY log
54 EXCEPT SELECT n-1,log FROM d1;
59 SELECT * FROM t1 ORDER BY log;
68 SELECT log, count(*) FROM d1 GROUP BY log
69 INTERSECT SELECT n-1,log FROM d1;
74 SELECT * FROM t1 ORDER BY log;
83 INSERT INTO t1 SELECT log, count() FROM d1 GROUP BY log;
[all …]
H A Dcopy.test56 set v [catch {execsql {COPY test1 FROM 'data1.txt'}} msg]
63 set v [catch {execsql {COPY sqlite_master FROM 'data2.txt'}} msg]
71 execsql {COPY test1 FROM 'data1.txt'}
72 execsql {SELECT * FROM test1 ORDER BY one}
78 execsql {DELETE FROM test1}
79 execsql {COPY test1 FROM 'data2.txt'}
80 execsql {SELECT * FROM test1 ORDER BY one}
86 execsql {DELETE FROM test1}
87 execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS ' | '}
88 execsql {SELECT * FROM test1 ORDER BY one}
[all …]
H A Dmemdb.test36 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
37 INSERT INTO t3 SELECT randstr(10,400) FROM t3;
38 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;
46 SELECT count(*) FROM t3;
[all …]
H A Dtrans.test30 SELECT b FROM one ORDER BY a;
39 SELECT b FROM two ORDER BY a;
44 execsql {SELECT b FROM one ORDER BY a} altdb
47 execsql {SELECT b FROM two ORDER BY a} altdb
80 SELECT a FROM one ORDER BY a;
81 SELECT a FROM two ORDER BY a;
92 SELECT a FROM one ORDER BY a;
97 SELECT a FROM two ORDER BY a;
103 SELECT a FROM one ORDER BY a;
115 SELECT a FROM two ORDER BY a;
[all …]
H A Dfunc.test27 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
37 SELECT * FROM t2;
44 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
47 set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
51 set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
55 execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
59 execsql {SELECT coalesce(length(a),-1) FROM t2}
65 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
68 execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
71 execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
[all …]
H A Djoin.test27 SELECT * FROM t1;
36 SELECT * FROM t2;
42 SELECT * FROM t1 NATURAL JOIN t2;
47 SELECT * FROM t2 NATURAL JOIN t1;
52 SELECT * FROM t1 INNER JOIN t2 USING(b,c);
57 SELECT * FROM t1 INNER JOIN t2 USING(b);
62 SELECT * FROM t1 INNER JOIN t2 USING(c);
67 SELECT * FROM t1 INNER JOIN t2 USING(c,b);
73 SELECT * FROM t1 NATURAL CROSS JOIN t2;
78 SELECT * FROM t1 CROSS JOIN t2 USING(b,c);
[all …]
H A Dintpkey.test35 SELECT name FROM sqlite_master
47 SELECT name FROM sqlite_master
63 SELECT * FROM t1;
68 SELECT rowid, * FROM t1;
83 SELECT rowid, * FROM t1;
97 SELECT rowid, * FROM t1;
107 SELECT b FROM t1 ORDER BY b;
116 SELECT * FROM t1;
125 SELECT * FROM t1 WHERE a==4;
157 execsql {SELECT * FROM t1}
[all …]
H A Dsubselect.test30 execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
36 set v [catch {execsql {SELECT * FROM t1 WHERE a = (SELECT * FROM t1)}} msg]
43 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
46 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
49 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
52 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)}
59 execsql {SELECT b from t1 where a = coalesce((SELECT a FROM t1 WHERE b=5),1)}
74 WHERE x = (SELECT sum(b) FROM t1 where a notnull) - (SELECT sum(a) FROM t1)
82 execsql {DELETE FROM t2 WHERE x < 0.5*(SELECT max(x) FROM t2)}
83 execsql {SELECT x FROM t2 ORDER BY x}
[all …]
H A Dselect3.test32 COPY t1 FROM 'data1.txt'
35 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
41 execsql {SELECT count(*) FROM t1}
46 FROM t1
50 execsql {SELECT max(n)/avg(n), max(log)/avg(log) FROM t1}
56 execsql {SELECT log, count(*) FROM t1 GROUP BY log ORDER BY log}
59 execsql {SELECT log, min(n) FROM t1 GROUP BY log ORDER BY log}
62 execsql {SELECT log, avg(n) FROM t1 GROUP BY log ORDER BY log}
65 execsql {SELECT log, avg(n)+1 FROM t1 GROUP BY log ORDER BY log}
68 execsql {SELECT log, avg(n)-min(n) FROM t1 GROUP BY log ORDER BY log}
[all …]
/illumos-gate/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>>...19