| /external/chromium_org/third_party/sqlite/src/test/ |
| collateA.test | 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 '}
83 execsql {SELECT a FROM t1 WHERE c='xyzz'
[all...] |
| collate8.test | 33 SELECT rowid FROM t1 WHERE a<'ccc' ORDER BY 1
38 SELECT rowid FROM t1 WHERE a<'ccc' COLLATE binary ORDER BY 1
43 SELECT rowid FROM t1 WHERE +a<'ccc' ORDER BY 1
58 SELECT a AS x FROM t1 WHERE x<'ccc' ORDER BY 1
63 SELECT a AS x FROM t1 WHERE x<'ccc' COLLATE binary ORDER BY [x]
68 SELECT a AS x FROM t1 WHERE +x<'ccc' ORDER BY 1
78 # When a result-set column is aliased into a WHERE clause, make sure the
86 SELECT a AS x FROM t2 WHERE x='abc';
91 SELECT a AS x FROM t2 WHERE x='abc' COLLATE nocase;
96 SELECT a AS x FROM t2 WHERE (x COLLATE nocase)='abc'
[all...] |
| tkt2391.test | 28 SELECT count(*) FROM folders WHERE foldername < 'FolderC';
34 SELECT count(*) FROM folders WHERE foldername < 'FolderC' COLLATE nocase;
45 SELECT count(*) FROM folders WHERE foldername < 'FolderC' COLLATE nocase;
|
| collate2.test | 23 # collate2-1.* WHERE <expr> expressions (sqliteExprIfTrue).
24 # collate2-2.* WHERE NOT <expr> expressions (sqliteExprIfFalse).
98 SELECT a FROM collate2t1 WHERE a > 'aa' ORDER BY 1;
103 SELECT a FROM collate2t1 WHERE a COLLATE binary > 'aa' ORDER BY 1;
108 SELECT a FROM collate2t1 WHERE b COLLATE binary > 'aa' ORDER BY 1;
113 SELECT a FROM collate2t1 WHERE c COLLATE binary > 'aa' ORDER BY 1;
118 SELECT b FROM collate2t1 WHERE b > 'aa' ORDER BY 1, oid;
123 SELECT b FROM collate2t1 WHERE a COLLATE nocase > 'aa'
129 SELECT b FROM collate2t1 WHERE b COLLATE nocase > 'aa'
135 SELECT b FROM collate2t1 WHERE c COLLATE nocase > 'aa
[all...] |
| 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;
|
| collate7.test | 58 SELECT * FROM abc16 WHERE a < 'abc';
68 SELECT * FROM abc16 WHERE a < 'abc';
|
| fuzz_common.tcl | 179 {[SelectKw] * FROM [Table] WHERE [Expr $::ColumnList]} \
183 WHERE [Expr $::ColumnList]
188 WHERE [Expr $::ColumnList]
251 WHERE [Expr $::ColumnList]}
258 {DELETE FROM [Table] WHERE [Expr $::ColumnList]}
|
| collate4.test | 49 # collate4-2.* WHERE clauses.
316 # selected or not selected to implement WHERE clauses when user
319 # Indices may optimise WHERE clauses using <, >, <=, >=, = or IN
345 SELECT * FROM collate4t2, collate4t1 WHERE a = b;
353 SELECT * FROM collate4t2, collate4t1 WHERE a = b;
358 SELECT * FROM collate4t2, collate4t1 WHERE b = a;
367 SELECT * FROM collate4t2, collate4t1 WHERE a = b;
372 SELECT * FROM collate4t2, collate4t1 WHERE b = a;
378 SELECT a FROM collate4t1 WHERE a IN (SELECT * FROM collate4t2);
387 SELECT a FROM collate4t1 WHERE a IN (SELECT * FROM collate4t2)
[all...] |
| tester.tcl | 381 # Where switches are:
446 db eval {SELECT tbl_name AS t FROM sqlite_master WHERE type = 'table'} {
981 # where nnnn is a number
[all...] |
| collate5.test | 149 SELECT a FROM collate5t2 EXCEPT select a FROM collate5t1 WHERE a != 'a';
160 where a != 'a';
171 SELECT a FROM collate5t2 INTERSECT select a FROM collate5t1 WHERE a != 'a';
|
| laststmtchanges.test | 50 update t0 set x=3 where x=1;
61 sqlite3_exec_printf db {update t0 set x=4 where x=3; select 1;} {}
67 execsql {update t0 set x=3 where x=4}
69 update t0 set x=x+changes() where x=3;
70 select count() from t0 where x=8;
74 # changes() set properly after update on table where no rows changed
77 update t0 set x=77 where x=88;
85 delete from t0 where x=2;
153 delete from t0 where oid=1 or oid=2;
233 update t0 set x=x*10 where x=1
[all...] |
| /external/chromium_org/third_party/sqlite/src/src/ |
| test8.c | 56 ** where $method is set to the name of the virtual table method to fail
67 ** a query like "SELECT * FROM real_table WHERE col = ?".
339 "SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ?",
755 ** then the echo module handles WHERE or ORDER BY clauses that refer
764 ** SELECT rowid, * FROM <real-table> ?<where-clause>? ?<order-by-clause>?
766 ** where the <where-clause> and <order-by-clause> are determined
774 const char *zSep = "WHERE";
970 string_concat(&z, sqlite3_mprintf(" WHERE rowid=?%d", nData), 1, &rc);
975 z = sqlite3_mprintf("DELETE FROM %Q WHERE rowid = ?1", pVtab->zTableName)
[all...] |
| /packages/providers/ContactsProvider/tests/assets/testUnsynced/ |
| legacy_contacts.sql | 90 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;
93 CREATE TRIGGER contact_methods_delete DELETE ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=old.person;END;
94 CREATE TRIGGER contact_methods_insert INSERT ON contact_methods BEGIN UPDATE people SET _sync_dirty=1 WHERE people._id=new.person;END;
95 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/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...] |
| /external/chromium_org/third_party/sqlite/src/ext/rtree/ |
| rtree_perf.tcl | 62 db eval {SELECT * FROM btree WHERE x1<$x1 AND x2>$x2 AND y1<$y1 AND y2>$y2}
71 db eval {SELECT * FROM rtree WHERE x1<$x1 AND x2>$x2 AND y1<$y1 AND y2>$y2}
|
| viewrtree.tcl | 18 set sql "SELECT parentnode FROM $::O(zTab)_parent WHERE nodeno = $::O(iNode)"
40 WHERE type='table' AND sql LIKE '%virtual%table%using%rtree%'
|
| /external/chromium_org/third_party/sqlite/src/tool/ |
| fragck.tcl | 84 WHERE name=$objname
|
| mkspeedsql.tcl | 95 puts "SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr;"
102 puts "SELECT count(*), avg(b) FROM t1 WHERE c LIKE '%[number_name $i]%';"
115 # 5000 SELECTs on an integer comparison where the integer is
122 puts "SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr;"
129 puts "SELECT c FROM t1 WHERE rowid=$id;"
136 puts "SELECT c FROM t1 WHERE a=$id;"
145 puts "SELECT c FROM t1 WHERE c='$c';"
152 # 5000 updates of ranges where the field being compared is indexed.
158 puts "UPDATE t1 SET b=b*2 WHERE a>=$lwr AND a<$upr;"
167 puts "UPDATE t1 SET b=$r WHERE a=$i;
[all...] |
| spaceanal.tcl | 87 set sql { SELECT name, tbl_name FROM sqlite_master WHERE rootpage>0 }
105 FROM temp.dbstat WHERE name = $name
116 SELECT pageno FROM temp.dbstat WHERE name = $name ORDER BY rowid
200 # the $where clause determines which subset to analyze.
202 proc subreport {title where} {
206 # for the subset of tables/indices identified by the WHERE clause in
207 # $where. Note that even if the WHERE clause matches no rows, the
228 FROM space_used WHERE $where" {} {}
[all...] |
| speedtest.tcl | 156 puts $fd "SELECT count(*), avg(b) FROM t2 WHERE b>=$lwr AND b<$upr;"
165 puts $fd "SELECT count(*), avg(b) FROM t2 WHERE c LIKE '%[number_name $i]%';"
184 puts $fd "SELECT count(*), avg(b) FROM t2 WHERE b>=$lwr AND b<$upr;"
196 puts $fd "UPDATE t1 SET b=b*2 WHERE a>=$lwr AND a<$upr;"
208 puts $fd "UPDATE t2 SET b=$r WHERE a=$i;"
219 puts $fd "UPDATE t2 SET c='[number_name $r]' WHERE a=$i;"
238 puts $fd {DELETE FROM t2 WHERE c LIKE '%fifty%';}
245 puts $fd {DELETE FROM t2 WHERE a>10 AND a<20000;}
|
| /external/eigen/blas/ |
| drotm.f | 14 * (DX**T) , WHERE **T INDICATES TRANSPOSE. THE ELEMENTS OF DX ARE IN
17 * DX(LX+I*INCX), I = 0 TO N-1, WHERE LX = 1 IF INCX .GE. 0, ELSE
|
| srotm.f | 14 * (SX**T) , WHERE **T INDICATES TRANSPOSE. THE ELEMENTS OF SX ARE IN
17 * SX(LX+I*INCX), I = 0 TO N-1, WHERE LX = 1 IF INCX .GE. 0, ELSE
|
| /packages/apps/Bluetooth/src/com/android/bluetooth/opp/ |
| BluetoothOppUtility.java | 137 final String WHERE = BluetoothShare.TIMESTAMP + " == " + timeStamp;
142 }, WHERE, null, BluetoothShare._ID);
|
| /external/sqlite/dist/orig/ |
| shell.c | [all...] |
