/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...] |