{"action":"created","issue":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5512","repository_url":"https://api.github.com/repos/greenplum-db/gpdb","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5512/labels{/name}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5512/comments","events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5512/events","html_url":"https://github.com/greenplum-db/gpdb/pull/5512","id":351360650,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA4OTc4Mzg4","number":5512,"title":"Inferring quals on left outer joins incorrectly","user":{"login":"joaopapereira","id":1826130,"node_id":"MDQ6VXNlcjE4MjYxMzA=","avatar_url":"https://avatars0.githubusercontent.com/u/1826130?v=4","gravatar_id":"","url":"https://api.github.com/users/joaopapereira","html_url":"https://github.com/joaopapereira","followers_url":"https://api.github.com/users/joaopapereira/followers","following_url":"https://api.github.com/users/joaopapereira/following{/other_user}","gists_url":"https://api.github.com/users/joaopapereira/gists{/gist_id}","starred_url":"https://api.github.com/users/joaopapereira/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joaopapereira/subscriptions","organizations_url":"https://api.github.com/users/joaopapereira/orgs","repos_url":"https://api.github.com/users/joaopapereira/repos","events_url":"https://api.github.com/users/joaopapereira/events{/privacy}","received_events_url":"https://api.github.com/users/joaopapereira/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-08-16T20:41:23Z","updated_at":"2018-08-24T01:03:32Z","closed_at":null,"author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/5512","html_url":"https://github.com/greenplum-db/gpdb/pull/5512","diff_url":"https://github.com/greenplum-db/gpdb/pull/5512.diff","patch_url":"https://github.com/greenplum-db/gpdb/pull/5512.patch"},"body":"The function `generate_implied_quals` was inferring quals and trying\r\nto push them down inside the non Nullable side of the LEFT OUTER JOIN\r\nand that behavior was incorrect. This was bubbling up in the following\r\nerror while trying to set join references(`set_join_references`):\r\n`ERROR: variable not found in subplan target lists (setrefs.c:2085)`\r\n\r\nThis commit check if it is an outer join and if so will not try to infer\r\nany predicates"},"comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments/415619049","html_url":"https://github.com/greenplum-db/gpdb/pull/5512#issuecomment-415619049","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5512","id":415619049,"node_id":"MDEyOklzc3VlQ29tbWVudDQxNTYxOTA0OQ==","user":{"login":"khannaekta","id":15749573,"node_id":"MDQ6VXNlcjE1NzQ5NTcz","avatar_url":"https://avatars0.githubusercontent.com/u/15749573?v=4","gravatar_id":"","url":"https://api.github.com/users/khannaekta","html_url":"https://github.com/khannaekta","followers_url":"https://api.github.com/users/khannaekta/followers","following_url":"https://api.github.com/users/khannaekta/following{/other_user}","gists_url":"https://api.github.com/users/khannaekta/gists{/gist_id}","starred_url":"https://api.github.com/users/khannaekta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/khannaekta/subscriptions","organizations_url":"https://api.github.com/users/khannaekta/orgs","repos_url":"https://api.github.com/users/khannaekta/repos","events_url":"https://api.github.com/users/khannaekta/events{/privacy}","received_events_url":"https://api.github.com/users/khannaekta/received_events","type":"User","site_admin":false},"created_at":"2018-08-24T01:03:32Z","updated_at":"2018-08-24T01:03:32Z","author_association":"CONTRIBUTOR","body":"@berlin-ab @d Added the `SELECT` to check against an expected output. Could you please take another look."}}
{"actor":{"display_login":"khannaekta"}}