{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/3186","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/3186/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/3186/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/3186/events","html_url":"https://github.com/aspnet/EntityFramework/issues/3186","id":107647490,"number":3186,"title":"strange behavior for query","user":{"login":"kennywangjin","id":3364218,"avatar_url":"https://avatars.githubusercontent.com/u/3364218?v=3","gravatar_id":"","url":"https://api.github.com/users/kennywangjin","html_url":"https://github.com/kennywangjin","followers_url":"https://api.github.com/users/kennywangjin/followers","following_url":"https://api.github.com/users/kennywangjin/following{/other_user}","gists_url":"https://api.github.com/users/kennywangjin/gists{/gist_id}","starred_url":"https://api.github.com/users/kennywangjin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kennywangjin/subscriptions","organizations_url":"https://api.github.com/users/kennywangjin/orgs","repos_url":"https://api.github.com/users/kennywangjin/repos","events_url":"https://api.github.com/users/kennywangjin/events{/privacy}","received_events_url":"https://api.github.com/users/kennywangjin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/aspnet/EntityFramework/labels/bug","name":"bug","color":"f7c6c7"},{"url":"https://api.github.com/repos/aspnet/EntityFramework/labels/pri0","name":"pri0","color":"e11d21"}],"state":"open","locked":false,"assignee":{"login":"maumar","id":1591930,"avatar_url":"https://avatars.githubusercontent.com/u/1591930?v=3","gravatar_id":"","url":"https://api.github.com/users/maumar","html_url":"https://github.com/maumar","followers_url":"https://api.github.com/users/maumar/followers","following_url":"https://api.github.com/users/maumar/following{/other_user}","gists_url":"https://api.github.com/users/maumar/gists{/gist_id}","starred_url":"https://api.github.com/users/maumar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maumar/subscriptions","organizations_url":"https://api.github.com/users/maumar/orgs","repos_url":"https://api.github.com/users/maumar/repos","events_url":"https://api.github.com/users/maumar/events{/privacy}","received_events_url":"https://api.github.com/users/maumar/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/aspnet/EntityFramework/milestones/18","html_url":"https://github.com/aspnet/EntityFramework/milestones/7.0.0-rc2","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/milestones/18/labels","id":1403248,"number":18,"title":"7.0.0-rc2","description":null,"creator":{"login":"bricelam","id":1226749,"avatar_url":"https://avatars.githubusercontent.com/u/1226749?v=3","gravatar_id":"","url":"https://api.github.com/users/bricelam","html_url":"https://github.com/bricelam","followers_url":"https://api.github.com/users/bricelam/followers","following_url":"https://api.github.com/users/bricelam/following{/other_user}","gists_url":"https://api.github.com/users/bricelam/gists{/gist_id}","starred_url":"https://api.github.com/users/bricelam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bricelam/subscriptions","organizations_url":"https://api.github.com/users/bricelam/orgs","repos_url":"https://api.github.com/users/bricelam/repos","events_url":"https://api.github.com/users/bricelam/events{/privacy}","received_events_url":"https://api.github.com/users/bricelam/received_events","type":"User","site_admin":false},"open_issues":61,"closed_issues":85,"state":"open","created_at":"2015-11-09T22:23:36Z","updated_at":"2015-12-23T21:43:09Z","due_on":null,"closed_at":null},"comments":10,"created_at":"2015-09-22T05:11:48Z","updated_at":"2015-12-24T17:27:48Z","closed_at":null,"body":"I have model: \r\n\r\n```\r\npublic Class Item\r\n\r\n{\r\n\r\n    public int Id {get; set;}\r\n   \r\n    public int? ParentId {get; set;}\r\n    \r\n    public virtual Item Parent {get;set;}\r\n\r\n}\r\n```\r\nwhen the query dbContenxt.Items.Where(item=>item.ParentId==null || item.Parent.ParentId==null)\r\n\r\nit returns just the items matching the second filter: item.Parent.ParentId==null, the first filter doesn't work!\r\nif I remove the second filter and just use the first one, then I could get the items matching the first filter.\r\n\r\nIs it a bug or any misunderstanding of the framework?"},"comment":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/comments/167139833","html_url":"https://github.com/aspnet/EntityFramework/issues/3186#issuecomment-167139833","issue_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/3186","id":167139833,"user":{"login":"jemiller0","id":15931877,"avatar_url":"https://avatars.githubusercontent.com/u/15931877?v=3","gravatar_id":"","url":"https://api.github.com/users/jemiller0","html_url":"https://github.com/jemiller0","followers_url":"https://api.github.com/users/jemiller0/followers","following_url":"https://api.github.com/users/jemiller0/following{/other_user}","gists_url":"https://api.github.com/users/jemiller0/gists{/gist_id}","starred_url":"https://api.github.com/users/jemiller0/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jemiller0/subscriptions","organizations_url":"https://api.github.com/users/jemiller0/orgs","repos_url":"https://api.github.com/users/jemiller0/repos","events_url":"https://api.github.com/users/jemiller0/events{/privacy}","received_events_url":"https://api.github.com/users/jemiller0/received_events","type":"User","site_admin":false},"created_at":"2015-12-24T17:27:48Z","updated_at":"2015-12-24T17:27:48Z","body":"I'm wondering if interceptors are supported in EF 7? I want to say this was a feature that was supposed to be improved over EF 6. Maybe one could use that to temporarily work around this problem? I.e. do a text replace of \"INNER JOIN\" with \"LEFT JOIN\"."}}