# Test Bug #57255. Cascade deletes that affect different rows should not# result in DB_FOREIGN_EXCEED_MAX_CASCADE error--sourceinclude/have_innodb.inccreatetableA(idintnotnullprimarykey)engine=innodb;createtableB(idintnotnullauto_incrementprimarykey,f1intnotnull,foreignkey(f1)referencesA(id)ondeletecascade)engine=innodb;createtableC(idintnotnullauto_incrementprimarykey,f1intnotnull,foreignkey(f1)referencesB(id)ondeletecascade)engine=innodb;insertintoAvalues(1),(2);--disable_query_logbegin;let$i=257;while($i){insertintoB(f1)values(1);dec$i;}let$i=486;while($i){insertintoC(f1)values(2);dec$i;}commit;--enable_query_log# Following Deletes should not report errorDELETEFROMAwhereid=1;DELETEFROMCwheref1=2;DELETEFROMAwhereid=1;DROPTABLEC;DROPTABLEB;DROPTABLEA;