Really we have private worklog #4103 about how DELETE IGNORE should behave.
Idea in this worklog is "skip the row, no change, move to the next row", so last SELECT should return:
mysql> select * from parent; +----+ | id | +----+ | 3 | | 5 | +----+ 2 rows in set (0.00 sec)
Really we have private worklog #4103 about how DELETE IGNORE should behave.
Idea in this worklog is "skip the row, no change, move to the next row", so last SELECT should return:
mysql> select * from parent;
+----+
| id |
+----+
| 3 |
| 5 |
+----+
2 rows in set (0.00 sec)