elsa-core icon indicating copy to clipboard operation
elsa-core copied to clipboard

WARN: The query uses a row limiting operator ('Skip'/'Take') without an 'OrderBy' operator

Open NightWuYo opened this issue 1 year ago • 2 comments

While Elsa server 3.0.3 started, I see these warnings.

warn: Microsoft.EntityFrameworkCore.Query[10102] The query uses a row limiting operator ('Skip'/'Take') without an 'OrderBy' operator. This may lead to unpredictable results. If the 'Distinct' operator is used after 'OrderBy', then make sure to use the 'OrderBy' operator after 'Distinct' as the ordering would otherwise get erased. warn: Microsoft.EntityFrameworkCore.Query[10102] The query uses a row limiting operator ('Skip'/'Take') without an 'OrderBy' operator. This may lead to unpredictable results. If the 'Distinct' operator is used after 'OrderBy', then make sure to use the 'OrderBy' operator after 'Distinct' as the ordering would otherwise get erased. warn: Microsoft.EntityFrameworkCore.Query[10102] The query uses a row limiting operator ('Skip'/'Take') without an 'OrderBy' operator. This may lead to unpredictable results. If the 'Distinct' operator is used after 'OrderBy', then make sure to use the 'OrderBy' operator after 'Distinct' as the ordering would otherwise get erased. warn: Microsoft.EntityFrameworkCore.Query[10102] The query uses a row limiting operator ('Skip'/'Take') without an 'OrderBy' operator. This may lead to unpredictable results. If the 'Distinct' operator is used after 'OrderBy', then make sure to use the 'OrderBy' operator after 'Distinct' as the ordering would otherwise get erased.

NightWuYo avatar Jan 20 '24 10:01 NightWuYo