529070 - Contributions statistics broken for individual contributions

Status: VERIFIED FIXED

(addons.mozilla.org Graveyard :: Statistics, defect)

Description

[Nick Nguyen [:osunick]]

As an admin, go to this page:

https://addons.mozilla.org/en-US/statistics/addon/201

Change the dropdown in the graph to "contributions" and the graph and table are empty.

Comment 1

[Wil Clouser [:clouserw]]

Attachment: lame sauce

aliases don't work in the WHERE clause.  Since this is a simple one, I just duplicated it from the SELECT.  These might be able to be optimized further, since an EXPLAIN says it's still touching a bunch more rows than it returns.

Comment 2

[Dave Dash [:davedash, :dd] (assign all bugs to mbrandt)]

Comment on attachment 412681 [details] [diff] [review]
lame sauce

yeah mysql is brilliantly inconsistent about aliases.

Comment 3

[Wil Clouser [:clouserw]]

r56155

QA:  This page has no CSV data on it (just a header) right now.  Once preview updates it'll have CSV data: https://preview.addons.mozilla.org/en-US/statistics/csv/201/contributions?group_by=date

Comment 4

[Stephen Donner [:stephend] Not actively reading bugmail]

https://preview.addons.mozilla.org/en-US/statistics/csv/201/contributions?group_by=date now has CSV data (while logged in).

Verified FIXED.

Comment 5

[Justin Scott [:fligtar]]

This bug was pushed live off-cycle tonight.