maria-developers team mailing list archive
Mailing list archive
Error 1422 - Explicit or implicit commit is not allowed in stored function or trigger
I'm facing to a new issue with my stored procedures.
Some of them are called directly or from trigger.
When these procedures are called directly, they manage the transaction and when they are called from trigger, they doesn't manage the transaction.
This works fine on Oracle, SQLServer , ... but fail on Mariadb because the check is done in is_not_allowed_in_function() before the call.
create or replace table t1 (c1 int);
insert into t1 values (1);
create or replace procedure p1(manage_transactionnal int)
if manage_transactionnal = 1 then
create or replace trigger tg1 after delete on t1 for each row
delete from t1;
What do you think about this ?