| /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 | 49 const unsigned short SELECT = 16384;
|
