Thanks for the idea. I just checked the settings and they're same in our production and test environments. It's set to Referential with Delete being Remove Link and Merge being Cascade All. Otherwise they're all Cascade None.
If you've found this thread useful, dive deeper into User Group community content by role