• Where is the author? Where are the folks who defended the data collection query as harmless?

    Steven993 said the query is fine. I think I have shown it's not fine.

    Brian O'Leary pronounced the effect of the bug to be nothing worse than showing duplicate rows. I think I have shown the effect is much worse.

    Where is the discussion? Can a few more people weigh in to confirm or refute (with some evidence) the problem? The article is rated 4+ stars, but I'm afraid the core query is fundamentally flawed.