diff options
| author | Erich Eckner <git@eckner.net> | 2018-06-12 09:54:21 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-06-12 09:54:21 +0200 |
| commit | 69ab1ebf3c53bc552a489a439b5d316c8ce1745b (patch) | |
| tree | e4cc28189f1dbcec54fa53307d0f2b2ad0f0071e | |
| parent | 27e7f02c6bd5a18c19aeed6b609b12edf45f9d00 (diff) | |
| download | archweb32-69ab1ebf3c53bc552a489a439b5d316c8ce1745b.tar.xz | |
buildmaster/mysql-issues.php: packages may be hidden
| -rw-r--r-- | buildmaster/mysql-issues.php | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/buildmaster/mysql-issues.php b/buildmaster/mysql-issues.php index 97eea84..6547a34 100644 --- a/buildmaster/mysql-issues.php +++ b/buildmaster/mysql-issues.php @@ -92,6 +92,17 @@ " JOIN `repository_stability_relations` ON `prov_r`.`stability`=`repository_stability_relations`.`more_stable`" . " WHERE `install_target_providers`.`install_target` = `dependencies`.`depending_on`" . " AND `repositories`.`stability`=`repository_stability_relations`.`less_stable`" . + " AND NOT EXISTS (" . + "SELECT 1 FROM `binary_packages` AS `sup_bp`" . + " JOIN `binary_packages_in_repositories` AS `sup_bpir` ON `sup_bp`.`id`=`sup_bpir`.`package`" . + " JOIN `repositories` AS `sup_r` ON `sup_bpir`.`repository`=`sup_r`.`id`" . + " JOIN `repository_stability_relations` AS `sup_rra` ON `sup_r`.`stability`=`sup_rra`.`more_stable`" . + " JOIN `repository_stability_relations` AS `sup_rrb` ON `sup_r`.`stability`=`sup_rrb`.`less_stable`" . + " WHERE `sup_bp`.`pkgname` = `prov_bp`.`pkgname`" . + " AND `sup_bp`.`id` != `prov_bp`.`id`" . + " AND `repositories`.`stability`=`sup_rra`.`less_stable`" . + " AND `prov_r`.`stability`=`sup_rrb`.`more_stable`" . + ")" . ")" . $ignore . " ORDER BY `binary_packages_in_repositories`.`is_to_be_deleted`,`binary_packages`.`pkgname`,`install_targets`.`name`" |