CREATE TEMPORARY TABLE `up`(`id` bigint(20) NOT NULL AUTO_INCREMENT,`pkgname` VARCHAR(64) NOT NULL,`epoch` MEDIUMINT(9) NOT NULL,`pkgver` VARCHAR(64) COLLATE utf8mb4_unicode_ci NOT NULL,`pkgrel` MEDIUMINT(9) NOT NULL,`architecture` VARCHAR(6) COLLATE utf8mb4_unicode_ci NOT NULL,`repository` VARCHAR(32) NOT NULL,PRIMARY KEY (`id`),UNIQUE KEY `content` (`pkgname`,`epoch`,`pkgver`,`pkgrel`),UNIQUE KEY `location` (`pkgname`,`repository`),KEY `repository` (`repository`));
LOAD DATA LOCAL INFILE "/home/master/builder/bin/../work/tmp.mysql-functions.was_insane_query.2019-03-15T07:07:41.iyCFwI.infile.1" INTO TABLE `up`(`repository`,`pkgname`,`epoch`,`pkgver`,`pkgrel`,`architecture`);
DELETE `upstream_packages` FROM `upstream_packages`;
INSERT IGNORE INTO `upstream_packages`(`id`,`pkgname`,`epoch`,`pkgver`,`pkgrel`,`architecture`,`repository`) SELECT `up`.`id`,`up`.`pkgname`,`up`.`epoch`,`up`.`pkgver`,`up`.`pkgrel`,`up`.`architecture`,`upstream_repositories`.`id` FROM `up` JOIN `upstream_repositories` ON `upstream_repositories`.`name`=`up`.`repository`;