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
|
// Tests to validate the input for sort on '$meta' operator.
// @tags: [
// sbe_incompatible,
// ]
(function() {
"use strict";
const coll = db.sort_with_meta_operator;
coll.drop();
assert.commandWorked(
coll.insert([{_id: 1, p: 1}, {_id: -1, p: -2}, {_id: -2, p: -1}, {_id: 2, p: 2}]));
// Verify that the sort with $meta operator correctly rejects invalid input.
assert.commandFailedWithCode(db.runCommand({find: coll.getName(), sort: {_id: {$meta: 1}}}), 31138);
assert.commandFailedWithCode(db.runCommand({find: coll.getName(), sort: {_id: {$meta: -1}}}),
31138);
assert.commandFailedWithCode(
db.runCommand({find: coll.getName(), sort: {_id: {$meta: 'searchScore'}}}), 31218);
assert.commandFailedWithCode(
db.runCommand({find: coll.getName(), sort: {_id: {$meta: 'searchHighlights'}}}), 31219);
assert.commandFailedWithCode(db.runCommand({find: coll.getName(), sort: {_id: {$meta: '1'}}}),
31138);
// Verify that sort with $meta:'randVal' works and returns all the documents.
assert.eq(coll.find().sort({_id: {$meta: 'randVal'}}).itcount(), 4);
assert.eq(coll.find().sort({p: {$meta: 'randVal'}, _id: {$meta: 'randVal'}}).itcount(), 4);
// Should still sort on the prefix 'p' when the later part is being sorted with 'randVal'.
assert.eq(coll.find().sort({p: 1, _id: {$meta: 'randVal'}}).toArray(),
[{_id: -1, p: -2}, {_id: -2, p: -1}, {_id: 1, p: 1}, {_id: 2, p: 2}]);
// Verify the above tests also fail with aggregate.
assert.commandFailedWithCode(
db.runCommand({aggregate: coll.getName(), cursor: {}, pipeline: [{$sort: {_id: {$meta: 1}}}]}),
31138);
assert.commandFailedWithCode(
db.runCommand({aggregate: coll.getName(), cursor: {}, pipeline: [{$sort: {_id: {$meta: -1}}}]}),
31138);
assert.commandFailedWithCode(db.runCommand({
aggregate: coll.getName(),
cursor: {},
pipeline: [{$sort: {_id: {$meta: 'searchScore'}}}]
}),
31218);
assert.commandFailedWithCode(db.runCommand({
aggregate: coll.getName(),
cursor: {},
pipeline: [{$sort: {_id: {$meta: 'searchHighlights'}}}]
}),
31219);
assert.commandFailedWithCode(
db.runCommand(
{aggregate: coll.getName(), cursor: {}, pipeline: [{$sort: {_id: {$meta: '1'}}}]}),
31138);
// Verify that sort with $meta:'randVal' works and returns all the documents.
assert.eq(coll.aggregate([{$sort: {_id: {$meta: 'randVal'}}}]).itcount(), 4);
assert.eq(coll.aggregate([{$sort: {p: {$meta: 'randVal'}, _id: {$meta: 'randVal'}}}]).itcount(), 4);
// Should still sort on the prefix 'p' when the later part is being sorted with 'randVal'.
assert.eq(coll.aggregate([{$sort: {p: 1, _id: {$meta: 'randVal'}}}]).toArray(),
[{_id: -1, p: -2}, {_id: -2, p: -1}, {_id: 1, p: 1}, {_id: 2, p: 2}]);
})();
|