maria-developers team mailing list archive
Mailing list archive
Re: sql_mode=oracle : Rollback on error
> -----Message d'origine-----
> De : Sergei Golubchik [mailto:serg@xxxxxxxxxxx]
> Envoyé : mercredi 11 avril 2018 20:37
> À : jerome brauge
> Cc : maria-developers@xxxxxxxxxxxxxxxxxxx
> Objet : Re: sql_mode=oracle : Rollback on error
> Hi, Jerome!
> On Apr 05, jerome brauge wrote:
> > Hello Sergei,
> > 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).
> I couldn't find what SQL standard says about it. It says an implicit rollback
> should happen in case of the "unrecoverable error", but doesn't clarify what
> errors are unrecoverable.
> Do you say that we should abort the whole transaction in
Yes, this is right.
> I think it's not even difficult to do. But may be a too big change for
> 10.3 at this point?
I let you decide of the right target release but 10.3 will be fine for us.
> Chief Architect MariaDB
> and security@xxxxxxxxxxx