{"action":"reopened","issue":{"url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/11006","repository_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore","labels_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/11006/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/11006/comments","events_url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/issues/11006/events","html_url":"https://github.com/aspnet/EntityFrameworkCore/issues/11006","id":298240585,"number":11006,"title":"SqlServer Error 8623 The query processor ran out of internal resources and could not produce a query plan","user":{"login":"xaviergxf","id":9695636,"avatar_url":"https://avatars2.githubusercontent.com/u/9695636?v=4","gravatar_id":"","url":"https://api.github.com/users/xaviergxf","html_url":"https://github.com/xaviergxf","followers_url":"https://api.github.com/users/xaviergxf/followers","following_url":"https://api.github.com/users/xaviergxf/following{/other_user}","gists_url":"https://api.github.com/users/xaviergxf/gists{/gist_id}","starred_url":"https://api.github.com/users/xaviergxf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xaviergxf/subscriptions","organizations_url":"https://api.github.com/users/xaviergxf/orgs","repos_url":"https://api.github.com/users/xaviergxf/repos","events_url":"https://api.github.com/users/xaviergxf/events{/privacy}","received_events_url":"https://api.github.com/users/xaviergxf/received_events","type":"User","site_admin":false},"labels":[{"id":420187509,"url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/labels/area-external","name":"area-external","color":"d4c5f9","default":false},{"id":333904587,"url":"https://api.github.com/repos/aspnet/EntityFrameworkCore/labels/type-investigation","name":"type-investigation","color":"0052cc","default":false}],"state":"open","locked":false,"assignee":{"login":"divega","id":1253414,"avatar_url":"https://avatars0.githubusercontent.com/u/1253414?v=4","gravatar_id":"","url":"https://api.github.com/users/divega","html_url":"https://github.com/divega","followers_url":"https://api.github.com/users/divega/followers","following_url":"https://api.github.com/users/divega/following{/other_user}","gists_url":"https://api.github.com/users/divega/gists{/gist_id}","starred_url":"https://api.github.com/users/divega/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/divega/subscriptions","organizations_url":"https://api.github.com/users/divega/orgs","repos_url":"https://api.github.com/users/divega/repos","events_url":"https://api.github.com/users/divega/events{/privacy}","received_events_url":"https://api.github.com/users/divega/received_events","type":"User","site_admin":false},"assignees":[{"login":"divega","id":1253414,"avatar_url":"https://avatars0.githubusercontent.com/u/1253414?v=4","gravatar_id":"","url":"https://api.github.com/users/divega","html_url":"https://github.com/divega","followers_url":"https://api.github.com/users/divega/followers","following_url":"https://api.github.com/users/divega/following{/other_user}","gists_url":"https://api.github.com/users/divega/gists{/gist_id}","starred_url":"https://api.github.com/users/divega/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/divega/subscriptions","organizations_url":"https://api.github.com/users/divega/orgs","repos_url":"https://api.github.com/users/divega/repos","events_url":"https://api.github.com/users/divega/events{/privacy}","received_events_url":"https://api.github.com/users/divega/received_events","type":"User","site_admin":false}],"milestone":null,"comments":16,"created_at":"2018-02-19T11:21:17Z","updated_at":"2018-02-28T20:02:18Z","closed_at":null,"author_association":"NONE","body":"When doing the following sql with ids containing more than 16000 ids:\r\n\r\n```\r\ndb.Table.Where(p=>p.ids.Contains(p.ID)).ToList();\r\n```\r\n\r\nI'm receiving the following exception:\r\n```\r\nThe query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.\r\n```\r\n\r\nI was expecting Sql Server to be able to filter the results correctly.\r\n\r\nIs it possible this query into multiple times to avoid this error?\r\n\r\n### Further technical details\r\nEF Core version: 2.01\r\nDatabase Provider: Microsoft.EntityFrameworkCore.SqlServer\r\nOperating system:  Windows 7 \r\nIDE: Visual Studio 2017 15.5\r\nSql Server: 2008 SP2\r\n"}}
{"actor":{"display_login":"ajcvickers"}}