On: Don't use DISTINCT as a "join-fixer"

[thiht]

I’ve done it a few times in the app I’m working with and had no idea DISTINCT was not the proper way to address it. I mean, it’s a standard feature, named « distinct », easy to use and it works. It’s on me that I didn’t run an explain on these queries, but it seems like an easy mistake to make.

Anyway I’ll happily fix these in my code on Monday.