That time a forum stranger caught my SQL mistake after 3 days of hair pulling
I spent 3 days stuck on a query that kept returning duplicate rows and a random user on the r/learnprogramming subreddit pointed out I was missing a GROUP BY on the wrong column, which made me realize I'd been looking at the data instead of the logic, so has anyone else had a total stranger spot something obvious that your own brain just refused to see?
Honestly the stranger probably got lucky and just guessed at the most common fix, because missing GROUP BY issues are like the first thing anyone yells in those threads. Your own brain didn't "refuse to see" it, you just hadn't slept and were staring at a screen too long, which is a totally normal thing that happens to everyone. Giving some random commenter credit for your breakthrough feels a bit much when the real lesson is just to walk away and come back fresh.