{"action":"closed","number":1581,"pull_request":{"url":"https://api.github.com/repos/blaze/blaze/pulls/1581","id":83167327,"html_url":"https://github.com/blaze/blaze/pull/1581","diff_url":"https://github.com/blaze/blaze/pull/1581.diff","patch_url":"https://github.com/blaze/blaze/pull/1581.patch","issue_url":"https://api.github.com/repos/blaze/blaze/issues/1581","number":1581,"state":"closed","locked":false,"title":"Correctly reconstruct SQL Selects with Joins","user":{"login":"necaris","id":460769,"avatar_url":"https://avatars.githubusercontent.com/u/460769?v=3","gravatar_id":"","url":"https://api.github.com/users/necaris","html_url":"https://github.com/necaris","followers_url":"https://api.github.com/users/necaris/followers","following_url":"https://api.github.com/users/necaris/following{/other_user}","gists_url":"https://api.github.com/users/necaris/gists{/gist_id}","starred_url":"https://api.github.com/users/necaris/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/necaris/subscriptions","organizations_url":"https://api.github.com/users/necaris/orgs","repos_url":"https://api.github.com/users/necaris/repos","events_url":"https://api.github.com/users/necaris/events{/privacy}","received_events_url":"https://api.github.com/users/necaris/received_events","type":"User","site_admin":false},"body":"Ensure that if a select statement is a JOIN, calling `reconstruct_select` correctly reconstructs the JOIN statement instead of dropping it into a multi-table select.","created_at":"2016-08-29T21:03:36Z","updated_at":"2016-10-26T20:14:56Z","closed_at":"2016-10-26T20:14:56Z","merged_at":"2016-10-26T20:14:56Z","merge_commit_sha":"50e42af0d3fd32eb5d9aa2f8756f01e25e0eb876","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/blaze/blaze/pulls/1581/commits","review_comments_url":"https://api.github.com/repos/blaze/blaze/pulls/1581/comments","review_comment_url":"https://api.github.com/repos/blaze/blaze/pulls/comments{/number}","comments_url":"https://api.github.com/repos/blaze/blaze/issues/1581/comments","statuses_url":"https://api.github.com/repos/blaze/blaze/statuses/782dbb4c7a85022270779fa7492c421b3d3fdc31","head":{"label":"necaris:handle-relabel-after-join","ref":"handle-relabel-after-join","sha":"782dbb4c7a85022270779fa7492c421b3d3fdc31","user":{"login":"necaris","id":460769,"avatar_url":"https://avatars.githubusercontent.com/u/460769?v=3","gravatar_id":"","url":"https://api.github.com/users/necaris","html_url":"https://github.com/necaris","followers_url":"https://api.github.com/users/necaris/followers","following_url":"https://api.github.com/users/necaris/following{/other_user}","gists_url":"https://api.github.com/users/necaris/gists{/gist_id}","starred_url":"https://api.github.com/users/necaris/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/necaris/subscriptions","organizations_url":"https://api.github.com/users/necaris/orgs","repos_url":"https://api.github.com/users/necaris/repos","events_url":"https://api.github.com/users/necaris/events{/privacy}","received_events_url":"https://api.github.com/users/necaris/received_events","type":"User","site_admin":false},"repo":{"id":56345827,"name":"blaze","full_name":"necaris/blaze","owner":{"login":"necaris","id":460769,"avatar_url":"https://avatars.githubusercontent.com/u/460769?v=3","gravatar_id":"","url":"https://api.github.com/users/necaris","html_url":"https://github.com/necaris","followers_url":"https://api.github.com/users/necaris/followers","following_url":"https://api.github.com/users/necaris/following{/other_user}","gists_url":"https://api.github.com/users/necaris/gists{/gist_id}","starred_url":"https://api.github.com/users/necaris/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/necaris/subscriptions","organizations_url":"https://api.github.com/users/necaris/orgs","repos_url":"https://api.github.com/users/necaris/repos","events_url":"https://api.github.com/users/necaris/events{/privacy}","received_events_url":"https://api.github.com/users/necaris/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/necaris/blaze","description":"NumPy and Pandas interface to Big Data","fork":true,"url":"https://api.github.com/repos/necaris/blaze","forks_url":"https://api.github.com/repos/necaris/blaze/forks","keys_url":"https://api.github.com/repos/necaris/blaze/keys{/key_id}","collaborators_url":"https://api.github.com/repos/necaris/blaze/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/necaris/blaze/teams","hooks_url":"https://api.github.com/repos/necaris/blaze/hooks","issue_events_url":"https://api.github.com/repos/necaris/blaze/issues/events{/number}","events_url":"https://api.github.com/repos/necaris/blaze/events","assignees_url":"https://api.github.com/repos/necaris/blaze/assignees{/user}","branches_url":"https://api.github.com/repos/necaris/blaze/branches{/branch}","tags_url":"https://api.github.com/repos/necaris/blaze/tags","blobs_url":"https://api.github.com/repos/necaris/blaze/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/necaris/blaze/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/necaris/blaze/git/refs{/sha}","trees_url":"https://api.github.com/repos/necaris/blaze/git/trees{/sha}","statuses_url":"https://api.github.com/repos/necaris/blaze/statuses/{sha}","languages_url":"https://api.github.com/repos/necaris/blaze/languages","stargazers_url":"https://api.github.com/repos/necaris/blaze/stargazers","contributors_url":"https://api.github.com/repos/necaris/blaze/contributors","subscribers_url":"https://api.github.com/repos/necaris/blaze/subscribers","subscription_url":"https://api.github.com/repos/necaris/blaze/subscription","commits_url":"https://api.github.com/repos/necaris/blaze/commits{/sha}","git_commits_url":"https://api.github.com/repos/necaris/blaze/git/commits{/sha}","comments_url":"https://api.github.com/repos/necaris/blaze/comments{/number}","issue_comment_url":"https://api.github.com/repos/necaris/blaze/issues/comments{/number}","contents_url":"https://api.github.com/repos/necaris/blaze/contents/{+path}","compare_url":"https://api.github.com/repos/necaris/blaze/compare/{base}...{head}","merges_url":"https://api.github.com/repos/necaris/blaze/merges","archive_url":"https://api.github.com/repos/necaris/blaze/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/necaris/blaze/downloads","issues_url":"https://api.github.com/repos/necaris/blaze/issues{/number}","pulls_url":"https://api.github.com/repos/necaris/blaze/pulls{/number}","milestones_url":"https://api.github.com/repos/necaris/blaze/milestones{/number}","notifications_url":"https://api.github.com/repos/necaris/blaze/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/necaris/blaze/labels{/name}","releases_url":"https://api.github.com/repos/necaris/blaze/releases{/id}","deployments_url":"https://api.github.com/repos/necaris/blaze/deployments","created_at":"2016-04-15T19:48:31Z","updated_at":"2016-04-15T19:48:33Z","pushed_at":"2016-10-04T20:44:28Z","git_url":"git://github.com/necaris/blaze.git","ssh_url":"git@github.com:necaris/blaze.git","clone_url":"https://github.com/necaris/blaze.git","svn_url":"https://github.com/necaris/blaze","homepage":"blaze.pydata.org","size":22781,"stargazers_count":0,"watchers_count":0,"language":"Python","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"blaze:master","ref":"master","sha":"a1aa9a2868494f875c41bb1d9c88c0ea666071e2","user":{"login":"blaze","id":12833921,"avatar_url":"https://avatars.githubusercontent.com/u/12833921?v=3","gravatar_id":"","url":"https://api.github.com/users/blaze","html_url":"https://github.com/blaze","followers_url":"https://api.github.com/users/blaze/followers","following_url":"https://api.github.com/users/blaze/following{/other_user}","gists_url":"https://api.github.com/users/blaze/gists{/gist_id}","starred_url":"https://api.github.com/users/blaze/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blaze/subscriptions","organizations_url":"https://api.github.com/users/blaze/orgs","repos_url":"https://api.github.com/users/blaze/repos","events_url":"https://api.github.com/users/blaze/events{/privacy}","received_events_url":"https://api.github.com/users/blaze/received_events","type":"Organization","site_admin":false},"repo":{"id":6404963,"name":"blaze","full_name":"blaze/blaze","owner":{"login":"blaze","id":12833921,"avatar_url":"https://avatars.githubusercontent.com/u/12833921?v=3","gravatar_id":"","url":"https://api.github.com/users/blaze","html_url":"https://github.com/blaze","followers_url":"https://api.github.com/users/blaze/followers","following_url":"https://api.github.com/users/blaze/following{/other_user}","gists_url":"https://api.github.com/users/blaze/gists{/gist_id}","starred_url":"https://api.github.com/users/blaze/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blaze/subscriptions","organizations_url":"https://api.github.com/users/blaze/orgs","repos_url":"https://api.github.com/users/blaze/repos","events_url":"https://api.github.com/users/blaze/events{/privacy}","received_events_url":"https://api.github.com/users/blaze/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/blaze/blaze","description":"NumPy and Pandas interface to Big Data","fork":false,"url":"https://api.github.com/repos/blaze/blaze","forks_url":"https://api.github.com/repos/blaze/blaze/forks","keys_url":"https://api.github.com/repos/blaze/blaze/keys{/key_id}","collaborators_url":"https://api.github.com/repos/blaze/blaze/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/blaze/blaze/teams","hooks_url":"https://api.github.com/repos/blaze/blaze/hooks","issue_events_url":"https://api.github.com/repos/blaze/blaze/issues/events{/number}","events_url":"https://api.github.com/repos/blaze/blaze/events","assignees_url":"https://api.github.com/repos/blaze/blaze/assignees{/user}","branches_url":"https://api.github.com/repos/blaze/blaze/branches{/branch}","tags_url":"https://api.github.com/repos/blaze/blaze/tags","blobs_url":"https://api.github.com/repos/blaze/blaze/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/blaze/blaze/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/blaze/blaze/git/refs{/sha}","trees_url":"https://api.github.com/repos/blaze/blaze/git/trees{/sha}","statuses_url":"https://api.github.com/repos/blaze/blaze/statuses/{sha}","languages_url":"https://api.github.com/repos/blaze/blaze/languages","stargazers_url":"https://api.github.com/repos/blaze/blaze/stargazers","contributors_url":"https://api.github.com/repos/blaze/blaze/contributors","subscribers_url":"https://api.github.com/repos/blaze/blaze/subscribers","subscription_url":"https://api.github.com/repos/blaze/blaze/subscription","commits_url":"https://api.github.com/repos/blaze/blaze/commits{/sha}","git_commits_url":"https://api.github.com/repos/blaze/blaze/git/commits{/sha}","comments_url":"https://api.github.com/repos/blaze/blaze/comments{/number}","issue_comment_url":"https://api.github.com/repos/blaze/blaze/issues/comments{/number}","contents_url":"https://api.github.com/repos/blaze/blaze/contents/{+path}","compare_url":"https://api.github.com/repos/blaze/blaze/compare/{base}...{head}","merges_url":"https://api.github.com/repos/blaze/blaze/merges","archive_url":"https://api.github.com/repos/blaze/blaze/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/blaze/blaze/downloads","issues_url":"https://api.github.com/repos/blaze/blaze/issues{/number}","pulls_url":"https://api.github.com/repos/blaze/blaze/pulls{/number}","milestones_url":"https://api.github.com/repos/blaze/blaze/milestones{/number}","notifications_url":"https://api.github.com/repos/blaze/blaze/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/blaze/blaze/labels{/name}","releases_url":"https://api.github.com/repos/blaze/blaze/releases{/id}","deployments_url":"https://api.github.com/repos/blaze/blaze/deployments","created_at":"2012-10-26T14:25:22Z","updated_at":"2016-10-25T05:24:00Z","pushed_at":"2016-10-26T20:14:56Z","git_url":"git://github.com/blaze/blaze.git","ssh_url":"git@github.com:blaze/blaze.git","clone_url":"https://github.com/blaze/blaze.git","svn_url":"https://github.com/blaze/blaze","homepage":"blaze.pydata.org","size":33422,"stargazers_count":1613,"watchers_count":1613,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":241,"mirror_url":null,"open_issues_count":240,"forks":241,"open_issues":240,"watchers":1613,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/blaze/blaze/pulls/1581"},"html":{"href":"https://github.com/blaze/blaze/pull/1581"},"issue":{"href":"https://api.github.com/repos/blaze/blaze/issues/1581"},"comments":{"href":"https://api.github.com/repos/blaze/blaze/issues/1581/comments"},"review_comments":{"href":"https://api.github.com/repos/blaze/blaze/pulls/1581/comments"},"review_comment":{"href":"https://api.github.com/repos/blaze/blaze/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/blaze/blaze/pulls/1581/commits"},"statuses":{"href":"https://api.github.com/repos/blaze/blaze/statuses/782dbb4c7a85022270779fa7492c421b3d3fdc31"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"kwmsmith","id":288771,"avatar_url":"https://avatars.githubusercontent.com/u/288771?v=3","gravatar_id":"","url":"https://api.github.com/users/kwmsmith","html_url":"https://github.com/kwmsmith","followers_url":"https://api.github.com/users/kwmsmith/followers","following_url":"https://api.github.com/users/kwmsmith/following{/other_user}","gists_url":"https://api.github.com/users/kwmsmith/gists{/gist_id}","starred_url":"https://api.github.com/users/kwmsmith/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kwmsmith/subscriptions","organizations_url":"https://api.github.com/users/kwmsmith/orgs","repos_url":"https://api.github.com/users/kwmsmith/repos","events_url":"https://api.github.com/users/kwmsmith/events{/privacy}","received_events_url":"https://api.github.com/users/kwmsmith/received_events","type":"User","site_admin":false},"comments":3,"review_comments":0,"commits":1,"additions":24,"deletions":1,"changed_files":2}}
{"actor":{"display_login":"kwmsmith"}}