commit 03d6a1a0305548d7c5b548feb905cb5c9525d266 Author: Karsten Loesing <karsten.loesing@gmx.net> Date: Fri Mar 8 15:19:22 2019 +0100 Make userstats-combined.csv order platform independent. Turns out that we didn't specify the sorting order of userstats-combined.csv. However, different platforms produced consistently different outputs. Let's just define sort order to make the output deterministic, even across platforms. --- src/main/sql/clients/init-userstats.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/main/sql/clients/init-userstats.sql b/src/main/sql/clients/init-userstats.sql index cf2b620..467f8aa 100644 --- a/src/main/sql/clients/init-userstats.sql +++ b/src/main/sql/clients/init-userstats.sql @@ -761,5 +761,5 @@ CREATE OR REPLACE VIEW combined AS SELECT AND a.date < current_date - 1 -- Order results. - ORDER BY date DESC; + ORDER BY date, node, country, LOWER(transport);