Details
Description
As found in NEXUS-12028, NuGet searches translate to db queries like
select from asset where (LOWER(attributes.nuget.id) = :p0) and (bucket=#25:0) ORDER BY attributes.nuget.download_count DESC, id asc, version asc
Note that the ORDER BY clause refers to the non-existing asset properties id and version instead of attributes.nuget.id|version.
At first glance, the cause might be https://github.com/sonatype/nexus-internal/blob/84a2d0537cb61ea16318e2748019f197bfb6b800/private/plugins/nexus-repository-nuget/src/main/java/com/sonatype/nexus/repository/nuget/odata/ODataUtils.java#L182 which doesn't consider the COLUMN_ALIASES.