MySQL Bugs: #22167: update ignore feature is missing

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:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S3 (Non-critical)
Version:	5.2	OS:	Any (all)
Assigned to:		CPU Architecture:	Any

Description:
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.

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