CREATE TEMPORARY TABLE `links`(`pkgname` VARCHAR(64),`architecture` VARCHAR(16),`epoch` MEDIUMINT,`pkgver` VARCHAR(64),`pkgrel` MEDIUMINT,`build_architecture` VARCHAR(16),`type` VARCHAR(16),`install_target_name` VARCHAR(128),`version_relation` VARCHAR(2),`install_target_epoch` MEDIUMINT,`install_target_version` VARCHAR(64));
LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.was_insane_query.2022-03-18T09:59:48.Am8gea.infile.1" INTO TABLE `links`;
SET @sub_pkgrel=(SELECT IFNULL(MAX(`binary_packages`.`sub_pkgrel`+IF(`binary_packages_in_repositories`.`repository` IN (9,11),0,1)),0) FROM `links` JOIN `architectures` ON `architectures`.`name`=`links`.`architecture` JOIN `binary_packages` ON `architectures`.`id`=`binary_packages`.`architecture` AND `binary_packages`.`pkgname`=`links`.`pkgname` AND `binary_packages`.`epoch`=`links`.`epoch` AND `binary_packages`.`pkgver`=`links`.`pkgver` AND `binary_packages`.`pkgrel`=`links`.`pkgrel` LEFT JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package`);
INSERT IGNORE INTO `build_assignments` (`package_source`,`architecture`) SELECT 411213,`architectures`.`id` FROM `links` JOIN `architectures` ON `architectures`.`name`=`links`.`build_architecture` WHERE `links`.`type`="arch";
DELETE `binary_packages` FROM `links` JOIN `architectures` ON `links`.`architecture`=`architectures`.`name` JOIN `architectures` AS `ba_a` ON `ba_a`.`name`=`links`.`build_architecture` JOIN `build_assignments` ON `ba_a`.`id`=`build_assignments`.`architecture` JOIN `binary_packages` ON `build_assignments`.`id`=`binary_packages`.`build_assignment` AND `binary_packages`.`pkgname`=`links`.`pkgname` AND `binary_packages`.`epoch`=`links`.`epoch` AND `binary_packages`.`pkgver`=`links`.`pkgver` AND `binary_packages`.`pkgrel`=`links`.`pkgrel` AND `binary_packages`.`sub_pkgrel`=@sub_pkgrel AND `binary_packages`.`architecture`=`architectures`.`id` WHERE `links`.`type`="arch" AND NOT EXISTS(SELECT 1 FROM `binary_packages_in_repositories` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` WHERE `repositories`.`is_on_master_mirror` AND `binary_packages_in_repositories`.`package`=`binary_packages`.`id`);
INSERT IGNORE INTO `binary_packages` (`build_assignment`,`pkgname`,`epoch`,`pkgver`,`pkgrel`,`sub_pkgrel`,`architecture`,`compression`) SELECT `build_assignments`.`id`,`links`.`pkgname`,`links`.`epoch`,`links`.`pkgver`,`links`.`pkgrel`,@sub_pkgrel,`architectures`.`id`,8 FROM `links` JOIN `architectures` ON `links`.`architecture`=`architectures`.`name` JOIN `architectures` AS `ba_a` ON `ba_a`.`name`=`links`.`build_architecture` JOIN `build_assignments` ON `ba_a`.`id`=`build_assignments`.`architecture` AND `build_assignments`.`package_source`=411213 WHERE `links`.`type`="arch";
INSERT IGNORE INTO `binary_packages_in_repositories` ( `package`,`repository`) SELECT `binary_packages`.`id`,9 FROM `links` JOIN `architectures` ON `architectures`.`name`=`links`.`architecture` JOIN `binary_packages` ON `architectures`.`id`=`binary_packages`.`architecture` AND `binary_packages`.`sub_pkgrel`=@sub_pkgrel AND `binary_packages`.`pkgname`=`links`.`pkgname` AND `binary_packages`.`epoch`=`links`.`epoch` AND `binary_packages`.`pkgver`=`links`.`pkgver` AND `binary_packages`.`pkgrel`=`links`.`pkgrel`;
DELETE `binary_packages_in_repositories` FROM `links` JOIN `architectures` ON `architectures`.`name`=`links`.`architecture` JOIN `binary_packages` ON `architectures`.`id`=`binary_packages`.`architecture` AND `binary_packages`.`pkgname`=`links`.`pkgname` AND (`binary_packages`.`sub_pkgrel`!=@sub_pkgrel OR `binary_packages`.`epoch`!=`links`.`epoch` OR `binary_packages`.`pkgver`!=`links`.`pkgver` OR `binary_packages`.`pkgrel`!=`links`.`pkgrel`) JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` AND `binary_packages_in_repositories`.`repository`=9;
DELETE `binary_packages` FROM `links` JOIN `architectures` ON `architectures`.`name`=`links`.`architecture` JOIN `binary_packages` ON `architectures`.`id`=`binary_packages`.`architecture` AND `binary_packages`.`pkgname`=`links`.`pkgname` AND (`binary_packages`.`sub_pkgrel`!=@sub_pkgrel OR `binary_packages`.`epoch`!=`links`.`epoch` OR `binary_packages`.`pkgver`!=`links`.`pkgver` OR `binary_packages`.`pkgrel`!=`links`.`pkgrel`) LEFT JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` WHERE `binary_packages_in_repositories`.`id` IS NULL AND `binary_packages`.`sha512sum` IS NULL;
INSERT IGNORE INTO `install_targets` (`name`) SELECT `links`.`install_target_name` FROM `links`;
INSERT IGNORE INTO `versions` (`epoch`,`version`) SELECT `links`.`install_target_epoch`,`links`.`install_target_version` FROM `links` WHERE `links`.`install_target_epoch` IS NOT NULL AND `links`.`install_target_version` IS NOT NULL;
INSERT IGNORE INTO `install_target_providers` (`package`,`install_target`,`version`,`install_target_is_group`) SELECT `binary_packages`.`id`,`install_targets`.`id`,`versions`.`id`,1 FROM `links` JOIN `architectures` ON `architectures`.`name`=`links`.`architecture` JOIN `binary_packages` ON `architectures`.`id`=`binary_packages`.`architecture` AND `binary_packages`.`sub_pkgrel`=@sub_pkgrel AND `binary_packages`.`pkgname`=`links`.`pkgname` AND `binary_packages`.`epoch`=`links`.`epoch` AND `binary_packages`.`pkgver`=`links`.`pkgver` AND `binary_packages`.`pkgrel`=`links`.`pkgrel` JOIN `install_targets` ON `install_targets`.`name`=`links`.`install_target_name` JOIN `versions` ON `versions`.`epoch`=`links`.`install_target_epoch` AND `versions`.`version`=`links`.`install_target_version` WHERE `links`.`type`="groups";
INSERT IGNORE INTO `install_target_providers` (`package`,`install_target`,`version`,`install_target_is_group`) SELECT `binary_packages`.`id`,`install_targets`.`id`,`versions`.`id`,0 FROM `links` JOIN `architectures` ON `architectures`.`name`=`links`.`architecture` JOIN `binary_packages` ON `architectures`.`id`=`binary_packages`.`architecture` AND `binary_packages`.`sub_pkgrel`=@sub_pkgrel AND `binary_packages`.`pkgname`=`links`.`pkgname` AND `binary_packages`.`epoch`=`links`.`epoch` AND `binary_packages`.`pkgver`=`links`.`pkgver` AND `binary_packages`.`pkgrel`=`links`.`pkgrel` JOIN `install_targets` ON `install_targets`.`name`=`links`.`install_target_name` JOIN `versions` ON `versions`.`epoch`=`links`.`install_target_epoch` AND `versions`.`version`=`links`.`install_target_version` WHERE `links`.`type`="provides";
INSERT IGNORE INTO `dependencies` (`dependent`,`depending_on`,`dependency_type`,`version`,`version_relation`) SELECT `binary_packages`.`id`,`install_targets`.`id`,`dependency_types`.`id`,`versions`.`id`,`links`.`version_relation` FROM `links` JOIN `architectures` ON `architectures`.`name`=`links`.`architecture` JOIN `binary_packages` ON `architectures`.`id`=`binary_packages`.`architecture` AND `binary_packages`.`sub_pkgrel`=@sub_pkgrel AND `binary_packages`.`pkgname`=`links`.`pkgname` AND `binary_packages`.`epoch`=`links`.`epoch` AND `binary_packages`.`pkgver`=`links`.`pkgver` AND `binary_packages`.`pkgrel`=`links`.`pkgrel` JOIN `install_targets` ON `install_targets`.`name`=`links`.`install_target_name` JOIN `versions` ON `versions`.`epoch`=`links`.`install_target_epoch` AND `versions`.`version`=`links`.`install_target_version` JOIN `dependency_types` ON `dependency_types`.`name`="make" WHERE `links`.`type`="makedepends";
INSERT IGNORE INTO `dependencies` (`dependent`,`depending_on`,`dependency_type`,`version`,`version_relation`) SELECT `binary_packages`.`id`,`install_targets`.`id`,`dependency_types`.`id`,`versions`.`id`,`links`.`version_relation` FROM `links` JOIN `architectures` ON `architectures`.`name`=`links`.`architecture` JOIN `binary_packages` ON `architectures`.`id`=`binary_packages`.`architecture` AND `binary_packages`.`sub_pkgrel`=@sub_pkgrel AND `binary_packages`.`pkgname`=`links`.`pkgname` AND `binary_packages`.`epoch`=`links`.`epoch` AND `binary_packages`.`pkgver`=`links`.`pkgver` AND `binary_packages`.`pkgrel`=`links`.`pkgrel` JOIN `install_targets` ON `install_targets`.`name`=`links`.`install_target_name` JOIN `versions` ON `versions`.`epoch`=`links`.`install_target_epoch` AND `versions`.`version`=`links`.`install_target_version` JOIN `dependency_types` ON `dependency_types`.`name`="check" WHERE `links`.`type`="checkdepends";
INSERT IGNORE INTO `dependencies` (`dependent`,`depending_on`,`dependency_type`,`version`,`version_relation`) SELECT `binary_packages`.`id`,`install_targets`.`id`,`dependency_types`.`id`,`versions`.`id`,`links`.`version_relation` FROM `links` JOIN `architectures` ON `architectures`.`name`=`links`.`architecture` JOIN `binary_packages` ON `architectures`.`id`=`binary_packages`.`architecture` AND `binary_packages`.`sub_pkgrel`=@sub_pkgrel AND `binary_packages`.`pkgname`=`links`.`pkgname` AND `binary_packages`.`epoch`=`links`.`epoch` AND `binary_packages`.`pkgver`=`links`.`pkgver` AND `binary_packages`.`pkgrel`=`links`.`pkgrel` JOIN `install_targets` ON `install_targets`.`name`=`links`.`install_target_name` JOIN `versions` ON `versions`.`epoch`=`links`.`install_target_epoch` AND `versions`.`version`=`links`.`install_target_version` JOIN `dependency_types` ON `dependency_types`.`name`="run" WHERE `links`.`type`="rundepends";
DROP TEMPORARY TABLE `links`;