diff options
author | Luis Soares <luis.soares@sun.com> | 2009-09-27 22:02:47 +0100 |
---|---|---|
committer | Luis Soares <luis.soares@sun.com> | 2009-09-27 22:02:47 +0100 |
commit | 3d211f39819db045c4992dcf1aab1c2473b56c66 (patch) | |
tree | 797a185fe4485dc15bcf5312381efdc7ed0cf709 /mysql-test/extra | |
parent | 6368919f54cea96c4176b8a98d572ae3eab06b18 (diff) | |
download | mariadb-git-3d211f39819db045c4992dcf1aab1c2473b56c66.tar.gz |
BUG#47312: RBR: Disabling key on slave breaks replication:
HA_ERR_WRONG_INDEX
In RBR, disabling keys on slave table will break replication when
updating or deleting a record. When the slave thread tries to
find the row, by searching in the storage engine, it checks
whether the table has a key or not. If it has one, then the slave
thread uses it to search the record.
Nonetheless, the slave only checks whether the key exists or not,
it does not verify if it is active. Should the key be
disabled (eg, DBA has issued an ALTER TABLE ... DISABLE KEYS)
then it will result in error: HA_ERR_WRONG_INDEX.
This patch addresses this issue by making the slave thread also
check whether the key is active or not before actually using it.
Diffstat (limited to 'mysql-test/extra')
0 files changed, 0 insertions, 0 deletions