{"action":"created","issue":{"url":"https://api.github.com/repos/django/django/issues/4240","labels_url":"https://api.github.com/repos/django/django/issues/4240/labels{/name}","comments_url":"https://api.github.com/repos/django/django/issues/4240/comments","events_url":"https://api.github.com/repos/django/django/issues/4240/events","html_url":"https://github.com/django/django/pull/4240","id":59917543,"number":4240,"title":"Fixed #24171 -- failure with complex aggregate query and expressions","user":{"login":"akaariai","id":125285,"avatar_url":"https://avatars.githubusercontent.com/u/125285?v=3","gravatar_id":"","url":"https://api.github.com/users/akaariai","html_url":"https://github.com/akaariai","followers_url":"https://api.github.com/users/akaariai/followers","following_url":"https://api.github.com/users/akaariai/following{/other_user}","gists_url":"https://api.github.com/users/akaariai/gists{/gist_id}","starred_url":"https://api.github.com/users/akaariai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akaariai/subscriptions","organizations_url":"https://api.github.com/users/akaariai/orgs","repos_url":"https://api.github.com/users/akaariai/repos","events_url":"https://api.github.com/users/akaariai/events{/privacy}","received_events_url":"https://api.github.com/users/akaariai/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-05T07:56:33Z","updated_at":"2015-03-09T11:52:32Z","closed_at":"2015-03-09T11:52:32Z","pull_request":{"url":"https://api.github.com/repos/django/django/pulls/4240","html_url":"https://github.com/django/django/pull/4240","diff_url":"https://github.com/django/django/pull/4240.diff","patch_url":"https://github.com/django/django/pull/4240.patch"},"body":"The query used a construct of qs.annotate().values().aggregate() where\r\nthe first annotate used an F-object reference, and the .values() and\r\n.aggregate() calls referenced that F-object.\r\n\r\nAlso made sure the inner query's select clause is as simple as possible,\r\nand made sure .values().distinct().aggreate() works correctly."},"comment":{"url":"https://api.github.com/repos/django/django/issues/comments/77840226","html_url":"https://github.com/django/django/pull/4240#issuecomment-77840226","issue_url":"https://api.github.com/repos/django/django/issues/4240","id":77840226,"user":{"login":"timgraham","id":411869,"avatar_url":"https://avatars.githubusercontent.com/u/411869?v=3","gravatar_id":"","url":"https://api.github.com/users/timgraham","html_url":"https://github.com/timgraham","followers_url":"https://api.github.com/users/timgraham/followers","following_url":"https://api.github.com/users/timgraham/following{/other_user}","gists_url":"https://api.github.com/users/timgraham/gists{/gist_id}","starred_url":"https://api.github.com/users/timgraham/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timgraham/subscriptions","organizations_url":"https://api.github.com/users/timgraham/orgs","repos_url":"https://api.github.com/users/timgraham/repos","events_url":"https://api.github.com/users/timgraham/events{/privacy}","received_events_url":"https://api.github.com/users/timgraham/received_events","type":"User","site_admin":false},"created_at":"2015-03-09T11:52:32Z","updated_at":"2015-03-09T11:52:32Z","body":"merged in fb146193c49e4c683dc8da39d9b7c479375fdb57, thanks!"}}