GitHub

mysql incr - alter table FOREIGN KEY ON DELETE SET NULL ON UPDATE SET NULL, the symbol is differenet

check show create, the symbol is differenet. child_3_ibfk_1 and fk_child_3_1 # src mysql SQL> SHOW CREATE TABLE child_3; child_3 | CREATE TABLE `child_3` ( `id` int(11) DEFAULT NULL, `parent_id` ...
GitHub

ALTER TABLE ADD FOREIGN KEY causes apply error under concurrent and conflicting DML

Adding a foreign key to an existing table, and concurrently replicating a statement that changes the parent so that it violates the FK constraint, may result in the applier failing and reporting the ...