From 45488e0ffae5100c3a82568642736aff203e1602 Mon Sep 17 00:00:00 2001
From: Erik Johnston <erik@matrix.org>
Date: Fri, 29 Jan 2016 14:42:01 +0000
Subject: Max is not a function

---
 synapse/storage/__init__.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/synapse/storage/__init__.py b/synapse/storage/__init__.py
index 2ed505cb1e..4d374a8b07 100644
--- a/synapse/storage/__init__.py
+++ b/synapse/storage/__init__.py
@@ -148,7 +148,7 @@ class DataStore(RoomMemberStore, RoomStore,
     def _get_cache_dict(self, db_conn, table, entity_column, stream_column, max_value):
         sql = (
             "SELECT %(entity)s, MAX(%(stream)s) FROM %(table)s"
-            " WHERE %(stream)s > max(? - 100000, 0)"
+            " WHERE %(stream)s > ? - 100000"
             " GROUP BY %(entity)s"
             " ORDER BY MAX(%(stream)s) DESC"
             " LIMIT 10000"
-- 
cgit 1.4.1