Uploaded image for project: 'Dev - Nexus Repo'
  1. Dev - Nexus Repo
  2. NEXUS-14029

Support Nuget "NormalizedVersion" queries

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.14.5
    • Fix Version/s: None
    • Component/s: NuGet
    • Labels:
    • Story Points:
      2

      Description

      Newer versions of NuGet make queries with a "NormalizedVersion" field.

      https://github.com/NuGet/NuGetGallery/issues/2944

      Example:

      127.0.0.1 - - [10/Aug/2017:08:18:49 +0100] "GET /nexus/service/local/nuget/barclays-nuget-read/Packages?$filter=(tolower(Id)%20eq%20'microsoft.aspnetcore.razor')%20and%20(NormalizedVersion%20eq%20'1.1.2') HTTP/1.1" 400 238 2744

       

      When Nexus 2.x receives one of these queries it results in an error:

       

      2017-08-10 08:18:49,249+0100 INFO [qtp1368710677-27545] anonymous com.sonatype.nexus.plugins.nuget.rest.NugetGalleryResource - Illegal argument: Problem preparing SQL: SELECT P.*,(P.VERSION=L.AV) AS ISABSOLUTELATESTVERSION,(P.VERSION=L.V) AS ISLATESTVERSION FROM (SELECT ID,MAX_VERSION(VERSION) AS AV,MAX_VERSION(CASEWHEN(ISPRERELEASE,'',VERSION)) AS V FROM PACKAGES WHERE LOCATE(CONCAT(CONCAT(':',REPOSITORYID),':'),?1) GROUP BY ID) AS L INNER JOIN PACKAGES AS P ON L.ID=P.ID WHERE LOCATE(CONCAT(CONCAT(':',REPOSITORYID),':'),?1) AND ((LOWER(P.ID) = 'microsoft.aspnetcore.razor') AND (P.NORMALIZEDVERSION = '1.1.2')) ORDER BY P.DOWNLOADCOUNT DESC,P.ID,P.VERSION LIMIT 40

      The query is then re-issued by NuGet.exe with just "version", so this isn't visible to the end user.  But it creates a ton of log noise, and no doubt slows builds down.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              rseddon Rich Seddon
              Last Updated By:
              Peter Lynch Peter Lynch
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response:

                  tigCommentSecurity.panel-title