The Halloween Problem: a spooky (and true) SQL story

The Halloween Problem is a rare but scary issue that can haunt relational databases, mutating your data in unexpected ways if you're not careful.

Has anyone ever actually triggered the Halloween problem in their database?

dang this IS scary. still not as terrifying as clowns tho