INSERT INTO `ffxiv_freecompany_rank` (`freecompanyid`, `rankid`, `rankname`) VALUE ('9236179148295239722', '0', 'Leader') ON DUPLICATE KEY UPDATE `rankname`='Leader' SELECT `ffxiv_freecompany_character`.`characterid`, `ffxiv_freecompany_character`.`freecompanyid` INSERT IGNORE INTO `ffxiv_freecompany_x_character` INSERT INTO `ffxiv_freecompany_names`(`freecompanyid`, `name`) `estateid`=(SELECT `estateid` FROM `ffxiv_estate` WHERE CONCAT('Plot ', `plot`, ', ', `ward`, ' Ward, ', `area`, ' (', CASE WHEN `size` = 1 THEN 'Small' WHEN `size` = 2 THEN 'Medium' WHEN `size` = 3 THEN 'Large' END, ')')=NULL LIMIT 1), `recruitment`='0', `communityid`=NULL, `estate_zone`=NULL, `activeid`=(SELECT `activeid` FROM `ffxiv_timeactive` WHERE `active`=NULL AND `active` IS NOT NULL LIMIT 1), `serverid`=(SELECT `serverid` FROM `ffxiv_server` WHERE `server`='Balmung'), (SELECT `estateid` FROM `ffxiv_estate` WHERE CONCAT('Plot ', `plot`, ', ', `ward`, ' Ward, ', `area`, ' (', CASE WHEN `size` = 1 THEN 'Small' WHEN `size` = 2 THEN 'Medium' WHEN `size` = 3 THEN 'Large' END, ')')=NULL LIMIT 1), (SELECT `activeid` FROM `ffxiv_timeactive` WHERE `active`=NULL AND `active` IS NOT NULL LIMIT 1), '0', NULL, NULL, (SELECT `gcrankid` FROM `ffxiv_grandcompany_rank` WHERE `gc_name`='Maelstrom' ORDER BY `gcrankid` LIMIT 1), 'Ruina', NULL, '15', NULL, `Guildhests`, `Trials`, `Raids`, `PvP`, `Tank`, `Healer`, `DPS`, `Crafter`, `Gatherer` `rank`, `slogan`, `activeid`, `recruitment`, `communityid`, `estate_zone`, `estateid`, `estate_message`, `Role-playing`, `Leveling`, `Casual`, `Hardcore`, `Dungeons`, `freecompanyid`, `name`, `serverid`, `formed`, `registered`, `updated`, `deleted`, `grandcompanyid`, `tag`, `crest`,
#Final fantasy xiv lodestone rss feed code#
I mean that there are rows inserted within the transaction, but when the transaction ends, they are missing in the table.įor example, code runs a set of queries like this: INSERT INTO `ffxiv_freecompany` (
I am having a strange heisenbug when a set of queries in a transaction (in MariaDB 10.2.38) somehow results in missing rows afterward.
0 kommentar(er)
