java - Azure mongodb $in 查询不起作用

Question

我有包含 140 个文档的员工集合

{

    "name" : "name1",

    "dept" : "tech",

    "address" : "adr3"

}

在所有 140 个文档中，部门都是技术部门当我在 azure mongodb

中执行查询时

    MongoDatabase db = mongo.getDatabase("test")
    def query = new BasicDBObject(['dept':['$in':['tech']]])
    FindIterable documents = db.getCollection("employees").find(query)
    def outList =  documents.collect {it}

我只得到 101 个文档，而不是 140 条记录

这在本地 mongodb 中运行良好。直到上周，这对我来说还在 azure 中工作。我在这里做错了什么吗？有人遇到类似情况吗？

如果我将查询更改为

def query = new BasicDBObject(['dept':'tech'])

我得到了全部 140 个文档

如果我将批量大小更改为 10，$in 查询仅返回 10 个文档。

Answer 1

夏尔。根据本案例分享:Cosmos Mongo API "In" Array expression issue ，看来是微软这边的问题，你可以等到bug修复。

回复如下:

Thank you David for reporting this! I investigated the issue, it’s a bug on our side manifesting under a combination of conditions. I already have made a fix for it and will check it in by end of week (then it’s up to our deployment cycle to propagate the fix to all datacenters around the world). Let me know if you have queries that don’t work and are blocking you. Best regards, Orestis

希望对您有帮助。