Bug #22167 update ignore feature is missing
Submitted: 9 Sep 2006 10:09 Modified: 15 Sep 2006 18:05
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:5.2 OS:Any (all)
Assigned to: CPU Architecture:Any

[9 Sep 2006 10:09] Georg Richter
see how to repeat

I assume the UPDATE IGNORE feature is not necessary for
an alpha release.
The system does not crash or mangles data, only a probably rare used
comfort feature is missing.

How to repeat:
 SET storage_engine = Falcon;
create table t1 (id int not null ,
name char(20) not null,
primary key (id));
insert into t1 (id, name) values (1, 'Tim'), (2, 'Monty');
select id, name from t1 order by id;
id name
1 Tim
2 Monty
update ignore t1 set id = 8, name = 'Sinisa' where id < 3;
ERROR HY000: Got error -2047 'duplicate values for key T1..PRIMARY_KEY in table MYSQL.T1' from Falcon
<--- This should not happen, because the manual says
If you use the IGNORE keyword, the update statement does not abort even if errors occur during the update. Rows for which duplicate-key conflicts occur are not updated. Rows for which columns are updated to values that would cause data conversion errors are updated to the closet valid values instead.

If I execute the test with storage engine = InnoDB the server
does not report an error.
[15 Sep 2006 18:05] Hakan Küçükyılmaz
I could verify the fix for this bug with test case falcon_bug_202.test on Linux 32-bit and Linux 64-bit with change set 1.2292, 2006-09-14.

Regards, Hakan