Hello Sergei, > -----Message d'origine----- > De : Sergei Golubchik [mailto:s...@mariadb.org] > Envoyé : mercredi 11 avril 2018 20:37 > À : jerome brauge > Cc : maria-developers@lists.launchpad.net > 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 secur...@mariadb.org _______________________________________________ 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