summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2020-02-26 14:09:02 +0100
committerErich Eckner <git@eckner.net>2020-02-26 14:09:02 +0100
commitaa640a0289438069270d12bc532636ba2ed4940e (patch)
treee4dc8296681068e3d32583639aa675be31b1d2ee
parent634286e569949aa0d32b1c282377f4ee997ea087 (diff)
downloadbuilder-aa640a0289438069270d12bc532636ba2ed4940e.tar.xz
bin/why-dont-you: fix query regarding stability
-rwxr-xr-xbin/why-dont-you4
1 files changed, 1 insertions, 3 deletions
diff --git a/bin/why-dont-you b/bin/why-dont-you
index 06edacb..9b50427 100755
--- a/bin/why-dont-you
+++ b/bin/why-dont-you
@@ -301,9 +301,7 @@ case "${action}" in
mysql_join_binary_packages_binary_packages_in_repositories 'itp_bp' 'itp_bpir'
mysql_join_binary_packages_in_repositories_repositories 'itp_bpir' 'itp_r'
printf ' AND `itp_r`.`architecture`=`repositories`.`architecture`'
- printf ' JOIN `repository_stability_relations`'
- printf ' ON `repository_stability_relations`.`more_stable`=`repositories`.`stability`'
- printf ' AND `repository_stability_relations`.`less_stable`=`itp_r`.`stability`'
+ printf ' AND `repositories`.`stability`=`itp_r`.`stability`'
printf ') AS `sub_q`'
printf ' GROUP BY `sub_q`.`id`;\n'