← Back to team overview

maria-developers team mailing list archive

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.

Attachment: MDEV12874_update_use_source.diff
Description: MDEV12874_update_use_source.diff


Follow ups