[#MDEV-26683] UPDATE IGNORE does not produce warnings upon duplicate key

[MDEV-26683] UPDATE IGNORE does not produce warnings upon duplicate key Created: 2021-09-25 Updated: 2023-04-27
Status:	Open
Project:	MariaDB Server
Component/s:	Data Manipulation - Update
Affects Version/s:	10.2, 10.3, 10.4, 10.5, 10.6
Fix Version/s:	10.4, 10.5, 10.6

Type:

Bug

Priority:

Major

Reporter:

Elena Stepanova

Assignee:

Oleksandr Byelkin

Resolution:

Unresolved

Votes:

Labels:

upstream-fixed

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.

Generated at Thu Feb 08 09:47:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.