jstests/noPassthroughWithMongod/external_sort_text_agg.js


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

// Ensure text search metadata is not lost in an external sort
var t = db.external_sort_text_agg;
t.drop();
t.ensureIndex({text: "text"});
for (i = 0; i < 100; i++) {
    t.insert({_id:i, text: Array(210000).join("asdf ")});
    // string over 1MB to hit the 100MB threshold for external sort
}

var score = t.find({$text: {$search: "asdf"}}, {score: {$meta: 'textScore'}}).next().score;
var res = t.aggregate([{$match: {$text: {$search: "asdf"}}},
                       {$sort: {"_id": 1}},
                       {$project: {string: "$text", score: {$meta: "textScore"}}}
                      ], 
                      {allowDiskUse: true});
// we must use .next() rather than a $limit because a $limit will optimize away the external sort
printjson(res.next());
assert.eq(res.next().score, score);