HomeSort by relevance Sort by last modified time
    Searched full:where (Results 476 - 500 of 21198) sorted by null

<<11121314151617181920>>

  /external/chromium_org/third_party/sqlite/src/test/
collate6.test 118 INSERT INTO def SELECT * FROM abc WHERE a < new.a COLLATE nocase;
131 UPDATE abc SET a = 'four' WHERE a = 'one';
133 INSERT INTO def SELECT * FROM abc WHERE a < new.a COLLATE nocase;
143 SELECT 1 FROM sqlite_master WHERE name COLLATE nocase = 'hello';
148 SELECT 1 FROM sqlite_master WHERE 'hello' = name COLLATE nocase;
fts3comp1.test 80 SELECT a, b FROM t1 WHERE docid = 2
83 SELECT a, b FROM t1 WHERE t1 MATCH 'two'
91 SELECT term, documents, occurrences FROM terms WHERE col = '*';
97 DELETE FROM t1 WHERE docid = 1;
98 SELECT term, documents, occurrences FROM terms WHERE col = '*';
misc2.test 85 SELECT t1.b+t2.b AS a, t1.a, t2.a FROM t1, t2 WHERE a==10
95 SELECT a FROM t1 WHERE a>1;
102 SELECT a FROM t1 WHERE a>2147483647;
107 SELECT a FROM t1 WHERE a<2147483648;
112 SELECT a FROM t1 WHERE a<=2147483648;
117 SELECT a FROM t1 WHERE a<10000000000;
122 SELECT a FROM t1 WHERE a<1000000000000 ORDER BY 1;
136 SELECT x1.b AS p, x2.b AS q FROM x AS x1, x AS x2 WHERE x1.a=x2.a;
138 SELECT y1.p, y2.p FROM y AS y1, y AS y2 WHERE y1.q=y2.q;
181 db eval "DELETE FROM t1 WHERE rowid=$rowid
    [all...]
vtab3.test 85 SELECT name FROM sqlite_master WHERE type = 'table';
97 SELECT name FROM sqlite_master WHERE type = 'table';
109 SELECT name FROM sqlite_master WHERE type = 'table';
124 SELECT name FROM sqlite_master WHERE type = 'table';
136 SELECT name FROM sqlite_master WHERE type = 'table';
view.test 97 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
110 UPDATE v2 SET a=10 WHERE a=5;
126 SELECT x FROM v2 WHERE a>10
232 SELECT * FROM v5 AS a, t2 AS b WHERE a.w=b.y;
237 EXPLAIN SELECT * FROM v5 AS a, t2 AS b WHERE a.w=b.y;
242 SELECT * FROM t2 AS b, v5 AS a WHERE a.w=b.y;
247 EXPLAIN SELECT * FROM t2 AS b, v5 AS a WHERE a.w=b.y;
252 SELECT * FROM t1 AS a, v5 AS b, t2 AS c WHERE a.x=b.v AND b.w=c.y;
257 EXPLAIN SELECT * FROM t1 AS a, v5 AS b, t2 AS c WHERE a.x=b.v AND b.w=c.y;
360 SELECT mx+10, pqr FROM v6, v8 WHERE xyz=2
    [all...]
speed4p.test 121 set sql "SELECT * FROM t1, t2, t3 WHERE t1.oid = t2.oid AND t2.oid = t3.oid"
125 set sql "SELECT * FROM t1, t2, t3 WHERE t1.t = t2.t AND t2.t = t3.t"
133 db eval "SELECT * FROM v$t WHERE rowid = \$v"
147 db eval "SELECT t FROM t$t WHERE rowid = \$v"
158 SELECT (SELECT t FROM t1 WHERE rowid = $v),
159 (SELECT t FROM t2 WHERE rowid = $v),
160 (SELECT t FROM t3 WHERE rowid = $v)
172 db eval {UPDATE t1 SET i=i+1 WHERE rowid=$ii}
190 db eval {UPDATE t5 SET i=i+1 WHERE t=$t}
232 UPDATE t4 SET i = $ii2, t = $name WHERE rowid = $ii
    [all...]
insert.test 108 execsql {SELECT * FROM test2 WHERE f1==-111}
112 execsql {SELECT * FROM test2 WHERE f1==77}
154 execsql {SELECT * FROM test2 WHERE f1='111' AND f2=-3.33}
158 execsql {SELECT * FROM test2 WHERE f1='111' AND f2=-3.33}
161 execsql {SELECT * FROM test2 WHERE f1=22 AND f2=-4.44}
200 execsql {INSERT INTO t3 VALUES((SELECT b FROM t3 WHERE a=0),6,7);}
202 set b [execsql {SELECT b FROM t3 WHERE a = 0}]
212 SELECT b,c FROM t3 WHERE a IS NULL;
223 SELECT * FROM t3 WHERE c=99;
260 SELECT rootpage FROM sqlite_master WHERE name='test1'
    [all...]
backcompat.test 19 # windows), where XXX can be any string.
186 # Each test case is named "backcompat-1.X...", where X is either 0 or
303 2 "SELECT rowid FROM t1 WHERE a MATCH 'five'"
304 3 "SELECT * FROM t1 WHERE a MATCH 'five'"
305 4 "SELECT offsets(t1) FROM t1 WHERE t1 MATCH 'jk'"
306 5 "SELECT offsets(t1) FROM t1 WHERE t1 MATCH 'tug* OR eight'"
324 2 "SELECT rowid FROM t1 WHERE a MATCH 'five'"
325 3 "SELECT * FROM t1 WHERE a MATCH 'five'"
326 4 "SELECT offsets(t1) FROM t1 WHERE t1 MATCH 'jk'"
327 5 "SELECT offsets(t1) FROM t1 WHERE t1 MATCH 'tug* OR eight'
    [all...]
fts3corrupt.test 70 SELECT rowid FROM t1 WHERE t1 MATCH 'hello'
87 SELECT rowid FROM t1 WHERE t1 MATCH 'world'
112 SELECT rowid FROM t1 WHERE t1 MATCH 'world';
131 SELECT rowid FROM t1 WHERE t1 MATCH 'world';
134 # Test a special kind of corruption, where the %_stat table contains
153 SELECT matchinfo(t1, 'nxa') FROM t1 WHERE t1 MATCH 't*';
157 SELECT matchinfo(t1, 'nxa') FROM t1 WHERE t1 MATCH 't*';
savepoint2.test 55 DELETE FROM t3 WHERE random()%10!=0;
60 DELETE FROM t3 WHERE random()%10!=0;
62 DELETE FROM t3 WHERE random()%10!=0;
66 UPDATE t3 SET x = randstr(10, 400) WHERE random()%10;
67 INSERT INTO t3 SELECT x FROM t3 WHERE random()%10;
68 DELETE FROM t3 WHERE random()%10;
71 INSERT INTO t3 SELECT randstr(10,400) FROM t3 WHERE (random()%10 == 0);
  /external/chromium_org/v8/src/
assert-scope.h 142 // Scope to document where we do not expect handles to be created.
150 // Scope to document where we do not expect any allocation and GC.
158 // Scope to document where we do not expect any handle dereferences.
166 // Scope to document where we do not expect deferred handles to be dereferenced.
174 // Scope to document where we do not expect deferred handles to be dereferenced.
  /external/clang/lib/Rewrite/Core/
TokenRewriter.cpp 70 TokenRewriter::AddToken(const Token &T, TokenRefTy Where) {
71 Where = TokenList.insert(Where, T);
74 Where)).second;
77 return Where;
  /external/qemu/memcheck/
memcheck_api.h 65 * addr - Virtual address in the guest space where memory is read.
79 * addr - Virtual address in the guest space where memory is written.
96 * pc - Guest address where call has been made.
97 * ret - Guest address where called routine will return.
103 * pc - Guest address where routine has returned.
  /libcore/luni/src/main/java/javax/xml/transform/
SourceLocator.java 23 * This interface is primarily for the purposes of reporting where
58 * Return the line number where the current document event ends.
66 * in the document entity or external parsed entity where the
75 * Return the character position where the current document event ends.
83 * in the document entity or external parsed entity where the
  /ndk/sources/cxx-stl/llvm-libc++/libcxx/test/numerics/rand/rand.eng/rand.eng.lcong/
values.pass.cpp 29 void where(const _Tp &) {} function
43 where(LCE::multiplier);
44 where(LCE::increment);
45 where(LCE::modulus);
46 where(LCE::default_seed);
  /cts/tests/tests/database/src/android/database/sqlite/cts/
SQLiteStatementTest.java 97 mDatabase.compileStatement("UPDATE test set data = 'a' WHERE _id > 0");
108 statement2 = mDatabase.compileStatement("DELETE from test WHERE _id < 4");
154 "SELECT * FROM test WHERE data=\"" + STRING2 + "\"");
170 mDatabase.compileStatement("SELECT num FROM test WHERE str = ?");
194 mDatabase.compileStatement("SELECT str FROM test WHERE num = ?");
225 String sql = "SELECT data FROM blob_test WHERE _id = " + 2;
245 String sql = "SELECT data FROM blob_test WHERE _id = " + i;
254 String sql = "SELECT data FROM blob_test WHERE _id = ?";
264 String sql = "SELECT data FROM blob_test WHERE _id = 100";
284 String sql = "SELECT data FROM blob_test WHERE _id = ?"
    [all...]
  /external/libvpx/libvpx/examples/includes/PHP-Markdown-Extra-1.2.3/
PHP Markdown Extra Readme.text 155 Here is a short non-exhaustive list of some programs and where they
213 * Fix for a bug introduced in Extra 1.2 where block-level HTML tags where
221 * Fixed a problem where abbreviation definitions, footnote
225 * Fixed a bug where characters such as `"` in abbreviation
228 * Fixed a bug where double quotes `"` were not correctly encoded
242 * Fixed a problem where Markdown headers and horizontal rules were
266 * Fixed an issue where an indented code block preceded by a blank
279 * Fixed a problem where `<hr@example.com>` was seen as a horizontal
282 * Fixed an issue where some characters in Markdown-generated HTM
    [all...]
  /packages/apps/Bluetooth/src/com/android/bluetooth/map/
BluetoothMapContent.java 896 String where = ""; local
917 String where = ""; local
938 String where = ""; local
949 String where = ""; local
964 String where = ""; local
985 String where = ""; local
1029 String where = ""; local
1063 String where = ""; local
1082 String where = ""; local
1117 String where = ""; local
1185 String where = setWhereFilter(folder, fi, ap); local
1206 String where = setWhereFilter(folder, fi, ap); local
1241 String where = setWhereFilter(folder, fi, ap); local
1253 String where = setWhereFilter(folder, fi, ap); local
1282 String where = setWhereFilterFolderType(folder, fi); local
1296 String where = setWhereFilterFolderType(folder, fi); local
    [all...]
  /packages/providers/ContactsProvider/tests/assets/test1/
legacy_contacts.sql 122 CREATE TRIGGER contact_cleanup DELETE ON people BEGIN DELETE FROM peopleLookup WHERE source = old._id;DELETE FROM peopleLookupWithPhoneticName WHERE source = old._id;DELETE FROM phones WHERE person = old._id;DELETE FROM contact_methods WHERE person = old._id;DELETE FROM organizations WHERE person = old._id;DELETE FROM groupmembership WHERE person = old._id;DELETE FROM extensions WHERE person = old._id;END;
125 CREATE TRIGGER contact_methods_delete DELETE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
126 CREATE TRIGGER contact_methods_insert INSERT ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=new.person;END;
127 CREATE TRIGGER contact_methods_update UPDATE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END
    [all...]
  /packages/providers/ContactsProvider/tests/assets/testSynced/
legacy_contacts.sql 146 CREATE TRIGGER contact_cleanup DELETE ON people BEGIN DELETE FROM peopleLookup WHERE source = old._id;DELETE FROM peopleLookupWithPhoneticName WHERE source = old._id;DELETE FROM phones WHERE person = old._id;DELETE FROM contact_methods WHERE person = old._id;DELETE FROM organizations WHERE person = old._id;DELETE FROM groupmembership WHERE person = old._id;DELETE FROM extensions WHERE person = old._id;END;
149 CREATE TRIGGER contact_methods_delete DELETE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
150 CREATE TRIGGER contact_methods_insert INSERT ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=new.person;END;
151 CREATE TRIGGER contact_methods_update UPDATE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END
    [all...]
  /development/samples/NotePad/src/com/example/android/notepad/
NotePadProvider.java 260 * Choose the projection and adjust the "where" clause based on URI pattern-matching.
269 * note ID projection, and appends "_ID = <noteID>" to the where clause, so that
312 selection, // The columns for the where clause
313 selectionArgs, // The values for the where clause
428 null, // No WHERE clause, get all matching records
429 null, // Since there is no WHERE clause, no selection criteria
575 * specified by where and whereArgs.
578 * @return If a "where" clause is used, the number of rows affected is returned, otherwise
579 * 0 is returned. To delete all rows and get a row count, use "1" as the where clause.
583 public int delete(Uri uri, String where, String[] whereArgs)
    [all...]
  /external/eclipse-basebuilder/basebuilder-3.6.2/org.eclipse.releng.basebuilder/plugins/org.eclipse.build.tools/scripts_cvs/searchcvs/www/projectName/
searchcvs.php 13 $where = "WHERE `date` >= DATE_SUB(CURDATE(), INTERVAL $days DAY)"; variable
17 array("regex" => "/author: ?(\S+)/", "sql" => "`author` LIKE '%%%s%%'", "sqlpart" => "where"),
18 array("regex" => "/file: ?(\S+)/", "sql" => "`cvsname` LIKE '%%%s%%'", "sqlpart" => "where"),
19 array("regex" => "/days: ?(\d+)/", "sql" => "`date` >= DATE_SUB(CURDATE(), INTERVAL %d DAY)", "sqlpart" => "where"),
20 array("regex" => "/(?:project|module): ?(\S+)/", "sql" => "`project` LIKE '%s'", "sqlpart" => "where"),
21 array("regex" => "/branch: ?(\S+)/", "sql" => "`branch` LIKE '%%%s%%'", "sqlpart" => "having") //is a calculated value, won't work in WHERE
25 $extra = array("where" => array(), "having" => array());
40 $where = "WHERE `bugid` = $regs[1]" variable
50 $where = "WHERE " . ($match ? $match : "1"); variable
    [all...]
  /external/apache-xml/src/main/java/org/apache/xalan/templates/
XUnresolvedVariable.java 43 /** An index to the point in the variable stack where we should
49 /** An index into the variable stack where the variable context
71 * @param varStackPos An index to the point in the variable stack where we should
73 * @param varStackContext An index into the variable stack where the variable context
141 * Set an index to the point in the variable stack where we should
145 * @param top A valid value that specifies where in the variable
154 * Set an index into the variable stack where the variable context
  /external/apache-xml/src/main/java/org/apache/xml/serializer/dom3/
DOMLocatorImpl.java 30 * where an error occured).
46 * The column number where the error occured,
52 * The line number where the error occured,
61 * The URI where the error occured,
134 * The line number where the error occured, or -1 if there is no line
142 * The column number where the error occured, or -1 if there is no column
151 * The URI where the error occured, or null if there is no URI available.
  /external/chromium/chrome/browser/history/
download_database.cc 27 // DownloadState for where this is used.
115 "SET received_bytes=?, state=? WHERE id=?"));
129 "UPDATE downloads SET full_path=? WHERE id=?"));
140 "UPDATE downloads SET state=? WHERE state=?"));
170 "DELETE FROM downloads WHERE id=?"));
181 // downloads where an index by time will give us a lot of benefit.
183 "DELETE FROM downloads WHERE start_time >= ? AND start_time < ? "

Completed in 1231 milliseconds

<<11121314151617181920>>