Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
Description
create table t1 (a int unique); |
insert into t1 values (1),(2),(3); |
update ignore t1 set a = 4; |
|
# Cleanup
|
drop table t1; |
10.7 d552e092 |
MariaDB [test]> update ignore t1 set a = 4; |
Query OK, 1 row affected (0.008 sec)
|
Rows matched: 3 Changed: 1 Warnings: 0 |
|
MariaDB [test]> select * from t1; |
+------+ |
| a |
|
+------+ |
| 2 |
|
| 3 |
|
| 4 |
|
+------+ |
3 rows in set (0.001 sec) |
Also reproducible on MySQL 5.6, but not on 5.7.