Re: UPDATE triggers with REPLACE statements

[(Hal]

>>>> 2011/12/19 13:55 -0800, Jim McNeely >>>>
Anyway, I just thought I would share. BTW I experimented, and innoDB does updates and
fires off update triggers for REPLACE statements, but MyISAM does delete/inserts. 
<<<<<<<<
Thank you. Which version?

Well, then the documentation is wrong: it is indeed visible to the user which happens.

And what would innoDB do in this case, UNIQUE index X1 and UNIQUE index X2, with a VARCHAR
f, too,

X1 X2 f
 1  2 a
 2  3 b

and one REPLACEs with (2, 2, 'b')? (Earlier in the section such a situation is referred
to.) Delete one and UPDATE the other?

User beware!