Searched refs:SELECT (Results 1 - 25 of 103) sorted by relevance

12345

/external/chromium_org/third_party/sqlite/src/test/
H A DcollateA.test34 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
[all...]
H A Dcollate8.test28 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
[all...]
H A Dcollate9.test59 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
[all...]
H A Dcollate2.test25 # 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
[all...]
H A Dboundary4.tcl136 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 rowi
[all...]
H A Dtkt2391.test28 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;
H A Dcollate4.test82 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
[all...]
H A Dcollate1.test74 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 c
[all...]
H A Dcollate5.test14 # 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
[all...]
H A Dcollate6.test60 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
[all...]
H A Dasync2.test82 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;
H A Dcollate7.test58 SELECT * FROM abc16 WHERE a < 'abc';
68 SELECT * FROM abc16 WHERE a < 'abc';
H A Dlaststmtchanges.test298 SELECT changes();
306 SELECT changes();
315 SELECT changes();
320 set nTotalChange [execsql {SELECT total_changes()}]
325 SELECT total_changes();
327 SELECT total_changes();
H A Dtester.tcl422 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)}"
1093 SELECT name, type, sql FROM sqlite_master order by name
1096 SELECT name FROM sqlite_master WHERE type='table' order by name
1098 append txt [$db eval "SELECT * FROM $tbl"]\n
1116 SELECT nam
[all...]
/external/chromium_org/third_party/sqlite/src/src/
H A Dtest8.c67 ** 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 '%%'||?||'%%')",
/external/chromium_org/chrome/browser/resources/print_preview/settings/
H A Dmargin_settings.js33 SELECT: 'margin-settings-select'
71 MarginSettings.Classes_.SELECT)[0];
/external/chromium_org/third_party/sqlite/src/tool/
H A Dmkspeedsql.tcl63 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 * FRO
[all...]
H A Dspace_used.tcl37 SELECT name, type, rootpage FROM sqlite_master
39 SELECT 'sqlite_master', 'table', 2
/external/chromium_org/chrome/browser/resources/print_preview/search/
H A Ddestination_list_item.js57 SELECT: 'print_preview.DestinationListItem.SELECT',
172 * Called when the destination item is activated. Dispatches a SELECT event
191 var selectEvt = new Event(DestinationListItem.EventType.SELECT);
203 var selectEvt = new Event(DestinationListItem.EventType.SELECT);
/external/apache-xml/src/main/java/org/apache/xpath/
H A DCachedXPathAPI.java288 XPath xpath = new XPath(str, null, prefixResolver, XPath.SELECT, null);
329 XPath xpath = new XPath(str, null, prefixResolver, XPath.SELECT, null);
H A DXPathAPI.java236 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/
H A DAVTPartXPath.java104 m_xpath = new XPath(val, null, nsNode, XPath.SELECT, liaison.getErrorListener());
/external/chromium_org/third_party/sqlite/src/ext/rtree/
H A Drtree_perf.tcl62 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/
H A DEvent.idl48 const unsigned short SELECT = 16384;
/external/chromium_org/ui/webui/resources/js/cr/ui/
H A Doverlay.js57 var forbiddenTagNames = /^(A|BUTTON|SELECT|TEXTAREA)$/;

Completed in 4034 milliseconds

12345