CREATE TEMPORARY TABLE `bugs`(`bugtracker_category` VARCHAR(32),`pkgname` VARCHAR(64));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.unimportant_query.2023-01-23T16:55:13.9JEHMb.infile.1" INTO TABLE `bugs`;
UPDATE `binary_packages` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` JOIN `repository_stabilities` ON `repositories`.`stability`=`repository_stabilities`.`id` LEFT JOIN `bugs` ON `bugs`.`pkgname`=`binary_packages`.`pkgname` AND `bugs`.`bugtracker_category`=`repository_stabilities`.`bugtracker_category` SET `binary_packages`.`has_issues`=(`bugs`.`pkgname` IS NOT NULL);