{"action":"created","issue":{"url":"https://api.github.com/repos/facebook/osquery/issues/1482","labels_url":"https://api.github.com/repos/facebook/osquery/issues/1482/labels{/name}","comments_url":"https://api.github.com/repos/facebook/osquery/issues/1482/comments","events_url":"https://api.github.com/repos/facebook/osquery/issues/1482/events","html_url":"https://github.com/facebook/osquery/issues/1482","id":104280640,"number":1482,"title":"Query returns wrong values for ambiguos column names","user":{"login":"rafaelgarrido","id":491296,"avatar_url":"https://avatars.githubusercontent.com/u/491296?v=3","gravatar_id":"","url":"https://api.github.com/users/rafaelgarrido","html_url":"https://github.com/rafaelgarrido","followers_url":"https://api.github.com/users/rafaelgarrido/followers","following_url":"https://api.github.com/users/rafaelgarrido/following{/other_user}","gists_url":"https://api.github.com/users/rafaelgarrido/gists{/gist_id}","starred_url":"https://api.github.com/users/rafaelgarrido/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rafaelgarrido/subscriptions","organizations_url":"https://api.github.com/users/rafaelgarrido/orgs","repos_url":"https://api.github.com/users/rafaelgarrido/repos","events_url":"https://api.github.com/users/rafaelgarrido/events{/privacy}","received_events_url":"https://api.github.com/users/rafaelgarrido/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/facebook/osquery/labels/wont%20fix","name":"wont fix","color":"ffffff"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-09-01T14:36:01Z","updated_at":"2015-09-01T23:47:02Z","closed_at":"2015-09-01T17:16:56Z","body":"Column name from table processes is being replaced by etc_protocols.name:\r\n\r\n```\r\nosquery> select lp.pid, lp.port, lp.address, p.name, pr.name from listening_ports lp inner join processes p on lp.pid = p.pid inner join etc_protocols pr on lp.protocol = pr.number;\r\n+-------+-------+--------------+------+------+\r\n| pid   | port  | address      | name | name |\r\n+-------+-------+--------------+------+------+\r\n| 63    | 0     |              | ip   | ip   |\r\n| 293   | 0     | 0.0.0.0      | udp  | udp  |\r\n| 3138  | 0     | 0.0.0.0      | tcp  | tcp  |\r\n| 6296  | 17500 | 0.0.0.0      | udp  | udp  |\r\n+-------+-------+--------------+------+------+\r\n```"},"comment":{"url":"https://api.github.com/repos/facebook/osquery/issues/comments/136893894","html_url":"https://github.com/facebook/osquery/issues/1482#issuecomment-136893894","issue_url":"https://api.github.com/repos/facebook/osquery/issues/1482","id":136893894,"user":{"login":"marpaia","id":927168,"avatar_url":"https://avatars.githubusercontent.com/u/927168?v=3","gravatar_id":"","url":"https://api.github.com/users/marpaia","html_url":"https://github.com/marpaia","followers_url":"https://api.github.com/users/marpaia/followers","following_url":"https://api.github.com/users/marpaia/following{/other_user}","gists_url":"https://api.github.com/users/marpaia/gists{/gist_id}","starred_url":"https://api.github.com/users/marpaia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marpaia/subscriptions","organizations_url":"https://api.github.com/users/marpaia/orgs","repos_url":"https://api.github.com/users/marpaia/repos","events_url":"https://api.github.com/users/marpaia/events{/privacy}","received_events_url":"https://api.github.com/users/marpaia/received_events","type":"User","site_admin":false},"created_at":"2015-09-01T23:47:02Z","updated_at":"2015-09-01T23:47:02Z","body":"That being said, in a perfect world, we would gracefully handle that error case, sure."}}