← Back to team overview

maria-developers team mailing list archive

sql_mode=oracle : Rollback on error


Hello Alexander,
I've found one another difference  between Mariadb and Oracle : oracle always rollback the active transaction if an error is raised, Maria leave the transaction active.
Possible workaround in stored procedure: add an exit handler which do a rollback and resignal the error.

What do you think about this ?


Attachment: trans_not_rollbacked_workaround.sql
Description: trans_not_rollbacked_workaround.sql

Attachment: trans_not_rollbacked.sql
Description: trans_not_rollbacked.sql

Follow ups