X-Git-Url: https://pd.if.org/git/?p=zpackage;a=blobdiff_plain;f=db.sql;h=a4a065161f3c972dde677be7fd5d4f73c4e2af2f;hp=1ad3d17e5da68361a998dc1ea5ab4bf7db44b90d;hb=63339873b48653db56a74dc6b08e73608d793bdf;hpb=7256198c4677c64fde0da2dc0bd14f29db799ca3 diff --git a/db.sql b/db.sql index 1ad3d17..a4a0651 100644 --- a/db.sql +++ b/db.sql @@ -427,8 +427,7 @@ md_conflict as ( on PA.package = PFA.package and PA.version = PFA.version and PA.release = PFA.release where PA.status in ('installing', 'installed') group by path - having (count(distinct - printf('%s:%s:%s:%s', PFA.filetype, PFA.mode, PFA.username, PFA.groupname) + having (count(distinct printf('%s:%s:%s:%s', PFA.filetype, PFA.mode, PFA.username, PFA.groupname) ) > 1 or count(distinct PFA.hash) > 1) ) select PFH.*,