diff options
Diffstat (limited to 'bin/why-dont-you')
| -rwxr-xr-x | bin/why-dont-you | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/bin/why-dont-you b/bin/why-dont-you index a3c2aa2..9fb13f5 100755 --- a/bin/why-dont-you +++ b/bin/why-dont-you @@ -46,7 +46,8 @@ case "${action}" in printf '`to_build`.`baa_name`,' printf 'If(`to_build`.`is_broken`,1,0),' printf '(' - printf 'SELECT COUNT(1) FROM `failed_builds`' + printf 'SELECT COUNT(1)' + printf ' FROM `failed_builds`' printf 'WHERE `failed_builds`.`build_assignment`=`to_build`.`ba_id`' printf ')' printf ',replace(to_base64(`%s`.`%s`),"\\n","")' \ @@ -98,7 +99,8 @@ case "${action}" in printf ') AS `deps`' printf ' ON `deps`.`dependent`=`to_build`.`bin_id`' # now we join with build slaves to see if someone builds this - printf ' LEFT JOIN `build_slaves` ON `build_slaves`.`currently_building`=`to_build`.`ba_id`' + printf ' LEFT JOIN `build_slaves`' + printf ' ON `build_slaves`.`currently_building`=`to_build`.`ba_id`' printf ';\n' } | \ mysql_run_query | \ @@ -315,7 +317,8 @@ case "${action}" in printf ' ON `rsr`.`more_stable`=`r_r`.`stability`' printf ' AND `rsr`.`less_stable`=`m_r`.`stability`' printf ' WHERE NOT EXISTS (' - printf 'SELECT 1 FROM `binary_packages_in_repositories` AS `subst_bpir`' + printf 'SELECT 1' + printf ' FROM `binary_packages_in_repositories` AS `subst_bpir`' mysql_join_binary_packages_in_repositories_repositories 'subst_bpir' 'subst_r' mysql_join_binary_packages_in_repositories_binary_packages 'subst_bpir' 'subst_bp' printf ' JOIN `repository_stability_relations` AS `rsr_a`' @@ -364,7 +367,9 @@ case "${action}" in printf ' FROM `install_targets`;\n' # create copy - printf 'INSERT INTO `knots_copy` SELECT * FROM `knots`;\n' + printf 'INSERT INTO `knots_copy`' + printf ' SELECT *' + printf ' FROM `knots`;\n' # "available" bpir requires available install_target printf 'INSERT INTO `edges` (`cause`,`impact`,`invert`)' |