maria-developers team mailing list archive
Mailing list archive
Re: sql_mode=oracle : Rollback on error
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?
I think it's not even difficult to do. But may be a too big change for
10.3 at this point?
Chief Architect MariaDB