Home
last modified time | relevance | path

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

12345678910>>...33

/external/chromium_org/third_party/sqlite/src/test/
Dtkt1473.test30 SELECT * FROM t1
36 SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=0
41 SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=0
46 SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=4
51 SELECT 1 FROM t1 WHERE a=1 UNION SELECT 2 FROM t1 WHERE b=4
56 SELECT 1 FROM t1 WHERE a=0 UNION ALL SELECT 2 FROM t1 WHERE b=4
61 SELECT 1 FROM t1 WHERE a=0 UNION SELECT 2 FROM t1 WHERE b=4
66 SELECT 1 FROM t1 WHERE a=0 UNION ALL SELECT 2 FROM t1 WHERE b=0
71 SELECT 1 FROM t1 WHERE a=0 UNION SELECT 2 FROM t1 WHERE b=0
84 SELECT (SELECT 1 FROM t1 WHERE a=1 UNION ALL SELECT 2 FROM t1 WHERE b=0)
[all …]
DselectB.test71 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
73 SELECT a FROM t1 UNION ALL SELECT d FROM t2
77 SELECT * FROM (SELECT a FROM t1 UNION ALL SELECT d FROM t2) ORDER BY 1
79 SELECT a FROM t1 UNION ALL SELECT d FROM t2 ORDER BY 1
83 SELECT * FROM
84 (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
87 SELECT a FROM t1 WHERE a>10 UNION ALL SELECT d FROM t2 WHERE d>10 ORDER BY 1
91 SELECT * FROM
92 (SELECT a FROM t1 UNION ALL SELECT d FROM t2)
95 SELECT a FROM t1 WHERE a>10
[all …]
Dtkt-38cb5df375.test24 INSERT INTO t1 SELECT a+2 FROM t1;
25 INSERT INTO t1 SELECT a+4 FROM t1;
32 SELECT * FROM (SELECT * FROM t1 ORDER BY a)
33 UNION ALL SELECT 9 FROM (SELECT a FROM t1)
41 SELECT 9 FROM (SELECT * FROM t1)
42 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a)
50 SELECT a FROM (SELECT * FROM t1 ORDER BY a)
51 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a)
59 SELECT 0 FROM (SELECT * FROM t1)
60 UNION ALL SELECT 9 FROM (SELECT a FROM t1)
[all …]
Dtkt2927.test35 SELECT * FROM t1;
42 SELECT a, b FROM t1
44 SELECT a, b FROM t1
50 SELECT a, b FROM t1
52 SELECT a, abs(b) FROM t1
57 SELECT a, b FROM t1
59 SELECT abs(a), b FROM t1
64 SELECT a, b FROM t1
66 SELECT abs(a), abs(b) FROM t1
71 SELECT a, abs(b) FROM t1
[all …]
Dlimit.test35 execsql {SELECT count(*) FROM t1}
38 execsql {SELECT count(*) FROM t1 LIMIT 5}
41 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5}
44 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 2}
47 execsql {SELECT x FROM t1 ORDER BY x+1 LIMIT 5 OFFSET -2}
50 execsql {SELECT x FROM t1 ORDER BY x+1 LIMIT 2, -5}
53 execsql {SELECT x FROM t1 ORDER BY x+1 LIMIT -2, 5}
56 execsql {SELECT x FROM t1 ORDER BY x+1 LIMIT -2, -5}
59 execsql {SELECT x FROM t1 ORDER BY x LIMIT 2, 5}
62 execsql {SELECT x FROM t1 ORDER BY x LIMIT 5 OFFSET 5}
[all …]
Dselect6.test13 # subqueries in their FROM clause.
51 SELECT DISTINCT y FROM t1 ORDER BY y;
56 execsql2 {SELECT * FROM (SELECT x, y FROM t1 WHERE x<2)}
59 execsql {SELECT count(*) FROM (SELECT y FROM t1)}
62 execsql {SELECT count(*) FROM (SELECT DISTINCT y FROM t1)}
65 execsql {SELECT count(*) FROM (SELECT DISTINCT * FROM (SELECT y FROM t1))}
68 execsql {SELECT count(*) FROM (SELECT * FROM (SELECT DISTINCT y FROM t1))}
74 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
75 (SELECT max(x),y FROM t1 GROUP BY y) as b
82 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
[all …]
Dboundary2.test98 SELECT count(*) FROM t1
103 SELECT * FROM t1 WHERE r=72057594037927935
108 SELECT r, a FROM t1 WHERE x='00ffffffffffffff'
113 SELECT r, x FROM t1 WHERE a=17
118 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY a
123 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY a DESC
128 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY r
133 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY r DESC
138 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY x
143 SELECT a FROM t1 WHERE r >= 72057594037927935 ORDER BY a
[all …]
Dboundary1.test97 SELECT count(*) FROM t1
102 SELECT * FROM t1 WHERE rowid=72057594037927935
107 SELECT rowid, a FROM t1 WHERE x='00ffffffffffffff'
112 SELECT rowid, x FROM t1 WHERE a=17
117 SELECT a FROM t1 WHERE rowid > 72057594037927935 ORDER BY a
122 SELECT a FROM t1 WHERE rowid > 72057594037927935 ORDER BY a DESC
127 SELECT a FROM t1 WHERE rowid > 72057594037927935 ORDER BY rowid
132 SELECT a FROM t1 WHERE rowid > 72057594037927935 ORDER BY rowid DESC
137 SELECT a FROM t1 WHERE rowid > 72057594037927935 ORDER BY x
142 SELECT a FROM t1 WHERE rowid >= 72057594037927935 ORDER BY a
[all …]
Dtkt2339.test37 SELECT * FROM (SELECT * FROM t1 ORDER BY num DESC LIMIT 2)
39 SELECT * FROM (SELECT * FROM t2 ORDER BY num DESC LIMIT 2)
44 SELECT * FROM (SELECT * FROM t1 ORDER BY num DESC LIMIT 2)
46 SELECT * FROM (SELECT * FROM t2 ORDER BY num DESC LIMIT 2)
51 SELECT * FROM (SELECT * FROM t1 ORDER BY num DESC)
53 SELECT * FROM (SELECT * FROM t2 ORDER BY num DESC LIMIT 2)
58 SELECT * FROM (SELECT * FROM t1 ORDER BY num DESC LIMIT 2)
60 SELECT * FROM (SELECT * FROM t2 ORDER BY num DESC)
65 SELECT * FROM (SELECT * FROM t1 ORDER BY num DESC LIMIT 2)
67 SELECT * FROM (SELECT * FROM t2 ORDER BY num DESC)
[all …]
Dminmax.test46 SELECT DISTINCT y FROM t1 ORDER BY y;
52 execsql {SELECT min(x) FROM t1}
59 execsql {SELECT max(x) FROM t1}
67 execsql {SELECT min(x) FROM t1}
74 execsql {SELECT max(x) FROM t1}
81 execsql {SELECT max(y) FROM t1}
88 execsql {SELECT min(x) FROM t1 WHERE x=5}
91 execsql {SELECT min(x) FROM t1 WHERE x>=5}
94 execsql {SELECT min(x) FROM t1 WHERE x>=4.5}
97 execsql {SELECT min(x) FROM t1 WHERE x<4.5}
[all …]
Dwhere5.test30 INSERT INTO t2 SELECT * FROM t1;
31 INSERT INTO t3 SELECT * FROM t2;
34 SELECT * FROM t1 WHERE x<0
39 SELECT * FROM t1 WHERE x<=0
44 SELECT * FROM t1 WHERE x=0
49 SELECT * FROM t1 WHERE x>=0
54 SELECT * FROM t1 WHERE x>0
59 SELECT * FROM t1 WHERE x<>0
64 SELECT * FROM t1 WHERE x<NULL
69 SELECT * FROM t1 WHERE x<=NULL
[all …]
Dnotnull.test34 SELECT * FROM t1;
39 DELETE FROM t1;
41 SELECT * FROM t1 order by a;
46 DELETE FROM t1;
48 SELECT * FROM t1 order by a;
53 DELETE FROM t1;
55 SELECT * FROM t1 order by a;
60 DELETE FROM t1;
62 SELECT * FROM t1 order by a;
67 DELETE FROM t1;
[all …]
Dshared4.test78 SELECT a FROM t1 UNION ALL
79 SELECT b FROM t2 UNION ALL
80 SELECT c FROM t3 UNION ALL
81 SELECT d FROM t4;
86 SELECT a FROM t1 UNION ALL
87 SELECT b FROM t2 UNION ALL
88 SELECT d FROM t4 UNION ALL
89 SELECT c FROM t3;
94 SELECT a FROM t1 UNION ALL
95 SELECT c FROM t3 UNION ALL
[all …]
De_delete.test32 1 "DELETE FROM t1" {}
33 2 "DELETE FROM t1 INDEXED BY i1" {}
34 3 "DELETE FROM t1 NOT INDEXED" {}
35 4 "DELETE FROM main.t1" {}
36 5 "DELETE FROM main.t1 INDEXED BY i1" {}
37 6 "DELETE FROM main.t1 NOT INDEXED" {}
38 7 "DELETE FROM t1 WHERE a>2" {}
39 8 "DELETE FROM t1 INDEXED BY i1 WHERE a>2" {}
40 9 "DELETE FROM t1 NOT INDEXED WHERE a>2" {}
41 10 "DELETE FROM main.t1 WHERE a>2" {}
[all …]
Dlike2.test151 SELECT count(*) FROM t1;
157 INSERT INTO t2 SELECT * FROM t1;
159 SELECT count(*) FROM t2;
165 INSERT INTO t3 SELECT x, 'abc' || y || 'xyz' FROM t1;
167 SELECT count(*) FROM t2;
171 db eval "SELECT x FROM t1 WHERE y LIKE ' %'"
174 db eval "SELECT x FROM t2 WHERE y LIKE ' %'"
177 db eval "SELECT x FROM t3 WHERE y LIKE 'abc %'"
180 db eval "SELECT x FROM t1 WHERE y LIKE '!%'"
183 db eval "SELECT x FROM t2 WHERE y LIKE '!%'"
[all …]
Din.test31 SELECT count(*) FROM t1;
38 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
41 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
44 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
47 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
50 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
53 execsql {SELECT a+ 100*(a BETWEEN 1 and 3) FROM t1 ORDER BY b}
68 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
71 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) ORDER BY a}
74 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) OR b=512 ORDER BY a}
[all …]
Dminmax2.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}
111 execsql {INSERT INTO t2 VALUES((SELECT max(a) FROM t2)+1,999)}
[all …]
Dwherelimit.test43 catchsql {DELETE FROM t1 ORDER BY x}
46 catchsql {DELETE FROM t1 WHERE x=1 ORDER BY x}
54 catchsql {DELETE FROM t1 AS a WHERE x=1}
62 catchsql {DELETE FROM t1 WHERE x=1 OFFSET 2}
72 execsql {SELECT count(*) FROM t1}
75 execsql {DELETE FROM t1}
76 execsql {SELECT count(*) FROM t1}
80 execsql {DELETE FROM t1 LIMIT 5}
81 execsql {SELECT count(*) FROM t1}
85 execsql {DELETE FROM t1 ORDER BY x LIMIT 5}
[all …]
Dwhere8.test23 # in the FROM clause.
27 # where8-3.*: Tests with more than one table in the FROM clause.
61 execsql_status2 { SELECT c FROM t1 WHERE a = 1 OR b = 'nine' }
65 execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b = 'two' }
69 execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b GLOB 't*' }
73 execsql_status2 { SELECT c FROM t1 WHERE a > 8 OR b GLOB 'f*' }
77 execsql_status { SELECT c FROM t1 WHERE a = 1 OR b = 'three' ORDER BY rowid }
81 execsql_status { SELECT c FROM t1 WHERE a = 1 OR b = 'three' ORDER BY a }
86 execsql_status2 { SELECT c FROM t1 WHERE a > 1 AND c LIKE 'I%' }
90 execsql_status2 { SELECT c FROM t1 WHERE a >= 9 OR b <= 'eight' }
[all …]
Dview.test30 SELECT * FROM t1;
37 CREATE VIEW IF NOT EXISTS v1 AS SELECT a,b FROM t1;
38 SELECT * FROM v1 ORDER BY a;
44 SELECT * FROM v1 ORDER BY a;
49 CREATE VIEW v1 AS SELECT a,b FROM t1;
50 SELECT * FROM v1 ORDER BY a;
57 SELECT * FROM v1 ORDER BY a;
63 SELECT * FROM v1 ORDER BY a;
68 CREATE VIEW v1 AS SELECT a,b FROM t1;
69 SELECT * FROM v1 ORDER BY a;
[all …]
Dcount.test34 SELECT count(*) FROM sqlite_master;
51 execsql { SELECT count(*) FROM t1 }
58 SELECT count(*) FROM t1;
64 INSERT INTO t1 SELECT * FROM t1; -- 4
65 INSERT INTO t1 SELECT * FROM t1; -- 8
66 INSERT INTO t1 SELECT * FROM t1; -- 16
67 INSERT INTO t1 SELECT * FROM t1; -- 32
68 INSERT INTO t1 SELECT * FROM t1; -- 64
69 INSERT INTO t1 SELECT * FROM t1; -- 128
70 INSERT INTO t1 SELECT * FROM t1; -- 256
[all …]
Dselect4.test40 execsql {SELECT DISTINCT log FROM t1 ORDER BY log}
46 lsort [execsql {SELECT DISTINCT log FROM t1}]
49 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
53 SELECT DISTINCT log FROM t1
55 SELECT n FROM t1 WHERE log=3
62 SELECT DISTINCT log FROM t1
64 SELECT n FROM t1 WHERE log=3
66 SELECT * FROM t2;
73 SELECT DISTINCT log FROM t1
75 SELECT n FROM t1 WHERE log=3
[all …]
De_select.test84 SELECT count(*) FROM t1 %JOIN% t2 ON (t1.a=t2.a)
87 SELECT count(*) FROM t1 %JOIN% t2 USING (a)
90 SELECT count(*) FROM t1 %JOIN% t2
93 SELECT count(*) FROM t1, t2 ON (t1.a=t2.a) USING (a)
96 SELECT count(*) FROM t1, t2 USING (a) ON (t1.a=t2.a)
105 # 0: No FROM clause
106 # 1: Has FROM clause
120 0100.1 "SELECT a, b, a||b FROM t1 " {
123 1100.1 "SELECT DISTINCT a, b, a||b FROM t1 " {
126 1200.1 "SELECT ALL a, b, a||b FROM t1 " {
[all …]
DcollateA.test34 SELECT count(*) FROM t1;
38 execsql {SELECT a FROM t1 WHERE b='abcde '}
41 execsql {SELECT a FROM t1 WHERE c='abcde '}
44 execsql {SELECT a FROM t1 WHERE b='xyzzy'}
47 execsql {SELECT a FROM t1 WHERE c='xyzzy'}
50 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
53 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
56 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
59 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
62 execsql {SELECT a FROM t1 WHERE c='xyzzy '}
[all …]
Dselect1.test22 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 …]

12345678910>>...33