| /external/chromium_org/third_party/sqlite/src/test/ |
| speed1p.explain | 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}
170 # 5000 SELECTs on an integer comparison where the integer is
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...] |
| fuzz2.test | 32 fuzzcatch {SELECT 1 WHERE ( #61 NOT MATCH ROUND( 1 ) )}
48 fuzzcatch {DELETE FROM AAAAAA WHERE #65 NOT NULL}
60 fuzzcatch {DELETE FROM AAAAAA WHERE #202 IS NOT NULL ISNULL}
90 fuzzcatch {SELECT 1 LIMIT ( SELECT DISTINCT * , AAAAAA , * , AAAAAA , "AAAAAA" . * FROM "AAAAAA" ON ROUND( 1 ) COLLATE AAAAAA OR "AAAAAA" USING ( AAAAAA , "AAAAAA" ) WHERE ROUND( 1 ) GROUP BY ORDER BY #84 ASC , #44 DESC , ( SELECT "AAAAAA" . * , "AAAAAA" . * FROM , ( ) "AAAAAA" USING ( )}
93 fuzzcatch {SELECT 1 WHERE 1 == AAAAAA ( * ) BETWEEN + - ~ + "AAAAAA" . AAAAAA | RAISE ( IGNORE ) COLLATE AAAAAA NOT IN ( SELECT DISTINCT "AAAAAA" . * , * , * WHERE ( SELECT ALL AAAAAA AS "AAAAAA" HAVING CAST ( "AAAAAA" . "AAAAAA" . "AAAAAA" AS AAAAAA ) ORDER BY , , IS NULL ASC , ~ AND DESC LIMIT ( ( "AAAAAA" ) NOT BETWEEN ( ) NOT IN ( ) AND AAAAAA ( ) IS NOT NULL ) OFFSET AAAAAA ( ALL , , ) ) GROUP BY ORDER BY "AAAAAA" . AAAAAA ASC , NULL IN ( SELECT UNION ALL SELECT ALL WHERE HAVING ORDER BY LIMIT UNION SELECT DISTINCT FROM ( ) WHERE + HAVING >> ORDER BY LIMIT . . , "AAAAAA" ) , CAST ( ~ "AAAAAA" . AAAAAA AS "AAAAAA" AAAAAA "AAAAAA" ( + 4294967295 , - 4294967296.0 ) ) ASC LIMIT AAAAAA INTERSECT SELECT ALL * GROUP BY , AAAAAA ( DISTINCT , ) != #241 NOT IN ( , , ) , , CTIME_KW HAVING AAAAAA ORDER BY #103 DESC , #81 ASC LIMIT AAAAAA OFFSET ~ AAAAAA ( ALL AAAAAA . AAAAAA >= AAAAAA . "AAAAAA" . "AAAAAA" ) ) NOTNULL NOT NULL}
96 fuzzcatch {SELECT 1 WHERE 1 == AAAAAA ( * ) BETWEEN + - ~ + "AAAAAA" . AAAAAA | RAISE ( IGNORE ) COLLATE AAAAAA NOT IN ( SELECT DISTINCT "AAAAAA" . * , * , * WHERE ( SELECT ALL AAAAAA AS "AAAAAA" HAVING CAST ( "AAAAAA" . "AAAAAA" . "AAAAAA" AS AAAAAA ) ORDER BY (…)
[all...] |
| selectC.test | 28 WHERE y IN ('aaabbb','xxx');
35 WHERE b||c IN ('aaabbb','xxx');
42 WHERE y='aaabbb'
49 WHERE b||c='aaabbb'
56 WHERE x=2
63 WHERE a=2
70 WHERE +y='aaabbb'
93 WHERE y='aaabbb'
101 WHERE b||c='aaabbb'
161 SELECT a FROM t21a WHERE a>new.x UNION AL
[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...] |
| null.test | 109 SELECT sum(b), total(b) FROM t1 WHERE b<0
113 # Check to see how WHERE clauses handle NULL values. A NULL value
114 # is the same as UNKNOWN. The WHERE clause should only select those
119 select a from t1 where b<10
124 select a from t1 where not b>10
129 select a from t1 where b<10 or c=1;
134 select a from t1 where b<10 and c=1;
139 select a from t1 where not (b<10 and c=1);
227 SELECT x FROM t4 WHERE y=NULL;
233 SELECT x FROM t4 WHERE y IN (33,NULL)
[all...] |
| mallocK.test | 12 # This test script checks malloc failures in WHERE clause analysis.
20 set sql {SELECT * FROM t1, t2 WHERE (a=1 OR a=2)}
29 set sql {SELECT * FROM t1 WHERE a GLOB 'xyz*' AND (a=1 OR a=2)}
37 set sql {SELECT * FROM t1 WHERE a BETWEEN 5 AND 10}
45 set sql {SELECT * FROM t1 WHERE b=0}
58 set sql {SELECT * FROM t2 WHERE a MATCH 'xyz'}
|
| tkt-31338dca7e.test | 15 # optimization in joins where the WHERE clause is of the form
34 WHERE (x=111 AND y!=444) OR x=222
43 WHERE (x=111 AND y!=444) OR x=222
61 WHERE (v=111 AND x=w AND z!=999) OR (v=333 AND x=444)
71 WHERE (v=111 AND x=w AND z!=999) OR (v=333 AND x=444)
|
| tkt3346.test | 33 WHERE (SELECT y FROM (SELECT x.b='alice' AS y))=0
39 WHERE (SELECT y FROM (SELECT a||b y FROM t1 WHERE t1.b=x.b))=(x.a||x.b)
45 WHERE (SELECT y FROM (SELECT a||b y FROM t1 WHERE t1.b=x.b))=('2'||x.b)
63 SELECT * FROM (SELECT * FROM t1 WHERE 1=x.a) AS x;
|
| tkt3419.test | 44 select * FROM a, b, c WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
49 select * FROM a, c, b WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
54 select * FROM b, a, c WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
59 select * FROM b, c, a WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
64 select * FROM c, a, b WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
69 select * FROM c, b, a WHERE a.id=2 AND b.a_id = a.id AND b.id=c.b_id;
|
| where9.test | 164 WHERE b IS NULL
173 WHERE +b IS NULL
182 WHERE b IS NULL
191 WHERE b IS NULL
200 WHERE b IS NULL
210 WHERE (b IS NULL AND c NOT NULL AND d NOT NULL)
219 WHERE (b IS NULL AND c NOT NULL AND d NOT NULL)
228 WHERE (b NOT NULL AND c NOT NULL AND d IS NULL)
237 WHERE (b IS NULL AND c NOT NULL AND d NOT NULL)
247 WHERE (b>=950 AND b<=1010) OR (b IS NULL AND c NOT NULL
[all...] |
| select4.test | 49 lsort [execsql {SELECT n FROM t1 WHERE log=3}]
55 SELECT n FROM t1 WHERE log=3
64 SELECT n FROM t1 WHERE log=3
75 SELECT n FROM t1 WHERE log=3
85 SELECT n FROM t1 WHERE log=2
93 SELECT n FROM t1 WHERE log=2;
101 SELECT log FROM t1 WHERE n IN
103 SELECT n FROM t1 WHERE log=3)
112 SELECT n FROM t1 WHERE log=3
124 SELECT n FROM t1 WHERE log=
[all...] |
| fts1o.test | 36 execsql { SELECT tbl_name FROM sqlite_master WHERE type = 'table'}
42 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
45 execsql { SELECT tbl_name FROM sqlite_master WHERE type = 'table'}
57 execsql { SELECT rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
60 execsql { SELECT tbl_name FROM sqlite_master WHERE type = 'table'}
81 execsql { SELECT rowid AS rowid, snippet(fts_t1) FROM fts_t1 WHERE a MATCH 'four'; }
84 execsql { SELECT tbl_name FROM sqlite_master WHERE type = 'table'}
91 execsql { SELECT a, b, c FROM fts_t1 WHERE c MATCH 'four'; }
104 SELECT a, b, c FROM t1 WHERE c MATCH 'two';
119 execsql { SELECT a, b, c FROM aux.t1 WHERE a MATCH 'song';
[all...] |
| select6.test | 56 execsql2 {SELECT * FROM (SELECT x, y FROM t1 WHERE x<2)}
76 WHERE a.y=b.y ORDER BY a.y
84 WHERE a.y=b.y ORDER BY a.y
92 WHERE q=s ORDER BY s
100 WHERE q=s ORDER BY s
112 execsql2 {SELECT * FROM (SELECT a, b FROM t2 WHERE a<2)}
132 WHERE a.b=b.b ORDER BY a.b
140 WHERE a.b=b.b ORDER BY a.b
148 WHERE q=s ORDER BY s
156 WHERE a.q=b.s ORDER BY a.
[all...] |
| analyze2.test | 90 DELETE FROM t1 WHERe x>9;
97 DELETE FROM t1 WHERE x>8;
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 700
155 SELECT * FROM t1 WHERE x BETWEEN -400 AND -300 AND y BETWEEN 100 AND 300
160 SELECT * FROM t1 WHERE x BETWEEN 100 AND 300 AND y BETWEEN -400 AND -30
[all...] |
| /external/chromium_org/third_party/sqlite/src/ext/rtree/ |
| rtree6.test | 59 rtree_strategy {SELECT * FROM t1 WHERE x1>10}
63 rtree_strategy {SELECT * FROM t1 WHERE x1<10}
67 rtree_strategy {SELECT * FROM t1,t2 WHERE k=ii AND x1<10}
71 rtree_strategy {SELECT * FROM t1,t2 WHERE k=+ii AND x1<10}
75 SELECT * FROM t1,t2 WHERE k=+ii AND x1<10
82 SELECT * FROM t1,t2 WHERE k=ii AND x1<10
89 SELECT * FROM t1,t2 WHERE k=ii
96 SELECT * FROM t1,t2 WHERE v=10 and x1<10 and x2>10
103 SELECT * FROM t1,t2 WHERE k=ii AND x1<v
112 SELECT * FROM t3 WHERE
[all...] |
| rtree2.test | 91 set where [list]
101 lappend where "$col $op $val"
103 set where [join $where " AND "]
105 set t1 [execsql "SELECT * FROM t1 WHERE $where ORDER BY ii"]
106 set t2 [execsql "SELECT * FROM t2 WHERE $where ORDER BY ii"]
109 #puts $where
114 #set t1 [execsql "SELECT * FROM t1 WHERE $where ORDER BY ii"
[all...] |
| /external/chromium_org/chrome/browser/history/android/ |
| android_history_provider_service.h | 66 // |selection| is the SQL WHERE clause without 'WHERE'.
67 // |selection_args| is the arguments for WHERE clause.
81 // |selection| is the SQL WHERE clause without 'WHERE'.
82 // |selection_args| is the arguments for the WHERE clause.
93 // |selection| is the SQL WHERE clause without 'WHERE'.
94 // |selection_args| is the arguments for the WHERE clause.
141 // |selection| is the SQL WHERE clause without 'WHERE'
[all...] |
| /external/netperf/ |
| netcpu_pstat.c | 80 fprintf(where,
85 fflush(where);
153 fprintf(where,"pstat_getprocessor failure errno %d\n",errno);
154 fflush(where);
172 fprintf(where, "Calibration for counter run: %d\n",i);
173 fprintf(where,"\tsec = %ld usec = %ld\n",sec,usec);
174 fprintf(where,"\telapsed time = %g\n",elapsed);
187 /* I know that there are situations where compilers know about */
189 fprintf(where,
203 fprintf(where,"\trate[%d] = %g\n",i,rate[i])
[all...] |
| netcpu_ntperf.c | 348 fprintf(where,"ActualDuration (ms): %d\n", duration/10);
353 fprintf(where, "%% CPU _Total");
358 fprintf(where, "\t CPU %i", i);
361 fprintf(where, "\n");
363 fprintf(where, "Busy %5.2f", tot_CPU_Util);
368 fprintf(where, "\t %5.2f",
372 fprintf(where, "\n");
374 fprintf(where, "Kernel %5.2f",
381 fprintf(where, "\t %5.2f",
385 fprintf(where, "\n")
[all...] |
| nettest_xti.c | 167 /* should be directed towards "where." family is generally AF_INET, */
186 fprintf(where,"create_xti_endpoint: attempting to open %s\n",
188 fflush(where);
195 fprintf(where,
200 fflush(where);
205 fprintf(where,"create_xti_endpoint: socket %d obtained...\n",temp_socket);
206 fflush(where);
212 fprintf(where,
215 fflush(where);
220 fprintf(where,
[all...] |
| /libcore/luni/src/test/java/tests/java/sql/ |
| UpdateFunctionalityTest2.java | 127 + " SET id = 4 WHERE id = 3");
141 + " SET id = 5 WHERE id = 1;");
156 + " WHERE name_id = 1;");
158 + " SET id = 5 WHERE id = 1;");
172 + " SET name_id = 6 WHERE name_id = 2");
187 + " SET id = 5 WHERE id = 1;");
190 + DatabaseCreator.FKCASCADE_TABLE + " WHERE name_id = 1;");
194 + DatabaseCreator.FKCASCADE_TABLE + " WHERE name_id = 5;");
212 + " SET name_id = 6 WHERE name_id = 2");
221 * subquery in WHERE claus
[all...] |
| /external/llvm/test/CodeGen/SystemZ/ |
| shift-09.ll | 5 ; Check that we use SLLK over SLL where useful.
15 ; Check that we use SLL over SLLK where possible.
25 ; Check that we use SRLK over SRL where useful.
35 ; Check that we use SRL over SRLK where possible.
45 ; Check that we use SRAK over SRA where useful.
55 ; Check that we use SRA over SRAK where possible.
|
| /external/qemu/distrib/sdl-1.2.15/src/video/maccommon/ |
| SDL_macmouse.c | 117 Point where; local
121 where.h = x;
122 where.v = y;
123 LocalToGlobal(&where);
125 CursorDeviceMoveTo(cursordevice, where.h, where.v);
|
| /external/robolectric/src/main/java/com/xtremelabs/robolectric/util/ |
| SQLite.java | 52 * @param whereClause SQL where clause fragment
67 String where = whereClause; local
69 where = buildWhereClause(whereClause, whereArgs);
71 sb.append(" WHERE ");
72 sb.append(where);
83 * @param whereClause SQL where clause fragment
94 String where = whereClause; local
96 where = buildWhereClause(whereClause, whereArgs);
98 sb.append(" WHERE ");
99 sb.append(where);
[all...] |
| /external/chromium/chrome/common/extensions/docs/examples/apps/background-simple/ |
| README | 4 1. Put index.html and background.html in a directory where the HTTP server
8 pointing to the launch page (index.html) and to the directory where
|
