| /external/chromium_org/third_party/sqlite/src/test/ |
| select8.test | 14 # unusual combinations SELECT statements.
31 SELECT DISTINCT artist,sum(timesplayed) AS total
38 SELECT DISTINCT artist,sum(timesplayed) AS total
46 SELECT DISTINCT artist,sum(timesplayed) AS total
54 SELECT DISTINCT artist,sum(timesplayed) AS total
|
| tkt-78e04e52ea.test | 25 SELECT * FROM "", t2;
45 EXPLAIN QUERY PLAN SELECT * FROM "" WHERE "" LIKE 'abc%';
51 SELECT name FROM sqlite_master;
58 EXPLAIN QUERY PLAN SELECT * FROM t2 WHERE x=5;
64 EXPLAIN QUERY PLAN SELECT * FROM t2 WHERE x=2;
|
| tkt3442.test | 46 # SELECT referenced in ticket #3442 (both '5000' and "5000")
51 EQP { SELECT node FROM listhash WHERE id='5000' LIMIT 1; }
54 EQP { SELECT node FROM listhash WHERE id="5000" LIMIT 1; }
63 EQP { SELECT node FROM listhash WHERE id=5000 LIMIT 1; }
68 SELECT node FROM listhash WHERE id=[5000] LIMIT 1;
|
| tkt3461.test | 37 execsql { SELECT a, b+1 AS b_plus_one FROM t1 WHERE a=1 }
41 # explain { SELECT a, b+1 AS b_plus_one FROM t1 WHERE a=1 OR b_plus_one }
43 execsql { SELECT a, b+1 AS b_plus_one FROM t1 WHERE a=1 OR b_plus_one }
48 SELECT a, b+1 AS b_plus_one
61 SELECT a, b+1 AS b_plus_one, c, d
|
| tkt3554.test | 37 SELECT RAISE(IGNORE) WHERE EXISTS (
38 SELECT obj FROM test
48 SELECT * FROM test;
57 execsql { SELECT * FROM test }
64 execsql { SELECT * FROM test }
|
| tkt3810.test | 29 SELECT * FROM t1;
41 SELECT * FROM t1;
57 SELECT * FROM t3;
65 execsql {SELECT name FROM sqlite_temp_master ORDER BY name}
81 SELECT name FROM sqlite_temp_master;
|
| tkt3992.test | 36 SELECT * FROM parameters1;
43 SELECT * FROM parameters2;
53 SELECT * FROM t1;
59 SELECT * FROM t1;
71 SELECT tcl('set res', typeof(new.c));
|
| trace.test | 41 SELECT * FROM t1;
46 } {{CREATE TABLE t1(a,b);} {INSERT INTO t1 VALUES(1,2);} {SELECT * FROM t1;}}
79 execsql {SELECT * FROM t1}
83 } {{SELECT * FROM t1}}
111 SELECT * FROM t2;
116 } {{CREATE TABLE t2(a,b);} {INSERT INTO t2 VALUES(1,2);} {SELECT * FROM t2;}}
149 execsql {SELECT * FROM t1}
153 } {{SELECT * FROM t1}}
165 SELECT 'hello';
186 db eval {SELECT x'3031323334' AS x} {set ::t6blob $x
[all...] |
| trans3.test | 28 SELECT * FROM t1;
36 db eval {SELECT * FROM t1 LIMIT 1} {
52 db eval {SELECT * FROM t1}
59 db eval {SELECT * FROM t1} {
73 db eval {SELECT * FROM t1}
|
| insert4.test | 40 CREATE VIEW v2 AS SELECT y, x FROM t2;
55 INSERT INTO t1 SELECT * FROM t2;
61 SELECT * FROM t1;
68 # The SELECT must be against a real table.
72 INSERT INTO t1 SELECT 4, 8;
73 SELECT * FROM t1;
80 INSERT INTO t1 SELECT * FROM v2;
81 SELECT * FROM t1;
92 INSERT INTO t2 SELECT y, x FROM t2;
93 INSERT INTO t3 SELECT * FROM t2 LIMIT 1
[all...] |
| collate9.test | 59 SELECT x FROM xy ORDER BY x
64 SELECT y FROM xy ORDER BY y
69 SELECT x FROM xy ORDER BY x
79 SELECT x FROM xy ORDER BY x
85 SELECT x, x < 'seven' FROM xy ORDER BY x
90 SELECT y, y < 'seven' FROM xy ORDER BY x
95 SELECT y, y COLLATE "reverse sort" < 'seven' FROM xy ORDER BY x
100 SELECT y FROM xy ORDER BY y
105 SELECT y FROM xy ORDER BY y COLLATE "reverse sort"
110 SELECT y COLLATE "reverse sort" AS aaa FROM xy ORDER BY aa
[all...] |
| stat.test | 12 # focus of this file is testing the SELECT statement.
32 SELECT * FROM stat;
39 SELECT * FROM stat;
53 SELECT * FROM stat WHERE name = 't1';
58 SELECT * FROM stat WHERE name = 'i1';
63 SELECT * FROM stat WHERE name = 'sqlite_master';
75 INSERT INTO t3 SELECT a_string(110+rowid), a_string(221+rowid) FROM t3;
76 INSERT INTO t3 SELECT a_string(110+rowid), a_string(221+rowid) FROM t3;
77 INSERT INTO t3 SELECT a_string(110+rowid), a_string(221+rowid) FROM t3;
78 INSERT INTO t3 SELECT a_string(110+rowid), a_string(221+rowid) FROM t3
[all...] |
| tkt3793.test | 46 INSERT INTO t1 SELECT randstr(50,50), randstr(50,50) FROM t1;
47 INSERT INTO t1 SELECT randstr(50,50), randstr(50,50) FROM t1;
48 INSERT INTO t1 SELECT randstr(50,50), randstr(50,50) FROM t1;
49 INSERT INTO t1 SELECT randstr(50,50), randstr(50,50) FROM t1;
50 INSERT INTO t1 SELECT randstr(50,50), randstr(50,50) FROM t1;
51 INSERT INTO t1 SELECT randstr(50,50), randstr(50,50) FROM t1;
52 INSERT INTO t1 SELECT randstr(50,50), randstr(50,50) FROM t1;
53 INSERT INTO t1 SELECT randstr(50,50), randstr(50,50) FROM t1;
54 INSERT INTO t1 SELECT randstr(50,50), randstr(50,50) FROM t1;
55 INSERT INTO t1 SELECT randstr(50,50), randstr(50,50) FROM t1
[all...] |
| misc7.test | 103 INSERT INTO abc SELECT a+2, b, c FROM abc;
121 INSERT INTO abc SELECT a+2, b, c FROM abc;
142 SELECT * FROM sqlite_master;
161 SELECT name FROM aux.sqlite_master;
175 SELECT name FROM aux.sqlite_master;
176 SELECT name FROM aux.sqlite_master;
197 SELECT *
198 FROM (SELECT name+1 AS one FROM sqlite_master LIMIT 1 OFFSET 1)
215 SELECT a FROM t1 WHERE a = 1 ORDER BY b;
223 SELECT t1.a, t2.a FROM t1, t1 AS t2 ORDER BY 2 LIMIT 1
[all...] |
| pagerfault.test | 40 INSERT INTO t1 SELECT a_string(200), a_string(300) FROM t1;
41 INSERT INTO t1 SELECT a_string(200), a_string(300) FROM t1;
43 INSERT INTO t1 SELECT a_string(201), a_string(301) FROM t1;
44 INSERT INTO t1 SELECT a_string(202), a_string(302) FROM t1;
45 INSERT INTO t1 SELECT a_string(203), a_string(303) FROM t1;
46 INSERT INTO t1 SELECT a_string(204), a_string(304) FROM t1;
53 execsql { SELECT count(*) FROM t1 }
57 if {[db one { SELECT count(*) FROM t1 }] != 4} {
81 INSERT INTO abc SELECT * FROM abc; -- 4
82 INSERT INTO abc SELECT * FROM abc; --
[all...] |
| analyze2.test | 74 SELECT * FROM sqlite_stat2;
92 SELECT tbl, idx, group_concat(sample, ' ') FROM sqlite_stat2;
99 SELECT * FROM sqlite_stat2;
106 SELECT * FROM sqlite_stat2;
125 SELECT * FROM t1 WHERE x>500 AND y>700
130 SELECT * FROM t1 WHERE x>700 AND y>500
135 SELECT * FROM t1 WHERE y>700 AND x>500
140 SELECT * FROM t1 WHERE y>500 AND x>700
145 SELECT * FROM t1 WHERE x BETWEEN 100 AND 200 AND y BETWEEN 400 AND 700
150 SELECT * FROM t1 WHERE x BETWEEN 100 AND 500 AND y BETWEEN 400 AND 70
[all...] |
| speed1p.explain | 79 SELECT name FROM sqlite_master ORDER BY 1;
133 db eval {SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr}
136 explain {SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr}
150 db eval {SELECT count(*), avg(b) FROM t1 WHERE c LIKE $pattern}
153 explain {SELECT count(*), avg(b) FROM t1 WHERE c LIKE $pattern}
181 db eval {SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr}
184 explain {SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr}
198 db eval {SELECT c FROM t1 WHERE rowid=$id}
201 explain {SELECT c FROM t1 WHERE rowid=$id}
215 db eval {SELECT c FROM t1 WHERE a=$id
[all...] |
| wal.test | 92 execsql { SELECT * FROM sqlite_master }
104 execsql { SELECT * FROM t1 }
109 execsql { BEGIN; SELECT * FROM t1 } db2
114 execsql { SELECT * FROM t1 }
118 execsql { SELECT * FROM t1 } db2
123 execsql { SELECT * FROM t1 }
127 execsql { SELECT * FROM t1 } db2
131 execsql { COMMIT; SELECT * FROM t1 } db2
136 execsql { SELECT * FROM t1 }
139 execsql { SELECT * FROM t1 } db
[all...] |
| fts2o.test | 35 SELECT rowid, snippet(t1) FROM t1 WHERE c MATCH 'four';
40 SELECT rowid, snippet(t1) FROM t1 WHERE b MATCH 'four';
45 SELECT rowid, snippet(t1) FROM t1 WHERE a MATCH 'four';
53 execsql { SELECT tbl_name FROM sqlite_master WHERE type = 'table'}
59 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
62 execsql { SELECT tbl_name FROM sqlite_master WHERE type = 'table'}
74 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
77 execsql { SELECT tbl_name FROM sqlite_master WHERE type = 'table'}
94 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
97 execsql { SELECT tbl_name FROM sqlite_master WHERE type = 'table'
[all...] |
| boundary3.test | 97 SELECT count(*) FROM t1
103 INSERT INTO t2 SELECT rowid, a FROM t1;
108 SELECT count(*) FROM t2;
113 SELECT t1.* FROM t1, t2 WHERE t1.rowid=72057594037927935 AND t2.a=t1.a
118 SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='00ffffffffffffff'
123 SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=17
128 SELECT t2.a FROM t1 JOIN t2 USING(a)
134 SELECT t2.a FROM t2 NATURAL JOIN t1
140 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r
147 SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.
[all...] |
| where7.test | 49 SELECT * FROM t1;
54 SELECT a FROM t1 WHERE b=3 OR c=6 ORDER BY a
59 SELECT a FROM t1 WHERE b=3 OR +c=6 ORDER BY a
64 SELECT a FROM t1 WHERE +b=3 OR c=6 ORDER BY 1
69 SELECT a FROM t1 WHERE 3=b OR c=6 ORDER BY rowid
74 SELECT a FROM t1 WHERE (3=b OR c=6) AND +a>0 ORDER BY a
79 SELECT a FROM t1 WHERE (b=3 OR c>10)
84 SELECT a FROM t1 WHERE (b=3 OR c>=10)
89 SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4)
94 SELECT a FROM t1 WHERE (b=3 OR c>=10 OR c=4 OR b>10
[all...] |
| /external/eclipse-basebuilder/basebuilder-3.6.2/org.eclipse.releng.basebuilder/plugins/org.apache.ant_1.7.1.v20090120-1145/etc/ |
| jdepend.xsl | 85 <xsl:for-each select="./Packages/Package">
86 <xsl:sort select="@name"/>
87 <li><xsl:value-of select="@name"/></li>
117 <xsl:for-each select="./Packages/Package">
122 <xsl:attribute name="href">#PK<xsl:value-of select="@name"/>
124 <xsl:value-of select="@name"/>
127 <td align="right"><xsl:value-of select="Stats/TotalClasses"/></td>
128 <td align="right"><xsl:value-of select="Stats/AbstractClasses"/></td>
129 <td align="right"><xsl:value-of select="Stats/ConcreteClasses"/></td>
130 <td align="right"><xsl:value-of select="Stats/Ca"/></td
[all...] |
| coverage-frames.xsl | 41 <xsl:param name="output.dir" select="'.'"/>
59 <xsl:apply-templates select="." mode="overview.packages"/>
64 <xsl:apply-templates select="." mode="all.packages"/>
69 <xsl:apply-templates select="." mode="all.classes"/>
73 <xsl:apply-templates select="./package" mode="write"/>
167 <xsl:for-each select="package/class">
168 <xsl:sort select="@name"/>
169 <xsl:variable name="package.name" select="(ancestor::package)[last()]/@name"/>
172 <xsl:value-of select="translate($package.name,'.','/')"/><xsl:text>/</xsl:text>
173 </xsl:if><xsl:value-of select="@name"/><xsl:text>.html</xsl:text
[all...] |
| mmetrics-frames.xsl | 29 <xsl:param name="output.dir" select="'.'"/>
32 <xsl:param name="vg.max" select="10"/>
33 <xsl:param name="loc.max" select="1000"/>
34 <xsl:param name="dit.max" select="10"/>
35 <xsl:param name="noa.max" select="250"/>
36 <xsl:param name="nrm.max" select="50"/>
37 <xsl:param name="nlm.max" select="250"/>
38 <xsl:param name="wmc.max" select="250"/>
39 <xsl:param name="rfc.max" select="50"/>
40 <xsl:param name="dac.max" select="10"/
[all...] |
| /external/chromium_org/third_party/sqlite/src/ext/rtree/ |
| rtreeA.test | 42 set blob [db one {SELECT data FROM t1_node WHERE nodeno=$nodeno}]
49 set blob [db one "SELECT data FROM ${tbl}_node WHERE nodeno=1"]
62 set blob [db one "SELECT data FROM ${tbl}_node WHERE nodeno=$nodeno"]
105 1 "SELECT * FROM t1"
106 2 "SELECT * FROM t1 WHERE rowid=5"
108 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12"
113 1 "SELECT * FROM t1"
114 2 "SELECT * FROM t1 WHERE rowid=5"
116 4 "SELECT * FROM t1 WHERE x1<10 AND x2>12"
126 set nodes [db eval {select nodeno FROM t1_node}
[all...] |
