sqlfuzz icon indicating copy to clipboard operation
sqlfuzz copied to clipboard

MySQL: Tables having FK references can't be populated because sqlfuzz doesn't go and populate the "parent" table first

Open maksimovic opened this issue 4 years ago • 0 comments

Getting an error like

2021/04/24 14:58:51 Error 1452: Cannot add or update a child row: a foreign key constraint fails (`db`.`table`, CONSTRAINT `FK_something` FOREIGN KEY (`column_from_table`) REFERENCES `other_table` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

maksimovic avatar Apr 24 '21 13:04 maksimovic