[~steve] bq. dropping the CASCADE part, executing {{delete from test}} used to fail on older MySQL versions... I can confirm that it fails on 5.5.37-1 (Debian jessie). On what versions does it succeed? bq. ...because row with PK 2 could not be deleted. But the row with PK 2 can always be deleted (also without the CASCADE part)!
And: I always thought {{Dialect#hasSelfReferentialForeignKeyBug}} is only relevant for cases *with* CASCADE (in which case setting the FK fields to null is forced). But unfortunately this fails if the FK fields have a not null constraint \- see my very first comment...
|