maria-developers team mailing list archive

[jerome brauge <j.brauge@xxxxxxxxxxx>]

Hello Sergei,

> -----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
> sql_mode=ORACLE?

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.
Regards,
Jérôme.

> 
> Regards,
> Sergei
> Chief Architect MariaDB
> and security@xxxxxxxxxxx