Getting unexpected results when using multiple aggregates

[da...@joustco.com]

I'm using an aggregate query to gather some information and I'm getting unexpected results.

>>> show_assets.aggregate(media_size=Sum('assetmedia__size')){'media_size': 652475}>>> show_assets.aggregate(assets_size=Sum('size'), media_size=Sum('assetmedia__size'),thumb_size=Sum('assetthumb__size')){'assets_size': 17488245, 'media_size': 47630675, 'thumb_size': 582827}

Notice the difference in the "media_size" result when doing multiple aggregates. Is this the intended result or a bug?

[Simon Charette]

This is a know limitation.

Please see "Combining multiple aggregations"[1] in the documentation.

Cheers,
Simon

[1] https://docs.djangoproject.com/en/1.9/topics/db/aggregation/#combining-multiple-aggregations