Bug. Ef Core cannot translate postgresql Array functions when used optimized EF Core Model

[megafetis]

Whe i use Optimized DbContext:
dotnet ef dbcontext optimize --context MainDbContext
Postgresql array functions cannot translate to sql:

I tried to use many funtions from documentation https://www.npgsql.org/efcore/mapping/array.html.
Works only this: String.Join(separator, array)
I use NET 8

[roji]

@megafetis please post a minimal, runnable console program that shows the problem. Screenshots of partial code snippets aren't helpful.

[megafetis]

@megafetis please post a minimal, runnable console program that shows the problem. Screenshots of partial code snippets aren't helpful.

@roji Hello, take a link to test app:
https://github.com/megafetis/NpgsqlEfCoreBugConsoleApp1

[roji]

Thanks for providing the repro, and sorry it took so long to get around to investigating this. This indeed turned out to be a real bug on the EF side - I've opened dotnet/efcore#35047 to track addressing it there.