Re: foreign bug? about ON UPDATE SET NULL ON DELETE CASCADE

[Peter Brawley]

Your example can't work as your post indicates, because REPLACE deletes any row having a Primary or Unique key value matching the inserted value before it inserts the new value.

Therefore after ...

REPLACE INTO tab1 (col1, col2) VALUES (1,'zzzz');

... we have ...

select * from tab2;
+------+------+------+
| col3 | col4 | col5 |
+------+------+------+
|    3 | eeee |    2 |
+------+------+------+