marcushill / troubadour-server

1 stars 1 forks source link

Nearby wasn't actually working #45

Closed marcushill closed 7 years ago

marcushill commented 7 years ago

TLDR: The SQL query I wrote wasn't the SQL query I thought I wrote. I think this fixes it, but someone should check my logic.

Fixes a bug in the nearby query that it doesn't actually bother to check that the preferences are in fact nearby.

Lesson learned: Don't forget to test your join conditions