1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
// Aggregation $strcasecmp tests.
t = db.jstests_aggregation_strcasecmp;
t.drop();
t.save({});
function cmp(a, b) {
return t.aggregate({$project: {a: {$cmp: [a, b]}}}).toArray()[0].a;
}
function strcasecmp(a, b) {
return t.aggregate({$project: {a: {$strcasecmp: [a, b]}}}).toArray()[0].a;
}
function assertException(args) {
assert.commandFailed(
t.runCommand('aggregate', {pipeline: [{$project: {a: {$strcasecmp: args}}}]}));
}
function assertStrcasecmp(expected, a, b) {
assert.eq(expected, strcasecmp(a, b));
assert.eq(-expected, strcasecmp(b, a));
}
function assertBoth(expectedStrcasecmp, expectedCmp, a, b) {
assertStrcasecmp(expectedStrcasecmp, a, b);
assert.eq(expectedCmp, cmp(a, b));
assert.eq(-expectedCmp, cmp(b, a));
}
// Wrong number of arguments.
assertException([]);
assertException(['a']);
assertException(['a', 'b', 'c']);
// Basic tests.
assertBoth(0, 0, '', '');
assertBoth(-1, -1, '', 'a');
assertBoth(0, -1, 'A', 'a');
assertBoth(1, -1, 'Ab', 'a');
assertBoth(0, -1, 'Ab', 'aB');
assertBoth(1, -1, 'Bb', 'aB');
assertBoth(-1, -1, 'Bb', 'cB');
assertBoth(1, -1, 'aB', 'aa');
assertBoth(-1, -1, 'aB', 'ac');
// With non alphabet characters.
assertBoth(0, -1, 'A$_b1C?', 'a$_b1C?');
assertBoth(1, -1, 'ABC01234', 'abc0123');
// String coercion.
assertStrcasecmp(0, '1', 1);
assertStrcasecmp(0, '1.23', 1.23);
assertStrcasecmp(0, '1970-01-01T00:00:00', new Date(0));
assertStrcasecmp(0, '1970-01-01t00:00:00', new Date(0));
assertException(['abc', /abc/]);
// Extended characters.
assertBoth(0, -1, '\u0080D\u20ac', '\u0080d\u20ac');
assertBoth(1, 1, 'ó', 'Ó'); // Not treated as equal currently.
// String from field path.
t.drop();
t.save({x: 'abc'});
assertBoth(0, 1, '$x', 'ABC');
|
