Flaky test executor/delete for foreign key

[YangKeao]

The foreign test in executor/delete is flaky:

time="2024-10-28T17:52:32+08:00" level=error msg="run test [executor/delete] err: sql:delete parent, parent2 from parent join parent2 on parent.a = parent2.a;: failed to run query \n\"delete parent, parent2 from parent join parent2 on parent.a = parent2.a;\" \n around line 139, \nwe need(256):\ndelete parent, parent2 from parent join parent2 on parent.a = parent2.a;\nError 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`executor__delete`.`child`, CONSTRAINT `fk_1` FOREIGN KEY (`a`) REFERENCES `parent` (`a`))\nde\nbut got(256):\ndelete parent, parent2 from parent join parent2 on parent.a = parent2.a;\nError 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`executor__delete`.`child2`, CONSTRAINT `fk_1` FOREIGN KEY (`a`) REFERENCES `parent2` (`a`))\n\n"