maria-developers team mailing list archive
Mailing list archive
Re: sql_mode=oracle : Rollback on error
I agree but it's not natural to have to use compound statement and it's require extra work in many place to handle the mariadb behavior.
In addition, this workaround need also an handler for "NOT FOUND" else if there is a query in the block that returns no rows, the exit handler is fired.
De : Vladislav Vaintroub [mailto:vvaintroub@xxxxxxxxx]
Envoyé : jeudi 5 avril 2018 13:03
À : jerome brauge; Sergei Golubchik (serg@xxxxxxxxxxx)
Cc : MariaDB Developers (maria-developers@xxxxxxxxxxxxxxxxxxx)
Objet : Re: [Maria-developers] sql_mode=oracle : Rollback on error
On 05.04.2018 12:22, jerome brauge wrote:
Can you take a glance on this issue.
It's a major behavior difference and my workaround only work with stored procedures.
Commercial DBs works like Oracle (as least Sybase, Sqlserver (when XACT_ABORT is ON), DB2 UDB and DB2 AS400).
Not just stored procedures, but also compound statements, as described in https://mariadb.com/resources/blog/atomic-compound-statements. similar to stored procedures in fact, just not "stored".
De : Alexander Barkov [mailto:bar@xxxxxxxxxxx]
Envoyé : mardi 3 avril 2018 12:43
À : jerome brauge
Cc : MariaDB Developers (maria-developers@xxxxxxxxxxxxxxxxxxx<mailto:maria-developers@xxxxxxxxxxxxxxxxxxx>)
Objet : Re: sql_mode=oracle : Rollback on error
On 03/30/2018 06:52 PM, jerome brauge wrote:
I've found one another difference between Mariadb and Oracle : oracle
always rollback the active transaction if an error is raised, Maria leave the
Possible workaround in stored procedure: add an exit handler which do a
rollback and resignal the error.
What do you think about this ?
Sorry, this topic is out of my expertise. Please talk to Sergei.
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@xxxxxxxxxxxxxxxxxxx<mailto:maria-developers@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp