maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

Hello Jerome,


On 07/21/2017 07:04 PM, jerome brauge wrote:
> Hello,
>
> Here is a patch for MDEV-12874 (on branch 10.2-ext).
> Can anyone review it ?

Let's ask Sergei to review your patch when he's back from vacation.

> Alexander, during my work on this MDEV, I've found a new issue with update statement and Oracle compatibility.

Thanks for noticing this. I filed a bug report:

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


> 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.