← Back to team overview

maria-developers team mailing list archive

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?

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
and security@xxxxxxxxxxx

Follow ups