"Incorrect syntax near 'OFFSET'. Invalid usage of the option NEXT in the FETCH statement"

I get this error when I click a column sort 3 times. It sorts ASC on first click, the DESC, then error.

The generated SQL is:

SELECT
    [InventoryServer].[Id] as 'InventoryServer.Id',
    [InventoryServer].[Name] as 'InventoryServer.Name',
    [InventoryServer].[DockDate] as 'InventoryServer.DockDate',
    [InventoryServer].[BillingStartDate] as 'InventoryServer.BillingStartDate',
    [PatchPartyDowntime].[Name] as 'PatchPartyDowntime.Name',
    [VirtualEnvironment].[Description] as 'VirtualEnvironment.Description'
    -- Many more redacted
FROM
    [InventoryServer]
    LEFT JOIN [ContactGroup] ON [ContactGroup].[Id] = [InventoryServer].[ContactGroupId]
    LEFT JOIN [DisasterRecoveryTeir] ON [DisasterRecoveryTeir].[Id] = [InventoryServer].[DisasterRecoveryTeirId]
    LEFT JOIN [Domain] ON [Domain].[Id] = [InventoryServer].[DomainId]
    -- Many more redacted
WHERE
    (1 = 1) OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY

It appears the order by is ripped away as a part of removing the sort on my third click.

Let me know if you need more code.

Reproduziere den im Issue beschriebenen dritten Klick auf die Spaltensortierung und untersuche das generierte SQL. Verfolge, wo das Entfernen der Sortierung ORDER BY entfernt, und stelle dann sicher, dass die resultierende OFFSET/FETCH-Abfrage weiterhin gültig ist; erledigt ist dies, wenn das Durchlaufen von ASC, DESC und keiner Sortierung den gemeldeten Syntaxfehler nicht mehr erzeugt.