Cosmos Mongo API “In"数组表达式问题 [英] Cosmos Mongo API "In" Array expression issue

问题描述

IN 表达式有问题吗?我们遇到了问题，即使它存在，它也找不到我们要求的结果?

Are there issues with the IN expression? We are having issues where it doesn't find the results we are asking for even though it exists?

{ "SerialNumber": "V8073023", "_t": "DeviceEventDataEvent", "EventType": NumberInt(4), "isDeleted": { $in: [false,null] }, "EventNumber": 122 }正确返回文档，但是使用 IN 时

{ "SerialNumber": "V8073023", "_t": "DeviceEventDataEvent", "EventType": NumberInt(4), "isDeleted": { $in: [false,null] }, "EventNumber": 122 } Returns the document correctly, however when using IN

{ "SerialNumber": "V8073023", "_t": "DeviceEventDataEvent", "EventType": NumberInt(4), "isDeleted": { $in: [false,null] }, "EventNumber": { $在:[122] } }没有数据返回.

{ "SerialNumber": "V8073023", "_t": "DeviceEventDataEvent", "EventType": NumberInt(4), "isDeleted": { $in: [false,null] }, "EventNumber": { $in: [122] } } No data is returned.

推荐答案

Microsoft 回复了我，发出他们的意见.感谢所有参与的人仍然提供帮助.

Microsoft got back to me, issue their side. Thanks to everyone involved for still assisting.

感谢大卫报告此事！我调查了这个问题，这是我们这边的一个错误，在多种条件下表现出来.我已经修复了它，并将在本周末检查它(然后由我们的部署周期将修复传播到世界各地的所有数据中心).如果您有无效的查询并阻止您，请告诉我.最好的祝福，奥瑞斯提斯

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

这篇关于Cosmos Mongo API “In"数组表达式问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！