mariadb/Docs
Kristian Nielsen 68042221e6 MDEV-38465: Savepoint in trigger causes transactional inconsistency
SAVEPOINT inside a trigger doesn't work correctly. Setting a savepoint
inside a trigger somehow loses the implicit savepoint set at transaction
start, so that the partial changes are left if the statement later fails.
Referencing an existing savepoint claims the savepoint does not exist (and
it is in any case very unclear what exactly it should mean to rollback to a
savepoint from the middle of a statement, or set in the middle of a prior
statement).

These problems are independent of binlog-in-engine, but in the new binlog
implementation we are trying to make things work more correctly and
robustly, so let's disallow use of savepoints inside triggers. The new
binlog is off by default, so backwards compatibility is less of a concern,
though arguably disallowing savepoints in triggers would be better done
unconditionally.

Signed-off-by: Kristian Nielsen <knielsen@knielsen-hq.org>
2026-01-23 03:23:20 +01:00
..
replication MDEV-38465: Savepoint in trigger causes transactional inconsistency 2026-01-23 03:23:20 +01:00
INSTALL-BINARY Merge branch '10.4' into 10.5 2022-08-10 12:24:31 +02:00
myisam.txt Fix remaining typos 2025-04-29 11:18:00 +10:00
mysql.info Update AskMonty and Atlassian references to MariaDB 2016-03-08 15:24:01 +02:00
optimizer_costs.txt Fix remaining typos 2025-04-29 11:18:00 +10:00
README-wsrep MDEV-29275 Fix server/Docs typos 2022-09-21 14:32:42 +10:00