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
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
=qualiac@lists.launchpad.net] De
la part de jerome brauge
Envoyé : jeudi 5 avril 2018 14:14
À : 'Vladislav Vaintroub'; Sergei Golubchik (s...@mariadb.com)
Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
Objet : Re: [Maria-developers] sql_mode=oracle : Rollback on error
Hi
it handler is fired.
De : Vladislav Vaintroub [mailto:vvaintr...@gmail.com]
Envoyé : jeudi 5 avril 2018 13:03
À : jerome brauge; Sergei Golubchik (s...@mariadb.com)
Cc : MariaDB Developers (maria-developers@lists.launchpad.net)
Objet : Re: [Maria-developers] sql_mode=oracle : Rollbac
On 05.04.2018 12:22, 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).
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).
Regards
> -Message d'origine-
> De :
Hello Jerome,
On 03/30/2018 06:52 PM, jerome brauge wrote:
> Hello Alexander,
> I've found one another difference between Mariadb and Oracle : oracle always
> rollback the active transaction if an error is raised, Maria leave the
> transaction active.
> Possible workaround in stored procedure:
Hello Alexander,
I've found one another difference between Mariadb and Oracle : oracle always
rollback the active transaction if an error is raised, Maria leave the
transaction active.
Possible workaround in stored procedure: add an exit handler which do a
rollback and resignal the error.
8 matches
Mail list logo