internal/postgres: do not order GetLatestPackage by module_path
Previously, GetLatestPackage was ordering results by module_path, which
was resulting in incorrect sorting for when a package belonged to
multiple modules. This is now removed.
Fixes b/137899743
@@ -143,7 +143,6 @@ func (db *DB) GetLatestPackage(ctx context.Context, path string) (*internal.Vers
WHERE
p.path = $1
ORDER BY
- v.module_path,
-- Order the versions by release then prerelease.
-- The default version should be the first release
-- version available, if one exists.
