{"action":"created","issue":{"url":"https://api.github.com/repos/mysql/mysql-server/issues/30","labels_url":"https://api.github.com/repos/mysql/mysql-server/issues/30/labels{/name}","comments_url":"https://api.github.com/repos/mysql/mysql-server/issues/30/comments","events_url":"https://api.github.com/repos/mysql/mysql-server/issues/30/events","html_url":"https://github.com/mysql/mysql-server/pull/30","id":113138702,"number":30,"title":"Bug #46053 GROUPING() function for ROLLUP ","user":{"login":"jimmybupt","id":7762915,"avatar_url":"https://avatars.githubusercontent.com/u/7762915?v=3","gravatar_id":"","url":"https://api.github.com/users/jimmybupt","html_url":"https://github.com/jimmybupt","followers_url":"https://api.github.com/users/jimmybupt/followers","following_url":"https://api.github.com/users/jimmybupt/following{/other_user}","gists_url":"https://api.github.com/users/jimmybupt/gists{/gist_id}","starred_url":"https://api.github.com/users/jimmybupt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jimmybupt/subscriptions","organizations_url":"https://api.github.com/users/jimmybupt/orgs","repos_url":"https://api.github.com/users/jimmybupt/repos","events_url":"https://api.github.com/users/jimmybupt/events{/privacy}","received_events_url":"https://api.github.com/users/jimmybupt/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-10-24T05:40:19Z","updated_at":"2015-10-27T13:39:02Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/mysql/mysql-server/pulls/30","html_url":"https://github.com/mysql/mysql-server/pull/30","diff_url":"https://github.com/mysql/mysql-server/pull/30.diff","patch_url":"https://github.com/mysql/mysql-server/pull/30.patch"},"body":"Hi, I'm Zhe Dong (OCA). I added a native grouping() function as described in bug #46053.\r\n\r\nI confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.\r\n\r\nIntended behavior: \r\nThe grouping() function returns integer 1 if and only if its argument is a single column reference and the current row is a subtotal of the input column. It returns 0 in all other circumstance. \r\n"},"comment":{"url":"https://api.github.com/repos/mysql/mysql-server/issues/comments/151499543","html_url":"https://github.com/mysql/mysql-server/pull/30#issuecomment-151499543","issue_url":"https://api.github.com/repos/mysql/mysql-server/issues/30","id":151499543,"user":{"login":"mysql-oca-bot","id":11857597,"avatar_url":"https://avatars.githubusercontent.com/u/11857597?v=3","gravatar_id":"","url":"https://api.github.com/users/mysql-oca-bot","html_url":"https://github.com/mysql-oca-bot","followers_url":"https://api.github.com/users/mysql-oca-bot/followers","following_url":"https://api.github.com/users/mysql-oca-bot/following{/other_user}","gists_url":"https://api.github.com/users/mysql-oca-bot/gists{/gist_id}","starred_url":"https://api.github.com/users/mysql-oca-bot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mysql-oca-bot/subscriptions","organizations_url":"https://api.github.com/users/mysql-oca-bot/orgs","repos_url":"https://api.github.com/users/mysql-oca-bot/repos","events_url":"https://api.github.com/users/mysql-oca-bot/events{/privacy}","received_events_url":"https://api.github.com/users/mysql-oca-bot/received_events","type":"User","site_admin":false},"created_at":"2015-10-27T13:39:02Z","updated_at":"2015-10-27T13:39:02Z","body":"Hi, thank you for your contribution. Your code has been assigned to an internal queue. Please follow \nbug http://bugs.mysql.com/bug.php?id=46053 for updates.\nThanks"}}