/external/chromium_org/third_party/sqlite/src/test/ |
collateA.test | 34 SELECT count(*) FROM t1; 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 ' [all...] |
collate8.test | 28 SELECT a FROM t1 ORDER BY a; 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 48 SELECT a FROM t1 ORDER BY +a 53 SELECT a AS x FROM t1 ORDER BY "x"; 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 73 SELECT a AS x FROM t1 ORDER BY + [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...] |
collate2.test | 25 # collate2-3.* SELECT <expr> expressions (sqliteExprCode). 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' 141 SELECT b FROM collate2t1 WHERE b > 'aa' ORDER BY +b [all...] |
boundary4.tcl | 136 puts " SELECT count(*) FROM t1" 152 maketest 1.3 {SELECT rowid, a, x FROM t1 ORDER BY +rowid} $ans 153 maketest 1.4 {SELECT rowid, a, x FROM t1 ORDER BY rowid} $ans 159 maketest 1.5 {SELECT rowid, a, x FROM t1 ORDER BY +rowid DESC} $ans 160 maketest 1.6 {SELECT rowid, a, x FROM t1 ORDER BY rowid DESC} $ans 167 maketest 1.7 {SELECT rowid, a, x FROM t1 ORDER BY +a} $ans 168 maketest 1.8 {SELECT rowid, a, x FROM t1 ORDER BY a} $ans 175 maketest 1.9 {SELECT rowid, a, x FROM t1 ORDER BY +a DESC} $ans 176 maketest 1.10 {SELECT rowid, a, x FROM t1 ORDER BY a DESC} $ans 183 maketest 1.11 {SELECT rowid, a, x FROM t1 ORDER BY +x} $an [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;
|
collate4.test | 82 cksort {SELECT a FROM collate4t1 ORDER BY a} 85 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE NOCASE} 88 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE TEXT} 91 cksort {SELECT b FROM collate4t1 ORDER BY b} 94 cksort {SELECT b FROM collate4t1 ORDER BY b COLLATE TEXT} 97 cksort {SELECT b FROM collate4t1 ORDER BY b COLLATE NOCASE} 112 cksort {SELECT a FROM collate4t2 ORDER BY a} 115 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE NOCASE} 118 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE TEXT} 121 cksort {SELECT b FROM collate4t2 ORDER BY b [all...] |
collate1.test | 74 SELECT c2 FROM collate1t1 ORDER BY 1; 79 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex; 84 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex DESC; 89 SELECT c2 FROM collate1t1 ORDER BY 1 COLLATE hex ASC; 94 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1 99 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1 ASC 104 SELECT c2 COLLATE hex FROM collate1t1 ORDER BY 1 DESC 126 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE numeric, 2 COLLATE hex; 131 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE binary, 2 COLLATE hex; 136 SELECT c1, c2 FROM collate1t1 ORDER BY 1 COLLATE binary DESC, 2 COLLATE hex [all...] |
collate5.test | 14 # SELECT statements that use user-defined collation sequences. Also 26 # collate5-2.* - Compound SELECT 27 # collate5-3.* - ORDER BY on compound SELECT 58 SELECT DISTINCT a FROM collate5t1; 63 SELECT DISTINCT b FROM collate5t1; 68 SELECT DISTINCT a, b FROM collate5t1; 79 SELECT DISTINCT a FROM tkt3376; 89 SELECT DISTINCT a FROM tkt3376; 94 # The remainder of this file tests compound SELECT statements. 123 SELECT a FROM collate5t1 UNION select a FROM collate5t2 [all...] |
collate6.test | 60 SELECT * FROM collate6log; 66 SELECT * FROM collate6log; 88 SELECT * FROM collate6log; 94 SELECT * FROM collate6log; 118 INSERT INTO def SELECT * FROM abc WHERE a < new.a COLLATE nocase; 126 SELECT * FROM def; 133 INSERT INTO def SELECT * FROM abc WHERE a < new.a COLLATE nocase; 135 SELECT * FROM def; 143 SELECT 1 FROM sqlite_master WHERE name COLLATE nocase = 'hello'; 148 SELECT 1 FROM sqlite_master WHERE 'hello' = name COLLATE nocase [all...] |
async2.test | 82 set c [db one {SELECT c FROM counter LIMIT 1}] 87 SELECT name FROM sqlite_master; 94 SELECT * FROM t1; 99 SELECT * FROM t2; 106 SELECT * FROM t1; 111 SELECT * FROM t2;
|
collate7.test | 58 SELECT * FROM abc16 WHERE a < 'abc'; 68 SELECT * FROM abc16 WHERE a < 'abc';
|
laststmtchanges.test | 43 select changes(), total_changes(); 51 select changes(), total_changes(); 61 sqlite3_exec_printf db {update t0 set x=4 where x=3; select 1;} {} 62 execsql {select changes()} 70 select count() from t0 where x=8; 78 select changes(); 86 select changes(); 114 select changes(); 121 select v1 from t2; 128 select v2 from t2 [all...] |
tester.tcl | 422 error "SELECT test list contains [llength $testlist] elements" 446 db eval {SELECT tbl_name AS t FROM sqlite_master WHERE type = 'table'} { 491 set vers [versdb one {SELECT sqlite_source_id()}] 501 set vers [lindex [versdb one {SELECT sqlite_source_id()}] 0] 841 puts $f {db eval {SELECT * FROM sqlite_master;}} 847 puts $f "db eval {SELECT randomblob($seed)}" [all...] |
/external/chromium_org/third_party/sqlite/src/src/ |
test8.c | 67 ** a query like "SELECT * FROM real_table WHERE col = ?". 167 /* Prepare the statement "SELECT * FROM <tbl>". The column names 168 ** of the result set of the compiled SELECT will be the same as 171 zSql = sqlite3_mprintf("SELECT * FROM %Q", zTab); 339 "SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ?", 764 ** SELECT rowid, * FROM <real-table> ?<where-clause>? ?<order-by-clause>? 802 zQuery = sqlite3_mprintf("SELECT count(*) FROM %Q", pVtab->zTableName); 819 zQuery = sqlite3_mprintf("SELECT rowid, * FROM %Q", pVtab->zTableName); 856 zNew = sqlite3_mprintf(" %s %s LIKE (SELECT '%%'||?||'%%')", [all...] |
/external/chromium_org/third_party/sqlite/src/tool/ |
mkspeedsql.tcl | 63 SELECT name FROM sqlite_master ORDER BY 1; 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]%';" 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';" 193 puts {INSERT INTO t1 SELECT * FROM t2;} 201 puts {INSERT INTO t1 SELECT * FROM t2;} 215 puts {INSERT INTO t1 SELECT * FROM t2; [all...] |
space_used.tcl | 37 SELECT name, type, rootpage FROM sqlite_master 39 SELECT 'sqlite_master', 'table', 2
|
fragck.tcl | 83 SELECT rootpage, type FROM sqlite_master
|
spaceanal.tcl | 69 CREATE TEMP TABLE dbstat AS SELECT * FROM temp.stat ORDER BY name, path; 87 set sql { SELECT name, tbl_name FROM sqlite_master WHERE rootpage>0 } 92 SELECT 116 SELECT pageno FROM temp.dbstat WHERE name = $name ORDER BY rowid 214 SELECT 260 SELECT count(*) FROM ( 261 SELECT DISTINCT tblname FROM space_used WHERE $where AND is_index=0 265 SELECT (sum(leaf_pages+int_pages)-$nTab)/sum(int_pages) FROM space_used 366 set sql {SELECT sum(leaf_pages+int_pages+ovfl_pages) FROM space_used} 377 set ntable [db eval {SELECT count(*)+1 FROM sqlite_master WHERE type='table'} [all...] |
/external/wpa_supplicant_8/hs20/server/www/ |
spp.php | 53 $row = $db->query("SELECT password FROM users " . 56 $row = $db->query("SELECT osu_password FROM users " .
|
/external/apache-xml/src/main/java/org/apache/xpath/ |
CachedXPathAPI.java | 111 * Use an XPath string to select a single node. XPath namespace 128 * Use an XPath string to select a single node. 151 * Use an XPath string to select a nodelist. 167 * Use an XPath string to select a nodelist. 190 * Use an XPath string to select a nodelist. 206 * Use an XPath string to select a nodelist. 288 XPath xpath = new XPath(str, null, prefixResolver, XPath.SELECT, null); 329 XPath xpath = new XPath(str, null, prefixResolver, XPath.SELECT, null);
|
XPathAPI.java | 56 * Use an XPath string to select a single node. XPath namespace 73 * Use an XPath string to select a single node. 96 * Use an XPath string to select a nodelist. 112 * Use an XPath string to select a nodelist. 135 * Use an XPath string to select a nodelist. 151 * Use an XPath string to select a nodelist. 236 XPath xpath = new XPath(str, null, prefixResolver, XPath.SELECT, null); 277 XPath xpath = new XPath(str, null, prefixResolver, XPath.SELECT, null);
|
/external/apache-xml/src/main/java/org/apache/xalan/templates/ |
AVTPartXPath.java | 104 m_xpath = new XPath(val, null, nsNode, XPath.SELECT, liaison.getErrorListener());
|
/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}
|
/external/chromium_org/third_party/WebKit/Source/core/events/ |
Event.idl | 48 const unsigned short SELECT = 16384;
|