{"action":"created","issue":{"url":"https://api.github.com/repos/pingcap/tidb/issues/179","labels_url":"https://api.github.com/repos/pingcap/tidb/issues/179/labels{/name}","comments_url":"https://api.github.com/repos/pingcap/tidb/issues/179/comments","events_url":"https://api.github.com/repos/pingcap/tidb/issues/179/events","html_url":"https://github.com/pingcap/tidb/issues/179","id":106902877,"number":179,"title":"having for aggregate field alias name bug ","user":{"login":"siddontang","id":1080370,"avatar_url":"https://avatars.githubusercontent.com/u/1080370?v=3","gravatar_id":"","url":"https://api.github.com/users/siddontang","html_url":"https://github.com/siddontang","followers_url":"https://api.github.com/users/siddontang/followers","following_url":"https://api.github.com/users/siddontang/following{/other_user}","gists_url":"https://api.github.com/users/siddontang/gists{/gist_id}","starred_url":"https://api.github.com/users/siddontang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/siddontang/subscriptions","organizations_url":"https://api.github.com/users/siddontang/orgs","repos_url":"https://api.github.com/users/siddontang/repos","events_url":"https://api.github.com/users/siddontang/events{/privacy}","received_events_url":"https://api.github.com/users/siddontang/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pingcap/tidb/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"qiuyesuifeng","id":1953644,"avatar_url":"https://avatars.githubusercontent.com/u/1953644?v=3","gravatar_id":"","url":"https://api.github.com/users/qiuyesuifeng","html_url":"https://github.com/qiuyesuifeng","followers_url":"https://api.github.com/users/qiuyesuifeng/followers","following_url":"https://api.github.com/users/qiuyesuifeng/following{/other_user}","gists_url":"https://api.github.com/users/qiuyesuifeng/gists{/gist_id}","starred_url":"https://api.github.com/users/qiuyesuifeng/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/qiuyesuifeng/subscriptions","organizations_url":"https://api.github.com/users/qiuyesuifeng/orgs","repos_url":"https://api.github.com/users/qiuyesuifeng/repos","events_url":"https://api.github.com/users/qiuyesuifeng/events{/privacy}","received_events_url":"https://api.github.com/users/qiuyesuifeng/received_events","type":"User","site_admin":false},"milestone":null,"comments":6,"created_at":"2015-09-17T03:00:00Z","updated_at":"2015-10-20T17:50:18Z","closed_at":null,"body":"```\r\ncreate table t1 (a int, b int) engine=innodb;\r\ninsert into t1 values (1,2), (1,3), (2,3), (2,4), (2,5), (3,4), (4,5), (4,100);\r\n\r\nmysql> select a, sum(b) as b from t1 group by a having b > 4;\r\n+------+------+\r\n| a    | b    |\r\n+------+------+\r\n|    1 |    5 |\r\n|    2 |   12 |\r\n|    4 |  105 |\r\n+------+------+\r\n```\r\n\r\nbut we only get one row result. \r\n"},"comment":{"url":"https://api.github.com/repos/pingcap/tidb/issues/comments/149645982","html_url":"https://github.com/pingcap/tidb/issues/179#issuecomment-149645982","issue_url":"https://api.github.com/repos/pingcap/tidb/issues/179","id":149645982,"user":{"login":"xwb1989","id":1270701,"avatar_url":"https://avatars.githubusercontent.com/u/1270701?v=3","gravatar_id":"","url":"https://api.github.com/users/xwb1989","html_url":"https://github.com/xwb1989","followers_url":"https://api.github.com/users/xwb1989/followers","following_url":"https://api.github.com/users/xwb1989/following{/other_user}","gists_url":"https://api.github.com/users/xwb1989/gists{/gist_id}","starred_url":"https://api.github.com/users/xwb1989/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xwb1989/subscriptions","organizations_url":"https://api.github.com/users/xwb1989/orgs","repos_url":"https://api.github.com/users/xwb1989/repos","events_url":"https://api.github.com/users/xwb1989/events{/privacy}","received_events_url":"https://api.github.com/users/xwb1989/received_events","type":"User","site_admin":false},"created_at":"2015-10-20T17:50:18Z","updated_at":"2015-10-20T17:50:18Z","body":"Thank you for letting me know :)"}}