From 39604afb4287f3e9cbfb69c0975d760b32488f6b Mon Sep 17 00:00:00 2001
From: vainsocial <vainsocial@prod>
Date: Sat, 13 Jan 2018 11:04:13 +0000
Subject: fix surrender being summed with null

---
 crunch_global.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'crunch_global.sql')

diff --git a/crunch_global.sql b/crunch_global.sql
index b9ba013..366549c 100644
--- a/crunch_global.sql
+++ b/crunch_global.sql
@@ -16,7 +16,7 @@ select
     -- everything added here needs to be in on DUPLICATE too!!!
     count(p.id) as played,
     sum(cast(p.winner as INT)) as wins,
-    sum(p.trueskill_delta) as trueskill_delta,
+    sum(coalesce(p.trueskill_delta)) as trueskill_delta,
     sum(p_s.duration) as time_spent,
     sum(p_s.kills) as kills,
     sum(p_s.deaths) as deaths,
@@ -30,8 +30,8 @@ select
     sum(p_s.kraken_captures) as kraken_captures,
     sum(p_s.turret_captures) as turret_captures,
     sum(p_s.gold) as gold,
-    sum(p_s.impact_score) as impact_score,
-    sum(p_i.surrender) as surrender,
+    round(sum(p_s.impact_score)) as impact_score,
+    sum(coalesce(p_i.surrender, 0)) as surrender,
     _p_i_item_uses_insert
 from participant p
 join participant_stats p_s on (p_s.participant_api_id = p.api_id)
-- 
cgit v1.3.1

