Re: [Maria-developers] sql_mode=oracle : Rollback on error

2018-04-23 Thread jerome brauge
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

Re: [Maria-developers] sql_mode=oracle : Rollback on error

2018-04-11 Thread Sergei Golubchik
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

Re: [Maria-developers] sql_mode=oracle : Rollback on error

2018-04-05 Thread jerome brauge
=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

Re: [Maria-developers] sql_mode=oracle : Rollback on error

2018-04-05 Thread jerome brauge
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

Re: [Maria-developers] sql_mode=oracle : Rollback on error

2018-04-05 Thread Vladislav Vaintroub
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).

[Maria-developers] sql_mode=oracle : Rollback on error

2018-04-05 Thread jerome brauge
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 :

Re: [Maria-developers] sql_mode=oracle : Rollback on error

2018-04-03 Thread Alexander Barkov
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:

[Maria-developers] sql_mode=oracle : Rollback on error

2018-03-30 Thread jerome brauge
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.