diff options
| author | Erich Eckner <git@eckner.net> | 2020-02-26 14:09:02 +0100 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2020-02-26 14:09:02 +0100 |
| commit | aa640a0289438069270d12bc532636ba2ed4940e (patch) | |
| tree | e4dc8296681068e3d32583639aa675be31b1d2ee | |
| parent | 634286e569949aa0d32b1c282377f4ee997ea087 (diff) | |
| download | builder-aa640a0289438069270d12bc532636ba2ed4940e.tar.xz | |
bin/why-dont-you: fix query regarding stability
| -rwxr-xr-x | bin/why-dont-you | 4 |
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' |