OpenGrok
Home
Sort by relevance
Sort by last modified time
Full Search
Definition
Symbol
File Path
History
|
|
Help
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