UseQuartz throw error >>>>>>>>>>>>>>>>> This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
DELETE o
FROM OpenIddictTokens AS o
WHERE o.Id IN (
SELECT o0.Id
FROM OpenIddictTokens AS o0
LEFT JOIN OpenIddictAuthorizations AS o1 ON o0.AuthorizationId = o1.Id
WHERE (o0.CreationDate < @date_0) AND (((((o0.Status <> 'inactive') OR o0.Status IS NULL) AND ((o0.Status <> 'valid') OR o0.Status IS NULL)) OR (o1.Id IS NOT NULL AND ((o1.Status <> 'valid') OR o1.Status IS NULL))) OR (o0.ExpirationDate < UTC_TIMESTAMP()))
ORDER BY o0.Id
LIMIT @p_1
)
Confirm you've already contributed to this project or that you sponsor it
Version
OpenIddict.Quartz 5.8.0
Describe the bug
builder.Services.AddOpenIddict() .AddCore(options => { options.UseEntityFrameworkCore().UseDbContext();
options.UseQuartz();
})；
UseQuartz throw error >>>>>>>>>>>>>>>>> This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
To reproduce
builder.Services.AddOpenIddict() .AddCore(options => { options.UseEntityFrameworkCore().UseDbContext();
options.UseQuartz();
})；
UseQuartz throw error >>>>>>>>>>>>>>>>> This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
DELETE
oFROMOpenIddictTokensASoWHEREo.IdIN ( SELECTo0.IdFROMOpenIddictTokensASo0LEFT JOINOpenIddictAuthorizationsASo1ONo0.AuthorizationId=o1.IdWHERE (o0.CreationDate< @date_0) AND (((((o0.Status<> 'inactive') ORo0.StatusIS NULL) AND ((o0.Status<> 'valid') ORo0.StatusIS NULL)) OR (o1.IdIS NOT NULL AND ((o1.Status<> 'valid') ORo1.StatusIS NULL))) OR (o0.ExpirationDate< UTC_TIMESTAMP())) ORDER BYo0.IdLIMIT @p_1 )Exceptions (if any)
No response