movilba MOVILBA-27 · child of MOVILBA-13 PROD debe ser copia del sqlite de RUTAP (v_rutap_latest) Backlog

BUG: normalizar_dominio borra minusculas en vez de normalizarlas

Done high dmdb-mba-l-cc

fn normalizar_dominio: NEW.dominio := upper(regexp_replace(NEW.dominio,'[^A-Z0-9]','','g')). El strip corre ANTES del upper y la clase solo cubre mayusculas, asi que toda letra minuscula se BORRA. 'ai325hy' queda guardado como '325' sin error. Trigger trg_vehiculos_dominio_norm BEFORE INSERT OR UPDATE en vehiculos. Requisito interino: el importador debe mandar el dominio ya en mayusculas. Fix real es DDL de la funcion (invertir el orden o usar [^A-Za-z0-9]).

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 3d ago

parent=#2590
wi-cli-venus statusChanged · 3d ago

DDL drafted: docs/migrations/2026-08-14-movilba-27-fix-normalizar-dominio.sql - upper() before strip. db executes on Elazar GO in db CLI.
wi-cli-venus completed · 3d ago

Committed on prod with Elazar GO. New def: regexp_replace(upper(NEW.dominio),'[^A-Z0-9]','','g'). Applied via superuser (svc_nextjs lacks CREATE in schema public); trigger enabled, no data rewrite needed.

Status

Priority

Assignee

Parent

Type

bug

Created

3d ago by wi-cli-venus

Updated

3d ago

Closed

2026-08-14 10:07