summary refs log tree commit diff
path: root/synapse
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2019-10-29 11:41:27 +0000
committerErik Johnston <erik@matrix.org>2019-10-29 11:41:27 +0000
commite419c44ba4e0247d4c68f95c1c5ecdb2d854bea8 (patch)
tree2cea3052728d5b62bb29b63255b20b7cb060067c /synapse
parentAdd CI for synapse_port_db (#6140) (diff)
parentMerge pull request #6268 from matrix-org/erikj/case_insensitive_room_dir (diff)
downloadsynapse-e419c44ba4e0247d4c68f95c1c5ecdb2d854bea8.tar.xz
Merge branch 'release-v1.5.0' of github.com:matrix-org/synapse into develop
Diffstat (limited to 'synapse')
-rw-r--r--synapse/storage/data_stores/main/room.py12
1 files changed, 8 insertions, 4 deletions
diff --git a/synapse/storage/data_stores/main/room.py b/synapse/storage/data_stores/main/room.py

index 4428e5c55d..67bb1b6f60 100644 --- a/synapse/storage/data_stores/main/room.py +++ b/synapse/storage/data_stores/main/room.py
@@ -201,13 +201,17 @@ class RoomWorkerStore(SQLBaseStore): where_clauses.append( """ ( - name LIKE ? - OR topic LIKE ? - OR canonical_alias LIKE ? + LOWER(name) LIKE ? + OR LOWER(topic) LIKE ? + OR LOWER(canonical_alias) LIKE ? ) """ ) - query_args += [search_term, search_term, search_term] + query_args += [ + search_term.lower(), + search_term.lower(), + search_term.lower(), + ] where_clause = "" if where_clauses: