summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-04-20 11:42:15 +0200
committerErich Eckner <git@eckner.net>2018-04-20 11:42:15 +0200
commit7e3abadb0226a3bb0b9eef60bd5120171da6e9f0 (patch)
tree45d32f229e820feeea8838570e3d101777366297
parent9e5f7e2a1a624af8e276394e675c8a5a674fade6 (diff)
downloadarchweb32-7e3abadb0226a3bb0b9eef60bd5120171da6e9f0.tar.xz
buildmaster/build-list.php: fix style in some queries
-rw-r--r--buildmaster/build-list.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/buildmaster/build-list.php b/buildmaster/build-list.php
index b1aa94e..0b6912e 100644
--- a/buildmaster/build-list.php
+++ b/buildmaster/build-list.php
@@ -28,8 +28,8 @@ $result = mysql_run_query(
"`upstream_repositories`.`name` AS `package_repository`," .
"`git_repositories`.`name` AS `git_repository`," .
"`architectures`.`name` AS `arch`," .
- "EXISTS (SELECT * " .
- "FROM `binary_packages` `broken_bin` " .
+ "EXISTS (SELECT 1 " .
+ "FROM `binary_packages` AS `broken_bin` " .
"JOIN `dependencies` ON `dependencies`.`dependent` = `broken_bin`.`id` " .
"JOIN `install_target_providers` ON `install_target_providers`.`install_target` = `dependencies`.`depending_on` " .
"JOIN `binary_packages` `to_be_built` ON `to_be_built`.`id` = `install_target_providers`.`package` " .
@@ -38,7 +38,7 @@ $result = mysql_run_query(
"AND `repositories`.`name`=\"build-list\" " .
"AND `to_be_built`.`build_assignment`!=`build_assignments`.`id`" .
") AS `dependencies_pending`," .
- "(SELECT count(*) " .
+ "(SELECT count(1) " .
"FROM `build_dependency_loops` " .
"WHERE `build_dependency_loops`.`build_assignment`=`build_assignments`.`id`" .
") AS `loops`, " .