Home
last modified time | relevance | path

Searched refs:SELECT (Results 1 – 25 of 689) sorted by relevance

12345678910>>...28

/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 …]
Dfunc2.test38 execsql {SELECT 'Supercalifragilisticexpialidocious'}
43 catchsql {SELECT SUBSTR()}
46 catchsql {SELECT SUBSTR('Supercalifragilisticexpialidocious')}
49 catchsql {SELECT SUBSTR('Supercalifragilisticexpialidocious', 1,1,1)}
54 execsql {SELECT SUBSTR('Supercalifragilisticexpialidocious', 0)}
57 execsql {SELECT SUBSTR('Supercalifragilisticexpialidocious', 1)}
60 execsql {SELECT SUBSTR('Supercalifragilisticexpialidocious', 2)}
63 execsql {SELECT SUBSTR('Supercalifragilisticexpialidocious', 30)}
66 execsql {SELECT SUBSTR('Supercalifragilisticexpialidocious', 34)}
69 execsql {SELECT SUBSTR('Supercalifragilisticexpialidocious', 35)}
[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 …]
Dtkt-80e031a00f.test37 do_execsql_test tkt-80e031a00f.1 {SELECT 1 IN ()} 0
38 do_execsql_test tkt-80e031a00f.1b {SELECT 1 IN (2)} 0
39 do_execsql_test tkt-80e031a00f.1c {SELECT 1 IN (2,3,4,5,6,7,8,9)} 0
40 do_execsql_test tkt-80e031a00f.2 {SELECT 1 NOT IN ()} 1
41 do_execsql_test tkt-80e031a00f.2b {SELECT 1 NOT IN (2)} 1
42 do_execsql_test tkt-80e031a00f.2c {SELECT 1 NOT IN (2,3,4,5,6,7,8,9)} 1
43 do_execsql_test tkt-80e031a00f.3 {SELECT null IN ()} 0
44 do_execsql_test tkt-80e031a00f.4 {SELECT null NOT IN ()} 1
47 SELECT 1 IN t1;
49 do_execsql_test tkt-80e031a00f.6 {SELECT 1 NOT IN t1} 1
[all …]
Dlimit.test13 # of SELECT statements.
35 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}
[all …]
Dcast.test29 execsql {SELECT x'616263'}
32 execsql {SELECT typeof(x'616263')}
35 execsql {SELECT CAST(x'616263' AS text)}
38 execsql {SELECT typeof(CAST(x'616263' AS text))}
41 execsql {SELECT CAST(x'616263' AS numeric)}
44 execsql {SELECT typeof(CAST(x'616263' AS numeric))}
47 execsql {SELECT CAST(x'616263' AS blob)}
50 execsql {SELECT typeof(CAST(x'616263' AS blob))}
53 execsql {SELECT CAST(x'616263' AS integer)}
56 execsql {SELECT typeof(CAST(x'616263' AS integer))}
[all …]
Dselect6.test12 # focus of this file is testing SELECT statements that contain
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))}
73 SELECT *
74 FROM (SELECT count(*),y FROM t1 GROUP BY y) AS a,
75 (SELECT max(x),y FROM t1 GROUP BY y) as b
[all …]
Dminmax.test12 # focus of this file is testing SELECT statements that contain
46 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}
[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 …]
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 …]
Dselect4.test13 # in SELECT statements.
40 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
[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 …]
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 …]
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 …]
Dfunc.test25 execsql {SELECT t1 FROM tbl1 ORDER BY t1}
35 SELECT * FROM t2;
42 execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
45 set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
49 set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
53 execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
57 execsql {SELECT coalesce(length(a),-1) FROM t2}
63 execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
66 execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
69 execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
[all …]
Dfuzz.test20 # The most complicated trees are for SELECT statements.
42 SELECT 'abc' LIKE X'ABCD';
47 SELECT 'abc' LIKE zeroblob(10);
52 SELECT zeroblob(10) LIKE 'abc';
57 SELECT (- -21) % NOT (456 LIKE zeroblob(10));
62 SELECT (SELECT (
63 SELECT (SELECT -2147483648) FROM (SELECT 1) ORDER BY 1
69 SELECT 'abc', zeroblob(1) FROM (SELECT 1) ORDER BY 1
71 } [execsql {SELECT 'abc', zeroblob(1)}]
75 SELECT ( SELECT zeroblob(1000) FROM (
[all …]
De_select.test56 # The second argument to this proc must be a SELECT statement that
61 # This test runs the SELECT three times - once with:
68 # and checks that each time the results of the SELECT are $res.
84 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)
101 # 0: SELECT ...
102 # 1: SELECT DISTINCT ...
[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 …]
Dsubselect.test12 # focus of this file is testing SELECT statements that are part of
35 execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
41 set v [catch {execsql {SELECT * FROM t1 WHERE a = (SELECT * FROM t1)}} msg]
43 } {1 {only a single result allowed for a SELECT that is part of an expression}}
48 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
51 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
54 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
57 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)}
62 SELECT b FROM t1
63 WHERE a = (SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY 1);
[all …]
Dminmax2.test12 # focus of this file is testing SELECT statements that contain
49 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}
[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 …]
Dcount.test12 # focus of this file is testing "SELECT count(*)" statements.
34 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
[all …]

12345678910>>...28