HomeSort by relevance Sort by last modified time
    Searched full:select (Results 26 - 50 of 8132) sorted by null

12 3 4 5 6 7 8 91011>>

  /external/chromium_org/third_party/sqlite/src/test/
tkt-38cb5df375.test 24 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
    [all...]
tkt3334.test 31 SELECT * FROM t1 ORDER BY b;
37 SELECT a FROM (SELECT a FROM t1 ORDER BY b LIMIT 2) WHERE a=1;
42 SELECT count(*) FROM (SELECT a FROM t1 ORDER BY b LIMIT 2) WHERE a=1;
47 SELECT a FROM (SELECT a FROM t1 ORDER BY b LIMIT 3) WHERE a=1;
52 SELECT count(*) FROM (SELECT a FROM t1 ORDER BY b LIMIT 3) WHERE a=1;
57 SELECT a FROM (SELECT a FROM t1 ORDER BY b LIMIT 99) WHERE a=1
    [all...]
func.test 25 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...]
count.test 12 # 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; -- 12
    [all...]
select7.test 10 # focus of this file is testing compute SELECT statements and nested
30 select * from t1 where x like 'a__'
31 intersect select * from t1 where x like '_m_'
32 intersect select * from t1 where x like '__x';
47 CREATE VIEW tv1 AS SELECT x.id, tx.id FROM x JOIN tempx tx ON tx.id=x.id;
48 CREATE VIEW tv1b AS SELECT x.id, tx.id FROM x JOIN tempx tx on tx.id=x.id;
49 CREATE VIEW tv2 AS SELECT * FROM tv1 UNION SELECT * FROM tv1b;
50 SELECT * FROM tv2;
65 # SELECT * FROM (SELECT * FROM sqlite_master) GROUP BY nam
    [all...]
selectA.test 13 # The focus of this file is testing the compound-SELECT merge
38 SELECT * FROM t1;
49 SELECT * FROM t2;
55 INSERT INTO t3 SELECT * FROM t1;
56 INSERT INTO t3 SELECT * FROM t2;
57 INSERT INTO t3 SELECT * FROM t1;
58 INSERT INTO t3 SELECT * FROM t2;
59 INSERT INTO t3 SELECT * FROM t1;
60 INSERT INTO t3 SELECT * FROM t2;
61 SELECT count(*) FROM t3
    [all...]
minmax2.test 12 # 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...]
insert5.test 13 # when required by an "INSERT INTO ... SELECT ..." statement.
26 # includes the opcode OpenEphemeral. An "INSERT INTO ... SELECT"
41 CREATE VIEW v1 AS SELECT * FROM B;
42 CREATE VIEW v2 AS SELECT * FROM MAIN;
54 SELECT * FROM B UNION ALL
55 SELECT * FROM MAIN WHERE exists (select * FROM B WHERE B.Id = MAIN.Id);
56 SELECT * FROM B;
62 INSERT INTO B SELECT * FROM B;
64 SELECT * FROM MAIN WHERE exists (select * FROM B WHERE B.Id = MAIN.Id)
    [all...]
minmax.test 12 # 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...]
select1.test 12 # focus of this file is testing the SELECT statement.
19 # Try to select on a non-existant table.
22 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
    [all...]
tokenize.test 21 catchsql {SELECT 1.0e+}
24 catchsql {SELECT 1.0E+}
27 catchsql {SELECT 1.0e-}
30 catchsql {SELECT 1.0E-}
33 catchsql {SELECT 1.0e+/}
36 catchsql {SELECT 1.0E+:}
39 catchsql {SELECT 1.0e-:}
42 catchsql {SELECT 1.0E-/}
45 catchsql {SELECT 1.0F+5}
48 catchsql {SELECT 1.0d-10
    [all...]
select6.test 12 # 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))
    [all...]
insert2.test 13 # result from a SELECT.
20 # Create some tables with data that we can select against
28 execsql {SELECT * FROM d1 ORDER BY n}
40 EXPLAIN INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
44 INSERT INTO t1 SELECT log, count(*) FROM d1 GROUP BY log;
51 execsql {SELECT * FROM t1 ORDER BY log}
60 SELECT log, count(*) FROM d1 GROUP BY log
61 EXCEPT SELECT n-1,log FROM d1;
66 SELECT * FROM t1 ORDER BY log;
75 SELECT log, count(*) FROM d1 GROUP BY lo
    [all...]
view.test 30 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...]
tkt2927.test 35 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 t
    [all...]
randexpr1.test 31 SELECT * FROM t1
36 db eval {SELECT coalesce((select 11 from t1 where 19 in (t1.b,+11,coalesce((select max((abs(17)/abs(t1.f))) from t1 where ((abs(t1.f)/abs(t1.b)) in (select case (min(t1.a | d*d)+(abs(count(*)-count(*)+ -count(*)*max( -t1.c))-max(f))) when -count(distinct 19) then ((count(*))) else max(13) end from t1 union select count(distinct b) from t1)) or 19 in (t1.a,t1.c,17)),17) | 17)),13) FROM t1 WHERE not not c=a-+(select case ~case -~+count(distinct (select count(distinct t1.a)*max(13) from t1))+max( -19*f)*max(f)*max(f)* -count(distinct d)-(count(distinct 11)) | max(t1.f)*count(*) when count(distinct b) then count(distinct t1.b) else -min(t1.f) end*cast(avg(11) AS integer) when max(t1.f) then max(c) else count(*) end from t1)+d}
39 db eval {SELECT coalesce((select 11 from t1 where 19 in (t1.b,+11,coalesce((select max((abs(17)/abs(t1.f))) from t1 where ((abs(t1. (…)
    [all...]
eval.test 28 INSERT INTO t1 SELECT x+2 FROM t1;
29 INSERT INTO t1 SELECT x+4 FROM t1;
30 INSERT INTO t1 SELECT x+8 FROM t1;
31 INSERT INTO t1 SELECT x+16 FROM t1;
32 INSERT INTO t1 SELECT x+32 FROM t1;
33 INSERT INTO t1 SELECT x+64 FROM t1;
34 INSERT INTO t1 SELECT x+128 FROM t1;
35 INSERT INTO t1 SELECT x+256 FROM t1;
36 SELECT count(*), max(x) FROM t1;
41 SELECT x, test_eval('SELECT max(x) FROM t1 WHERE x<' || x) FROM t1 LIMIT
    [all...]
  /external/chromium_org/chrome/browser/resources/sync_file_system_internals/
file_metadata.html 3 <select id="extensions-select"></select>
  /external/chromium_org/third_party/WebKit/ManualTests/
empty-title-popup.html 2 <p>Select the second item on the pop up.
3 <select><option></option><option>Pick me!</option></select></p>
remove-select-onchange.html 1 <p>This test shouldn't crash when you pick something from select, even though it removes itself.
3 <select id="foo" onchange='sel.parentNode.removeChild(sel)'>
6 </select>
select-delete-item.html 3 <title>RenderMenuList::itemStyle Select Element Crash</title>
6 var select = document.getElementById("dropDown");
7 select.removeChild(document.getElementsByTagName("option")[2]);
12 <select id="dropDown" onfocus="setTimeout('removeItem();', 2000);">
16 </select>
18 Once the select gets focus, in 2 seconds it will delete an item. This test passes
19 if you have the select open when it deletes an item, and doesn't crash.</p>
  /external/llvm/test/Transforms/SCCP/
select.ll 1 ; RUN: opt < %s -sccp -S | not grep select
4 %X = select i1 %C, i32 0, i32 0 ; <i32> [#uses=1]
9 %X = select i1 %C, i32 0, i32 undef ; <i32> [#uses=1]
  /prebuilts/python/darwin-x86/2.7.5/lib/python2.7/test/
test_epoll.py 27 import select namespace
31 if not hasattr(select, "epoll"):
35 select.epoll()
70 ep = select.epoll(16)
80 self.assertRaises(TypeError, select.epoll, 1, 2, 3)
81 self.assertRaises(TypeError, select.epoll, 'foo')
82 self.assertRaises(TypeError, select.epoll, None)
83 self.assertRaises(TypeError, select.epoll, ())
84 self.assertRaises(TypeError, select.epoll, ['foo'])
85 self.assertRaises(TypeError, select.epoll, {}
    [all...]
  /prebuilts/python/linux-x86/2.7.5/lib/python2.7/test/
test_epoll.py 27 import select namespace
31 if not hasattr(select, "epoll"):
35 select.epoll()
70 ep = select.epoll(16)
80 self.assertRaises(TypeError, select.epoll, 1, 2, 3)
81 self.assertRaises(TypeError, select.epoll, 'foo')
82 self.assertRaises(TypeError, select.epoll, None)
83 self.assertRaises(TypeError, select.epoll, ())
84 self.assertRaises(TypeError, select.epoll, ['foo'])
85 self.assertRaises(TypeError, select.epoll, {}
    [all...]
  /external/chromium_org/third_party/WebKit/ManualTests/chromium/
select-close-popup-value-change.html 5 <p>Do the following, the test passes if the select keeps the selected value after step 4, fails if the value reverted.</p>
7 <li>1. Click the select to open the popup list.</li>
8 <li>2. Use keyboard to select a value by pressing the first letter of the value.</li>
9 <li>3. Click the select again to close the popup list, it should stay at the value from step 2.</li>
10 <li>4. Click anywhere else on the page to move the focus out of the select.</li>
13 <select>
18 </select>

Completed in 476 milliseconds

12 3 4 5 6 7 8 91011>>