diff options
| author | Erich Eckner <git@eckner.net> | 2018-04-20 11:42:15 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-04-20 11:42:15 +0200 |
| commit | 7e3abadb0226a3bb0b9eef60bd5120171da6e9f0 (patch) | |
| tree | 45d32f229e820feeea8838570e3d101777366297 /buildmaster | |
| parent | 9e5f7e2a1a624af8e276394e675c8a5a674fade6 (diff) | |
| download | archweb32-7e3abadb0226a3bb0b9eef60bd5120171da6e9f0.tar.xz | |
buildmaster/build-list.php: fix style in some queries
Diffstat (limited to 'buildmaster')
| -rw-r--r-- | buildmaster/build-list.php | 6 |
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`, " . |