[CSHARP-4525] Querying a standard view returns an empty response Created: 14/Feb/23  Updated: 27/Oct/23  Resolved: 06/Mar/23

Status: Closed
Project: C# Driver
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Matteo Chiavaroli Assignee: Boris Dogadov
Resolution: Gone away Votes: 0
Labels: query, views
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Summary

On an Atlas 6.0.4 M10 MongoDB cluster, querying a standard view by using C# driver 2.19.0 it returns an empty result.

Doing the same query on an Atlas 5.0.14 M0 cluster it returns the expected results. Of course the view on M0 is the same than the one on M10.

Please provide the version of the driver. If applicable, please provide the MongoDB server version and topology (standalone, replica set, or sharded cluster).

C# driver 2.19.0

Atlas 6.0.4 M10 replica set 3 nodes cluster

How to Reproduce

Please refer to what described in the summary.



 Comments   
Comment by PM Bot [ 06/Mar/23 ]

There hasn't been any recent activity on this ticket, so we're resolving it. Thanks for reaching out! Please feel free to comment on this if you're able to provide more information.

Comment by Boris Dogadov [ 17/Feb/23 ]

Thank you for your question matteo.chiavaroli@aenduo.com 

C# Driver behavior should be not affected by Atlas deployment version, and it should issue similar queries for both deployments.
As the driver works as expected with different deployment, seems that the problem is not within the driver. To investigate further, I suggest validating those queries in MongoDB Shell against both deployments.

If the query works as expected in MongoDB Shell but fails in the driver, please provide more information to reproduce the issue: Self contained code and the relevant information of creating the collection and the view.
Also logs would give us more insights: configuring logging.

Thanks.

Comment by Matteo Chiavaroli [ 16/Feb/23 ]

Running the pipeline using directly the Aggregate method of the driver it works but not querying the saved view.

Generated at Wed Feb 07 21:48:29 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.