.Net 8 have problems while trying apply skip() or take() after sorting with json columns about efcore.pg HOT 6 CLOSED

@SergMarkovych could you please submit an actually runnable minimal console program? The code snippets you posted above are missing various things (ClientCustomInfo, ParentDto), and does not work out of the box. An actual minimal, runnable code sample is the most important thing when submitting a bug report.

from efcore.pg.

@roji I was trying to obfuscate the names of my objects and forgot to rename a couple of objects. I already did that, could you take another look at the problem? Please let me know if you need more information.

from efcore.pg.

@SergMarkovych please, take the time to submit the actual source code to a console program that can be copy-pasted and executed directly. Otherwise you're asking me to spend my time on guessing about your code and bring it to a runnable state.

from efcore.pg.

@roji I've included a link to the console program and would appreciate it if you took a look. Please let me know if you need more information.

from efcore.pg.

Thank you for the repro - that allowed me to see the exception and investigate this.

This no longer occurs on main, but still occurs on latest release/8.0. I bisected this to #32812, which fixes the bug and is one of the big query architecture changes done recently.

We can consider doing a patch for 8.0.3 specifically as this is a regression.

from efcore.pg.

Note that this is an EF-side bug - opened dotnet/efcore#32910 to track there, and closing this here.

from efcore.pg.