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
67
68
69
70
|
// Tests finding NumberDecimal from the shell in mixed collections.
(function() {
"use strict";
var col = db.decimal_find_mixed;
col.drop();
// Insert some sample data.
assert.commandWorked(col.insert([
{"a": -1},
{"a": NumberDecimal("-1")},
{"a": NumberLong("-1")},
{"a": NumberInt("-1")},
{"a": -0.3},
{"a": NumberDecimal("-0.3")},
{"a": -0.1},
{"a": NumberDecimal("-0.1")},
{"a": NumberDecimal("0")},
{"a": 0},
{"a": NumberDecimal("-0")},
{"a": NumberDecimal("0.00")},
{"a": NumberDecimal("0.1")},
{"a": 0.1},
{"a": NumberDecimal("0.3")},
{"a": 0.3},
{"a": NumberDecimal("0.5")},
{"a": 0.5},
{"a": NumberDecimal("1.0")},
{"a": NumberLong("1")},
{"a": NumberDecimal("1.00")},
{"a": NumberDecimal("2.00")},
{"a": NumberDecimal("12345678901234567890.12345678901234")},
{"a": NumberDecimal("NaN")},
{"a": NumberDecimal("-NaN")},
{"a": NaN},
{"a": NumberDecimal("Infinity")},
{"a": Infinity}
]),
"Initial decimal insertion failed");
// Simple finds
assert.eq(col.find({"a": -1}).count(), 4, "A1");
assert.eq(col.find({"a": NumberLong("-1")}).count(), 4, "A2");
assert.eq(col.find({"a": NumberInt("-1")}).count(), 4, "A3");
assert.eq(col.find({"a": NumberDecimal("-1")}).count(), 4, "A4");
assert.eq(col.find({"a": NaN}).count(), 3, "B1");
assert.eq(col.find({"a": NumberDecimal("NaN")}).count(), 3, "B2");
assert.eq(col.find({"a": Infinity}).count(), 2, "B3");
assert.eq(col.find({"a": NumberDecimal("Infinity")}).count(), 2, "B4");
assert.eq(col.find({$and: [{"a": {$gte: 0}}, {"a": {$lte: 2}}]}).count(), 14, "C1");
// Proper mixed ordering of decimals and doubles
col.drop();
assert.commandWorked(col.insert([{"a": NumberDecimal("0.3")}, {"a": 0.3}], "2 insertion failed"));
assert.eq(col.find({"a": {$lt: NumberDecimal("0.3")}}).count(), 1, "D1");
assert.eq(col.find({"a": {$gt: 0.3}}).count(), 1, "D1");
// Find with NumberLong, but not Double
col.drop();
assert.commandWorked(col.insert([{"a": NumberDecimal("36028797018963967")}], "3 insertion failed"));
assert.eq(col.find({"a": NumberDecimal("36028797018963967")}).count(), 1, "E1");
// Not representable as double
assert.eq(col.find({"a": 36028797018963967}).count(), 0, "E2");
assert.eq(col.find({"a": NumberLong("36028797018963967")}).count(), 1, "E3");
}());
|
