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

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to