The Aggregate That Trusted a Placeholder
You’ve been told a hundred times: “always coalesce your nulls before they hit the report.” It’s good advice, right up until the moment it isn’t — right up until the placeholder you used to make a NULL “safe” becomes the answer itself. This is the story of an aggregate that picked a fake value over a real one, […]