| /external/chromium_org/third_party/sqlite/src/test/ |
| collate8.test | 23 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
[all...] |
| collate1.test | 23 # collate1-1.* - Single-field ORDER BY with an explicit COLLATE clause.
24 # collate1-2.* - Multi-field ORDER BY with an explicit COLLATE clause.
26 # explict collate type overrides a default collate type.
36 db collate HEX hex_collate
58 db collate numeric numeric_collate
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
[all...] |
| tkt2391.test | 19 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;
|
| collate4.test | 20 db collate TEXT text_collate
71 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
[all...] |
| collate9.test | 24 db collate "reverse sort" reverse_sort
51 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
[all...] |
| collate6.test | 30 db collate NOCASE nocase_collate
43 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;
|
| collateA.test | 25 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, ''<>' '
[all...] |
| collate7.test | 37 CREATE TABLE abc(a COLLATE CASELESS, b, c);
52 CREATE TABLE abc16(a COLLATE CASELESS, b, c);
|
| collate5.test | 32 db collate TEXT [list string compare]
35 db collate numeric numeric_collate
46 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)
[all...] |
| collate2.test | 33 db collate BACKWARDS backwards_collate
62 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
[all...] |
| colmeta.test | 29 CREATE TABLE abc2(a PRIMARY KEY COLLATE NOCASE, b VARCHAR(32), c);
|
| /packages/providers/ContactsProvider/tests/assets/testUnsynced/ |
| legacy_contacts.sql | 33 CREATE TABLE people (_id INTEGER PRIMARY KEY AUTOINCREMENT,_sync_account TEXT,_sync_id TEXT,_sync_time TEXT,_sync_version TEXT,_sync_local_id INTEGER,_sync_dirty INTEGER NOT NULL DEFAULT 0,_sync_mark INTEGER,name TEXT COLLATE LOCALIZED,notes TEXT COLLATE LOCALIZED,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,primary_phone INTEGER REFERENCES phones(_id),primary_organization INTEGER REFERENCES organizations(_id),primary_email INTEGER REFERENCES contact_methods(_id),photo_version TEXT,custom_ringtone TEXT,send_to_voicemail INTEGER,phonetic_name TEXT COLLATE LOCALIZED);
|
| /packages/providers/ContactsProvider/tests/assets/test1/ |
| legacy_contacts.sql | 53 CREATE TABLE people (_id INTEGER PRIMARY KEY AUTOINCREMENT,_sync_account TEXT,_sync_id TEXT,_sync_time TEXT,_sync_version TEXT,_sync_local_id INTEGER,_sync_dirty INTEGER NOT NULL DEFAULT 0,_sync_mark INTEGER,name TEXT COLLATE LOCALIZED,notes TEXT COLLATE LOCALIZED,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,primary_phone INTEGER REFERENCES phones(_id),primary_organization INTEGER REFERENCES organizations(_id),primary_email INTEGER REFERENCES contact_methods(_id),photo_version TEXT,custom_ringtone TEXT,send_to_voicemail INTEGER,phonetic_name TEXT COLLATE LOCALIZED);
|
| /packages/providers/ContactsProvider/tests/assets/testSynced/ |
| legacy_contacts.sql | 43 CREATE TABLE people (_id INTEGER PRIMARY KEY AUTOINCREMENT,_sync_account TEXT,_sync_id TEXT,_sync_time TEXT,_sync_version TEXT,_sync_local_id INTEGER,_sync_dirty INTEGER NOT NULL DEFAULT 0,_sync_mark INTEGER,name TEXT COLLATE LOCALIZED,notes TEXT COLLATE LOCALIZED,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,primary_phone INTEGER REFERENCES phones(_id),primary_organization INTEGER REFERENCES organizations(_id),primary_email INTEGER REFERENCES contact_methods(_id),photo_version TEXT,custom_ringtone TEXT,send_to_voicemail INTEGER,phonetic_name TEXT COLLATE LOCALIZED);
|
| /external/chromium_org/third_party/sqlite/src/src/ |
| parse.y | 230 %left COLLATE.
302 ccons ::= COLLATE ids(C). {sqlite3AddCollateType(pParse, &C);}
782 expr(A) ::= expr(E) COLLATE ids(C). {
[all...] |
| /external/chromium_org/chrome/browser/ui/webui/print_preview/ |
| print_preview_handler.cc | 105 COLLATE,
226 bool collate = false; local
227 if (settings.GetBoolean(printing::kSettingCollate, &collate) && collate)
228 ReportPrintSettingHistogram(COLLATE);
[all...] |
| /build/tools/droiddoc/templates-sac/assets/js/ |
| android_3p-bundle.js | [all...] |
| /build/tools/droiddoc/templates-sdk/assets/js/ |
| android_3p-bundle.js | [all...] |
