lib/mysql-functions: mysql_package_name_query(): take compression suffix from database, default to "tar.xz" for now

1 files changed, 3 insertions, 1 deletions

diff --git a/lib/common-functions b/lib/common-functions
index 30b80a2..729cc46 100755
--- a/lib/common-functions
+++ b/lib/common-functions
@@ -163,7 +163,7 @@ remove_old_package_versions() {
         printf '`d_bp`.`pkgname`,'
         printf 'CONCAT(`d_ra`.`name`,"/",'
         printf '`d_r`.`name`,"/",'
-        mysql_package_name_query 'd_bp' 'd_bpa'
+        mysql_package_name_query 'd_bp' 'd_bpa' 'd_bpc'
         printf ')'
         printf ' FROM `binary_packages_in_repositories` AS `d_bpir`'
         mysql_join_binary_packages_in_repositories_binary_packages 'd_bpir' 'd_bp'
@@ -171,6 +171,8 @@ remove_old_package_versions() {
         printf ' AND `d_r`.`is_on_master_mirror`'
         mysql_join_repositories_architectures 'd_r' 'd_ra'
         mysql_join_binary_packages_architectures 'd_bp' 'd_bpa'
+        printf ' LEFT'
+        mysql_join_binary_packages_compressions 'd_bp' 'd_bpc'
         printf ' JOIN `binary_packages` AS `o_bp`'
         printf ' ON `d_bp`.`pkgname`=`o_bp`.`pkgname`'
         mysql_join_binary_packages_binary_packages_in_repositories 'o_bp' 'o_bpir'