{"action":"created","issue":{"url":"https://api.github.com/repos/o1lab/xmysql/issues/24","repository_url":"https://api.github.com/repos/o1lab/xmysql","labels_url":"https://api.github.com/repos/o1lab/xmysql/issues/24/labels{/name}","comments_url":"https://api.github.com/repos/o1lab/xmysql/issues/24/comments","events_url":"https://api.github.com/repos/o1lab/xmysql/issues/24/events","html_url":"https://github.com/o1lab/xmysql/issues/24","id":294275585,"number":24,"title":"While joining two tables if some columns have same name then I am not able to select all column names (Only all unique column names are displaying in the output).","user":{"login":"shivsharma396","id":16001901,"avatar_url":"https://avatars1.githubusercontent.com/u/16001901?v=4","gravatar_id":"","url":"https://api.github.com/users/shivsharma396","html_url":"https://github.com/shivsharma396","followers_url":"https://api.github.com/users/shivsharma396/followers","following_url":"https://api.github.com/users/shivsharma396/following{/other_user}","gists_url":"https://api.github.com/users/shivsharma396/gists{/gist_id}","starred_url":"https://api.github.com/users/shivsharma396/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shivsharma396/subscriptions","organizations_url":"https://api.github.com/users/shivsharma396/orgs","repos_url":"https://api.github.com/users/shivsharma396/repos","events_url":"https://api.github.com/users/shivsharma396/events{/privacy}","received_events_url":"https://api.github.com/users/shivsharma396/received_events","type":"User","site_admin":false},"labels":[{"id":734533055,"url":"https://api.github.com/repos/o1lab/xmysql/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-05T05:12:03Z","updated_at":"2018-02-05T18:09:01Z","closed_at":null,"author_association":"NONE","body":"If I am using _fileds and trying to select columns which have the common name then also in the output only one column is displaying. Not getting the option to alias column name.\r\n**Example**:\r\n _Table1_ : User(id, name, email, city_id) \r\n_Table2_:  City(id, name)\r\n_query_: /api/xjoin?_join=u.user,_lj,c.city&_on1=(u.city_id,eq,c.id)&_fields=u.id,u.name,c.id,c.name\r\n_Output_:\r\n[{\r\nid: 1,\r\nname : \"xxx\"\r\n},{\r\nid : 2,\r\nname : \"yyy\"\r\n}]\r\n_Expected Output_:\r\n[{\r\nid: 1,\r\nname : \"xxx\",\r\nid: 1,\r\nname : \"city1\"\r\n},{\r\nid : 2,\r\nname : \"yyy\",\r\nid: 2,\r\nname : \"city2\"\r\n}]"},"comment":{"url":"https://api.github.com/repos/o1lab/xmysql/issues/comments/363169973","html_url":"https://github.com/o1lab/xmysql/issues/24#issuecomment-363169973","issue_url":"https://api.github.com/repos/o1lab/xmysql/issues/24","id":363169973,"user":{"login":"o1lab","id":5435402,"avatar_url":"https://avatars1.githubusercontent.com/u/5435402?v=4","gravatar_id":"","url":"https://api.github.com/users/o1lab","html_url":"https://github.com/o1lab","followers_url":"https://api.github.com/users/o1lab/followers","following_url":"https://api.github.com/users/o1lab/following{/other_user}","gists_url":"https://api.github.com/users/o1lab/gists{/gist_id}","starred_url":"https://api.github.com/users/o1lab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/o1lab/subscriptions","organizations_url":"https://api.github.com/users/o1lab/orgs","repos_url":"https://api.github.com/users/o1lab/repos","events_url":"https://api.github.com/users/o1lab/events{/privacy}","received_events_url":"https://api.github.com/users/o1lab/received_events","type":"User","site_admin":false},"created_at":"2018-02-05T18:09:01Z","updated_at":"2018-02-05T18:09:01Z","author_association":"OWNER","body":"\r\nHaving multiple keys with same name in an object wouldn't work.\r\n\r\nFixed Output will be in the lines of -\r\n\r\n```\r\nExpected Output:\r\n[{\r\nu_id: 1,\r\nu_name : \"xxx\",\r\nc_id: 1,\r\nc_name : \"city1\"\r\n},{\r\nu_id : 2,\r\nu_name : \"yyy\",\r\nc_id: 2,\r\nc_name : \"city2\"\r\n}]\r\n```\r\n\r\nwhere alias for tables getting joined ti.e u and c will be prepended with _\r\n\r\n"}}
{"actor":{"display_login":"o1lab"}}