[MariaDB developers] Re: Suggestions for the problems around replication of XA in 10.5

Hi! On Thu, Jan 25, 2024 at 8:09 PM <andrei.elkin@pp.inet.fi> wrote:

Kristian, this statement of row-based primary-key only replication requires at least a confirmation with a test. Oth ROW may be somewhat difficult to dismiss and I am not going to now, but the PK is too much as a UK guarantees correctness, please read on. So far we only have MDEV 32020 about non-UK ROW format vulnerability.

Note the Unique key is not enough. All key parts has also be NOT NULL, otherwise you have all the same problems as you have with a table without any keys. Regards, Monty