summary refs log tree commit diff
path: root/synapse/storage
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2016-09-05 14:50:36 +0100
committerErik Johnston <erik@matrix.org>2016-09-05 14:50:36 +0100
commit373654c6354c04b08a6f4dcb0ff7fa9ccae02f55 (patch)
tree4b05a4558a196ee2c0e564ff3b3d5ff2e2f229dc /synapse/storage
parentCorrectly delete old state groups in purge history API (diff)
downloadsynapse-373654c6354c04b08a6f4dcb0ff7fa9ccae02f55.tar.xz
Comment about sqlite and WITH RECURSIVE
Diffstat (limited to 'synapse/storage')
-rw-r--r--synapse/storage/state.py4
1 files changed, 4 insertions, 0 deletions
diff --git a/synapse/storage/state.py b/synapse/storage/state.py
index ee8b763008..e790793370 100644
--- a/synapse/storage/state.py
+++ b/synapse/storage/state.py
@@ -209,6 +209,8 @@ class StateStore(SQLBaseStore):
             else:
                 return 0
         else:
+            # We don't use WITH RECURSIVE on sqlite3 as there are distributions
+            # that ship with an sqlite3 version that doesn't support it (e.g. wheezy)
             next_group = state_group
             count = 0
 
@@ -340,6 +342,8 @@ class StateStore(SQLBaseStore):
                     key = (row["type"], row["state_key"])
                     results[group][key] = row["event_id"]
         else:
+            # We don't use WITH RECURSIVE on sqlite3 as there are distributions
+            # that ship with an sqlite3 version that doesn't support it (e.g. wheezy)
             for group in groups:
                 group_tree = [group]
                 next_group = group