System.ArgumentOutOfRangeException: 'Index was out of range.

[achilleaskar]

Steps to reproduce

It might be quite hard to reproduce because my project is very complex

The issue

I get a very strange error In one of my queries that works perfectly in the .Net Framework version of my app (there I use MySql.Data.EntityFramework)

The query is this:

var x = await Context.Personal_Bookings
  .Where(c =>
  (completed || c.Services.Any(s => (s.Allerretour && s.TimeReturn >= DateTime.Today) || s.TimeGo >= DateTime.Today))
  .Include(f => f.Customers).ThenInclude(s => s.Services)
  .Include(f => f.User)
  .Include(f => f.Payments)
  .Include(f => f.Partner)
  .ToListAsync();

The problem occurs in (completed || c.Services.Any(s => (s.Allerretour && s.TimeReturn >= DateTime.Today) || s.TimeGo >= DateTime.Today))

I get exception System.ArgumentOutOfRangeException: 'Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index')'

If I change it to (completed || c.Services.Any(s => s.TimeReturn >= DateTime.Today || s.TimeGo >= DateTime.Today)) it works fine. The problem is in using two conditions. Any idea why this happens?

Further technical details

MySQL version:
Operating system:
Pomelo.EntityFrameworkCore.MySql version: 6.0.0

[achilleaskar]

Looks like the "Allerretour" causes the problem. It is a bool (not nullable) and in database it is type bit(1)

[mguinness]

Could be related to dotnet/efcore#26428.

[lauxjpn]

Could be related to dotnet/efcore#26428.

@achilleaskar Are you using query filters?

[achilleaskar]

No only the where you can see. I also get the same problem in other application .Net 6 at this block of code

query = query
    .Where(t=> t.ExcursionDates.Any(d=> !includeDates || d.CheckOut >= DateTime.Today))
    .OrderBy(e => e.ExcursionDates.Where(d => d.CheckIn >= DateTime.Today)
    .OrderBy(ed => ed.CheckIn).FirstOrDefault().CheckIn);

var x = await query.Select(e => new ExcursionWithDatesDto
{
    ExcursionDates = !includeDates ? new List<ExcursionDateDto>() : e.ExcursionDates
        .Where(d => d.CheckOut >= DateTime.Today).Select(d => new ExcursionDateDto
    {
        Name = d.Name,
        Id = d.Id,
        NightStart = d.NightStart,
        CheckIn = !d.NightStart ? d.CheckIn : d.CheckIn.AddDays(1), //change here
        CheckOut = d.CheckOut
    }).ToList()
}).ToListAsync();

The fourth line of the end is the fault of this error. If I change it to CheckIn = d.CheckIn it works perfectly. I will try to debug it my self and come up for more info.

[vaital3000]

Hi!
I wanted to create new issue, but may be it related problem.

I reproduce same problem(System.ArgumentOutOfRangeException : Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index')) in simple sample.

https://github.com/vaital3000/net6efMysqlProblem
https://github.com/vaital3000/net6efMysqlProblem/runs/4405172285

I faced this problem after migration to net6 with ef core 6 and Pomelo.EntityFrameworkCore.MySql 6.
An example shows that it works with 5 versions, but doesn't work with 6.

[mguinness]

@vaital3000 Could you try another database provider like SQLite or PostgreSQL to see if you have the same issue?

[achilleaskar]

I searched for hours, downloaded both efcore & pomelo repo to dig into this one and I found out that it's a known efcore 6 issue that is fixed and will be ok at 6.0.1 release of ef core. So just wait for it...

[achilleaskar]

dotnet/efcore#26821 (comment)
dotnet/efcore#26431 (comment)

[mguinness]

OK, thanks for verifying that it was related to dotnet/efcore#26428 that was previously mentioned.

[mguinness]

FYI for those impacted by this issue: EF Core 6.0.1 is now available from NuGet.