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

1 files changed, 4 insertions, 0 deletions

diff --git a/bin/return-assignment b/bin/return-assignment
index c8c6ecf..d9ba283 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -758,6 +758,8 @@ find . -maxdepth 1 -name '*.pkg.tar.xz' -printf '%f\n' > \
   mysql_package_name_query
   printf ' FROM `binary_packages`'
   mysql_join_binary_packages_architectures
+  printf ' LEFT'
+  mysql_join_binary_packages_compressions
   mysql_join_binary_packages_binary_packages_in_repositories
   printf ' WHERE `binary_packages`.`build_assignment`=from_base64("%s")' \
     "$(
@@ -820,6 +822,8 @@ fi
   printf ' AND `binary_packages_in_repositories`.`repository`=%s' \
     "${repository_ids__any_build_list}"
   mysql_join_binary_packages_architectures
+  printf ' LEFT'
+  mysql_join_binary_packages_compressions
   mysql_join_build_assignments_package_sources
   mysql_join_package_sources_upstream_repositories
   mysql_join_upstream_repositories_repository_moves