maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #10809
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