EF generates incorrect SQL

[CurlerRoo]

As mentioned in the closed issue #147.
That was not a question on how to use EF.
I think it was a bug. EF should not generate syntactically incorrect SQL in any case.

[roji]

@Pc-lover, I didn't say it's not a bug - if incorrect SQL gets generated it's definitely a bug.

It's just 99% not an Npgsql bug, but rather an EF Core bug. Did you open an issue with them, so that someone can take a look?

[CurlerRoo]

You're right. I've just tested using SQL Server and still got the same result. I just opened an issue in their repo: dotnet/efcore#7666.

[roji]

OK, thanks for testing. I'll close this for now - whatever fix they do in EF Core will also fix it for Npgsql. If not, we'll revisit then.