Data too long for column 'ordinal'

Thanks, this is interesting. Can I ask how many entities are in the view?

Currently about 300. I want to build a family tree.

Can you provide some detail about your database server. I'm aware that nsw.gov.au are using v5 to model their 10k+ nodes hierarchy and haven't hit this issue

I use 10.5.25-MariaDB

Maybe the depth is the problem. The current depth (family generations) is 13.

That sounds like it would be

I wonder if we can cast it

Perhaps casting this to something longer https://git.drupalcode.org/project/entity_hierarchy/-/blob/5.x/src/Query... will be the trick

Do you expect me to do something? I don't know what to change in the given file. It is equal to the file in the current release.

Pushed something to the MR for this issue

I like to review your updates, but where can I find them? I dont use git. In https://git.drupalcode.org/project/entity_hierarchy/-/blob/5.x/src/Query... I didnt see changes.

It looks like it failed all tests anyway, so hold off