On Sep 18, 2009, at 10:04 AM, Andrei Elkin wrote:
> Luis, hello.
>
> The patch is approved.
>
> I have just couple of "footnotes" :-) for your deliberation.
>
>> #At file:///home/lsoares/Workspace/bzr/work/bugfixing/47312/mysql-5.1-bugteam/
>> based on revid:luis.soares@stripped
>>
>> 3124 Luis Soares 2009-09-15
>> BUG#47312: RBR: Disabling key on slave breaks replication:
>> HA_ERR_WRONG_INDEX
>>
>> In RBR, if disabling keys on slave table it breaks replication
>> if
>> updating or deleting a record. When the slave thread tries to
>> finding the row, by searching the storage engine, it checkes
>> whether the table has a key or not. If it has one, then the
>> slave
>> thread uses it to search the record.
>>
>> Unfortunately, the slave only checks whether the key exists or
> ~~~~~~~~~~~~~
> I would not advice expressing emotions :-)
While using an emoticon to make that observation!
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com