[CSHARP-1518] Don't work sub array query Created: 24/Dec/15  Updated: 17/Nov/22

Status: Backlog
Project: C# Driver
Component/s: Linq, LINQ3
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor - P4
Reporter: Vorobjev Valery Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: triaged
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

This query success compile and run. But, result is not right!

Example:

            var cursor = from uc in usersCollection.AsQueryable()
                         join cc in candlesCollection.AsQueryable() on uc.Pairs.First(p=>p.Name == "CAD_HKD").Id equals cc.UserPairId into joined
                         select new { uc.FirstName, uc.LastName, Count =  joined.Count()};

This code return 50 records, but every propery "Count" = 0! It is not right, because data exist in the collection!



 Comments   
Comment by Craig Wilson [ 27/Jan/16 ]

Hi Vorobjev,

MongoDB doesn't support this type of join, so we can't support it either. However, we really should be raising an exception rather that succeeding and giving incorrect results.

Thanks for the report,
Craig

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