CREATE TEMPORARY TABLE `replaced_bpir` (`id` BIGINT, UNIQUE KEY (`id`));
CREATE TEMPORARY TABLE `moved_bpir` (`id` BIGINT, `new_repository` MEDIUMINT, UNIQUE KEY (`id`));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.was_insane_query.2023-02-25T13:25:58.5YZ7M9.infile.1" INTO TABLE `moved_bpir` COLUMNS TERMINATED BY " ";
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.was_insane_query.2023-02-25T13:25:58.5YZ7M9.infile.2" INTO TABLE `replaced_bpir` COLUMNS TERMINATED BY " ";
DELETE `binary_packages_in_repositories` FROM `binary_packages_in_repositories` JOIN `replaced_bpir` ON `binary_packages_in_repositories`.`id`=`replaced_bpir`.`id`;
SELECT CONCAT("pool/",CONCAT(`binary_packages`.`pkgname`,"-",IF(`binary_packages`.`epoch`=0,"",CONCAT(`binary_packages`.`epoch`,":")),`binary_packages`.`pkgver`,"-",`binary_packages`.`pkgrel`,IF(`binary_packages`.`sub_pkgrel_omitted`,"",CONCAT(".",`binary_packages`.`sub_pkgrel`)),"-",`architectures`.`name`,".pkg.",IF(`compressions`.`suffix` IS NULL,"tar.zst",`compressions`.`suffix`))) FROM `binary_packages` JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` LEFT JOIN `compressions` ON `binary_packages`.`compression`=`compressions`.`id` WHERE NOT EXISTS (SELECT 1 FROM `binary_packages_in_repositories` WHERE `binary_packages_in_repositories`.`package`=`binary_packages`.`id`);
DELETE `binary_packages` FROM `binary_packages` WHERE NOT EXISTS (SELECT 1 FROM `binary_packages_in_repositories` WHERE `binary_packages_in_repositories`.`package`=`binary_packages`.`id`);
UPDATE `binary_packages_in_repositories` JOIN `moved_bpir` ON `binary_packages_in_repositories`.`id`=`moved_bpir`.`id` SET `binary_packages_in_repositories`.`repository`=`moved_bpir`.`new_repository`,`binary_packages_in_repositories`.`last_moved`=NOW() WHERE `binary_packages_in_repositories`.`repository`!=`moved_bpir`.`new_repository`;