← Back to team overview

maria-developers team mailing list archive

Thread
Date

sql_mode=oracle : Rollback on error

To: "Alexander Barkov (bar@xxxxxxxxxxx)" <bar@xxxxxxxxxxx>
From: jerome brauge <j.brauge@xxxxxxxxxxx>
Date: Fri, 30 Mar 2018 14:52:16 +0000
Accept-language: fr-FR, en-US
Cc: "MariaDB Developers \(maria-developers@xxxxxxxxxxxxxxxxxxx\)" <maria-developers@xxxxxxxxxxxxxxxxxxx>
Thread-index: AdPINpxObE2KG06fSFu7o2scwKQW/A==
Thread-topic: 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 ?

Regards

Attachment: trans_not_rollbacked_workaround.sql
Description: trans_not_rollbacked_workaround.sql

Attachment: trans_not_rollbacked.sql
Description: trans_not_rollbacked.sql

Follow ups

Re: sql_mode=oracle : Rollback on error
From: Alexander Barkov, 2018-04-03