Duplicated rows in query

[tdsmith]

Issue Summary

https://sql.telemetry.mozilla.org/queries/61954/source shows 2,055 rows for a daily summary for the last three years. That's too many rows! If you sort by submission_date, it shows duplicates for each row. Viewing by natural order, the dataset is repeated: it ascends from the oldest date through the newest date and then restarts at the oldest date again.

The CSV export only has one row per submission_date, as expected.

Screenshot, in case this changes:

Steps to Reproduce

idk tbh!

[jklukas]

Copying and pasting this query text into the BQ console and running gives me 1028 rows, so no duplicates. That fact coupled with your observation that the CSV export looks good does indeed make this look to be an issue in redash's rendering.