Skip to content

fix name duplication with lower/upper case in new models

Vincent Mora requested to merge fix_duplicated_name_case into master

@marjorie.dranguet j'ai modifié la fonction qui vérifie les noms dupliqués quand tu selectionnes l'option dans metadata

Je ne sais pas encore où mettre la mise à jour pour les modèles existants, en plus la vérification ralentie la base...

create or replace function ___.duplicated_names()
returns varchar
language sql as
$$
    with counted as (
        select upper(name) as name, model, count(1) ct
        from (
            select name, model from ___.node
            union all
            select s.name, n.model from ___.singularity s join ___.node n on n.id=s.id
            union all
            select l.name, n.model from ___.link l join ___.node n on n.id=l.up
            ) t
        group by upper(name), model
    )
    select string_agg(name, ', ') from counted where ct > 1;
$$
;

Merge request reports