Steve Ebersole

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?

...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 this fails if the FK fields have a not null constraint - see my very first comment...