[tests] test hard relation softdelete cascade, closes #745