From 6c8bbce9c961b9876a93a8aac7e4b4276978ca59 Mon Sep 17 00:00:00 2001
From: Kapil Viren Ahuja <k.v.ahuja@gmail.com>
Date: Sat, 4 Mar 2017 12:40:09 +0530
Subject: Fixed the last match cols which was sending this job into a hung
 state without throwing any exception.

---
 queries/match.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'queries/match.sql')

diff --git a/queries/match.sql b/queries/match.sql
index 0b992f9..fc8ab7e 100644
--- a/queries/match.sql
+++ b/queries/match.sql
@@ -4,7 +4,7 @@ match.id AS "api_id",
 (match.data->'data'->'attributes'->>'createdAt')::timestamp as "created_at",
 (match.data->'data'->'attributes'->>'duration')::int AS "duration",
 match.data->'data'->'attributes'->>'gameMode' AS "game_mode",
-COALESCE(NULLIF(match.data->'data'->'attributes'->>'patch_version', '2.2'), '0') AS "patch_version",
+COALESCE(NULLIF(match.data->'data'->'attributes'->>'patch_version', ''), '2.2') AS "patch_version",
 match.data->'data'->'attributes'->>'shardId' AS "shard_id",
 match.data->'data'->'attributes'->'stats'->>'endGameReason' AS "end_game_reason",
 match.data->'data'->'attributes'->'stats'->>'queue' AS "queue",
-- 
cgit v1.3.1

