Hello Sergei,
-----Message d'origine----- De : Sergei Golubchik [mailto:serg@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 security@mariadb.org