{"action":"created","issue":{"url":"https://api.github.com/repos/onyxfish/agate/issues/402","labels_url":"https://api.github.com/repos/onyxfish/agate/issues/402/labels{/name}","comments_url":"https://api.github.com/repos/onyxfish/agate/issues/402/comments","events_url":"https://api.github.com/repos/onyxfish/agate/issues/402/events","html_url":"https://github.com/onyxfish/agate/issues/402","id":118463613,"number":402,"title":"Merged table doesn't use only the first table's column names","user":{"login":"Kirkman","id":761387,"avatar_url":"https://avatars.githubusercontent.com/u/761387?v=3","gravatar_id":"","url":"https://api.github.com/users/Kirkman","html_url":"https://github.com/Kirkman","followers_url":"https://api.github.com/users/Kirkman/followers","following_url":"https://api.github.com/users/Kirkman/following{/other_user}","gists_url":"https://api.github.com/users/Kirkman/gists{/gist_id}","starred_url":"https://api.github.com/users/Kirkman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kirkman/subscriptions","organizations_url":"https://api.github.com/users/Kirkman/orgs","repos_url":"https://api.github.com/users/Kirkman/repos","events_url":"https://api.github.com/users/Kirkman/events{/privacy}","received_events_url":"https://api.github.com/users/Kirkman/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-23T20:18:03Z","updated_at":"2015-11-24T01:08:33Z","closed_at":null,"body":"The docs say when two tables are merged, \"The first table’s column names will be the ones which are used.\"\r\n\r\nI'm trying to build something using agate right now, and I'm finding this isn't true. When I merge two tables, it appears that each row keeps the column names it had in its source table.\r\n\r\nSo if I iterate over all rows in the merged table and print the row's keys, instead of all the keys being the same, I see something like this:\r\n\r\n\t('complaint_id', 'month_recorded', 'date', 'count', 'crime_code', 'district', 'crime_description', 'house_num', 'street', 'hood_code', 'x', 'y')\r\n\t('Complaint', 'CodedMonth', 'DateOccur', 'Count', 'Crime', 'District', 'Description', 'ILEADSAddress', 'ILEADSStreet', 'Neighborhood', 'XCoord', 'YCoord')\r\n\t...\r\n\r\nThis leads to key errors later when I try to use things like .where() or .select() on the merged table.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/onyxfish/agate/issues/comments/159119022","html_url":"https://github.com/onyxfish/agate/issues/402#issuecomment-159119022","issue_url":"https://api.github.com/repos/onyxfish/agate/issues/402","id":159119022,"user":{"login":"onyxfish","id":33046,"avatar_url":"https://avatars.githubusercontent.com/u/33046?v=3","gravatar_id":"","url":"https://api.github.com/users/onyxfish","html_url":"https://github.com/onyxfish","followers_url":"https://api.github.com/users/onyxfish/followers","following_url":"https://api.github.com/users/onyxfish/following{/other_user}","gists_url":"https://api.github.com/users/onyxfish/gists{/gist_id}","starred_url":"https://api.github.com/users/onyxfish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/onyxfish/subscriptions","organizations_url":"https://api.github.com/users/onyxfish/orgs","repos_url":"https://api.github.com/users/onyxfish/repos","events_url":"https://api.github.com/users/onyxfish/events{/privacy}","received_events_url":"https://api.github.com/users/onyxfish/received_events","type":"User","site_admin":false},"created_at":"2015-11-24T01:08:33Z","updated_at":"2015-11-24T01:08:33Z","body":"That sounds like a legit bug. I'll take a closer look."}}