[Koha-bugs] [Bug 18364] LOCK and UNLOCK are not transaction-safe

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18364

--- Comment #6 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
The doc says

"""
The correct way to use LOCK TABLES and UNLOCK TABLES with transactional tables,
such as InnoDB tables, is to begin a transaction with SET autocommit = 0 (not
START TRANSACTION) followed by LOCK TABLES, and to not call UNLOCK TABLES until
you commit the transaction explicitly.
"""

https://dev.mysql.com/doc/refman/5.7/en/lock-tables-and-transactions.html

-- 
You are receiving this mail because:
You are watching all bug changes.