Skip occured exception After OrderBy... Case #2

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
ChangHyeon Lee
Posts: 11
Joined: Wed 14 Jun 2017 05:46

Skip occured exception After OrderBy... Case #2

Post by ChangHyeon Lee » Mon 25 Jun 2018 04:53

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Skip occured exception After OrderBy... Case #2

Post by Shalex » Wed 27 Jun 2018 18:57

Thank you for your report. We have reproduced the issue and are investigating it. We will notify you about the result.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Skip occured exception After OrderBy... Case #2

Post by Shalex » Fri 13 Jul 2018 20:13

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Skip occured exception After OrderBy... Case #2

Post by Shalex » Fri 20 Jul 2018 11:10

dotConnect for MySQL 8.12 is released: viewtopic.php?f=2&t=37477.

Post Reply