{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/11861","repository_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore","labels_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/11861/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/11861/comments","events_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/11861/events","html_url":"https://github.com/aspnet/EntityFrameworkCore/issues/11861","id":319026443,"number":11861,"title":"Grouped query does not return all rows","user":{"login":"sam-wheat","id":16885210,"avatar_url":"https://avatars0.githubusercontent.com/u/16885210?v=4","gravatar_id":"","url":"https://api.github.com/users/sam-wheat","html_url":"https://github.com/sam-wheat","followers_url":"https://api.github.com/users/sam-wheat/followers","following_url":"https://api.github.com/users/sam-wheat/following{/other_user}","gists_url":"https://api.github.com/users/sam-wheat/gists{/gist_id}","starred_url":"https://api.github.com/users/sam-wheat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sam-wheat/subscriptions","organizations_url":"https://api.github.com/users/sam-wheat/orgs","repos_url":"https://api.github.com/users/sam-wheat/repos","events_url":"https://api.github.com/users/sam-wheat/events{/privacy}","received_events_url":"https://api.github.com/users/sam-wheat/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-04-30T20:35:20Z","updated_at":"2018-04-30T22:42:51Z","closed_at":null,"author_association":"NONE","body":"Query below returns 45282 symbols:\r\n\r\n\r\n\tList<string> symbols = await db.DTOObservations.GroupBy(x => x.Symbol).Select(x => x.Key).ToListAsync();\r\n     \r\n\r\n\tforeach(string symbol in symbols)\r\n\t{\r\n\t\tawait func(symbol);\r\n\t};\r\n\r\n\r\n\r\n\r\nQuery below returns 10616 symbols: \r\n\r\n\tvar query = db.DTOObservations.GroupBy(x => x.Symbol);  \r\n\r\n\tawait query.ForEachAsync(async symbols =>\r\n\t{\r\n\t\tawait func(symbols.Key);\r\n\t});\r\n\t\r\n\t\r\nAm I doing something obviously wrong?  Is this a known problem for version 2.0.2?  I will try to reproduce it in an example project if not. \r\n\r\n"},"comment":{"url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/comments/385550553","html_url":"https://github.com/aspnet/EntityFrameworkCore/issues/11861#issuecomment-385550553","issue_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/11861","id":385550553,"user":{"login":"smitpatel","id":1528107,"avatar_url":"https://avatars0.githubusercontent.com/u/1528107?v=4","gravatar_id":"","url":"https://api.github.com/users/smitpatel","html_url":"https://github.com/smitpatel","followers_url":"https://api.github.com/users/smitpatel/followers","following_url":"https://api.github.com/users/smitpatel/following{/other_user}","gists_url":"https://api.github.com/users/smitpatel/gists{/gist_id}","starred_url":"https://api.github.com/users/smitpatel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smitpatel/subscriptions","organizations_url":"https://api.github.com/users/smitpatel/orgs","repos_url":"https://api.github.com/users/smitpatel/repos","events_url":"https://api.github.com/users/smitpatel/events{/privacy}","received_events_url":"https://api.github.com/users/smitpatel/received_events","type":"User","site_admin":false},"created_at":"2018-04-30T22:42:51Z","updated_at":"2018-04-30T22:42:51Z","author_association":"CONTRIBUTOR","body":"I am not able to see difference in data for my sample test. Can you provide a repro?"}}
{"actor":{"display_login":"smitpatel"}}