HomeSort by relevance Sort by last modified time
    Searched refs:NOCASE (Results 1 - 5 of 5) sorted by null

  /external/chromium_org/third_party/sqlite/src/test/
collate4.test 71 CREATE TABLE collate4t1(a COLLATE NOCASE, b COLLATE TEXT);
85 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE NOCASE}
97 cksort {SELECT b FROM collate4t1 ORDER BY b COLLATE NOCASE}
103 a PRIMARY KEY COLLATE NOCASE,
115 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE NOCASE}
127 cksort {SELECT b FROM collate4t2 ORDER BY b COLLATE NOCASE}
134 a COLLATE NOCASE,
146 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE NOCASE}
158 cksort {SELECT b FROM collate4t3 ORDER BY b COLLATE NOCASE}
163 CREATE TABLE collate4t4(a COLLATE NOCASE, b COLLATE TEXT)
    [all...]
colmeta.test 29 CREATE TABLE abc2(a PRIMARY KEY COLLATE NOCASE, b VARCHAR(32), c);
54 5 {{} abc2 a} {0 {{} NOCASE 0 1 0}}
collate6.test 28 # Create a case-insensitive collation type NOCASE for use in testing.
30 db collate NOCASE nocase_collate
32 return [string compare -nocase $a $b]
43 CREATE TABLE collate6tab(a COLLATE NOCASE, b COLLATE BINARY);
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;
collate5.test 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);
269 CREATE TABLE collate5t1(a COLLATE NOCASE, b COLLATE NUMERIC);
collate2.test 48 # NOCASE: NULL aa aA Aa AA ab aB Ab AB ba bA Ba BA bb bB Bb BB
55 # The collation sequences BINARY and NOCASE are built-in, the BACKWARDS
63 b COLLATE NOCASE,
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;
151 SELECT b FROM collate2t1 WHERE b COLLATE nocase > 'aa' ORDER BY +b;
156 SELECT b FROM collate2t1 WHERE c COLLATE nocase > 'aa' ORDER BY +b;

Completed in 790 milliseconds