summaryrefslogtreecommitdiff
path: root/jstests/decimal/decimal_find_mixed.js
blob: 078ada3ad0f20d452ee7623995148c6a54aa8dc0 (plain)
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.writeOK(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.writeOK(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.writeOK(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");
}());