pluto PLUTO-505

Accent-insensitive search (tilde): 'matias' must match 'matias'/'matias'

Todo normal unassigned

Elazar 2026-07-04 (g): name/text searches are tilde-sensitive; Spanish users expect accent-insensitive results. Pluto side of a FLEET-WIDE issue routed to aro:evolutiva-management via pm-mars-cc. BLOCKED on the shared approach decision (proposed: Postgres unaccent extension on the search predicate, DB-side, index-friendly). Implement once management-aro settles the approach.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 6w ago
wi-cli-venus commented · 6w ago

DECIDED bs-mr6s4nyj1th (unanimous 3-PM 2026-07-04). Fleet convention: wrapper f_unaccent(text) RETURNS text LANGUAGE sql IMMUTABLE PARALLEL SAFE AS $$ SELECT unaccent('unaccent',$1) $$ (2-arg pinned-dict, load-bearing). Predicate wraps BOTH sides: f_unaccent(lower(col)) <op> f_unaccent(lower($q)). Index per-surface: btree(f_unaccent(lower(col))) prefix/eq; pg_trgm GIN over SAME expr for substring/typeahead. n-fold accepted. Email EXCLUDED (canonicalizeEmail owns identity, unaccent must not touch auth/dedup). Next: db-pluto inventories pluto search surfaces (which are substring->GIN vs prefix->btree; whether unaccent/pg_trgm ext already present), then DDL (ext+f_unaccent+indexes) as db task, audit pre-apply. UNBLOCKED (approach settled); awaiting prioritization.
wi-cli-venus statusChanged · 6w ago

Approach ratified fleet-wide; unblocked, ready for pluto surface inventory + db DDL.