Trying to sort gem versions by downloads fails because joins don’t work on associations with dynamic conditions. 
https://github.com/rubygems/rubygems.org/blob/master/app/models/version.rb#L6 …
-
If anybody has a brilliant idea for that one, I’m fresh out.
-
-
Versions belong to only one gem, so there should not be a need to specify both
-
That’s what I assumed too. See https://github.com/rubygems/rubygems.org/commit/66765d45a4472fb458bf9fa47a83f092941a5016#commitcomment-19480753 … for context. It needs to join on both version_id and rubygem_id.
- 1 more reply
New conversation -
-
-
Oh I see. There's multiple keys there. Is the `rubygem_id` constraint necessary at all? Isn't the version id enough?
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.