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
|
// Cannot implicitly shard accessed collections because queries on a sharded collection are not
// able to be covered when they aren't on the shard key since the document needs to be fetched in
// order to apply the SHARDING_FILTER stage.
// @tags: [assumes_unsharded_collection]
// Test indexing of decimal numbers
(function() {
'use strict';
// Include helpers for analyzing explain output.
load('jstests/libs/analyze_plan.js');
var t = db.decimal_indexing;
t.drop();
// Create doubles and NumberDecimals. The double 0.1 is actually 0.10000000000000000555
// and the double 0.3 is actually 0.2999999999999999888, so we can check ordering.
assert.writeOK(t.insert({x: 0.1, y: NumberDecimal('0.3000')}));
assert.writeOK(t.insert({x: 0.1}));
assert.writeOK(t.insert({y: 0.3}));
// Create an index on existing numbers.
assert.commandWorked(t.createIndex({x: 1}));
assert.commandWorked(t.createIndex({y: -1}));
// Insert some more items after index creation. Use _id for decimal.
assert.writeOK(t.insert({x: NumberDecimal('0.10')}));
assert.writeOK(t.insert({_id: NumberDecimal('0E3')}));
assert.writeError(t.insert({_id: -0.0}));
// Check that we return exactly the right document, use an index to do so, and that the
// result of the covered query has the right number of trailing zeros.
var qres = t.find({x: NumberDecimal('0.1')}, {_id: 0, x: 1}).toArray();
var qplan = t.find({x: NumberDecimal('0.1')}, {_id: 0, x: 1}).explain();
assert.neq(tojson(NumberDecimal('0.1')),
tojson(NumberDecimal('0.10')),
'trailing zeros are significant for exact equality');
assert.eq(
qres, [{x: NumberDecimal('0.10')}], 'query for x equal to decimal 0.10 returns wrong value');
assert(isIndexOnly(db, qplan.queryPlanner.winningPlan),
'query on decimal should be covered: ' + tojson(qplan));
// Check that queries for exact floating point numbers don't return nearby decimals.
assert.eq(t.find({x: 0.1}, {_id: 0}).sort({x: 1, y: 1}).toArray(),
[{x: 0.1}, {x: 0.1, y: NumberDecimal('0.3000')}],
'wrong result for querying {x: 0.1}');
assert.eq(t.find({x: {$lt: 0.1}}, {_id: 0}).toArray(),
[{x: NumberDecimal('0.10')}],
'querying for decimal less than double 0.1 should return decimal 0.10');
assert.eq(t.find({y: {$lt: NumberDecimal('0.3')}}, {y: 1, _id: 0}).toArray(),
[{y: 0.3}],
'querying for double less than decimal 0.3 should return double 0.3');
assert.eq(t.find({_id: 0}, {_id: 1}).toArray(),
[{_id: NumberDecimal('0E3')}],
'querying for zero does not return the correct decimal');
})();
|
