[Koha-bugs] [Bug 34678] Concurrent changes to the holds can fail due to primary key constraints

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34678 --- Comment #6 from Kyle M Hall <kyle@bywatersolutions.com> --- (In reply to Marcel de Rooy from comment #5)

Should we use a MySQL extension like REPLACE ?

It appears that MERGE is the closest SQL standard keyword with the same functionality. However, MySQL/MariaDB doesn't support it. There is also no DBIC alternative to use as universal fix. The alternative would be to run a delete query with the insert as a transaction. That feels rather clunky and inefficient to simply avoid a specific use of this keyword. -- You are receiving this mail because: You are watching all bug changes.