Cosmos Mongo API "In" Array expression issue

Question

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 } Returns the document correctly, however when using IN

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

David, you could post more details such as your sample document, db location. — Jay Gong
– Jay Gong, Commented Apr 12, 2018 at 2:20
Hey @JayGong, thanks for looking into this. See my answer below. Its an issue on Microsofts side. Waiting for fix to be rolled out — David
– David, Commented Apr 13, 2018 at 10:24

Jay Gong · Accepted Answer · 2018-04-12 02:19:22Z

2

I tried to reproduce your issue on my side but failed. Please refer to my details.

My sample documents in my cosmos db:

{
        "id" : "1",
        "CustomerId" : 1,
        "Orders" : [
            "a",
            "b",
            "c"
        ]
},
{
        "id" : "2",
        "CustomerId" : 2,
        "Orders" : [
            "e",
            "f",
            "g"
        ]
}

Query 1：

Query 2:

My db was built in the region East Asia.If you have any difference with me, you could edit it.

answered Apr 12, 2018 at 2:19

Jay Gong

23.8k2 gold badges30 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David · Accepted Answer · 2018-04-13 06:27:47Z

1

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

answered Apr 13, 2018 at 6:27

David

7437 silver badges24 bronze badges

Collectives™ on Stack Overflow

Cosmos Mongo API "In" Array expression issue

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related