Hi...
I am currently applying 8.11.1172 to my project.
It is applied to the actual product, so it is urgent to correct it. :(
But, if I call Skip () after OrderBy (), an error occurs.
This is different case within #1.
(Using Include statement)
Here is sample
==============================================
List< AnalysisRequest> test = await m_dbContext.AnalysisRequests.AsNoTracking()
.Include(i => i.VirtualDevice)
.OrderBy(i => i.RegDate)
.Skip(1)
.ToListAsync();
Here is query generated by ef
==============================================
query is not display...
Here is stack traces..
==============================================
NNException: [2018-06-25 13:53:14][ERROR][NNException] - System.IndexOutOfRangeException: Result set index too big.
at Devart.Data.MySql.MySqlDataReader.(Int32 , String )
at Devart.Data.MySql.MySqlDataReader.IsDBNull(Int32 i)
at lambda_method(Closure , DbDataReader )
at Microsoft.EntityFrameworkCore.Storage.Internal.TypedRelationalValueBufferFactory.Create(DbDataReader dataReader)
at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken)
at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator`2.MoveNextCore(CancellationToken cancellationToken)
at System.Linq.AsyncEnumerable.AsyncIterator`1.MoveNext(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
at System.Linq.AsyncEnumerable.Aggregate_[TSource,TAccumulate,TResult](IAsyncEnumerable`1 source, TAccumulate seed, Func`3 accumulator, Func`2 resultSelector, CancellationToken cancellationToken)
at MSquareProvider.Providers.Optimization.AnalysisProvider.Get(String deviceId, String virtualDeviceId, Int32 skip, Int32 countPerPage, List`1 searchFields, String searchKeyword, Nullable`1 searchStartDate, Nullable`1 searchEndDate, EnumAnalysisStatus status) in D:\Source\NewMSquare\MSquare\Models\MSquareProvider\Providers\Optimization\AnalysisProvider.cs:line 90
Skip occured exception After OrderBy... Case #2
-
- Posts: 11
- Joined: Wed 14 Jun 2017 05:46
Re: Skip occured exception After OrderBy... Case #2
Thank you for your report. We have reproduced the issue and are investigating it. We will notify you about the result.
Re: Skip occured exception After OrderBy... Case #2
The bug with paging in EF Core 2.1 is fixed. The internal build with the fix: https://www.devart.com/pub/nuget_mysql_8_11_1186.zip.
Re: Skip occured exception After OrderBy... Case #2
dotConnect for MySQL 8.12 is released: viewtopic.php?f=2&t=37477.