Max is not a function

1 files changed, 1 insertions, 1 deletions

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"