Home
last modified time | relevance | path

Searched refs:COLLATE (Results 1 – 25 of 57) sorted by relevance

123

/external/chromium_org/third_party/sqlite/src/test/
Dcollate1.test23 # collate1-1.* - Single-field ORDER BY with an explicit COLLATE clause.
24 # collate1-2.* - Multi-field ORDER BY with an explicit COLLATE clause.
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;
[all …]
Dcollate4.test71 CREATE TABLE collate4t1(a COLLATE NOCASE, b COLLATE TEXT);
85 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE NOCASE}
88 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE TEXT}
94 cksort {SELECT b FROM collate4t1 ORDER BY b COLLATE TEXT}
97 cksort {SELECT b FROM collate4t1 ORDER BY b COLLATE NOCASE}
103 a PRIMARY KEY COLLATE NOCASE,
104 b UNIQUE COLLATE TEXT
115 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE NOCASE}
118 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE TEXT}
124 cksort {SELECT b FROM collate4t2 ORDER BY b COLLATE TEXT}
[all …]
Dcollate8.test23 CREATE TABLE t1(a TEXT COLLATE nocase);
38 SELECT rowid FROM t1 WHERE a<'ccc' COLLATE binary ORDER BY 1
63 SELECT a AS x FROM t1 WHERE x<'ccc' COLLATE binary ORDER BY [x]
91 SELECT a AS x FROM t2 WHERE x='abc' COLLATE nocase;
96 SELECT a AS x FROM t2 WHERE (x COLLATE nocase)='abc';
101 SELECT a COLLATE nocase AS x FROM t2 WHERE x='abc';
106 SELECT a COLLATE nocase AS x FROM t2 WHERE (x COLLATE binary)='abc';
111 SELECT a COLLATE nocase AS x FROM t2 WHERE x='abc' COLLATE binary;
116 SELECT * FROM t2 WHERE (a COLLATE nocase)='abc' COLLATE binary;
121 SELECT a COLLATE nocase AS x FROM t2 WHERE 'abc'=x COLLATE binary;
Dcollate3.test50 CREATE INDEX collate3i1 ON collate3t1(c1 COLLATE garbage);
76 CREATE TABLE collate3t1(c1 COLLATE string_compare, c2);
84 SELECT * FROM collate3t1 ORDER BY 1 COLLATE string_compare;
99 CREATE TABLE collate3t2(c1 COLLATE string_compare);
156 SELECT 10 UNION ALL SELECT 20 ORDER BY 1 COLLATE string_compare;
161 SELECT 10 INTERSECT SELECT 20 ORDER BY 1 COLLATE string_compare;
166 SELECT 10 EXCEPT SELECT 20 ORDER BY 1 COLLATE string_compare;
171 SELECT 10 UNION SELECT 20 ORDER BY 1 COLLATE string_compare;
249 SELECT * FROM collate3t1 ORDER BY 1 COLLATE string_compare;
264 CREATE TABLE collate3t2(c1 COLLATE string_compare);
[all …]
DcollateA.test25 b TEXT COLLATE BINARY,
26 c TEXT COLLATE RTRIM
65 execsql {SELECT 'abc123'='abc123 ' COLLATE RTRIM;}
68 execsql {SELECT 'abc123 '='abc123' COLLATE RTRIM;}
71 execsql {SELECT ' '='' COLLATE RTRIM, ' '='' COLLATE BINARY, ' '=''}
74 execsql {SELECT ''=' ' COLLATE RTRIM, ''=' ' COLLATE BINARY, ''=' '}
77 execsql {SELECT ' '=' ' COLLATE RTRIM, ' '=' '}
80 execsql {SELECT ''<>' ' COLLATE RTRIM, ''<>' ' COLLATE BINARY, ''<>' '}
Dcollate9.test51 CREATE TABLE xy(x COLLATE "reverse sort", y COLLATE binary);
95 SELECT y, y COLLATE "reverse sort" < 'seven' FROM xy ORDER BY x
105 SELECT y FROM xy ORDER BY y COLLATE "reverse sort"
110 SELECT y COLLATE "reverse sort" AS aaa FROM xy ORDER BY aaa
116 CREATE INDEX xy_i2 ON xy(y COLLATE "reverse sort");
126 SELECT y FROM xy ORDER BY y COLLATE "reverse sort"
136 SELECT y COLLATE "reverse sort" AS aaa FROM xy ORDER BY aaa
173 SELECT x FROM xy ORDER BY x COLLATE "reverse sort"
Dtkt2391.test19 CREATE TABLE folders(folderid, parentid, foldername COLLATE binary);
34 SELECT count(*) FROM folders WHERE foldername < 'FolderC' COLLATE nocase;
39 # the "COLLATE nocase" clause and use the default collation sequence
45 SELECT count(*) FROM folders WHERE foldername < 'FolderC' COLLATE nocase;
Dminmax3.test233 SELECT max(x COLLATE nocase) FROM t4;
238 SELECT max(x), max(x COLLATE nocase) FROM t4;
243 SELECT max(x COLLATE binary), max(x COLLATE nocase) FROM t4;
248 SELECT max(x COLLATE nocase), max(x COLLATE rtrim) FROM t4;
253 SELECT max(x COLLATE nocase), max(x) FROM t4;
263 SELECT min(x COLLATE nocase) FROM t4;
268 SELECT min(x), min(x COLLATE nocase) FROM t4;
273 SELECT min(x COLLATE binary), min(x COLLATE nocase) FROM t4;
278 SELECT min(x COLLATE nocase), min(x COLLATE rtrim) FROM t4;
283 SELECT min(x COLLATE nocase), min(x) FROM t4;
Dcollate6.test43 CREATE TABLE collate6tab(a COLLATE NOCASE, b COLLATE BINARY);
115 CREATE TABLE abc(a COLLATE binary, b, c);
118 INSERT INTO def SELECT * FROM abc WHERE a < new.a COLLATE nocase;
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;
Dtkt3997.test41 ORDER BY name COLLATE reverse
48 ORDER BY name COLLATE reverse
54 CREATE TABLE mytext2(name COLLATE reverse);
69 ORDER BY name COLLATE usual
Dcollate5.test46 CREATE TABLE collate5t1(a COLLATE nocase, b COLLATE text);
76 CREATE TABLE tkt3376(a COLLATE nocase PRIMARY KEY);
86 CREATE TABLE tkt3376(a COLLATE nocase PRIMARY KEY);
112 CREATE TABLE collate5t2(a COLLATE text, b COLLATE nocase);
233 ORDER BY 1 COLLATE TEXT;
239 CREATE TABLE collate5t_cn(a COLLATE NUMERIC);
240 CREATE TABLE collate5t_ct(a COLLATE TEXT);
269 CREATE TABLE collate5t1(a COLLATE NOCASE, b COLLATE NUMERIC);
De_reindex.test116 CREATE INDEX i1_a ON t1(x COLLATE collA);
117 CREATE INDEX i1_b ON t1(x COLLATE collB);
128 CREATE INDEX i2_a ON t2(x COLLATE collA);
129 CREATE INDEX i2_b ON t2(x COLLATE collB);
133 CREATE INDEX aux.i1_a ON t1(x COLLATE collA);
134 CREATE INDEX aux.i1_b ON t1(x COLLATE collB);
140 set sql "SELECT x FROM $tbl ORDER BY x COLLATE $collation"
272 CREATE INDEX icolla_a ON collA(x COLLATE collA);
273 CREATE INDEX icolla_b ON collA(x COLLATE collB);
Danalyze4.test89 a TEXT COLLATE nocase,
90 b TEXT COLLATE rtrim,
91 c TEXT COLLATE binary
96 CREATE INDEX t2c2 ON t2(c COLLATE nocase);
97 CREATE INDEX t2c3 ON t2(c COLLATE rtrim);
DselectA.test32 CREATE TABLE t1(a,b,c COLLATE NOCASE);
43 CREATE TABLE t2(x,y,z COLLATE NOCASE);
54 CREATE TABLE t3(a,b,c COLLATE NOCASE);
104 ORDER BY b COLLATE NOCASE,a,c
110 ORDER BY b COLLATE NOCASE DESC,a,c
134 ORDER BY c COLLATE BINARY DESC,a,b
164 ORDER BY b COLLATE NOCASE,a,c
170 ORDER BY b COLLATE NOCASE DESC,a,c
194 ORDER BY c COLLATE BINARY DESC,a,b
224 ORDER BY b COLLATE NOCASE,a,c
[all …]
Dreindex.test80 a TEXT PRIMARY KEY COLLATE c1,
81 b TEXT UNIQUE COLLATE c2,
82 c TEXT COLLATE nocase,
83 d TEST COLLATE binary
Dfuzz2.test35 fuzzcatch {SELECT 1 LIMIT NOT #59 COLLATE AAAAAA NOT IN
42 fuzzcatch {SELECT 1 LIMIT NOT #59 COLLATE AAAAAA NOT IN round(1.0)}
90 …TINCT * , AAAAAA , * , AAAAAA , "AAAAAA" . * FROM "AAAAAA" ON ROUND( 1 ) COLLATE AAAAAA OR "AAAAAA…
93 …E 1 == AAAAAA ( * ) BETWEEN + - ~ + "AAAAAA" . AAAAAA | RAISE ( IGNORE ) COLLATE AAAAAA NOT IN ( S…
96 …E 1 == AAAAAA ( * ) BETWEEN + - ~ + "AAAAAA" . AAAAAA | RAISE ( IGNORE ) COLLATE AAAAAA NOT IN ( S…
Dcollate2.test62 a COLLATE BINARY,
63 b COLLATE NOCASE,
64 c COLLATE BACKWARDS
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;
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'
146 SELECT b FROM collate2t1 WHERE a COLLATE nocase > 'aa' ORDER BY +b;
[all …]
Dtkt3493.test129 CREATE TABLE t2(a COLLATE NOCASE, b COLLATE BINARY);
144 execsql { SELECT a>b COLLATE BINARY FROM t2 GROUP BY a, b}
150 execsql { SELECT b>a COLLATE NOCASE FROM t2 GROUP BY a, b}
Denc2.test223 set res [execsql {SELECT * FROM t5 ORDER BY 1 COLLATE test_collate;}]
228 set res [execsql {SELECT * FROM t5 ORDER BY 1 COLLATE test_collate}]
233 set res [execsql {SELECT * FROM t5 ORDER BY 1 COLLATE test_collate}]
253 set res [execsql {SELECT * FROM t5 ORDER BY 1 COLLATE test_collate}]
258 set res [execsql {SELECT * FROM t5 ORDER BY 1 COLLATE test_collate}]
263 set res [execsql {SELECT * FROM t5 ORDER BY 1 COLLATE test_collate}]
283 set res [execsql {SELECT * FROM t5 ORDER BY 1 COLLATE test_collate}]
288 set res [execsql {SELECT * FROM t5 ORDER BY 1 COLLATE test_collate}]
293 set res [execsql {SELECT * FROM t5 ORDER BY 1 COLLATE test_collate}]
301 SELECT * FROM t5 ORDER BY 1 COLLATE test_collate
[all …]
Dcollate7.test37 CREATE TABLE abc(a COLLATE CASELESS, b, c);
52 CREATE TABLE abc16(a COLLATE CASELESS, b, c);
Dlike.test405 CREATE TABLE t2(x TEXT COLLATE NOCASE);
407 CREATE INDEX i2 ON t2(x COLLATE NOCASE);
696 b INTEGER COLLATE nocase UNIQUE,
697 c NUMBER COLLATE nocase UNIQUE,
698 d BLOB COLLATE nocase UNIQUE,
699 e COLLATE nocase UNIQUE,
700 f TEXT COLLATE nocase UNIQUE
788 b TEXT COLLATE nocase,
789 c TEXT COLLATE binary
835 CREATE INDEX t11bnc ON t11(b COLLATE nocase);
[all …]
De_expr.test344 # Run some tests on the COLLATE "unary postfix operator".
362 # EVIDENCE-OF: R-59577-33471 The COLLATE operator is a unary postfix
365 # EVIDENCE-OF: R-23441-22541 The COLLATE operator has a higher
369 do_execsql_test e_expr-9.1 { SELECT 'abcd' < 'bbbb' COLLATE reverse } 0
370 do_execsql_test e_expr-9.2 { SELECT ('abcd' < 'bbbb') COLLATE reverse } 1
371 do_execsql_test e_expr-9.3 { SELECT 'abcd' <= 'bbbb' COLLATE reverse } 0
372 do_execsql_test e_expr-9.4 { SELECT ('abcd' <= 'bbbb') COLLATE reverse } 1
374 do_execsql_test e_expr-9.5 { SELECT 'abcd' > 'bbbb' COLLATE reverse } 1
375 do_execsql_test e_expr-9.6 { SELECT ('abcd' > 'bbbb') COLLATE reverse } 0
376 do_execsql_test e_expr-9.7 { SELECT 'abcd' >= 'bbbb' COLLATE reverse } 1
[all …]
Dutf16align.test40 a TEXT COLLATE utf16_aligned,
41 b TEXT COLLATE utf16_unaligned
Dsort.test327 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE numeric;
332 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE integer;
337 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE text;
342 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE blob;
347 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE clob;
352 # SELECT b FROM t4 UNION SELECT b FROM v4 ORDER BY 1 COLLATE varchar;
/external/wpa_supplicant_8/hs20/server/
Dsql.txt4 sessionid TEXT COLLATE NOCASE,
13 id TEXT COLLATE NOCASE,

123