maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

Hello Jerome,


On 07/31/2017 04:28 PM, jerome brauge wrote:
> Hello Alexander,
> As I thought, there is the same issue with select.
> The following procedure produce a different result between Mariadb and Oracle.

Thanks for reporting this. I filed a new issue for this:


https://jira.mariadb.org/browse/MDEV-13418

> set sql_mode=oracle;
> use test;
> DELIMITER $$
> CREATE or replace procedure psselerr_field(res OUT VARCHAR)
> AS
>    b1 INT;
> BEGIN
>    b1:=10;
>    select 1,cast(b1 as varchar(10)) into b1, res from dual;
>    return ;
> END;
> $$
> DELIMITER ;
> call psselerr_field (@res);
> select @res;
>
> Mariadb : res = 1
> Oracle: res = 10
>
> Best regards,
> Jérôme.
>
>
> > -----Message d'origine-----
> > De : jerome brauge
> > Envoyé : vendredi 21 juillet 2017 17:04
> > À : maria-developers@xxxxxxxxxxxxxxxxxxx
> > Cc : Alexander Barkov; 'Sergei Golubchik'
> > Objet : Patch for MDEV-12874 - UPDATE statements with the same source
> > and target
> >
> > Hello,
> >
> > Here is a patch for MDEV-12874 (on branch 10.2-ext).
> > Can anyone review it ?
> >
> > Alexander, during my work on this MDEV, I've found a new issue with update
> > statement and Oracle compatibility.
> >
> > create table t1 (c1 integer, c2 integer, c3 integer); insert into t1(c1,c2,c3)
> > values (1,1,1); update t1
> >     set c1 = c1+1,
> >         c2 = c1+1,
> >         c3 = c2+1;
> > select * from t1;
> >
> > Mariadb :
> > +------+------+------+
> > | c1   | c2   | c3   |
> > +------+------+------+
> > |    2 |    3 |    4 |
> > +------+------+------+
> > 1 row in set (0.00 sec)
> >
> > Oracle :
> > DVTORA>
> >          C1         C2         C3
> > ---------- ---------- ----------
> >           2          2          2
> >
> > Can you open a new MDEV for this ?
> >
> > Best regards,
> > Jérôme.