Großbuchstaben im Benutzernamen unterbrechen die Prüfung erreichbarer Erwähnungen im Composer

zogstrip · 23. April 2026 um 08:34

Die richtige Lösung ist

github.com/discourse/discourse

DEV: Use ActiveRecord normalizes for username lookups (#37177)

main ← fix/unicode-username-lookups

closed 02:15AM - 14 Apr 26 UTC

ZogStriP

+159 -164

Leverages Rails' built-in `normalizes` feature to handle username normalization …consistently throughout the codebase. When you call `User.where(username_lower: value)` or `find_by(username_lower: value)`, ActiveRecord now automatically normalizes the input value. Key changes: - Adds `normalizes :username` (unicode normalize) and `normalizes :username_lower` (unicode normalize + downcase) to User - Adds `normalizes :email` (strip + downcase) to UserEmail - Removes manual `.downcase` and `.map(&:downcase)` calls before AR queries - Adds `User#matches_username?` method for comparing usernames - Simplifies `filter_by_username` and `filter_by_username_or_email` scopes to use `ILIKE ANY(ARRAY[?])` instead of branching on array vs single value - Updates `filter_by_username` to normalize input for ILIKE patterns - Updates `find_by_username` to rely on AR normalization - Fixes a SQL injection vulnerability in search user ordering - Uses before_save callback for username_lower assignment to ensure it runs even when validation is skipped (e.g., finish installation flow) - Adds shoulda matcher tests for username normalizations The `normalize_username` class method is kept for cases where AR can't help: raw SQL queries, ILIKE patterns, and direct comparisons. Ref - https://meta.discourse.org/t/393646

aber das ist eine zu große Änderung, als dass ich sie im Moment gerne zusammenführen würde

Stattdessen werde ich die „Endpunkte

Thema		Antworten	Aufrufe
Preview is changing casing of @ mentions Bug	2	887	15. Juni 2015
Rich editor misses usernames with umlauts Bug composer	4	199	1. August 2025
Unicode username with Σ as the final char leads to an error loading profile page Bug	36	2334	23. Februar 2021
Discobot case-sensitive mentions Bug	3	602	7. Mai 2019
Capitalization does not match when you open user cards using mentions Bug	13	1023	3. Mai 2022

Großbuchstaben im Benutzernamen unterbrechen die Prüfung erreichbarer Erwähnungen im Composer

Verwandte Themen