{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2626","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2626/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2626/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2626/events","html_url":"https://github.com/aspnet/EntityFramework/issues/2626","id":95131923,"number":2626,"title":"Fix \"Relational: Lift sub-queries in Where and OrderBy clauses\" breaks SQLCE","user":{"login":"ErikEJ","id":4169187,"avatar_url":"https://avatars.githubusercontent.com/u/4169187?v=3","gravatar_id":"","url":"https://api.github.com/users/ErikEJ","html_url":"https://github.com/ErikEJ","followers_url":"https://api.github.com/users/ErikEJ/followers","following_url":"https://api.github.com/users/ErikEJ/following{/other_user}","gists_url":"https://api.github.com/users/ErikEJ/gists{/gist_id}","starred_url":"https://api.github.com/users/ErikEJ/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ErikEJ/subscriptions","organizations_url":"https://api.github.com/users/ErikEJ/orgs","repos_url":"https://api.github.com/users/ErikEJ/repos","events_url":"https://api.github.com/users/ErikEJ/events{/privacy}","received_events_url":"https://api.github.com/users/ErikEJ/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/aspnet/EntityFramework/labels/pri0","name":"pri0","color":"e11d21"},{"url":"https://api.github.com/repos/aspnet/EntityFramework/labels/task","name":"task","color":"d4c5f9"}],"state":"open","locked":false,"assignee":{"login":"anpete","id":1210944,"avatar_url":"https://avatars.githubusercontent.com/u/1210944?v=3","gravatar_id":"","url":"https://api.github.com/users/anpete","html_url":"https://github.com/anpete","followers_url":"https://api.github.com/users/anpete/followers","following_url":"https://api.github.com/users/anpete/following{/other_user}","gists_url":"https://api.github.com/users/anpete/gists{/gist_id}","starred_url":"https://api.github.com/users/anpete/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anpete/subscriptions","organizations_url":"https://api.github.com/users/anpete/orgs","repos_url":"https://api.github.com/users/anpete/repos","events_url":"https://api.github.com/users/anpete/events{/privacy}","received_events_url":"https://api.github.com/users/anpete/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/aspnet/EntityFramework/milestones/7","html_url":"https://github.com/aspnet/EntityFramework/milestones/7.0.0","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/milestones/7/labels","id":666128,"number":7,"title":"7.0.0","description":"","creator":{"login":"rowanmiller","id":4741851,"avatar_url":"https://avatars.githubusercontent.com/u/4741851?v=3","gravatar_id":"","url":"https://api.github.com/users/rowanmiller","html_url":"https://github.com/rowanmiller","followers_url":"https://api.github.com/users/rowanmiller/followers","following_url":"https://api.github.com/users/rowanmiller/following{/other_user}","gists_url":"https://api.github.com/users/rowanmiller/gists{/gist_id}","starred_url":"https://api.github.com/users/rowanmiller/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rowanmiller/subscriptions","organizations_url":"https://api.github.com/users/rowanmiller/orgs","repos_url":"https://api.github.com/users/rowanmiller/repos","events_url":"https://api.github.com/users/rowanmiller/events{/privacy}","received_events_url":"https://api.github.com/users/rowanmiller/received_events","type":"User","site_admin":false},"open_issues":90,"closed_issues":48,"state":"open","created_at":"2014-05-21T19:25:32Z","updated_at":"2015-12-12T00:13:25Z","due_on":null,"closed_at":null},"comments":13,"created_at":"2015-07-15T08:13:04Z","updated_at":"2015-12-12T15:28:54Z","closed_at":null,"body":"@anpete  The recent fix for this unfortunately breaks the SQLCE provider, as the SQL generated with nested SELECTs is not supported by the SQL CE engine. https://github.com/aspnet/EntityFramework/commit/cd1839b224ab0f1b49473216a146510d562d9735 \r\nWhat do I need to change in order for this to work again?\r\n\r\nAffected query tests include: \r\n\r\nOrderBy_correlated_subquery_lol()\r\nWhere_query_composition()\r\nWhere_shadow_subquery_first()\r\nWhere_subquery_correlated()\r\nWhere_subquery_recursive_trivial()\r\n"},"comment":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/comments/164161203","html_url":"https://github.com/aspnet/EntityFramework/issues/2626#issuecomment-164161203","issue_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2626","id":164161203,"user":{"login":"ErikEJ","id":4169187,"avatar_url":"https://avatars.githubusercontent.com/u/4169187?v=3","gravatar_id":"","url":"https://api.github.com/users/ErikEJ","html_url":"https://github.com/ErikEJ","followers_url":"https://api.github.com/users/ErikEJ/followers","following_url":"https://api.github.com/users/ErikEJ/following{/other_user}","gists_url":"https://api.github.com/users/ErikEJ/gists{/gist_id}","starred_url":"https://api.github.com/users/ErikEJ/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ErikEJ/subscriptions","organizations_url":"https://api.github.com/users/ErikEJ/orgs","repos_url":"https://api.github.com/users/ErikEJ/repos","events_url":"https://api.github.com/users/ErikEJ/events{/privacy}","received_events_url":"https://api.github.com/users/ErikEJ/received_events","type":"User","site_admin":false},"created_at":"2015-12-12T15:28:54Z","updated_at":"2015-12-12T15:28:54Z","body":"Now this test also breaks: Join_navigation_translated_to_subquery_self_ref \r\nStill looking forward to some workaround pointers..."}}