summaryrefslogtreecommitdiff
path: root/buildmaster
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-06-12 08:36:08 +0200
committerErich Eckner <git@eckner.net>2018-06-12 08:36:08 +0200
commit27e7f02c6bd5a18c19aeed6b609b12edf45f9d00 (patch)
tree87806de6d3271950ee67b3db73dbbdfb65a25481 /buildmaster
parent48d9c19cedc9c5506815e7e56a53a43324419fab (diff)
downloadarchweb32-27e7f02c6bd5a18c19aeed6b609b12edf45f9d00.tar.xz
buildmaster/mysql-issues.php: "exists (select * ...)" -> "exists (select 1 ...)"
Diffstat (limited to 'buildmaster')
-rw-r--r--buildmaster/mysql-issues.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/buildmaster/mysql-issues.php b/buildmaster/mysql-issues.php
index 684c44c..97eea84 100644
--- a/buildmaster/mysql-issues.php
+++ b/buildmaster/mysql-issues.php
@@ -43,7 +43,7 @@
" AND `subst_buildlist_r`.`name`=\"build-list\"".
") ON `subst_buildlist_bp`.`pkgname`=`binary_packages`.`pkgname`" .
" WHERE NOT EXISTS (" .
- "SELECT * FROM `install_target_providers`" .
+ "SELECT 1 FROM `install_target_providers`" .
" WHERE `install_target_providers`.`install_target` = `dependencies`.`depending_on`" .
")" .
$ignore .
@@ -81,11 +81,11 @@
" JOIN `install_targets` ON `dependencies`.`depending_on`=`install_targets`.`id`" .
" JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id`" .
" WHERE EXISTS (" .
- "SELECT * FROM `install_target_providers`" .
+ "SELECT 1 FROM `install_target_providers`" .
" WHERE `install_target_providers`.`install_target` = `dependencies`.`depending_on`" .
")" .
" AND NOT EXISTS (" .
- "SELECT * FROM `install_target_providers`" .
+ "SELECT 1 FROM `install_target_providers`" .
" JOIN `binary_packages` AS `prov_bp` ON `prov_bp`.`id`=`install_target_providers`.`package`" .
" JOIN `binary_packages_in_repositories` AS `prov_bpir` ON `prov_bp`.`id`=`prov_bpir`.`package`" .
" JOIN `repositories` AS `prov_r` ON `prov_bpir`.`repository`=`prov_r`.`id`" .