{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/EntityFramework6.Npgsql/issues/94","repository_url":"https://api.github.com/repos/npgsql/EntityFramework6.Npgsql","labels_url":"https://api.github.com/repos/npgsql/EntityFramework6.Npgsql/issues/94/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/EntityFramework6.Npgsql/issues/94/comments","events_url":"https://api.github.com/repos/npgsql/EntityFramework6.Npgsql/issues/94/events","html_url":"https://github.com/npgsql/EntityFramework6.Npgsql/pull/94","id":318835927,"number":94,"title":"Translate nested CASE to simpler COALESCE","user":{"login":"bgurmendi","id":1327625,"avatar_url":"https://avatars2.githubusercontent.com/u/1327625?v=4","gravatar_id":"","url":"https://api.github.com/users/bgurmendi","html_url":"https://github.com/bgurmendi","followers_url":"https://api.github.com/users/bgurmendi/followers","following_url":"https://api.github.com/users/bgurmendi/following{/other_user}","gists_url":"https://api.github.com/users/bgurmendi/gists{/gist_id}","starred_url":"https://api.github.com/users/bgurmendi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bgurmendi/subscriptions","organizations_url":"https://api.github.com/users/bgurmendi/orgs","repos_url":"https://api.github.com/users/bgurmendi/repos","events_url":"https://api.github.com/users/bgurmendi/events{/privacy}","received_events_url":"https://api.github.com/users/bgurmendi/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-30T09:46:39Z","updated_at":"2018-04-30T12:02:39Z","closed_at":"2018-04-30T12:02:39Z","author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/npgsql/EntityFramework6.Npgsql/pulls/94","html_url":"https://github.com/npgsql/EntityFramework6.Npgsql/pull/94","diff_url":"https://github.com/npgsql/EntityFramework6.Npgsql/pull/94.diff","patch_url":"https://github.com/npgsql/EntityFramework6.Npgsql/pull/94.patch"},"body":"When EntityFramework UseDatabaseNullSemantics == true or when using null propagation expressións (?? or ?) EntityFramework6 generates and expression tree with many nested CASE WHEN expressions.\r\n\r\nWhen this happens the generated SQL query is hard to analyze for optimizations.\r\n\r\nAlso CASE expression breaks Postgres type inference in many cases. View: #60 and #62 issues for more detail.\r\n\r\nThis pull request is a starting point for solving described issues. And very annoying #60 and #62 issues."},"comment":{"url":"https://api.github.com/repos/npgsql/EntityFramework6.Npgsql/issues/comments/385378715","html_url":"https://github.com/npgsql/EntityFramework6.Npgsql/pull/94#issuecomment-385378715","issue_url":"https://api.github.com/repos/npgsql/EntityFramework6.Npgsql/issues/94","id":385378715,"user":{"login":"bgurmendi","id":1327625,"avatar_url":"https://avatars2.githubusercontent.com/u/1327625?v=4","gravatar_id":"","url":"https://api.github.com/users/bgurmendi","html_url":"https://github.com/bgurmendi","followers_url":"https://api.github.com/users/bgurmendi/followers","following_url":"https://api.github.com/users/bgurmendi/following{/other_user}","gists_url":"https://api.github.com/users/bgurmendi/gists{/gist_id}","starred_url":"https://api.github.com/users/bgurmendi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bgurmendi/subscriptions","organizations_url":"https://api.github.com/users/bgurmendi/orgs","repos_url":"https://api.github.com/users/bgurmendi/repos","events_url":"https://api.github.com/users/bgurmendi/events{/privacy}","received_events_url":"https://api.github.com/users/bgurmendi/received_events","type":"User","site_admin":false},"created_at":"2018-04-30T12:02:39Z","updated_at":"2018-04-30T12:02:39Z","author_association":"NONE","body":"There are many compilation errores, sorry. I will fix all of then and open new pull request"}}
{"actor":{"display_login":"bgurmendi"}}